PREVIEW / etf_1min / 2015-06-10
file: by_date/etf_1min/2015/2015-06-10.parquet size: 2.5 MB rows: 130,486
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-06-10 04:00:00 | SPY | ETF | 208.98 | 209.11 | 208.98 | 209.11 | 400.0 |
| 2015-06-10 04:14:00 | SPY | ETF | 209.0 | 209.0 | 209.0 | 209.0 | 500.0 |
| 2015-06-10 04:20:00 | SPY | ETF | 209.13 | 209.13 | 209.13 | 209.13 | 350.0 |
| 2015-06-10 04:21:00 | SPY | ETF | 209.18 | 209.18 | 209.18 | 209.18 | 100.0 |
| 2015-06-10 04:22:00 | SPY | ETF | 209.15 | 209.15 | 209.15 | 209.15 | 860.0 |
| 2015-06-10 04:25:00 | SPY | ETF | 209.08 | 209.08 | 209.07 | 209.07 | 500.0 |
| 2015-06-10 04:27:00 | SPY | ETF | 209.08 | 209.08 | 209.08 | 209.08 | 900.0 |
| 2015-06-10 04:29:00 | SPY | ETF | 209.2 | 209.2 | 209.2 | 209.2 | 800.0 |
| 2015-06-10 04:34:00 | SPY | ETF | 209.09 | 209.11 | 209.04 | 209.04 | 61300.0 |
| 2015-06-10 04:36:00 | SPY | ETF | 209.01 | 209.01 | 208.98 | 208.98 | 36950.0 |
| 2015-06-10 04:40:00 | SPY | ETF | 209.03 | 209.03 | 209.01 | 209.01 | 306.0 |
| 2015-06-10 04:42:00 | SPY | ETF | 209.07 | 209.07 | 209.07 | 209.07 | 300.0 |
| 2015-06-10 04:46:00 | SPY | ETF | 209.1 | 209.1 | 209.1 | 209.1 | 100.0 |
| 2015-06-10 04:54:00 | SPY | ETF | 209.22 | 209.22 | 209.22 | 209.22 | 400.0 |
| 2015-06-10 04:55:00 | SPY | ETF | 209.22 | 209.22 | 209.22 | 209.22 | 300.0 |
| 2015-06-10 05:01:00 | SPY | ETF | 209.12 | 209.12 | 209.12 | 209.12 | 900.0 |
| 2015-06-10 05:05:00 | SPY | ETF | 209.1 | 209.1 | 209.1 | 209.1 | 700.0 |
| 2015-06-10 05:08:00 | SPY | ETF | 209.13 | 209.15 | 209.13 | 209.15 | 1605.0 |
| 2015-06-10 05:09:00 | SPY | ETF | 209.15 | 209.15 | 209.15 | 209.15 | 700.0 |
| 2015-06-10 05:19:00 | SPY | ETF | 209.16 | 209.16 | 209.16 | 209.16 | 300.0 |
| 2015-06-10 05:21:00 | SPY | ETF | 209.22 | 209.27 | 209.22 | 209.27 | 9800.0 |
| 2015-06-10 05:22:00 | SPY | ETF | 209.17 | 209.17 | 209.17 | 209.17 | 234.0 |
| 2015-06-10 05:24:00 | SPY | ETF | 209.22 | 209.27 | 209.22 | 209.27 | 4456.0 |
| 2015-06-10 05:32:00 | SPY | ETF | 209.29 | 209.35 | 209.29 | 209.35 | 1896.0 |
| 2015-06-10 05:33:00 | SPY | ETF | 209.37 | 209.37 | 209.31 | 209.31 | 3800.0 |
| 2015-06-10 05:34:00 | SPY | ETF | 209.29 | 209.29 | 209.23 | 209.23 | 11800.0 |
| 2015-06-10 05:35:00 | SPY | ETF | 209.25 | 209.25 | 209.25 | 209.25 | 400.0 |
| 2015-06-10 05:38:00 | SPY | ETF | 209.28 | 209.28 | 209.26 | 209.26 | 600.0 |
| 2015-06-10 05:42:00 | SPY | ETF | 209.28 | 209.28 | 209.28 | 209.28 | 3700.0 |
| 2015-06-10 05:44:00 | SPY | ETF | 209.33 | 209.35 | 209.33 | 209.35 | 640.0 |
| 2015-06-10 05:47:00 | SPY | ETF | 209.44 | 209.46 | 209.38 | 209.38 | 13615.0 |
| 2015-06-10 05:50:00 | SPY | ETF | 209.46 | 209.55 | 209.46 | 209.48 | 2920.0 |
| 2015-06-10 05:51:00 | SPY | ETF | 209.5 | 209.5 | 209.46 | 209.46 | 540.0 |
| 2015-06-10 05:52:00 | SPY | ETF | 209.51 | 209.51 | 209.5 | 209.5 | 833.0 |
| 2015-06-10 05:54:00 | SPY | ETF | 209.5 | 209.5 | 209.48 | 209.48 | 900.0 |
| 2015-06-10 05:55:00 | SPY | ETF | 209.5 | 209.55 | 209.5 | 209.55 | 700.0 |
| 2015-06-10 05:56:00 | SPY | ETF | 209.51 | 209.52 | 209.51 | 209.52 | 4450.0 |
| 2015-06-10 05:57:00 | SPY | ETF | 209.48 | 209.5 | 209.48 | 209.5 | 1650.0 |
| 2015-06-10 06:00:00 | SPY | ETF | 209.45 | 209.45 | 209.45 | 209.45 | 250.0 |
| 2015-06-10 06:01:00 | SPY | ETF | 209.45 | 209.45 | 209.41 | 209.41 | 1375.0 |
| 2015-06-10 06:02:00 | SPY | ETF | 209.42 | 209.42 | 209.42 | 209.42 | 200.0 |
| 2015-06-10 06:03:00 | SPY | ETF | 209.41 | 209.41 | 209.41 | 209.41 | 270.0 |
| 2015-06-10 06:05:00 | SPY | ETF | 209.41 | 209.41 | 209.41 | 209.41 | 102.0 |
| 2015-06-10 06:06:00 | SPY | ETF | 209.45 | 209.45 | 209.45 | 209.45 | 100.0 |
| 2015-06-10 06:07:00 | SPY | ETF | 209.46 | 209.46 | 209.46 | 209.46 | 2002.0 |
| 2015-06-10 06:09:00 | SPY | ETF | 209.5 | 209.5 | 209.5 | 209.5 | 274.0 |
| 2015-06-10 06:10:00 | SPY | ETF | 209.54 | 209.54 | 209.54 | 209.54 | 140.0 |
| 2015-06-10 06:12:00 | SPY | ETF | 209.55 | 209.55 | 209.55 | 209.55 | 100.0 |
| 2015-06-10 06:13:00 | SPY | ETF | 209.45 | 209.45 | 209.45 | 209.45 | 100.0 |
| 2015-06-10 06:14:00 | SPY | ETF | 209.43 | 209.45 | 209.43 | 209.45 | 1300.0 |
> showing 50 of 130,486 rows — these rows as CSV