PREVIEW / etf_1min / 2019-01-30
file: by_date/etf_1min/2019/2019-01-30.parquet size: 3.5 MB rows: 178,817
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 |
|---|---|---|---|---|---|---|---|
| 2019-01-30 04:00:00 | SPY | ETF | 264.4 | 264.41 | 264.11 | 264.11 | 1065.0 |
| 2019-01-30 04:03:00 | SPY | ETF | 264.04 | 264.07 | 264.04 | 264.06 | 1300.0 |
| 2019-01-30 04:05:00 | SPY | ETF | 264.05 | 264.05 | 264.05 | 264.05 | 262.0 |
| 2019-01-30 04:07:00 | SPY | ETF | 264.13 | 264.13 | 264.13 | 264.13 | 1000.0 |
| 2019-01-30 04:08:00 | SPY | ETF | 264.05 | 264.05 | 264.05 | 264.05 | 400.0 |
| 2019-01-30 04:09:00 | SPY | ETF | 263.97 | 263.97 | 263.97 | 263.97 | 1100.0 |
| 2019-01-30 04:10:00 | SPY | ETF | 264.05 | 264.05 | 264.05 | 264.05 | 300.0 |
| 2019-01-30 04:12:00 | SPY | ETF | 264.05 | 264.05 | 264.05 | 264.05 | 300.0 |
| 2019-01-30 04:13:00 | SPY | ETF | 264.02 | 264.02 | 264.02 | 264.02 | 300.0 |
| 2019-01-30 04:15:00 | SPY | ETF | 264.08 | 264.1 | 264.08 | 264.1 | 5000.0 |
| 2019-01-30 04:17:00 | SPY | ETF | 264.08 | 264.08 | 264.08 | 264.08 | 900.0 |
| 2019-01-30 04:18:00 | SPY | ETF | 264.09 | 264.09 | 264.09 | 264.09 | 850.0 |
| 2019-01-30 04:19:00 | SPY | ETF | 264.09 | 264.12 | 264.09 | 264.12 | 400.0 |
| 2019-01-30 04:20:00 | SPY | ETF | 264.14 | 264.14 | 264.14 | 264.14 | 300.0 |
| 2019-01-30 04:24:00 | SPY | ETF | 264.14 | 264.14 | 264.14 | 264.14 | 310.0 |
| 2019-01-30 04:26:00 | SPY | ETF | 264.17 | 264.17 | 264.17 | 264.17 | 100.0 |
| 2019-01-30 04:29:00 | SPY | ETF | 264.22 | 264.22 | 264.22 | 264.22 | 1300.0 |
| 2019-01-30 04:30:00 | SPY | ETF | 264.23 | 264.24 | 264.19 | 264.24 | 1400.0 |
| 2019-01-30 04:31:00 | SPY | ETF | 264.26 | 264.26 | 264.26 | 264.26 | 700.0 |
| 2019-01-30 04:32:00 | SPY | ETF | 264.26 | 264.26 | 264.26 | 264.26 | 3150.0 |
| 2019-01-30 04:34:00 | SPY | ETF | 264.26 | 264.26 | 264.26 | 264.26 | 100.0 |
| 2019-01-30 04:35:00 | SPY | ETF | 264.25 | 264.25 | 264.25 | 264.25 | 300.0 |
| 2019-01-30 04:37:00 | SPY | ETF | 264.28 | 264.28 | 264.28 | 264.28 | 100.0 |
| 2019-01-30 04:38:00 | SPY | ETF | 264.25 | 264.25 | 264.25 | 264.25 | 300.0 |
| 2019-01-30 04:40:00 | SPY | ETF | 264.23 | 264.23 | 264.23 | 264.23 | 300.0 |
| 2019-01-30 04:43:00 | SPY | ETF | 264.33 | 264.33 | 264.33 | 264.33 | 400.0 |
| 2019-01-30 04:44:00 | SPY | ETF | 264.35 | 264.35 | 264.35 | 264.35 | 1000.0 |
| 2019-01-30 04:45:00 | SPY | ETF | 264.35 | 264.35 | 264.35 | 264.35 | 500.0 |
| 2019-01-30 04:46:00 | SPY | ETF | 264.39 | 264.39 | 264.39 | 264.39 | 580.0 |
| 2019-01-30 04:48:00 | SPY | ETF | 264.3 | 264.3 | 264.3 | 264.3 | 300.0 |
| 2019-01-30 04:52:00 | SPY | ETF | 264.22 | 264.22 | 264.2 | 264.2 | 520.0 |
| 2019-01-30 04:55:00 | SPY | ETF | 264.27 | 264.27 | 264.27 | 264.27 | 100.0 |
| 2019-01-30 04:57:00 | SPY | ETF | 264.27 | 264.29 | 264.27 | 264.29 | 500.0 |
| 2019-01-30 04:58:00 | SPY | ETF | 264.22 | 264.22 | 264.22 | 264.22 | 400.0 |
| 2019-01-30 05:01:00 | SPY | ETF | 264.3 | 264.3 | 264.3 | 264.3 | 355.0 |
| 2019-01-30 05:02:00 | SPY | ETF | 264.3 | 264.3 | 264.3 | 264.3 | 300.0 |
| 2019-01-30 05:03:00 | SPY | ETF | 264.28 | 264.28 | 264.28 | 264.28 | 300.0 |
| 2019-01-30 05:04:00 | SPY | ETF | 264.35 | 264.35 | 264.35 | 264.35 | 300.0 |
| 2019-01-30 05:05:00 | SPY | ETF | 264.3 | 264.3 | 264.27 | 264.27 | 600.0 |
| 2019-01-30 05:06:00 | SPY | ETF | 264.3 | 264.3 | 264.3 | 264.3 | 300.0 |
| 2019-01-30 05:07:00 | SPY | ETF | 264.22 | 264.22 | 264.22 | 264.22 | 300.0 |
| 2019-01-30 05:08:00 | SPY | ETF | 264.21 | 264.22 | 264.15 | 264.22 | 2000.0 |
| 2019-01-30 05:10:00 | SPY | ETF | 264.19 | 264.19 | 264.19 | 264.19 | 300.0 |
| 2019-01-30 05:12:00 | SPY | ETF | 264.15 | 264.15 | 264.15 | 264.15 | 300.0 |
| 2019-01-30 05:13:00 | SPY | ETF | 264.12 | 264.12 | 264.12 | 264.12 | 300.0 |
| 2019-01-30 05:14:00 | SPY | ETF | 264.13 | 264.13 | 264.13 | 264.13 | 100.0 |
| 2019-01-30 05:19:00 | SPY | ETF | 264.15 | 264.15 | 264.15 | 264.15 | 300.0 |
| 2019-01-30 05:20:00 | SPY | ETF | 264.21 | 264.21 | 264.21 | 264.21 | 400.0 |
| 2019-01-30 05:22:00 | SPY | ETF | 264.19 | 264.2 | 264.18 | 264.2 | 10300.0 |
| 2019-01-30 05:24:00 | SPY | ETF | 264.24 | 264.25 | 264.24 | 264.24 | 4200.0 |
> showing 50 of 178,817 rows — these rows as CSV