PREVIEW / etf_5min / 2022-06-24
file: by_date/etf_5min/2022/2022-06-24.parquet size: 1.9 MB rows: 94,515
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 |
|---|---|---|---|---|---|---|---|
| 2022-06-24 04:00:00 | SPY | ETF | 380.77 | 381.25 | 380.0 | 380.89 | 16734.0 |
| 2022-06-24 04:05:00 | SPY | ETF | 380.8 | 380.82 | 380.61 | 380.61 | 2290.0 |
| 2022-06-24 04:10:00 | SPY | ETF | 380.58 | 380.7 | 380.36 | 380.37 | 5550.0 |
| 2022-06-24 04:15:00 | SPY | ETF | 380.63 | 380.71 | 380.48 | 380.68 | 2300.0 |
| 2022-06-24 04:20:00 | SPY | ETF | 380.76 | 380.76 | 380.05 | 380.2 | 2600.0 |
| 2022-06-24 04:25:00 | SPY | ETF | 380.2 | 380.57 | 380.18 | 380.5 | 2124.0 |
| 2022-06-24 04:30:00 | SPY | ETF | 380.61 | 380.8 | 380.48 | 380.8 | 3631.0 |
| 2022-06-24 04:35:00 | SPY | ETF | 380.7 | 380.92 | 380.7 | 380.8 | 2474.0 |
| 2022-06-24 04:40:00 | SPY | ETF | 380.89 | 380.9 | 380.82 | 380.86 | 9080.0 |
| 2022-06-24 04:45:00 | SPY | ETF | 380.84 | 380.93 | 380.67 | 380.67 | 827.0 |
| 2022-06-24 04:50:00 | SPY | ETF | 380.58 | 380.78 | 380.54 | 380.73 | 4372.0 |
| 2022-06-24 04:55:00 | SPY | ETF | 380.76 | 380.95 | 380.76 | 380.84 | 3456.0 |
| 2022-06-24 05:00:00 | SPY | ETF | 380.8 | 380.8 | 380.69 | 380.69 | 1500.0 |
| 2022-06-24 05:05:00 | SPY | ETF | 380.7 | 380.88 | 380.65 | 380.82 | 1659.0 |
| 2022-06-24 05:10:00 | SPY | ETF | 380.92 | 381.16 | 380.92 | 381.16 | 4853.0 |
| 2022-06-24 05:15:00 | SPY | ETF | 381.01 | 381.08 | 381.01 | 381.08 | 950.0 |
| 2022-06-24 05:20:00 | SPY | ETF | 381.06 | 381.06 | 381.01 | 381.05 | 1205.0 |
| 2022-06-24 05:25:00 | SPY | ETF | 381.05 | 381.05 | 380.75 | 380.76 | 3450.0 |
| 2022-06-24 05:30:00 | SPY | ETF | 380.8 | 380.9 | 380.8 | 380.9 | 2080.0 |
| 2022-06-24 05:35:00 | SPY | ETF | 380.95 | 380.95 | 380.71 | 380.71 | 575.0 |
| 2022-06-24 05:40:00 | SPY | ETF | 380.7 | 380.9 | 380.65 | 380.9 | 3047.0 |
| 2022-06-24 05:45:00 | SPY | ETF | 380.99 | 381.1 | 380.94 | 380.97 | 4250.0 |
| 2022-06-24 05:50:00 | SPY | ETF | 380.89 | 381.04 | 380.89 | 381.04 | 360.0 |
| 2022-06-24 05:55:00 | SPY | ETF | 381.0 | 381.28 | 380.94 | 381.28 | 4950.0 |
| 2022-06-24 06:00:00 | SPY | ETF | 381.31 | 381.66 | 381.27 | 381.6 | 57819.0 |
| 2022-06-24 06:05:00 | SPY | ETF | 381.52 | 381.7 | 381.33 | 381.7 | 6456.0 |
| 2022-06-24 06:10:00 | SPY | ETF | 381.64 | 381.64 | 381.46 | 381.5 | 6575.0 |
| 2022-06-24 06:15:00 | SPY | ETF | 381.56 | 381.6 | 381.44 | 381.48 | 3957.0 |
| 2022-06-24 06:20:00 | SPY | ETF | 381.44 | 381.44 | 381.24 | 381.24 | 1161.0 |
| 2022-06-24 06:25:00 | SPY | ETF | 381.2 | 381.24 | 381.14 | 381.18 | 5161.0 |
| 2022-06-24 06:30:00 | SPY | ETF | 381.2 | 381.5 | 381.17 | 381.5 | 6891.0 |
| 2022-06-24 06:35:00 | SPY | ETF | 381.43 | 381.43 | 381.38 | 381.39 | 4534.0 |
| 2022-06-24 06:40:00 | SPY | ETF | 381.32 | 381.32 | 381.16 | 381.21 | 7699.0 |
| 2022-06-24 06:45:00 | SPY | ETF | 381.23 | 381.3 | 381.18 | 381.22 | 3442.0 |
| 2022-06-24 06:50:00 | SPY | ETF | 381.29 | 381.29 | 381.11 | 381.15 | 2727.0 |
| 2022-06-24 06:55:00 | SPY | ETF | 381.18 | 381.18 | 380.95 | 381.11 | 9020.0 |
| 2022-06-24 07:00:00 | SPY | ETF | 381.07 | 381.13 | 380.98 | 380.99 | 25593.0 |
| 2022-06-24 07:05:00 | SPY | ETF | 380.97 | 381.01 | 380.93 | 381.0 | 9978.0 |
| 2022-06-24 07:10:00 | SPY | ETF | 381.0 | 381.17 | 380.95 | 381.16 | 38588.0 |
| 2022-06-24 07:15:00 | SPY | ETF | 381.16 | 381.24 | 381.03 | 381.24 | 28276.0 |
| 2022-06-24 07:20:00 | SPY | ETF | 381.24 | 381.3 | 381.11 | 381.21 | 40185.0 |
| 2022-06-24 07:25:00 | SPY | ETF | 381.15 | 381.31 | 381.1 | 381.31 | 14216.0 |
| 2022-06-24 07:30:00 | SPY | ETF | 381.39 | 381.6 | 381.31 | 381.51 | 45717.0 |
| 2022-06-24 07:35:00 | SPY | ETF | 381.47 | 381.48 | 381.05 | 381.11 | 36945.0 |
| 2022-06-24 07:40:00 | SPY | ETF | 381.15 | 381.17 | 380.95 | 380.95 | 32712.0 |
| 2022-06-24 07:45:00 | SPY | ETF | 380.99 | 381.04 | 380.6 | 380.66 | 23836.0 |
| 2022-06-24 07:50:00 | SPY | ETF | 380.67 | 380.85 | 380.6 | 380.83 | 42007.0 |
| 2022-06-24 07:55:00 | SPY | ETF | 380.81 | 380.97 | 380.76 | 380.84 | 39829.0 |
| 2022-06-24 08:00:00 | SPY | ETF | 381.2001 | 381.6 | 380.45 | 381.52 | 132481.0 |
| 2022-06-24 08:05:00 | SPY | ETF | 380.94 | 381.24 | 380.86 | 381.1 | 20073.0 |
> showing 50 of 94,515 rows — these rows as CSV