PREVIEW / etf_5min / 2020-12-24
file: by_date/etf_5min/2020/2020-12-24.parquet size: 1.0 MB rows: 44,307
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 |
|---|---|---|---|---|---|---|---|
| 2020-12-24 04:00:00 | SPY | ETF | 368.36 | 368.47 | 368.36 | 368.47 | 774.0 |
| 2020-12-24 04:05:00 | SPY | ETF | 368.47 | 368.47 | 368.44 | 368.44 | 2051.0 |
| 2020-12-24 04:15:00 | SPY | ETF | 368.49 | 368.58 | 368.49 | 368.58 | 958.0 |
| 2020-12-24 04:25:00 | SPY | ETF | 368.5 | 368.57 | 368.5 | 368.57 | 1925.0 |
| 2020-12-24 04:30:00 | SPY | ETF | 368.57 | 368.57 | 368.54 | 368.54 | 1100.0 |
| 2020-12-24 04:35:00 | SPY | ETF | 368.51 | 368.54 | 368.51 | 368.54 | 495.0 |
| 2020-12-24 04:45:00 | SPY | ETF | 368.51 | 368.51 | 368.51 | 368.51 | 200.0 |
| 2020-12-24 05:15:00 | SPY | ETF | 368.64 | 368.64 | 368.64 | 368.64 | 101.0 |
| 2020-12-24 05:25:00 | SPY | ETF | 368.57 | 368.57 | 368.56 | 368.56 | 1100.0 |
| 2020-12-24 05:30:00 | SPY | ETF | 368.58 | 368.58 | 368.58 | 368.58 | 155.0 |
| 2020-12-24 05:40:00 | SPY | ETF | 368.61 | 368.61 | 368.6 | 368.61 | 1251.0 |
| 2020-12-24 05:45:00 | SPY | ETF | 368.6 | 368.6 | 368.59 | 368.6 | 302.0 |
| 2020-12-24 05:50:00 | SPY | ETF | 368.59 | 368.59 | 368.59 | 368.59 | 212.0 |
| 2020-12-24 05:55:00 | SPY | ETF | 368.57 | 368.61 | 368.57 | 368.59 | 2070.0 |
| 2020-12-24 06:00:00 | SPY | ETF | 368.56 | 368.57 | 368.56 | 368.57 | 200.0 |
| 2020-12-24 06:05:00 | SPY | ETF | 368.47 | 368.47 | 368.36 | 368.36 | 711.0 |
| 2020-12-24 06:15:00 | SPY | ETF | 368.38 | 368.38 | 368.38 | 368.38 | 100.0 |
| 2020-12-24 06:20:00 | SPY | ETF | 368.5 | 368.5 | 368.45 | 368.47 | 3735.0 |
| 2020-12-24 06:25:00 | SPY | ETF | 368.4 | 368.4 | 368.35 | 368.35 | 230.0 |
| 2020-12-24 06:40:00 | SPY | ETF | 368.36 | 368.4 | 368.36 | 368.4 | 945.0 |
| 2020-12-24 06:45:00 | SPY | ETF | 368.4 | 368.47 | 368.4 | 368.41 | 11148.0 |
| 2020-12-24 06:50:00 | SPY | ETF | 368.42 | 368.47 | 368.42 | 368.46 | 300.0 |
| 2020-12-24 07:00:00 | SPY | ETF | 368.44 | 368.44 | 368.32 | 368.32 | 6248.0 |
| 2020-12-24 07:05:00 | SPY | ETF | 368.27 | 368.38 | 368.27 | 368.34 | 4013.0 |
| 2020-12-24 07:10:00 | SPY | ETF | 368.3 | 368.34 | 368.28 | 368.33 | 2747.0 |
| 2020-12-24 07:15:00 | SPY | ETF | 368.33 | 368.33 | 368.29 | 368.32 | 1335.0 |
| 2020-12-24 07:20:00 | SPY | ETF | 368.33 | 368.36 | 368.33 | 368.33 | 5483.0 |
| 2020-12-24 07:25:00 | SPY | ETF | 368.32 | 368.32 | 368.28 | 368.28 | 2140.0 |
| 2020-12-24 07:30:00 | SPY | ETF | 368.33 | 368.33 | 368.16 | 368.16 | 1659.0 |
| 2020-12-24 07:35:00 | SPY | ETF | 368.14 | 368.14 | 367.93 | 368.05 | 9981.0 |
| 2020-12-24 07:40:00 | SPY | ETF | 367.99 | 368.14 | 367.99 | 368.06 | 1818.0 |
| 2020-12-24 07:45:00 | SPY | ETF | 368.12 | 368.19 | 368.11 | 368.19 | 970.0 |
| 2020-12-24 07:50:00 | SPY | ETF | 368.19 | 368.19 | 368.15 | 368.17 | 1422.0 |
| 2020-12-24 07:55:00 | SPY | ETF | 368.25 | 368.25 | 368.19 | 368.19 | 3880.0 |
| 2020-12-24 08:00:00 | SPY | ETF | 368.29 | 368.38 | 367.97 | 368.16 | 61448.0 |
| 2020-12-24 08:05:00 | SPY | ETF | 368.1 | 368.2 | 368.09 | 368.09 | 15689.0 |
| 2020-12-24 08:10:00 | SPY | ETF | 368.11 | 368.15 | 368.04 | 368.15 | 15631.0 |
| 2020-12-24 08:15:00 | SPY | ETF | 368.15 | 368.23 | 368.07 | 368.23 | 5807.0 |
| 2020-12-24 08:20:00 | SPY | ETF | 368.21 | 368.21 | 368.12 | 368.19 | 3342.0 |
| 2020-12-24 08:25:00 | SPY | ETF | 368.19 | 368.23 | 368.18 | 368.22 | 11193.0 |
| 2020-12-24 08:30:00 | SPY | ETF | 368.18 | 368.25 | 368.18 | 368.25 | 2296.0 |
| 2020-12-24 08:35:00 | SPY | ETF | 368.25 | 368.25 | 368.15 | 368.19 | 6746.0 |
| 2020-12-24 08:40:00 | SPY | ETF | 368.16 | 368.2 | 368.16 | 368.17 | 2239.0 |
| 2020-12-24 08:45:00 | SPY | ETF | 368.18 | 368.18 | 368.03 | 368.1 | 6963.0 |
| 2020-12-24 08:50:00 | SPY | ETF | 368.1 | 368.15 | 368.08 | 368.15 | 4281.0 |
| 2020-12-24 08:55:00 | SPY | ETF | 368.15 | 368.16 | 368.1 | 368.16 | 6592.0 |
| 2020-12-24 09:00:00 | SPY | ETF | 368.15 | 368.18 | 368.1 | 368.16 | 6441.0 |
| 2020-12-24 09:05:00 | SPY | ETF | 368.13 | 368.13 | 368.04 | 368.06 | 18388.0 |
| 2020-12-24 09:10:00 | SPY | ETF | 368.03 | 368.1 | 368.0 | 368.04 | 13593.0 |
| 2020-12-24 09:15:00 | SPY | ETF | 368.05 | 368.07 | 367.99 | 367.99 | 6485.0 |
> showing 50 of 44,307 rows — these rows as CSV