PREVIEW / etf_1min / 2015-04-23
file: by_date/etf_1min/2015/2015-04-23.parquet size: 2.4 MB rows: 126,451
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-04-23 04:00:00 | SPY | ETF | 210.35 | 210.55 | 209.6 | 209.69 | 4569.0 |
| 2015-04-23 04:01:00 | SPY | ETF | 209.69 | 209.69 | 209.69 | 209.69 | 115.0 |
| 2015-04-23 04:02:00 | SPY | ETF | 209.63 | 209.63 | 209.63 | 209.63 | 350.0 |
| 2015-04-23 04:11:00 | SPY | ETF | 209.84 | 209.84 | 209.84 | 209.84 | 100.0 |
| 2015-04-23 04:13:00 | SPY | ETF | 209.75 | 209.75 | 209.75 | 209.75 | 200.0 |
| 2015-04-23 04:14:00 | SPY | ETF | 209.6 | 209.6 | 209.6 | 209.6 | 100.0 |
| 2015-04-23 04:22:00 | SPY | ETF | 209.65 | 209.65 | 209.65 | 209.65 | 200.0 |
| 2015-04-23 04:25:00 | SPY | ETF | 209.68 | 209.68 | 209.68 | 209.68 | 15000.0 |
| 2015-04-23 04:29:00 | SPY | ETF | 209.67 | 209.67 | 209.67 | 209.67 | 400.0 |
| 2015-04-23 04:32:00 | SPY | ETF | 209.55 | 209.55 | 209.53 | 209.53 | 400.0 |
| 2015-04-23 04:33:00 | SPY | ETF | 209.5 | 209.5 | 209.5 | 209.5 | 1239.0 |
| 2015-04-23 04:34:00 | SPY | ETF | 209.46 | 209.46 | 209.46 | 209.46 | 150.0 |
| 2015-04-23 04:35:00 | SPY | ETF | 209.47 | 209.47 | 209.43 | 209.43 | 450.0 |
| 2015-04-23 04:37:00 | SPY | ETF | 209.35 | 209.36 | 209.35 | 209.36 | 270.0 |
| 2015-04-23 04:39:00 | SPY | ETF | 209.3 | 209.3 | 209.3 | 209.3 | 110.0 |
| 2015-04-23 04:41:00 | SPY | ETF | 209.32 | 209.32 | 209.32 | 209.32 | 125.0 |
| 2015-04-23 04:42:00 | SPY | ETF | 209.28 | 209.28 | 209.28 | 209.28 | 100.0 |
| 2015-04-23 04:43:00 | SPY | ETF | 209.37 | 209.37 | 209.37 | 209.37 | 110.0 |
| 2015-04-23 04:46:00 | SPY | ETF | 209.44 | 209.44 | 209.44 | 209.44 | 100.0 |
| 2015-04-23 04:51:00 | SPY | ETF | 209.5 | 209.5 | 209.5 | 209.5 | 100.0 |
| 2015-04-23 05:01:00 | SPY | ETF | 209.85 | 209.85 | 209.85 | 209.85 | 300.0 |
| 2015-04-23 05:06:00 | SPY | ETF | 209.83 | 209.83 | 209.83 | 209.83 | 23100.0 |
| 2015-04-23 05:07:00 | SPY | ETF | 209.78 | 209.78 | 209.78 | 209.78 | 10020.0 |
| 2015-04-23 05:13:00 | SPY | ETF | 209.82 | 209.82 | 209.82 | 209.82 | 100.0 |
| 2015-04-23 05:14:00 | SPY | ETF | 209.89 | 209.95 | 209.89 | 209.95 | 17000.0 |
| 2015-04-23 05:15:00 | SPY | ETF | 209.97 | 209.97 | 209.97 | 209.97 | 500.0 |
| 2015-04-23 05:17:00 | SPY | ETF | 210.12 | 210.21 | 210.12 | 210.21 | 800.0 |
| 2015-04-23 05:18:00 | SPY | ETF | 210.2 | 210.2 | 210.2 | 210.2 | 5000.0 |
| 2015-04-23 05:20:00 | SPY | ETF | 210.12 | 210.12 | 210.12 | 210.12 | 620.0 |
| 2015-04-23 05:21:00 | SPY | ETF | 210.15 | 210.16 | 210.15 | 210.16 | 2030.0 |
| 2015-04-23 05:22:00 | SPY | ETF | 210.14 | 210.14 | 210.1 | 210.1 | 1115.0 |
| 2015-04-23 05:23:00 | SPY | ETF | 210.12 | 210.12 | 210.12 | 210.12 | 120.0 |
| 2015-04-23 05:24:00 | SPY | ETF | 210.15 | 210.15 | 210.15 | 210.15 | 100.0 |
| 2015-04-23 05:30:00 | SPY | ETF | 210.08 | 210.08 | 210.08 | 210.08 | 200.0 |
| 2015-04-23 05:31:00 | SPY | ETF | 209.99 | 209.99 | 209.95 | 209.99 | 2300.0 |
| 2015-04-23 05:37:00 | SPY | ETF | 210.06 | 210.06 | 210.06 | 210.06 | 10250.0 |
| 2015-04-23 05:39:00 | SPY | ETF | 210.05 | 210.05 | 210.05 | 210.05 | 10000.0 |
| 2015-04-23 05:40:00 | SPY | ETF | 210.14 | 210.14 | 210.14 | 210.14 | 1020.0 |
| 2015-04-23 05:41:00 | SPY | ETF | 210.29 | 210.31 | 210.29 | 210.31 | 500.0 |
| 2015-04-23 05:43:00 | SPY | ETF | 210.21 | 210.24 | 210.21 | 210.24 | 1900.0 |
| 2015-04-23 05:49:00 | SPY | ETF | 210.16 | 210.16 | 210.16 | 210.16 | 700.0 |
| 2015-04-23 05:55:00 | SPY | ETF | 210.22 | 210.22 | 210.22 | 210.22 | 100.0 |
| 2015-04-23 05:57:00 | SPY | ETF | 210.17 | 210.17 | 210.17 | 210.17 | 500.0 |
| 2015-04-23 06:02:00 | SPY | ETF | 210.06 | 210.06 | 210.06 | 210.06 | 420.0 |
| 2015-04-23 06:03:00 | SPY | ETF | 210.07 | 210.07 | 210.07 | 210.07 | 150.0 |
| 2015-04-23 06:07:00 | SPY | ETF | 210.14 | 210.14 | 210.14 | 210.14 | 1500.0 |
| 2015-04-23 06:18:00 | SPY | ETF | 210.02 | 210.02 | 209.99 | 209.99 | 1600.0 |
| 2015-04-23 06:19:00 | SPY | ETF | 209.95 | 209.95 | 209.95 | 209.95 | 200.0 |
| 2015-04-23 06:20:00 | SPY | ETF | 209.99 | 209.99 | 209.99 | 209.99 | 2500.0 |
| 2015-04-23 06:21:00 | SPY | ETF | 209.97 | 209.97 | 209.97 | 209.97 | 2312.0 |
> showing 50 of 126,451 rows — these rows as CSV