PREVIEW / etf_5min / 2016-10-24
file: by_date/etf_5min/2016/2016-10-24.parquet size: 1.1 MB rows: 48,124
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-10-24 04:00:00 | SPY | ETF | 214.91 | 215.12 | 214.88 | 215.05 | 4220.0 |
| 2016-10-24 04:05:00 | SPY | ETF | 214.95 | 214.95 | 214.95 | 214.95 | 100.0 |
| 2016-10-24 04:15:00 | SPY | ETF | 214.95 | 214.95 | 214.89 | 214.94 | 1400.0 |
| 2016-10-24 04:20:00 | SPY | ETF | 214.94 | 214.94 | 214.94 | 214.94 | 1200.0 |
| 2016-10-24 04:25:00 | SPY | ETF | 214.88 | 214.88 | 214.88 | 214.88 | 300.0 |
| 2016-10-24 04:40:00 | SPY | ETF | 214.95 | 214.95 | 214.95 | 214.95 | 300.0 |
| 2016-10-24 04:45:00 | SPY | ETF | 214.92 | 215.0 | 214.92 | 214.97 | 1754.0 |
| 2016-10-24 04:50:00 | SPY | ETF | 215.0 | 215.0 | 215.0 | 215.0 | 400.0 |
| 2016-10-24 04:55:00 | SPY | ETF | 214.9 | 214.9 | 214.9 | 214.9 | 300.0 |
| 2016-10-24 05:05:00 | SPY | ETF | 214.92 | 214.92 | 214.92 | 214.92 | 301.0 |
| 2016-10-24 05:15:00 | SPY | ETF | 214.9 | 214.9 | 214.86 | 214.86 | 3199.0 |
| 2016-10-24 05:30:00 | SPY | ETF | 214.86 | 214.86 | 214.86 | 214.86 | 100.0 |
| 2016-10-24 05:40:00 | SPY | ETF | 214.84 | 214.87 | 214.84 | 214.87 | 302.0 |
| 2016-10-24 05:45:00 | SPY | ETF | 214.84 | 214.84 | 214.84 | 214.84 | 100.0 |
| 2016-10-24 06:05:00 | SPY | ETF | 214.89 | 214.92 | 214.89 | 214.89 | 1250.0 |
| 2016-10-24 06:15:00 | SPY | ETF | 214.94 | 214.94 | 214.89 | 214.89 | 200.0 |
| 2016-10-24 06:20:00 | SPY | ETF | 214.89 | 214.91 | 214.86 | 214.87 | 1501.0 |
| 2016-10-24 06:25:00 | SPY | ETF | 214.89 | 214.89 | 214.86 | 214.87 | 800.0 |
| 2016-10-24 06:30:00 | SPY | ETF | 214.87 | 214.92 | 214.87 | 214.89 | 2602.0 |
| 2016-10-24 06:35:00 | SPY | ETF | 214.9 | 214.9 | 214.9 | 214.9 | 6100.0 |
| 2016-10-24 06:40:00 | SPY | ETF | 214.86 | 214.86 | 214.86 | 214.86 | 7000.0 |
| 2016-10-24 06:45:00 | SPY | ETF | 214.86 | 214.92 | 214.86 | 214.89 | 6901.0 |
| 2016-10-24 06:50:00 | SPY | ETF | 214.83 | 214.83 | 214.81 | 214.81 | 1754.0 |
| 2016-10-24 06:55:00 | SPY | ETF | 214.81 | 214.81 | 214.81 | 214.81 | 12402.0 |
| 2016-10-24 07:00:00 | SPY | ETF | 214.8 | 214.82 | 214.78 | 214.8 | 2831.0 |
| 2016-10-24 07:05:00 | SPY | ETF | 214.82 | 214.82 | 214.76 | 214.78 | 2679.0 |
| 2016-10-24 07:10:00 | SPY | ETF | 214.77 | 214.84 | 214.77 | 214.84 | 8806.0 |
| 2016-10-24 07:15:00 | SPY | ETF | 214.82 | 214.82 | 214.8 | 214.8 | 4300.0 |
| 2016-10-24 07:20:00 | SPY | ETF | 214.84 | 214.85 | 214.83 | 214.85 | 15000.0 |
| 2016-10-24 07:25:00 | SPY | ETF | 214.84 | 214.85 | 214.83 | 214.84 | 1802.0 |
| 2016-10-24 07:30:00 | SPY | ETF | 214.86 | 214.86 | 214.77 | 214.79 | 14642.0 |
| 2016-10-24 07:35:00 | SPY | ETF | 214.76 | 214.78 | 214.75 | 214.76 | 9750.0 |
| 2016-10-24 07:40:00 | SPY | ETF | 214.79 | 214.79 | 214.76 | 214.76 | 52519.0 |
| 2016-10-24 07:45:00 | SPY | ETF | 214.79 | 214.8 | 214.77 | 214.79 | 12902.0 |
| 2016-10-24 07:50:00 | SPY | ETF | 214.79 | 214.82 | 214.78 | 214.82 | 5704.0 |
| 2016-10-24 07:55:00 | SPY | ETF | 214.81 | 214.85 | 214.81 | 214.84 | 29601.0 |
| 2016-10-24 08:00:00 | SPY | ETF | 214.82 | 214.87 | 214.76 | 214.87 | 90781.0 |
| 2016-10-24 08:05:00 | SPY | ETF | 214.131 | 214.88 | 214.131 | 214.86 | 57662.0 |
| 2016-10-24 08:10:00 | SPY | ETF | 214.86 | 214.86 | 214.75 | 214.75 | 61659.0 |
| 2016-10-24 08:15:00 | SPY | ETF | 214.75 | 214.75 | 214.7 | 214.71 | 82393.0 |
| 2016-10-24 08:20:00 | SPY | ETF | 214.72 | 214.83 | 214.71 | 214.83 | 24319.0 |
| 2016-10-24 08:25:00 | SPY | ETF | 214.82 | 214.83 | 214.81 | 214.82 | 7198.0 |
| 2016-10-24 08:30:00 | SPY | ETF | 214.82 | 214.85 | 214.82 | 214.85 | 21936.0 |
| 2016-10-24 08:35:00 | SPY | ETF | 214.85 | 214.91 | 214.85 | 214.91 | 46341.0 |
| 2016-10-24 08:40:00 | SPY | ETF | 214.91 | 214.94 | 214.88 | 214.91 | 67902.0 |
| 2016-10-24 08:45:00 | SPY | ETF | 214.94 | 214.94 | 214.91 | 214.92 | 36550.0 |
| 2016-10-24 08:50:00 | SPY | ETF | 214.91 | 214.94 | 214.9 | 214.94 | 36324.0 |
| 2016-10-24 08:55:00 | SPY | ETF | 214.93 | 214.94 | 214.92 | 214.93 | 36031.0 |
| 2016-10-24 09:00:00 | SPY | ETF | 214.92 | 214.94 | 214.9 | 214.94 | 12098.0 |
| 2016-10-24 09:05:00 | SPY | ETF | 214.94 | 214.96 | 214.9 | 214.91 | 28633.0 |
> showing 50 of 48,124 rows — these rows as CSV