PREVIEW / etf_5min / 2023-11-21
file: by_date/etf_5min/2023/2023-11-21.parquet size: 2.1 MB rows: 101,302
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-11-21 04:00:00 | SPY | ETF | 454.4 | 454.4 | 453.88 | 453.96 | 5427.0 |
| 2023-11-21 04:05:00 | SPY | ETF | 453.97 | 453.97 | 453.86 | 453.86 | 1500.0 |
| 2023-11-21 04:10:00 | SPY | ETF | 453.89 | 454.03 | 453.87 | 453.87 | 1914.0 |
| 2023-11-21 04:15:00 | SPY | ETF | 453.85 | 453.97 | 453.85 | 453.97 | 1417.0 |
| 2023-11-21 04:20:00 | SPY | ETF | 453.94 | 454.1 | 453.94 | 454.1 | 1219.0 |
| 2023-11-21 04:25:00 | SPY | ETF | 454.12 | 454.13 | 454.05 | 454.05 | 842.0 |
| 2023-11-21 04:30:00 | SPY | ETF | 454.06 | 454.11 | 454.01 | 454.01 | 951.0 |
| 2023-11-21 04:35:00 | SPY | ETF | 454.15 | 454.17 | 454.15 | 454.17 | 815.0 |
| 2023-11-21 04:40:00 | SPY | ETF | 454.16 | 454.2 | 454.0 | 454.0 | 1095.0 |
| 2023-11-21 04:45:00 | SPY | ETF | 453.87 | 453.87 | 453.8 | 453.8 | 675.0 |
| 2023-11-21 04:50:00 | SPY | ETF | 453.82 | 453.82 | 453.74 | 453.78 | 1598.0 |
| 2023-11-21 04:55:00 | SPY | ETF | 453.75 | 453.75 | 453.75 | 453.75 | 500.0 |
| 2023-11-21 05:00:00 | SPY | ETF | 453.75 | 453.75 | 453.75 | 453.75 | 100.0 |
| 2023-11-21 05:05:00 | SPY | ETF | 453.8 | 453.85 | 453.78 | 453.78 | 1278.0 |
| 2023-11-21 05:10:00 | SPY | ETF | 453.75 | 453.75 | 453.75 | 453.75 | 100.0 |
| 2023-11-21 05:15:00 | SPY | ETF | 453.93 | 453.93 | 453.9 | 453.9 | 1064.0 |
| 2023-11-21 05:20:00 | SPY | ETF | 454.0 | 454.0 | 454.0 | 454.0 | 1095.0 |
| 2023-11-21 05:30:00 | SPY | ETF | 454.09 | 454.09 | 454.09 | 454.09 | 199.0 |
| 2023-11-21 05:40:00 | SPY | ETF | 454.14 | 454.14 | 454.14 | 454.14 | 134.0 |
| 2023-11-21 05:45:00 | SPY | ETF | 454.11 | 454.11 | 454.03 | 454.05 | 2699.0 |
| 2023-11-21 05:50:00 | SPY | ETF | 454.0 | 454.0 | 454.0 | 454.0 | 600.0 |
| 2023-11-21 05:55:00 | SPY | ETF | 453.99 | 453.99 | 453.98 | 453.99 | 1195.0 |
| 2023-11-21 06:00:00 | SPY | ETF | 454.0 | 454.0 | 453.82 | 453.83 | 2854.0 |
| 2023-11-21 06:05:00 | SPY | ETF | 453.85 | 453.85 | 453.76 | 453.76 | 2388.0 |
| 2023-11-21 06:10:00 | SPY | ETF | 453.75 | 453.81 | 453.75 | 453.75 | 3599.0 |
| 2023-11-21 06:15:00 | SPY | ETF | 453.85 | 453.85 | 453.85 | 453.85 | 200.0 |
| 2023-11-21 06:20:00 | SPY | ETF | 453.82 | 453.82 | 453.75 | 453.75 | 300.0 |
| 2023-11-21 06:25:00 | SPY | ETF | 453.77 | 453.84 | 453.77 | 453.83 | 1694.0 |
| 2023-11-21 06:30:00 | SPY | ETF | 453.79 | 453.79 | 453.72 | 453.74 | 6632.0 |
| 2023-11-21 06:35:00 | SPY | ETF | 453.77 | 453.85 | 453.77 | 453.81 | 1612.0 |
| 2023-11-21 06:40:00 | SPY | ETF | 453.79 | 453.82 | 453.79 | 453.82 | 380.0 |
| 2023-11-21 06:50:00 | SPY | ETF | 453.82 | 453.83 | 453.71 | 453.71 | 12254.0 |
| 2023-11-21 06:55:00 | SPY | ETF | 453.73 | 453.73 | 453.68 | 453.71 | 2051.0 |
| 2023-11-21 07:00:00 | SPY | ETF | 453.75 | 453.81 | 453.75 | 453.75 | 19001.0 |
| 2023-11-21 07:05:00 | SPY | ETF | 453.75 | 453.8 | 453.67 | 453.7 | 4366.0 |
| 2023-11-21 07:10:00 | SPY | ETF | 453.7 | 453.81 | 453.7 | 453.74 | 5734.0 |
| 2023-11-21 07:15:00 | SPY | ETF | 453.7 | 453.79 | 453.63 | 453.76 | 6241.0 |
| 2023-11-21 07:20:00 | SPY | ETF | 453.75 | 453.81 | 453.75 | 453.79 | 13113.0 |
| 2023-11-21 07:25:00 | SPY | ETF | 453.82 | 453.94 | 453.82 | 453.94 | 6628.0 |
| 2023-11-21 07:30:00 | SPY | ETF | 453.9 | 454.0 | 453.82 | 453.86 | 8733.0 |
| 2023-11-21 07:35:00 | SPY | ETF | 453.89 | 453.89 | 453.73 | 453.75 | 4414.0 |
| 2023-11-21 07:40:00 | SPY | ETF | 453.7 | 453.77 | 453.66 | 453.77 | 2391.0 |
| 2023-11-21 07:45:00 | SPY | ETF | 453.76 | 453.76 | 453.64 | 453.64 | 4558.0 |
| 2023-11-21 07:50:00 | SPY | ETF | 453.7 | 453.7 | 453.62 | 453.66 | 25800.0 |
| 2023-11-21 07:55:00 | SPY | ETF | 453.67 | 453.7 | 453.49 | 453.54 | 32318.0 |
| 2023-11-21 08:00:00 | SPY | ETF | 453.741 | 454.51 | 453.44 | 453.44 | 60983.0 |
| 2023-11-21 08:05:00 | SPY | ETF | 453.45 | 453.45 | 453.38 | 453.38 | 34366.0 |
| 2023-11-21 08:10:00 | SPY | ETF | 453.38 | 453.47 | 453.36 | 453.47 | 15243.0 |
| 2023-11-21 08:15:00 | SPY | ETF | 453.45 | 453.53 | 453.42 | 453.53 | 8280.0 |
| 2023-11-21 08:20:00 | SPY | ETF | 453.49 | 454.26 | 453.49 | 453.59 | 45719.0 |
> showing 50 of 101,302 rows — these rows as CSV