---
date: 2026-02-08 17:46:32
tags: WRDS, FFIEC
category: Banks, Call Reports
---

# Chart: Total Cash by Banks
Total Cash by Banks from 2021-12-31 to 2023-12-31

## Chart
```{raw} html
<iframe src="../_static/P0/total_cash.html" height="500px" width="100%"></iframe>

<p style="text-align: center;">Sources: WRDS, FFIEC</p>
```
[Full Screen Chart](../download_chart/P0/total_cash.html)





## Description

This is an exploratory chart from the RCFD Series 1 data on WRDS. It shows total cash in banks over time


## Chart Specs

| Chart Name             | Total Cash by Banks                                             |
|------------------------|------------------------------------------------------------|
| Chart ID               | total_cash                                               |
| Topic Tags             | Banks, Call Reports                                |
| Data Series Start Date | 1/31/2012                                 |
| Data Frequency         |                                          |
| Observation Period     |                                      |
| Lag in Data Release    |                                     |
| Data Release Timing    |                                     |
| Seasonal Adjustment    |                                     |
| Units                  | dollars                                                  |
| HTML Chart             | [HTML](../download_chart/P0/total_cash.html)    |


## Dataframe Manifest

| Dataframe Name                 | FFEIC Call Report Data                                                   |
|--------------------------------|--------------------------------------------------------------------------------------|
| Dataframe ID                   | [RCFD_Series_1](../dataframes/P0/RCFD_Series_1.md)                                       |
| Data Sources                   | WRDS, FFIEC                                        |
| Data Providers                 | WRDS, FFIEC                                      |
| Links to Providers             |                              |
| Topic Tags                     | Banks, Call Reports                                          |
| Type of Data Access            |                                   |
| How is data pulled?            | WRDS Web API via Python                                                    |
| Data available up to (min)     |                                                              |
| Data available up to (max)     |                                                              |
| Dataframe Path                 | /Users/joewang/Desktop/MSFM Courses/FINM32900 - Full Stack Quantitative Finance/p08_jiang_et_al_2024/_data/RCFD_Series_1.parquet                                                   |


**Linked Charts:**


- [P0:total_cash](../../charts/P0.total_cash.md)



## Pipeline Manifest

| Pipeline Name                   | Monetary Tightening and US Bank Fragility                       |
|---------------------------------|--------------------------------------------------------|
| Pipeline ID                     | [P0](../index.md)              |
| Lead Pipeline Developer         | Summer Han, Joe Wang             |
| Contributors                    | Summer Han, Joe Wang           |
| Git Repo URL                    |                         |
| Pipeline Web Page               | <a href="file:///Users/joewang/Desktop/MSFM Courses/FINM32900 - Full Stack Quantitative Finance/p08_jiang_et_al_2024/docs/index.html">Pipeline Web Page      |
| Date of Last Code Update        | 2026-02-08 17:46:32           |
| OS Compatibility                |  |
| Linked Dataframes               |  [P0:RCFD_Series_1](../dataframes/P0/RCFD_Series_1.md)<br>  |