PREVIEW / etf_5min / 2021-12-02
file: by_date/etf_5min/2021/2021-12-02.parquet size: 1.9 MB rows: 92,929
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-02 04:00:00 | SPY | ETF | 453.1 | 453.79 | 453.1 | 453.79 | 28779.0 |
| 2021-12-02 04:05:00 | SPY | ETF | 453.79 | 453.93 | 453.77 | 453.87 | 14582.0 |
| 2021-12-02 04:10:00 | SPY | ETF | 453.94 | 454.19 | 453.88 | 454.19 | 13792.0 |
| 2021-12-02 04:15:00 | SPY | ETF | 454.23 | 454.61 | 454.17 | 454.5 | 12458.0 |
| 2021-12-02 04:20:00 | SPY | ETF | 454.49 | 454.53 | 454.26 | 454.53 | 8424.0 |
| 2021-12-02 04:25:00 | SPY | ETF | 454.49 | 454.61 | 454.13 | 454.13 | 7819.0 |
| 2021-12-02 04:30:00 | SPY | ETF | 454.08 | 454.08 | 453.76 | 453.76 | 3686.0 |
| 2021-12-02 04:35:00 | SPY | ETF | 453.64 | 453.94 | 453.56 | 453.94 | 10120.0 |
| 2021-12-02 04:40:00 | SPY | ETF | 453.91 | 454.07 | 453.73 | 453.78 | 3900.0 |
| 2021-12-02 04:45:00 | SPY | ETF | 453.73 | 453.9 | 453.64 | 453.65 | 22965.0 |
| 2021-12-02 04:50:00 | SPY | ETF | 453.44 | 453.79 | 453.41 | 453.79 | 23795.0 |
| 2021-12-02 04:55:00 | SPY | ETF | 453.83 | 454.0 | 453.79 | 454.0 | 3628.0 |
| 2021-12-02 05:00:00 | SPY | ETF | 453.96 | 454.04 | 453.62 | 453.7 | 7596.0 |
| 2021-12-02 05:05:00 | SPY | ETF | 453.6 | 453.84 | 453.57 | 453.66 | 6484.0 |
| 2021-12-02 05:10:00 | SPY | ETF | 453.56 | 453.56 | 452.83 | 452.83 | 6428.0 |
| 2021-12-02 05:15:00 | SPY | ETF | 452.49 | 452.64 | 452.39 | 452.64 | 9200.0 |
| 2021-12-02 05:20:00 | SPY | ETF | 452.9 | 453.05 | 452.38 | 453.0 | 4598.0 |
| 2021-12-02 05:25:00 | SPY | ETF | 453.24 | 453.35 | 453.07 | 453.07 | 2110.0 |
| 2021-12-02 05:30:00 | SPY | ETF | 453.01 | 453.2 | 452.97 | 453.2 | 11199.0 |
| 2021-12-02 05:35:00 | SPY | ETF | 453.41 | 453.92 | 453.31 | 453.61 | 10765.0 |
| 2021-12-02 05:40:00 | SPY | ETF | 453.86 | 453.86 | 453.68 | 453.78 | 3126.0 |
| 2021-12-02 05:45:00 | SPY | ETF | 453.9 | 453.91 | 453.77 | 453.91 | 3399.0 |
| 2021-12-02 05:50:00 | SPY | ETF | 453.89 | 453.89 | 453.45 | 453.82 | 2000.0 |
| 2021-12-02 05:55:00 | SPY | ETF | 453.76 | 453.76 | 453.54 | 453.58 | 1000.0 |
| 2021-12-02 06:00:00 | SPY | ETF | 453.51 | 453.51 | 453.3 | 453.3 | 1800.0 |
| 2021-12-02 06:05:00 | SPY | ETF | 453.5 | 453.6 | 453.48 | 453.6 | 3675.0 |
| 2021-12-02 06:10:00 | SPY | ETF | 453.65 | 453.65 | 453.37 | 453.65 | 3490.0 |
| 2021-12-02 06:15:00 | SPY | ETF | 453.41 | 453.42 | 453.05 | 453.06 | 7198.0 |
| 2021-12-02 06:20:00 | SPY | ETF | 453.08 | 453.27 | 453.06 | 453.21 | 2181.0 |
| 2021-12-02 06:25:00 | SPY | ETF | 453.14 | 453.41 | 453.14 | 453.22 | 13900.0 |
| 2021-12-02 06:30:00 | SPY | ETF | 453.25 | 453.56 | 453.25 | 453.26 | 3975.0 |
| 2021-12-02 06:35:00 | SPY | ETF | 453.16 | 453.17 | 452.91 | 453.02 | 7795.0 |
| 2021-12-02 06:40:00 | SPY | ETF | 453.26 | 453.26 | 453.0 | 453.05 | 3041.0 |
| 2021-12-02 06:45:00 | SPY | ETF | 453.14 | 453.35 | 453.14 | 453.34 | 25999.0 |
| 2021-12-02 06:50:00 | SPY | ETF | 453.3 | 453.42 | 453.3 | 453.3 | 740.0 |
| 2021-12-02 06:55:00 | SPY | ETF | 453.35 | 453.53 | 453.35 | 453.37 | 5682.0 |
| 2021-12-02 07:00:00 | SPY | ETF | 453.4 | 453.69 | 453.24 | 453.46 | 21697.0 |
| 2021-12-02 07:05:00 | SPY | ETF | 453.28 | 453.29 | 452.48 | 452.48 | 32087.0 |
| 2021-12-02 07:10:00 | SPY | ETF | 452.51 | 452.94 | 452.35 | 452.57 | 36577.0 |
| 2021-12-02 07:15:00 | SPY | ETF | 452.55 | 452.63 | 452.06 | 452.2 | 46247.0 |
| 2021-12-02 07:20:00 | SPY | ETF | 452.15 | 452.3 | 451.98 | 452.13 | 21253.0 |
| 2021-12-02 07:25:00 | SPY | ETF | 452.16 | 452.16 | 451.24 | 451.61 | 51812.0 |
| 2021-12-02 07:30:00 | SPY | ETF | 451.56 | 451.7 | 451.36 | 451.48 | 24094.0 |
| 2021-12-02 07:35:00 | SPY | ETF | 451.4 | 451.64 | 451.34 | 451.41 | 28732.0 |
| 2021-12-02 07:40:00 | SPY | ETF | 451.41 | 451.41 | 450.66 | 450.94 | 80248.0 |
| 2021-12-02 07:45:00 | SPY | ETF | 450.9 | 451.23 | 450.9 | 451.23 | 20559.0 |
| 2021-12-02 07:50:00 | SPY | ETF | 451.179 | 451.8 | 451.16 | 451.8 | 66775.0 |
| 2021-12-02 07:55:00 | SPY | ETF | 451.74 | 452.16 | 451.74 | 452.05 | 136141.0 |
| 2021-12-02 08:00:00 | SPY | ETF | 451.98 | 454.0 | 450.69 | 452.5 | 137960.0 |
| 2021-12-02 08:05:00 | SPY | ETF | 452.5 | 453.9 | 452.28 | 452.78 | 84818.0 |
> showing 50 of 92,929 rows — these rows as CSV