PREVIEW / etf_5min / 2018-11-15
file: by_date/etf_5min/2018/2018-11-15.parquet size: 1.4 MB rows: 63,393
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-15 04:00:00 | SPY | ETF | 270.23 | 270.35 | 270.17 | 270.35 | 5396.0 |
| 2018-11-15 04:05:00 | SPY | ETF | 270.15 | 270.15 | 269.93 | 270.15 | 3704.0 |
| 2018-11-15 04:10:00 | SPY | ETF | 270.15 | 270.36 | 270.15 | 270.36 | 480.0 |
| 2018-11-15 04:15:00 | SPY | ETF | 270.35 | 270.51 | 270.35 | 270.51 | 3950.0 |
| 2018-11-15 04:20:00 | SPY | ETF | 270.55 | 270.55 | 270.45 | 270.48 | 4338.0 |
| 2018-11-15 04:25:00 | SPY | ETF | 270.41 | 270.41 | 270.17 | 270.17 | 4805.0 |
| 2018-11-15 04:30:00 | SPY | ETF | 270.13 | 270.14 | 270.01 | 270.01 | 8430.0 |
| 2018-11-15 04:35:00 | SPY | ETF | 270.1 | 270.1 | 269.85 | 269.85 | 3706.0 |
| 2018-11-15 04:40:00 | SPY | ETF | 269.9 | 269.9 | 269.71 | 269.71 | 5310.0 |
| 2018-11-15 04:45:00 | SPY | ETF | 269.79 | 269.89 | 269.7 | 269.83 | 3801.0 |
| 2018-11-15 04:50:00 | SPY | ETF | 269.82 | 269.82 | 269.77 | 269.77 | 2000.0 |
| 2018-11-15 04:55:00 | SPY | ETF | 269.85 | 269.87 | 269.72 | 269.77 | 13807.0 |
| 2018-11-15 05:00:00 | SPY | ETF | 269.77 | 269.77 | 269.32 | 269.35 | 30951.0 |
| 2018-11-15 05:05:00 | SPY | ETF | 269.4 | 269.59 | 269.34 | 269.54 | 10266.0 |
| 2018-11-15 05:10:00 | SPY | ETF | 269.54 | 269.66 | 269.54 | 269.54 | 8327.0 |
| 2018-11-15 05:15:00 | SPY | ETF | 269.66 | 269.89 | 269.66 | 269.85 | 7637.0 |
| 2018-11-15 05:20:00 | SPY | ETF | 269.91 | 270.0 | 269.91 | 270.0 | 6394.0 |
| 2018-11-15 05:25:00 | SPY | ETF | 269.98 | 270.05 | 269.92 | 269.98 | 17737.0 |
| 2018-11-15 05:30:00 | SPY | ETF | 269.98 | 270.21 | 269.83 | 270.2 | 15270.0 |
| 2018-11-15 05:35:00 | SPY | ETF | 270.22 | 270.38 | 270.22 | 270.35 | 6208.0 |
| 2018-11-15 05:40:00 | SPY | ETF | 270.38 | 270.38 | 270.18 | 270.3 | 13426.0 |
| 2018-11-15 05:45:00 | SPY | ETF | 270.26 | 270.35 | 270.04 | 270.34 | 16683.0 |
| 2018-11-15 05:50:00 | SPY | ETF | 270.28 | 270.31 | 270.2 | 270.25 | 7245.0 |
| 2018-11-15 05:55:00 | SPY | ETF | 270.3 | 270.56 | 270.25 | 270.5 | 14380.0 |
| 2018-11-15 06:00:00 | SPY | ETF | 270.52 | 270.65 | 270.45 | 270.65 | 8248.0 |
| 2018-11-15 06:05:00 | SPY | ETF | 270.63 | 270.89 | 270.63 | 270.8 | 12545.0 |
| 2018-11-15 06:10:00 | SPY | ETF | 270.83 | 270.83 | 270.71 | 270.71 | 10138.0 |
| 2018-11-15 06:15:00 | SPY | ETF | 270.73 | 270.76 | 270.71 | 270.73 | 3900.0 |
| 2018-11-15 06:20:00 | SPY | ETF | 270.73 | 270.73 | 270.65 | 270.68 | 9530.0 |
| 2018-11-15 06:25:00 | SPY | ETF | 270.7 | 270.7 | 270.55 | 270.55 | 14969.0 |
| 2018-11-15 06:30:00 | SPY | ETF | 270.51 | 270.51 | 270.34 | 270.5 | 18045.0 |
| 2018-11-15 06:35:00 | SPY | ETF | 270.55 | 270.55 | 270.42 | 270.42 | 6169.0 |
| 2018-11-15 06:40:00 | SPY | ETF | 270.5 | 270.5 | 270.35 | 270.36 | 8648.0 |
| 2018-11-15 06:45:00 | SPY | ETF | 270.41 | 270.45 | 270.3 | 270.3 | 8244.0 |
| 2018-11-15 06:50:00 | SPY | ETF | 270.31 | 270.75 | 270.3 | 270.75 | 27036.0 |
| 2018-11-15 06:55:00 | SPY | ETF | 270.75 | 270.76 | 270.6 | 270.6 | 12138.0 |
| 2018-11-15 07:00:00 | SPY | ETF | 270.57 | 270.83 | 270.57 | 270.77 | 30483.0 |
| 2018-11-15 07:05:00 | SPY | ETF | 270.75 | 270.79 | 270.67 | 270.76 | 12393.0 |
| 2018-11-15 07:10:00 | SPY | ETF | 270.66 | 270.68 | 270.5 | 270.5 | 10669.0 |
| 2018-11-15 07:15:00 | SPY | ETF | 270.51 | 270.63 | 270.4 | 270.6 | 60738.0 |
| 2018-11-15 07:20:00 | SPY | ETF | 270.6 | 270.64 | 270.49 | 270.6 | 88472.0 |
| 2018-11-15 07:25:00 | SPY | ETF | 270.6 | 270.77 | 270.58 | 270.75 | 84933.0 |
| 2018-11-15 07:30:00 | SPY | ETF | 270.7 | 270.75 | 270.65 | 270.65 | 34890.0 |
| 2018-11-15 07:35:00 | SPY | ETF | 270.6 | 270.63 | 270.47 | 270.48 | 25382.0 |
| 2018-11-15 07:40:00 | SPY | ETF | 270.52 | 270.52 | 270.26 | 270.29 | 32990.0 |
| 2018-11-15 07:45:00 | SPY | ETF | 270.31 | 270.36 | 270.24 | 270.36 | 16363.0 |
| 2018-11-15 07:50:00 | SPY | ETF | 270.39 | 270.39 | 270.24 | 270.31 | 42875.0 |
| 2018-11-15 07:55:00 | SPY | ETF | 270.28 | 270.28 | 270.05 | 270.06 | 70778.0 |
| 2018-11-15 08:00:00 | SPY | ETF | 270.06 | 270.77 | 269.25 | 270.03 | 121000.0 |
| 2018-11-15 08:05:00 | SPY | ETF | 270.05 | 270.16 | 269.63 | 269.69 | 110424.0 |
> showing 50 of 63,393 rows — these rows as CSV