PREVIEW / etf_1min / 2016-09-26
file: by_date/etf_1min/2016/2016-09-26.parquet size: 2.4 MB rows: 131,151
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-09-26 04:00:00 | SPY | ETF | 215.2 | 215.2 | 215.0 | 215.0 | 1415.0 |
| 2016-09-26 04:01:00 | SPY | ETF | 215.0 | 215.13 | 215.0 | 215.0 | 1600.0 |
| 2016-09-26 04:02:00 | SPY | ETF | 215.2 | 215.2 | 215.19 | 215.19 | 520.0 |
| 2016-09-26 04:04:00 | SPY | ETF | 215.0 | 215.0 | 214.94 | 214.94 | 554.0 |
| 2016-09-26 04:05:00 | SPY | ETF | 214.93 | 214.97 | 214.86 | 214.86 | 736.0 |
| 2016-09-26 04:07:00 | SPY | ETF | 214.77 | 214.78 | 214.77 | 214.77 | 450.0 |
| 2016-09-26 04:09:00 | SPY | ETF | 214.88 | 214.88 | 214.88 | 214.88 | 160.0 |
| 2016-09-26 04:10:00 | SPY | ETF | 214.86 | 214.86 | 214.86 | 214.86 | 500.0 |
| 2016-09-26 04:12:00 | SPY | ETF | 214.86 | 214.86 | 214.83 | 214.86 | 1302.0 |
| 2016-09-26 04:13:00 | SPY | ETF | 214.77 | 214.8 | 214.77 | 214.8 | 427.0 |
| 2016-09-26 04:14:00 | SPY | ETF | 214.77 | 214.77 | 214.77 | 214.77 | 730.0 |
| 2016-09-26 04:16:00 | SPY | ETF | 214.8 | 214.82 | 214.8 | 214.81 | 1197.0 |
| 2016-09-26 04:18:00 | SPY | ETF | 214.84 | 214.84 | 214.84 | 214.84 | 401.0 |
| 2016-09-26 04:21:00 | SPY | ETF | 214.9 | 214.9 | 214.9 | 214.9 | 398.0 |
| 2016-09-26 04:22:00 | SPY | ETF | 214.8 | 214.8 | 214.8 | 214.8 | 104.0 |
| 2016-09-26 04:29:00 | SPY | ETF | 214.96 | 214.96 | 214.89 | 214.89 | 550.0 |
| 2016-09-26 04:30:00 | SPY | ETF | 214.91 | 214.91 | 214.91 | 214.91 | 454.0 |
| 2016-09-26 04:34:00 | SPY | ETF | 214.97 | 214.97 | 214.97 | 214.97 | 301.0 |
| 2016-09-26 04:40:00 | SPY | ETF | 214.95 | 214.98 | 214.95 | 214.98 | 2600.0 |
| 2016-09-26 04:43:00 | SPY | ETF | 215.0 | 215.0 | 214.99 | 214.99 | 2100.0 |
| 2016-09-26 04:44:00 | SPY | ETF | 214.99 | 215.0 | 214.95 | 214.95 | 1802.0 |
| 2016-09-26 04:45:00 | SPY | ETF | 214.96 | 214.96 | 214.96 | 214.96 | 605.0 |
| 2016-09-26 04:46:00 | SPY | ETF | 214.93 | 214.93 | 214.93 | 214.93 | 202.0 |
| 2016-09-26 04:51:00 | SPY | ETF | 215.03 | 215.03 | 215.03 | 215.03 | 401.0 |
| 2016-09-26 04:53:00 | SPY | ETF | 215.03 | 215.03 | 215.01 | 215.01 | 900.0 |
| 2016-09-26 04:55:00 | SPY | ETF | 215.01 | 215.01 | 215.01 | 215.01 | 400.0 |
| 2016-09-26 05:01:00 | SPY | ETF | 214.98 | 214.98 | 214.98 | 214.98 | 132.0 |
| 2016-09-26 05:06:00 | SPY | ETF | 215.0 | 215.0 | 215.0 | 215.0 | 303.0 |
| 2016-09-26 05:07:00 | SPY | ETF | 215.06 | 215.07 | 215.06 | 215.07 | 22222.0 |
| 2016-09-26 05:09:00 | SPY | ETF | 215.02 | 215.06 | 215.02 | 215.06 | 490.0 |
| 2016-09-26 05:10:00 | SPY | ETF | 215.06 | 215.07 | 215.06 | 215.07 | 302.0 |
| 2016-09-26 05:12:00 | SPY | ETF | 215.06 | 215.06 | 215.06 | 215.06 | 900.0 |
| 2016-09-26 05:13:00 | SPY | ETF | 215.06 | 215.06 | 215.06 | 215.06 | 300.0 |
| 2016-09-26 05:19:00 | SPY | ETF | 215.08 | 215.08 | 215.08 | 215.08 | 270.0 |
| 2016-09-26 05:25:00 | SPY | ETF | 215.06 | 215.06 | 215.06 | 215.06 | 700.0 |
| 2016-09-26 05:28:00 | SPY | ETF | 215.04 | 215.04 | 215.04 | 215.04 | 2501.0 |
| 2016-09-26 05:29:00 | SPY | ETF | 215.04 | 215.04 | 215.04 | 215.04 | 2501.0 |
| 2016-09-26 05:30:00 | SPY | ETF | 214.97 | 214.97 | 214.97 | 214.97 | 504.0 |
| 2016-09-26 05:32:00 | SPY | ETF | 214.96 | 214.96 | 214.96 | 214.96 | 100.0 |
| 2016-09-26 05:35:00 | SPY | ETF | 214.92 | 214.92 | 214.92 | 214.92 | 3750.0 |
| 2016-09-26 05:36:00 | SPY | ETF | 214.92 | 214.92 | 214.92 | 214.92 | 3750.0 |
| 2016-09-26 05:39:00 | SPY | ETF | 214.94 | 214.94 | 214.94 | 214.94 | 400.0 |
| 2016-09-26 05:40:00 | SPY | ETF | 214.91 | 214.91 | 214.91 | 214.91 | 202.0 |
| 2016-09-26 05:42:00 | SPY | ETF | 214.9 | 214.91 | 214.85 | 214.85 | 917.0 |
| 2016-09-26 05:43:00 | SPY | ETF | 214.85 | 214.85 | 214.85 | 214.85 | 201.0 |
| 2016-09-26 05:44:00 | SPY | ETF | 214.88 | 214.88 | 214.88 | 214.88 | 399.0 |
| 2016-09-26 05:45:00 | SPY | ETF | 214.88 | 214.88 | 214.88 | 214.88 | 600.0 |
| 2016-09-26 05:46:00 | SPY | ETF | 214.91 | 214.91 | 214.88 | 214.88 | 603.0 |
| 2016-09-26 05:47:00 | SPY | ETF | 214.87 | 214.87 | 214.87 | 214.87 | 162.0 |
| 2016-09-26 05:51:00 | SPY | ETF | 214.84 | 214.84 | 214.84 | 214.84 | 300.0 |
> showing 50 of 131,151 rows — these rows as CSV