PREVIEW / etf_5min / 2018-11-07
file: by_date/etf_5min/2018/2018-11-07.parquet size: 1.5 MB rows: 64,279
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 |
|---|---|---|---|---|---|---|---|
| 2018-11-07 04:00:00 | SPY | ETF | 277.29 | 277.6 | 277.29 | 277.35 | 7665.0 |
| 2018-11-07 04:05:00 | SPY | ETF | 277.4 | 277.63 | 277.4 | 277.47 | 25739.0 |
| 2018-11-07 04:10:00 | SPY | ETF | 277.46 | 277.5 | 277.43 | 277.46 | 9220.0 |
| 2018-11-07 04:15:00 | SPY | ETF | 277.51 | 277.82 | 277.51 | 277.8 | 11370.0 |
| 2018-11-07 04:20:00 | SPY | ETF | 277.73 | 277.75 | 277.63 | 277.66 | 3140.0 |
| 2018-11-07 04:25:00 | SPY | ETF | 277.66 | 277.69 | 277.63 | 277.65 | 1238.0 |
| 2018-11-07 04:30:00 | SPY | ETF | 277.79 | 277.8 | 277.71 | 277.71 | 5270.0 |
| 2018-11-07 04:35:00 | SPY | ETF | 277.79 | 277.99 | 277.75 | 277.77 | 13765.0 |
| 2018-11-07 04:40:00 | SPY | ETF | 277.74 | 277.9 | 277.74 | 277.83 | 2489.0 |
| 2018-11-07 04:45:00 | SPY | ETF | 277.82 | 277.94 | 277.82 | 277.89 | 1100.0 |
| 2018-11-07 04:50:00 | SPY | ETF | 277.89 | 278.13 | 277.88 | 278.13 | 8235.0 |
| 2018-11-07 04:55:00 | SPY | ETF | 278.08 | 278.29 | 278.08 | 278.25 | 8882.0 |
| 2018-11-07 05:00:00 | SPY | ETF | 278.2 | 278.34 | 278.15 | 278.23 | 6245.0 |
| 2018-11-07 05:05:00 | SPY | ETF | 278.13 | 278.25 | 278.11 | 278.25 | 7146.0 |
| 2018-11-07 05:10:00 | SPY | ETF | 278.27 | 278.34 | 278.16 | 278.22 | 8309.0 |
| 2018-11-07 05:15:00 | SPY | ETF | 278.23 | 278.23 | 278.17 | 278.17 | 2269.0 |
| 2018-11-07 05:20:00 | SPY | ETF | 278.14 | 278.18 | 278.04 | 278.07 | 4419.0 |
| 2018-11-07 05:25:00 | SPY | ETF | 278.04 | 278.07 | 277.9 | 277.94 | 14545.0 |
| 2018-11-07 05:30:00 | SPY | ETF | 277.95 | 278.05 | 277.94 | 278.05 | 6500.0 |
| 2018-11-07 05:35:00 | SPY | ETF | 278.02 | 278.14 | 278.02 | 278.14 | 7085.0 |
| 2018-11-07 05:40:00 | SPY | ETF | 278.14 | 278.14 | 278.02 | 278.02 | 1203.0 |
| 2018-11-07 05:45:00 | SPY | ETF | 278.02 | 278.14 | 277.98 | 278.09 | 3910.0 |
| 2018-11-07 05:50:00 | SPY | ETF | 278.13 | 278.15 | 278.02 | 278.02 | 2859.0 |
| 2018-11-07 05:55:00 | SPY | ETF | 278.0 | 278.06 | 277.92 | 278.06 | 3365.0 |
| 2018-11-07 06:00:00 | SPY | ETF | 278.03 | 278.03 | 278.03 | 278.03 | 700.0 |
| 2018-11-07 06:05:00 | SPY | ETF | 277.97 | 277.98 | 277.83 | 277.91 | 14350.0 |
| 2018-11-07 06:10:00 | SPY | ETF | 277.84 | 277.92 | 277.78 | 277.78 | 4410.0 |
| 2018-11-07 06:15:00 | SPY | ETF | 277.78 | 277.87 | 277.75 | 277.87 | 9100.0 |
| 2018-11-07 06:20:00 | SPY | ETF | 277.87 | 277.94 | 277.87 | 277.92 | 4605.0 |
| 2018-11-07 06:25:00 | SPY | ETF | 277.94 | 278.08 | 277.94 | 278.03 | 4120.0 |
| 2018-11-07 06:30:00 | SPY | ETF | 278.0 | 278.0 | 277.89 | 277.9 | 7098.0 |
| 2018-11-07 06:35:00 | SPY | ETF | 277.88 | 277.88 | 277.65 | 277.75 | 8889.0 |
| 2018-11-07 06:40:00 | SPY | ETF | 277.72 | 277.82 | 277.69 | 277.69 | 18747.0 |
| 2018-11-07 06:45:00 | SPY | ETF | 277.7 | 277.73 | 277.63 | 277.65 | 50490.0 |
| 2018-11-07 06:50:00 | SPY | ETF | 277.68 | 277.68 | 277.51 | 277.63 | 38686.0 |
| 2018-11-07 06:55:00 | SPY | ETF | 277.57 | 277.64 | 277.55 | 277.6 | 77859.0 |
| 2018-11-07 07:00:00 | SPY | ETF | 277.64 | 277.73 | 277.6 | 277.73 | 49672.0 |
| 2018-11-07 07:05:00 | SPY | ETF | 277.73 | 277.87 | 277.73 | 277.87 | 35037.0 |
| 2018-11-07 07:10:00 | SPY | ETF | 277.86 | 277.99 | 277.84 | 277.98 | 46102.0 |
| 2018-11-07 07:15:00 | SPY | ETF | 277.98 | 278.04 | 277.96 | 277.98 | 76924.0 |
| 2018-11-07 07:20:00 | SPY | ETF | 278.0 | 278.04 | 277.87 | 277.9 | 55081.0 |
| 2018-11-07 07:25:00 | SPY | ETF | 277.89 | 277.96 | 277.86 | 277.88 | 19464.0 |
| 2018-11-07 07:30:00 | SPY | ETF | 277.91 | 277.96 | 277.77 | 277.95 | 23496.0 |
| 2018-11-07 07:35:00 | SPY | ETF | 277.98 | 277.99 | 277.71 | 277.76 | 36849.0 |
| 2018-11-07 07:40:00 | SPY | ETF | 277.83 | 277.83 | 277.46 | 277.49 | 37787.0 |
| 2018-11-07 07:45:00 | SPY | ETF | 277.49 | 277.49 | 277.3 | 277.3 | 65714.0 |
| 2018-11-07 07:50:00 | SPY | ETF | 277.33 | 277.43 | 277.25 | 277.32 | 66260.0 |
| 2018-11-07 07:55:00 | SPY | ETF | 277.34 | 277.35 | 277.21 | 277.24 | 23125.0 |
| 2018-11-07 08:00:00 | SPY | ETF | 277.94 | 278.0101 | 277.18 | 277.21 | 56508.0 |
| 2018-11-07 08:05:00 | SPY | ETF | 277.2 | 277.25 | 277.06 | 277.14 | 91311.0 |
> showing 50 of 64,279 rows — these rows as CSV