PREVIEW / etf_5min / 2020-07-07
file: by_date/etf_5min/2020/2020-07-07.parquet size: 1.6 MB rows: 75,824
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-07-07 04:00:00 | SPY | ETF | 315.6 | 315.6 | 315.14 | 315.32 | 10537.0 |
| 2020-07-07 04:05:00 | SPY | ETF | 315.2 | 315.25 | 315.07 | 315.23 | 4987.0 |
| 2020-07-07 04:10:00 | SPY | ETF | 315.28 | 315.77 | 315.28 | 315.56 | 11112.0 |
| 2020-07-07 04:15:00 | SPY | ETF | 315.49 | 315.49 | 315.3 | 315.3 | 5979.0 |
| 2020-07-07 04:20:00 | SPY | ETF | 315.25 | 315.37 | 315.25 | 315.3 | 13043.0 |
| 2020-07-07 04:25:00 | SPY | ETF | 315.25 | 315.25 | 314.5 | 314.58 | 14324.0 |
| 2020-07-07 04:30:00 | SPY | ETF | 314.57 | 314.94 | 314.57 | 314.79 | 4693.0 |
| 2020-07-07 04:35:00 | SPY | ETF | 314.77 | 314.89 | 314.77 | 314.84 | 820.0 |
| 2020-07-07 04:40:00 | SPY | ETF | 314.9 | 314.9 | 314.86 | 314.88 | 1305.0 |
| 2020-07-07 04:45:00 | SPY | ETF | 314.79 | 315.0 | 314.79 | 315.0 | 5226.0 |
| 2020-07-07 04:50:00 | SPY | ETF | 314.87 | 314.94 | 314.82 | 314.94 | 2901.0 |
| 2020-07-07 04:55:00 | SPY | ETF | 314.95 | 314.95 | 314.59 | 314.79 | 2813.0 |
| 2020-07-07 05:00:00 | SPY | ETF | 314.69 | 314.79 | 314.29 | 314.36 | 8154.0 |
| 2020-07-07 05:05:00 | SPY | ETF | 314.35 | 314.51 | 314.35 | 314.5 | 2681.0 |
| 2020-07-07 05:10:00 | SPY | ETF | 314.41 | 314.41 | 314.33 | 314.41 | 3330.0 |
| 2020-07-07 05:15:00 | SPY | ETF | 314.34 | 314.49 | 314.34 | 314.49 | 621.0 |
| 2020-07-07 05:20:00 | SPY | ETF | 314.31 | 314.36 | 314.25 | 314.36 | 987.0 |
| 2020-07-07 05:25:00 | SPY | ETF | 314.2 | 314.4 | 314.15 | 314.35 | 7476.0 |
| 2020-07-07 05:30:00 | SPY | ETF | 314.45 | 314.54 | 314.41 | 314.42 | 2503.0 |
| 2020-07-07 05:35:00 | SPY | ETF | 314.5 | 314.54 | 314.44 | 314.47 | 2372.0 |
| 2020-07-07 05:40:00 | SPY | ETF | 314.44 | 314.57 | 314.39 | 314.5 | 11769.0 |
| 2020-07-07 05:45:00 | SPY | ETF | 314.39 | 314.42 | 314.32 | 314.34 | 1404.0 |
| 2020-07-07 05:50:00 | SPY | ETF | 314.09 | 314.39 | 314.09 | 314.39 | 3798.0 |
| 2020-07-07 05:55:00 | SPY | ETF | 314.4 | 314.44 | 314.4 | 314.4 | 2125.0 |
| 2020-07-07 06:00:00 | SPY | ETF | 314.47 | 314.47 | 314.25 | 314.4 | 35666.0 |
| 2020-07-07 06:05:00 | SPY | ETF | 314.4 | 314.54 | 314.4 | 314.41 | 18192.0 |
| 2020-07-07 06:10:00 | SPY | ETF | 314.39 | 314.41 | 314.26 | 314.37 | 12984.0 |
| 2020-07-07 06:15:00 | SPY | ETF | 314.44 | 314.5 | 313.95 | 314.4 | 13632.0 |
| 2020-07-07 06:20:00 | SPY | ETF | 314.42 | 314.5 | 314.34 | 314.44 | 2573.0 |
| 2020-07-07 06:25:00 | SPY | ETF | 314.49 | 314.51 | 314.39 | 314.49 | 7813.0 |
| 2020-07-07 06:30:00 | SPY | ETF | 314.45 | 314.6 | 314.45 | 314.52 | 3680.0 |
| 2020-07-07 06:35:00 | SPY | ETF | 314.47 | 315.0 | 314.47 | 314.79 | 17680.0 |
| 2020-07-07 06:40:00 | SPY | ETF | 314.79 | 314.82 | 314.63 | 314.67 | 9760.0 |
| 2020-07-07 06:45:00 | SPY | ETF | 314.7 | 314.7 | 314.4 | 314.4 | 5591.0 |
| 2020-07-07 06:50:00 | SPY | ETF | 314.4 | 314.55 | 314.4 | 314.53 | 6794.0 |
| 2020-07-07 06:55:00 | SPY | ETF | 314.48 | 314.48 | 314.33 | 314.35 | 4546.0 |
| 2020-07-07 07:00:00 | SPY | ETF | 314.53 | 314.61 | 314.45 | 314.51 | 40494.0 |
| 2020-07-07 07:05:00 | SPY | ETF | 314.5 | 314.52 | 314.32 | 314.48 | 31646.0 |
| 2020-07-07 07:10:00 | SPY | ETF | 314.45 | 314.68 | 314.45 | 314.63 | 6997.0 |
| 2020-07-07 07:15:00 | SPY | ETF | 314.63 | 314.959 | 314.63 | 314.95 | 54823.0 |
| 2020-07-07 07:20:00 | SPY | ETF | 314.939 | 314.939 | 314.83 | 314.839 | 17205.0 |
| 2020-07-07 07:25:00 | SPY | ETF | 314.8 | 314.94 | 314.76 | 314.94 | 9607.0 |
| 2020-07-07 07:30:00 | SPY | ETF | 314.92 | 315.03 | 314.78 | 314.78 | 18153.0 |
| 2020-07-07 07:35:00 | SPY | ETF | 314.81 | 314.92 | 314.79 | 314.86 | 30344.0 |
| 2020-07-07 07:40:00 | SPY | ETF | 314.9 | 315.26 | 314.9 | 315.21 | 24608.0 |
| 2020-07-07 07:45:00 | SPY | ETF | 315.25 | 315.46 | 315.17 | 315.36 | 46535.0 |
| 2020-07-07 07:50:00 | SPY | ETF | 315.4 | 315.44 | 315.18 | 315.18 | 35465.0 |
| 2020-07-07 07:55:00 | SPY | ETF | 315.22 | 315.28 | 315.16 | 315.23 | 17152.0 |
| 2020-07-07 08:00:00 | SPY | ETF | 315.24 | 316.9 | 314.1704 | 315.38 | 62310.0 |
| 2020-07-07 08:05:00 | SPY | ETF | 315.4 | 315.42 | 315.21 | 315.22 | 55179.0 |
> showing 50 of 75,824 rows — these rows as CSV