PREVIEW / etf_5min / 2016-04-19
file: by_date/etf_5min/2016/2016-04-19.parquet size: 1.2 MB rows: 50,299
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-04-19 04:00:00 | SPY | ETF | 209.83 | 210.05 | 209.83 | 210.03 | 16570.0 |
| 2016-04-19 04:05:00 | SPY | ETF | 209.98 | 209.98 | 209.95 | 209.95 | 862.0 |
| 2016-04-19 04:10:00 | SPY | ETF | 209.95 | 209.95 | 209.93 | 209.93 | 2740.0 |
| 2016-04-19 04:15:00 | SPY | ETF | 209.95 | 209.96 | 209.94 | 209.96 | 1610.0 |
| 2016-04-19 04:20:00 | SPY | ETF | 209.96 | 209.98 | 209.95 | 209.95 | 724.0 |
| 2016-04-19 04:25:00 | SPY | ETF | 209.9 | 209.9 | 209.9 | 209.9 | 1700.0 |
| 2016-04-19 04:30:00 | SPY | ETF | 209.94 | 209.98 | 209.92 | 209.96 | 3794.0 |
| 2016-04-19 04:35:00 | SPY | ETF | 209.95 | 209.95 | 209.95 | 209.95 | 232.0 |
| 2016-04-19 04:40:00 | SPY | ETF | 209.96 | 209.96 | 209.96 | 209.96 | 100.0 |
| 2016-04-19 04:45:00 | SPY | ETF | 209.98 | 209.98 | 209.97 | 209.98 | 1209.0 |
| 2016-04-19 04:50:00 | SPY | ETF | 209.95 | 210.0 | 209.95 | 209.99 | 8447.0 |
| 2016-04-19 04:55:00 | SPY | ETF | 210.02 | 210.03 | 210.02 | 210.03 | 552.0 |
| 2016-04-19 05:00:00 | SPY | ETF | 210.04 | 210.05 | 210.03 | 210.03 | 6160.0 |
| 2016-04-19 05:05:00 | SPY | ETF | 210.04 | 210.04 | 210.04 | 210.04 | 232.0 |
| 2016-04-19 05:10:00 | SPY | ETF | 209.97 | 209.97 | 209.97 | 209.97 | 298.0 |
| 2016-04-19 05:15:00 | SPY | ETF | 209.97 | 210.03 | 209.97 | 210.03 | 828.0 |
| 2016-04-19 05:20:00 | SPY | ETF | 210.06 | 210.07 | 210.05 | 210.07 | 1932.0 |
| 2016-04-19 05:25:00 | SPY | ETF | 210.06 | 210.07 | 210.06 | 210.07 | 200.0 |
| 2016-04-19 05:30:00 | SPY | ETF | 210.05 | 210.16 | 210.05 | 210.15 | 6817.0 |
| 2016-04-19 05:35:00 | SPY | ETF | 210.16 | 210.16 | 210.14 | 210.14 | 1500.0 |
| 2016-04-19 05:40:00 | SPY | ETF | 210.16 | 210.18 | 210.14 | 210.17 | 2801.0 |
| 2016-04-19 05:45:00 | SPY | ETF | 210.2 | 210.25 | 210.2 | 210.25 | 641.0 |
| 2016-04-19 05:50:00 | SPY | ETF | 210.25 | 210.25 | 210.18 | 210.18 | 1241.0 |
| 2016-04-19 05:55:00 | SPY | ETF | 210.17 | 210.17 | 210.14 | 210.17 | 2697.0 |
| 2016-04-19 06:00:00 | SPY | ETF | 210.21 | 210.23 | 210.2 | 210.2 | 4901.0 |
| 2016-04-19 06:05:00 | SPY | ETF | 210.2 | 210.21 | 210.16 | 210.2 | 11108.0 |
| 2016-04-19 06:10:00 | SPY | ETF | 210.17 | 210.17 | 210.17 | 210.17 | 220.0 |
| 2016-04-19 06:15:00 | SPY | ETF | 210.17 | 210.21 | 210.17 | 210.21 | 4510.0 |
| 2016-04-19 06:20:00 | SPY | ETF | 210.15 | 210.15 | 210.15 | 210.15 | 2100.0 |
| 2016-04-19 06:25:00 | SPY | ETF | 210.12 | 210.18 | 210.12 | 210.12 | 10903.0 |
| 2016-04-19 06:30:00 | SPY | ETF | 210.12 | 210.12 | 210.09 | 210.09 | 706.0 |
| 2016-04-19 06:35:00 | SPY | ETF | 210.06 | 210.08 | 210.04 | 210.04 | 2637.0 |
| 2016-04-19 06:40:00 | SPY | ETF | 210.06 | 210.06 | 210.02 | 210.02 | 3706.0 |
| 2016-04-19 06:45:00 | SPY | ETF | 210.0 | 210.02 | 209.97 | 209.97 | 1819.0 |
| 2016-04-19 06:50:00 | SPY | ETF | 210.03 | 210.08 | 210.03 | 210.07 | 1713.0 |
| 2016-04-19 06:55:00 | SPY | ETF | 210.08 | 210.08 | 210.06 | 210.06 | 401.0 |
| 2016-04-19 07:00:00 | SPY | ETF | 210.06 | 210.08 | 210.02 | 210.02 | 74486.0 |
| 2016-04-19 07:05:00 | SPY | ETF | 210.04 | 210.09 | 210.04 | 210.09 | 13434.0 |
| 2016-04-19 07:10:00 | SPY | ETF | 210.09 | 210.11 | 209.96 | 209.96 | 225313.0 |
| 2016-04-19 07:15:00 | SPY | ETF | 209.96 | 210.0 | 209.94 | 210.0 | 8808.0 |
| 2016-04-19 07:20:00 | SPY | ETF | 209.96 | 209.96 | 209.95 | 209.95 | 9301.0 |
| 2016-04-19 07:25:00 | SPY | ETF | 209.94 | 209.94 | 209.9 | 209.93 | 8009.0 |
| 2016-04-19 07:30:00 | SPY | ETF | 209.91 | 210.1 | 209.91 | 210.06 | 23550.0 |
| 2016-04-19 07:35:00 | SPY | ETF | 210.06 | 210.09 | 210.01 | 210.01 | 19921.0 |
| 2016-04-19 07:40:00 | SPY | ETF | 210.02 | 210.06 | 209.99 | 210.06 | 36434.0 |
| 2016-04-19 07:45:00 | SPY | ETF | 210.06 | 210.15 | 210.06 | 210.06 | 50401.0 |
| 2016-04-19 07:50:00 | SPY | ETF | 210.06 | 210.13 | 210.06 | 210.13 | 48959.0 |
| 2016-04-19 07:55:00 | SPY | ETF | 210.12 | 210.15 | 210.1 | 210.1 | 7451.0 |
| 2016-04-19 08:00:00 | SPY | ETF | 210.09 | 210.09 | 209.04 | 209.04 | 84872.0 |
| 2016-04-19 08:05:00 | SPY | ETF | 210.03 | 210.07 | 210.02 | 210.03 | 123808.0 |
> showing 50 of 50,299 rows — these rows as CSV