PREVIEW / etf_1min / 2016-07-21
file: by_date/etf_1min/2016/2016-07-21.parquet size: 2.5 MB rows: 131,728
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-07-21 04:05:00 | SPY | ETF | 217.15 | 217.15 | 217.15 | 217.15 | 100.0 |
| 2016-07-21 04:07:00 | SPY | ETF | 217.11 | 217.11 | 217.11 | 217.11 | 2000.0 |
| 2016-07-21 04:13:00 | SPY | ETF | 217.09 | 217.09 | 217.09 | 217.09 | 1400.0 |
| 2016-07-21 04:17:00 | SPY | ETF | 217.14 | 217.14 | 217.14 | 217.14 | 100.0 |
| 2016-07-21 04:23:00 | SPY | ETF | 217.2 | 217.2 | 217.2 | 217.2 | 100.0 |
| 2016-07-21 04:29:00 | SPY | ETF | 217.16 | 217.16 | 217.16 | 217.16 | 300.0 |
| 2016-07-21 04:30:00 | SPY | ETF | 217.17 | 217.17 | 217.17 | 217.17 | 100.0 |
| 2016-07-21 04:31:00 | SPY | ETF | 217.19 | 217.19 | 217.19 | 217.19 | 900.0 |
| 2016-07-21 04:33:00 | SPY | ETF | 217.15 | 217.15 | 217.1 | 217.1 | 4200.0 |
| 2016-07-21 04:34:00 | SPY | ETF | 217.04 | 217.04 | 216.91 | 216.91 | 2111.0 |
| 2016-07-21 04:35:00 | SPY | ETF | 216.86 | 216.87 | 216.86 | 216.87 | 1162.0 |
| 2016-07-21 04:36:00 | SPY | ETF | 216.8 | 216.83 | 216.79 | 216.79 | 3204.0 |
| 2016-07-21 04:39:00 | SPY | ETF | 216.87 | 216.87 | 216.87 | 216.87 | 400.0 |
| 2016-07-21 04:40:00 | SPY | ETF | 216.84 | 216.84 | 216.84 | 216.84 | 1840.0 |
| 2016-07-21 04:41:00 | SPY | ETF | 216.83 | 216.83 | 216.83 | 216.83 | 230.0 |
| 2016-07-21 04:44:00 | SPY | ETF | 216.86 | 216.86 | 216.76 | 216.76 | 2003.0 |
| 2016-07-21 04:47:00 | SPY | ETF | 216.79 | 216.79 | 216.79 | 216.79 | 300.0 |
| 2016-07-21 04:50:00 | SPY | ETF | 216.82 | 216.82 | 216.82 | 216.82 | 216.0 |
| 2016-07-21 04:51:00 | SPY | ETF | 216.87 | 216.87 | 216.87 | 216.87 | 104.0 |
| 2016-07-21 04:52:00 | SPY | ETF | 216.91 | 216.91 | 216.91 | 216.91 | 174.0 |
| 2016-07-21 04:55:00 | SPY | ETF | 216.91 | 216.91 | 216.91 | 216.91 | 400.0 |
| 2016-07-21 04:57:00 | SPY | ETF | 216.96 | 216.96 | 216.96 | 216.96 | 205.0 |
| 2016-07-21 05:00:00 | SPY | ETF | 216.94 | 216.94 | 216.94 | 216.94 | 201.0 |
| 2016-07-21 05:01:00 | SPY | ETF | 216.86 | 216.86 | 216.86 | 216.86 | 2003.0 |
| 2016-07-21 05:02:00 | SPY | ETF | 216.86 | 216.86 | 216.86 | 216.86 | 1301.0 |
| 2016-07-21 05:05:00 | SPY | ETF | 216.89 | 216.89 | 216.89 | 216.89 | 303.0 |
| 2016-07-21 05:08:00 | SPY | ETF | 216.94 | 216.94 | 216.94 | 216.94 | 500.0 |
| 2016-07-21 05:09:00 | SPY | ETF | 216.91 | 216.91 | 216.91 | 216.91 | 200.0 |
| 2016-07-21 05:11:00 | SPY | ETF | 216.93 | 216.95 | 216.93 | 216.95 | 299.0 |
| 2016-07-21 05:12:00 | SPY | ETF | 216.92 | 216.92 | 216.91 | 216.91 | 1610.0 |
| 2016-07-21 05:21:00 | SPY | ETF | 216.9 | 216.9 | 216.9 | 216.9 | 102.0 |
| 2016-07-21 05:22:00 | SPY | ETF | 216.87 | 216.87 | 216.87 | 216.87 | 200.0 |
| 2016-07-21 05:24:00 | SPY | ETF | 216.85 | 216.85 | 216.85 | 216.85 | 200.0 |
| 2016-07-21 05:25:00 | SPY | ETF | 216.82 | 216.82 | 216.82 | 216.82 | 117.0 |
| 2016-07-21 05:26:00 | SPY | ETF | 216.8 | 216.8 | 216.8 | 216.8 | 100.0 |
| 2016-07-21 05:27:00 | SPY | ETF | 216.82 | 216.82 | 216.82 | 216.82 | 251.0 |
| 2016-07-21 05:28:00 | SPY | ETF | 216.8 | 216.8 | 216.8 | 216.8 | 200.0 |
| 2016-07-21 05:29:00 | SPY | ETF | 216.8 | 216.8 | 216.8 | 216.8 | 400.0 |
| 2016-07-21 05:30:00 | SPY | ETF | 216.79 | 216.79 | 216.78 | 216.78 | 719.0 |
| 2016-07-21 05:32:00 | SPY | ETF | 216.75 | 216.75 | 216.74 | 216.75 | 1800.0 |
| 2016-07-21 05:33:00 | SPY | ETF | 216.74 | 216.74 | 216.74 | 216.74 | 200.0 |
| 2016-07-21 05:34:00 | SPY | ETF | 216.75 | 216.75 | 216.75 | 216.75 | 270.0 |
| 2016-07-21 05:35:00 | SPY | ETF | 216.72 | 216.72 | 216.68 | 216.68 | 1152.0 |
| 2016-07-21 05:36:00 | SPY | ETF | 216.72 | 216.72 | 216.72 | 216.72 | 221.0 |
| 2016-07-21 05:40:00 | SPY | ETF | 216.75 | 216.75 | 216.75 | 216.75 | 3500.0 |
| 2016-07-21 05:41:00 | SPY | ETF | 216.77 | 216.77 | 216.74 | 216.74 | 7100.0 |
| 2016-07-21 05:43:00 | SPY | ETF | 216.79 | 216.79 | 216.79 | 216.79 | 2525.0 |
| 2016-07-21 05:49:00 | SPY | ETF | 216.8 | 216.8 | 216.79 | 216.79 | 600.0 |
| 2016-07-21 05:50:00 | SPY | ETF | 216.82 | 216.82 | 216.82 | 216.82 | 110.0 |
| 2016-07-21 05:57:00 | SPY | ETF | 216.76 | 216.76 | 216.76 | 216.76 | 1502.0 |
> showing 50 of 131,728 rows — these rows as CSV