PREVIEW / etf_1min / 2021-12-20
file: by_date/etf_1min/2021/2021-12-20.parquet size: 4.8 MB rows: 269,120
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-20 04:00:00 | SPY | ETF | 453.6 | 458.1 | 452.61 | 452.66 | 17886.0 |
| 2021-12-20 04:01:00 | SPY | ETF | 452.6 | 452.67 | 452.41 | 452.63 | 4350.0 |
| 2021-12-20 04:02:00 | SPY | ETF | 452.66 | 452.66 | 452.41 | 452.49 | 10514.0 |
| 2021-12-20 04:03:00 | SPY | ETF | 452.5 | 452.5 | 452.3 | 452.3 | 14349.0 |
| 2021-12-20 04:04:00 | SPY | ETF | 452.33 | 452.42 | 452.23 | 452.38 | 10507.0 |
| 2021-12-20 04:05:00 | SPY | ETF | 452.24 | 452.24 | 452.05 | 452.11 | 5368.0 |
| 2021-12-20 04:06:00 | SPY | ETF | 452.09 | 452.09 | 451.83 | 451.86 | 4500.0 |
| 2021-12-20 04:07:00 | SPY | ETF | 451.82 | 452.05 | 451.82 | 451.94 | 10620.0 |
| 2021-12-20 04:08:00 | SPY | ETF | 452.06 | 452.17 | 451.88 | 452.13 | 12719.0 |
| 2021-12-20 04:09:00 | SPY | ETF | 452.13 | 452.15 | 452.0 | 452.06 | 7165.0 |
| 2021-12-20 04:10:00 | SPY | ETF | 452.06 | 452.18 | 452.06 | 452.18 | 9911.0 |
| 2021-12-20 04:11:00 | SPY | ETF | 452.2 | 452.29 | 452.2 | 452.29 | 3086.0 |
| 2021-12-20 04:12:00 | SPY | ETF | 452.36 | 452.36 | 452.1 | 452.1 | 27751.0 |
| 2021-12-20 04:13:00 | SPY | ETF | 452.17 | 452.21 | 452.11 | 452.13 | 600.0 |
| 2021-12-20 04:14:00 | SPY | ETF | 452.02 | 452.02 | 451.8 | 451.8 | 3496.0 |
| 2021-12-20 04:15:00 | SPY | ETF | 451.76 | 451.94 | 451.76 | 451.92 | 6930.0 |
| 2021-12-20 04:16:00 | SPY | ETF | 451.91 | 451.91 | 451.8 | 451.9 | 4581.0 |
| 2021-12-20 04:17:00 | SPY | ETF | 451.83 | 452.07 | 451.83 | 452.07 | 12594.0 |
| 2021-12-20 04:18:00 | SPY | ETF | 451.91 | 451.95 | 451.91 | 451.95 | 2923.0 |
| 2021-12-20 04:19:00 | SPY | ETF | 451.94 | 451.94 | 451.94 | 451.94 | 500.0 |
| 2021-12-20 04:20:00 | SPY | ETF | 451.83 | 451.9 | 451.82 | 451.9 | 1700.0 |
| 2021-12-20 04:21:00 | SPY | ETF | 451.76 | 451.76 | 451.76 | 451.76 | 300.0 |
| 2021-12-20 04:22:00 | SPY | ETF | 452.07 | 452.21 | 452.04 | 452.12 | 2033.0 |
| 2021-12-20 04:23:00 | SPY | ETF | 452.2 | 452.2 | 452.01 | 452.16 | 1119.0 |
| 2021-12-20 04:24:00 | SPY | ETF | 452.17 | 452.21 | 452.12 | 452.18 | 1837.0 |
| 2021-12-20 04:25:00 | SPY | ETF | 452.13 | 452.13 | 452.07 | 452.07 | 2400.0 |
| 2021-12-20 04:26:00 | SPY | ETF | 451.99 | 451.99 | 451.91 | 451.94 | 584.0 |
| 2021-12-20 04:27:00 | SPY | ETF | 451.89 | 451.89 | 451.89 | 451.89 | 100.0 |
| 2021-12-20 04:28:00 | SPY | ETF | 451.8 | 451.89 | 451.8 | 451.89 | 237.0 |
| 2021-12-20 04:29:00 | SPY | ETF | 452.0 | 452.11 | 452.0 | 452.02 | 1419.0 |
| 2021-12-20 04:30:00 | SPY | ETF | 452.12 | 452.57 | 452.12 | 452.46 | 11935.0 |
| 2021-12-20 04:31:00 | SPY | ETF | 452.39 | 452.46 | 452.39 | 452.46 | 2896.0 |
| 2021-12-20 04:32:00 | SPY | ETF | 452.49 | 452.71 | 452.49 | 452.68 | 7156.0 |
| 2021-12-20 04:33:00 | SPY | ETF | 452.68 | 452.76 | 452.68 | 452.76 | 1960.0 |
| 2021-12-20 04:34:00 | SPY | ETF | 452.53 | 452.53 | 452.53 | 452.53 | 1162.0 |
| 2021-12-20 04:36:00 | SPY | ETF | 452.41 | 452.59 | 452.41 | 452.59 | 1300.0 |
| 2021-12-20 04:37:00 | SPY | ETF | 452.72 | 452.8 | 452.71 | 452.8 | 690.0 |
| 2021-12-20 04:38:00 | SPY | ETF | 452.81 | 452.81 | 452.81 | 452.81 | 300.0 |
| 2021-12-20 04:39:00 | SPY | ETF | 452.46 | 452.52 | 452.46 | 452.51 | 999.0 |
| 2021-12-20 04:44:00 | SPY | ETF | 452.82 | 452.82 | 452.76 | 452.76 | 200.0 |
| 2021-12-20 04:45:00 | SPY | ETF | 452.79 | 452.79 | 452.63 | 452.63 | 602.0 |
| 2021-12-20 04:46:00 | SPY | ETF | 452.7 | 452.7 | 452.69 | 452.69 | 500.0 |
| 2021-12-20 04:47:00 | SPY | ETF | 452.58 | 452.58 | 452.53 | 452.53 | 264.0 |
| 2021-12-20 04:48:00 | SPY | ETF | 452.61 | 452.61 | 452.61 | 452.61 | 1037.0 |
| 2021-12-20 04:50:00 | SPY | ETF | 452.56 | 452.57 | 452.45 | 452.45 | 800.0 |
| 2021-12-20 04:51:00 | SPY | ETF | 452.4 | 452.4 | 452.3 | 452.3 | 1442.0 |
| 2021-12-20 04:52:00 | SPY | ETF | 452.32 | 452.32 | 452.32 | 452.32 | 2912.0 |
| 2021-12-20 04:54:00 | SPY | ETF | 452.34 | 452.34 | 452.34 | 452.34 | 100.0 |
| 2021-12-20 04:55:00 | SPY | ETF | 452.34 | 452.38 | 452.34 | 452.38 | 5193.0 |
| 2021-12-20 04:56:00 | SPY | ETF | 452.43 | 452.67 | 452.43 | 452.65 | 4862.0 |
> showing 50 of 269,120 rows — these rows as CSV