PREVIEW / etf_1min / 2015-09-14
file: by_date/etf_1min/2015/2015-09-14.parquet size: 2.2 MB rows: 118,309
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-09-14 04:00:00 | SPY | ETF | 197.28 | 197.28 | 197.28 | 197.28 | 205.0 |
| 2015-09-14 04:01:00 | SPY | ETF | 197.28 | 197.28 | 197.28 | 197.28 | 105.0 |
| 2015-09-14 04:02:00 | SPY | ETF | 197.32 | 197.32 | 197.32 | 197.32 | 105.0 |
| 2015-09-14 04:07:00 | SPY | ETF | 197.25 | 197.25 | 197.1 | 197.1 | 400.0 |
| 2015-09-14 04:08:00 | SPY | ETF | 197.03 | 197.04 | 197.02 | 197.04 | 900.0 |
| 2015-09-14 04:09:00 | SPY | ETF | 197.01 | 197.01 | 196.99 | 196.99 | 405.0 |
| 2015-09-14 04:14:00 | SPY | ETF | 197.11 | 197.11 | 197.11 | 197.11 | 200.0 |
| 2015-09-14 04:19:00 | SPY | ETF | 197.25 | 197.25 | 197.25 | 197.25 | 100.0 |
| 2015-09-14 04:21:00 | SPY | ETF | 197.03 | 197.03 | 197.03 | 197.03 | 505.0 |
| 2015-09-14 04:26:00 | SPY | ETF | 197.1 | 197.1 | 197.1 | 197.1 | 267.0 |
| 2015-09-14 04:40:00 | SPY | ETF | 196.95 | 196.95 | 196.83 | 196.83 | 1111.0 |
| 2015-09-14 04:42:00 | SPY | ETF | 196.8 | 196.8 | 196.8 | 196.8 | 405.0 |
| 2015-09-14 04:49:00 | SPY | ETF | 196.95 | 196.95 | 196.95 | 196.95 | 400.0 |
| 2015-09-14 05:04:00 | SPY | ETF | 197.17 | 197.17 | 197.17 | 197.17 | 6250.0 |
| 2015-09-14 05:08:00 | SPY | ETF | 197.15 | 197.15 | 197.15 | 197.15 | 200.0 |
| 2015-09-14 05:10:00 | SPY | ETF | 197.11 | 197.11 | 197.11 | 197.11 | 400.0 |
| 2015-09-14 05:15:00 | SPY | ETF | 197.33 | 197.33 | 197.33 | 197.33 | 205.0 |
| 2015-09-14 05:16:00 | SPY | ETF | 197.34 | 197.34 | 197.34 | 197.34 | 1005.0 |
| 2015-09-14 05:25:00 | SPY | ETF | 197.21 | 197.21 | 197.21 | 197.21 | 192.0 |
| 2015-09-14 05:26:00 | SPY | ETF | 197.17 | 197.17 | 197.17 | 197.17 | 1000.0 |
| 2015-09-14 05:27:00 | SPY | ETF | 197.17 | 197.17 | 197.17 | 197.17 | 500.0 |
| 2015-09-14 05:34:00 | SPY | ETF | 197.22 | 197.22 | 197.22 | 197.22 | 514.0 |
| 2015-09-14 05:35:00 | SPY | ETF | 197.24 | 197.24 | 197.24 | 197.24 | 200.0 |
| 2015-09-14 05:37:00 | SPY | ETF | 197.24 | 197.24 | 197.24 | 197.24 | 100.0 |
| 2015-09-14 05:41:00 | SPY | ETF | 197.24 | 197.24 | 197.24 | 197.24 | 600.0 |
| 2015-09-14 05:43:00 | SPY | ETF | 197.17 | 197.17 | 197.17 | 197.17 | 600.0 |
| 2015-09-14 05:48:00 | SPY | ETF | 197.08 | 197.08 | 197.08 | 197.08 | 180.0 |
| 2015-09-14 05:58:00 | SPY | ETF | 197.24 | 197.24 | 197.24 | 197.24 | 1000.0 |
| 2015-09-14 06:04:00 | SPY | ETF | 197.27 | 197.27 | 197.24 | 197.24 | 1600.0 |
| 2015-09-14 06:07:00 | SPY | ETF | 197.39 | 197.53 | 197.28 | 197.53 | 10265.0 |
| 2015-09-14 06:08:00 | SPY | ETF | 197.53 | 197.6 | 197.49 | 197.6 | 9560.0 |
| 2015-09-14 06:12:00 | SPY | ETF | 197.62 | 197.62 | 197.62 | 197.62 | 505.0 |
| 2015-09-14 06:14:00 | SPY | ETF | 197.57 | 197.57 | 197.57 | 197.57 | 510.0 |
| 2015-09-14 06:16:00 | SPY | ETF | 197.49 | 197.49 | 197.37 | 197.4 | 5100.0 |
| 2015-09-14 06:18:00 | SPY | ETF | 197.41 | 197.41 | 197.41 | 197.41 | 110.0 |
| 2015-09-14 06:21:00 | SPY | ETF | 197.4 | 197.4 | 197.4 | 197.4 | 100.0 |
| 2015-09-14 06:22:00 | SPY | ETF | 197.32 | 197.37 | 197.32 | 197.33 | 600.0 |
| 2015-09-14 06:23:00 | SPY | ETF | 197.28 | 197.34 | 197.28 | 197.34 | 500.0 |
| 2015-09-14 06:25:00 | SPY | ETF | 197.39 | 197.39 | 197.39 | 197.39 | 100.0 |
| 2015-09-14 06:28:00 | SPY | ETF | 197.37 | 197.37 | 197.37 | 197.37 | 100.0 |
| 2015-09-14 06:30:00 | SPY | ETF | 197.39 | 197.47 | 197.39 | 197.47 | 805.0 |
| 2015-09-14 06:31:00 | SPY | ETF | 197.46 | 197.46 | 197.46 | 197.46 | 134.0 |
| 2015-09-14 06:35:00 | SPY | ETF | 197.44 | 197.46 | 197.44 | 197.46 | 2900.0 |
| 2015-09-14 06:36:00 | SPY | ETF | 197.43 | 197.46 | 197.41 | 197.43 | 7483.0 |
| 2015-09-14 06:38:00 | SPY | ETF | 197.34 | 197.34 | 197.34 | 197.34 | 100.0 |
| 2015-09-14 06:42:00 | SPY | ETF | 197.36 | 197.36 | 197.36 | 197.36 | 300.0 |
| 2015-09-14 06:44:00 | SPY | ETF | 197.37 | 197.37 | 197.37 | 197.37 | 100.0 |
| 2015-09-14 06:45:00 | SPY | ETF | 197.39 | 197.39 | 197.39 | 197.39 | 1500.0 |
| 2015-09-14 06:47:00 | SPY | ETF | 197.3 | 197.3 | 197.26 | 197.26 | 2905.0 |
| 2015-09-14 06:48:00 | SPY | ETF | 197.23 | 197.26 | 197.23 | 197.26 | 205.0 |
> showing 50 of 118,309 rows — these rows as CSV