PREVIEW / etf_5min / 2020-11-13
file: by_date/etf_5min/2020/2020-11-13.parquet size: 1.6 MB rows: 73,863
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-11-13 04:00:00 | SPY | ETF | 355.1 | 355.27 | 354.99 | 355.22 | 10413.0 |
| 2020-11-13 04:05:00 | SPY | ETF | 355.26 | 355.32 | 355.26 | 355.32 | 1961.0 |
| 2020-11-13 04:10:00 | SPY | ETF | 355.35 | 355.35 | 355.18 | 355.18 | 3047.0 |
| 2020-11-13 04:15:00 | SPY | ETF | 355.43 | 355.5 | 355.43 | 355.5 | 4522.0 |
| 2020-11-13 04:20:00 | SPY | ETF | 355.66 | 355.66 | 355.46 | 355.58 | 10272.0 |
| 2020-11-13 04:25:00 | SPY | ETF | 355.51 | 355.58 | 355.49 | 355.53 | 2260.0 |
| 2020-11-13 04:30:00 | SPY | ETF | 355.69 | 356.3 | 355.69 | 356.11 | 16620.0 |
| 2020-11-13 04:35:00 | SPY | ETF | 356.01 | 356.03 | 355.96 | 355.96 | 3718.0 |
| 2020-11-13 04:40:00 | SPY | ETF | 355.96 | 356.0 | 355.94 | 355.94 | 3501.0 |
| 2020-11-13 04:45:00 | SPY | ETF | 356.0 | 356.23 | 355.93 | 356.13 | 6532.0 |
| 2020-11-13 04:50:00 | SPY | ETF | 356.26 | 356.37 | 356.24 | 356.36 | 3445.0 |
| 2020-11-13 04:55:00 | SPY | ETF | 356.36 | 356.36 | 356.32 | 356.32 | 732.0 |
| 2020-11-13 05:00:00 | SPY | ETF | 356.28 | 356.39 | 356.23 | 356.23 | 1747.0 |
| 2020-11-13 05:05:00 | SPY | ETF | 356.33 | 356.43 | 356.33 | 356.35 | 44415.0 |
| 2020-11-13 05:10:00 | SPY | ETF | 356.27 | 356.29 | 356.14 | 356.26 | 21011.0 |
| 2020-11-13 05:15:00 | SPY | ETF | 356.24 | 356.8 | 356.24 | 356.78 | 31412.0 |
| 2020-11-13 05:20:00 | SPY | ETF | 356.57 | 356.57 | 356.49 | 356.55 | 7084.0 |
| 2020-11-13 05:25:00 | SPY | ETF | 356.27 | 356.27 | 356.23 | 356.25 | 2150.0 |
| 2020-11-13 05:30:00 | SPY | ETF | 356.15 | 356.2 | 356.06 | 356.06 | 2325.0 |
| 2020-11-13 05:35:00 | SPY | ETF | 356.1 | 356.17 | 356.1 | 356.17 | 4600.0 |
| 2020-11-13 05:40:00 | SPY | ETF | 356.19 | 356.36 | 356.19 | 356.35 | 12042.0 |
| 2020-11-13 05:45:00 | SPY | ETF | 356.32 | 356.4 | 356.32 | 356.36 | 17690.0 |
| 2020-11-13 05:50:00 | SPY | ETF | 356.38 | 356.56 | 356.38 | 356.56 | 24603.0 |
| 2020-11-13 05:55:00 | SPY | ETF | 356.4 | 356.41 | 356.32 | 356.32 | 4570.0 |
| 2020-11-13 06:00:00 | SPY | ETF | 356.44 | 356.45 | 356.05 | 356.05 | 2465.0 |
| 2020-11-13 06:05:00 | SPY | ETF | 356.02 | 356.05 | 355.98 | 356.03 | 2119.0 |
| 2020-11-13 06:10:00 | SPY | ETF | 356.05 | 356.19 | 355.96 | 355.96 | 3905.0 |
| 2020-11-13 06:15:00 | SPY | ETF | 355.96 | 355.96 | 355.82 | 355.82 | 1841.0 |
| 2020-11-13 06:20:00 | SPY | ETF | 355.91 | 355.91 | 355.53 | 355.7 | 6472.0 |
| 2020-11-13 06:25:00 | SPY | ETF | 355.67 | 355.83 | 355.67 | 355.78 | 3718.0 |
| 2020-11-13 06:30:00 | SPY | ETF | 355.75 | 355.92 | 355.75 | 355.85 | 37266.0 |
| 2020-11-13 06:35:00 | SPY | ETF | 355.75 | 355.8 | 355.69 | 355.75 | 21672.0 |
| 2020-11-13 06:40:00 | SPY | ETF | 355.75 | 355.9 | 355.56 | 355.56 | 35694.0 |
| 2020-11-13 06:45:00 | SPY | ETF | 355.56 | 355.58 | 355.38 | 355.38 | 38995.0 |
| 2020-11-13 06:50:00 | SPY | ETF | 355.75 | 355.83 | 355.6 | 355.81 | 16182.0 |
| 2020-11-13 06:55:00 | SPY | ETF | 355.82 | 355.97 | 355.8 | 355.8 | 40215.0 |
| 2020-11-13 07:00:00 | SPY | ETF | 355.87 | 355.9 | 355.55 | 355.55 | 37671.0 |
| 2020-11-13 07:05:00 | SPY | ETF | 355.59 | 355.74 | 355.53 | 355.55 | 12792.0 |
| 2020-11-13 07:10:00 | SPY | ETF | 355.51 | 355.55 | 355.44 | 355.51 | 14214.0 |
| 2020-11-13 07:15:00 | SPY | ETF | 355.47 | 355.71 | 355.44 | 355.65 | 23453.0 |
| 2020-11-13 07:20:00 | SPY | ETF | 355.65 | 355.76 | 355.51 | 355.76 | 21521.0 |
| 2020-11-13 07:25:00 | SPY | ETF | 355.74 | 355.76 | 355.54 | 355.67 | 13511.0 |
| 2020-11-13 07:30:00 | SPY | ETF | 355.7 | 355.91 | 355.65 | 355.86 | 22108.0 |
| 2020-11-13 07:35:00 | SPY | ETF | 355.9 | 355.95 | 355.75 | 355.83 | 79546.0 |
| 2020-11-13 07:40:00 | SPY | ETF | 355.82 | 355.87 | 355.75 | 355.75 | 28889.0 |
| 2020-11-13 07:45:00 | SPY | ETF | 355.75 | 355.75 | 355.53 | 355.54 | 14498.0 |
| 2020-11-13 07:50:00 | SPY | ETF | 355.58 | 355.67 | 355.51 | 355.59 | 54378.0 |
| 2020-11-13 07:55:00 | SPY | ETF | 355.58 | 355.6 | 355.36 | 355.39 | 7475.0 |
| 2020-11-13 08:00:00 | SPY | ETF | 355.46 | 355.88 | 353.39 | 355.412 | 67692.0 |
| 2020-11-13 08:05:00 | SPY | ETF | 355.46 | 355.61 | 355.42 | 355.51 | 22422.0 |
> showing 50 of 73,863 rows — these rows as CSV