PREVIEW / etf_5min / 2024-10-08
file: by_date/etf_5min/2024/2024-10-08.parquet size: 2.4 MB rows: 116,346
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 |
|---|---|---|---|---|---|---|---|
| 2024-10-08 04:00:00 | SPY | ETF | 568.09 | 568.28 | 567.99 | 568.17 | 4193.0 |
| 2024-10-08 04:05:00 | SPY | ETF | 568.0 | 568.13 | 567.86 | 567.92 | 1489.0 |
| 2024-10-08 04:10:00 | SPY | ETF | 568.0 | 568.1 | 567.87 | 567.92 | 1953.0 |
| 2024-10-08 04:15:00 | SPY | ETF | 568.28 | 568.28 | 568.28 | 568.28 | 184.0 |
| 2024-10-08 04:20:00 | SPY | ETF | 568.41 | 568.41 | 567.92 | 567.92 | 1909.0 |
| 2024-10-08 04:25:00 | SPY | ETF | 568.0 | 568.15 | 567.96 | 567.96 | 1134.0 |
| 2024-10-08 04:30:00 | SPY | ETF | 567.9 | 567.9 | 567.85 | 567.9 | 787.0 |
| 2024-10-08 04:35:00 | SPY | ETF | 568.3 | 568.3 | 568.26 | 568.26 | 563.0 |
| 2024-10-08 04:45:00 | SPY | ETF | 568.3 | 568.48 | 568.3 | 568.35 | 788.0 |
| 2024-10-08 04:50:00 | SPY | ETF | 568.27 | 568.49 | 568.27 | 568.46 | 4549.0 |
| 2024-10-08 04:55:00 | SPY | ETF | 568.5 | 568.54 | 568.41 | 568.48 | 1400.0 |
| 2024-10-08 05:00:00 | SPY | ETF | 568.55 | 569.1 | 568.55 | 569.1 | 2016.0 |
| 2024-10-08 05:05:00 | SPY | ETF | 569.11 | 569.2 | 569.08 | 569.11 | 3704.0 |
| 2024-10-08 05:10:00 | SPY | ETF | 568.94 | 568.94 | 568.94 | 568.94 | 265.0 |
| 2024-10-08 05:15:00 | SPY | ETF | 569.22 | 569.73 | 569.22 | 569.53 | 5817.0 |
| 2024-10-08 05:20:00 | SPY | ETF | 569.47 | 569.61 | 569.47 | 569.6 | 2220.0 |
| 2024-10-08 05:25:00 | SPY | ETF | 569.71 | 569.82 | 569.71 | 569.74 | 1300.0 |
| 2024-10-08 05:30:00 | SPY | ETF | 569.88 | 569.88 | 569.66 | 569.66 | 1300.0 |
| 2024-10-08 05:35:00 | SPY | ETF | 569.71 | 569.71 | 569.63 | 569.63 | 2392.0 |
| 2024-10-08 05:40:00 | SPY | ETF | 569.61 | 569.8 | 569.58 | 569.8 | 7220.0 |
| 2024-10-08 05:45:00 | SPY | ETF | 569.91 | 569.91 | 569.66 | 569.69 | 3111.0 |
| 2024-10-08 05:50:00 | SPY | ETF | 569.8 | 569.8 | 569.8 | 569.8 | 616.0 |
| 2024-10-08 05:55:00 | SPY | ETF | 569.86 | 569.88 | 569.71 | 569.71 | 2150.0 |
| 2024-10-08 06:00:00 | SPY | ETF | 569.8 | 569.8 | 569.8 | 569.8 | 3324.0 |
| 2024-10-08 06:05:00 | SPY | ETF | 569.85 | 569.9 | 569.85 | 569.9 | 3231.0 |
| 2024-10-08 06:10:00 | SPY | ETF | 569.87 | 570.07 | 569.87 | 569.98 | 3081.0 |
| 2024-10-08 06:15:00 | SPY | ETF | 569.88 | 569.91 | 569.8 | 569.87 | 10893.0 |
| 2024-10-08 06:20:00 | SPY | ETF | 569.81 | 569.81 | 569.7 | 569.7 | 400.0 |
| 2024-10-08 06:25:00 | SPY | ETF | 569.81 | 569.81 | 569.81 | 569.81 | 458.0 |
| 2024-10-08 06:30:00 | SPY | ETF | 569.89 | 569.89 | 569.41 | 569.42 | 1754.0 |
| 2024-10-08 06:35:00 | SPY | ETF | 569.47 | 569.48 | 569.44 | 569.44 | 717.0 |
| 2024-10-08 06:40:00 | SPY | ETF | 569.31 | 569.31 | 569.31 | 569.31 | 200.0 |
| 2024-10-08 06:45:00 | SPY | ETF | 569.53 | 569.72 | 569.48 | 569.7 | 1987.0 |
| 2024-10-08 06:50:00 | SPY | ETF | 569.8 | 569.93 | 569.8 | 569.93 | 8376.0 |
| 2024-10-08 06:55:00 | SPY | ETF | 569.93 | 570.05 | 569.86 | 570.05 | 15948.0 |
| 2024-10-08 07:00:00 | SPY | ETF | 570.05 | 570.05 | 569.74 | 570.0 | 39748.0 |
| 2024-10-08 07:05:00 | SPY | ETF | 569.98 | 570.03 | 569.96 | 569.96 | 7620.0 |
| 2024-10-08 07:10:00 | SPY | ETF | 569.89 | 569.89 | 569.64 | 569.66 | 51885.0 |
| 2024-10-08 07:15:00 | SPY | ETF | 569.65 | 569.85 | 569.62 | 569.84 | 9061.0 |
| 2024-10-08 07:20:00 | SPY | ETF | 569.85 | 569.95 | 569.6 | 569.67 | 75212.0 |
| 2024-10-08 07:25:00 | SPY | ETF | 569.76 | 570.01 | 569.7 | 569.88 | 60959.0 |
| 2024-10-08 07:30:00 | SPY | ETF | 569.9 | 570.24 | 569.9 | 570.16 | 58568.0 |
| 2024-10-08 07:35:00 | SPY | ETF | 570.17 | 570.17 | 569.95 | 569.95 | 38784.0 |
| 2024-10-08 07:40:00 | SPY | ETF | 569.88 | 570.0 | 569.88 | 569.9 | 1211.0 |
| 2024-10-08 07:45:00 | SPY | ETF | 569.95 | 570.01 | 569.79 | 570.01 | 2317.0 |
| 2024-10-08 07:50:00 | SPY | ETF | 570.03 | 570.05 | 569.94 | 570.02 | 11531.0 |
| 2024-10-08 07:55:00 | SPY | ETF | 570.02 | 570.09 | 569.98 | 569.98 | 5412.0 |
| 2024-10-08 08:00:00 | SPY | ETF | 569.62 | 570.15 | 567.07 | 570.1 | 92089.0 |
| 2024-10-08 08:05:00 | SPY | ETF | 569.97 | 570.0 | 569.7715 | 569.7715 | 6876.0 |
| 2024-10-08 08:10:00 | SPY | ETF | 569.8 | 569.82 | 569.57 | 569.73 | 26247.0 |
> showing 50 of 116,346 rows — these rows as CSV