PREVIEW / etf_1min / 2015-12-17
file: by_date/etf_1min/2015/2015-12-17.parquet size: 2.8 MB rows: 143,908
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-12-17 04:00:00 | SPY | ETF | 208.03 | 208.29 | 208.03 | 208.29 | 2140.0 |
| 2015-12-17 04:02:00 | SPY | ETF | 208.19 | 208.19 | 208.15 | 208.15 | 1114.0 |
| 2015-12-17 04:03:00 | SPY | ETF | 208.13 | 208.16 | 208.11 | 208.11 | 2003.0 |
| 2015-12-17 04:09:00 | SPY | ETF | 208.28 | 208.28 | 208.28 | 208.28 | 924.0 |
| 2015-12-17 04:11:00 | SPY | ETF | 208.25 | 208.29 | 208.25 | 208.29 | 1114.0 |
| 2015-12-17 04:13:00 | SPY | ETF | 208.24 | 208.24 | 208.24 | 208.24 | 129.0 |
| 2015-12-17 04:14:00 | SPY | ETF | 208.32 | 208.32 | 208.32 | 208.32 | 120.0 |
| 2015-12-17 04:15:00 | SPY | ETF | 208.24 | 208.24 | 208.24 | 208.24 | 500.0 |
| 2015-12-17 04:17:00 | SPY | ETF | 208.33 | 208.39 | 208.33 | 208.35 | 3010.0 |
| 2015-12-17 04:19:00 | SPY | ETF | 208.34 | 208.34 | 208.33 | 208.33 | 610.0 |
| 2015-12-17 04:20:00 | SPY | ETF | 208.24 | 208.24 | 208.24 | 208.24 | 304.0 |
| 2015-12-17 04:21:00 | SPY | ETF | 208.23 | 208.23 | 208.23 | 208.23 | 302.0 |
| 2015-12-17 04:23:00 | SPY | ETF | 208.12 | 208.12 | 208.12 | 208.12 | 304.0 |
| 2015-12-17 04:24:00 | SPY | ETF | 208.12 | 208.12 | 208.11 | 208.12 | 8000.0 |
| 2015-12-17 04:26:00 | SPY | ETF | 208.2 | 208.26 | 208.16 | 208.26 | 9509.0 |
| 2015-12-17 04:28:00 | SPY | ETF | 208.16 | 208.16 | 208.16 | 208.16 | 250.0 |
| 2015-12-17 04:29:00 | SPY | ETF | 208.06 | 208.21 | 208.02 | 208.21 | 4447.0 |
| 2015-12-17 04:32:00 | SPY | ETF | 208.23 | 208.23 | 208.23 | 208.23 | 200.0 |
| 2015-12-17 04:40:00 | SPY | ETF | 208.3 | 208.31 | 208.3 | 208.31 | 500.0 |
| 2015-12-17 04:42:00 | SPY | ETF | 208.34 | 208.35 | 208.31 | 208.31 | 1255.0 |
| 2015-12-17 04:44:00 | SPY | ETF | 208.31 | 208.31 | 208.31 | 208.31 | 124.0 |
| 2015-12-17 04:45:00 | SPY | ETF | 208.4 | 208.4 | 208.39 | 208.39 | 479.0 |
| 2015-12-17 04:49:00 | SPY | ETF | 208.34 | 208.34 | 208.34 | 208.34 | 100.0 |
| 2015-12-17 04:50:00 | SPY | ETF | 208.4 | 208.41 | 208.36 | 208.36 | 18250.0 |
| 2015-12-17 04:51:00 | SPY | ETF | 208.38 | 208.38 | 208.38 | 208.38 | 500.0 |
| 2015-12-17 04:59:00 | SPY | ETF | 208.49 | 208.56 | 208.49 | 208.56 | 3805.0 |
| 2015-12-17 05:00:00 | SPY | ETF | 208.5 | 208.51 | 208.5 | 208.51 | 2603.0 |
| 2015-12-17 05:01:00 | SPY | ETF | 208.5 | 208.5 | 208.5 | 208.5 | 1020.0 |
| 2015-12-17 05:02:00 | SPY | ETF | 208.46 | 208.46 | 208.44 | 208.44 | 7700.0 |
| 2015-12-17 05:03:00 | SPY | ETF | 208.45 | 208.45 | 208.42 | 208.42 | 4602.0 |
| 2015-12-17 05:04:00 | SPY | ETF | 208.45 | 208.45 | 208.45 | 208.45 | 200.0 |
| 2015-12-17 05:05:00 | SPY | ETF | 208.44 | 208.44 | 208.4 | 208.4 | 400.0 |
| 2015-12-17 05:06:00 | SPY | ETF | 208.44 | 208.46 | 208.44 | 208.46 | 2600.0 |
| 2015-12-17 05:07:00 | SPY | ETF | 208.47 | 208.51 | 208.47 | 208.51 | 6432.0 |
| 2015-12-17 05:11:00 | SPY | ETF | 208.44 | 208.44 | 208.44 | 208.44 | 400.0 |
| 2015-12-17 05:12:00 | SPY | ETF | 208.47 | 208.47 | 208.47 | 208.47 | 1600.0 |
| 2015-12-17 05:13:00 | SPY | ETF | 208.52 | 208.52 | 208.52 | 208.52 | 1604.0 |
| 2015-12-17 05:14:00 | SPY | ETF | 208.5 | 208.5 | 208.49 | 208.5 | 6750.0 |
| 2015-12-17 05:15:00 | SPY | ETF | 208.5 | 208.5 | 208.5 | 208.5 | 2600.0 |
| 2015-12-17 05:17:00 | SPY | ETF | 208.56 | 208.56 | 208.54 | 208.54 | 3618.0 |
| 2015-12-17 05:18:00 | SPY | ETF | 208.59 | 208.64 | 208.58 | 208.59 | 15421.0 |
| 2015-12-17 05:19:00 | SPY | ETF | 208.62 | 208.67 | 208.62 | 208.67 | 9528.0 |
| 2015-12-17 05:20:00 | SPY | ETF | 208.67 | 208.67 | 208.67 | 208.67 | 500.0 |
| 2015-12-17 05:21:00 | SPY | ETF | 208.59 | 208.61 | 208.59 | 208.61 | 800.0 |
| 2015-12-17 05:22:00 | SPY | ETF | 208.6 | 208.6 | 208.6 | 208.6 | 500.0 |
| 2015-12-17 05:23:00 | SPY | ETF | 208.61 | 208.64 | 208.61 | 208.61 | 10700.0 |
| 2015-12-17 05:24:00 | SPY | ETF | 208.7 | 208.74 | 208.69 | 208.69 | 11603.0 |
| 2015-12-17 05:25:00 | SPY | ETF | 208.75 | 208.75 | 208.75 | 208.75 | 500.0 |
| 2015-12-17 05:26:00 | SPY | ETF | 208.66 | 208.68 | 208.64 | 208.66 | 22800.0 |
| 2015-12-17 05:27:00 | SPY | ETF | 208.64 | 208.73 | 208.64 | 208.73 | 1620.0 |
> showing 50 of 143,908 rows — these rows as CSV