PREVIEW / etf_1min / 2016-08-04
file: by_date/etf_1min/2016/2016-08-04.parquet size: 2.4 MB rows: 126,964
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-08-04 04:01:00 | SPY | ETF | 216.03 | 216.03 | 216.03 | 216.03 | 100.0 |
| 2016-08-04 04:15:00 | SPY | ETF | 216.07 | 216.07 | 216.07 | 216.07 | 300.0 |
| 2016-08-04 04:17:00 | SPY | ETF | 216.09 | 216.1 | 216.09 | 216.1 | 4003.0 |
| 2016-08-04 04:21:00 | SPY | ETF | 216.09 | 216.09 | 216.09 | 216.09 | 2002.0 |
| 2016-08-04 04:22:00 | SPY | ETF | 216.1 | 216.1 | 216.1 | 216.1 | 205.0 |
| 2016-08-04 04:25:00 | SPY | ETF | 216.14 | 216.14 | 216.14 | 216.14 | 802.0 |
| 2016-08-04 04:28:00 | SPY | ETF | 216.14 | 216.2 | 216.14 | 216.2 | 1789.0 |
| 2016-08-04 04:34:00 | SPY | ETF | 216.19 | 216.19 | 216.19 | 216.19 | 301.0 |
| 2016-08-04 04:38:00 | SPY | ETF | 216.17 | 216.17 | 216.17 | 216.17 | 403.0 |
| 2016-08-04 04:49:00 | SPY | ETF | 216.17 | 216.17 | 216.17 | 216.17 | 500.0 |
| 2016-08-04 04:51:00 | SPY | ETF | 216.14 | 216.14 | 216.14 | 216.14 | 2202.0 |
| 2016-08-04 04:52:00 | SPY | ETF | 216.11 | 216.11 | 216.11 | 216.11 | 1200.0 |
| 2016-08-04 04:55:00 | SPY | ETF | 216.09 | 216.09 | 216.09 | 216.09 | 300.0 |
| 2016-08-04 04:56:00 | SPY | ETF | 216.08 | 216.08 | 216.08 | 216.08 | 2000.0 |
| 2016-08-04 05:13:00 | SPY | ETF | 216.03 | 216.03 | 216.03 | 216.03 | 101.0 |
| 2016-08-04 05:16:00 | SPY | ETF | 216.1 | 216.12 | 216.1 | 216.12 | 505.0 |
| 2016-08-04 05:26:00 | SPY | ETF | 216.14 | 216.14 | 216.11 | 216.11 | 452.0 |
| 2016-08-04 05:30:00 | SPY | ETF | 216.09 | 216.09 | 216.09 | 216.09 | 702.0 |
| 2016-08-04 05:34:00 | SPY | ETF | 216.12 | 216.12 | 216.12 | 216.12 | 301.0 |
| 2016-08-04 05:35:00 | SPY | ETF | 216.09 | 216.1 | 216.09 | 216.1 | 6900.0 |
| 2016-08-04 05:56:00 | SPY | ETF | 216.19 | 216.19 | 216.19 | 216.19 | 900.0 |
| 2016-08-04 06:01:00 | SPY | ETF | 216.16 | 216.16 | 216.16 | 216.16 | 100.0 |
| 2016-08-04 06:02:00 | SPY | ETF | 216.16 | 216.19 | 216.16 | 216.19 | 353.0 |
| 2016-08-04 06:04:00 | SPY | ETF | 216.19 | 216.19 | 216.19 | 216.19 | 400.0 |
| 2016-08-04 06:13:00 | SPY | ETF | 216.14 | 216.14 | 216.14 | 216.14 | 900.0 |
| 2016-08-04 06:21:00 | SPY | ETF | 216.12 | 216.12 | 216.12 | 216.12 | 300.0 |
| 2016-08-04 06:26:00 | SPY | ETF | 216.07 | 216.09 | 216.07 | 216.09 | 5600.0 |
| 2016-08-04 06:29:00 | SPY | ETF | 216.05 | 216.05 | 216.05 | 216.05 | 2501.0 |
| 2016-08-04 06:30:00 | SPY | ETF | 216.03 | 216.03 | 216.03 | 216.03 | 306.0 |
| 2016-08-04 06:33:00 | SPY | ETF | 216.04 | 216.04 | 216.04 | 216.04 | 100.0 |
| 2016-08-04 06:36:00 | SPY | ETF | 216.04 | 216.04 | 216.04 | 216.04 | 100.0 |
| 2016-08-04 06:38:00 | SPY | ETF | 216.02 | 216.05 | 216.01 | 216.01 | 500.0 |
| 2016-08-04 06:42:00 | SPY | ETF | 216.07 | 216.07 | 216.07 | 216.07 | 206.0 |
| 2016-08-04 06:48:00 | SPY | ETF | 216.14 | 216.17 | 216.14 | 216.17 | 701.0 |
| 2016-08-04 06:53:00 | SPY | ETF | 216.19 | 216.2 | 216.19 | 216.2 | 5000.0 |
| 2016-08-04 06:54:00 | SPY | ETF | 216.18 | 216.18 | 216.18 | 216.18 | 400.0 |
| 2016-08-04 06:57:00 | SPY | ETF | 216.22 | 216.22 | 216.2 | 216.2 | 700.0 |
| 2016-08-04 06:58:00 | SPY | ETF | 216.22 | 216.22 | 216.22 | 216.22 | 300.0 |
| 2016-08-04 07:00:00 | SPY | ETF | 216.22 | 216.41 | 216.22 | 216.28 | 25752.0 |
| 2016-08-04 07:01:00 | SPY | ETF | 216.32 | 216.32 | 216.22 | 216.29 | 15814.0 |
| 2016-08-04 07:02:00 | SPY | ETF | 216.3 | 216.31 | 216.29 | 216.31 | 16774.0 |
| 2016-08-04 07:03:00 | SPY | ETF | 216.29 | 216.33 | 216.29 | 216.33 | 3500.0 |
| 2016-08-04 07:04:00 | SPY | ETF | 216.34 | 216.34 | 216.34 | 216.34 | 444.0 |
| 2016-08-04 07:05:00 | SPY | ETF | 216.39 | 216.5 | 216.39 | 216.44 | 11719.0 |
| 2016-08-04 07:06:00 | SPY | ETF | 216.48 | 216.48 | 216.48 | 216.48 | 15454.0 |
| 2016-08-04 07:07:00 | SPY | ETF | 216.47 | 216.5 | 216.47 | 216.5 | 10002.0 |
| 2016-08-04 07:08:00 | SPY | ETF | 216.44 | 216.44 | 216.42 | 216.42 | 626.0 |
| 2016-08-04 07:09:00 | SPY | ETF | 216.45 | 216.5 | 216.45 | 216.5 | 26024.0 |
| 2016-08-04 07:10:00 | SPY | ETF | 216.44 | 216.44 | 216.44 | 216.44 | 20454.0 |
| 2016-08-04 07:11:00 | SPY | ETF | 216.4 | 216.4 | 216.39 | 216.39 | 4696.0 |
> showing 50 of 126,964 rows — these rows as CSV