PREVIEW / etf_5min / 2020-04-16
file: by_date/etf_5min/2020/2020-04-16.parquet size: 1.8 MB rows: 79,869
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-16 04:00:00 | SPY | ETF | 279.89 | 280.18 | 279.55 | 279.69 | 26392.0 |
| 2020-04-16 04:05:00 | SPY | ETF | 279.61 | 280.26 | 279.61 | 280.13 | 15409.0 |
| 2020-04-16 04:10:00 | SPY | ETF | 279.9 | 280.11 | 279.9 | 279.96 | 3671.0 |
| 2020-04-16 04:15:00 | SPY | ETF | 279.98 | 280.22 | 279.95 | 279.95 | 11759.0 |
| 2020-04-16 04:20:00 | SPY | ETF | 279.87 | 279.89 | 279.67 | 279.85 | 5421.0 |
| 2020-04-16 04:25:00 | SPY | ETF | 279.66 | 279.81 | 279.66 | 279.73 | 5436.0 |
| 2020-04-16 04:30:00 | SPY | ETF | 279.71 | 279.81 | 279.54 | 279.81 | 3975.0 |
| 2020-04-16 04:35:00 | SPY | ETF | 279.88 | 280.0 | 279.65 | 279.65 | 6149.0 |
| 2020-04-16 04:40:00 | SPY | ETF | 279.57 | 279.57 | 279.54 | 279.54 | 2173.0 |
| 2020-04-16 04:45:00 | SPY | ETF | 279.62 | 279.62 | 279.46 | 279.46 | 1530.0 |
| 2020-04-16 04:50:00 | SPY | ETF | 279.5 | 279.68 | 279.35 | 279.43 | 2620.0 |
| 2020-04-16 04:55:00 | SPY | ETF | 279.37 | 279.46 | 279.37 | 279.39 | 1760.0 |
| 2020-04-16 05:00:00 | SPY | ETF | 279.17 | 279.19 | 278.6 | 278.67 | 15730.0 |
| 2020-04-16 05:05:00 | SPY | ETF | 278.66 | 279.03 | 278.63 | 279.03 | 7150.0 |
| 2020-04-16 05:10:00 | SPY | ETF | 278.82 | 279.04 | 278.77 | 279.04 | 5590.0 |
| 2020-04-16 05:15:00 | SPY | ETF | 279.08 | 279.17 | 279.04 | 279.17 | 4805.0 |
| 2020-04-16 05:20:00 | SPY | ETF | 279.18 | 279.18 | 278.73 | 278.73 | 2258.0 |
| 2020-04-16 05:25:00 | SPY | ETF | 278.74 | 278.91 | 278.59 | 278.59 | 2660.0 |
| 2020-04-16 05:30:00 | SPY | ETF | 278.59 | 278.83 | 278.59 | 278.83 | 3715.0 |
| 2020-04-16 05:35:00 | SPY | ETF | 278.74 | 279.17 | 278.71 | 279.05 | 12753.0 |
| 2020-04-16 05:40:00 | SPY | ETF | 279.15 | 279.52 | 279.13 | 279.45 | 10610.0 |
| 2020-04-16 05:45:00 | SPY | ETF | 279.52 | 279.52 | 279.37 | 279.45 | 12622.0 |
| 2020-04-16 05:50:00 | SPY | ETF | 279.32 | 279.36 | 279.13 | 279.13 | 4028.0 |
| 2020-04-16 05:55:00 | SPY | ETF | 279.1 | 279.25 | 279.0 | 279.25 | 6200.0 |
| 2020-04-16 06:00:00 | SPY | ETF | 279.28 | 279.35 | 278.67 | 278.67 | 6649.0 |
| 2020-04-16 06:05:00 | SPY | ETF | 278.7 | 278.8 | 278.4 | 278.75 | 9887.0 |
| 2020-04-16 06:10:00 | SPY | ETF | 278.8 | 279.05 | 278.8 | 279.05 | 5930.0 |
| 2020-04-16 06:15:00 | SPY | ETF | 279.0 | 279.13 | 278.9 | 279.13 | 3124.0 |
| 2020-04-16 06:20:00 | SPY | ETF | 279.08 | 279.1 | 279.08 | 279.1 | 200.0 |
| 2020-04-16 06:25:00 | SPY | ETF | 279.42 | 279.62 | 279.42 | 279.62 | 33795.0 |
| 2020-04-16 06:30:00 | SPY | ETF | 279.71 | 279.74 | 279.53 | 279.53 | 10273.0 |
| 2020-04-16 06:35:00 | SPY | ETF | 279.56 | 279.59 | 279.4 | 279.4 | 5171.0 |
| 2020-04-16 06:40:00 | SPY | ETF | 279.4 | 279.69 | 279.4 | 279.65 | 11074.0 |
| 2020-04-16 06:45:00 | SPY | ETF | 279.66 | 279.66 | 279.1 | 279.15 | 35835.0 |
| 2020-04-16 06:50:00 | SPY | ETF | 279.18 | 279.36 | 279.0 | 279.34 | 22193.0 |
| 2020-04-16 06:55:00 | SPY | ETF | 279.26 | 279.27 | 279.11 | 279.16 | 4017.0 |
| 2020-04-16 07:00:00 | SPY | ETF | 279.2 | 279.2 | 278.86 | 278.86 | 33672.0 |
| 2020-04-16 07:05:00 | SPY | ETF | 278.86 | 278.96 | 278.73 | 278.87 | 77757.0 |
| 2020-04-16 07:10:00 | SPY | ETF | 278.89 | 279.11 | 278.85 | 279.11 | 16185.0 |
| 2020-04-16 07:15:00 | SPY | ETF | 279.0 | 279.02 | 278.85 | 278.95 | 7725.0 |
| 2020-04-16 07:20:00 | SPY | ETF | 278.98 | 279.21 | 278.98 | 279.11 | 21310.0 |
| 2020-04-16 07:25:00 | SPY | ETF | 279.15 | 279.25 | 279.01 | 279.08 | 14390.0 |
| 2020-04-16 07:30:00 | SPY | ETF | 279.19 | 279.24 | 278.34 | 278.34 | 32343.0 |
| 2020-04-16 07:35:00 | SPY | ETF | 278.33 | 278.44 | 278.11 | 278.13 | 36181.0 |
| 2020-04-16 07:40:00 | SPY | ETF | 278.13 | 278.26 | 277.98 | 278.0 | 50045.0 |
| 2020-04-16 07:45:00 | SPY | ETF | 278.05 | 278.23 | 278.0 | 278.08 | 31173.0 |
| 2020-04-16 07:50:00 | SPY | ETF | 278.0 | 278.35 | 277.89 | 278.3 | 85992.0 |
| 2020-04-16 07:55:00 | SPY | ETF | 278.34 | 278.4 | 278.1 | 278.3 | 21863.0 |
| 2020-04-16 08:00:00 | SPY | ETF | 279.02 | 280.7 | 276.32 | 278.42 | 191619.0 |
| 2020-04-16 08:05:00 | SPY | ETF | 278.38 | 278.62 | 277.99 | 278.26 | 42281.0 |
> showing 50 of 79,869 rows — these rows as CSV