PREVIEW / etf_5min / 2020-08-14
file: by_date/etf_5min/2020/2020-08-14.parquet size: 1.5 MB rows: 69,136
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-08-14 04:00:00 | SPY | ETF | 336.19 | 336.22 | 335.85 | 335.85 | 9747.0 |
| 2020-08-14 04:05:00 | SPY | ETF | 335.97 | 335.99 | 335.59 | 335.62 | 6725.0 |
| 2020-08-14 04:10:00 | SPY | ETF | 335.55 | 335.6 | 335.3 | 335.6 | 3754.0 |
| 2020-08-14 04:15:00 | SPY | ETF | 335.57 | 335.58 | 335.26 | 335.29 | 6970.0 |
| 2020-08-14 04:20:00 | SPY | ETF | 335.25 | 335.3 | 335.14 | 335.18 | 1963.0 |
| 2020-08-14 04:25:00 | SPY | ETF | 335.15 | 335.46 | 335.15 | 335.46 | 1787.0 |
| 2020-08-14 04:30:00 | SPY | ETF | 335.41 | 335.41 | 335.3 | 335.3 | 1572.0 |
| 2020-08-14 04:35:00 | SPY | ETF | 335.24 | 335.55 | 335.24 | 335.41 | 1501.0 |
| 2020-08-14 04:40:00 | SPY | ETF | 335.33 | 335.4 | 335.33 | 335.4 | 1067.0 |
| 2020-08-14 04:45:00 | SPY | ETF | 335.1 | 335.19 | 335.1 | 335.19 | 5227.0 |
| 2020-08-14 04:50:00 | SPY | ETF | 335.18 | 335.24 | 335.05 | 335.24 | 7507.0 |
| 2020-08-14 04:55:00 | SPY | ETF | 335.35 | 335.39 | 335.32 | 335.39 | 2407.0 |
| 2020-08-14 05:00:00 | SPY | ETF | 335.3 | 335.3 | 335.17 | 335.17 | 1767.0 |
| 2020-08-14 05:05:00 | SPY | ETF | 335.23 | 335.3 | 335.16 | 335.16 | 8243.0 |
| 2020-08-14 05:10:00 | SPY | ETF | 335.19 | 335.2 | 335.19 | 335.2 | 831.0 |
| 2020-08-14 05:15:00 | SPY | ETF | 335.3 | 335.37 | 335.3 | 335.37 | 852.0 |
| 2020-08-14 05:20:00 | SPY | ETF | 335.4 | 335.53 | 335.4 | 335.53 | 3995.0 |
| 2020-08-14 05:25:00 | SPY | ETF | 335.42 | 335.74 | 335.42 | 335.73 | 1321.0 |
| 2020-08-14 05:30:00 | SPY | ETF | 335.64 | 335.73 | 335.64 | 335.68 | 6285.0 |
| 2020-08-14 05:35:00 | SPY | ETF | 335.61 | 335.62 | 335.6 | 335.62 | 628.0 |
| 2020-08-14 05:40:00 | SPY | ETF | 335.48 | 335.53 | 335.48 | 335.51 | 25221.0 |
| 2020-08-14 05:45:00 | SPY | ETF | 335.6 | 335.64 | 335.56 | 335.56 | 1252.0 |
| 2020-08-14 05:50:00 | SPY | ETF | 335.52 | 335.72 | 335.52 | 335.72 | 1933.0 |
| 2020-08-14 05:55:00 | SPY | ETF | 335.69 | 335.85 | 335.67 | 335.85 | 4629.0 |
| 2020-08-14 06:00:00 | SPY | ETF | 335.8 | 335.8 | 335.75 | 335.8 | 5561.0 |
| 2020-08-14 06:05:00 | SPY | ETF | 335.75 | 335.75 | 335.32 | 335.32 | 2148.0 |
| 2020-08-14 06:10:00 | SPY | ETF | 335.33 | 335.5 | 335.31 | 335.5 | 1648.0 |
| 2020-08-14 06:15:00 | SPY | ETF | 335.48 | 335.5 | 335.4 | 335.4 | 10150.0 |
| 2020-08-14 06:20:00 | SPY | ETF | 335.6 | 335.65 | 335.6 | 335.65 | 731.0 |
| 2020-08-14 06:25:00 | SPY | ETF | 335.66 | 335.67 | 335.5 | 335.53 | 6170.0 |
| 2020-08-14 06:30:00 | SPY | ETF | 335.59 | 335.71 | 335.48 | 335.64 | 6088.0 |
| 2020-08-14 06:35:00 | SPY | ETF | 335.64 | 335.74 | 335.64 | 335.74 | 2500.0 |
| 2020-08-14 06:40:00 | SPY | ETF | 335.73 | 335.79 | 335.73 | 335.76 | 655.0 |
| 2020-08-14 06:45:00 | SPY | ETF | 335.73 | 335.84 | 335.73 | 335.84 | 1500.0 |
| 2020-08-14 06:50:00 | SPY | ETF | 335.88 | 336.04 | 335.88 | 335.97 | 7388.0 |
| 2020-08-14 06:55:00 | SPY | ETF | 336.05 | 336.05 | 336.0 | 336.03 | 34773.0 |
| 2020-08-14 07:00:00 | SPY | ETF | 336.03 | 336.12 | 336.02 | 336.08 | 59016.0 |
| 2020-08-14 07:05:00 | SPY | ETF | 336.1 | 336.1 | 335.95 | 336.04 | 9242.0 |
| 2020-08-14 07:10:00 | SPY | ETF | 336.05 | 336.15 | 336.05 | 336.15 | 17238.0 |
| 2020-08-14 07:15:00 | SPY | ETF | 336.13 | 336.13 | 336.01 | 336.12 | 7574.0 |
| 2020-08-14 07:20:00 | SPY | ETF | 336.16 | 336.29 | 336.15 | 336.29 | 12802.0 |
| 2020-08-14 07:25:00 | SPY | ETF | 336.26 | 336.4 | 336.25 | 336.39 | 32371.0 |
| 2020-08-14 07:30:00 | SPY | ETF | 336.37 | 336.42 | 336.34 | 336.39 | 5316.0 |
| 2020-08-14 07:35:00 | SPY | ETF | 336.42 | 336.47 | 336.37 | 336.47 | 12995.0 |
| 2020-08-14 07:40:00 | SPY | ETF | 336.51 | 336.72 | 336.51 | 336.67 | 23592.0 |
| 2020-08-14 07:45:00 | SPY | ETF | 336.7 | 336.85 | 336.57 | 336.57 | 35414.0 |
| 2020-08-14 07:50:00 | SPY | ETF | 336.57 | 336.6 | 336.5 | 336.51 | 48314.0 |
| 2020-08-14 07:55:00 | SPY | ETF | 336.57 | 336.73 | 336.57 | 336.7 | 5811.0 |
| 2020-08-14 08:00:00 | SPY | ETF | 336.5801 | 337.89 | 335.5696 | 336.59 | 42884.0 |
| 2020-08-14 08:05:00 | SPY | ETF | 336.63 | 336.63 | 336.34 | 336.35 | 27485.0 |
> showing 50 of 69,136 rows — these rows as CSV