PREVIEW / etf_5min / 2023-10-13
file: by_date/etf_5min/2023/2023-10-13.parquet size: 2.0 MB rows: 97,092
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-13 04:00:00 | SPY | ETF | 434.48 | 434.7 | 434.48 | 434.69 | 1800.0 |
| 2023-10-13 04:05:00 | SPY | ETF | 434.71 | 434.84 | 434.64 | 434.66 | 1720.0 |
| 2023-10-13 04:10:00 | SPY | ETF | 434.63 | 434.63 | 434.6 | 434.6 | 1070.0 |
| 2023-10-13 04:15:00 | SPY | ETF | 434.6 | 434.6 | 434.35 | 434.35 | 625.0 |
| 2023-10-13 04:20:00 | SPY | ETF | 434.36 | 434.45 | 434.35 | 434.39 | 4316.0 |
| 2023-10-13 04:25:00 | SPY | ETF | 434.2 | 434.2 | 434.2 | 434.2 | 1178.0 |
| 2023-10-13 04:30:00 | SPY | ETF | 434.17 | 434.23 | 434.12 | 434.21 | 3055.0 |
| 2023-10-13 04:35:00 | SPY | ETF | 434.34 | 434.35 | 434.02 | 434.02 | 5585.0 |
| 2023-10-13 04:40:00 | SPY | ETF | 433.87 | 433.9 | 433.8 | 433.8 | 2788.0 |
| 2023-10-13 04:45:00 | SPY | ETF | 433.87 | 433.89 | 433.87 | 433.88 | 900.0 |
| 2023-10-13 04:50:00 | SPY | ETF | 433.8 | 433.88 | 433.8 | 433.88 | 211.0 |
| 2023-10-13 04:55:00 | SPY | ETF | 433.89 | 433.91 | 433.87 | 433.87 | 569.0 |
| 2023-10-13 05:00:00 | SPY | ETF | 433.87 | 433.87 | 433.69 | 433.7 | 696.0 |
| 2023-10-13 05:05:00 | SPY | ETF | 433.55 | 433.55 | 433.23 | 433.23 | 6562.0 |
| 2023-10-13 05:10:00 | SPY | ETF | 433.26 | 433.26 | 433.26 | 433.26 | 250.0 |
| 2023-10-13 05:15:00 | SPY | ETF | 433.17 | 433.27 | 433.14 | 433.27 | 847.0 |
| 2023-10-13 05:20:00 | SPY | ETF | 433.39 | 433.41 | 433.35 | 433.35 | 300.0 |
| 2023-10-13 05:25:00 | SPY | ETF | 433.33 | 433.39 | 433.22 | 433.22 | 651.0 |
| 2023-10-13 05:30:00 | SPY | ETF | 433.31 | 433.31 | 433.2 | 433.2 | 4068.0 |
| 2023-10-13 05:35:00 | SPY | ETF | 433.19 | 433.26 | 433.19 | 433.26 | 225.0 |
| 2023-10-13 05:40:00 | SPY | ETF | 433.11 | 433.11 | 433.05 | 433.08 | 975.0 |
| 2023-10-13 05:45:00 | SPY | ETF | 433.1 | 433.1 | 432.9 | 432.9 | 2110.0 |
| 2023-10-13 05:50:00 | SPY | ETF | 432.89 | 432.94 | 432.51 | 432.52 | 11866.0 |
| 2023-10-13 05:55:00 | SPY | ETF | 432.6 | 432.76 | 432.6 | 432.6 | 2720.0 |
| 2023-10-13 06:00:00 | SPY | ETF | 432.55 | 432.74 | 432.55 | 432.73 | 3056.0 |
| 2023-10-13 06:05:00 | SPY | ETF | 432.8 | 432.8 | 432.5 | 432.5 | 1623.0 |
| 2023-10-13 06:10:00 | SPY | ETF | 432.58 | 432.58 | 432.29 | 432.54 | 7748.0 |
| 2023-10-13 06:15:00 | SPY | ETF | 432.5 | 432.73 | 432.49 | 432.52 | 2742.0 |
| 2023-10-13 06:20:00 | SPY | ETF | 432.58 | 432.61 | 432.5 | 432.5 | 823.0 |
| 2023-10-13 06:25:00 | SPY | ETF | 432.58 | 432.7 | 432.58 | 432.64 | 300.0 |
| 2023-10-13 06:30:00 | SPY | ETF | 432.36 | 432.36 | 432.36 | 432.36 | 289.0 |
| 2023-10-13 06:35:00 | SPY | ETF | 432.35 | 432.72 | 432.35 | 432.64 | 7798.0 |
| 2023-10-13 06:40:00 | SPY | ETF | 432.45 | 432.47 | 432.44 | 432.44 | 6405.0 |
| 2023-10-13 06:45:00 | SPY | ETF | 432.38 | 433.1 | 432.38 | 433.06 | 20064.0 |
| 2023-10-13 06:50:00 | SPY | ETF | 432.95 | 433.21 | 432.86 | 432.93 | 14950.0 |
| 2023-10-13 06:55:00 | SPY | ETF | 432.93 | 433.07 | 432.86 | 432.87 | 11499.0 |
| 2023-10-13 07:00:00 | SPY | ETF | 432.96 | 433.2 | 432.92 | 433.2 | 13303.0 |
| 2023-10-13 07:05:00 | SPY | ETF | 433.17 | 433.35 | 433.17 | 433.35 | 11557.0 |
| 2023-10-13 07:10:00 | SPY | ETF | 433.28 | 433.47 | 433.27 | 433.45 | 29205.0 |
| 2023-10-13 07:15:00 | SPY | ETF | 433.35 | 433.39 | 433.22 | 433.22 | 10745.0 |
| 2023-10-13 07:20:00 | SPY | ETF | 433.14 | 433.4 | 433.06 | 433.38 | 40041.0 |
| 2023-10-13 07:25:00 | SPY | ETF | 433.3 | 433.77 | 433.3 | 433.71 | 18220.0 |
| 2023-10-13 07:30:00 | SPY | ETF | 433.68 | 433.68 | 433.52 | 433.52 | 27505.0 |
| 2023-10-13 07:35:00 | SPY | ETF | 433.51 | 433.6 | 433.51 | 433.59 | 24817.0 |
| 2023-10-13 07:40:00 | SPY | ETF | 433.69 | 433.77 | 433.46 | 433.46 | 28625.0 |
| 2023-10-13 07:45:00 | SPY | ETF | 433.4 | 433.5 | 433.24 | 433.43 | 36152.0 |
| 2023-10-13 07:50:00 | SPY | ETF | 433.36 | 433.69 | 433.36 | 433.6 | 11784.0 |
| 2023-10-13 07:55:00 | SPY | ETF | 433.58 | 433.68 | 433.41 | 433.53 | 5563.0 |
| 2023-10-13 08:00:00 | SPY | ETF | 432.93 | 434.66 | 432.3496 | 433.47 | 71314.0 |
| 2023-10-13 08:05:00 | SPY | ETF | 433.47 | 433.52 | 432.97 | 433.07 | 56841.0 |
> showing 50 of 97,092 rows — these rows as CSV