PREVIEW / etf_5min / 2021-12-06
file: by_date/etf_5min/2021/2021-12-06.parquet size: 1.9 MB rows: 91,193
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-06 04:00:00 | SPY | ETF | 455.5 | 456.81 | 455.5 | 456.53 | 10423.0 |
| 2021-12-06 04:05:00 | SPY | ETF | 456.6 | 456.66 | 456.15 | 456.15 | 4638.0 |
| 2021-12-06 04:10:00 | SPY | ETF | 456.29 | 456.57 | 456.25 | 456.57 | 2550.0 |
| 2021-12-06 04:15:00 | SPY | ETF | 456.52 | 456.61 | 456.43 | 456.5 | 6982.0 |
| 2021-12-06 04:20:00 | SPY | ETF | 456.47 | 456.5 | 456.3 | 456.34 | 5800.0 |
| 2021-12-06 04:25:00 | SPY | ETF | 456.49 | 456.62 | 456.49 | 456.62 | 1421.0 |
| 2021-12-06 04:30:00 | SPY | ETF | 456.65 | 456.65 | 456.35 | 456.46 | 2747.0 |
| 2021-12-06 04:35:00 | SPY | ETF | 456.49 | 456.49 | 455.81 | 455.91 | 7920.0 |
| 2021-12-06 04:40:00 | SPY | ETF | 455.88 | 455.88 | 455.56 | 455.56 | 4902.0 |
| 2021-12-06 04:45:00 | SPY | ETF | 455.38 | 455.38 | 455.04 | 455.24 | 11340.0 |
| 2021-12-06 04:50:00 | SPY | ETF | 455.24 | 455.3 | 454.99 | 454.99 | 12660.0 |
| 2021-12-06 04:55:00 | SPY | ETF | 454.99 | 455.02 | 454.3 | 454.4 | 27664.0 |
| 2021-12-06 05:00:00 | SPY | ETF | 454.51 | 454.53 | 454.2 | 454.34 | 37280.0 |
| 2021-12-06 05:05:00 | SPY | ETF | 454.4 | 454.4 | 454.4 | 454.4 | 1393.0 |
| 2021-12-06 05:10:00 | SPY | ETF | 454.28 | 454.68 | 454.28 | 454.66 | 2309.0 |
| 2021-12-06 05:15:00 | SPY | ETF | 454.62 | 454.76 | 454.48 | 454.69 | 1891.0 |
| 2021-12-06 05:20:00 | SPY | ETF | 454.52 | 454.52 | 454.45 | 454.45 | 1600.0 |
| 2021-12-06 05:25:00 | SPY | ETF | 454.0 | 454.03 | 453.32 | 453.48 | 6948.0 |
| 2021-12-06 05:30:00 | SPY | ETF | 453.38 | 453.63 | 453.06 | 453.63 | 2308.0 |
| 2021-12-06 05:35:00 | SPY | ETF | 453.61 | 453.71 | 453.44 | 453.46 | 2239.0 |
| 2021-12-06 05:40:00 | SPY | ETF | 453.44 | 453.5 | 453.0 | 453.22 | 20790.0 |
| 2021-12-06 05:45:00 | SPY | ETF | 453.37 | 453.54 | 453.29 | 453.51 | 3381.0 |
| 2021-12-06 05:50:00 | SPY | ETF | 453.29 | 453.45 | 453.06 | 453.06 | 29965.0 |
| 2021-12-06 05:55:00 | SPY | ETF | 453.17 | 453.17 | 453.01 | 453.04 | 1841.0 |
| 2021-12-06 06:00:00 | SPY | ETF | 453.24 | 453.52 | 453.24 | 453.42 | 3966.0 |
| 2021-12-06 06:05:00 | SPY | ETF | 453.37 | 453.84 | 453.37 | 453.84 | 7530.0 |
| 2021-12-06 06:10:00 | SPY | ETF | 453.82 | 453.89 | 453.64 | 453.87 | 11278.0 |
| 2021-12-06 06:15:00 | SPY | ETF | 453.97 | 454.14 | 453.95 | 454.07 | 10753.0 |
| 2021-12-06 06:20:00 | SPY | ETF | 454.17 | 454.34 | 454.14 | 454.22 | 20325.0 |
| 2021-12-06 06:25:00 | SPY | ETF | 454.22 | 454.22 | 453.89 | 453.89 | 2167.0 |
| 2021-12-06 06:30:00 | SPY | ETF | 454.02 | 454.34 | 454.02 | 454.02 | 4195.0 |
| 2021-12-06 06:35:00 | SPY | ETF | 454.16 | 454.17 | 454.14 | 454.14 | 2908.0 |
| 2021-12-06 06:40:00 | SPY | ETF | 454.19 | 454.57 | 454.12 | 454.54 | 14395.0 |
| 2021-12-06 06:45:00 | SPY | ETF | 454.55 | 454.82 | 454.4 | 454.4 | 10385.0 |
| 2021-12-06 06:50:00 | SPY | ETF | 454.35 | 454.65 | 454.35 | 454.6 | 17559.0 |
| 2021-12-06 06:55:00 | SPY | ETF | 454.8 | 455.3 | 454.77 | 455.29 | 29727.0 |
| 2021-12-06 07:00:00 | SPY | ETF | 455.34 | 455.5 | 455.06 | 455.16 | 21732.0 |
| 2021-12-06 07:05:00 | SPY | ETF | 455.14 | 455.35 | 454.83 | 455.0 | 23833.0 |
| 2021-12-06 07:10:00 | SPY | ETF | 454.98 | 455.13 | 454.84 | 454.98 | 24309.0 |
| 2021-12-06 07:15:00 | SPY | ETF | 454.97 | 454.97 | 454.51 | 454.51 | 24719.0 |
| 2021-12-06 07:20:00 | SPY | ETF | 454.52 | 454.69 | 454.36 | 454.69 | 38566.0 |
| 2021-12-06 07:25:00 | SPY | ETF | 454.74 | 454.74 | 454.58 | 454.59 | 9916.0 |
| 2021-12-06 07:30:00 | SPY | ETF | 454.5 | 454.53 | 454.38 | 454.46 | 13151.0 |
| 2021-12-06 07:35:00 | SPY | ETF | 454.48 | 454.76 | 454.48 | 454.76 | 23357.0 |
| 2021-12-06 07:40:00 | SPY | ETF | 454.84 | 454.89 | 454.78 | 454.79 | 6871.0 |
| 2021-12-06 07:45:00 | SPY | ETF | 454.81 | 454.84 | 454.76 | 454.81 | 11993.0 |
| 2021-12-06 07:50:00 | SPY | ETF | 454.86 | 454.96 | 454.42 | 454.61 | 30250.0 |
| 2021-12-06 07:55:00 | SPY | ETF | 454.61 | 454.79 | 454.56 | 454.61 | 10059.0 |
| 2021-12-06 08:00:00 | SPY | ETF | 454.68 | 456.4004 | 453.4204 | 454.7 | 36208.0 |
| 2021-12-06 08:05:00 | SPY | ETF | 454.6 | 454.94 | 454.53 | 454.89 | 29406.0 |
> showing 50 of 91,193 rows — these rows as CSV