PREVIEW / etf_1min / 2015-05-04
file: by_date/etf_1min/2015/2015-05-04.parquet size: 2.5 MB rows: 130,724
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-05-04 04:21:00 | SPY | ETF | 210.75 | 210.75 | 210.75 | 210.75 | 235.0 |
| 2015-05-04 04:29:00 | SPY | ETF | 210.92 | 210.92 | 210.92 | 210.92 | 100.0 |
| 2015-05-04 04:32:00 | SPY | ETF | 210.99 | 210.99 | 210.99 | 210.99 | 285.0 |
| 2015-05-04 04:35:00 | SPY | ETF | 211.15 | 211.15 | 211.15 | 211.15 | 140.0 |
| 2015-05-04 04:56:00 | SPY | ETF | 211.12 | 211.12 | 211.12 | 211.12 | 300.0 |
| 2015-05-04 04:59:00 | SPY | ETF | 211.12 | 211.12 | 211.12 | 211.12 | 5950.0 |
| 2015-05-04 05:11:00 | SPY | ETF | 211.14 | 211.14 | 211.14 | 211.14 | 400.0 |
| 2015-05-04 05:12:00 | SPY | ETF | 211.15 | 211.2 | 211.15 | 211.2 | 1200.0 |
| 2015-05-04 05:42:00 | SPY | ETF | 211.1 | 211.1 | 211.1 | 211.1 | 100.0 |
| 2015-05-04 05:44:00 | SPY | ETF | 211.11 | 211.11 | 211.11 | 211.11 | 100.0 |
| 2015-05-04 05:45:00 | SPY | ETF | 211.1 | 211.1 | 211.1 | 211.1 | 100.0 |
| 2015-05-04 05:47:00 | SPY | ETF | 211.08 | 211.08 | 211.08 | 211.08 | 2060.0 |
| 2015-05-04 05:48:00 | SPY | ETF | 211.1 | 211.1 | 211.1 | 211.1 | 100.0 |
| 2015-05-04 05:49:00 | SPY | ETF | 211.01 | 211.01 | 211.01 | 211.01 | 4400.0 |
| 2015-05-04 05:51:00 | SPY | ETF | 211.01 | 211.01 | 211.01 | 211.01 | 1000.0 |
| 2015-05-04 05:52:00 | SPY | ETF | 211.0 | 211.0 | 211.0 | 211.0 | 500.0 |
| 2015-05-04 05:53:00 | SPY | ETF | 211.08 | 211.08 | 211.08 | 211.08 | 3900.0 |
| 2015-05-04 05:54:00 | SPY | ETF | 211.08 | 211.08 | 211.08 | 211.08 | 6100.0 |
| 2015-05-04 06:00:00 | SPY | ETF | 211.08 | 211.08 | 211.08 | 211.08 | 100.0 |
| 2015-05-04 06:05:00 | SPY | ETF | 211.0 | 211.0 | 211.0 | 211.0 | 100.0 |
| 2015-05-04 06:08:00 | SPY | ETF | 211.03 | 211.03 | 211.03 | 211.03 | 1000.0 |
| 2015-05-04 06:09:00 | SPY | ETF | 211.02 | 211.02 | 211.02 | 211.02 | 100.0 |
| 2015-05-04 06:11:00 | SPY | ETF | 211.03 | 211.03 | 211.03 | 211.03 | 400.0 |
| 2015-05-04 06:16:00 | SPY | ETF | 211.0 | 211.0 | 211.0 | 211.0 | 200.0 |
| 2015-05-04 06:21:00 | SPY | ETF | 210.98 | 210.98 | 210.98 | 210.98 | 4675.0 |
| 2015-05-04 06:22:00 | SPY | ETF | 210.98 | 210.98 | 210.98 | 210.98 | 325.0 |
| 2015-05-04 06:38:00 | SPY | ETF | 211.05 | 211.05 | 211.05 | 211.05 | 100.0 |
| 2015-05-04 06:39:00 | SPY | ETF | 211.04 | 211.04 | 211.04 | 211.04 | 500.0 |
| 2015-05-04 06:44:00 | SPY | ETF | 211.14 | 211.14 | 211.14 | 211.14 | 4220.0 |
| 2015-05-04 06:45:00 | SPY | ETF | 211.15 | 211.15 | 211.14 | 211.15 | 12450.0 |
| 2015-05-04 06:46:00 | SPY | ETF | 211.18 | 211.18 | 211.17 | 211.17 | 10000.0 |
| 2015-05-04 06:48:00 | SPY | ETF | 211.18 | 211.18 | 211.18 | 211.18 | 1250.0 |
| 2015-05-04 06:49:00 | SPY | ETF | 211.22 | 211.25 | 211.19 | 211.25 | 10200.0 |
| 2015-05-04 06:50:00 | SPY | ETF | 211.2 | 211.2 | 211.2 | 211.2 | 5000.0 |
| 2015-05-04 06:51:00 | SPY | ETF | 211.22 | 211.22 | 211.22 | 211.22 | 150.0 |
| 2015-05-04 06:53:00 | SPY | ETF | 211.2 | 211.2 | 211.2 | 211.2 | 150.0 |
| 2015-05-04 06:54:00 | SPY | ETF | 211.19 | 211.19 | 211.19 | 211.19 | 100.0 |
| 2015-05-04 07:00:00 | SPY | ETF | 211.19 | 211.19 | 211.18 | 211.19 | 2400.0 |
| 2015-05-04 07:01:00 | SPY | ETF | 211.19 | 211.19 | 211.19 | 211.19 | 5500.0 |
| 2015-05-04 07:03:00 | SPY | ETF | 211.19 | 211.19 | 211.19 | 211.19 | 100.0 |
| 2015-05-04 07:05:00 | SPY | ETF | 211.19 | 211.21 | 211.19 | 211.21 | 270.0 |
| 2015-05-04 07:06:00 | SPY | ETF | 211.2 | 211.2 | 211.2 | 211.2 | 7102.0 |
| 2015-05-04 07:08:00 | SPY | ETF | 211.2 | 211.2 | 211.2 | 211.2 | 2988.0 |
| 2015-05-04 07:10:00 | SPY | ETF | 211.23 | 211.25 | 211.23 | 211.23 | 13400.0 |
| 2015-05-04 07:11:00 | SPY | ETF | 211.24 | 211.28 | 211.24 | 211.28 | 9120.0 |
| 2015-05-04 07:12:00 | SPY | ETF | 211.28 | 211.31 | 211.28 | 211.29 | 32500.0 |
| 2015-05-04 07:13:00 | SPY | ETF | 211.26 | 211.3 | 211.25 | 211.3 | 4700.0 |
| 2015-05-04 07:15:00 | SPY | ETF | 211.26 | 211.28 | 211.26 | 211.26 | 3770.0 |
| 2015-05-04 07:16:00 | SPY | ETF | 211.24 | 211.26 | 211.24 | 211.26 | 2900.0 |
| 2015-05-04 07:17:00 | SPY | ETF | 211.24 | 211.24 | 211.23 | 211.23 | 800.0 |
> showing 50 of 130,724 rows — these rows as CSV