PREVIEW / etf_5min / 2022-03-04
file: by_date/etf_5min/2022/2022-03-04.parquet size: 2.1 MB rows: 99,974
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2022-03-04 04:00:00 | SPY | ETF | 431.62 | 432.96 | 431.62 | 432.41 | 19034.0 |
| 2022-03-04 04:05:00 | SPY | ETF | 432.57 | 432.64 | 432.15 | 432.15 | 9420.0 |
| 2022-03-04 04:10:00 | SPY | ETF | 432.11 | 432.31 | 432.0 | 432.12 | 9466.0 |
| 2022-03-04 04:15:00 | SPY | ETF | 432.1 | 432.11 | 431.91 | 432.06 | 7203.0 |
| 2022-03-04 04:20:00 | SPY | ETF | 432.27 | 432.27 | 431.34 | 431.76 | 43262.0 |
| 2022-03-04 04:25:00 | SPY | ETF | 432.02 | 432.54 | 432.02 | 432.54 | 665.0 |
| 2022-03-04 04:30:00 | SPY | ETF | 432.37 | 433.07 | 432.36 | 432.77 | 11298.0 |
| 2022-03-04 04:35:00 | SPY | ETF | 432.7 | 432.78 | 431.86 | 431.86 | 2800.0 |
| 2022-03-04 04:40:00 | SPY | ETF | 431.7 | 431.99 | 431.44 | 431.9 | 5277.0 |
| 2022-03-04 04:45:00 | SPY | ETF | 432.0 | 432.56 | 432.0 | 432.31 | 6221.0 |
| 2022-03-04 04:50:00 | SPY | ETF | 432.3 | 432.5 | 432.0 | 432.0 | 10005.0 |
| 2022-03-04 04:55:00 | SPY | ETF | 431.69 | 432.19 | 431.69 | 432.19 | 1619.0 |
| 2022-03-04 05:00:00 | SPY | ETF | 432.15 | 432.49 | 431.89 | 432.49 | 1000.0 |
| 2022-03-04 05:05:00 | SPY | ETF | 432.31 | 432.5 | 432.14 | 432.14 | 2850.0 |
| 2022-03-04 05:10:00 | SPY | ETF | 432.14 | 432.42 | 432.14 | 432.34 | 13299.0 |
| 2022-03-04 05:15:00 | SPY | ETF | 432.41 | 432.58 | 432.24 | 432.51 | 6000.0 |
| 2022-03-04 05:20:00 | SPY | ETF | 432.53 | 433.22 | 432.53 | 433.22 | 4894.0 |
| 2022-03-04 05:25:00 | SPY | ETF | 433.14 | 433.5 | 433.01 | 433.46 | 6110.0 |
| 2022-03-04 05:30:00 | SPY | ETF | 433.59 | 433.59 | 433.07 | 433.12 | 11153.0 |
| 2022-03-04 05:35:00 | SPY | ETF | 433.12 | 433.12 | 432.9 | 432.9 | 16171.0 |
| 2022-03-04 05:40:00 | SPY | ETF | 432.81 | 432.88 | 432.8 | 432.81 | 897.0 |
| 2022-03-04 05:45:00 | SPY | ETF | 432.5 | 432.52 | 432.42 | 432.42 | 14542.0 |
| 2022-03-04 05:50:00 | SPY | ETF | 432.57 | 432.58 | 432.01 | 432.01 | 2180.0 |
| 2022-03-04 05:55:00 | SPY | ETF | 432.01 | 432.34 | 431.95 | 432.0 | 1470.0 |
| 2022-03-04 06:00:00 | SPY | ETF | 432.04 | 432.05 | 431.64 | 432.05 | 15699.0 |
| 2022-03-04 06:05:00 | SPY | ETF | 432.05 | 432.23 | 431.99 | 432.23 | 9050.0 |
| 2022-03-04 06:10:00 | SPY | ETF | 432.2 | 432.29 | 431.79 | 431.79 | 8477.0 |
| 2022-03-04 06:15:00 | SPY | ETF | 431.81 | 431.83 | 431.45 | 431.45 | 12476.0 |
| 2022-03-04 06:20:00 | SPY | ETF | 431.57 | 432.08 | 431.39 | 432.08 | 8335.0 |
| 2022-03-04 06:25:00 | SPY | ETF | 432.15 | 432.15 | 432.05 | 432.05 | 510.0 |
| 2022-03-04 06:30:00 | SPY | ETF | 432.25 | 432.41 | 432.02 | 432.13 | 5900.0 |
| 2022-03-04 06:35:00 | SPY | ETF | 432.4 | 432.4 | 431.9 | 431.9 | 6675.0 |
| 2022-03-04 06:40:00 | SPY | ETF | 431.87 | 432.23 | 431.87 | 432.0 | 30100.0 |
| 2022-03-04 06:45:00 | SPY | ETF | 431.97 | 432.34 | 431.97 | 432.18 | 6950.0 |
| 2022-03-04 06:50:00 | SPY | ETF | 432.15 | 432.6 | 431.95 | 432.56 | 10075.0 |
| 2022-03-04 06:55:00 | SPY | ETF | 432.58 | 432.58 | 431.93 | 431.94 | 3810.0 |
| 2022-03-04 07:00:00 | SPY | ETF | 432.12 | 432.3 | 431.88 | 432.28 | 19596.0 |
| 2022-03-04 07:05:00 | SPY | ETF | 432.22 | 432.25 | 431.5 | 431.5 | 17078.0 |
| 2022-03-04 07:10:00 | SPY | ETF | 431.43 | 431.51 | 431.03 | 431.15 | 36706.0 |
| 2022-03-04 07:15:00 | SPY | ETF | 431.1 | 431.78 | 431.1 | 431.78 | 15618.0 |
| 2022-03-04 07:20:00 | SPY | ETF | 431.71 | 431.79 | 431.3 | 431.36 | 23965.0 |
| 2022-03-04 07:25:00 | SPY | ETF | 431.35 | 431.37 | 430.74 | 430.81 | 31067.0 |
| 2022-03-04 07:30:00 | SPY | ETF | 430.79 | 431.08 | 430.78 | 430.83 | 16275.0 |
| 2022-03-04 07:35:00 | SPY | ETF | 430.81 | 431.56 | 430.81 | 431.53 | 15797.0 |
| 2022-03-04 07:40:00 | SPY | ETF | 431.59 | 431.83 | 431.43 | 431.83 | 65544.0 |
| 2022-03-04 07:45:00 | SPY | ETF | 431.89 | 432.49 | 431.89 | 432.08 | 37237.0 |
| 2022-03-04 07:50:00 | SPY | ETF | 432.14 | 432.16 | 431.5 | 431.78 | 33758.0 |
| 2022-03-04 07:55:00 | SPY | ETF | 432.01 | 432.27 | 431.83 | 432.2 | 23488.0 |
| 2022-03-04 08:00:00 | SPY | ETF | 431.7099 | 436.096 | 430.76 | 432.1796 | 185863.0 |
| 2022-03-04 08:05:00 | SPY | ETF | 432.24 | 432.57 | 432.08 | 432.11 | 40258.0 |
> showing 50 of 99,974 rows — these rows as CSV