PREVIEW / etf_5min / 2022-03-18
file: by_date/etf_5min/2022/2022-03-18.parquet size: 1.9 MB rows: 93,213
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-18 04:00:00 | SPY | ETF | 438.0 | 438.05 | 437.49 | 437.59 | 4905.0 |
| 2022-03-18 04:05:00 | SPY | ETF | 437.6 | 437.63 | 437.45 | 437.63 | 1061.0 |
| 2022-03-18 04:10:00 | SPY | ETF | 437.55 | 437.88 | 437.54 | 437.88 | 1770.0 |
| 2022-03-18 04:15:00 | SPY | ETF | 437.81 | 437.81 | 437.4 | 437.4 | 1696.0 |
| 2022-03-18 04:20:00 | SPY | ETF | 437.65 | 437.89 | 437.65 | 437.89 | 300.0 |
| 2022-03-18 04:25:00 | SPY | ETF | 437.73 | 437.89 | 437.49 | 437.49 | 4200.0 |
| 2022-03-18 04:30:00 | SPY | ETF | 437.28 | 437.28 | 436.87 | 437.11 | 5774.0 |
| 2022-03-18 04:35:00 | SPY | ETF | 437.27 | 437.39 | 437.26 | 437.35 | 2200.0 |
| 2022-03-18 04:40:00 | SPY | ETF | 437.17 | 437.17 | 436.99 | 437.15 | 1900.0 |
| 2022-03-18 04:45:00 | SPY | ETF | 436.81 | 436.81 | 436.57 | 436.74 | 6662.0 |
| 2022-03-18 04:50:00 | SPY | ETF | 436.76 | 436.9 | 436.75 | 436.8 | 1932.0 |
| 2022-03-18 04:55:00 | SPY | ETF | 436.88 | 437.09 | 436.88 | 437.08 | 1335.0 |
| 2022-03-18 05:00:00 | SPY | ETF | 437.2 | 437.23 | 436.8 | 437.09 | 4075.0 |
| 2022-03-18 05:05:00 | SPY | ETF | 436.97 | 437.08 | 436.97 | 437.08 | 11080.0 |
| 2022-03-18 05:10:00 | SPY | ETF | 436.97 | 436.97 | 436.85 | 436.85 | 600.0 |
| 2022-03-18 05:15:00 | SPY | ETF | 436.68 | 436.69 | 436.59 | 436.66 | 2500.0 |
| 2022-03-18 05:20:00 | SPY | ETF | 436.67 | 436.67 | 436.66 | 436.66 | 700.0 |
| 2022-03-18 05:25:00 | SPY | ETF | 436.7 | 436.7 | 436.25 | 436.61 | 5716.0 |
| 2022-03-18 05:30:00 | SPY | ETF | 436.69 | 437.2 | 436.69 | 437.0 | 11480.0 |
| 2022-03-18 05:35:00 | SPY | ETF | 436.8 | 436.8 | 436.5 | 436.51 | 4380.0 |
| 2022-03-18 05:40:00 | SPY | ETF | 436.54 | 436.62 | 436.48 | 436.61 | 1999.0 |
| 2022-03-18 05:45:00 | SPY | ETF | 436.71 | 436.85 | 436.71 | 436.85 | 2080.0 |
| 2022-03-18 05:50:00 | SPY | ETF | 436.89 | 436.89 | 436.87 | 436.87 | 300.0 |
| 2022-03-18 05:55:00 | SPY | ETF | 437.0 | 437.07 | 437.0 | 437.06 | 1841.0 |
| 2022-03-18 06:00:00 | SPY | ETF | 436.92 | 437.1 | 436.88 | 437.1 | 1512.0 |
| 2022-03-18 06:05:00 | SPY | ETF | 437.16 | 437.2 | 437.0 | 437.18 | 2099.0 |
| 2022-03-18 06:10:00 | SPY | ETF | 437.2 | 437.29 | 437.05 | 437.05 | 5500.0 |
| 2022-03-18 06:15:00 | SPY | ETF | 437.0 | 437.0 | 436.5 | 436.5 | 7438.0 |
| 2022-03-18 06:20:00 | SPY | ETF | 436.45 | 436.76 | 436.41 | 436.6 | 4999.0 |
| 2022-03-18 06:25:00 | SPY | ETF | 436.7 | 436.88 | 436.7 | 436.82 | 6896.0 |
| 2022-03-18 06:30:00 | SPY | ETF | 436.7 | 436.7 | 436.5 | 436.5 | 4775.0 |
| 2022-03-18 06:35:00 | SPY | ETF | 436.7 | 436.7 | 436.65 | 436.7 | 1020.0 |
| 2022-03-18 06:40:00 | SPY | ETF | 436.8 | 436.8 | 436.42 | 436.42 | 6500.0 |
| 2022-03-18 06:45:00 | SPY | ETF | 436.45 | 436.45 | 436.32 | 436.32 | 380.0 |
| 2022-03-18 06:50:00 | SPY | ETF | 436.33 | 436.33 | 436.05 | 436.2 | 7300.0 |
| 2022-03-18 06:55:00 | SPY | ETF | 436.21 | 436.51 | 436.21 | 436.51 | 4400.0 |
| 2022-03-18 07:00:00 | SPY | ETF | 436.57 | 436.57 | 436.19 | 436.36 | 29794.0 |
| 2022-03-18 07:05:00 | SPY | ETF | 436.3 | 436.32 | 435.86 | 436.1 | 63864.0 |
| 2022-03-18 07:10:00 | SPY | ETF | 436.13 | 436.14 | 435.76 | 436.03 | 20501.0 |
| 2022-03-18 07:15:00 | SPY | ETF | 436.08 | 436.41 | 436.08 | 436.4 | 20219.0 |
| 2022-03-18 07:20:00 | SPY | ETF | 436.4 | 436.41 | 436.22 | 436.28 | 9390.0 |
| 2022-03-18 07:25:00 | SPY | ETF | 436.28 | 436.28 | 435.71 | 436.13 | 32651.0 |
| 2022-03-18 07:30:00 | SPY | ETF | 436.17 | 436.6 | 436.17 | 436.45 | 35719.0 |
| 2022-03-18 07:35:00 | SPY | ETF | 436.45 | 436.69 | 436.29 | 436.6 | 21107.0 |
| 2022-03-18 07:40:00 | SPY | ETF | 436.58 | 436.83 | 436.51 | 436.72 | 37274.0 |
| 2022-03-18 07:45:00 | SPY | ETF | 436.72 | 436.75 | 436.44 | 436.49 | 28695.0 |
| 2022-03-18 07:50:00 | SPY | ETF | 436.5 | 436.55 | 436.34 | 436.37 | 28179.0 |
| 2022-03-18 07:55:00 | SPY | ETF | 436.4 | 436.55 | 436.1 | 436.139 | 45349.0 |
| 2022-03-18 08:00:00 | SPY | ETF | 436.201 | 438.3 | 435.76 | 436.35 | 111894.0 |
| 2022-03-18 08:05:00 | SPY | ETF | 436.34 | 436.6 | 436.27 | 436.46 | 43525.0 |
> showing 50 of 93,213 rows — these rows as CSV