PREVIEW / etf_5min / 2023-10-10
file: by_date/etf_5min/2023/2023-10-10.parquet size: 2.0 MB rows: 98,727
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 |
|---|---|---|---|---|---|---|---|
| 2023-10-10 04:00:00 | SPY | ETF | 432.64 | 432.76 | 432.44 | 432.48 | 3746.0 |
| 2023-10-10 04:05:00 | SPY | ETF | 432.45 | 432.64 | 432.38 | 432.39 | 2845.0 |
| 2023-10-10 04:10:00 | SPY | ETF | 432.32 | 433.0 | 432.32 | 432.66 | 13227.0 |
| 2023-10-10 04:15:00 | SPY | ETF | 432.77 | 432.93 | 432.5 | 432.54 | 2763.0 |
| 2023-10-10 04:20:00 | SPY | ETF | 432.62 | 433.0 | 432.62 | 433.0 | 8117.0 |
| 2023-10-10 04:25:00 | SPY | ETF | 433.08 | 433.25 | 433.08 | 433.12 | 13710.0 |
| 2023-10-10 04:30:00 | SPY | ETF | 433.21 | 433.28 | 433.02 | 433.15 | 10767.0 |
| 2023-10-10 04:35:00 | SPY | ETF | 433.11 | 433.24 | 433.11 | 433.22 | 1600.0 |
| 2023-10-10 04:40:00 | SPY | ETF | 433.08 | 433.08 | 432.94 | 432.99 | 11542.0 |
| 2023-10-10 04:45:00 | SPY | ETF | 432.99 | 433.22 | 432.99 | 433.2 | 1741.0 |
| 2023-10-10 04:50:00 | SPY | ETF | 433.23 | 433.36 | 433.23 | 433.35 | 1198.0 |
| 2023-10-10 04:55:00 | SPY | ETF | 433.43 | 433.43 | 433.26 | 433.32 | 5138.0 |
| 2023-10-10 05:00:00 | SPY | ETF | 433.34 | 433.34 | 432.94 | 432.99 | 4165.0 |
| 2023-10-10 05:05:00 | SPY | ETF | 433.03 | 433.1 | 432.9 | 432.91 | 5819.0 |
| 2023-10-10 05:10:00 | SPY | ETF | 433.08 | 433.1 | 432.87 | 432.87 | 15091.0 |
| 2023-10-10 05:15:00 | SPY | ETF | 432.87 | 433.08 | 432.87 | 433.08 | 750.0 |
| 2023-10-10 05:20:00 | SPY | ETF | 433.08 | 433.22 | 433.06 | 433.22 | 2015.0 |
| 2023-10-10 05:25:00 | SPY | ETF | 433.18 | 433.19 | 433.15 | 433.15 | 346.0 |
| 2023-10-10 05:30:00 | SPY | ETF | 433.16 | 433.17 | 432.99 | 433.17 | 981.0 |
| 2023-10-10 05:35:00 | SPY | ETF | 433.17 | 433.17 | 433.01 | 433.01 | 2121.0 |
| 2023-10-10 05:40:00 | SPY | ETF | 433.13 | 433.13 | 433.11 | 433.11 | 3300.0 |
| 2023-10-10 05:45:00 | SPY | ETF | 433.01 | 433.01 | 432.94 | 432.95 | 1721.0 |
| 2023-10-10 05:50:00 | SPY | ETF | 432.95 | 433.22 | 432.95 | 433.22 | 2391.0 |
| 2023-10-10 05:55:00 | SPY | ETF | 433.17 | 433.17 | 433.09 | 433.09 | 1482.0 |
| 2023-10-10 06:00:00 | SPY | ETF | 433.07 | 433.07 | 432.98 | 433.04 | 1710.0 |
| 2023-10-10 06:05:00 | SPY | ETF | 433.05 | 433.25 | 433.05 | 433.25 | 432.0 |
| 2023-10-10 06:10:00 | SPY | ETF | 433.25 | 433.25 | 433.19 | 433.19 | 2233.0 |
| 2023-10-10 06:15:00 | SPY | ETF | 433.13 | 433.13 | 433.1 | 433.1 | 700.0 |
| 2023-10-10 06:20:00 | SPY | ETF | 433.07 | 433.17 | 433.07 | 433.13 | 700.0 |
| 2023-10-10 06:25:00 | SPY | ETF | 433.22 | 433.34 | 433.22 | 433.34 | 1870.0 |
| 2023-10-10 06:30:00 | SPY | ETF | 433.33 | 433.33 | 433.33 | 433.33 | 1000.0 |
| 2023-10-10 06:35:00 | SPY | ETF | 433.21 | 433.34 | 433.21 | 433.25 | 1550.0 |
| 2023-10-10 06:40:00 | SPY | ETF | 433.31 | 433.44 | 433.31 | 433.43 | 11873.0 |
| 2023-10-10 06:45:00 | SPY | ETF | 433.28 | 433.28 | 433.28 | 433.28 | 1500.0 |
| 2023-10-10 06:50:00 | SPY | ETF | 433.27 | 433.27 | 433.24 | 433.24 | 205.0 |
| 2023-10-10 06:55:00 | SPY | ETF | 433.29 | 433.29 | 433.0 | 433.0 | 5474.0 |
| 2023-10-10 07:00:00 | SPY | ETF | 432.97 | 433.1 | 432.96 | 433.05 | 31561.0 |
| 2023-10-10 07:05:00 | SPY | ETF | 433.05 | 433.1 | 432.96 | 432.98 | 43084.0 |
| 2023-10-10 07:10:00 | SPY | ETF | 432.95 | 432.96 | 432.57 | 432.73 | 20979.0 |
| 2023-10-10 07:15:00 | SPY | ETF | 432.79 | 432.87 | 432.76 | 432.81 | 16317.0 |
| 2023-10-10 07:20:00 | SPY | ETF | 432.86 | 432.87 | 432.53 | 432.56 | 29877.0 |
| 2023-10-10 07:25:00 | SPY | ETF | 432.53 | 432.53 | 432.35 | 432.35 | 18536.0 |
| 2023-10-10 07:30:00 | SPY | ETF | 432.47 | 432.6 | 432.45 | 432.52 | 16284.0 |
| 2023-10-10 07:35:00 | SPY | ETF | 432.521 | 432.84 | 432.47 | 432.84 | 14372.0 |
| 2023-10-10 07:40:00 | SPY | ETF | 432.8 | 432.8 | 432.55 | 432.55 | 10427.0 |
| 2023-10-10 07:45:00 | SPY | ETF | 432.65 | 432.65 | 432.4 | 432.41 | 21407.0 |
| 2023-10-10 07:50:00 | SPY | ETF | 432.4 | 432.4 | 432.21 | 432.21 | 11069.0 |
| 2023-10-10 07:55:00 | SPY | ETF | 432.2 | 432.25 | 432.07 | 432.16 | 18082.0 |
| 2023-10-10 08:00:00 | SPY | ETF | 433.04 | 433.28 | 432.02 | 432.24 | 56171.0 |
| 2023-10-10 08:05:00 | SPY | ETF | 432.27 | 432.32 | 432.171 | 432.32 | 81262.0 |
> showing 50 of 98,727 rows — these rows as CSV