PREVIEW / etf_5min / 2015-11-20
file: by_date/etf_5min/2015/2015-11-20.parquet size: 1.1 MB rows: 47,334
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 |
|---|---|---|---|---|---|---|---|
| 2015-11-20 04:00:00 | SPY | ETF | 208.75 | 208.75 | 208.75 | 208.75 | 140.0 |
| 2015-11-20 04:05:00 | SPY | ETF | 208.54 | 208.54 | 208.54 | 208.54 | 500.0 |
| 2015-11-20 04:10:00 | SPY | ETF | 208.53 | 208.53 | 208.53 | 208.53 | 300.0 |
| 2015-11-20 04:25:00 | SPY | ETF | 208.58 | 208.58 | 208.58 | 208.58 | 4300.0 |
| 2015-11-20 04:30:00 | SPY | ETF | 208.52 | 208.52 | 208.52 | 208.52 | 209.0 |
| 2015-11-20 04:40:00 | SPY | ETF | 208.74 | 208.85 | 208.74 | 208.8 | 11525.0 |
| 2015-11-20 04:45:00 | SPY | ETF | 208.87 | 208.9 | 208.87 | 208.88 | 2757.0 |
| 2015-11-20 04:55:00 | SPY | ETF | 208.85 | 208.85 | 208.83 | 208.85 | 425.0 |
| 2015-11-20 05:05:00 | SPY | ETF | 208.73 | 208.78 | 208.73 | 208.78 | 6300.0 |
| 2015-11-20 05:10:00 | SPY | ETF | 208.75 | 208.75 | 208.75 | 208.75 | 300.0 |
| 2015-11-20 05:45:00 | SPY | ETF | 208.83 | 208.83 | 208.83 | 208.83 | 200.0 |
| 2015-11-20 05:50:00 | SPY | ETF | 208.96 | 209.01 | 208.96 | 209.01 | 4315.0 |
| 2015-11-20 05:55:00 | SPY | ETF | 209.0 | 209.02 | 208.95 | 209.02 | 2575.0 |
| 2015-11-20 06:00:00 | SPY | ETF | 209.05 | 209.08 | 209.03 | 209.03 | 12000.0 |
| 2015-11-20 06:10:00 | SPY | ETF | 209.0 | 209.0 | 208.98 | 208.98 | 200.0 |
| 2015-11-20 06:15:00 | SPY | ETF | 209.0 | 209.0 | 209.0 | 209.0 | 500.0 |
| 2015-11-20 06:20:00 | SPY | ETF | 209.02 | 209.02 | 209.02 | 209.02 | 2100.0 |
| 2015-11-20 06:25:00 | SPY | ETF | 209.04 | 209.04 | 208.98 | 209.0 | 900.0 |
| 2015-11-20 06:30:00 | SPY | ETF | 209.0 | 209.02 | 209.0 | 209.02 | 525.0 |
| 2015-11-20 06:35:00 | SPY | ETF | 208.95 | 208.95 | 208.95 | 208.95 | 1500.0 |
| 2015-11-20 06:45:00 | SPY | ETF | 208.99 | 209.05 | 208.99 | 209.05 | 3150.0 |
| 2015-11-20 06:50:00 | SPY | ETF | 209.0 | 209.0 | 209.0 | 209.0 | 5000.0 |
| 2015-11-20 06:55:00 | SPY | ETF | 209.02 | 209.02 | 209.02 | 209.02 | 191.0 |
| 2015-11-20 07:00:00 | SPY | ETF | 209.0 | 209.1 | 209.0 | 209.1 | 21385.0 |
| 2015-11-20 07:05:00 | SPY | ETF | 209.1 | 209.15 | 209.1 | 209.14 | 21475.0 |
| 2015-11-20 07:10:00 | SPY | ETF | 209.13 | 209.13 | 209.1 | 209.1 | 2900.0 |
| 2015-11-20 07:15:00 | SPY | ETF | 209.1 | 209.17 | 209.1 | 209.16 | 20004.0 |
| 2015-11-20 07:20:00 | SPY | ETF | 209.1 | 209.1 | 209.05 | 209.05 | 6200.0 |
| 2015-11-20 07:25:00 | SPY | ETF | 209.06 | 209.1 | 209.06 | 209.1 | 4200.0 |
| 2015-11-20 07:30:00 | SPY | ETF | 209.15 | 209.21 | 209.15 | 209.15 | 68852.0 |
| 2015-11-20 07:35:00 | SPY | ETF | 209.2 | 209.2 | 209.15 | 209.15 | 3100.0 |
| 2015-11-20 07:40:00 | SPY | ETF | 209.17 | 209.17 | 209.14 | 209.14 | 4620.0 |
| 2015-11-20 07:45:00 | SPY | ETF | 209.15 | 209.15 | 209.1 | 209.15 | 700.0 |
| 2015-11-20 07:50:00 | SPY | ETF | 209.14 | 209.14 | 209.06 | 209.08 | 79000.0 |
| 2015-11-20 07:55:00 | SPY | ETF | 209.05 | 209.25 | 209.02 | 209.24 | 25697.0 |
| 2015-11-20 08:00:00 | SPY | ETF | 209.06 | 209.24 | 209.03 | 209.16 | 73303.0 |
| 2015-11-20 08:05:00 | SPY | ETF | 209.17 | 209.39 | 209.17 | 209.39 | 49559.0 |
| 2015-11-20 08:10:00 | SPY | ETF | 209.34 | 209.34 | 209.27 | 209.31 | 14950.0 |
| 2015-11-20 08:15:00 | SPY | ETF | 209.31 | 209.34 | 209.26 | 209.26 | 62371.0 |
| 2015-11-20 08:20:00 | SPY | ETF | 209.26 | 209.26 | 209.2 | 209.2 | 133240.0 |
| 2015-11-20 08:25:00 | SPY | ETF | 209.21 | 209.25 | 209.21 | 209.23 | 5732.0 |
| 2015-11-20 08:30:00 | SPY | ETF | 209.25 | 209.29 | 209.17 | 209.25 | 99205.0 |
| 2015-11-20 08:35:00 | SPY | ETF | 209.27 | 209.31 | 209.21 | 209.23 | 64267.0 |
| 2015-11-20 08:40:00 | SPY | ETF | 209.22 | 209.26 | 209.21 | 209.24 | 20701.0 |
| 2015-11-20 08:45:00 | SPY | ETF | 209.24 | 209.29 | 209.24 | 209.27 | 9720.0 |
| 2015-11-20 08:50:00 | SPY | ETF | 209.28 | 209.3 | 209.26 | 209.29 | 24061.0 |
| 2015-11-20 08:55:00 | SPY | ETF | 209.3 | 209.35 | 209.27 | 209.33 | 45270.0 |
| 2015-11-20 09:00:00 | SPY | ETF | 209.35 | 209.39 | 209.28 | 209.33 | 41206.0 |
| 2015-11-20 09:05:00 | SPY | ETF | 209.29 | 209.33 | 209.29 | 209.31 | 39890.0 |
| 2015-11-20 09:10:00 | SPY | ETF | 209.31 | 209.31 | 209.15 | 209.17 | 67752.0 |
> showing 50 of 47,334 rows — these rows as CSV