PREVIEW / etf_1min / 2016-10-17
file: by_date/etf_1min/2016/2016-10-17.parquet size: 2.4 MB rows: 128,610
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-17 04:00:00 | SPY | ETF | 212.75 | 212.75 | 212.64 | 212.64 | 603.0 |
| 2016-10-17 04:02:00 | SPY | ETF | 212.68 | 212.68 | 212.68 | 212.68 | 100.0 |
| 2016-10-17 04:03:00 | SPY | ETF | 212.66 | 212.66 | 212.66 | 212.66 | 200.0 |
| 2016-10-17 04:04:00 | SPY | ETF | 212.63 | 212.63 | 212.63 | 212.63 | 130.0 |
| 2016-10-17 04:05:00 | SPY | ETF | 212.54 | 212.54 | 212.54 | 212.54 | 218.0 |
| 2016-10-17 04:11:00 | SPY | ETF | 212.49 | 212.49 | 212.49 | 212.49 | 603.0 |
| 2016-10-17 04:12:00 | SPY | ETF | 212.46 | 212.46 | 212.46 | 212.46 | 103.0 |
| 2016-10-17 04:15:00 | SPY | ETF | 212.44 | 212.44 | 212.44 | 212.44 | 250.0 |
| 2016-10-17 04:22:00 | SPY | ETF | 212.46 | 212.46 | 212.46 | 212.46 | 100.0 |
| 2016-10-17 04:40:00 | SPY | ETF | 212.59 | 212.59 | 212.59 | 212.59 | 500.0 |
| 2016-10-17 05:08:00 | SPY | ETF | 212.5 | 212.5 | 212.5 | 212.5 | 300.0 |
| 2016-10-17 05:20:00 | SPY | ETF | 212.23 | 212.23 | 212.23 | 212.23 | 150.0 |
| 2016-10-17 05:36:00 | SPY | ETF | 212.35 | 212.35 | 212.35 | 212.35 | 1000.0 |
| 2016-10-17 05:38:00 | SPY | ETF | 212.42 | 212.42 | 212.42 | 212.42 | 223.0 |
| 2016-10-17 05:39:00 | SPY | ETF | 212.35 | 212.35 | 212.35 | 212.35 | 250.0 |
| 2016-10-17 05:40:00 | SPY | ETF | 212.35 | 212.35 | 212.35 | 212.35 | 803.0 |
| 2016-10-17 05:50:00 | SPY | ETF | 212.35 | 212.35 | 212.35 | 212.35 | 550.0 |
| 2016-10-17 05:51:00 | SPY | ETF | 212.35 | 212.35 | 212.35 | 212.35 | 500.0 |
| 2016-10-17 06:00:00 | SPY | ETF | 212.4 | 212.4 | 212.4 | 212.4 | 203.0 |
| 2016-10-17 06:07:00 | SPY | ETF | 212.4 | 212.4 | 212.4 | 212.4 | 253.0 |
| 2016-10-17 06:22:00 | SPY | ETF | 212.4 | 212.4 | 212.4 | 212.4 | 303.0 |
| 2016-10-17 06:23:00 | SPY | ETF | 212.4 | 212.4 | 212.4 | 212.4 | 101.0 |
| 2016-10-17 06:35:00 | SPY | ETF | 212.65 | 212.65 | 212.65 | 212.65 | 1000.0 |
| 2016-10-17 06:47:00 | SPY | ETF | 212.57 | 212.57 | 212.55 | 212.57 | 801.0 |
| 2016-10-17 06:56:00 | SPY | ETF | 212.57 | 212.57 | 212.57 | 212.57 | 303.0 |
| 2016-10-17 07:05:00 | SPY | ETF | 212.68 | 212.7 | 212.68 | 212.7 | 981.0 |
| 2016-10-17 07:08:00 | SPY | ETF | 212.64 | 212.65 | 212.6 | 212.6 | 1519.0 |
| 2016-10-17 07:09:00 | SPY | ETF | 212.6 | 212.6 | 212.6 | 212.6 | 500.0 |
| 2016-10-17 07:13:00 | SPY | ETF | 212.58 | 212.58 | 212.56 | 212.56 | 12503.0 |
| 2016-10-17 07:15:00 | SPY | ETF | 212.7 | 212.7 | 212.7 | 212.7 | 713.0 |
| 2016-10-17 07:17:00 | SPY | ETF | 212.75 | 212.75 | 212.75 | 212.75 | 500.0 |
| 2016-10-17 07:19:00 | SPY | ETF | 212.77 | 212.84 | 212.77 | 212.84 | 559.0 |
| 2016-10-17 07:20:00 | SPY | ETF | 212.79 | 212.79 | 212.79 | 212.79 | 12550.0 |
| 2016-10-17 07:21:00 | SPY | ETF | 212.79 | 212.79 | 212.79 | 212.79 | 11001.0 |
| 2016-10-17 07:22:00 | SPY | ETF | 212.82 | 212.82 | 212.82 | 212.82 | 400.0 |
| 2016-10-17 07:23:00 | SPY | ETF | 212.85 | 212.94 | 212.85 | 212.94 | 42945.0 |
| 2016-10-17 07:24:00 | SPY | ETF | 212.92 | 212.92 | 212.92 | 212.92 | 1012.0 |
| 2016-10-17 07:25:00 | SPY | ETF | 212.92 | 212.92 | 212.91 | 212.91 | 1035.0 |
| 2016-10-17 07:30:00 | SPY | ETF | 212.9 | 212.9 | 212.9 | 212.9 | 190.0 |
| 2016-10-17 07:31:00 | SPY | ETF | 212.98 | 212.98 | 212.92 | 212.92 | 15244.0 |
| 2016-10-17 07:34:00 | SPY | ETF | 212.9 | 212.92 | 212.9 | 212.92 | 894.0 |
| 2016-10-17 07:35:00 | SPY | ETF | 212.9 | 212.9 | 212.89 | 212.89 | 7400.0 |
| 2016-10-17 07:36:00 | SPY | ETF | 212.87 | 212.87 | 212.87 | 212.87 | 200.0 |
| 2016-10-17 07:38:00 | SPY | ETF | 212.84 | 212.84 | 212.84 | 212.84 | 504.0 |
| 2016-10-17 07:39:00 | SPY | ETF | 212.84 | 212.84 | 212.84 | 212.84 | 7516.0 |
| 2016-10-17 07:40:00 | SPY | ETF | 212.84 | 212.84 | 212.84 | 212.84 | 103.0 |
| 2016-10-17 07:41:00 | SPY | ETF | 212.8 | 212.8 | 212.8 | 212.8 | 4100.0 |
| 2016-10-17 07:42:00 | SPY | ETF | 212.8 | 212.8 | 212.8 | 212.8 | 600.0 |
| 2016-10-17 07:43:00 | SPY | ETF | 212.82 | 212.82 | 212.82 | 212.82 | 2500.0 |
| 2016-10-17 07:44:00 | SPY | ETF | 212.82 | 212.82 | 212.8 | 212.81 | 1500.0 |
> showing 50 of 128,610 rows — these rows as CSV