PREVIEW / etf_5min / 2016-12-01
file: by_date/etf_5min/2016/2016-12-01.parquet size: 1.4 MB rows: 58,727
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-12-01 04:00:00 | SPY | ETF | 220.29 | 220.29 | 220.24 | 220.24 | 800.0 |
| 2016-12-01 04:10:00 | SPY | ETF | 220.2 | 220.2 | 220.2 | 220.2 | 320.0 |
| 2016-12-01 04:15:00 | SPY | ETF | 220.19 | 220.19 | 220.19 | 220.19 | 153.0 |
| 2016-12-01 04:30:00 | SPY | ETF | 220.15 | 220.15 | 220.12 | 220.12 | 1301.0 |
| 2016-12-01 04:35:00 | SPY | ETF | 220.1 | 220.1 | 220.1 | 220.1 | 201.0 |
| 2016-12-01 04:40:00 | SPY | ETF | 220.12 | 220.13 | 220.1 | 220.11 | 12804.0 |
| 2016-12-01 04:45:00 | SPY | ETF | 220.07 | 220.07 | 220.04 | 220.05 | 1752.0 |
| 2016-12-01 04:50:00 | SPY | ETF | 220.1 | 220.15 | 220.1 | 220.15 | 401.0 |
| 2016-12-01 04:55:00 | SPY | ETF | 220.11 | 220.11 | 220.11 | 220.11 | 1001.0 |
| 2016-12-01 05:00:00 | SPY | ETF | 220.06 | 220.08 | 220.06 | 220.08 | 1410.0 |
| 2016-12-01 05:05:00 | SPY | ETF | 220.1 | 220.16 | 220.1 | 220.16 | 1405.0 |
| 2016-12-01 05:25:00 | SPY | ETF | 220.27 | 220.27 | 220.21 | 220.21 | 1103.0 |
| 2016-12-01 05:35:00 | SPY | ETF | 220.27 | 220.27 | 220.22 | 220.22 | 424.0 |
| 2016-12-01 05:40:00 | SPY | ETF | 220.25 | 220.25 | 220.25 | 220.25 | 700.0 |
| 2016-12-01 05:45:00 | SPY | ETF | 220.23 | 220.23 | 220.19 | 220.19 | 1020.0 |
| 2016-12-01 05:50:00 | SPY | ETF | 220.17 | 220.17 | 220.12 | 220.12 | 803.0 |
| 2016-12-01 05:55:00 | SPY | ETF | 220.11 | 220.11 | 220.1 | 220.1 | 301.0 |
| 2016-12-01 06:00:00 | SPY | ETF | 220.1 | 220.1 | 220.1 | 220.1 | 101.0 |
| 2016-12-01 06:05:00 | SPY | ETF | 220.06 | 220.08 | 220.06 | 220.08 | 1500.0 |
| 2016-12-01 06:10:00 | SPY | ETF | 220.08 | 220.08 | 220.08 | 220.08 | 1100.0 |
| 2016-12-01 06:15:00 | SPY | ETF | 220.13 | 220.13 | 220.13 | 220.13 | 500.0 |
| 2016-12-01 06:20:00 | SPY | ETF | 220.13 | 220.13 | 220.13 | 220.13 | 15000.0 |
| 2016-12-01 06:25:00 | SPY | ETF | 220.17 | 220.17 | 220.17 | 220.17 | 300.0 |
| 2016-12-01 06:30:00 | SPY | ETF | 220.16 | 220.16 | 220.16 | 220.16 | 200.0 |
| 2016-12-01 06:40:00 | SPY | ETF | 220.25 | 220.25 | 220.24 | 220.24 | 800.0 |
| 2016-12-01 06:55:00 | SPY | ETF | 220.23 | 220.23 | 220.23 | 220.23 | 1000.0 |
| 2016-12-01 07:00:00 | SPY | ETF | 220.25 | 220.25 | 220.12 | 220.15 | 803.0 |
| 2016-12-01 07:05:00 | SPY | ETF | 220.18 | 220.18 | 220.12 | 220.12 | 7002.0 |
| 2016-12-01 07:10:00 | SPY | ETF | 220.1 | 220.1 | 220.1 | 220.1 | 552.0 |
| 2016-12-01 07:15:00 | SPY | ETF | 220.09 | 220.11 | 220.08 | 220.08 | 15869.0 |
| 2016-12-01 07:20:00 | SPY | ETF | 220.07 | 220.08 | 220.07 | 220.08 | 702.0 |
| 2016-12-01 07:25:00 | SPY | ETF | 220.08 | 220.08 | 220.08 | 220.08 | 5000.0 |
| 2016-12-01 07:30:00 | SPY | ETF | 220.11 | 220.11 | 220.07 | 220.08 | 5502.0 |
| 2016-12-01 07:35:00 | SPY | ETF | 220.08 | 220.15 | 220.08 | 220.15 | 5424.0 |
| 2016-12-01 07:40:00 | SPY | ETF | 220.17 | 220.17 | 220.17 | 220.17 | 5001.0 |
| 2016-12-01 07:45:00 | SPY | ETF | 220.2 | 220.23 | 220.2 | 220.22 | 9821.0 |
| 2016-12-01 07:50:00 | SPY | ETF | 220.25 | 220.25 | 220.18 | 220.2 | 3710.0 |
| 2016-12-01 07:55:00 | SPY | ETF | 220.19 | 220.19 | 220.19 | 220.19 | 400.0 |
| 2016-12-01 08:00:00 | SPY | ETF | 220.15 | 220.26 | 220.07 | 220.2 | 26759.0 |
| 2016-12-01 08:05:00 | SPY | ETF | 220.22 | 220.24 | 220.2 | 220.2 | 21100.0 |
| 2016-12-01 08:10:00 | SPY | ETF | 220.2 | 220.26 | 220.2 | 220.26 | 14153.0 |
| 2016-12-01 08:15:00 | SPY | ETF | 220.25 | 220.28 | 220.24 | 220.26 | 20381.0 |
| 2016-12-01 08:20:00 | SPY | ETF | 220.25 | 220.31 | 220.25 | 220.31 | 16596.0 |
| 2016-12-01 08:25:00 | SPY | ETF | 220.3 | 220.33 | 220.29 | 220.3 | 113864.0 |
| 2016-12-01 08:30:00 | SPY | ETF | 220.31 | 220.4 | 220.31 | 220.38 | 71020.0 |
| 2016-12-01 08:35:00 | SPY | ETF | 220.38 | 220.43 | 220.37 | 220.41 | 75503.0 |
| 2016-12-01 08:40:00 | SPY | ETF | 220.41 | 220.51 | 220.41 | 220.51 | 164960.0 |
| 2016-12-01 08:45:00 | SPY | ETF | 220.51 | 220.66 | 220.5 | 220.62 | 132820.0 |
| 2016-12-01 08:50:00 | SPY | ETF | 220.62 | 220.75 | 220.61 | 220.66 | 67495.0 |
| 2016-12-01 08:55:00 | SPY | ETF | 220.66 | 220.68 | 220.64 | 220.68 | 26339.0 |
> showing 50 of 58,727 rows — these rows as CSV