PREVIEW / etf_5min / 2016-10-11
file: by_date/etf_5min/2016/2016-10-11.parquet size: 1.2 MB rows: 52,006
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 |
|---|---|---|---|---|---|---|---|
| 2016-10-11 04:00:00 | SPY | ETF | 215.91 | 215.91 | 215.9 | 215.9 | 5228.0 |
| 2016-10-11 04:05:00 | SPY | ETF | 215.9 | 215.9 | 215.85 | 215.85 | 13062.0 |
| 2016-10-11 04:10:00 | SPY | ETF | 215.82 | 215.82 | 215.8 | 215.8 | 3178.0 |
| 2016-10-11 04:15:00 | SPY | ETF | 215.78 | 215.78 | 215.77 | 215.77 | 5800.0 |
| 2016-10-11 04:20:00 | SPY | ETF | 215.78 | 215.78 | 215.73 | 215.73 | 904.0 |
| 2016-10-11 04:30:00 | SPY | ETF | 215.78 | 215.78 | 215.78 | 215.78 | 1010.0 |
| 2016-10-11 04:35:00 | SPY | ETF | 215.78 | 215.81 | 215.77 | 215.81 | 1812.0 |
| 2016-10-11 04:40:00 | SPY | ETF | 215.78 | 215.78 | 215.72 | 215.72 | 4754.0 |
| 2016-10-11 04:45:00 | SPY | ETF | 215.76 | 215.76 | 215.76 | 215.76 | 100.0 |
| 2016-10-11 04:50:00 | SPY | ETF | 215.7 | 215.76 | 215.7 | 215.71 | 2053.0 |
| 2016-10-11 04:55:00 | SPY | ETF | 215.67 | 215.67 | 215.59 | 215.66 | 3101.0 |
| 2016-10-11 05:00:00 | SPY | ETF | 215.6 | 215.6 | 215.58 | 215.58 | 1002.0 |
| 2016-10-11 05:05:00 | SPY | ETF | 215.6 | 215.6 | 215.59 | 215.59 | 600.0 |
| 2016-10-11 05:20:00 | SPY | ETF | 215.63 | 215.64 | 215.62 | 215.62 | 1503.0 |
| 2016-10-11 05:25:00 | SPY | ETF | 215.69 | 215.69 | 215.69 | 215.69 | 199.0 |
| 2016-10-11 05:30:00 | SPY | ETF | 215.71 | 215.71 | 215.71 | 215.71 | 176.0 |
| 2016-10-11 05:35:00 | SPY | ETF | 215.68 | 215.68 | 215.68 | 215.68 | 200.0 |
| 2016-10-11 05:40:00 | SPY | ETF | 215.72 | 215.72 | 215.72 | 215.72 | 2000.0 |
| 2016-10-11 05:45:00 | SPY | ETF | 215.76 | 215.76 | 215.76 | 215.76 | 11100.0 |
| 2016-10-11 05:55:00 | SPY | ETF | 215.81 | 215.81 | 215.81 | 215.81 | 558.0 |
| 2016-10-11 06:05:00 | SPY | ETF | 215.75 | 215.75 | 215.73 | 215.73 | 352.0 |
| 2016-10-11 06:20:00 | SPY | ETF | 215.78 | 215.78 | 215.77 | 215.77 | 5801.0 |
| 2016-10-11 06:30:00 | SPY | ETF | 215.87 | 215.9 | 215.87 | 215.9 | 800.0 |
| 2016-10-11 06:35:00 | SPY | ETF | 215.91 | 215.91 | 215.91 | 215.91 | 478.0 |
| 2016-10-11 06:40:00 | SPY | ETF | 215.91 | 215.91 | 215.85 | 215.85 | 7250.0 |
| 2016-10-11 06:45:00 | SPY | ETF | 215.85 | 215.9 | 215.85 | 215.87 | 4901.0 |
| 2016-10-11 06:50:00 | SPY | ETF | 215.89 | 215.9 | 215.87 | 215.87 | 10401.0 |
| 2016-10-11 06:55:00 | SPY | ETF | 215.87 | 215.87 | 215.87 | 215.87 | 601.0 |
| 2016-10-11 07:00:00 | SPY | ETF | 215.97 | 215.97 | 215.97 | 215.97 | 603.0 |
| 2016-10-11 07:05:00 | SPY | ETF | 215.95 | 215.95 | 215.94 | 215.94 | 1509.0 |
| 2016-10-11 07:10:00 | SPY | ETF | 216.0 | 216.02 | 215.98 | 215.98 | 9725.0 |
| 2016-10-11 07:15:00 | SPY | ETF | 216.0 | 216.0 | 215.93 | 215.93 | 17153.0 |
| 2016-10-11 07:20:00 | SPY | ETF | 215.92 | 215.93 | 215.79 | 215.79 | 17193.0 |
| 2016-10-11 07:25:00 | SPY | ETF | 215.85 | 215.85 | 215.78 | 215.78 | 17978.0 |
| 2016-10-11 07:30:00 | SPY | ETF | 215.84 | 215.86 | 215.84 | 215.84 | 4623.0 |
| 2016-10-11 07:35:00 | SPY | ETF | 215.83 | 215.92 | 215.83 | 215.92 | 9153.0 |
| 2016-10-11 07:40:00 | SPY | ETF | 215.92 | 215.92 | 215.86 | 215.92 | 5302.0 |
| 2016-10-11 07:45:00 | SPY | ETF | 215.89 | 215.89 | 215.83 | 215.83 | 30784.0 |
| 2016-10-11 07:50:00 | SPY | ETF | 215.88 | 215.88 | 215.84 | 215.84 | 39000.0 |
| 2016-10-11 07:55:00 | SPY | ETF | 215.85 | 215.85 | 215.64 | 215.67 | 76111.0 |
| 2016-10-11 08:00:00 | SPY | ETF | 215.69 | 215.94 | 215.65 | 215.68 | 83086.0 |
| 2016-10-11 08:05:00 | SPY | ETF | 215.68 | 215.68 | 215.64 | 215.65 | 99605.0 |
| 2016-10-11 08:10:00 | SPY | ETF | 215.65 | 215.67 | 215.62 | 215.63 | 38352.0 |
| 2016-10-11 08:15:00 | SPY | ETF | 215.62 | 215.65 | 215.57 | 215.61 | 96749.0 |
| 2016-10-11 08:20:00 | SPY | ETF | 215.59 | 215.65 | 215.55 | 215.65 | 68771.0 |
| 2016-10-11 08:25:00 | SPY | ETF | 215.64 | 215.65 | 215.61 | 215.64 | 21642.0 |
| 2016-10-11 08:30:00 | SPY | ETF | 215.64 | 215.69 | 215.58 | 215.69 | 34773.0 |
| 2016-10-11 08:35:00 | SPY | ETF | 215.68 | 215.71 | 215.67 | 215.71 | 2178.0 |
| 2016-10-11 08:40:00 | SPY | ETF | 215.71 | 215.74 | 215.7 | 215.73 | 67212.0 |
| 2016-10-11 08:45:00 | SPY | ETF | 215.7 | 215.7 | 215.65 | 215.65 | 2354.0 |
> showing 50 of 52,006 rows — these rows as CSV