PREVIEW / etf_5min / 2016-08-05
file: by_date/etf_5min/2016/2016-08-05.parquet size: 1.1 MB rows: 48,940
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-08-05 04:00:00 | SPY | ETF | 216.8 | 216.8 | 216.78 | 216.78 | 510.0 |
| 2016-08-05 04:05:00 | SPY | ETF | 216.76 | 216.76 | 216.76 | 216.76 | 300.0 |
| 2016-08-05 04:10:00 | SPY | ETF | 216.79 | 216.79 | 216.79 | 216.79 | 650.0 |
| 2016-08-05 04:15:00 | SPY | ETF | 216.74 | 216.76 | 216.74 | 216.76 | 16010.0 |
| 2016-08-05 04:20:00 | SPY | ETF | 216.81 | 216.81 | 216.81 | 216.81 | 197.0 |
| 2016-08-05 04:30:00 | SPY | ETF | 216.79 | 216.79 | 216.79 | 216.79 | 1401.0 |
| 2016-08-05 04:40:00 | SPY | ETF | 216.59 | 216.62 | 216.59 | 216.62 | 1881.0 |
| 2016-08-05 04:55:00 | SPY | ETF | 216.69 | 216.72 | 216.69 | 216.72 | 1500.0 |
| 2016-08-05 05:05:00 | SPY | ETF | 216.7 | 216.7 | 216.69 | 216.69 | 600.0 |
| 2016-08-05 05:10:00 | SPY | ETF | 216.73 | 216.73 | 216.73 | 216.73 | 201.0 |
| 2016-08-05 05:15:00 | SPY | ETF | 216.77 | 216.79 | 216.68 | 216.68 | 2909.0 |
| 2016-08-05 05:20:00 | SPY | ETF | 216.76 | 216.77 | 216.76 | 216.77 | 1501.0 |
| 2016-08-05 05:25:00 | SPY | ETF | 216.79 | 216.79 | 216.76 | 216.76 | 1901.0 |
| 2016-08-05 05:30:00 | SPY | ETF | 216.81 | 216.81 | 216.81 | 216.81 | 101.0 |
| 2016-08-05 05:35:00 | SPY | ETF | 216.83 | 216.87 | 216.83 | 216.87 | 1330.0 |
| 2016-08-05 05:40:00 | SPY | ETF | 216.89 | 216.89 | 216.84 | 216.84 | 1500.0 |
| 2016-08-05 05:55:00 | SPY | ETF | 216.82 | 216.82 | 216.82 | 216.82 | 1200.0 |
| 2016-08-05 06:00:00 | SPY | ETF | 216.82 | 216.82 | 216.79 | 216.79 | 626.0 |
| 2016-08-05 06:05:00 | SPY | ETF | 216.76 | 216.76 | 216.76 | 216.76 | 2326.0 |
| 2016-08-05 06:10:00 | SPY | ETF | 216.79 | 216.79 | 216.79 | 216.79 | 2000.0 |
| 2016-08-05 06:20:00 | SPY | ETF | 216.76 | 216.81 | 216.76 | 216.81 | 802.0 |
| 2016-08-05 06:25:00 | SPY | ETF | 216.82 | 216.82 | 216.81 | 216.81 | 11701.0 |
| 2016-08-05 06:30:00 | SPY | ETF | 216.81 | 216.87 | 216.81 | 216.81 | 22405.0 |
| 2016-08-05 06:40:00 | SPY | ETF | 216.81 | 216.81 | 216.81 | 216.81 | 3902.0 |
| 2016-08-05 06:45:00 | SPY | ETF | 216.89 | 216.89 | 216.89 | 216.89 | 420.0 |
| 2016-08-05 06:50:00 | SPY | ETF | 216.87 | 216.91 | 216.87 | 216.91 | 1762.0 |
| 2016-08-05 06:55:00 | SPY | ETF | 216.88 | 216.88 | 216.88 | 216.88 | 401.0 |
| 2016-08-05 07:00:00 | SPY | ETF | 216.85 | 216.89 | 216.85 | 216.89 | 10061.0 |
| 2016-08-05 07:05:00 | SPY | ETF | 216.86 | 216.86 | 216.84 | 216.86 | 2164.0 |
| 2016-08-05 07:15:00 | SPY | ETF | 216.81 | 216.81 | 216.74 | 216.74 | 8306.0 |
| 2016-08-05 07:20:00 | SPY | ETF | 216.76 | 216.76 | 216.75 | 216.75 | 1600.0 |
| 2016-08-05 07:25:00 | SPY | ETF | 216.83 | 216.83 | 216.76 | 216.76 | 5204.0 |
| 2016-08-05 07:30:00 | SPY | ETF | 216.77 | 216.79 | 216.72 | 216.73 | 20520.0 |
| 2016-08-05 07:35:00 | SPY | ETF | 216.75 | 216.75 | 216.68 | 216.7 | 36960.0 |
| 2016-08-05 07:40:00 | SPY | ETF | 216.72 | 216.72 | 216.71 | 216.72 | 1000.0 |
| 2016-08-05 07:45:00 | SPY | ETF | 216.72 | 216.72 | 216.67 | 216.69 | 7629.0 |
| 2016-08-05 07:50:00 | SPY | ETF | 216.72 | 216.72 | 216.69 | 216.69 | 1401.0 |
| 2016-08-05 07:55:00 | SPY | ETF | 216.69 | 216.69 | 216.69 | 216.69 | 1700.0 |
| 2016-08-05 08:00:00 | SPY | ETF | 216.81 | 216.87 | 216.67 | 216.72 | 29586.0 |
| 2016-08-05 08:05:00 | SPY | ETF | 216.72 | 216.78 | 216.72 | 216.78 | 37850.0 |
| 2016-08-05 08:10:00 | SPY | ETF | 216.77 | 216.78 | 216.7 | 216.72 | 70267.0 |
| 2016-08-05 08:15:00 | SPY | ETF | 216.72 | 216.73 | 216.68 | 216.68 | 15899.0 |
| 2016-08-05 08:20:00 | SPY | ETF | 216.67 | 216.72 | 216.66 | 216.66 | 12576.0 |
| 2016-08-05 08:25:00 | SPY | ETF | 216.65 | 216.67 | 216.62 | 216.65 | 46707.0 |
| 2016-08-05 08:30:00 | SPY | ETF | 216.56 | 217.18 | 216.55 | 216.97 | 944322.0 |
| 2016-08-05 08:35:00 | SPY | ETF | 216.97 | 217.08 | 216.74 | 217.08 | 167170.0 |
| 2016-08-05 08:40:00 | SPY | ETF | 217.05 | 217.15 | 216.97 | 217.02 | 135330.0 |
| 2016-08-05 08:45:00 | SPY | ETF | 217.02 | 217.06 | 216.98 | 217.02 | 104732.0 |
| 2016-08-05 08:50:00 | SPY | ETF | 217.02 | 217.14 | 217.02 | 217.12 | 113056.0 |
| 2016-08-05 08:55:00 | SPY | ETF | 217.13 | 217.23 | 217.09 | 217.15 | 642261.0 |
> showing 50 of 48,940 rows — these rows as CSV