PREVIEW / etf_5min / 2020-08-20
file: by_date/etf_5min/2020/2020-08-20.parquet size: 1.5 MB rows: 71,267
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-20 04:00:00 | SPY | ETF | 336.54 | 336.54 | 336.1 | 336.1 | 2248.0 |
| 2020-08-20 04:05:00 | SPY | ETF | 336.1 | 336.1 | 335.9 | 336.05 | 1545.0 |
| 2020-08-20 04:10:00 | SPY | ETF | 336.04 | 336.05 | 336.04 | 336.05 | 386.0 |
| 2020-08-20 04:15:00 | SPY | ETF | 335.75 | 335.76 | 335.35 | 335.35 | 8230.0 |
| 2020-08-20 04:20:00 | SPY | ETF | 335.4 | 335.4 | 335.25 | 335.29 | 3542.0 |
| 2020-08-20 04:25:00 | SPY | ETF | 335.13 | 335.27 | 335.07 | 335.27 | 12596.0 |
| 2020-08-20 04:30:00 | SPY | ETF | 335.2 | 335.27 | 335.13 | 335.2 | 5799.0 |
| 2020-08-20 04:35:00 | SPY | ETF | 335.08 | 335.48 | 335.03 | 335.48 | 2053.0 |
| 2020-08-20 04:40:00 | SPY | ETF | 335.47 | 335.47 | 335.47 | 335.47 | 200.0 |
| 2020-08-20 04:45:00 | SPY | ETF | 335.49 | 335.66 | 335.49 | 335.62 | 3567.0 |
| 2020-08-20 04:50:00 | SPY | ETF | 335.58 | 335.88 | 335.58 | 335.86 | 3730.0 |
| 2020-08-20 04:55:00 | SPY | ETF | 335.95 | 336.07 | 335.94 | 336.07 | 1634.0 |
| 2020-08-20 05:00:00 | SPY | ETF | 335.91 | 336.02 | 335.91 | 335.96 | 5292.0 |
| 2020-08-20 05:05:00 | SPY | ETF | 336.1 | 336.1 | 336.01 | 336.09 | 1711.0 |
| 2020-08-20 05:10:00 | SPY | ETF | 336.1 | 336.15 | 336.09 | 336.09 | 3701.0 |
| 2020-08-20 05:15:00 | SPY | ETF | 335.9 | 335.93 | 335.9 | 335.9 | 1222.0 |
| 2020-08-20 05:25:00 | SPY | ETF | 335.82 | 335.82 | 335.82 | 335.82 | 513.0 |
| 2020-08-20 05:35:00 | SPY | ETF | 336.02 | 336.02 | 335.95 | 335.97 | 1052.0 |
| 2020-08-20 05:40:00 | SPY | ETF | 336.07 | 336.13 | 336.07 | 336.13 | 771.0 |
| 2020-08-20 05:45:00 | SPY | ETF | 336.15 | 336.21 | 336.15 | 336.2 | 1398.0 |
| 2020-08-20 05:50:00 | SPY | ETF | 336.22 | 336.23 | 336.14 | 336.14 | 4656.0 |
| 2020-08-20 05:55:00 | SPY | ETF | 336.14 | 336.14 | 336.1 | 336.1 | 426.0 |
| 2020-08-20 06:00:00 | SPY | ETF | 336.13 | 336.18 | 336.08 | 336.08 | 6001.0 |
| 2020-08-20 06:10:00 | SPY | ETF | 336.24 | 336.25 | 336.24 | 336.25 | 1811.0 |
| 2020-08-20 06:15:00 | SPY | ETF | 336.33 | 336.43 | 336.33 | 336.38 | 15779.0 |
| 2020-08-20 06:20:00 | SPY | ETF | 336.43 | 336.54 | 336.36 | 336.54 | 1738.0 |
| 2020-08-20 06:25:00 | SPY | ETF | 336.58 | 336.59 | 336.41 | 336.41 | 4255.0 |
| 2020-08-20 06:30:00 | SPY | ETF | 336.48 | 336.48 | 336.48 | 336.48 | 200.0 |
| 2020-08-20 06:35:00 | SPY | ETF | 336.48 | 336.49 | 336.47 | 336.49 | 1109.0 |
| 2020-08-20 06:40:00 | SPY | ETF | 336.43 | 336.48 | 336.4 | 336.42 | 3359.0 |
| 2020-08-20 06:45:00 | SPY | ETF | 336.42 | 336.43 | 336.41 | 336.41 | 6310.0 |
| 2020-08-20 06:50:00 | SPY | ETF | 336.43 | 336.66 | 336.43 | 336.66 | 3571.0 |
| 2020-08-20 06:55:00 | SPY | ETF | 336.66 | 336.87 | 336.66 | 336.87 | 1044.0 |
| 2020-08-20 07:00:00 | SPY | ETF | 336.76 | 336.83 | 336.71 | 336.74 | 16155.0 |
| 2020-08-20 07:05:00 | SPY | ETF | 336.69 | 336.75 | 336.65 | 336.65 | 5403.0 |
| 2020-08-20 07:10:00 | SPY | ETF | 336.63 | 336.77 | 336.62 | 336.7 | 8206.0 |
| 2020-08-20 07:15:00 | SPY | ETF | 336.65 | 336.67 | 336.52 | 336.52 | 5696.0 |
| 2020-08-20 07:20:00 | SPY | ETF | 336.52 | 336.52 | 336.41 | 336.45 | 19007.0 |
| 2020-08-20 07:25:00 | SPY | ETF | 336.48 | 336.54 | 336.48 | 336.48 | 5641.0 |
| 2020-08-20 07:30:00 | SPY | ETF | 336.48 | 336.53 | 336.43 | 336.48 | 7542.0 |
| 2020-08-20 07:35:00 | SPY | ETF | 336.55 | 336.65 | 336.45 | 336.49 | 10426.0 |
| 2020-08-20 07:40:00 | SPY | ETF | 336.49 | 336.49 | 336.32 | 336.39 | 28886.0 |
| 2020-08-20 07:45:00 | SPY | ETF | 336.46 | 336.46 | 336.35 | 336.35 | 1738.0 |
| 2020-08-20 07:50:00 | SPY | ETF | 336.36 | 336.36 | 336.15 | 336.16 | 16672.0 |
| 2020-08-20 07:55:00 | SPY | ETF | 336.22 | 336.27 | 336.17 | 336.27 | 12867.0 |
| 2020-08-20 08:00:00 | SPY | ETF | 336.5699 | 336.79 | 335.3 | 336.12 | 39199.0 |
| 2020-08-20 08:05:00 | SPY | ETF | 336.12 | 336.2 | 335.87 | 335.95 | 61017.0 |
| 2020-08-20 08:10:00 | SPY | ETF | 336.0 | 336.06 | 335.9105 | 336.0 | 20453.0 |
| 2020-08-20 08:15:00 | SPY | ETF | 335.96 | 336.0 | 335.77 | 335.78 | 38360.0 |
| 2020-08-20 08:20:00 | SPY | ETF | 335.81 | 335.93 | 335.81 | 335.92 | 20066.0 |
> showing 50 of 71,267 rows — these rows as CSV