PREVIEW / etf_1min / 2015-11-05
file: by_date/etf_1min/2015/2015-11-05.parquet size: 2.5 MB rows: 127,687
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-11-05 04:02:00 | SPY | ETF | 210.12 | 210.12 | 210.12 | 210.12 | 100.0 |
| 2015-11-05 04:09:00 | SPY | ETF | 210.2 | 210.2 | 210.2 | 210.2 | 100.0 |
| 2015-11-05 04:18:00 | SPY | ETF | 210.22 | 210.22 | 210.22 | 210.22 | 100.0 |
| 2015-11-05 04:22:00 | SPY | ETF | 210.16 | 210.16 | 210.16 | 210.16 | 100.0 |
| 2015-11-05 04:24:00 | SPY | ETF | 210.27 | 210.27 | 210.27 | 210.27 | 136.0 |
| 2015-11-05 04:25:00 | SPY | ETF | 210.29 | 210.32 | 210.29 | 210.32 | 343.0 |
| 2015-11-05 04:26:00 | SPY | ETF | 210.39 | 210.39 | 210.39 | 210.39 | 203.0 |
| 2015-11-05 04:32:00 | SPY | ETF | 210.39 | 210.39 | 210.39 | 210.39 | 123.0 |
| 2015-11-05 04:46:00 | SPY | ETF | 210.27 | 210.27 | 210.26 | 210.26 | 280.0 |
| 2015-11-05 04:48:00 | SPY | ETF | 210.22 | 210.22 | 210.22 | 210.22 | 140.0 |
| 2015-11-05 04:49:00 | SPY | ETF | 210.23 | 210.23 | 210.23 | 210.23 | 100.0 |
| 2015-11-05 04:52:00 | SPY | ETF | 210.3 | 210.3 | 210.3 | 210.3 | 240.0 |
| 2015-11-05 04:55:00 | SPY | ETF | 210.32 | 210.32 | 210.32 | 210.32 | 120.0 |
| 2015-11-05 04:59:00 | SPY | ETF | 210.29 | 210.29 | 210.29 | 210.29 | 200.0 |
| 2015-11-05 05:05:00 | SPY | ETF | 210.33 | 210.33 | 210.33 | 210.33 | 510.0 |
| 2015-11-05 05:11:00 | SPY | ETF | 210.4 | 210.41 | 210.4 | 210.41 | 200.0 |
| 2015-11-05 05:12:00 | SPY | ETF | 210.42 | 210.42 | 210.42 | 210.42 | 139.0 |
| 2015-11-05 05:20:00 | SPY | ETF | 210.46 | 210.46 | 210.46 | 210.46 | 133.0 |
| 2015-11-05 05:26:00 | SPY | ETF | 210.5 | 210.5 | 210.49 | 210.49 | 1813.0 |
| 2015-11-05 05:27:00 | SPY | ETF | 210.5 | 210.54 | 210.5 | 210.54 | 223.0 |
| 2015-11-05 05:28:00 | SPY | ETF | 210.55 | 210.55 | 210.55 | 210.55 | 1000.0 |
| 2015-11-05 05:29:00 | SPY | ETF | 210.57 | 210.57 | 210.57 | 210.57 | 1060.0 |
| 2015-11-05 05:31:00 | SPY | ETF | 210.6 | 210.6 | 210.6 | 210.6 | 117.0 |
| 2015-11-05 05:32:00 | SPY | ETF | 210.58 | 210.58 | 210.58 | 210.58 | 180.0 |
| 2015-11-05 05:33:00 | SPY | ETF | 210.6 | 210.6 | 210.6 | 210.6 | 889.0 |
| 2015-11-05 05:34:00 | SPY | ETF | 210.62 | 210.62 | 210.62 | 210.62 | 1150.0 |
| 2015-11-05 05:36:00 | SPY | ETF | 210.7 | 210.7 | 210.7 | 210.7 | 248.0 |
| 2015-11-05 05:40:00 | SPY | ETF | 210.66 | 210.66 | 210.65 | 210.65 | 700.0 |
| 2015-11-05 05:47:00 | SPY | ETF | 210.61 | 210.61 | 210.61 | 210.61 | 300.0 |
| 2015-11-05 05:52:00 | SPY | ETF | 210.52 | 210.52 | 210.52 | 210.52 | 500.0 |
| 2015-11-05 05:55:00 | SPY | ETF | 210.55 | 210.55 | 210.55 | 210.55 | 1000.0 |
| 2015-11-05 06:01:00 | SPY | ETF | 210.55 | 210.55 | 210.55 | 210.55 | 100.0 |
| 2015-11-05 06:08:00 | SPY | ETF | 210.58 | 210.58 | 210.55 | 210.55 | 800.0 |
| 2015-11-05 06:09:00 | SPY | ETF | 210.57 | 210.57 | 210.57 | 210.57 | 313.0 |
| 2015-11-05 06:11:00 | SPY | ETF | 210.57 | 210.57 | 210.57 | 210.57 | 200.0 |
| 2015-11-05 06:13:00 | SPY | ETF | 210.6 | 210.6 | 210.6 | 210.6 | 500.0 |
| 2015-11-05 06:15:00 | SPY | ETF | 210.59 | 210.6 | 210.59 | 210.6 | 1413.0 |
| 2015-11-05 06:16:00 | SPY | ETF | 210.57 | 210.58 | 210.56 | 210.56 | 4913.0 |
| 2015-11-05 06:17:00 | SPY | ETF | 210.55 | 210.55 | 210.55 | 210.55 | 2000.0 |
| 2015-11-05 06:18:00 | SPY | ETF | 210.55 | 210.58 | 210.55 | 210.58 | 400.0 |
| 2015-11-05 06:24:00 | SPY | ETF | 210.5 | 210.5 | 210.5 | 210.5 | 1500.0 |
| 2015-11-05 06:26:00 | SPY | ETF | 210.56 | 210.56 | 210.56 | 210.56 | 1000.0 |
| 2015-11-05 06:28:00 | SPY | ETF | 210.52 | 210.52 | 210.52 | 210.52 | 1000.0 |
| 2015-11-05 06:31:00 | SPY | ETF | 210.5 | 210.5 | 210.5 | 210.5 | 400.0 |
| 2015-11-05 06:32:00 | SPY | ETF | 210.55 | 210.58 | 210.55 | 210.55 | 2104.0 |
| 2015-11-05 06:33:00 | SPY | ETF | 210.6 | 210.6 | 210.6 | 210.6 | 1001.0 |
| 2015-11-05 06:35:00 | SPY | ETF | 210.62 | 210.62 | 210.62 | 210.62 | 563.0 |
| 2015-11-05 06:39:00 | SPY | ETF | 210.6 | 210.6 | 210.6 | 210.6 | 1717.0 |
| 2015-11-05 06:40:00 | SPY | ETF | 210.69 | 210.74 | 210.69 | 210.74 | 910.0 |
| 2015-11-05 06:41:00 | SPY | ETF | 210.75 | 210.75 | 210.75 | 210.75 | 241.0 |
> showing 50 of 127,687 rows — these rows as CSV