PREVIEW / etf_1min / 2015-11-17
file: by_date/etf_1min/2015/2015-11-17.parquet size: 2.6 MB rows: 133,207
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-17 04:00:00 | SPY | ETF | 205.75 | 205.75 | 205.6 | 205.75 | 536.0 |
| 2015-11-17 04:02:00 | SPY | ETF | 205.88 | 205.88 | 205.88 | 205.88 | 300.0 |
| 2015-11-17 04:03:00 | SPY | ETF | 205.77 | 205.77 | 205.77 | 205.77 | 300.0 |
| 2015-11-17 04:04:00 | SPY | ETF | 205.88 | 205.88 | 205.88 | 205.88 | 120.0 |
| 2015-11-17 04:06:00 | SPY | ETF | 205.8 | 205.8 | 205.8 | 205.8 | 100.0 |
| 2015-11-17 04:08:00 | SPY | ETF | 205.8 | 205.8 | 205.8 | 205.8 | 100.0 |
| 2015-11-17 04:09:00 | SPY | ETF | 205.87 | 205.87 | 205.87 | 205.87 | 600.0 |
| 2015-11-17 04:24:00 | SPY | ETF | 205.98 | 206.0 | 205.98 | 206.0 | 6762.0 |
| 2015-11-17 04:30:00 | SPY | ETF | 206.07 | 206.07 | 206.07 | 206.07 | 350.0 |
| 2015-11-17 04:31:00 | SPY | ETF | 206.18 | 206.2 | 206.18 | 206.2 | 255.0 |
| 2015-11-17 04:32:00 | SPY | ETF | 206.19 | 206.19 | 206.19 | 206.19 | 205.0 |
| 2015-11-17 04:37:00 | SPY | ETF | 206.27 | 206.3 | 206.27 | 206.3 | 2488.0 |
| 2015-11-17 04:38:00 | SPY | ETF | 206.32 | 206.32 | 206.32 | 206.32 | 240.0 |
| 2015-11-17 04:39:00 | SPY | ETF | 206.28 | 206.28 | 206.28 | 206.28 | 6250.0 |
| 2015-11-17 04:40:00 | SPY | ETF | 206.29 | 206.29 | 206.29 | 206.29 | 493.0 |
| 2015-11-17 04:42:00 | SPY | ETF | 206.3 | 206.3 | 206.3 | 206.3 | 1800.0 |
| 2015-11-17 04:43:00 | SPY | ETF | 206.29 | 206.3 | 206.29 | 206.3 | 2462.0 |
| 2015-11-17 04:47:00 | SPY | ETF | 206.36 | 206.39 | 206.36 | 206.39 | 325.0 |
| 2015-11-17 04:50:00 | SPY | ETF | 206.37 | 206.37 | 206.37 | 206.37 | 1550.0 |
| 2015-11-17 04:52:00 | SPY | ETF | 206.42 | 206.42 | 206.42 | 206.42 | 160.0 |
| 2015-11-17 04:57:00 | SPY | ETF | 206.32 | 206.32 | 206.32 | 206.32 | 100.0 |
| 2015-11-17 04:59:00 | SPY | ETF | 206.27 | 206.27 | 206.27 | 206.27 | 300.0 |
| 2015-11-17 05:01:00 | SPY | ETF | 206.34 | 206.37 | 206.34 | 206.37 | 900.0 |
| 2015-11-17 05:02:00 | SPY | ETF | 206.38 | 206.38 | 206.38 | 206.38 | 125.0 |
| 2015-11-17 05:09:00 | SPY | ETF | 206.36 | 206.36 | 206.36 | 206.36 | 300.0 |
| 2015-11-17 05:13:00 | SPY | ETF | 206.23 | 206.23 | 206.23 | 206.23 | 200.0 |
| 2015-11-17 05:14:00 | SPY | ETF | 206.26 | 206.26 | 206.26 | 206.26 | 100.0 |
| 2015-11-17 05:15:00 | SPY | ETF | 206.25 | 206.25 | 206.25 | 206.25 | 1500.0 |
| 2015-11-17 05:22:00 | SPY | ETF | 206.26 | 206.26 | 206.26 | 206.26 | 100.0 |
| 2015-11-17 05:31:00 | SPY | ETF | 206.38 | 206.38 | 206.38 | 206.38 | 500.0 |
| 2015-11-17 05:34:00 | SPY | ETF | 206.27 | 206.31 | 206.27 | 206.31 | 3400.0 |
| 2015-11-17 05:35:00 | SPY | ETF | 206.28 | 206.28 | 206.28 | 206.28 | 700.0 |
| 2015-11-17 05:36:00 | SPY | ETF | 206.21 | 206.21 | 206.21 | 206.21 | 105.0 |
| 2015-11-17 05:37:00 | SPY | ETF | 206.23 | 206.23 | 206.23 | 206.23 | 155.0 |
| 2015-11-17 05:38:00 | SPY | ETF | 206.25 | 206.25 | 206.25 | 206.25 | 100.0 |
| 2015-11-17 05:39:00 | SPY | ETF | 206.19 | 206.19 | 206.19 | 206.19 | 1500.0 |
| 2015-11-17 05:41:00 | SPY | ETF | 206.25 | 206.25 | 206.25 | 206.25 | 1500.0 |
| 2015-11-17 05:42:00 | SPY | ETF | 206.26 | 206.27 | 206.26 | 206.27 | 1600.0 |
| 2015-11-17 05:44:00 | SPY | ETF | 206.38 | 206.38 | 206.38 | 206.38 | 500.0 |
| 2015-11-17 05:47:00 | SPY | ETF | 206.35 | 206.35 | 206.35 | 206.35 | 197.0 |
| 2015-11-17 05:49:00 | SPY | ETF | 206.34 | 206.38 | 206.34 | 206.38 | 342.0 |
| 2015-11-17 05:51:00 | SPY | ETF | 206.38 | 206.4 | 206.38 | 206.4 | 422.0 |
| 2015-11-17 05:52:00 | SPY | ETF | 206.42 | 206.5 | 206.42 | 206.5 | 8360.0 |
| 2015-11-17 05:53:00 | SPY | ETF | 206.54 | 206.54 | 206.51 | 206.54 | 9000.0 |
| 2015-11-17 05:54:00 | SPY | ETF | 206.5 | 206.5 | 206.5 | 206.5 | 1500.0 |
| 2015-11-17 05:55:00 | SPY | ETF | 206.48 | 206.48 | 206.48 | 206.48 | 200.0 |
| 2015-11-17 05:57:00 | SPY | ETF | 206.44 | 206.44 | 206.41 | 206.41 | 497.0 |
| 2015-11-17 06:01:00 | SPY | ETF | 206.46 | 206.5 | 206.46 | 206.5 | 2700.0 |
| 2015-11-17 06:02:00 | SPY | ETF | 206.45 | 206.48 | 206.45 | 206.48 | 7500.0 |
| 2015-11-17 06:03:00 | SPY | ETF | 206.45 | 206.45 | 206.43 | 206.44 | 2400.0 |
> showing 50 of 133,207 rows — these rows as CSV