PREVIEW / etf_1min / 2016-10-11
file: by_date/etf_1min/2016/2016-10-11.parquet size: 2.7 MB rows: 141,263
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-11 04:00:00 | SPY | ETF | 215.91 | 215.91 | 215.91 | 215.91 | 118.0 |
| 2016-10-11 04:01:00 | SPY | ETF | 215.9 | 215.9 | 215.9 | 215.9 | 110.0 |
| 2016-10-11 04:04:00 | SPY | ETF | 215.9 | 215.9 | 215.9 | 215.9 | 5000.0 |
| 2016-10-11 04:05:00 | SPY | ETF | 215.9 | 215.9 | 215.9 | 215.9 | 5020.0 |
| 2016-10-11 04:08:00 | SPY | ETF | 215.9 | 215.9 | 215.9 | 215.9 | 5040.0 |
| 2016-10-11 04:09:00 | SPY | ETF | 215.85 | 215.85 | 215.85 | 215.85 | 3002.0 |
| 2016-10-11 04:11:00 | SPY | ETF | 215.82 | 215.82 | 215.8 | 215.8 | 3178.0 |
| 2016-10-11 04:15:00 | SPY | ETF | 215.78 | 215.78 | 215.78 | 215.78 | 5500.0 |
| 2016-10-11 04:16:00 | SPY | ETF | 215.77 | 215.77 | 215.77 | 215.77 | 300.0 |
| 2016-10-11 04:20:00 | SPY | ETF | 215.78 | 215.78 | 215.78 | 215.78 | 200.0 |
| 2016-10-11 04:22:00 | SPY | ETF | 215.78 | 215.78 | 215.76 | 215.76 | 602.0 |
| 2016-10-11 04:23:00 | SPY | ETF | 215.73 | 215.73 | 215.73 | 215.73 | 102.0 |
| 2016-10-11 04:31:00 | SPY | ETF | 215.78 | 215.78 | 215.78 | 215.78 | 610.0 |
| 2016-10-11 04:33:00 | SPY | ETF | 215.78 | 215.78 | 215.78 | 215.78 | 200.0 |
| 2016-10-11 04:34:00 | SPY | ETF | 215.78 | 215.78 | 215.78 | 215.78 | 200.0 |
| 2016-10-11 04:36:00 | SPY | ETF | 215.78 | 215.79 | 215.78 | 215.79 | 412.0 |
| 2016-10-11 04:38:00 | SPY | ETF | 215.81 | 215.81 | 215.81 | 215.81 | 1000.0 |
| 2016-10-11 04:39:00 | SPY | ETF | 215.77 | 215.81 | 215.77 | 215.81 | 400.0 |
| 2016-10-11 04:43:00 | SPY | ETF | 215.78 | 215.78 | 215.72 | 215.72 | 4754.0 |
| 2016-10-11 04:46:00 | SPY | ETF | 215.76 | 215.76 | 215.76 | 215.76 | 100.0 |
| 2016-10-11 04:51:00 | SPY | ETF | 215.7 | 215.76 | 215.7 | 215.76 | 1752.0 |
| 2016-10-11 04:54:00 | SPY | ETF | 215.71 | 215.71 | 215.71 | 215.71 | 301.0 |
| 2016-10-11 04:55:00 | SPY | ETF | 215.67 | 215.67 | 215.67 | 215.67 | 700.0 |
| 2016-10-11 04:58:00 | SPY | ETF | 215.63 | 215.66 | 215.59 | 215.66 | 2401.0 |
| 2016-10-11 05:00:00 | SPY | ETF | 215.6 | 215.6 | 215.6 | 215.6 | 102.0 |
| 2016-10-11 05:03:00 | SPY | ETF | 215.6 | 215.6 | 215.6 | 215.6 | 700.0 |
| 2016-10-11 05:04:00 | SPY | ETF | 215.58 | 215.58 | 215.58 | 215.58 | 200.0 |
| 2016-10-11 05:07:00 | SPY | ETF | 215.6 | 215.6 | 215.6 | 215.6 | 300.0 |
| 2016-10-11 05:09:00 | SPY | ETF | 215.6 | 215.6 | 215.59 | 215.59 | 300.0 |
| 2016-10-11 05:20:00 | SPY | ETF | 215.63 | 215.63 | 215.63 | 215.63 | 501.0 |
| 2016-10-11 05:23:00 | SPY | ETF | 215.64 | 215.64 | 215.64 | 215.64 | 502.0 |
| 2016-10-11 05:24:00 | SPY | ETF | 215.62 | 215.62 | 215.62 | 215.62 | 500.0 |
| 2016-10-11 05:29:00 | SPY | ETF | 215.69 | 215.69 | 215.69 | 215.69 | 199.0 |
| 2016-10-11 05:33:00 | SPY | ETF | 215.71 | 215.71 | 215.71 | 215.71 | 176.0 |
| 2016-10-11 05:38:00 | SPY | ETF | 215.68 | 215.68 | 215.68 | 215.68 | 200.0 |
| 2016-10-11 05:42:00 | SPY | ETF | 215.72 | 215.72 | 215.72 | 215.72 | 2000.0 |
| 2016-10-11 05:46:00 | SPY | ETF | 215.76 | 215.76 | 215.76 | 215.76 | 11100.0 |
| 2016-10-11 05:58:00 | SPY | ETF | 215.81 | 215.81 | 215.81 | 215.81 | 558.0 |
| 2016-10-11 06:06:00 | SPY | ETF | 215.75 | 215.75 | 215.73 | 215.73 | 352.0 |
| 2016-10-11 06:20:00 | SPY | ETF | 215.78 | 215.78 | 215.78 | 215.78 | 5601.0 |
| 2016-10-11 06:24:00 | SPY | ETF | 215.77 | 215.77 | 215.77 | 215.77 | 200.0 |
| 2016-10-11 06:32:00 | SPY | ETF | 215.87 | 215.9 | 215.87 | 215.9 | 800.0 |
| 2016-10-11 06:35:00 | SPY | ETF | 215.91 | 215.91 | 215.91 | 215.91 | 278.0 |
| 2016-10-11 06:39:00 | SPY | ETF | 215.91 | 215.91 | 215.91 | 215.91 | 200.0 |
| 2016-10-11 06:40:00 | SPY | ETF | 215.91 | 215.91 | 215.91 | 215.91 | 150.0 |
| 2016-10-11 06:44:00 | SPY | ETF | 215.87 | 215.87 | 215.85 | 215.85 | 7100.0 |
| 2016-10-11 06:45:00 | SPY | ETF | 215.85 | 215.85 | 215.85 | 215.85 | 200.0 |
| 2016-10-11 06:46:00 | SPY | ETF | 215.85 | 215.9 | 215.85 | 215.9 | 1601.0 |
| 2016-10-11 06:47:00 | SPY | ETF | 215.89 | 215.9 | 215.88 | 215.88 | 1799.0 |
| 2016-10-11 06:48:00 | SPY | ETF | 215.87 | 215.87 | 215.87 | 215.87 | 1301.0 |
> showing 50 of 141,263 rows — these rows as CSV