PREVIEW / etf_5min / 2020-09-04
file: by_date/etf_5min/2020/2020-09-04.parquet size: 1.8 MB rows: 80,479
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-09-04 04:00:00 | SPY | ETF | 347.0 | 347.04 | 346.74 | 346.74 | 19961.0 |
| 2020-09-04 04:05:00 | SPY | ETF | 346.75 | 347.06 | 346.69 | 347.06 | 3472.0 |
| 2020-09-04 04:10:00 | SPY | ETF | 346.89 | 347.22 | 346.76 | 347.19 | 6147.0 |
| 2020-09-04 04:15:00 | SPY | ETF | 347.26 | 347.44 | 347.11 | 347.11 | 13906.0 |
| 2020-09-04 04:20:00 | SPY | ETF | 347.09 | 347.11 | 347.09 | 347.11 | 360.0 |
| 2020-09-04 04:25:00 | SPY | ETF | 347.08 | 347.36 | 347.08 | 347.21 | 2703.0 |
| 2020-09-04 04:30:00 | SPY | ETF | 347.2 | 347.76 | 347.17 | 347.7 | 5980.0 |
| 2020-09-04 04:35:00 | SPY | ETF | 347.73 | 347.8 | 347.56 | 347.63 | 6548.0 |
| 2020-09-04 04:40:00 | SPY | ETF | 347.61 | 347.66 | 347.47 | 347.51 | 9116.0 |
| 2020-09-04 04:45:00 | SPY | ETF | 347.29 | 347.47 | 347.29 | 347.47 | 1526.0 |
| 2020-09-04 04:50:00 | SPY | ETF | 347.45 | 347.7 | 347.45 | 347.64 | 1735.0 |
| 2020-09-04 04:55:00 | SPY | ETF | 347.46 | 347.46 | 347.36 | 347.36 | 658.0 |
| 2020-09-04 05:00:00 | SPY | ETF | 347.6 | 347.6 | 347.49 | 347.49 | 350.0 |
| 2020-09-04 05:05:00 | SPY | ETF | 347.48 | 347.48 | 347.34 | 347.37 | 2334.0 |
| 2020-09-04 05:10:00 | SPY | ETF | 347.4 | 347.4 | 347.31 | 347.33 | 2707.0 |
| 2020-09-04 05:15:00 | SPY | ETF | 347.25 | 347.25 | 347.25 | 347.25 | 1365.0 |
| 2020-09-04 05:20:00 | SPY | ETF | 347.3 | 347.35 | 347.3 | 347.35 | 720.0 |
| 2020-09-04 05:25:00 | SPY | ETF | 347.54 | 347.6 | 347.5 | 347.5 | 3874.0 |
| 2020-09-04 05:30:00 | SPY | ETF | 347.43 | 347.43 | 347.22 | 347.28 | 2601.0 |
| 2020-09-04 05:35:00 | SPY | ETF | 347.45 | 347.55 | 347.45 | 347.53 | 3911.0 |
| 2020-09-04 05:40:00 | SPY | ETF | 347.6 | 347.67 | 347.6 | 347.64 | 3251.0 |
| 2020-09-04 05:45:00 | SPY | ETF | 347.69 | 347.93 | 347.58 | 347.93 | 6146.0 |
| 2020-09-04 05:50:00 | SPY | ETF | 347.95 | 348.27 | 347.95 | 348.27 | 23201.0 |
| 2020-09-04 05:55:00 | SPY | ETF | 348.19 | 348.32 | 348.19 | 348.26 | 8704.0 |
| 2020-09-04 06:00:00 | SPY | ETF | 348.36 | 348.44 | 348.35 | 348.39 | 5741.0 |
| 2020-09-04 06:05:00 | SPY | ETF | 348.27 | 348.38 | 348.24 | 348.32 | 14945.0 |
| 2020-09-04 06:10:00 | SPY | ETF | 348.32 | 348.5 | 348.32 | 348.34 | 2601.0 |
| 2020-09-04 06:15:00 | SPY | ETF | 348.19 | 348.19 | 347.65 | 347.65 | 5588.0 |
| 2020-09-04 06:20:00 | SPY | ETF | 347.67 | 347.67 | 347.31 | 347.34 | 7811.0 |
| 2020-09-04 06:25:00 | SPY | ETF | 347.32 | 347.53 | 347.29 | 347.4 | 6233.0 |
| 2020-09-04 06:30:00 | SPY | ETF | 347.39 | 347.54 | 347.36 | 347.47 | 6058.0 |
| 2020-09-04 06:35:00 | SPY | ETF | 347.52 | 347.52 | 347.4 | 347.44 | 2535.0 |
| 2020-09-04 06:40:00 | SPY | ETF | 347.44 | 347.45 | 347.35 | 347.4 | 2550.0 |
| 2020-09-04 06:45:00 | SPY | ETF | 347.37 | 347.44 | 347.16 | 347.29 | 23726.0 |
| 2020-09-04 06:50:00 | SPY | ETF | 347.26 | 347.32 | 347.26 | 347.32 | 16526.0 |
| 2020-09-04 06:55:00 | SPY | ETF | 347.32 | 347.33 | 347.26 | 347.28 | 63151.0 |
| 2020-09-04 07:00:00 | SPY | ETF | 347.2 | 347.27 | 346.67 | 346.79 | 55622.0 |
| 2020-09-04 07:05:00 | SPY | ETF | 346.9 | 347.02 | 346.55 | 346.73 | 44416.0 |
| 2020-09-04 07:10:00 | SPY | ETF | 346.68 | 346.7 | 346.04 | 346.28 | 117964.0 |
| 2020-09-04 07:15:00 | SPY | ETF | 346.24 | 346.24 | 345.92 | 346.01 | 23643.0 |
| 2020-09-04 07:20:00 | SPY | ETF | 346.1 | 346.41 | 346.0 | 346.41 | 30404.0 |
| 2020-09-04 07:25:00 | SPY | ETF | 346.41 | 346.47 | 346.07 | 346.07 | 37017.0 |
| 2020-09-04 07:30:00 | SPY | ETF | 346.02 | 346.02 | 345.44 | 345.44 | 54547.0 |
| 2020-09-04 07:35:00 | SPY | ETF | 345.43 | 345.63 | 345.34 | 345.46 | 80853.0 |
| 2020-09-04 07:40:00 | SPY | ETF | 345.45 | 345.47 | 345.02 | 345.31 | 33428.0 |
| 2020-09-04 07:45:00 | SPY | ETF | 345.29 | 345.36 | 345.02 | 345.34 | 43582.0 |
| 2020-09-04 07:50:00 | SPY | ETF | 345.34 | 345.34 | 344.96 | 345.23 | 44079.0 |
| 2020-09-04 07:55:00 | SPY | ETF | 345.18 | 345.25 | 344.79 | 345.06 | 44667.0 |
| 2020-09-04 08:00:00 | SPY | ETF | 345.4901 | 348.3904 | 344.23 | 345.61 | 91737.0 |
| 2020-09-04 08:05:00 | SPY | ETF | 345.57 | 345.72 | 345.23 | 345.27 | 87867.0 |
> showing 50 of 80,479 rows — these rows as CSV