PREVIEW / etf_5min / 2022-03-28
file: by_date/etf_5min/2022/2022-03-28.parquet size: 1.9 MB rows: 92,995
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-03-28 04:00:00 | SPY | ETF | 451.96 | 451.96 | 451.34 | 451.34 | 2319.0 |
| 2022-03-28 04:05:00 | SPY | ETF | 451.46 | 451.49 | 451.24 | 451.43 | 11660.0 |
| 2022-03-28 04:10:00 | SPY | ETF | 451.43 | 451.6 | 451.43 | 451.6 | 1037.0 |
| 2022-03-28 04:15:00 | SPY | ETF | 451.55 | 452.05 | 451.55 | 452.05 | 10794.0 |
| 2022-03-28 04:20:00 | SPY | ETF | 451.88 | 451.95 | 451.85 | 451.85 | 3026.0 |
| 2022-03-28 04:25:00 | SPY | ETF | 452.01 | 452.01 | 451.93 | 451.94 | 620.0 |
| 2022-03-28 04:30:00 | SPY | ETF | 451.89 | 451.89 | 451.8 | 451.8 | 614.0 |
| 2022-03-28 04:35:00 | SPY | ETF | 451.88 | 451.88 | 451.88 | 451.88 | 100.0 |
| 2022-03-28 04:40:00 | SPY | ETF | 451.94 | 452.11 | 451.94 | 452.11 | 850.0 |
| 2022-03-28 04:45:00 | SPY | ETF | 452.08 | 452.42 | 452.05 | 452.42 | 1050.0 |
| 2022-03-28 04:50:00 | SPY | ETF | 452.4 | 452.6 | 452.4 | 452.6 | 500.0 |
| 2022-03-28 04:55:00 | SPY | ETF | 452.67 | 452.87 | 452.67 | 452.87 | 1282.0 |
| 2022-03-28 05:00:00 | SPY | ETF | 452.81 | 452.83 | 452.45 | 452.45 | 1837.0 |
| 2022-03-28 05:05:00 | SPY | ETF | 452.46 | 452.46 | 452.25 | 452.25 | 1502.0 |
| 2022-03-28 05:10:00 | SPY | ETF | 452.17 | 452.18 | 452.11 | 452.11 | 2023.0 |
| 2022-03-28 05:15:00 | SPY | ETF | 452.0 | 452.0 | 451.9 | 451.9 | 2733.0 |
| 2022-03-28 05:20:00 | SPY | ETF | 451.83 | 452.04 | 451.83 | 452.04 | 2360.0 |
| 2022-03-28 05:25:00 | SPY | ETF | 452.06 | 452.13 | 452.06 | 452.09 | 1110.0 |
| 2022-03-28 05:30:00 | SPY | ETF | 452.17 | 452.23 | 452.17 | 452.23 | 700.0 |
| 2022-03-28 05:35:00 | SPY | ETF | 452.49 | 452.6 | 452.48 | 452.48 | 1449.0 |
| 2022-03-28 05:40:00 | SPY | ETF | 452.56 | 452.56 | 452.46 | 452.47 | 408.0 |
| 2022-03-28 05:50:00 | SPY | ETF | 452.35 | 452.36 | 452.25 | 452.25 | 700.0 |
| 2022-03-28 05:55:00 | SPY | ETF | 452.22 | 452.31 | 452.22 | 452.31 | 700.0 |
| 2022-03-28 06:00:00 | SPY | ETF | 452.34 | 452.43 | 452.2 | 452.35 | 1050.0 |
| 2022-03-28 06:05:00 | SPY | ETF | 452.33 | 452.42 | 452.32 | 452.32 | 894.0 |
| 2022-03-28 06:10:00 | SPY | ETF | 452.4 | 452.54 | 452.4 | 452.54 | 1340.0 |
| 2022-03-28 06:15:00 | SPY | ETF | 452.54 | 452.68 | 452.54 | 452.68 | 3300.0 |
| 2022-03-28 06:20:00 | SPY | ETF | 452.62 | 452.77 | 452.61 | 452.69 | 2000.0 |
| 2022-03-28 06:25:00 | SPY | ETF | 452.79 | 452.79 | 452.4 | 452.4 | 400.0 |
| 2022-03-28 06:35:00 | SPY | ETF | 452.35 | 452.35 | 452.35 | 452.35 | 100.0 |
| 2022-03-28 06:40:00 | SPY | ETF | 452.57 | 452.64 | 452.57 | 452.64 | 400.0 |
| 2022-03-28 06:45:00 | SPY | ETF | 452.7 | 452.92 | 452.7 | 452.92 | 10249.0 |
| 2022-03-28 06:50:00 | SPY | ETF | 452.8 | 452.89 | 452.7 | 452.7 | 6220.0 |
| 2022-03-28 06:55:00 | SPY | ETF | 452.69 | 452.69 | 452.57 | 452.58 | 1609.0 |
| 2022-03-28 07:00:00 | SPY | ETF | 452.82 | 453.06 | 452.82 | 453.06 | 11756.0 |
| 2022-03-28 07:05:00 | SPY | ETF | 453.04 | 453.3 | 452.95 | 453.26 | 20612.0 |
| 2022-03-28 07:10:00 | SPY | ETF | 453.27 | 453.42 | 453.04 | 453.24 | 10972.0 |
| 2022-03-28 07:15:00 | SPY | ETF | 453.24 | 453.54 | 453.24 | 453.5 | 15581.0 |
| 2022-03-28 07:20:00 | SPY | ETF | 453.53 | 453.54 | 453.38 | 453.46 | 4005.0 |
| 2022-03-28 07:25:00 | SPY | ETF | 453.5 | 453.56 | 453.47 | 453.53 | 17845.0 |
| 2022-03-28 07:30:00 | SPY | ETF | 453.56 | 453.8 | 453.56 | 453.68 | 10165.0 |
| 2022-03-28 07:35:00 | SPY | ETF | 453.7 | 453.87 | 453.7 | 453.8 | 5316.0 |
| 2022-03-28 07:40:00 | SPY | ETF | 453.8 | 453.8 | 453.6 | 453.66 | 11304.0 |
| 2022-03-28 07:45:00 | SPY | ETF | 453.66 | 453.82 | 453.66 | 453.82 | 2331.0 |
| 2022-03-28 07:50:00 | SPY | ETF | 453.79 | 453.81 | 453.62 | 453.75 | 24644.0 |
| 2022-03-28 07:55:00 | SPY | ETF | 453.8 | 453.85 | 453.73 | 453.78 | 4436.0 |
| 2022-03-28 08:00:00 | SPY | ETF | 452.1804 | 453.86 | 450.71 | 453.56 | 48690.0 |
| 2022-03-28 08:05:00 | SPY | ETF | 453.6 | 453.65 | 453.49 | 453.55 | 8526.0 |
| 2022-03-28 08:10:00 | SPY | ETF | 453.52 | 453.54 | 452.31 | 453.45 | 41066.0 |
| 2022-03-28 08:15:00 | SPY | ETF | 453.49 | 453.5 | 453.3 | 453.32 | 6977.0 |
> showing 50 of 92,995 rows — these rows as CSV