PREVIEW / etf_1min / 2016-02-25
file: by_date/etf_1min/2016/2016-02-25.parquet size: 2.5 MB rows: 131,685
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-02-25 04:00:00 | SPY | ETF | 192.94 | 192.94 | 192.81 | 192.91 | 3540.0 |
| 2016-02-25 04:02:00 | SPY | ETF | 193.01 | 193.01 | 193.01 | 193.01 | 1000.0 |
| 2016-02-25 04:04:00 | SPY | ETF | 193.11 | 193.11 | 193.09 | 193.09 | 1060.0 |
| 2016-02-25 04:05:00 | SPY | ETF | 193.0 | 193.0 | 192.97 | 192.97 | 240.0 |
| 2016-02-25 04:06:00 | SPY | ETF | 192.95 | 192.95 | 192.95 | 192.95 | 1060.0 |
| 2016-02-25 04:07:00 | SPY | ETF | 193.0 | 193.0 | 193.0 | 193.0 | 510.0 |
| 2016-02-25 04:08:00 | SPY | ETF | 193.09 | 193.24 | 193.06 | 193.13 | 19477.0 |
| 2016-02-25 04:10:00 | SPY | ETF | 193.16 | 193.16 | 193.16 | 193.16 | 329.0 |
| 2016-02-25 04:11:00 | SPY | ETF | 193.16 | 193.16 | 193.16 | 193.16 | 603.0 |
| 2016-02-25 04:14:00 | SPY | ETF | 193.24 | 193.31 | 193.24 | 193.31 | 4258.0 |
| 2016-02-25 04:18:00 | SPY | ETF | 193.34 | 193.34 | 193.34 | 193.34 | 131.0 |
| 2016-02-25 04:19:00 | SPY | ETF | 193.31 | 193.31 | 193.31 | 193.31 | 102.0 |
| 2016-02-25 04:20:00 | SPY | ETF | 193.38 | 193.38 | 193.38 | 193.38 | 143.0 |
| 2016-02-25 04:21:00 | SPY | ETF | 193.49 | 193.49 | 193.46 | 193.46 | 890.0 |
| 2016-02-25 04:22:00 | SPY | ETF | 193.38 | 193.38 | 193.38 | 193.38 | 501.0 |
| 2016-02-25 04:28:00 | SPY | ETF | 193.47 | 193.47 | 193.47 | 193.47 | 2027.0 |
| 2016-02-25 04:29:00 | SPY | ETF | 193.42 | 193.42 | 193.42 | 193.42 | 1511.0 |
| 2016-02-25 04:30:00 | SPY | ETF | 193.48 | 193.48 | 193.48 | 193.48 | 104.0 |
| 2016-02-25 04:31:00 | SPY | ETF | 193.36 | 193.36 | 193.36 | 193.36 | 1003.0 |
| 2016-02-25 04:32:00 | SPY | ETF | 193.43 | 193.43 | 193.43 | 193.43 | 304.0 |
| 2016-02-25 04:34:00 | SPY | ETF | 193.46 | 193.46 | 193.46 | 193.46 | 1215.0 |
| 2016-02-25 04:35:00 | SPY | ETF | 193.36 | 193.36 | 193.36 | 193.36 | 155.0 |
| 2016-02-25 04:37:00 | SPY | ETF | 193.27 | 193.27 | 193.27 | 193.27 | 521.0 |
| 2016-02-25 04:39:00 | SPY | ETF | 193.28 | 193.28 | 193.28 | 193.28 | 131.0 |
| 2016-02-25 04:40:00 | SPY | ETF | 193.32 | 193.32 | 193.32 | 193.32 | 512.0 |
| 2016-02-25 04:44:00 | SPY | ETF | 193.11 | 193.11 | 193.08 | 193.08 | 674.0 |
| 2016-02-25 04:46:00 | SPY | ETF | 193.16 | 193.16 | 193.16 | 193.16 | 131.0 |
| 2016-02-25 04:50:00 | SPY | ETF | 193.4 | 193.4 | 193.4 | 193.4 | 585.0 |
| 2016-02-25 04:52:00 | SPY | ETF | 193.31 | 193.31 | 193.26 | 193.26 | 4117.0 |
| 2016-02-25 04:53:00 | SPY | ETF | 193.2 | 193.2 | 193.19 | 193.19 | 1980.0 |
| 2016-02-25 04:54:00 | SPY | ETF | 193.34 | 193.34 | 193.33 | 193.33 | 1915.0 |
| 2016-02-25 04:55:00 | SPY | ETF | 193.35 | 193.35 | 193.34 | 193.34 | 2022.0 |
| 2016-02-25 04:56:00 | SPY | ETF | 193.3 | 193.3 | 193.25 | 193.25 | 967.0 |
| 2016-02-25 04:58:00 | SPY | ETF | 193.26 | 193.26 | 193.26 | 193.26 | 101.0 |
| 2016-02-25 05:00:00 | SPY | ETF | 193.26 | 193.26 | 193.25 | 193.25 | 406.0 |
| 2016-02-25 05:02:00 | SPY | ETF | 193.25 | 193.25 | 193.25 | 193.25 | 2657.0 |
| 2016-02-25 05:03:00 | SPY | ETF | 193.21 | 193.21 | 193.05 | 193.1 | 13462.0 |
| 2016-02-25 05:04:00 | SPY | ETF | 193.03 | 193.03 | 193.03 | 193.03 | 560.0 |
| 2016-02-25 05:05:00 | SPY | ETF | 193.04 | 193.04 | 193.04 | 193.04 | 588.0 |
| 2016-02-25 05:07:00 | SPY | ETF | 193.03 | 193.03 | 193.0 | 193.01 | 787.0 |
| 2016-02-25 05:09:00 | SPY | ETF | 193.0 | 193.0 | 193.0 | 193.0 | 607.0 |
| 2016-02-25 05:10:00 | SPY | ETF | 193.09 | 193.14 | 193.09 | 193.14 | 226.0 |
| 2016-02-25 05:11:00 | SPY | ETF | 193.14 | 193.19 | 193.14 | 193.19 | 2005.0 |
| 2016-02-25 05:12:00 | SPY | ETF | 193.16 | 193.16 | 193.1 | 193.1 | 913.0 |
| 2016-02-25 05:13:00 | SPY | ETF | 193.09 | 193.11 | 193.09 | 193.11 | 387.0 |
| 2016-02-25 05:14:00 | SPY | ETF | 193.1 | 193.1 | 193.1 | 193.1 | 102.0 |
| 2016-02-25 05:16:00 | SPY | ETF | 193.12 | 193.12 | 193.03 | 193.03 | 1616.0 |
| 2016-02-25 05:17:00 | SPY | ETF | 193.05 | 193.05 | 193.05 | 193.05 | 616.0 |
| 2016-02-25 05:18:00 | SPY | ETF | 193.07 | 193.11 | 193.07 | 193.09 | 1596.0 |
| 2016-02-25 05:19:00 | SPY | ETF | 193.06 | 193.11 | 193.05 | 193.11 | 529.0 |
> showing 50 of 131,685 rows — these rows as CSV