PREVIEW / etf_5min / 2016-06-10
file: by_date/etf_5min/2016/2016-06-10.parquet size: 1.2 MB rows: 49,561
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-06-10 04:00:00 | SPY | ETF | 211.13 | 211.15 | 211.01 | 211.15 | 5191.0 |
| 2016-06-10 04:05:00 | SPY | ETF | 211.05 | 211.05 | 210.89 | 210.89 | 2356.0 |
| 2016-06-10 04:10:00 | SPY | ETF | 210.94 | 211.04 | 210.94 | 211.04 | 13143.0 |
| 2016-06-10 04:15:00 | SPY | ETF | 211.02 | 211.02 | 211.02 | 211.02 | 215.0 |
| 2016-06-10 04:20:00 | SPY | ETF | 211.05 | 211.07 | 211.05 | 211.07 | 201.0 |
| 2016-06-10 04:25:00 | SPY | ETF | 211.05 | 211.05 | 211.05 | 211.05 | 100.0 |
| 2016-06-10 04:30:00 | SPY | ETF | 211.05 | 211.1 | 211.05 | 211.1 | 2213.0 |
| 2016-06-10 04:40:00 | SPY | ETF | 211.1 | 211.1 | 211.1 | 211.1 | 500.0 |
| 2016-06-10 04:50:00 | SPY | ETF | 210.95 | 210.98 | 210.95 | 210.97 | 1652.0 |
| 2016-06-10 04:55:00 | SPY | ETF | 210.97 | 210.97 | 210.94 | 210.94 | 47351.0 |
| 2016-06-10 05:00:00 | SPY | ETF | 210.95 | 210.97 | 210.94 | 210.97 | 14470.0 |
| 2016-06-10 05:05:00 | SPY | ETF | 210.93 | 210.93 | 210.69 | 210.69 | 16908.0 |
| 2016-06-10 05:10:00 | SPY | ETF | 210.69 | 210.72 | 210.62 | 210.67 | 7150.0 |
| 2016-06-10 05:15:00 | SPY | ETF | 210.73 | 210.75 | 210.73 | 210.74 | 10501.0 |
| 2016-06-10 05:20:00 | SPY | ETF | 210.7 | 210.72 | 210.66 | 210.68 | 26203.0 |
| 2016-06-10 05:25:00 | SPY | ETF | 210.73 | 210.82 | 210.73 | 210.82 | 1108.0 |
| 2016-06-10 05:30:00 | SPY | ETF | 210.86 | 210.87 | 210.82 | 210.85 | 1314.0 |
| 2016-06-10 05:35:00 | SPY | ETF | 210.78 | 210.83 | 210.78 | 210.83 | 441.0 |
| 2016-06-10 05:40:00 | SPY | ETF | 210.75 | 210.83 | 210.75 | 210.83 | 5822.0 |
| 2016-06-10 05:45:00 | SPY | ETF | 210.77 | 210.77 | 210.77 | 210.77 | 200.0 |
| 2016-06-10 05:50:00 | SPY | ETF | 210.81 | 210.81 | 210.67 | 210.7 | 1322.0 |
| 2016-06-10 05:55:00 | SPY | ETF | 210.7 | 210.71 | 210.66 | 210.67 | 5967.0 |
| 2016-06-10 06:00:00 | SPY | ETF | 210.67 | 210.7 | 210.65 | 210.68 | 17734.0 |
| 2016-06-10 06:05:00 | SPY | ETF | 210.7 | 210.8 | 210.6 | 210.8 | 61032.0 |
| 2016-06-10 06:15:00 | SPY | ETF | 210.75 | 210.75 | 210.75 | 210.75 | 100.0 |
| 2016-06-10 06:20:00 | SPY | ETF | 210.79 | 210.79 | 210.79 | 210.79 | 300.0 |
| 2016-06-10 06:25:00 | SPY | ETF | 210.82 | 210.84 | 210.82 | 210.84 | 25551.0 |
| 2016-06-10 06:30:00 | SPY | ETF | 210.81 | 210.81 | 210.78 | 210.78 | 6053.0 |
| 2016-06-10 06:35:00 | SPY | ETF | 210.78 | 210.79 | 210.74 | 210.78 | 4103.0 |
| 2016-06-10 06:40:00 | SPY | ETF | 210.82 | 210.82 | 210.81 | 210.81 | 2402.0 |
| 2016-06-10 06:45:00 | SPY | ETF | 210.8 | 210.81 | 210.79 | 210.8 | 12601.0 |
| 2016-06-10 06:50:00 | SPY | ETF | 210.79 | 210.81 | 210.77 | 210.77 | 7024.0 |
| 2016-06-10 06:55:00 | SPY | ETF | 210.77 | 210.8 | 210.77 | 210.8 | 35131.0 |
| 2016-06-10 07:00:00 | SPY | ETF | 210.8 | 210.82 | 210.74 | 210.76 | 64101.0 |
| 2016-06-10 07:05:00 | SPY | ETF | 210.76 | 210.87 | 210.76 | 210.86 | 5595.0 |
| 2016-06-10 07:10:00 | SPY | ETF | 210.86 | 210.9 | 210.84 | 210.85 | 46524.0 |
| 2016-06-10 07:15:00 | SPY | ETF | 210.85 | 210.95 | 210.83 | 210.95 | 27107.0 |
| 2016-06-10 07:20:00 | SPY | ETF | 210.95 | 210.97 | 210.89 | 210.89 | 30144.0 |
| 2016-06-10 07:25:00 | SPY | ETF | 210.88 | 210.89 | 210.84 | 210.84 | 14754.0 |
| 2016-06-10 07:30:00 | SPY | ETF | 210.82 | 210.83 | 210.76 | 210.76 | 12470.0 |
| 2016-06-10 07:35:00 | SPY | ETF | 210.76 | 210.76 | 210.7 | 210.71 | 38503.0 |
| 2016-06-10 07:40:00 | SPY | ETF | 210.72 | 210.73 | 210.68 | 210.69 | 22016.0 |
| 2016-06-10 07:45:00 | SPY | ETF | 210.69 | 210.72 | 210.68 | 210.72 | 15945.0 |
| 2016-06-10 07:50:00 | SPY | ETF | 210.72 | 210.77 | 210.71 | 210.76 | 66403.0 |
| 2016-06-10 07:55:00 | SPY | ETF | 210.77 | 210.78 | 210.72 | 210.73 | 4876.0 |
| 2016-06-10 08:00:00 | SPY | ETF | 210.73 | 210.89 | 210.61 | 210.65 | 106861.0 |
| 2016-06-10 08:05:00 | SPY | ETF | 210.65 | 210.77 | 210.63 | 210.77 | 30796.0 |
| 2016-06-10 08:10:00 | SPY | ETF | 210.76 | 210.79 | 210.74 | 210.75 | 33583.0 |
| 2016-06-10 08:15:00 | SPY | ETF | 210.75 | 210.77 | 210.71 | 210.72 | 19318.0 |
| 2016-06-10 08:20:00 | SPY | ETF | 210.72 | 210.76 | 210.67 | 210.67 | 128479.0 |
> showing 50 of 49,561 rows — these rows as CSV