PREVIEW / etf_5min / 2015-06-23
file: by_date/etf_5min/2015/2015-06-23.parquet size: 1.1 MB rows: 46,744
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-06-23 04:05:00 | SPY | ETF | 212.14 | 212.17 | 212.14 | 212.17 | 1200.0 |
| 2015-06-23 04:10:00 | SPY | ETF | 212.14 | 212.18 | 212.14 | 212.18 | 900.0 |
| 2015-06-23 04:15:00 | SPY | ETF | 212.16 | 212.16 | 212.16 | 212.16 | 900.0 |
| 2015-06-23 04:20:00 | SPY | ETF | 212.11 | 212.11 | 212.1 | 212.1 | 1200.0 |
| 2015-06-23 04:45:00 | SPY | ETF | 212.08 | 212.08 | 212.08 | 212.08 | 200.0 |
| 2015-06-23 04:50:00 | SPY | ETF | 212.12 | 212.12 | 212.12 | 212.12 | 900.0 |
| 2015-06-23 04:55:00 | SPY | ETF | 212.06 | 212.06 | 212.06 | 212.06 | 100.0 |
| 2015-06-23 05:00:00 | SPY | ETF | 212.07 | 212.07 | 212.07 | 212.07 | 100.0 |
| 2015-06-23 05:10:00 | SPY | ETF | 211.96 | 211.96 | 211.96 | 211.96 | 500.0 |
| 2015-06-23 05:15:00 | SPY | ETF | 211.96 | 211.96 | 211.95 | 211.95 | 600.0 |
| 2015-06-23 05:20:00 | SPY | ETF | 211.96 | 211.96 | 211.96 | 211.96 | 300.0 |
| 2015-06-23 05:25:00 | SPY | ETF | 211.95 | 211.98 | 211.95 | 211.97 | 17550.0 |
| 2015-06-23 05:30:00 | SPY | ETF | 211.96 | 212.0 | 211.96 | 212.0 | 3200.0 |
| 2015-06-23 05:35:00 | SPY | ETF | 212.03 | 212.03 | 212.03 | 212.03 | 500.0 |
| 2015-06-23 05:40:00 | SPY | ETF | 211.95 | 211.95 | 211.95 | 211.95 | 600.0 |
| 2015-06-23 05:45:00 | SPY | ETF | 211.98 | 212.1 | 211.97 | 212.09 | 600.0 |
| 2015-06-23 05:50:00 | SPY | ETF | 211.97 | 211.97 | 211.97 | 211.97 | 500.0 |
| 2015-06-23 05:55:00 | SPY | ETF | 212.02 | 212.02 | 212.02 | 212.02 | 100.0 |
| 2015-06-23 06:00:00 | SPY | ETF | 212.03 | 212.03 | 211.99 | 211.99 | 600.0 |
| 2015-06-23 06:05:00 | SPY | ETF | 212.02 | 212.02 | 211.99 | 211.99 | 820.0 |
| 2015-06-23 06:10:00 | SPY | ETF | 212.03 | 212.07 | 212.03 | 212.07 | 1500.0 |
| 2015-06-23 06:15:00 | SPY | ETF | 212.1 | 212.1 | 212.01 | 212.05 | 6203.0 |
| 2015-06-23 06:20:00 | SPY | ETF | 212.09 | 212.11 | 212.09 | 212.1 | 1700.0 |
| 2015-06-23 06:25:00 | SPY | ETF | 212.1 | 212.13 | 212.05 | 212.05 | 1940.0 |
| 2015-06-23 06:30:00 | SPY | ETF | 212.05 | 212.07 | 211.91 | 212.06 | 32500.0 |
| 2015-06-23 06:35:00 | SPY | ETF | 212.08 | 212.13 | 212.08 | 212.13 | 24486.0 |
| 2015-06-23 06:40:00 | SPY | ETF | 212.15 | 212.19 | 212.14 | 212.14 | 1660.0 |
| 2015-06-23 06:45:00 | SPY | ETF | 212.13 | 212.16 | 212.13 | 212.16 | 1300.0 |
| 2015-06-23 06:50:00 | SPY | ETF | 212.17 | 212.17 | 212.17 | 212.17 | 5000.0 |
| 2015-06-23 06:55:00 | SPY | ETF | 212.12 | 212.12 | 212.08 | 212.08 | 2409.0 |
| 2015-06-23 07:00:00 | SPY | ETF | 212.07 | 212.07 | 211.95 | 212.01 | 31500.0 |
| 2015-06-23 07:05:00 | SPY | ETF | 211.99 | 212.01 | 211.99 | 212.01 | 3380.0 |
| 2015-06-23 07:10:00 | SPY | ETF | 212.02 | 212.03 | 211.99 | 212.03 | 920.0 |
| 2015-06-23 07:15:00 | SPY | ETF | 212.01 | 212.12 | 212.01 | 212.1 | 18322.0 |
| 2015-06-23 07:20:00 | SPY | ETF | 212.1 | 212.13 | 212.06 | 212.13 | 7640.0 |
| 2015-06-23 07:25:00 | SPY | ETF | 212.13 | 212.18 | 212.12 | 212.14 | 12360.0 |
| 2015-06-23 07:30:00 | SPY | ETF | 212.15 | 212.25 | 212.13 | 212.25 | 37965.0 |
| 2015-06-23 07:35:00 | SPY | ETF | 212.28 | 212.28 | 212.22 | 212.25 | 25163.0 |
| 2015-06-23 07:40:00 | SPY | ETF | 212.22 | 212.23 | 212.2 | 212.21 | 39650.0 |
| 2015-06-23 07:45:00 | SPY | ETF | 212.22 | 212.25 | 212.22 | 212.25 | 5965.0 |
| 2015-06-23 07:50:00 | SPY | ETF | 212.24 | 212.27 | 212.24 | 212.26 | 7169.0 |
| 2015-06-23 07:55:00 | SPY | ETF | 212.27 | 212.27 | 212.2 | 212.24 | 42189.0 |
| 2015-06-23 08:00:00 | SPY | ETF | 212.24 | 212.29 | 212.0 | 212.23 | 31571.0 |
| 2015-06-23 08:05:00 | SPY | ETF | 212.01 | 212.35 | 212.01 | 212.33 | 88134.0 |
| 2015-06-23 08:10:00 | SPY | ETF | 212.33 | 212.33 | 212.27 | 212.3 | 15835.0 |
| 2015-06-23 08:15:00 | SPY | ETF | 212.28 | 212.29 | 212.25 | 212.27 | 18300.0 |
| 2015-06-23 08:20:00 | SPY | ETF | 212.25 | 212.27 | 212.25 | 212.26 | 9595.0 |
| 2015-06-23 08:25:00 | SPY | ETF | 212.27 | 212.27 | 212.2 | 212.2 | 35459.0 |
| 2015-06-23 08:30:00 | SPY | ETF | 212.15 | 212.28 | 212.15 | 212.18 | 44485.0 |
| 2015-06-23 08:35:00 | SPY | ETF | 212.18 | 212.23 | 212.18 | 212.2 | 30020.0 |
> showing 50 of 46,744 rows — these rows as CSV