PREVIEW / etf_5min / 2021-12-31
file: by_date/etf_5min/2021/2021-12-31.parquet size: 1.7 MB rows: 83,926
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 |
|---|---|---|---|---|---|---|---|
| 2021-12-31 04:00:00 | SPY | ETF | 475.83 | 475.87 | 475.78 | 475.87 | 1591.0 |
| 2021-12-31 04:05:00 | SPY | ETF | 475.89 | 476.08 | 475.89 | 476.03 | 1167.0 |
| 2021-12-31 04:10:00 | SPY | ETF | 476.06 | 476.06 | 476.05 | 476.05 | 214.0 |
| 2021-12-31 04:15:00 | SPY | ETF | 476.01 | 476.01 | 475.93 | 475.93 | 243.0 |
| 2021-12-31 04:20:00 | SPY | ETF | 475.59 | 475.59 | 475.59 | 475.59 | 100.0 |
| 2021-12-31 04:25:00 | SPY | ETF | 475.65 | 475.65 | 475.65 | 475.65 | 190.0 |
| 2021-12-31 04:30:00 | SPY | ETF | 475.67 | 475.67 | 475.67 | 475.67 | 100.0 |
| 2021-12-31 04:40:00 | SPY | ETF | 475.77 | 475.83 | 475.77 | 475.79 | 800.0 |
| 2021-12-31 05:00:00 | SPY | ETF | 475.88 | 475.88 | 475.88 | 475.88 | 100.0 |
| 2021-12-31 05:05:00 | SPY | ETF | 475.75 | 475.75 | 475.75 | 475.75 | 1265.0 |
| 2021-12-31 05:10:00 | SPY | ETF | 475.7 | 475.7 | 475.7 | 475.7 | 100.0 |
| 2021-12-31 05:20:00 | SPY | ETF | 475.7 | 475.7 | 475.7 | 475.7 | 356.0 |
| 2021-12-31 05:25:00 | SPY | ETF | 475.74 | 475.74 | 475.74 | 475.74 | 100.0 |
| 2021-12-31 05:30:00 | SPY | ETF | 475.79 | 475.82 | 475.79 | 475.82 | 380.0 |
| 2021-12-31 05:35:00 | SPY | ETF | 475.75 | 475.75 | 475.75 | 475.75 | 100.0 |
| 2021-12-31 05:40:00 | SPY | ETF | 475.7 | 475.7 | 475.52 | 475.52 | 1975.0 |
| 2021-12-31 05:45:00 | SPY | ETF | 475.5 | 475.51 | 475.43 | 475.43 | 3160.0 |
| 2021-12-31 05:50:00 | SPY | ETF | 475.47 | 475.47 | 475.47 | 475.47 | 200.0 |
| 2021-12-31 05:55:00 | SPY | ETF | 475.57 | 475.57 | 475.51 | 475.51 | 300.0 |
| 2021-12-31 06:00:00 | SPY | ETF | 475.48 | 475.56 | 475.48 | 475.56 | 1848.0 |
| 2021-12-31 06:05:00 | SPY | ETF | 475.41 | 475.41 | 475.11 | 475.17 | 14157.0 |
| 2021-12-31 06:10:00 | SPY | ETF | 475.09 | 475.23 | 475.09 | 475.22 | 2914.0 |
| 2021-12-31 06:15:00 | SPY | ETF | 475.33 | 475.36 | 475.3 | 475.3 | 5014.0 |
| 2021-12-31 06:20:00 | SPY | ETF | 475.35 | 475.39 | 475.34 | 475.39 | 1513.0 |
| 2021-12-31 06:25:00 | SPY | ETF | 475.31 | 475.42 | 475.3 | 475.42 | 4861.0 |
| 2021-12-31 06:30:00 | SPY | ETF | 475.43 | 475.43 | 475.43 | 475.43 | 100.0 |
| 2021-12-31 06:35:00 | SPY | ETF | 475.3 | 475.33 | 475.3 | 475.32 | 6886.0 |
| 2021-12-31 06:40:00 | SPY | ETF | 475.36 | 475.39 | 475.36 | 475.39 | 3967.0 |
| 2021-12-31 06:45:00 | SPY | ETF | 475.33 | 475.34 | 475.3 | 475.3 | 21568.0 |
| 2021-12-31 06:50:00 | SPY | ETF | 475.3 | 475.31 | 475.11 | 475.11 | 4280.0 |
| 2021-12-31 06:55:00 | SPY | ETF | 475.01 | 475.07 | 474.96 | 475.07 | 32984.0 |
| 2021-12-31 07:00:00 | SPY | ETF | 475.06 | 475.09 | 474.85 | 474.87 | 7927.0 |
| 2021-12-31 07:05:00 | SPY | ETF | 474.87 | 474.87 | 474.69 | 474.73 | 54323.0 |
| 2021-12-31 07:10:00 | SPY | ETF | 474.72 | 474.97 | 474.72 | 474.94 | 8999.0 |
| 2021-12-31 07:15:00 | SPY | ETF | 474.96 | 475.1 | 474.96 | 475.08 | 10731.0 |
| 2021-12-31 07:20:00 | SPY | ETF | 475.12 | 475.24 | 475.12 | 475.24 | 3470.0 |
| 2021-12-31 07:25:00 | SPY | ETF | 475.27 | 475.43 | 475.27 | 475.43 | 6182.0 |
| 2021-12-31 07:30:00 | SPY | ETF | 475.42 | 475.49 | 475.41 | 475.46 | 2300.0 |
| 2021-12-31 07:35:00 | SPY | ETF | 475.4 | 475.44 | 475.38 | 475.38 | 1000.0 |
| 2021-12-31 07:40:00 | SPY | ETF | 475.41 | 475.75 | 475.4 | 475.75 | 6228.0 |
| 2021-12-31 07:45:00 | SPY | ETF | 475.75 | 475.75 | 475.69 | 475.69 | 2794.0 |
| 2021-12-31 07:50:00 | SPY | ETF | 475.7 | 475.75 | 475.59 | 475.7 | 14733.0 |
| 2021-12-31 07:55:00 | SPY | ETF | 475.75 | 475.77 | 475.65 | 475.66 | 3500.0 |
| 2021-12-31 08:00:00 | SPY | ETF | 475.6796 | 476.0 | 474.79 | 475.58 | 33259.0 |
| 2021-12-31 08:05:00 | SPY | ETF | 475.61 | 475.61 | 475.52 | 475.55 | 2195.0 |
| 2021-12-31 08:10:00 | SPY | ETF | 475.61 | 475.68 | 475.57 | 475.57 | 3324.0 |
| 2021-12-31 08:15:00 | SPY | ETF | 475.56 | 475.7 | 475.55 | 475.63 | 7259.0 |
| 2021-12-31 08:20:00 | SPY | ETF | 475.61 | 475.65 | 475.57 | 475.62 | 1570.0 |
| 2021-12-31 08:25:00 | SPY | ETF | 475.64 | 475.68 | 475.64 | 475.66 | 3689.0 |
| 2021-12-31 08:30:00 | SPY | ETF | 475.65 | 475.7 | 475.62 | 475.62 | 2813.0 |
> showing 50 of 83,926 rows — these rows as CSV