PREVIEW / etf_5min / 2016-12-08
file: by_date/etf_5min/2016/2016-12-08.parquet size: 1.4 MB rows: 59,550
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-08 04:00:00 | SPY | ETF | 224.35 | 224.35 | 224.2 | 224.2 | 4210.0 |
| 2016-12-08 04:05:00 | SPY | ETF | 224.15 | 224.15 | 224.15 | 224.15 | 1110.0 |
| 2016-12-08 04:10:00 | SPY | ETF | 224.15 | 224.2 | 224.15 | 224.2 | 1950.0 |
| 2016-12-08 04:15:00 | SPY | ETF | 224.07 | 224.07 | 224.07 | 224.07 | 110.0 |
| 2016-12-08 04:20:00 | SPY | ETF | 224.19 | 224.19 | 224.19 | 224.19 | 250.0 |
| 2016-12-08 04:30:00 | SPY | ETF | 224.25 | 224.27 | 224.25 | 224.27 | 200.0 |
| 2016-12-08 04:40:00 | SPY | ETF | 224.12 | 224.12 | 224.12 | 224.12 | 300.0 |
| 2016-12-08 04:45:00 | SPY | ETF | 224.11 | 224.17 | 224.11 | 224.17 | 1599.0 |
| 2016-12-08 04:50:00 | SPY | ETF | 224.26 | 224.26 | 224.26 | 224.26 | 2005.0 |
| 2016-12-08 04:55:00 | SPY | ETF | 224.25 | 224.25 | 224.2 | 224.2 | 1202.0 |
| 2016-12-08 05:00:00 | SPY | ETF | 224.18 | 224.18 | 224.18 | 224.18 | 401.0 |
| 2016-12-08 05:05:00 | SPY | ETF | 224.18 | 224.18 | 224.15 | 224.18 | 1702.0 |
| 2016-12-08 05:20:00 | SPY | ETF | 224.28 | 224.32 | 224.28 | 224.32 | 605.0 |
| 2016-12-08 05:25:00 | SPY | ETF | 224.3 | 224.3 | 224.3 | 224.3 | 300.0 |
| 2016-12-08 05:30:00 | SPY | ETF | 224.38 | 224.38 | 224.37 | 224.37 | 1200.0 |
| 2016-12-08 05:35:00 | SPY | ETF | 224.37 | 224.38 | 224.37 | 224.37 | 2420.0 |
| 2016-12-08 05:40:00 | SPY | ETF | 224.39 | 224.41 | 224.39 | 224.4 | 888.0 |
| 2016-12-08 05:45:00 | SPY | ETF | 224.4 | 224.41 | 224.4 | 224.41 | 1507.0 |
| 2016-12-08 05:50:00 | SPY | ETF | 224.34 | 224.37 | 224.34 | 224.37 | 450.0 |
| 2016-12-08 05:55:00 | SPY | ETF | 224.4 | 224.4 | 224.4 | 224.4 | 300.0 |
| 2016-12-08 06:00:00 | SPY | ETF | 224.46 | 224.46 | 224.38 | 224.38 | 3756.0 |
| 2016-12-08 06:05:00 | SPY | ETF | 224.35 | 224.35 | 224.35 | 224.35 | 303.0 |
| 2016-12-08 06:10:00 | SPY | ETF | 224.35 | 224.35 | 224.35 | 224.35 | 6601.0 |
| 2016-12-08 06:15:00 | SPY | ETF | 224.35 | 224.35 | 224.35 | 224.35 | 3301.0 |
| 2016-12-08 06:20:00 | SPY | ETF | 224.3 | 224.3 | 224.3 | 224.3 | 100.0 |
| 2016-12-08 06:25:00 | SPY | ETF | 224.31 | 224.31 | 224.31 | 224.31 | 100.0 |
| 2016-12-08 06:30:00 | SPY | ETF | 224.31 | 224.32 | 224.31 | 224.32 | 3701.0 |
| 2016-12-08 06:35:00 | SPY | ETF | 224.27 | 224.28 | 224.22 | 224.25 | 12230.0 |
| 2016-12-08 06:40:00 | SPY | ETF | 224.29 | 224.29 | 224.29 | 224.29 | 10002.0 |
| 2016-12-08 06:45:00 | SPY | ETF | 224.31 | 224.31 | 224.31 | 224.31 | 7500.0 |
| 2016-12-08 06:50:00 | SPY | ETF | 224.31 | 224.31 | 224.27 | 224.27 | 16457.0 |
| 2016-12-08 06:55:00 | SPY | ETF | 224.29 | 224.35 | 224.29 | 224.35 | 23204.0 |
| 2016-12-08 07:00:00 | SPY | ETF | 224.3 | 224.33 | 224.3 | 224.3 | 5302.0 |
| 2016-12-08 07:05:00 | SPY | ETF | 224.3 | 224.33 | 224.3 | 224.33 | 22101.0 |
| 2016-12-08 07:10:00 | SPY | ETF | 224.31 | 224.33 | 224.3 | 224.33 | 14623.0 |
| 2016-12-08 07:15:00 | SPY | ETF | 224.33 | 224.35 | 224.33 | 224.35 | 30301.0 |
| 2016-12-08 07:20:00 | SPY | ETF | 224.35 | 224.39 | 224.34 | 224.39 | 14064.0 |
| 2016-12-08 07:25:00 | SPY | ETF | 224.39 | 224.44 | 224.39 | 224.44 | 893.0 |
| 2016-12-08 07:30:00 | SPY | ETF | 224.44 | 224.45 | 224.43 | 224.43 | 8951.0 |
| 2016-12-08 07:35:00 | SPY | ETF | 224.45 | 224.45 | 224.43 | 224.45 | 17682.0 |
| 2016-12-08 07:40:00 | SPY | ETF | 224.44 | 224.5 | 224.43 | 224.5 | 50924.0 |
| 2016-12-08 07:45:00 | SPY | ETF | 224.49 | 224.49 | 223.8 | 224.36 | 282518.0 |
| 2016-12-08 07:50:00 | SPY | ETF | 224.41 | 224.61 | 224.2 | 224.55 | 144158.0 |
| 2016-12-08 07:55:00 | SPY | ETF | 224.49 | 224.58 | 224.4 | 224.4 | 36747.0 |
| 2016-12-08 08:00:00 | SPY | ETF | 224.31 | 224.51 | 224.07 | 224.11 | 122171.0 |
| 2016-12-08 08:05:00 | SPY | ETF | 224.12 | 224.28 | 224.08 | 224.19 | 42510.0 |
| 2016-12-08 08:10:00 | SPY | ETF | 224.23 | 224.4 | 224.19 | 224.37 | 31122.0 |
| 2016-12-08 08:15:00 | SPY | ETF | 224.36 | 224.41 | 224.33 | 224.37 | 45213.0 |
| 2016-12-08 08:20:00 | SPY | ETF | 224.37 | 224.37 | 224.22 | 224.28 | 32924.0 |
| 2016-12-08 08:25:00 | SPY | ETF | 224.27 | 224.43 | 224.26 | 224.41 | 58111.0 |
> showing 50 of 59,550 rows — these rows as CSV