PREVIEW / etf_5min / 2020-06-17
file: by_date/etf_5min/2020/2020-06-17.parquet size: 1.6 MB rows: 73,463
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-06-17 04:00:00 | SPY | ETF | 314.87 | 315.1 | 314.87 | 315.0 | 11954.0 |
| 2020-06-17 04:05:00 | SPY | ETF | 314.87 | 315.03 | 314.66 | 315.02 | 16723.0 |
| 2020-06-17 04:10:00 | SPY | ETF | 315.02 | 315.09 | 314.87 | 314.87 | 2091.0 |
| 2020-06-17 04:15:00 | SPY | ETF | 315.12 | 315.55 | 315.12 | 315.55 | 7409.0 |
| 2020-06-17 04:20:00 | SPY | ETF | 315.55 | 316.0 | 315.51 | 315.74 | 37709.0 |
| 2020-06-17 04:25:00 | SPY | ETF | 315.69 | 315.74 | 315.63 | 315.66 | 3656.0 |
| 2020-06-17 04:30:00 | SPY | ETF | 315.67 | 315.99 | 315.63 | 315.8 | 15028.0 |
| 2020-06-17 04:35:00 | SPY | ETF | 315.55 | 315.55 | 315.32 | 315.32 | 4340.0 |
| 2020-06-17 04:40:00 | SPY | ETF | 315.35 | 315.42 | 315.35 | 315.4 | 832.0 |
| 2020-06-17 04:45:00 | SPY | ETF | 315.45 | 315.5 | 315.39 | 315.5 | 914.0 |
| 2020-06-17 04:50:00 | SPY | ETF | 315.38 | 315.41 | 315.26 | 315.26 | 3995.0 |
| 2020-06-17 04:55:00 | SPY | ETF | 315.18 | 315.39 | 315.16 | 315.39 | 1364.0 |
| 2020-06-17 05:00:00 | SPY | ETF | 315.54 | 315.54 | 315.26 | 315.44 | 968.0 |
| 2020-06-17 05:05:00 | SPY | ETF | 315.4 | 315.4 | 314.97 | 315.03 | 18887.0 |
| 2020-06-17 05:10:00 | SPY | ETF | 315.04 | 315.15 | 314.96 | 315.15 | 52816.0 |
| 2020-06-17 05:15:00 | SPY | ETF | 315.03 | 315.03 | 314.5 | 314.5 | 4664.0 |
| 2020-06-17 05:20:00 | SPY | ETF | 314.51 | 314.58 | 314.44 | 314.45 | 7128.0 |
| 2020-06-17 05:25:00 | SPY | ETF | 314.4 | 314.44 | 314.09 | 314.44 | 28586.0 |
| 2020-06-17 05:30:00 | SPY | ETF | 314.37 | 314.55 | 314.37 | 314.5 | 1585.0 |
| 2020-06-17 05:35:00 | SPY | ETF | 314.36 | 314.36 | 314.05 | 314.34 | 6560.0 |
| 2020-06-17 05:40:00 | SPY | ETF | 314.29 | 314.47 | 314.22 | 314.35 | 2973.0 |
| 2020-06-17 05:45:00 | SPY | ETF | 314.46 | 314.49 | 313.1 | 313.42 | 16078.0 |
| 2020-06-17 05:50:00 | SPY | ETF | 313.42 | 313.7 | 313.1 | 313.67 | 12551.0 |
| 2020-06-17 05:55:00 | SPY | ETF | 313.62 | 313.7 | 313.57 | 313.65 | 4005.0 |
| 2020-06-17 06:00:00 | SPY | ETF | 313.8 | 313.8 | 313.56 | 313.72 | 4486.0 |
| 2020-06-17 06:05:00 | SPY | ETF | 313.78 | 313.87 | 313.78 | 313.84 | 1151.0 |
| 2020-06-17 06:10:00 | SPY | ETF | 313.94 | 314.27 | 313.94 | 314.13 | 11859.0 |
| 2020-06-17 06:15:00 | SPY | ETF | 314.13 | 314.2 | 313.92 | 313.99 | 17818.0 |
| 2020-06-17 06:20:00 | SPY | ETF | 313.98 | 314.1 | 313.98 | 314.01 | 3152.0 |
| 2020-06-17 06:25:00 | SPY | ETF | 314.26 | 314.85 | 314.26 | 314.74 | 14809.0 |
| 2020-06-17 06:30:00 | SPY | ETF | 314.8 | 314.86 | 314.6 | 314.6 | 26877.0 |
| 2020-06-17 06:35:00 | SPY | ETF | 314.62 | 314.86 | 314.57 | 314.86 | 49007.0 |
| 2020-06-17 06:40:00 | SPY | ETF | 314.87 | 314.91 | 314.6 | 314.6 | 43863.0 |
| 2020-06-17 06:45:00 | SPY | ETF | 314.62 | 314.84 | 314.57 | 314.7 | 4004.0 |
| 2020-06-17 06:50:00 | SPY | ETF | 314.67 | 314.69 | 314.62 | 314.62 | 953.0 |
| 2020-06-17 06:55:00 | SPY | ETF | 314.63 | 314.96 | 314.59 | 314.94 | 10646.0 |
| 2020-06-17 07:00:00 | SPY | ETF | 314.9 | 315.29 | 314.83 | 315.08 | 68610.0 |
| 2020-06-17 07:05:00 | SPY | ETF | 315.08 | 315.24 | 315.0 | 315.07 | 28712.0 |
| 2020-06-17 07:10:00 | SPY | ETF | 315.05 | 315.23 | 314.92 | 315.0 | 53855.0 |
| 2020-06-17 07:15:00 | SPY | ETF | 314.97 | 315.0 | 314.76 | 314.92 | 38748.0 |
| 2020-06-17 07:20:00 | SPY | ETF | 314.77 | 314.85 | 314.67 | 314.7 | 41789.0 |
| 2020-06-17 07:25:00 | SPY | ETF | 314.76 | 315.08 | 314.73 | 314.95 | 17271.0 |
| 2020-06-17 07:30:00 | SPY | ETF | 314.91 | 315.16 | 314.91 | 315.1 | 11234.0 |
| 2020-06-17 07:35:00 | SPY | ETF | 315.11 | 315.17 | 315.09 | 315.17 | 19583.0 |
| 2020-06-17 07:40:00 | SPY | ETF | 315.2 | 315.2 | 314.65 | 314.65 | 25256.0 |
| 2020-06-17 07:45:00 | SPY | ETF | 314.61 | 314.87 | 314.33 | 314.87 | 29708.0 |
| 2020-06-17 07:50:00 | SPY | ETF | 315.0 | 315.1 | 314.98 | 315.01 | 15789.0 |
| 2020-06-17 07:55:00 | SPY | ETF | 314.97 | 315.07 | 314.12 | 314.48 | 230999.0 |
| 2020-06-17 08:00:00 | SPY | ETF | 314.9 | 315.28 | 311.67 | 314.62 | 424582.0 |
| 2020-06-17 08:05:00 | SPY | ETF | 314.63 | 314.98 | 314.61 | 314.85 | 102311.0 |
> showing 50 of 73,463 rows — these rows as CSV