Skip to content

mito-ds/snowflake-streamlit-bank-performance-demo

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

8 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Compare the world's largest banks

This streamlit app helps you compare important metrics, like Total Desposits, amongst the world's largest banks.

The app pulls data from Snowflake and uses the Mito spreadsheet for Streamlit to display it to the user. The user can further analyze the data using the spreadsheet and pre-made graphs.

Alt text

Mito Streamlit Package

To learn more about creating Streamlit applications using the Mito spreadsheet, checkout the docs here

The Data

This app is connected to a Snowflake database that contains financial and economic data aggregated by Cybersyn from the following sources: FDIC, FFIEC, FRED, BLS, CFPB, Bank of England, Bank of International Settlements, Bank of Canada, Banco de Mexico, and Banco Central do Brasil.

Run Locally

  1. Set up your data by creating a Snowflake account and then creating a database with this data. Its free!

  2. Create a virtual environment:

python3 -m venv venv
  1. Start the virtual environment:
source venv/bin/activate
  1. Install the required python packages:
pip install -r requirements.txt
  1. Create a file .streamlit/secrets.toml in the root folder with the following format:
[snowflake]
account = "xxx"
user = "xxx"
password = "xxx"
  1. Start the streamlit app
streamlit run main.py

Releases

No releases published

Packages

No packages published

Languages