PREVIEW / etf_5min / 2020-04-15
file: by_date/etf_5min/2020/2020-04-15.parquet size: 1.8 MB rows: 79,212
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-15 04:00:00 | SPY | ETF | 280.36 | 280.61 | 280.2 | 280.34 | 26251.0 |
| 2020-04-15 04:05:00 | SPY | ETF | 280.35 | 280.66 | 280.35 | 280.54 | 9760.0 |
| 2020-04-15 04:10:00 | SPY | ETF | 280.6 | 280.65 | 280.47 | 280.49 | 5122.0 |
| 2020-04-15 04:15:00 | SPY | ETF | 280.3 | 280.67 | 280.27 | 280.53 | 5316.0 |
| 2020-04-15 04:20:00 | SPY | ETF | 280.7 | 280.96 | 280.7 | 280.75 | 3427.0 |
| 2020-04-15 04:25:00 | SPY | ETF | 280.85 | 280.9 | 280.6 | 280.6 | 5857.0 |
| 2020-04-15 04:30:00 | SPY | ETF | 280.65 | 280.65 | 280.34 | 280.48 | 5960.0 |
| 2020-04-15 04:35:00 | SPY | ETF | 280.47 | 280.5 | 280.25 | 280.25 | 7343.0 |
| 2020-04-15 04:40:00 | SPY | ETF | 280.22 | 280.35 | 280.2 | 280.3 | 8854.0 |
| 2020-04-15 04:45:00 | SPY | ETF | 280.2 | 280.2 | 279.26 | 279.4 | 35100.0 |
| 2020-04-15 04:50:00 | SPY | ETF | 279.47 | 279.53 | 279.21 | 279.5 | 5847.0 |
| 2020-04-15 04:55:00 | SPY | ETF | 279.23 | 279.6 | 279.23 | 279.6 | 8810.0 |
| 2020-04-15 05:00:00 | SPY | ETF | 279.6 | 279.6 | 279.25 | 279.36 | 4196.0 |
| 2020-04-15 05:05:00 | SPY | ETF | 279.25 | 279.25 | 278.86 | 278.86 | 16762.0 |
| 2020-04-15 05:10:00 | SPY | ETF | 279.13 | 279.37 | 279.0 | 279.37 | 16818.0 |
| 2020-04-15 05:15:00 | SPY | ETF | 279.46 | 279.58 | 279.33 | 279.33 | 6702.0 |
| 2020-04-15 05:20:00 | SPY | ETF | 279.49 | 279.61 | 279.4 | 279.52 | 2682.0 |
| 2020-04-15 05:25:00 | SPY | ETF | 279.56 | 279.66 | 279.1 | 279.26 | 15155.0 |
| 2020-04-15 05:30:00 | SPY | ETF | 279.31 | 279.66 | 279.27 | 279.54 | 15315.0 |
| 2020-04-15 05:35:00 | SPY | ETF | 279.6 | 279.66 | 279.5 | 279.5 | 4385.0 |
| 2020-04-15 05:40:00 | SPY | ETF | 279.6 | 279.6 | 279.31 | 279.45 | 7500.0 |
| 2020-04-15 05:45:00 | SPY | ETF | 279.35 | 279.49 | 279.3 | 279.45 | 1538.0 |
| 2020-04-15 05:50:00 | SPY | ETF | 279.39 | 279.39 | 279.21 | 279.24 | 4459.0 |
| 2020-04-15 05:55:00 | SPY | ETF | 279.31 | 279.52 | 279.28 | 279.52 | 1025.0 |
| 2020-04-15 06:00:00 | SPY | ETF | 279.54 | 279.95 | 279.54 | 279.95 | 16706.0 |
| 2020-04-15 06:05:00 | SPY | ETF | 279.96 | 280.1 | 279.39 | 279.39 | 16930.0 |
| 2020-04-15 06:10:00 | SPY | ETF | 279.45 | 279.59 | 279.44 | 279.5 | 10807.0 |
| 2020-04-15 06:15:00 | SPY | ETF | 279.49 | 279.49 | 279.0 | 279.34 | 15578.0 |
| 2020-04-15 06:20:00 | SPY | ETF | 279.3 | 279.32 | 279.11 | 279.25 | 11295.0 |
| 2020-04-15 06:25:00 | SPY | ETF | 279.27 | 279.27 | 278.95 | 279.25 | 5578.0 |
| 2020-04-15 06:30:00 | SPY | ETF | 279.34 | 279.48 | 279.28 | 279.38 | 21439.0 |
| 2020-04-15 06:35:00 | SPY | ETF | 279.3 | 279.44 | 278.6 | 279.11 | 55612.0 |
| 2020-04-15 06:40:00 | SPY | ETF | 279.1 | 279.21 | 278.85 | 279.11 | 57857.0 |
| 2020-04-15 06:45:00 | SPY | ETF | 279.09 | 279.17 | 278.91 | 279.08 | 13506.0 |
| 2020-04-15 06:50:00 | SPY | ETF | 279.08 | 279.25 | 278.92 | 279.01 | 25748.0 |
| 2020-04-15 06:55:00 | SPY | ETF | 278.91 | 279.45 | 278.9 | 279.45 | 14504.0 |
| 2020-04-15 07:00:00 | SPY | ETF | 279.49 | 279.75 | 279.4 | 279.46 | 145074.0 |
| 2020-04-15 07:05:00 | SPY | ETF | 279.49 | 279.68 | 279.28 | 279.68 | 77371.0 |
| 2020-04-15 07:10:00 | SPY | ETF | 279.62 | 279.82 | 279.36 | 279.71 | 80366.0 |
| 2020-04-15 07:15:00 | SPY | ETF | 279.76 | 279.94 | 279.66 | 279.78 | 79922.0 |
| 2020-04-15 07:20:00 | SPY | ETF | 279.85 | 279.96 | 279.74 | 279.77 | 218644.0 |
| 2020-04-15 07:25:00 | SPY | ETF | 279.77 | 280.23 | 279.77 | 280.16 | 64452.0 |
| 2020-04-15 07:30:00 | SPY | ETF | 280.12 | 280.15 | 279.88 | 279.88 | 115384.0 |
| 2020-04-15 07:35:00 | SPY | ETF | 279.88 | 279.91 | 279.71 | 279.71 | 46752.0 |
| 2020-04-15 07:40:00 | SPY | ETF | 279.71 | 279.71 | 279.35 | 279.38 | 57389.0 |
| 2020-04-15 07:45:00 | SPY | ETF | 279.38 | 279.68 | 279.32 | 279.68 | 23057.0 |
| 2020-04-15 07:50:00 | SPY | ETF | 279.81 | 279.89 | 279.35 | 279.4 | 71616.0 |
| 2020-04-15 07:55:00 | SPY | ETF | 279.35 | 279.55 | 279.29 | 279.29 | 51890.0 |
| 2020-04-15 08:00:00 | SPY | ETF | 279.3799 | 283.68 | 279.26 | 279.46 | 138021.0 |
| 2020-04-15 08:05:00 | SPY | ETF | 279.46 | 279.69 | 278.55 | 278.65 | 207074.0 |
> showing 50 of 79,212 rows — these rows as CSV