PREVIEW / etf_5min / 2024-12-20
file: by_date/etf_5min/2024/2024-12-20.parquet size: 2.8 MB rows: 139,910
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-12-20 04:00:00 | SPY | ETF | 581.98 | 581.98 | 580.5 | 580.5 | 12907.0 |
| 2024-12-20 04:05:00 | SPY | ETF | 580.5 | 580.56 | 579.63 | 580.11 | 25581.0 |
| 2024-12-20 04:10:00 | SPY | ETF | 580.2 | 580.48 | 580.0 | 580.28 | 10889.0 |
| 2024-12-20 04:15:00 | SPY | ETF | 580.16 | 580.42 | 580.09 | 580.42 | 6670.0 |
| 2024-12-20 04:20:00 | SPY | ETF | 580.56 | 580.56 | 580.05 | 580.05 | 1681.0 |
| 2024-12-20 04:25:00 | SPY | ETF | 580.13 | 580.13 | 579.83 | 579.97 | 5844.0 |
| 2024-12-20 04:30:00 | SPY | ETF | 580.16 | 580.41 | 580.03 | 580.3 | 3430.0 |
| 2024-12-20 04:35:00 | SPY | ETF | 580.23 | 580.23 | 579.96 | 579.97 | 4806.0 |
| 2024-12-20 04:40:00 | SPY | ETF | 579.9 | 579.9 | 579.61 | 579.61 | 1717.0 |
| 2024-12-20 04:45:00 | SPY | ETF | 579.56 | 579.71 | 579.56 | 579.59 | 2830.0 |
| 2024-12-20 04:50:00 | SPY | ETF | 579.45 | 579.71 | 579.45 | 579.71 | 3096.0 |
| 2024-12-20 04:55:00 | SPY | ETF | 579.57 | 579.83 | 579.57 | 579.67 | 3937.0 |
| 2024-12-20 05:00:00 | SPY | ETF | 579.8 | 580.08 | 579.8 | 579.96 | 2218.0 |
| 2024-12-20 05:05:00 | SPY | ETF | 579.97 | 580.02 | 579.77 | 579.77 | 979.0 |
| 2024-12-20 05:10:00 | SPY | ETF | 579.8 | 579.8 | 579.16 | 579.16 | 600.0 |
| 2024-12-20 05:15:00 | SPY | ETF | 579.4 | 579.53 | 579.27 | 579.3 | 8089.0 |
| 2024-12-20 05:20:00 | SPY | ETF | 579.19 | 579.51 | 579.14 | 579.34 | 9100.0 |
| 2024-12-20 05:25:00 | SPY | ETF | 579.59 | 579.66 | 579.55 | 579.57 | 6371.0 |
| 2024-12-20 05:30:00 | SPY | ETF | 579.59 | 579.74 | 579.59 | 579.68 | 2390.0 |
| 2024-12-20 05:35:00 | SPY | ETF | 579.72 | 579.75 | 579.27 | 579.27 | 15810.0 |
| 2024-12-20 05:40:00 | SPY | ETF | 579.53 | 579.96 | 579.44 | 579.69 | 3538.0 |
| 2024-12-20 05:45:00 | SPY | ETF | 579.59 | 580.04 | 579.49 | 580.04 | 5961.0 |
| 2024-12-20 05:50:00 | SPY | ETF | 579.89 | 580.14 | 579.89 | 580.14 | 8129.0 |
| 2024-12-20 05:55:00 | SPY | ETF | 580.3 | 580.3 | 579.86 | 579.92 | 3216.0 |
| 2024-12-20 06:00:00 | SPY | ETF | 579.98 | 580.08 | 579.77 | 579.77 | 1798.0 |
| 2024-12-20 06:05:00 | SPY | ETF | 579.77 | 580.07 | 579.77 | 580.07 | 2663.0 |
| 2024-12-20 06:10:00 | SPY | ETF | 580.08 | 580.47 | 579.87 | 580.18 | 13923.0 |
| 2024-12-20 06:15:00 | SPY | ETF | 580.18 | 580.23 | 580.03 | 580.09 | 4688.0 |
| 2024-12-20 06:20:00 | SPY | ETF | 580.0 | 580.1 | 579.71 | 579.81 | 5456.0 |
| 2024-12-20 06:25:00 | SPY | ETF | 579.82 | 579.95 | 579.82 | 579.95 | 3399.0 |
| 2024-12-20 06:30:00 | SPY | ETF | 579.89 | 580.09 | 579.89 | 580.0 | 1525.0 |
| 2024-12-20 06:35:00 | SPY | ETF | 579.89 | 579.89 | 579.67 | 579.85 | 12554.0 |
| 2024-12-20 06:40:00 | SPY | ETF | 579.79 | 579.83 | 579.6 | 579.6 | 13993.0 |
| 2024-12-20 06:45:00 | SPY | ETF | 579.56 | 579.59 | 579.32 | 579.52 | 33032.0 |
| 2024-12-20 06:50:00 | SPY | ETF | 579.42 | 579.48 | 579.24 | 579.32 | 7716.0 |
| 2024-12-20 06:55:00 | SPY | ETF | 579.32 | 579.58 | 579.32 | 579.42 | 10463.0 |
| 2024-12-20 07:00:00 | SPY | ETF | 579.4 | 579.55 | 578.72 | 579.01 | 15597.0 |
| 2024-12-20 07:05:00 | SPY | ETF | 579.02 | 579.2 | 578.66 | 578.76 | 33855.0 |
| 2024-12-20 07:10:00 | SPY | ETF | 578.74 | 578.8 | 578.4 | 578.44 | 28170.0 |
| 2024-12-20 07:15:00 | SPY | ETF | 578.5 | 578.72 | 578.06 | 578.21 | 52960.0 |
| 2024-12-20 07:20:00 | SPY | ETF | 578.15 | 578.36 | 577.76 | 577.78 | 32680.0 |
| 2024-12-20 07:25:00 | SPY | ETF | 577.76 | 578.07 | 577.74 | 578.0 | 35758.0 |
| 2024-12-20 07:30:00 | SPY | ETF | 577.94 | 578.49 | 577.81 | 578.36 | 34227.0 |
| 2024-12-20 07:35:00 | SPY | ETF | 578.29 | 578.65 | 578.27 | 578.58 | 19220.0 |
| 2024-12-20 07:40:00 | SPY | ETF | 578.58 | 579.44 | 578.57 | 579.43 | 57230.0 |
| 2024-12-20 07:45:00 | SPY | ETF | 579.43 | 579.68 | 579.07 | 579.28 | 83326.0 |
| 2024-12-20 07:50:00 | SPY | ETF | 579.29 | 579.29 | 579.0 | 579.26 | 54961.0 |
| 2024-12-20 07:55:00 | SPY | ETF | 579.18 | 579.67 | 579.18 | 579.59 | 10171.0 |
| 2024-12-20 08:00:00 | SPY | ETF | 579.36 | 583.82 | 577.7494 | 579.8 | 131308.0 |
| 2024-12-20 08:05:00 | SPY | ETF | 579.681 | 579.69 | 579.2 | 579.39 | 13829.0 |
> showing 50 of 139,910 rows — these rows as CSV