PREVIEW / etf_5min / 2016-05-18
file: by_date/etf_5min/2016/2016-05-18.parquet size: 1.2 MB rows: 51,803
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-05-18 04:00:00 | SPY | ETF | 204.87 | 204.87 | 204.69 | 204.84 | 9681.0 |
| 2016-05-18 04:10:00 | SPY | ETF | 204.83 | 204.84 | 204.8 | 204.84 | 306.0 |
| 2016-05-18 04:15:00 | SPY | ETF | 204.81 | 204.81 | 204.81 | 204.81 | 1405.0 |
| 2016-05-18 04:20:00 | SPY | ETF | 204.91 | 204.94 | 204.91 | 204.91 | 4410.0 |
| 2016-05-18 04:25:00 | SPY | ETF | 204.88 | 204.88 | 204.88 | 204.88 | 3001.0 |
| 2016-05-18 04:30:00 | SPY | ETF | 204.81 | 204.81 | 204.81 | 204.81 | 305.0 |
| 2016-05-18 04:35:00 | SPY | ETF | 204.93 | 204.93 | 204.93 | 204.93 | 1103.0 |
| 2016-05-18 04:40:00 | SPY | ETF | 204.88 | 204.88 | 204.88 | 204.88 | 303.0 |
| 2016-05-18 04:45:00 | SPY | ETF | 204.88 | 204.88 | 204.88 | 204.88 | 1904.0 |
| 2016-05-18 04:50:00 | SPY | ETF | 204.86 | 204.98 | 204.86 | 204.97 | 3009.0 |
| 2016-05-18 04:55:00 | SPY | ETF | 205.01 | 205.01 | 205.01 | 205.01 | 1003.0 |
| 2016-05-18 05:00:00 | SPY | ETF | 204.98 | 205.01 | 204.96 | 204.96 | 908.0 |
| 2016-05-18 05:05:00 | SPY | ETF | 204.98 | 204.98 | 204.98 | 204.98 | 502.0 |
| 2016-05-18 05:10:00 | SPY | ETF | 204.93 | 204.93 | 204.91 | 204.91 | 505.0 |
| 2016-05-18 05:15:00 | SPY | ETF | 204.93 | 204.93 | 204.93 | 204.93 | 401.0 |
| 2016-05-18 05:20:00 | SPY | ETF | 204.85 | 204.85 | 204.85 | 204.85 | 150.0 |
| 2016-05-18 05:25:00 | SPY | ETF | 204.83 | 204.83 | 204.83 | 204.83 | 500.0 |
| 2016-05-18 05:30:00 | SPY | ETF | 204.86 | 204.9 | 204.86 | 204.88 | 2206.0 |
| 2016-05-18 05:35:00 | SPY | ETF | 204.91 | 204.93 | 204.91 | 204.93 | 3002.0 |
| 2016-05-18 05:40:00 | SPY | ETF | 204.93 | 204.93 | 204.93 | 204.93 | 401.0 |
| 2016-05-18 05:45:00 | SPY | ETF | 204.9 | 204.9 | 204.9 | 204.9 | 651.0 |
| 2016-05-18 05:55:00 | SPY | ETF | 204.9 | 204.9 | 204.9 | 204.9 | 550.0 |
| 2016-05-18 06:00:00 | SPY | ETF | 205.01 | 205.01 | 204.95 | 204.95 | 2615.0 |
| 2016-05-18 06:05:00 | SPY | ETF | 205.06 | 205.08 | 205.06 | 205.08 | 4046.0 |
| 2016-05-18 06:15:00 | SPY | ETF | 204.99 | 204.99 | 204.97 | 204.97 | 6002.0 |
| 2016-05-18 06:20:00 | SPY | ETF | 204.92 | 204.93 | 204.92 | 204.93 | 2104.0 |
| 2016-05-18 06:25:00 | SPY | ETF | 204.91 | 204.91 | 204.83 | 204.83 | 2000.0 |
| 2016-05-18 06:30:00 | SPY | ETF | 204.75 | 204.77 | 204.75 | 204.77 | 2009.0 |
| 2016-05-18 06:35:00 | SPY | ETF | 204.76 | 204.76 | 204.74 | 204.74 | 4100.0 |
| 2016-05-18 06:40:00 | SPY | ETF | 204.77 | 204.77 | 204.7 | 204.7 | 2004.0 |
| 2016-05-18 06:50:00 | SPY | ETF | 204.73 | 204.73 | 204.7 | 204.71 | 3001.0 |
| 2016-05-18 06:55:00 | SPY | ETF | 204.71 | 204.71 | 204.68 | 204.69 | 4401.0 |
| 2016-05-18 07:00:00 | SPY | ETF | 204.76 | 204.88 | 204.76 | 204.88 | 3604.0 |
| 2016-05-18 07:05:00 | SPY | ETF | 204.88 | 204.93 | 204.88 | 204.93 | 8582.0 |
| 2016-05-18 07:10:00 | SPY | ETF | 204.94 | 204.94 | 204.81 | 204.85 | 6703.0 |
| 2016-05-18 07:15:00 | SPY | ETF | 204.87 | 204.91 | 204.87 | 204.89 | 1800.0 |
| 2016-05-18 07:20:00 | SPY | ETF | 204.91 | 204.91 | 204.9 | 204.9 | 604.0 |
| 2016-05-18 07:25:00 | SPY | ETF | 204.94 | 205.0 | 204.94 | 205.0 | 37037.0 |
| 2016-05-18 07:30:00 | SPY | ETF | 204.99 | 205.0 | 204.94 | 204.97 | 86496.0 |
| 2016-05-18 07:35:00 | SPY | ETF | 204.94 | 204.94 | 204.9 | 204.9 | 11953.0 |
| 2016-05-18 07:40:00 | SPY | ETF | 204.89 | 204.89 | 204.75 | 204.76 | 78330.0 |
| 2016-05-18 07:45:00 | SPY | ETF | 204.75 | 204.81 | 204.75 | 204.8 | 7355.0 |
| 2016-05-18 07:50:00 | SPY | ETF | 204.78 | 204.78 | 204.66 | 204.74 | 46445.0 |
| 2016-05-18 07:55:00 | SPY | ETF | 204.71 | 204.71 | 204.57 | 204.58 | 27263.0 |
| 2016-05-18 08:00:00 | SPY | ETF | 204.61 | 205.103 | 204.58 | 205.103 | 110583.0 |
| 2016-05-18 08:05:00 | SPY | ETF | 204.63 | 204.65 | 204.57 | 204.57 | 21844.0 |
| 2016-05-18 08:10:00 | SPY | ETF | 204.58 | 204.65 | 204.5 | 204.51 | 105507.0 |
| 2016-05-18 08:15:00 | SPY | ETF | 204.5 | 204.54 | 204.5 | 204.52 | 41898.0 |
| 2016-05-18 08:20:00 | SPY | ETF | 204.52 | 204.61 | 204.47 | 204.59 | 40587.0 |
| 2016-05-18 08:25:00 | SPY | ETF | 204.59 | 204.59 | 204.41 | 204.41 | 247820.0 |
> showing 50 of 51,803 rows — these rows as CSV