PREVIEW / etf_1min / 2016-11-08
file: by_date/etf_1min/2016/2016-11-08.parquet size: 2.8 MB rows: 141,541
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-11-08 04:05:00 | SPY | ETF | 213.25 | 213.25 | 213.25 | 213.25 | 100.0 |
| 2016-11-08 04:09:00 | SPY | ETF | 213.28 | 213.28 | 213.28 | 213.28 | 400.0 |
| 2016-11-08 04:10:00 | SPY | ETF | 213.26 | 213.26 | 213.26 | 213.26 | 201.0 |
| 2016-11-08 04:14:00 | SPY | ETF | 213.31 | 213.31 | 213.31 | 213.31 | 1000.0 |
| 2016-11-08 04:17:00 | SPY | ETF | 213.31 | 213.31 | 213.31 | 213.31 | 100.0 |
| 2016-11-08 04:19:00 | SPY | ETF | 213.32 | 213.32 | 213.32 | 213.32 | 404.0 |
| 2016-11-08 04:21:00 | SPY | ETF | 213.37 | 213.37 | 213.34 | 213.34 | 701.0 |
| 2016-11-08 04:23:00 | SPY | ETF | 213.36 | 213.36 | 213.36 | 213.36 | 501.0 |
| 2016-11-08 04:27:00 | SPY | ETF | 213.19 | 213.19 | 213.19 | 213.19 | 104.0 |
| 2016-11-08 04:36:00 | SPY | ETF | 213.3 | 213.3 | 213.3 | 213.3 | 104.0 |
| 2016-11-08 04:39:00 | SPY | ETF | 213.36 | 213.36 | 213.36 | 213.36 | 2003.0 |
| 2016-11-08 04:49:00 | SPY | ETF | 213.29 | 213.29 | 213.29 | 213.29 | 1400.0 |
| 2016-11-08 04:52:00 | SPY | ETF | 213.28 | 213.28 | 213.28 | 213.28 | 401.0 |
| 2016-11-08 05:00:00 | SPY | ETF | 213.28 | 213.28 | 213.28 | 213.28 | 5000.0 |
| 2016-11-08 05:07:00 | SPY | ETF | 213.2 | 213.2 | 213.2 | 213.2 | 102.0 |
| 2016-11-08 05:12:00 | SPY | ETF | 213.19 | 213.19 | 213.19 | 213.19 | 302.0 |
| 2016-11-08 05:13:00 | SPY | ETF | 213.19 | 213.19 | 213.19 | 213.19 | 204.0 |
| 2016-11-08 05:16:00 | SPY | ETF | 213.16 | 213.16 | 213.16 | 213.16 | 202.0 |
| 2016-11-08 05:18:00 | SPY | ETF | 213.11 | 213.11 | 213.08 | 213.08 | 5001.0 |
| 2016-11-08 05:19:00 | SPY | ETF | 213.07 | 213.07 | 213.04 | 213.04 | 703.0 |
| 2016-11-08 05:23:00 | SPY | ETF | 213.05 | 213.05 | 213.05 | 213.05 | 1041.0 |
| 2016-11-08 05:26:00 | SPY | ETF | 213.01 | 213.01 | 213.0 | 213.0 | 304.0 |
| 2016-11-08 05:30:00 | SPY | ETF | 213.01 | 213.01 | 212.92 | 212.92 | 4540.0 |
| 2016-11-08 05:31:00 | SPY | ETF | 212.88 | 212.88 | 212.82 | 212.82 | 635.0 |
| 2016-11-08 05:36:00 | SPY | ETF | 212.92 | 212.92 | 212.92 | 212.92 | 302.0 |
| 2016-11-08 05:38:00 | SPY | ETF | 212.96 | 212.96 | 212.96 | 212.96 | 100.0 |
| 2016-11-08 05:39:00 | SPY | ETF | 212.99 | 212.99 | 212.99 | 212.99 | 402.0 |
| 2016-11-08 05:41:00 | SPY | ETF | 213.04 | 213.04 | 213.04 | 213.04 | 304.0 |
| 2016-11-08 05:44:00 | SPY | ETF | 213.08 | 213.08 | 213.08 | 213.08 | 201.0 |
| 2016-11-08 05:46:00 | SPY | ETF | 213.04 | 213.08 | 213.04 | 213.08 | 1302.0 |
| 2016-11-08 05:47:00 | SPY | ETF | 213.08 | 213.08 | 213.03 | 213.03 | 491.0 |
| 2016-11-08 05:48:00 | SPY | ETF | 213.04 | 213.04 | 213.04 | 213.04 | 1500.0 |
| 2016-11-08 05:49:00 | SPY | ETF | 213.04 | 213.04 | 213.04 | 213.04 | 1502.0 |
| 2016-11-08 05:51:00 | SPY | ETF | 213.07 | 213.07 | 213.07 | 213.07 | 650.0 |
| 2016-11-08 05:52:00 | SPY | ETF | 213.07 | 213.07 | 213.07 | 213.07 | 750.0 |
| 2016-11-08 05:53:00 | SPY | ETF | 213.04 | 213.04 | 213.04 | 213.04 | 500.0 |
| 2016-11-08 05:54:00 | SPY | ETF | 213.07 | 213.07 | 213.07 | 213.07 | 500.0 |
| 2016-11-08 05:55:00 | SPY | ETF | 213.06 | 213.12 | 213.06 | 213.12 | 700.0 |
| 2016-11-08 05:56:00 | SPY | ETF | 213.07 | 213.07 | 213.01 | 213.01 | 621.0 |
| 2016-11-08 05:57:00 | SPY | ETF | 213.01 | 213.01 | 213.01 | 213.01 | 200.0 |
| 2016-11-08 05:58:00 | SPY | ETF | 213.09 | 213.09 | 213.09 | 213.09 | 305.0 |
| 2016-11-08 06:00:00 | SPY | ETF | 213.07 | 213.07 | 213.07 | 213.07 | 502.0 |
| 2016-11-08 06:01:00 | SPY | ETF | 213.09 | 213.09 | 213.02 | 213.02 | 703.0 |
| 2016-11-08 06:03:00 | SPY | ETF | 212.98 | 212.98 | 212.98 | 212.98 | 5128.0 |
| 2016-11-08 06:05:00 | SPY | ETF | 212.97 | 213.04 | 212.97 | 213.04 | 1707.0 |
| 2016-11-08 06:06:00 | SPY | ETF | 213.02 | 213.02 | 213.02 | 213.02 | 1002.0 |
| 2016-11-08 06:09:00 | SPY | ETF | 212.99 | 212.99 | 212.99 | 212.99 | 900.0 |
| 2016-11-08 06:11:00 | SPY | ETF | 213.04 | 213.04 | 213.04 | 213.04 | 180.0 |
| 2016-11-08 06:12:00 | SPY | ETF | 212.99 | 212.99 | 212.99 | 212.99 | 200.0 |
| 2016-11-08 06:13:00 | SPY | ETF | 213.0 | 213.0 | 212.99 | 212.99 | 321.0 |
> showing 50 of 141,541 rows — these rows as CSV