PREVIEW / etf_5min / 2016-09-30
file: by_date/etf_5min/2016/2016-09-30.parquet size: 1.2 MB rows: 49,672
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-09-30 04:00:00 | SPY | ETF | 214.3 | 214.3 | 214.14 | 214.16 | 7670.0 |
| 2016-09-30 04:05:00 | SPY | ETF | 214.21 | 214.45 | 214.21 | 214.45 | 2025.0 |
| 2016-09-30 04:10:00 | SPY | ETF | 214.51 | 214.51 | 214.39 | 214.39 | 5550.0 |
| 2016-09-30 04:15:00 | SPY | ETF | 214.39 | 214.39 | 214.39 | 214.39 | 300.0 |
| 2016-09-30 04:20:00 | SPY | ETF | 214.53 | 214.57 | 214.49 | 214.52 | 5492.0 |
| 2016-09-30 04:25:00 | SPY | ETF | 214.56 | 214.7 | 214.56 | 214.7 | 7034.0 |
| 2016-09-30 04:30:00 | SPY | ETF | 214.6 | 214.61 | 214.41 | 214.41 | 30373.0 |
| 2016-09-30 04:35:00 | SPY | ETF | 214.4 | 214.64 | 214.4 | 214.64 | 4320.0 |
| 2016-09-30 04:40:00 | SPY | ETF | 214.63 | 214.75 | 214.63 | 214.75 | 603.0 |
| 2016-09-30 04:45:00 | SPY | ETF | 214.78 | 214.8 | 214.78 | 214.8 | 2158.0 |
| 2016-09-30 05:00:00 | SPY | ETF | 214.83 | 214.85 | 214.73 | 214.78 | 1265.0 |
| 2016-09-30 05:05:00 | SPY | ETF | 214.71 | 214.71 | 214.69 | 214.69 | 403.0 |
| 2016-09-30 05:10:00 | SPY | ETF | 214.73 | 214.81 | 214.73 | 214.79 | 718.0 |
| 2016-09-30 05:15:00 | SPY | ETF | 214.76 | 214.76 | 214.76 | 214.76 | 200.0 |
| 2016-09-30 05:20:00 | SPY | ETF | 214.83 | 214.83 | 214.83 | 214.83 | 102.0 |
| 2016-09-30 05:25:00 | SPY | ETF | 214.79 | 214.79 | 214.79 | 214.79 | 100.0 |
| 2016-09-30 05:30:00 | SPY | ETF | 214.73 | 214.79 | 214.73 | 214.79 | 326.0 |
| 2016-09-30 05:35:00 | SPY | ETF | 214.84 | 214.84 | 214.79 | 214.79 | 1313.0 |
| 2016-09-30 05:40:00 | SPY | ETF | 214.76 | 215.06 | 214.76 | 215.06 | 5100.0 |
| 2016-09-30 05:45:00 | SPY | ETF | 215.07 | 215.07 | 214.98 | 215.04 | 1443.0 |
| 2016-09-30 05:50:00 | SPY | ETF | 215.0 | 215.0 | 214.94 | 214.97 | 2805.0 |
| 2016-09-30 05:55:00 | SPY | ETF | 214.99 | 215.01 | 214.99 | 215.01 | 1001.0 |
| 2016-09-30 06:00:00 | SPY | ETF | 214.86 | 214.86 | 214.86 | 214.86 | 100.0 |
| 2016-09-30 06:05:00 | SPY | ETF | 214.92 | 214.92 | 214.88 | 214.89 | 1602.0 |
| 2016-09-30 06:10:00 | SPY | ETF | 214.88 | 214.9 | 214.82 | 214.82 | 11202.0 |
| 2016-09-30 06:15:00 | SPY | ETF | 214.7 | 214.78 | 214.69 | 214.74 | 18405.0 |
| 2016-09-30 06:20:00 | SPY | ETF | 214.77 | 214.79 | 214.76 | 214.76 | 21001.0 |
| 2016-09-30 06:25:00 | SPY | ETF | 214.78 | 214.78 | 214.74 | 214.74 | 2006.0 |
| 2016-09-30 06:30:00 | SPY | ETF | 214.68 | 214.7 | 214.65 | 214.7 | 1009.0 |
| 2016-09-30 06:35:00 | SPY | ETF | 214.72 | 214.77 | 214.72 | 214.77 | 706.0 |
| 2016-09-30 06:40:00 | SPY | ETF | 214.82 | 214.82 | 214.76 | 214.76 | 600.0 |
| 2016-09-30 06:45:00 | SPY | ETF | 214.88 | 214.9 | 214.84 | 214.84 | 2162.0 |
| 2016-09-30 06:50:00 | SPY | ETF | 214.9 | 214.92 | 214.9 | 214.92 | 3252.0 |
| 2016-09-30 06:55:00 | SPY | ETF | 214.94 | 215.25 | 214.94 | 215.12 | 168061.0 |
| 2016-09-30 07:00:00 | SPY | ETF | 215.15 | 215.21 | 215.14 | 215.14 | 27987.0 |
| 2016-09-30 07:05:00 | SPY | ETF | 215.12 | 215.12 | 215.02 | 215.02 | 22358.0 |
| 2016-09-30 07:10:00 | SPY | ETF | 215.05 | 215.06 | 214.94 | 214.98 | 40511.0 |
| 2016-09-30 07:15:00 | SPY | ETF | 215.0 | 215.06 | 215.0 | 215.06 | 9067.0 |
| 2016-09-30 07:20:00 | SPY | ETF | 215.02 | 215.02 | 215.0 | 215.0 | 141500.0 |
| 2016-09-30 07:25:00 | SPY | ETF | 215.0 | 215.0 | 214.91 | 214.94 | 131702.0 |
| 2016-09-30 07:30:00 | SPY | ETF | 214.94 | 215.08 | 214.93 | 215.07 | 58939.0 |
| 2016-09-30 07:35:00 | SPY | ETF | 215.07 | 215.14 | 215.05 | 215.07 | 29048.0 |
| 2016-09-30 07:40:00 | SPY | ETF | 215.05 | 215.05 | 214.99 | 214.99 | 14168.0 |
| 2016-09-30 07:45:00 | SPY | ETF | 215.0 | 215.0 | 214.94 | 214.95 | 24951.0 |
| 2016-09-30 07:50:00 | SPY | ETF | 214.94 | 214.99 | 214.94 | 214.95 | 12128.0 |
| 2016-09-30 07:55:00 | SPY | ETF | 214.98 | 215.06 | 214.98 | 215.04 | 10063.0 |
| 2016-09-30 08:00:00 | SPY | ETF | 214.95 | 215.15 | 214.7 | 214.7 | 77818.0 |
| 2016-09-30 08:05:00 | SPY | ETF | 214.98 | 215.06 | 214.97 | 215.05 | 98316.0 |
| 2016-09-30 08:10:00 | SPY | ETF | 215.05 | 215.15 | 215.04 | 215.1 | 24837.0 |
| 2016-09-30 08:15:00 | SPY | ETF | 215.11 | 215.16 | 215.11 | 215.13 | 89473.0 |
> showing 50 of 49,672 rows — these rows as CSV