PREVIEW / etf_1min / 2016-12-29
file: by_date/etf_1min/2016/2016-12-29.parquet size: 2.8 MB rows: 145,558
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-29 04:00:00 | SPY | ETF | 224.3 | 224.3 | 224.3 | 224.3 | 100.0 |
| 2016-12-29 04:03:00 | SPY | ETF | 224.43 | 224.45 | 224.43 | 224.45 | 400.0 |
| 2016-12-29 04:23:00 | SPY | ETF | 224.49 | 224.49 | 224.49 | 224.49 | 300.0 |
| 2016-12-29 04:44:00 | SPY | ETF | 224.44 | 224.44 | 224.44 | 224.44 | 100.0 |
| 2016-12-29 04:47:00 | SPY | ETF | 224.41 | 224.41 | 224.41 | 224.41 | 552.0 |
| 2016-12-29 04:49:00 | SPY | ETF | 224.41 | 224.41 | 224.41 | 224.41 | 100.0 |
| 2016-12-29 04:50:00 | SPY | ETF | 224.43 | 224.43 | 224.43 | 224.43 | 200.0 |
| 2016-12-29 04:56:00 | SPY | ETF | 224.42 | 224.42 | 224.42 | 224.42 | 100.0 |
| 2016-12-29 04:57:00 | SPY | ETF | 224.42 | 224.42 | 224.41 | 224.41 | 3900.0 |
| 2016-12-29 05:06:00 | SPY | ETF | 224.42 | 224.42 | 224.42 | 224.42 | 100.0 |
| 2016-12-29 05:08:00 | SPY | ETF | 224.4 | 224.4 | 224.4 | 224.4 | 400.0 |
| 2016-12-29 05:14:00 | SPY | ETF | 224.4 | 224.4 | 224.4 | 224.4 | 175.0 |
| 2016-12-29 05:24:00 | SPY | ETF | 224.44 | 224.44 | 224.44 | 224.44 | 400.0 |
| 2016-12-29 05:31:00 | SPY | ETF | 224.51 | 224.51 | 224.51 | 224.51 | 303.0 |
| 2016-12-29 05:32:00 | SPY | ETF | 224.51 | 224.51 | 224.51 | 224.51 | 2900.0 |
| 2016-12-29 05:34:00 | SPY | ETF | 224.54 | 224.54 | 224.54 | 224.54 | 1801.0 |
| 2016-12-29 05:44:00 | SPY | ETF | 224.51 | 224.51 | 224.51 | 224.51 | 400.0 |
| 2016-12-29 05:47:00 | SPY | ETF | 224.56 | 224.56 | 224.56 | 224.56 | 102.0 |
| 2016-12-29 05:48:00 | SPY | ETF | 224.6 | 224.6 | 224.6 | 224.6 | 100.0 |
| 2016-12-29 05:57:00 | SPY | ETF | 224.54 | 224.54 | 224.54 | 224.54 | 301.0 |
| 2016-12-29 06:30:00 | SPY | ETF | 224.52 | 224.52 | 224.52 | 224.52 | 201.0 |
| 2016-12-29 06:36:00 | SPY | ETF | 224.49 | 224.49 | 224.49 | 224.49 | 101.0 |
| 2016-12-29 06:37:00 | SPY | ETF | 224.47 | 224.47 | 224.47 | 224.47 | 100.0 |
| 2016-12-29 06:38:00 | SPY | ETF | 224.47 | 224.47 | 224.47 | 224.47 | 404.0 |
| 2016-12-29 06:52:00 | SPY | ETF | 224.5 | 224.5 | 224.5 | 224.5 | 100.0 |
| 2016-12-29 06:53:00 | SPY | ETF | 224.5 | 224.5 | 224.5 | 224.5 | 100.0 |
| 2016-12-29 06:55:00 | SPY | ETF | 224.5 | 224.5 | 224.5 | 224.5 | 100.0 |
| 2016-12-29 07:05:00 | SPY | ETF | 224.48 | 224.48 | 224.48 | 224.48 | 200.0 |
| 2016-12-29 07:08:00 | SPY | ETF | 224.5 | 224.55 | 224.5 | 224.55 | 5604.0 |
| 2016-12-29 07:09:00 | SPY | ETF | 224.53 | 224.53 | 224.53 | 224.53 | 300.0 |
| 2016-12-29 07:11:00 | SPY | ETF | 224.54 | 224.54 | 224.54 | 224.54 | 200.0 |
| 2016-12-29 07:14:00 | SPY | ETF | 224.55 | 224.56 | 224.55 | 224.55 | 5130.0 |
| 2016-12-29 07:22:00 | SPY | ETF | 224.57 | 224.57 | 224.57 | 224.57 | 3201.0 |
| 2016-12-29 07:25:00 | SPY | ETF | 224.55 | 224.55 | 224.55 | 224.55 | 509.0 |
| 2016-12-29 07:28:00 | SPY | ETF | 224.55 | 224.55 | 224.55 | 224.55 | 2491.0 |
| 2016-12-29 07:32:00 | SPY | ETF | 224.56 | 224.58 | 224.56 | 224.58 | 17491.0 |
| 2016-12-29 07:34:00 | SPY | ETF | 224.59 | 224.61 | 224.59 | 224.61 | 8802.0 |
| 2016-12-29 07:36:00 | SPY | ETF | 224.61 | 224.63 | 224.61 | 224.63 | 6001.0 |
| 2016-12-29 07:37:00 | SPY | ETF | 224.63 | 224.63 | 224.63 | 224.63 | 3203.0 |
| 2016-12-29 07:38:00 | SPY | ETF | 224.63 | 224.63 | 224.63 | 224.63 | 100.0 |
| 2016-12-29 07:42:00 | SPY | ETF | 224.61 | 224.61 | 224.61 | 224.61 | 20000.0 |
| 2016-12-29 07:43:00 | SPY | ETF | 224.6 | 224.6 | 224.6 | 224.6 | 101.0 |
| 2016-12-29 07:45:00 | SPY | ETF | 224.59 | 224.6 | 224.59 | 224.6 | 1600.0 |
| 2016-12-29 07:46:00 | SPY | ETF | 224.6 | 224.6 | 224.6 | 224.6 | 900.0 |
| 2016-12-29 07:47:00 | SPY | ETF | 224.6 | 224.6 | 224.6 | 224.6 | 200.0 |
| 2016-12-29 07:48:00 | SPY | ETF | 224.6 | 224.6 | 224.59 | 224.6 | 10199.0 |
| 2016-12-29 07:51:00 | SPY | ETF | 224.6 | 224.6 | 224.6 | 224.6 | 2000.0 |
| 2016-12-29 07:53:00 | SPY | ETF | 224.61 | 224.62 | 224.61 | 224.62 | 15025.0 |
| 2016-12-29 07:55:00 | SPY | ETF | 224.62 | 224.62 | 224.62 | 224.62 | 100.0 |
| 2016-12-29 07:59:00 | SPY | ETF | 224.6 | 224.63 | 224.6 | 224.63 | 9402.0 |
> showing 50 of 145,558 rows — these rows as CSV