PREVIEW / etf_5min / 2020-02-13
file: by_date/etf_5min/2020/2020-02-13.parquet size: 1.6 MB rows: 66,965
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-02-13 04:00:00 | SPY | ETF | 336.1 | 336.1 | 335.96 | 335.97 | 5806.0 |
| 2020-02-13 04:05:00 | SPY | ETF | 335.99 | 336.08 | 335.84 | 335.84 | 3990.0 |
| 2020-02-13 04:10:00 | SPY | ETF | 335.96 | 336.04 | 335.96 | 336.04 | 350.0 |
| 2020-02-13 04:15:00 | SPY | ETF | 336.0 | 336.0 | 335.82 | 335.82 | 287.0 |
| 2020-02-13 04:20:00 | SPY | ETF | 335.89 | 335.89 | 335.8 | 335.8 | 2380.0 |
| 2020-02-13 04:25:00 | SPY | ETF | 335.76 | 335.77 | 335.61 | 335.62 | 2791.0 |
| 2020-02-13 04:30:00 | SPY | ETF | 335.68 | 335.68 | 335.63 | 335.66 | 1738.0 |
| 2020-02-13 04:35:00 | SPY | ETF | 335.62 | 335.66 | 335.62 | 335.66 | 1300.0 |
| 2020-02-13 04:40:00 | SPY | ETF | 335.62 | 335.64 | 335.57 | 335.64 | 1706.0 |
| 2020-02-13 04:45:00 | SPY | ETF | 335.69 | 335.69 | 335.58 | 335.58 | 200.0 |
| 2020-02-13 04:50:00 | SPY | ETF | 335.55 | 335.6 | 335.07 | 335.07 | 8051.0 |
| 2020-02-13 04:55:00 | SPY | ETF | 335.28 | 335.32 | 335.28 | 335.32 | 1479.0 |
| 2020-02-13 05:00:00 | SPY | ETF | 335.28 | 335.28 | 335.16 | 335.2 | 3217.0 |
| 2020-02-13 05:05:00 | SPY | ETF | 335.1 | 335.1 | 334.82 | 334.82 | 11406.0 |
| 2020-02-13 05:10:00 | SPY | ETF | 334.75 | 334.9 | 334.62 | 334.89 | 3568.0 |
| 2020-02-13 05:15:00 | SPY | ETF | 335.0 | 335.0 | 335.0 | 335.0 | 200.0 |
| 2020-02-13 05:20:00 | SPY | ETF | 335.05 | 335.16 | 335.05 | 335.16 | 1500.0 |
| 2020-02-13 05:25:00 | SPY | ETF | 335.26 | 335.52 | 335.22 | 335.36 | 11435.0 |
| 2020-02-13 05:30:00 | SPY | ETF | 335.34 | 335.45 | 335.34 | 335.44 | 1035.0 |
| 2020-02-13 05:35:00 | SPY | ETF | 335.31 | 335.31 | 335.29 | 335.3 | 1062.0 |
| 2020-02-13 05:40:00 | SPY | ETF | 335.26 | 335.26 | 335.26 | 335.26 | 500.0 |
| 2020-02-13 05:45:00 | SPY | ETF | 335.19 | 335.19 | 335.15 | 335.15 | 1733.0 |
| 2020-02-13 05:50:00 | SPY | ETF | 335.38 | 335.38 | 335.38 | 335.38 | 345.0 |
| 2020-02-13 05:55:00 | SPY | ETF | 335.29 | 335.29 | 335.25 | 335.25 | 450.0 |
| 2020-02-13 06:00:00 | SPY | ETF | 335.12 | 335.13 | 335.04 | 335.1 | 6820.0 |
| 2020-02-13 06:05:00 | SPY | ETF | 335.13 | 335.13 | 334.96 | 334.96 | 11000.0 |
| 2020-02-13 06:10:00 | SPY | ETF | 335.08 | 335.08 | 334.89 | 334.93 | 2394.0 |
| 2020-02-13 06:15:00 | SPY | ETF | 334.96 | 335.04 | 334.96 | 334.97 | 5725.0 |
| 2020-02-13 06:20:00 | SPY | ETF | 334.98 | 334.98 | 334.93 | 334.97 | 8606.0 |
| 2020-02-13 06:25:00 | SPY | ETF | 334.93 | 335.06 | 334.92 | 334.98 | 5560.0 |
| 2020-02-13 06:30:00 | SPY | ETF | 334.91 | 334.94 | 334.91 | 334.91 | 6015.0 |
| 2020-02-13 06:35:00 | SPY | ETF | 335.06 | 335.33 | 335.05 | 335.25 | 9694.0 |
| 2020-02-13 06:40:00 | SPY | ETF | 335.25 | 335.4 | 335.25 | 335.28 | 59591.0 |
| 2020-02-13 06:45:00 | SPY | ETF | 335.34 | 335.49 | 335.34 | 335.46 | 45550.0 |
| 2020-02-13 06:50:00 | SPY | ETF | 335.39 | 335.61 | 335.39 | 335.5 | 17881.0 |
| 2020-02-13 06:55:00 | SPY | ETF | 335.41 | 335.46 | 335.32 | 335.37 | 11480.0 |
| 2020-02-13 07:00:00 | SPY | ETF | 335.41 | 335.61 | 335.39 | 335.6 | 184479.0 |
| 2020-02-13 07:05:00 | SPY | ETF | 335.57 | 335.71 | 335.5 | 335.63 | 139211.0 |
| 2020-02-13 07:10:00 | SPY | ETF | 335.65 | 335.65 | 335.5 | 335.52 | 99010.0 |
| 2020-02-13 07:15:00 | SPY | ETF | 335.53 | 335.53 | 335.39 | 335.39 | 43891.0 |
| 2020-02-13 07:20:00 | SPY | ETF | 335.42 | 335.53 | 335.4 | 335.4 | 15493.0 |
| 2020-02-13 07:25:00 | SPY | ETF | 335.41 | 335.41 | 335.3 | 335.34 | 31410.0 |
| 2020-02-13 07:30:00 | SPY | ETF | 335.34 | 335.49 | 335.34 | 335.45 | 24273.0 |
| 2020-02-13 07:35:00 | SPY | ETF | 335.54 | 335.54 | 335.38 | 335.38 | 9176.0 |
| 2020-02-13 07:40:00 | SPY | ETF | 335.35 | 335.54 | 335.35 | 335.45 | 33513.0 |
| 2020-02-13 07:45:00 | SPY | ETF | 335.46 | 335.49 | 335.15 | 335.15 | 24946.0 |
| 2020-02-13 07:50:00 | SPY | ETF | 335.2 | 335.38 | 335.2 | 335.37 | 9342.0 |
| 2020-02-13 07:55:00 | SPY | ETF | 335.3 | 335.61 | 335.3 | 335.61 | 14627.0 |
| 2020-02-13 08:00:00 | SPY | ETF | 335.66 | 336.52 | 335.22 | 335.8 | 56953.0 |
| 2020-02-13 08:05:00 | SPY | ETF | 335.8 | 335.82 | 335.61 | 335.65 | 31767.0 |
> showing 50 of 66,965 rows — these rows as CSV