PREVIEW / etf_5min / 2022-11-11
file: by_date/etf_5min/2022/2022-11-11.parquet size: 2.0 MB rows: 98,018
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-11-11 04:00:00 | SPY | ETF | 398.0 | 398.11 | 397.36 | 397.56 | 21283.0 |
| 2022-11-11 04:05:00 | SPY | ETF | 397.53 | 397.53 | 397.29 | 397.34 | 5144.0 |
| 2022-11-11 04:10:00 | SPY | ETF | 397.4 | 397.42 | 397.1 | 397.1 | 6850.0 |
| 2022-11-11 04:15:00 | SPY | ETF | 397.09 | 397.33 | 396.78 | 396.99 | 24873.0 |
| 2022-11-11 04:20:00 | SPY | ETF | 397.0 | 397.0 | 396.75 | 396.82 | 4364.0 |
| 2022-11-11 04:25:00 | SPY | ETF | 396.8 | 396.8 | 396.53 | 396.53 | 5496.0 |
| 2022-11-11 04:30:00 | SPY | ETF | 396.63 | 396.73 | 396.41 | 396.5 | 13462.0 |
| 2022-11-11 04:35:00 | SPY | ETF | 396.49 | 396.7 | 396.49 | 396.53 | 3929.0 |
| 2022-11-11 04:40:00 | SPY | ETF | 396.62 | 396.77 | 396.62 | 396.76 | 1125.0 |
| 2022-11-11 04:45:00 | SPY | ETF | 396.73 | 396.88 | 396.67 | 396.88 | 4494.0 |
| 2022-11-11 04:50:00 | SPY | ETF | 396.87 | 396.9 | 396.67 | 396.67 | 6114.0 |
| 2022-11-11 04:55:00 | SPY | ETF | 396.71 | 397.04 | 396.71 | 396.87 | 7850.0 |
| 2022-11-11 05:00:00 | SPY | ETF | 396.89 | 397.25 | 396.89 | 397.02 | 1789.0 |
| 2022-11-11 05:05:00 | SPY | ETF | 397.03 | 397.03 | 396.7 | 396.71 | 5109.0 |
| 2022-11-11 05:10:00 | SPY | ETF | 396.8 | 396.85 | 396.49 | 396.84 | 20617.0 |
| 2022-11-11 05:15:00 | SPY | ETF | 396.87 | 397.09 | 396.82 | 397.07 | 4366.0 |
| 2022-11-11 05:20:00 | SPY | ETF | 397.07 | 397.07 | 396.7 | 396.7 | 4182.0 |
| 2022-11-11 05:25:00 | SPY | ETF | 396.68 | 396.7 | 396.35 | 396.38 | 6092.0 |
| 2022-11-11 05:30:00 | SPY | ETF | 396.38 | 396.63 | 396.38 | 396.57 | 7321.0 |
| 2022-11-11 05:35:00 | SPY | ETF | 396.33 | 396.64 | 396.24 | 396.64 | 5497.0 |
| 2022-11-11 05:40:00 | SPY | ETF | 396.37 | 396.37 | 396.15 | 396.3 | 5191.0 |
| 2022-11-11 05:45:00 | SPY | ETF | 396.17 | 396.24 | 396.0 | 396.03 | 7050.0 |
| 2022-11-11 05:50:00 | SPY | ETF | 396.0 | 396.08 | 396.0 | 396.08 | 1746.0 |
| 2022-11-11 05:55:00 | SPY | ETF | 396.19 | 396.35 | 396.17 | 396.35 | 2187.0 |
| 2022-11-11 06:00:00 | SPY | ETF | 396.15 | 396.17 | 395.9 | 395.91 | 74973.0 |
| 2022-11-11 06:05:00 | SPY | ETF | 395.93 | 396.23 | 395.84 | 396.04 | 27822.0 |
| 2022-11-11 06:10:00 | SPY | ETF | 396.09 | 396.21 | 396.02 | 396.15 | 3346.0 |
| 2022-11-11 06:15:00 | SPY | ETF | 396.05 | 396.37 | 396.0 | 396.32 | 14764.0 |
| 2022-11-11 06:20:00 | SPY | ETF | 396.33 | 396.44 | 396.18 | 396.4 | 37927.0 |
| 2022-11-11 06:25:00 | SPY | ETF | 396.4 | 396.4 | 396.27 | 396.33 | 32770.0 |
| 2022-11-11 06:30:00 | SPY | ETF | 396.47 | 396.7 | 396.47 | 396.65 | 37100.0 |
| 2022-11-11 06:35:00 | SPY | ETF | 396.65 | 396.8 | 396.65 | 396.65 | 8214.0 |
| 2022-11-11 06:40:00 | SPY | ETF | 396.7 | 396.76 | 396.44 | 396.44 | 12054.0 |
| 2022-11-11 06:45:00 | SPY | ETF | 396.46 | 396.46 | 396.29 | 396.4 | 12984.0 |
| 2022-11-11 06:50:00 | SPY | ETF | 396.46 | 396.75 | 396.44 | 396.75 | 2957.0 |
| 2022-11-11 06:55:00 | SPY | ETF | 396.76 | 396.76 | 396.47 | 396.53 | 1450.0 |
| 2022-11-11 07:00:00 | SPY | ETF | 396.51 | 396.64 | 396.15 | 396.57 | 32224.0 |
| 2022-11-11 07:05:00 | SPY | ETF | 396.57 | 396.59 | 396.2 | 396.44 | 32958.0 |
| 2022-11-11 07:10:00 | SPY | ETF | 396.42 | 396.44 | 396.04 | 396.05 | 43749.0 |
| 2022-11-11 07:15:00 | SPY | ETF | 396.06 | 396.06 | 395.77 | 396.03 | 34691.0 |
| 2022-11-11 07:20:00 | SPY | ETF | 396.01 | 396.04 | 395.9 | 396.04 | 8489.0 |
| 2022-11-11 07:25:00 | SPY | ETF | 396.03 | 396.23 | 396.0 | 396.0 | 15369.0 |
| 2022-11-11 07:30:00 | SPY | ETF | 396.0 | 396.471 | 395.8 | 396.47 | 28087.0 |
| 2022-11-11 07:35:00 | SPY | ETF | 396.47 | 396.64 | 396.38 | 396.52 | 45505.0 |
| 2022-11-11 07:40:00 | SPY | ETF | 396.499 | 396.52 | 396.24 | 396.27 | 88513.0 |
| 2022-11-11 07:45:00 | SPY | ETF | 396.3 | 396.54 | 396.16 | 396.3 | 42456.0 |
| 2022-11-11 07:50:00 | SPY | ETF | 396.31 | 396.57 | 396.2 | 396.521 | 39759.0 |
| 2022-11-11 07:55:00 | SPY | ETF | 396.43 | 396.65 | 396.36 | 396.61 | 11192.0 |
| 2022-11-11 08:00:00 | SPY | ETF | 396.44 | 398.0 | 395.29 | 396.69 | 183336.0 |
| 2022-11-11 08:05:00 | SPY | ETF | 396.67 | 396.82 | 396.65 | 396.73 | 86008.0 |
> showing 50 of 98,018 rows — these rows as CSV