PREVIEW / etf_5min / 2020-04-06
file: by_date/etf_5min/2020/2020-04-06.parquet size: 1.8 MB rows: 80,885
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-04-06 04:00:00 | SPY | ETF | 258.24 | 258.7 | 257.83 | 257.83 | 95563.0 |
| 2020-04-06 04:05:00 | SPY | ETF | 257.84 | 257.86 | 257.55 | 257.59 | 23388.0 |
| 2020-04-06 04:10:00 | SPY | ETF | 257.5 | 257.6 | 257.01 | 257.2 | 8785.0 |
| 2020-04-06 04:15:00 | SPY | ETF | 257.2 | 257.28 | 257.07 | 257.22 | 4503.0 |
| 2020-04-06 04:20:00 | SPY | ETF | 257.22 | 257.39 | 257.06 | 257.3 | 20848.0 |
| 2020-04-06 04:25:00 | SPY | ETF | 257.29 | 257.7 | 257.26 | 257.7 | 15574.0 |
| 2020-04-06 04:30:00 | SPY | ETF | 257.68 | 257.69 | 257.39 | 257.5 | 9510.0 |
| 2020-04-06 04:35:00 | SPY | ETF | 257.58 | 257.58 | 257.01 | 257.06 | 10756.0 |
| 2020-04-06 04:40:00 | SPY | ETF | 257.1 | 257.4 | 257.1 | 257.39 | 17554.0 |
| 2020-04-06 04:45:00 | SPY | ETF | 257.34 | 257.65 | 257.29 | 257.34 | 6902.0 |
| 2020-04-06 04:50:00 | SPY | ETF | 257.36 | 258.0 | 257.36 | 257.82 | 18358.0 |
| 2020-04-06 04:55:00 | SPY | ETF | 257.82 | 258.2 | 257.75 | 258.2 | 13621.0 |
| 2020-04-06 05:00:00 | SPY | ETF | 258.18 | 258.25 | 257.79 | 257.79 | 9644.0 |
| 2020-04-06 05:05:00 | SPY | ETF | 257.81 | 257.86 | 257.66 | 257.85 | 2927.0 |
| 2020-04-06 05:10:00 | SPY | ETF | 257.7 | 257.77 | 257.54 | 257.77 | 27441.0 |
| 2020-04-06 05:15:00 | SPY | ETF | 257.76 | 257.76 | 257.53 | 257.6 | 7559.0 |
| 2020-04-06 05:20:00 | SPY | ETF | 257.75 | 258.04 | 257.59 | 257.94 | 100748.0 |
| 2020-04-06 05:25:00 | SPY | ETF | 257.9 | 258.37 | 257.9 | 258.25 | 45481.0 |
| 2020-04-06 05:30:00 | SPY | ETF | 258.27 | 258.27 | 258.1 | 258.27 | 6781.0 |
| 2020-04-06 05:35:00 | SPY | ETF | 258.32 | 258.38 | 257.94 | 257.98 | 3528.0 |
| 2020-04-06 05:40:00 | SPY | ETF | 258.07 | 258.53 | 258.04 | 258.53 | 21096.0 |
| 2020-04-06 05:45:00 | SPY | ETF | 258.59 | 258.65 | 258.37 | 258.6 | 25012.0 |
| 2020-04-06 05:50:00 | SPY | ETF | 258.65 | 258.69 | 258.5 | 258.54 | 11989.0 |
| 2020-04-06 05:55:00 | SPY | ETF | 258.55 | 258.55 | 258.19 | 258.35 | 7690.0 |
| 2020-04-06 06:00:00 | SPY | ETF | 258.34 | 258.49 | 258.19 | 258.47 | 108549.0 |
| 2020-04-06 06:05:00 | SPY | ETF | 258.4 | 258.45 | 257.87 | 257.91 | 98694.0 |
| 2020-04-06 06:10:00 | SPY | ETF | 257.85 | 257.85 | 257.47 | 257.82 | 110119.0 |
| 2020-04-06 06:15:00 | SPY | ETF | 257.82 | 257.95 | 257.6 | 257.92 | 78473.0 |
| 2020-04-06 06:20:00 | SPY | ETF | 257.93 | 257.93 | 257.45 | 257.49 | 14439.0 |
| 2020-04-06 06:25:00 | SPY | ETF | 257.7 | 257.73 | 257.4 | 257.45 | 7849.0 |
| 2020-04-06 06:30:00 | SPY | ETF | 257.34 | 257.52 | 257.31 | 257.44 | 11737.0 |
| 2020-04-06 06:35:00 | SPY | ETF | 257.46 | 257.61 | 257.3 | 257.34 | 12137.0 |
| 2020-04-06 06:40:00 | SPY | ETF | 257.43 | 257.86 | 257.43 | 257.86 | 14482.0 |
| 2020-04-06 06:45:00 | SPY | ETF | 257.81 | 258.08 | 257.68 | 257.93 | 37926.0 |
| 2020-04-06 06:50:00 | SPY | ETF | 257.93 | 257.97 | 257.8 | 257.82 | 15241.0 |
| 2020-04-06 06:55:00 | SPY | ETF | 257.92 | 258.13 | 257.84 | 257.84 | 13946.0 |
| 2020-04-06 07:00:00 | SPY | ETF | 257.97 | 257.99 | 257.5 | 257.5 | 67161.0 |
| 2020-04-06 07:05:00 | SPY | ETF | 257.44 | 257.66 | 257.4 | 257.66 | 39622.0 |
| 2020-04-06 07:10:00 | SPY | ETF | 257.59 | 257.8 | 257.59 | 257.61 | 64408.0 |
| 2020-04-06 07:15:00 | SPY | ETF | 257.59 | 257.75 | 257.35 | 257.37 | 121473.0 |
| 2020-04-06 07:20:00 | SPY | ETF | 257.42 | 257.66 | 257.36 | 257.65 | 68703.0 |
| 2020-04-06 07:25:00 | SPY | ETF | 257.65 | 257.88 | 257.64 | 257.8 | 64291.0 |
| 2020-04-06 07:30:00 | SPY | ETF | 257.75 | 257.84 | 257.55 | 257.72 | 37477.0 |
| 2020-04-06 07:35:00 | SPY | ETF | 257.68 | 257.91 | 257.54 | 257.58 | 59819.0 |
| 2020-04-06 07:40:00 | SPY | ETF | 257.69 | 258.02 | 257.69 | 257.88 | 58883.0 |
| 2020-04-06 07:45:00 | SPY | ETF | 257.88 | 258.11 | 257.75 | 257.95 | 50312.0 |
| 2020-04-06 07:50:00 | SPY | ETF | 257.9 | 257.9 | 257.64 | 257.64 | 42058.0 |
| 2020-04-06 07:55:00 | SPY | ETF | 257.6 | 257.8 | 257.46 | 257.71 | 86492.0 |
| 2020-04-06 08:00:00 | SPY | ETF | 257.69 | 259.0 | 256.59 | 257.19 | 243062.0 |
| 2020-04-06 08:05:00 | SPY | ETF | 257.19 | 257.31 | 257.0 | 257.19 | 148781.0 |
> showing 50 of 80,885 rows — these rows as CSV