PREVIEW / etf_5min / 2016-11-17
file: by_date/etf_5min/2016/2016-11-17.parquet size: 1.3 MB rows: 56,207
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-11-17 04:00:00 | SPY | ETF | 218.0 | 218.15 | 218.0 | 218.01 | 1468.0 |
| 2016-11-17 04:05:00 | SPY | ETF | 217.94 | 218.02 | 217.94 | 218.02 | 2900.0 |
| 2016-11-17 04:10:00 | SPY | ETF | 218.01 | 218.04 | 218.01 | 218.04 | 1400.0 |
| 2016-11-17 04:15:00 | SPY | ETF | 217.99 | 217.99 | 217.94 | 217.94 | 3301.0 |
| 2016-11-17 04:20:00 | SPY | ETF | 217.94 | 217.94 | 217.94 | 217.94 | 402.0 |
| 2016-11-17 04:40:00 | SPY | ETF | 218.02 | 218.02 | 218.02 | 218.02 | 502.0 |
| 2016-11-17 04:45:00 | SPY | ETF | 218.04 | 218.04 | 217.98 | 217.98 | 1204.0 |
| 2016-11-17 04:50:00 | SPY | ETF | 217.96 | 217.96 | 217.87 | 217.87 | 1706.0 |
| 2016-11-17 04:55:00 | SPY | ETF | 217.91 | 217.96 | 217.91 | 217.96 | 1403.0 |
| 2016-11-17 05:00:00 | SPY | ETF | 217.96 | 217.96 | 217.92 | 217.94 | 2300.0 |
| 2016-11-17 05:05:00 | SPY | ETF | 217.93 | 217.93 | 217.93 | 217.93 | 600.0 |
| 2016-11-17 05:10:00 | SPY | ETF | 217.91 | 217.91 | 217.91 | 217.91 | 1819.0 |
| 2016-11-17 05:15:00 | SPY | ETF | 217.84 | 217.91 | 217.84 | 217.91 | 3320.0 |
| 2016-11-17 05:20:00 | SPY | ETF | 217.91 | 217.92 | 217.88 | 217.91 | 1408.0 |
| 2016-11-17 05:25:00 | SPY | ETF | 217.95 | 217.96 | 217.91 | 217.91 | 4212.0 |
| 2016-11-17 05:30:00 | SPY | ETF | 217.91 | 217.91 | 217.91 | 217.91 | 308.0 |
| 2016-11-17 05:35:00 | SPY | ETF | 217.91 | 217.91 | 217.91 | 217.91 | 1400.0 |
| 2016-11-17 05:40:00 | SPY | ETF | 217.96 | 218.01 | 217.96 | 218.01 | 4303.0 |
| 2016-11-17 05:45:00 | SPY | ETF | 218.02 | 218.11 | 218.02 | 218.09 | 4310.0 |
| 2016-11-17 05:55:00 | SPY | ETF | 218.07 | 218.07 | 218.07 | 218.07 | 200.0 |
| 2016-11-17 06:00:00 | SPY | ETF | 218.11 | 218.13 | 218.11 | 218.12 | 1067.0 |
| 2016-11-17 06:05:00 | SPY | ETF | 218.04 | 218.04 | 218.04 | 218.04 | 502.0 |
| 2016-11-17 06:10:00 | SPY | ETF | 218.06 | 218.06 | 218.06 | 218.06 | 5500.0 |
| 2016-11-17 06:15:00 | SPY | ETF | 218.03 | 218.07 | 218.03 | 218.07 | 401.0 |
| 2016-11-17 06:20:00 | SPY | ETF | 218.06 | 218.06 | 218.06 | 218.06 | 2021.0 |
| 2016-11-17 06:25:00 | SPY | ETF | 218.11 | 218.11 | 218.11 | 218.11 | 2205.0 |
| 2016-11-17 06:30:00 | SPY | ETF | 218.08 | 218.08 | 218.03 | 218.03 | 2494.0 |
| 2016-11-17 06:35:00 | SPY | ETF | 218.08 | 218.09 | 218.06 | 218.06 | 541.0 |
| 2016-11-17 06:40:00 | SPY | ETF | 218.04 | 218.06 | 217.98 | 218.06 | 2918.0 |
| 2016-11-17 06:45:00 | SPY | ETF | 218.08 | 218.08 | 218.08 | 218.08 | 200.0 |
| 2016-11-17 06:50:00 | SPY | ETF | 218.0 | 218.0 | 218.0 | 218.0 | 252.0 |
| 2016-11-17 06:55:00 | SPY | ETF | 217.98 | 217.98 | 217.98 | 217.98 | 101.0 |
| 2016-11-17 07:00:00 | SPY | ETF | 217.97 | 217.97 | 217.97 | 217.97 | 3001.0 |
| 2016-11-17 07:05:00 | SPY | ETF | 217.98 | 218.03 | 217.98 | 218.03 | 1600.0 |
| 2016-11-17 07:10:00 | SPY | ETF | 218.03 | 218.15 | 218.03 | 218.13 | 6995.0 |
| 2016-11-17 07:15:00 | SPY | ETF | 218.13 | 218.15 | 218.11 | 218.11 | 3807.0 |
| 2016-11-17 07:20:00 | SPY | ETF | 218.11 | 218.14 | 218.09 | 218.09 | 2357.0 |
| 2016-11-17 07:25:00 | SPY | ETF | 218.08 | 218.1 | 218.04 | 218.1 | 10311.0 |
| 2016-11-17 07:30:00 | SPY | ETF | 218.11 | 218.12 | 218.04 | 218.05 | 3789.0 |
| 2016-11-17 07:35:00 | SPY | ETF | 218.05 | 218.11 | 218.05 | 218.11 | 10206.0 |
| 2016-11-17 07:40:00 | SPY | ETF | 218.11 | 218.11 | 218.03 | 218.04 | 2304.0 |
| 2016-11-17 07:45:00 | SPY | ETF | 218.04 | 218.04 | 217.92 | 217.92 | 36986.0 |
| 2016-11-17 07:50:00 | SPY | ETF | 217.92 | 217.93 | 217.9 | 217.93 | 10029.0 |
| 2016-11-17 07:55:00 | SPY | ETF | 217.94 | 217.96 | 217.9 | 217.9 | 13907.0 |
| 2016-11-17 08:00:00 | SPY | ETF | 217.91 | 217.97 | 217.82 | 217.83 | 60742.0 |
| 2016-11-17 08:05:00 | SPY | ETF | 217.87 | 217.95 | 217.84 | 217.94 | 70171.0 |
| 2016-11-17 08:10:00 | SPY | ETF | 217.94 | 217.94 | 217.88 | 217.93 | 38110.0 |
| 2016-11-17 08:15:00 | SPY | ETF | 217.92 | 217.92 | 217.88 | 217.89 | 5378.0 |
| 2016-11-17 08:20:00 | SPY | ETF | 217.88 | 217.94 | 217.88 | 217.91 | 1626.0 |
| 2016-11-17 08:25:00 | SPY | ETF | 217.89 | 217.91 | 217.83 | 217.85 | 19581.0 |
> showing 50 of 56,207 rows — these rows as CSV