PREVIEW / etf_1min / 2015-10-28
file: by_date/etf_1min/2015/2015-10-28.parquet size: 2.6 MB rows: 133,627
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-10-28 04:00:00 | SPY | ETF | 206.84 | 206.84 | 206.84 | 206.84 | 121.0 |
| 2015-10-28 04:02:00 | SPY | ETF | 206.95 | 206.95 | 206.94 | 206.94 | 6001.0 |
| 2015-10-28 04:03:00 | SPY | ETF | 207.05 | 207.05 | 207.05 | 207.05 | 2200.0 |
| 2015-10-28 04:04:00 | SPY | ETF | 207.03 | 207.05 | 207.0 | 207.0 | 2900.0 |
| 2015-10-28 04:06:00 | SPY | ETF | 206.83 | 206.83 | 206.83 | 206.83 | 200.0 |
| 2015-10-28 04:07:00 | SPY | ETF | 206.85 | 206.85 | 206.85 | 206.85 | 200.0 |
| 2015-10-28 04:08:00 | SPY | ETF | 206.9 | 206.9 | 206.9 | 206.9 | 100.0 |
| 2015-10-28 04:11:00 | SPY | ETF | 206.88 | 206.88 | 206.88 | 206.88 | 101.0 |
| 2015-10-28 04:12:00 | SPY | ETF | 206.93 | 206.93 | 206.93 | 206.93 | 105.0 |
| 2015-10-28 04:15:00 | SPY | ETF | 206.82 | 206.82 | 206.77 | 206.77 | 900.0 |
| 2015-10-28 04:16:00 | SPY | ETF | 206.8 | 206.8 | 206.8 | 206.8 | 100.0 |
| 2015-10-28 04:17:00 | SPY | ETF | 206.85 | 206.85 | 206.85 | 206.85 | 1010.0 |
| 2015-10-28 04:24:00 | SPY | ETF | 206.93 | 206.93 | 206.93 | 206.93 | 250.0 |
| 2015-10-28 04:25:00 | SPY | ETF | 206.97 | 206.97 | 206.97 | 206.97 | 205.0 |
| 2015-10-28 04:26:00 | SPY | ETF | 207.0 | 207.0 | 207.0 | 207.0 | 505.0 |
| 2015-10-28 04:27:00 | SPY | ETF | 207.03 | 207.03 | 207.03 | 207.03 | 105.0 |
| 2015-10-28 04:33:00 | SPY | ETF | 207.02 | 207.02 | 207.02 | 207.02 | 289.0 |
| 2015-10-28 04:43:00 | SPY | ETF | 207.07 | 207.07 | 207.07 | 207.07 | 210.0 |
| 2015-10-28 04:45:00 | SPY | ETF | 207.08 | 207.08 | 207.08 | 207.08 | 155.0 |
| 2015-10-28 04:47:00 | SPY | ETF | 207.08 | 207.08 | 207.08 | 207.08 | 200.0 |
| 2015-10-28 05:06:00 | SPY | ETF | 207.08 | 207.08 | 207.08 | 207.08 | 206.0 |
| 2015-10-28 05:09:00 | SPY | ETF | 207.02 | 207.02 | 207.02 | 207.02 | 200.0 |
| 2015-10-28 05:16:00 | SPY | ETF | 207.04 | 207.04 | 207.04 | 207.04 | 3000.0 |
| 2015-10-28 05:29:00 | SPY | ETF | 207.1 | 207.13 | 207.1 | 207.13 | 2405.0 |
| 2015-10-28 05:30:00 | SPY | ETF | 207.1 | 207.1 | 207.1 | 207.1 | 100.0 |
| 2015-10-28 05:38:00 | SPY | ETF | 207.09 | 207.09 | 207.09 | 207.09 | 175.0 |
| 2015-10-28 05:42:00 | SPY | ETF | 207.02 | 207.02 | 207.02 | 207.02 | 100.0 |
| 2015-10-28 05:48:00 | SPY | ETF | 207.13 | 207.13 | 207.13 | 207.13 | 200.0 |
| 2015-10-28 05:51:00 | SPY | ETF | 207.17 | 207.17 | 207.17 | 207.17 | 210.0 |
| 2015-10-28 05:52:00 | SPY | ETF | 207.16 | 207.16 | 207.16 | 207.16 | 100.0 |
| 2015-10-28 05:53:00 | SPY | ETF | 207.18 | 207.25 | 207.18 | 207.25 | 1584.0 |
| 2015-10-28 05:55:00 | SPY | ETF | 207.25 | 207.25 | 207.25 | 207.25 | 153.0 |
| 2015-10-28 06:00:00 | SPY | ETF | 207.16 | 207.16 | 207.16 | 207.16 | 200.0 |
| 2015-10-28 06:05:00 | SPY | ETF | 207.16 | 207.16 | 207.1 | 207.1 | 1092.0 |
| 2015-10-28 06:06:00 | SPY | ETF | 207.13 | 207.13 | 207.13 | 207.13 | 100.0 |
| 2015-10-28 06:07:00 | SPY | ETF | 207.13 | 207.14 | 207.13 | 207.14 | 250.0 |
| 2015-10-28 06:10:00 | SPY | ETF | 207.17 | 207.19 | 207.17 | 207.19 | 405.0 |
| 2015-10-28 06:13:00 | SPY | ETF | 207.17 | 207.17 | 207.17 | 207.17 | 105.0 |
| 2015-10-28 06:17:00 | SPY | ETF | 207.17 | 207.17 | 207.17 | 207.17 | 405.0 |
| 2015-10-28 06:24:00 | SPY | ETF | 207.2 | 207.2 | 207.2 | 207.2 | 100.0 |
| 2015-10-28 06:25:00 | SPY | ETF | 207.22 | 207.22 | 207.22 | 207.22 | 100.0 |
| 2015-10-28 06:26:00 | SPY | ETF | 207.17 | 207.17 | 207.17 | 207.17 | 100.0 |
| 2015-10-28 06:33:00 | SPY | ETF | 207.12 | 207.12 | 207.12 | 207.12 | 200.0 |
| 2015-10-28 06:36:00 | SPY | ETF | 207.1 | 207.1 | 207.08 | 207.08 | 300.0 |
| 2015-10-28 06:46:00 | SPY | ETF | 207.09 | 207.09 | 207.09 | 207.09 | 375.0 |
| 2015-10-28 06:53:00 | SPY | ETF | 207.05 | 207.05 | 207.05 | 207.05 | 2000.0 |
| 2015-10-28 06:57:00 | SPY | ETF | 207.08 | 207.08 | 207.07 | 207.07 | 1128.0 |
| 2015-10-28 06:58:00 | SPY | ETF | 207.09 | 207.1 | 207.09 | 207.09 | 17500.0 |
| 2015-10-28 06:59:00 | SPY | ETF | 207.08 | 207.08 | 207.08 | 207.08 | 100.0 |
| 2015-10-28 07:00:00 | SPY | ETF | 207.08 | 207.08 | 207.08 | 207.08 | 190.0 |
> showing 50 of 133,627 rows — these rows as CSV