PREVIEW / etf_1min / 2016-10-12
file: by_date/etf_1min/2016/2016-10-12.parquet size: 2.5 MB rows: 132,796
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-10-12 04:00:00 | SPY | ETF | 213.67 | 213.67 | 213.67 | 213.67 | 100.0 |
| 2016-10-12 04:01:00 | SPY | ETF | 213.58 | 213.58 | 213.57 | 213.57 | 2010.0 |
| 2016-10-12 04:03:00 | SPY | ETF | 213.6 | 213.61 | 213.6 | 213.6 | 12700.0 |
| 2016-10-12 04:04:00 | SPY | ETF | 213.63 | 213.63 | 213.55 | 213.55 | 3200.0 |
| 2016-10-12 04:09:00 | SPY | ETF | 213.5 | 213.59 | 213.5 | 213.59 | 11200.0 |
| 2016-10-12 04:10:00 | SPY | ETF | 213.48 | 213.54 | 213.48 | 213.54 | 13810.0 |
| 2016-10-12 04:11:00 | SPY | ETF | 213.48 | 213.51 | 213.48 | 213.51 | 396.0 |
| 2016-10-12 04:12:00 | SPY | ETF | 213.43 | 213.43 | 213.43 | 213.43 | 467.0 |
| 2016-10-12 04:16:00 | SPY | ETF | 213.5 | 213.5 | 213.5 | 213.5 | 192.0 |
| 2016-10-12 04:17:00 | SPY | ETF | 213.49 | 213.49 | 213.49 | 213.49 | 513.0 |
| 2016-10-12 04:22:00 | SPY | ETF | 213.69 | 213.69 | 213.69 | 213.69 | 2704.0 |
| 2016-10-12 04:32:00 | SPY | ETF | 213.71 | 213.71 | 213.71 | 213.71 | 900.0 |
| 2016-10-12 04:34:00 | SPY | ETF | 213.61 | 213.61 | 213.58 | 213.58 | 358.0 |
| 2016-10-12 04:35:00 | SPY | ETF | 213.56 | 213.56 | 213.56 | 213.56 | 1600.0 |
| 2016-10-12 04:37:00 | SPY | ETF | 213.53 | 213.53 | 213.53 | 213.53 | 102.0 |
| 2016-10-12 04:42:00 | SPY | ETF | 213.57 | 213.57 | 213.53 | 213.53 | 805.0 |
| 2016-10-12 04:43:00 | SPY | ETF | 213.54 | 213.54 | 213.54 | 213.54 | 105.0 |
| 2016-10-12 04:44:00 | SPY | ETF | 213.56 | 213.56 | 213.56 | 213.56 | 203.0 |
| 2016-10-12 04:48:00 | SPY | ETF | 213.64 | 213.64 | 213.64 | 213.64 | 1001.0 |
| 2016-10-12 05:07:00 | SPY | ETF | 213.71 | 213.71 | 213.71 | 213.71 | 1000.0 |
| 2016-10-12 05:14:00 | SPY | ETF | 213.66 | 213.66 | 213.66 | 213.66 | 100.0 |
| 2016-10-12 05:24:00 | SPY | ETF | 213.66 | 213.66 | 213.66 | 213.66 | 220.0 |
| 2016-10-12 05:25:00 | SPY | ETF | 213.69 | 213.69 | 213.69 | 213.69 | 404.0 |
| 2016-10-12 05:33:00 | SPY | ETF | 213.66 | 213.66 | 213.66 | 213.66 | 504.0 |
| 2016-10-12 05:45:00 | SPY | ETF | 213.64 | 213.64 | 213.64 | 213.64 | 1000.0 |
| 2016-10-12 05:46:00 | SPY | ETF | 213.61 | 213.61 | 213.61 | 213.61 | 501.0 |
| 2016-10-12 05:58:00 | SPY | ETF | 213.51 | 213.51 | 213.51 | 213.51 | 202.0 |
| 2016-10-12 05:59:00 | SPY | ETF | 213.54 | 213.54 | 213.54 | 213.54 | 3333.0 |
| 2016-10-12 06:01:00 | SPY | ETF | 213.52 | 213.52 | 213.51 | 213.52 | 5334.0 |
| 2016-10-12 06:07:00 | SPY | ETF | 213.57 | 213.57 | 213.52 | 213.52 | 1503.0 |
| 2016-10-12 06:08:00 | SPY | ETF | 213.51 | 213.51 | 213.49 | 213.49 | 10203.0 |
| 2016-10-12 06:10:00 | SPY | ETF | 213.51 | 213.51 | 213.51 | 213.51 | 100.0 |
| 2016-10-12 06:16:00 | SPY | ETF | 213.53 | 213.53 | 213.53 | 213.53 | 1000.0 |
| 2016-10-12 06:22:00 | SPY | ETF | 213.59 | 213.59 | 213.59 | 213.59 | 10100.0 |
| 2016-10-12 06:24:00 | SPY | ETF | 213.52 | 213.52 | 213.52 | 213.52 | 145.0 |
| 2016-10-12 06:33:00 | SPY | ETF | 213.54 | 213.54 | 213.54 | 213.54 | 700.0 |
| 2016-10-12 06:34:00 | SPY | ETF | 213.52 | 213.52 | 213.52 | 213.52 | 202.0 |
| 2016-10-12 06:35:00 | SPY | ETF | 213.55 | 213.55 | 213.55 | 213.55 | 201.0 |
| 2016-10-12 06:37:00 | SPY | ETF | 213.55 | 213.55 | 213.55 | 213.55 | 298.0 |
| 2016-10-12 06:41:00 | SPY | ETF | 213.54 | 213.54 | 213.54 | 213.54 | 100.0 |
| 2016-10-12 06:44:00 | SPY | ETF | 213.54 | 213.54 | 213.54 | 213.54 | 226.0 |
| 2016-10-12 06:46:00 | SPY | ETF | 213.53 | 213.53 | 213.53 | 213.53 | 504.0 |
| 2016-10-12 06:51:00 | SPY | ETF | 213.67 | 213.67 | 213.67 | 213.67 | 10200.0 |
| 2016-10-12 06:52:00 | SPY | ETF | 213.67 | 213.67 | 213.67 | 213.67 | 110.0 |
| 2016-10-12 06:53:00 | SPY | ETF | 213.67 | 213.69 | 213.67 | 213.69 | 10000.0 |
| 2016-10-12 06:54:00 | SPY | ETF | 213.7 | 213.7 | 213.7 | 213.7 | 776.0 |
| 2016-10-12 06:56:00 | SPY | ETF | 213.63 | 213.63 | 213.63 | 213.63 | 305.0 |
| 2016-10-12 07:00:00 | SPY | ETF | 213.7 | 213.72 | 213.69 | 213.69 | 902.0 |
| 2016-10-12 07:01:00 | SPY | ETF | 213.69 | 213.7 | 213.67 | 213.7 | 1202.0 |
| 2016-10-12 07:02:00 | SPY | ETF | 213.67 | 213.67 | 213.67 | 213.67 | 901.0 |
> showing 50 of 132,796 rows — these rows as CSV