PREVIEW / etf_5min / 2016-04-27
file: by_date/etf_5min/2016/2016-04-27.parquet size: 1.2 MB rows: 49,412
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-04-27 04:00:00 | SPY | ETF | 208.84 | 208.91 | 208.84 | 208.91 | 1670.0 |
| 2016-04-27 04:05:00 | SPY | ETF | 208.73 | 208.73 | 208.67 | 208.72 | 590.0 |
| 2016-04-27 04:10:00 | SPY | ETF | 208.64 | 208.64 | 208.61 | 208.61 | 31519.0 |
| 2016-04-27 04:15:00 | SPY | ETF | 208.61 | 208.62 | 208.57 | 208.62 | 866.0 |
| 2016-04-27 04:20:00 | SPY | ETF | 208.67 | 208.67 | 208.67 | 208.67 | 1002.0 |
| 2016-04-27 04:30:00 | SPY | ETF | 208.65 | 208.67 | 208.65 | 208.67 | 1701.0 |
| 2016-04-27 04:35:00 | SPY | ETF | 208.64 | 208.67 | 208.64 | 208.67 | 950.0 |
| 2016-04-27 04:45:00 | SPY | ETF | 208.84 | 208.84 | 208.84 | 208.84 | 434.0 |
| 2016-04-27 04:50:00 | SPY | ETF | 208.94 | 208.94 | 208.89 | 208.89 | 2653.0 |
| 2016-04-27 04:55:00 | SPY | ETF | 208.92 | 208.94 | 208.92 | 208.94 | 1603.0 |
| 2016-04-27 05:00:00 | SPY | ETF | 208.85 | 208.85 | 208.85 | 208.85 | 906.0 |
| 2016-04-27 05:05:00 | SPY | ETF | 208.79 | 208.82 | 208.79 | 208.82 | 6002.0 |
| 2016-04-27 05:10:00 | SPY | ETF | 208.8 | 208.8 | 208.8 | 208.8 | 2400.0 |
| 2016-04-27 05:20:00 | SPY | ETF | 208.75 | 208.75 | 208.72 | 208.72 | 5204.0 |
| 2016-04-27 05:25:00 | SPY | ETF | 208.72 | 208.75 | 208.72 | 208.75 | 10901.0 |
| 2016-04-27 05:35:00 | SPY | ETF | 208.78 | 208.78 | 208.78 | 208.78 | 7701.0 |
| 2016-04-27 05:40:00 | SPY | ETF | 208.75 | 208.75 | 208.7 | 208.7 | 15301.0 |
| 2016-04-27 05:45:00 | SPY | ETF | 208.73 | 208.77 | 208.73 | 208.77 | 7104.0 |
| 2016-04-27 05:50:00 | SPY | ETF | 208.71 | 208.71 | 208.71 | 208.71 | 3502.0 |
| 2016-04-27 05:55:00 | SPY | ETF | 208.71 | 208.71 | 208.7 | 208.7 | 18406.0 |
| 2016-04-27 06:05:00 | SPY | ETF | 208.7 | 208.7 | 208.7 | 208.7 | 1000.0 |
| 2016-04-27 06:10:00 | SPY | ETF | 208.73 | 208.75 | 208.73 | 208.75 | 2704.0 |
| 2016-04-27 06:15:00 | SPY | ETF | 208.76 | 208.76 | 208.76 | 208.76 | 3004.0 |
| 2016-04-27 06:20:00 | SPY | ETF | 208.78 | 208.78 | 208.78 | 208.78 | 2700.0 |
| 2016-04-27 06:25:00 | SPY | ETF | 208.76 | 208.76 | 208.75 | 208.75 | 8501.0 |
| 2016-04-27 06:30:00 | SPY | ETF | 208.78 | 208.78 | 208.78 | 208.78 | 100.0 |
| 2016-04-27 06:35:00 | SPY | ETF | 208.72 | 208.72 | 208.63 | 208.63 | 8606.0 |
| 2016-04-27 06:40:00 | SPY | ETF | 208.6 | 208.65 | 208.6 | 208.6 | 2895.0 |
| 2016-04-27 06:45:00 | SPY | ETF | 208.6 | 208.65 | 208.6 | 208.64 | 5001.0 |
| 2016-04-27 06:55:00 | SPY | ETF | 208.66 | 208.66 | 208.66 | 208.66 | 2502.0 |
| 2016-04-27 07:00:00 | SPY | ETF | 208.71 | 208.72 | 208.71 | 208.72 | 1201.0 |
| 2016-04-27 07:05:00 | SPY | ETF | 208.76 | 208.77 | 208.74 | 208.77 | 3660.0 |
| 2016-04-27 07:10:00 | SPY | ETF | 208.75 | 208.75 | 208.74 | 208.74 | 2301.0 |
| 2016-04-27 07:15:00 | SPY | ETF | 208.73 | 208.73 | 208.68 | 208.68 | 2405.0 |
| 2016-04-27 07:20:00 | SPY | ETF | 208.66 | 208.67 | 208.64 | 208.66 | 2457.0 |
| 2016-04-27 07:25:00 | SPY | ETF | 208.65 | 208.71 | 208.65 | 208.71 | 2101.0 |
| 2016-04-27 07:30:00 | SPY | ETF | 208.67 | 208.69 | 208.67 | 208.69 | 401.0 |
| 2016-04-27 07:35:00 | SPY | ETF | 208.69 | 208.73 | 208.68 | 208.73 | 4005.0 |
| 2016-04-27 07:40:00 | SPY | ETF | 208.72 | 208.8 | 208.72 | 208.8 | 87651.0 |
| 2016-04-27 07:45:00 | SPY | ETF | 208.82 | 208.84 | 208.79 | 208.79 | 56890.0 |
| 2016-04-27 07:50:00 | SPY | ETF | 208.8 | 208.8 | 208.73 | 208.73 | 16454.0 |
| 2016-04-27 07:55:00 | SPY | ETF | 208.72 | 208.73 | 208.69 | 208.73 | 7161.0 |
| 2016-04-27 08:00:00 | SPY | ETF | 208.72 | 208.83 | 208.65 | 208.8 | 24659.0 |
| 2016-04-27 08:05:00 | SPY | ETF | 208.8 | 208.86 | 208.8 | 208.83 | 9344.0 |
| 2016-04-27 08:10:00 | SPY | ETF | 208.81 | 208.82 | 208.73 | 208.82 | 14608.0 |
| 2016-04-27 08:15:00 | SPY | ETF | 208.8 | 208.8 | 208.76 | 208.78 | 7233.0 |
| 2016-04-27 08:20:00 | SPY | ETF | 208.78 | 208.84 | 208.77 | 208.77 | 64828.0 |
| 2016-04-27 08:25:00 | SPY | ETF | 208.76 | 208.78 | 208.72 | 208.75 | 50236.0 |
| 2016-04-27 08:30:00 | SPY | ETF | 208.75 | 208.78 | 208.75 | 208.76 | 13657.0 |
| 2016-04-27 08:35:00 | SPY | ETF | 208.76 | 208.8 | 208.7 | 208.7 | 21542.0 |
> showing 50 of 49,412 rows — these rows as CSV