PREVIEW / etf_5min / 2024-10-25
file: by_date/etf_5min/2024/2024-10-25.parquet size: 2.3 MB rows: 113,470
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-25 04:00:00 | SPY | ETF | 580.1 | 580.55 | 580.1 | 580.34 | 2100.0 |
| 2024-10-25 04:05:00 | SPY | ETF | 580.2 | 580.24 | 580.01 | 580.16 | 3100.0 |
| 2024-10-25 04:10:00 | SPY | ETF | 580.15 | 580.2 | 580.1 | 580.13 | 4620.0 |
| 2024-10-25 04:15:00 | SPY | ETF | 580.11 | 580.16 | 579.85 | 580.16 | 936.0 |
| 2024-10-25 04:20:00 | SPY | ETF | 580.16 | 580.2 | 580.16 | 580.2 | 661.0 |
| 2024-10-25 04:30:00 | SPY | ETF | 580.1 | 580.3 | 580.1 | 580.3 | 943.0 |
| 2024-10-25 04:35:00 | SPY | ETF | 580.27 | 580.27 | 580.26 | 580.26 | 555.0 |
| 2024-10-25 04:40:00 | SPY | ETF | 580.2 | 580.2 | 580.2 | 580.2 | 100.0 |
| 2024-10-25 05:00:00 | SPY | ETF | 580.42 | 580.51 | 580.42 | 580.51 | 1098.0 |
| 2024-10-25 05:05:00 | SPY | ETF | 580.5 | 580.6 | 580.42 | 580.6 | 405.0 |
| 2024-10-25 05:10:00 | SPY | ETF | 580.55 | 580.7 | 580.52 | 580.7 | 763.0 |
| 2024-10-25 05:15:00 | SPY | ETF | 580.87 | 580.87 | 580.87 | 580.87 | 300.0 |
| 2024-10-25 05:25:00 | SPY | ETF | 580.95 | 580.98 | 580.93 | 580.93 | 3620.0 |
| 2024-10-25 05:30:00 | SPY | ETF | 580.9 | 580.9 | 580.76 | 580.77 | 3267.0 |
| 2024-10-25 05:45:00 | SPY | ETF | 580.77 | 580.77 | 580.73 | 580.73 | 612.0 |
| 2024-10-25 05:50:00 | SPY | ETF | 580.78 | 580.78 | 580.78 | 580.78 | 500.0 |
| 2024-10-25 05:55:00 | SPY | ETF | 580.72 | 580.79 | 580.67 | 580.79 | 1454.0 |
| 2024-10-25 06:00:00 | SPY | ETF | 580.85 | 580.85 | 580.84 | 580.84 | 600.0 |
| 2024-10-25 06:05:00 | SPY | ETF | 580.96 | 580.96 | 580.94 | 580.94 | 1657.0 |
| 2024-10-25 06:10:00 | SPY | ETF | 580.97 | 580.98 | 580.9 | 580.9 | 950.0 |
| 2024-10-25 06:15:00 | SPY | ETF | 580.9 | 580.9 | 580.88 | 580.88 | 651.0 |
| 2024-10-25 06:20:00 | SPY | ETF | 580.94 | 580.94 | 580.89 | 580.89 | 574.0 |
| 2024-10-25 06:25:00 | SPY | ETF | 581.0 | 581.02 | 581.0 | 581.02 | 2168.0 |
| 2024-10-25 06:30:00 | SPY | ETF | 580.98 | 581.06 | 580.92 | 580.92 | 6565.0 |
| 2024-10-25 06:35:00 | SPY | ETF | 580.9 | 580.98 | 580.9 | 580.94 | 5300.0 |
| 2024-10-25 06:45:00 | SPY | ETF | 580.94 | 580.94 | 580.94 | 580.94 | 387.0 |
| 2024-10-25 06:50:00 | SPY | ETF | 581.02 | 581.03 | 580.92 | 580.92 | 697.0 |
| 2024-10-25 06:55:00 | SPY | ETF | 580.89 | 580.89 | 580.7 | 580.7 | 500.0 |
| 2024-10-25 07:00:00 | SPY | ETF | 580.67 | 580.72 | 580.19 | 580.48 | 84699.0 |
| 2024-10-25 07:05:00 | SPY | ETF | 580.44 | 580.47 | 580.36 | 580.39 | 5955.0 |
| 2024-10-25 07:10:00 | SPY | ETF | 580.4 | 580.52 | 580.4 | 580.52 | 625.0 |
| 2024-10-25 07:15:00 | SPY | ETF | 580.56 | 580.68 | 580.51 | 580.56 | 5293.0 |
| 2024-10-25 07:20:00 | SPY | ETF | 580.51 | 580.51 | 580.51 | 580.51 | 100.0 |
| 2024-10-25 07:25:00 | SPY | ETF | 580.61 | 580.71 | 580.61 | 580.63 | 2469.0 |
| 2024-10-25 07:30:00 | SPY | ETF | 580.66 | 580.74 | 580.66 | 580.74 | 585.0 |
| 2024-10-25 07:35:00 | SPY | ETF | 580.74 | 580.8 | 580.72 | 580.8 | 5832.0 |
| 2024-10-25 07:40:00 | SPY | ETF | 580.829 | 580.9 | 580.829 | 580.9 | 1287.0 |
| 2024-10-25 07:45:00 | SPY | ETF | 580.99 | 581.2 | 580.98 | 581.0 | 6005.0 |
| 2024-10-25 07:50:00 | SPY | ETF | 581.0 | 581.09 | 580.85 | 581.09 | 33030.0 |
| 2024-10-25 07:55:00 | SPY | ETF | 581.06 | 581.06 | 580.97 | 581.01 | 14418.0 |
| 2024-10-25 08:00:00 | SPY | ETF | 580.99 | 581.14 | 578.99 | 581.08 | 18446.0 |
| 2024-10-25 08:05:00 | SPY | ETF | 581.08 | 581.39 | 581.07 | 581.341 | 15840.0 |
| 2024-10-25 08:10:00 | SPY | ETF | 581.33 | 581.33 | 581.2 | 581.32 | 9173.0 |
| 2024-10-25 08:15:00 | SPY | ETF | 581.31 | 581.32 | 581.13 | 581.16 | 3387.0 |
| 2024-10-25 08:20:00 | SPY | ETF | 581.13 | 581.17 | 581.1 | 581.1 | 8504.0 |
| 2024-10-25 08:25:00 | SPY | ETF | 581.19 | 581.21 | 581.1 | 581.16 | 19220.0 |
| 2024-10-25 08:30:00 | SPY | ETF | 581.07 | 581.19 | 581.05 | 581.09 | 3534.0 |
| 2024-10-25 08:35:00 | SPY | ETF | 581.1 | 581.35 | 581.1 | 581.29 | 11918.0 |
| 2024-10-25 08:40:00 | SPY | ETF | 581.31 | 581.49 | 581.31 | 581.45 | 15296.0 |
| 2024-10-25 08:45:00 | SPY | ETF | 581.47 | 581.63 | 581.47 | 581.55 | 12649.0 |
> showing 50 of 113,470 rows — these rows as CSV