PREVIEW / etf_5min / 2020-04-24
file: by_date/etf_5min/2020/2020-04-24.parquet size: 1.6 MB rows: 72,526
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-24 04:00:00 | SPY | ETF | 278.25 | 278.27 | 277.57 | 277.61 | 11809.0 |
| 2020-04-24 04:05:00 | SPY | ETF | 277.69 | 277.81 | 277.65 | 277.71 | 2003.0 |
| 2020-04-24 04:10:00 | SPY | ETF | 278.02 | 278.02 | 277.62 | 277.62 | 2610.0 |
| 2020-04-24 04:15:00 | SPY | ETF | 277.62 | 277.62 | 277.22 | 277.29 | 3357.0 |
| 2020-04-24 04:20:00 | SPY | ETF | 277.23 | 277.3 | 277.18 | 277.18 | 12269.0 |
| 2020-04-24 04:25:00 | SPY | ETF | 277.36 | 277.47 | 277.28 | 277.43 | 4208.0 |
| 2020-04-24 04:30:00 | SPY | ETF | 277.43 | 277.48 | 277.43 | 277.43 | 2801.0 |
| 2020-04-24 04:35:00 | SPY | ETF | 277.4 | 277.5 | 277.3 | 277.37 | 9859.0 |
| 2020-04-24 04:40:00 | SPY | ETF | 277.55 | 277.57 | 277.52 | 277.55 | 5485.0 |
| 2020-04-24 04:45:00 | SPY | ETF | 277.63 | 277.63 | 277.6 | 277.6 | 1100.0 |
| 2020-04-24 04:50:00 | SPY | ETF | 277.69 | 277.9 | 277.69 | 277.9 | 2806.0 |
| 2020-04-24 04:55:00 | SPY | ETF | 277.93 | 277.93 | 277.86 | 277.86 | 2964.0 |
| 2020-04-24 05:00:00 | SPY | ETF | 277.95 | 278.19 | 277.95 | 278.19 | 4620.0 |
| 2020-04-24 05:05:00 | SPY | ETF | 278.17 | 278.82 | 278.17 | 278.82 | 11280.0 |
| 2020-04-24 05:10:00 | SPY | ETF | 278.85 | 279.24 | 278.84 | 279.11 | 14778.0 |
| 2020-04-24 05:15:00 | SPY | ETF | 279.1 | 279.1 | 278.97 | 279.04 | 8813.0 |
| 2020-04-24 05:20:00 | SPY | ETF | 278.98 | 278.98 | 278.8 | 278.8 | 33720.0 |
| 2020-04-24 05:25:00 | SPY | ETF | 278.95 | 279.73 | 278.95 | 279.39 | 17140.0 |
| 2020-04-24 05:30:00 | SPY | ETF | 279.33 | 279.41 | 279.21 | 279.21 | 6791.0 |
| 2020-04-24 05:35:00 | SPY | ETF | 279.26 | 279.31 | 279.09 | 279.15 | 14960.0 |
| 2020-04-24 05:40:00 | SPY | ETF | 279.12 | 279.42 | 279.12 | 279.39 | 20328.0 |
| 2020-04-24 05:45:00 | SPY | ETF | 279.37 | 279.61 | 279.37 | 279.61 | 8338.0 |
| 2020-04-24 05:50:00 | SPY | ETF | 279.64 | 279.9 | 279.64 | 279.73 | 80767.0 |
| 2020-04-24 05:55:00 | SPY | ETF | 279.62 | 279.96 | 279.58 | 279.58 | 5004.0 |
| 2020-04-24 06:00:00 | SPY | ETF | 279.64 | 279.65 | 279.44 | 279.6 | 8071.0 |
| 2020-04-24 06:05:00 | SPY | ETF | 279.52 | 279.57 | 279.5 | 279.54 | 5983.0 |
| 2020-04-24 06:10:00 | SPY | ETF | 279.5 | 279.5 | 279.32 | 279.43 | 11075.0 |
| 2020-04-24 06:15:00 | SPY | ETF | 279.6 | 280.2 | 279.6 | 280.19 | 13809.0 |
| 2020-04-24 06:20:00 | SPY | ETF | 280.15 | 280.15 | 279.8 | 279.8 | 9291.0 |
| 2020-04-24 06:25:00 | SPY | ETF | 279.83 | 279.86 | 279.7 | 279.7 | 11889.0 |
| 2020-04-24 06:30:00 | SPY | ETF | 279.72 | 279.97 | 279.6 | 279.76 | 12122.0 |
| 2020-04-24 06:35:00 | SPY | ETF | 279.8 | 280.03 | 279.79 | 279.88 | 6551.0 |
| 2020-04-24 06:40:00 | SPY | ETF | 280.0 | 280.1 | 280.0 | 280.02 | 11021.0 |
| 2020-04-24 06:45:00 | SPY | ETF | 280.02 | 280.5 | 280.02 | 280.27 | 25147.0 |
| 2020-04-24 06:50:00 | SPY | ETF | 280.26 | 280.26 | 280.1 | 280.12 | 10289.0 |
| 2020-04-24 06:55:00 | SPY | ETF | 280.25 | 280.85 | 280.23 | 280.85 | 78266.0 |
| 2020-04-24 07:00:00 | SPY | ETF | 280.8 | 280.92 | 280.57 | 280.77 | 49150.0 |
| 2020-04-24 07:05:00 | SPY | ETF | 280.8 | 280.98 | 280.53 | 280.54 | 36456.0 |
| 2020-04-24 07:10:00 | SPY | ETF | 280.61 | 280.7 | 280.49 | 280.62 | 40708.0 |
| 2020-04-24 07:15:00 | SPY | ETF | 280.68 | 280.73 | 280.35 | 280.36 | 26557.0 |
| 2020-04-24 07:20:00 | SPY | ETF | 280.46 | 280.54 | 280.38 | 280.54 | 25233.0 |
| 2020-04-24 07:25:00 | SPY | ETF | 280.49 | 280.72 | 280.44 | 280.66 | 21568.0 |
| 2020-04-24 07:30:00 | SPY | ETF | 280.66 | 280.66 | 280.3 | 280.3 | 28591.0 |
| 2020-04-24 07:35:00 | SPY | ETF | 280.28 | 280.39 | 280.25 | 280.35 | 37887.0 |
| 2020-04-24 07:40:00 | SPY | ETF | 280.35 | 280.4 | 280.16 | 280.22 | 31771.0 |
| 2020-04-24 07:45:00 | SPY | ETF | 280.22 | 280.22 | 279.95 | 279.99 | 35343.0 |
| 2020-04-24 07:50:00 | SPY | ETF | 279.95 | 280.1 | 279.91 | 280.06 | 54017.0 |
| 2020-04-24 07:55:00 | SPY | ETF | 280.07 | 280.07 | 279.83 | 279.95 | 31776.0 |
| 2020-04-24 08:00:00 | SPY | ETF | 280.9399 | 280.9399 | 276.13 | 279.8 | 313122.0 |
| 2020-04-24 08:05:00 | SPY | ETF | 279.76 | 280.01 | 279.74 | 279.88 | 41392.0 |
> showing 50 of 72,526 rows — these rows as CSV