PREVIEW / etf_1min / 2020-11-18
file: by_date/etf_1min/2020/2020-11-18.parquet size: 4.1 MB rows: 218,166
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 |
|---|---|---|---|---|---|---|---|
| 2020-11-18 04:00:00 | SPY | ETF | 360.17 | 360.17 | 360.17 | 360.17 | 188.0 |
| 2020-11-18 04:01:00 | SPY | ETF | 360.28 | 360.28 | 360.28 | 360.28 | 548.0 |
| 2020-11-18 04:02:00 | SPY | ETF | 360.28 | 360.28 | 360.21 | 360.21 | 243.0 |
| 2020-11-18 04:03:00 | SPY | ETF | 360.2 | 360.23 | 360.2 | 360.23 | 200.0 |
| 2020-11-18 04:04:00 | SPY | ETF | 360.22 | 360.3 | 360.22 | 360.25 | 2225.0 |
| 2020-11-18 04:05:00 | SPY | ETF | 360.23 | 360.23 | 360.21 | 360.21 | 200.0 |
| 2020-11-18 04:06:00 | SPY | ETF | 360.28 | 360.28 | 360.28 | 360.28 | 600.0 |
| 2020-11-18 04:07:00 | SPY | ETF | 360.32 | 360.32 | 360.32 | 360.32 | 230.0 |
| 2020-11-18 04:08:00 | SPY | ETF | 360.28 | 360.28 | 360.28 | 360.28 | 100.0 |
| 2020-11-18 04:11:00 | SPY | ETF | 360.52 | 360.53 | 360.5 | 360.53 | 362.0 |
| 2020-11-18 04:14:00 | SPY | ETF | 360.38 | 360.38 | 360.38 | 360.38 | 230.0 |
| 2020-11-18 04:16:00 | SPY | ETF | 360.39 | 360.39 | 360.39 | 360.39 | 140.0 |
| 2020-11-18 04:17:00 | SPY | ETF | 360.46 | 360.61 | 360.46 | 360.61 | 340.0 |
| 2020-11-18 04:18:00 | SPY | ETF | 360.61 | 360.63 | 360.55 | 360.55 | 1173.0 |
| 2020-11-18 04:21:00 | SPY | ETF | 360.73 | 360.73 | 360.68 | 360.68 | 407.0 |
| 2020-11-18 04:22:00 | SPY | ETF | 360.7 | 360.7 | 360.7 | 360.7 | 101.0 |
| 2020-11-18 04:23:00 | SPY | ETF | 360.7 | 360.75 | 360.7 | 360.75 | 913.0 |
| 2020-11-18 04:24:00 | SPY | ETF | 360.8 | 360.94 | 360.8 | 360.94 | 5660.0 |
| 2020-11-18 04:25:00 | SPY | ETF | 360.87 | 360.89 | 360.87 | 360.88 | 1100.0 |
| 2020-11-18 04:26:00 | SPY | ETF | 360.9 | 361.03 | 360.9 | 361.03 | 4229.0 |
| 2020-11-18 04:27:00 | SPY | ETF | 360.96 | 360.96 | 360.96 | 360.96 | 100.0 |
| 2020-11-18 04:28:00 | SPY | ETF | 361.01 | 361.04 | 361.01 | 361.04 | 300.0 |
| 2020-11-18 04:33:00 | SPY | ETF | 360.91 | 360.91 | 360.91 | 360.91 | 1000.0 |
| 2020-11-18 04:35:00 | SPY | ETF | 360.86 | 360.86 | 360.86 | 360.86 | 630.0 |
| 2020-11-18 04:36:00 | SPY | ETF | 360.91 | 360.94 | 360.91 | 360.92 | 2178.0 |
| 2020-11-18 04:40:00 | SPY | ETF | 360.97 | 360.97 | 360.95 | 360.95 | 200.0 |
| 2020-11-18 04:44:00 | SPY | ETF | 360.88 | 360.9 | 360.88 | 360.9 | 600.0 |
| 2020-11-18 04:45:00 | SPY | ETF | 360.96 | 360.98 | 360.96 | 360.98 | 295.0 |
| 2020-11-18 04:51:00 | SPY | ETF | 360.88 | 360.88 | 360.88 | 360.88 | 100.0 |
| 2020-11-18 04:55:00 | SPY | ETF | 361.0 | 361.0 | 361.0 | 361.0 | 260.0 |
| 2020-11-18 05:03:00 | SPY | ETF | 361.05 | 361.05 | 361.05 | 361.05 | 180.0 |
| 2020-11-18 05:04:00 | SPY | ETF | 361.02 | 361.02 | 361.02 | 361.02 | 100.0 |
| 2020-11-18 05:06:00 | SPY | ETF | 361.09 | 361.23 | 361.09 | 361.17 | 3734.0 |
| 2020-11-18 05:09:00 | SPY | ETF | 361.3 | 361.3 | 361.3 | 361.3 | 751.0 |
| 2020-11-18 05:10:00 | SPY | ETF | 361.32 | 361.35 | 361.32 | 361.35 | 1061.0 |
| 2020-11-18 05:11:00 | SPY | ETF | 361.3 | 361.3 | 361.3 | 361.3 | 100.0 |
| 2020-11-18 05:13:00 | SPY | ETF | 361.33 | 361.33 | 361.33 | 361.33 | 300.0 |
| 2020-11-18 05:14:00 | SPY | ETF | 361.33 | 361.38 | 361.33 | 361.38 | 1679.0 |
| 2020-11-18 05:15:00 | SPY | ETF | 361.48 | 361.5 | 361.38 | 361.38 | 1302.0 |
| 2020-11-18 05:17:00 | SPY | ETF | 361.3 | 361.3 | 361.3 | 361.3 | 120.0 |
| 2020-11-18 05:18:00 | SPY | ETF | 361.3 | 361.32 | 361.3 | 361.32 | 1300.0 |
| 2020-11-18 05:21:00 | SPY | ETF | 361.39 | 361.39 | 361.3 | 361.3 | 3300.0 |
| 2020-11-18 05:22:00 | SPY | ETF | 361.3 | 361.3 | 361.3 | 361.3 | 233.0 |
| 2020-11-18 05:24:00 | SPY | ETF | 361.48 | 361.48 | 361.48 | 361.48 | 300.0 |
| 2020-11-18 05:27:00 | SPY | ETF | 361.6 | 361.6 | 361.6 | 361.6 | 115.0 |
| 2020-11-18 05:29:00 | SPY | ETF | 361.7 | 361.7 | 361.65 | 361.7 | 459.0 |
| 2020-11-18 05:35:00 | SPY | ETF | 361.48 | 361.5 | 361.48 | 361.5 | 210.0 |
| 2020-11-18 05:36:00 | SPY | ETF | 361.5 | 361.5 | 361.5 | 361.5 | 100.0 |
| 2020-11-18 05:37:00 | SPY | ETF | 361.5 | 361.5 | 361.5 | 361.5 | 920.0 |
| 2020-11-18 05:38:00 | SPY | ETF | 361.51 | 361.51 | 361.51 | 361.51 | 113.0 |
> showing 50 of 218,166 rows — these rows as CSV