PREVIEW / etf_5min / 2024-10-22
file: by_date/etf_5min/2024/2024-10-22.parquet size: 2.4 MB rows: 116,180
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-22 04:00:00 | SPY | ETF | 582.78 | 582.78 | 582.18 | 582.18 | 5926.0 |
| 2024-10-22 04:05:00 | SPY | ETF | 582.17 | 582.25 | 582.17 | 582.25 | 560.0 |
| 2024-10-22 04:10:00 | SPY | ETF | 582.41 | 582.48 | 582.35 | 582.45 | 2159.0 |
| 2024-10-22 04:15:00 | SPY | ETF | 582.52 | 582.53 | 582.4 | 582.46 | 5159.0 |
| 2024-10-22 04:20:00 | SPY | ETF | 582.51 | 582.51 | 582.51 | 582.51 | 300.0 |
| 2024-10-22 04:25:00 | SPY | ETF | 582.31 | 582.31 | 582.31 | 582.31 | 100.0 |
| 2024-10-22 04:30:00 | SPY | ETF | 582.25 | 582.25 | 581.84 | 581.84 | 1832.0 |
| 2024-10-22 04:35:00 | SPY | ETF | 581.72 | 581.86 | 581.72 | 581.86 | 700.0 |
| 2024-10-22 04:40:00 | SPY | ETF | 581.88 | 581.88 | 581.88 | 581.88 | 114.0 |
| 2024-10-22 04:45:00 | SPY | ETF | 582.29 | 582.29 | 582.29 | 582.29 | 100.0 |
| 2024-10-22 05:00:00 | SPY | ETF | 581.65 | 581.65 | 581.53 | 581.64 | 6235.0 |
| 2024-10-22 05:05:00 | SPY | ETF | 581.64 | 581.74 | 581.64 | 581.68 | 451.0 |
| 2024-10-22 05:10:00 | SPY | ETF | 581.5 | 581.53 | 581.5 | 581.53 | 809.0 |
| 2024-10-22 05:15:00 | SPY | ETF | 581.44 | 581.44 | 581.21 | 581.23 | 2429.0 |
| 2024-10-22 05:20:00 | SPY | ETF | 581.27 | 581.27 | 580.91 | 581.03 | 7944.0 |
| 2024-10-22 05:25:00 | SPY | ETF | 581.0 | 581.05 | 580.94 | 580.97 | 8307.0 |
| 2024-10-22 05:30:00 | SPY | ETF | 580.99 | 581.21 | 580.99 | 581.14 | 4294.0 |
| 2024-10-22 05:35:00 | SPY | ETF | 581.28 | 581.44 | 581.28 | 581.31 | 5513.0 |
| 2024-10-22 05:40:00 | SPY | ETF | 581.28 | 581.28 | 580.91 | 580.91 | 2762.0 |
| 2024-10-22 05:45:00 | SPY | ETF | 581.02 | 581.02 | 580.56 | 580.69 | 8416.0 |
| 2024-10-22 05:50:00 | SPY | ETF | 580.81 | 580.84 | 580.63 | 580.72 | 1100.0 |
| 2024-10-22 05:55:00 | SPY | ETF | 580.71 | 580.76 | 580.69 | 580.76 | 1670.0 |
| 2024-10-22 06:00:00 | SPY | ETF | 580.77 | 580.78 | 580.7 | 580.78 | 2128.0 |
| 2024-10-22 06:05:00 | SPY | ETF | 580.63 | 580.99 | 580.63 | 580.99 | 1402.0 |
| 2024-10-22 06:10:00 | SPY | ETF | 581.1 | 581.29 | 581.1 | 581.29 | 2283.0 |
| 2024-10-22 06:15:00 | SPY | ETF | 581.2 | 581.2 | 581.14 | 581.18 | 766.0 |
| 2024-10-22 06:20:00 | SPY | ETF | 581.23 | 581.23 | 581.17 | 581.17 | 524.0 |
| 2024-10-22 06:25:00 | SPY | ETF | 580.97 | 581.01 | 580.97 | 581.01 | 672.0 |
| 2024-10-22 06:30:00 | SPY | ETF | 581.0 | 581.21 | 580.94 | 580.97 | 11439.0 |
| 2024-10-22 06:35:00 | SPY | ETF | 580.87 | 580.87 | 580.82 | 580.82 | 2500.0 |
| 2024-10-22 06:40:00 | SPY | ETF | 580.84 | 580.84 | 580.76 | 580.82 | 6060.0 |
| 2024-10-22 06:45:00 | SPY | ETF | 581.01 | 581.05 | 580.98 | 580.98 | 4162.0 |
| 2024-10-22 06:50:00 | SPY | ETF | 580.93 | 580.93 | 580.75 | 580.76 | 3507.0 |
| 2024-10-22 06:55:00 | SPY | ETF | 580.78 | 580.88 | 580.64 | 580.88 | 12379.0 |
| 2024-10-22 07:00:00 | SPY | ETF | 580.9 | 581.2 | 580.88 | 581.07 | 8726.0 |
| 2024-10-22 07:05:00 | SPY | ETF | 581.14 | 581.14 | 580.95 | 581.04 | 3737.0 |
| 2024-10-22 07:10:00 | SPY | ETF | 580.97 | 581.15 | 580.95 | 581.04 | 1578.0 |
| 2024-10-22 07:15:00 | SPY | ETF | 581.01 | 581.19 | 581.01 | 581.19 | 42046.0 |
| 2024-10-22 07:20:00 | SPY | ETF | 581.19 | 581.42 | 581.19 | 581.39 | 30148.0 |
| 2024-10-22 07:25:00 | SPY | ETF | 581.4 | 581.49 | 581.39 | 581.39 | 9095.0 |
| 2024-10-22 07:30:00 | SPY | ETF | 581.38 | 581.44 | 581.33 | 581.33 | 922.0 |
| 2024-10-22 07:35:00 | SPY | ETF | 581.36 | 581.45 | 581.36 | 581.42 | 2436.0 |
| 2024-10-22 07:40:00 | SPY | ETF | 581.43 | 581.46 | 581.1 | 581.1 | 6655.0 |
| 2024-10-22 07:45:00 | SPY | ETF | 581.14 | 581.16 | 580.95 | 580.99 | 18078.0 |
| 2024-10-22 07:50:00 | SPY | ETF | 581.01 | 581.1 | 580.89 | 581.1 | 13767.0 |
| 2024-10-22 07:55:00 | SPY | ETF | 581.19 | 581.28 | 581.07 | 581.12 | 4079.0 |
| 2024-10-22 08:00:00 | SPY | ETF | 580.97 | 582.89 | 580.7596 | 581.38 | 44883.0 |
| 2024-10-22 08:05:00 | SPY | ETF | 581.38 | 581.76 | 581.37 | 581.67 | 12732.0 |
| 2024-10-22 08:10:00 | SPY | ETF | 581.74 | 581.74 | 581.5 | 581.62 | 9060.0 |
| 2024-10-22 08:15:00 | SPY | ETF | 581.6 | 581.79 | 581.53 | 581.57 | 21708.0 |
> showing 50 of 116,180 rows — these rows as CSV