PREVIEW / etf_1min / 2022-12-02
file: by_date/etf_1min/2022/2022-12-02.parquet size: 4.7 MB rows: 269,578
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 |
|---|---|---|---|---|---|---|---|
| 2022-12-02 04:00:00 | SPY | ETF | 407.15 | 407.23 | 406.85 | 407.2 | 1211.0 |
| 2022-12-02 04:01:00 | SPY | ETF | 407.19 | 407.23 | 407.19 | 407.23 | 200.0 |
| 2022-12-02 04:02:00 | SPY | ETF | 407.27 | 407.27 | 407.21 | 407.21 | 300.0 |
| 2022-12-02 04:03:00 | SPY | ETF | 407.26 | 407.26 | 407.26 | 407.26 | 117.0 |
| 2022-12-02 04:04:00 | SPY | ETF | 407.32 | 407.35 | 407.13 | 407.17 | 2189.0 |
| 2022-12-02 04:05:00 | SPY | ETF | 407.16 | 407.19 | 407.15 | 407.17 | 1403.0 |
| 2022-12-02 04:06:00 | SPY | ETF | 407.24 | 407.24 | 407.24 | 407.24 | 200.0 |
| 2022-12-02 04:08:00 | SPY | ETF | 407.23 | 407.23 | 407.19 | 407.19 | 320.0 |
| 2022-12-02 04:09:00 | SPY | ETF | 407.08 | 407.12 | 407.08 | 407.11 | 500.0 |
| 2022-12-02 04:10:00 | SPY | ETF | 407.06 | 407.06 | 407.0 | 407.0 | 1520.0 |
| 2022-12-02 04:11:00 | SPY | ETF | 406.96 | 407.0 | 406.96 | 407.0 | 900.0 |
| 2022-12-02 04:12:00 | SPY | ETF | 407.03 | 407.03 | 407.03 | 407.03 | 300.0 |
| 2022-12-02 04:13:00 | SPY | ETF | 406.88 | 406.88 | 406.88 | 406.88 | 328.0 |
| 2022-12-02 04:14:00 | SPY | ETF | 406.97 | 406.97 | 406.97 | 406.97 | 122.0 |
| 2022-12-02 04:15:00 | SPY | ETF | 406.95 | 406.99 | 406.95 | 406.99 | 1144.0 |
| 2022-12-02 04:16:00 | SPY | ETF | 407.01 | 407.01 | 407.01 | 407.01 | 100.0 |
| 2022-12-02 04:17:00 | SPY | ETF | 407.06 | 407.06 | 407.06 | 407.06 | 100.0 |
| 2022-12-02 04:18:00 | SPY | ETF | 407.0 | 407.0 | 407.0 | 407.0 | 197.0 |
| 2022-12-02 04:19:00 | SPY | ETF | 407.02 | 407.02 | 407.01 | 407.01 | 589.0 |
| 2022-12-02 04:21:00 | SPY | ETF | 407.08 | 407.08 | 407.06 | 407.06 | 1163.0 |
| 2022-12-02 04:23:00 | SPY | ETF | 406.98 | 406.98 | 406.98 | 406.98 | 100.0 |
| 2022-12-02 04:24:00 | SPY | ETF | 406.92 | 407.01 | 406.91 | 407.01 | 2400.0 |
| 2022-12-02 04:25:00 | SPY | ETF | 406.95 | 406.95 | 406.95 | 406.95 | 500.0 |
| 2022-12-02 04:26:00 | SPY | ETF | 406.94 | 406.94 | 406.94 | 406.94 | 300.0 |
| 2022-12-02 04:27:00 | SPY | ETF | 406.98 | 406.98 | 406.98 | 406.98 | 450.0 |
| 2022-12-02 04:28:00 | SPY | ETF | 407.02 | 407.02 | 407.02 | 407.02 | 1256.0 |
| 2022-12-02 04:29:00 | SPY | ETF | 407.12 | 407.16 | 407.12 | 407.16 | 296.0 |
| 2022-12-02 04:30:00 | SPY | ETF | 407.14 | 407.14 | 407.09 | 407.09 | 338.0 |
| 2022-12-02 04:32:00 | SPY | ETF | 406.94 | 406.94 | 406.94 | 406.94 | 1200.0 |
| 2022-12-02 04:33:00 | SPY | ETF | 406.9 | 406.9 | 406.9 | 406.9 | 200.0 |
| 2022-12-02 04:35:00 | SPY | ETF | 407.11 | 407.21 | 407.04 | 407.21 | 1775.0 |
| 2022-12-02 04:44:00 | SPY | ETF | 407.14 | 407.15 | 407.14 | 407.15 | 900.0 |
| 2022-12-02 04:46:00 | SPY | ETF | 407.2 | 407.2 | 407.2 | 407.2 | 122.0 |
| 2022-12-02 04:47:00 | SPY | ETF | 407.23 | 407.23 | 407.19 | 407.19 | 205.0 |
| 2022-12-02 04:48:00 | SPY | ETF | 407.2 | 407.2 | 407.2 | 407.2 | 101.0 |
| 2022-12-02 04:49:00 | SPY | ETF | 407.1 | 407.1 | 407.1 | 407.1 | 150.0 |
| 2022-12-02 04:50:00 | SPY | ETF | 407.05 | 407.05 | 406.99 | 406.99 | 300.0 |
| 2022-12-02 04:51:00 | SPY | ETF | 407.1 | 407.1 | 407.1 | 407.1 | 242.0 |
| 2022-12-02 04:52:00 | SPY | ETF | 407.14 | 407.15 | 407.14 | 407.15 | 4950.0 |
| 2022-12-02 04:53:00 | SPY | ETF | 407.17 | 407.17 | 407.13 | 407.13 | 600.0 |
| 2022-12-02 04:54:00 | SPY | ETF | 407.17 | 407.17 | 407.17 | 407.17 | 101.0 |
| 2022-12-02 04:55:00 | SPY | ETF | 407.18 | 407.18 | 407.18 | 407.18 | 100.0 |
| 2022-12-02 04:56:00 | SPY | ETF | 407.18 | 407.18 | 407.18 | 407.18 | 250.0 |
| 2022-12-02 04:57:00 | SPY | ETF | 407.26 | 407.33 | 407.26 | 407.33 | 200.0 |
| 2022-12-02 04:58:00 | SPY | ETF | 407.37 | 407.44 | 407.37 | 407.44 | 450.0 |
| 2022-12-02 05:00:00 | SPY | ETF | 407.49 | 407.49 | 407.46 | 407.46 | 1900.0 |
| 2022-12-02 05:03:00 | SPY | ETF | 407.36 | 407.44 | 407.34 | 407.44 | 1893.0 |
| 2022-12-02 05:04:00 | SPY | ETF | 407.45 | 407.45 | 407.42 | 407.42 | 941.0 |
| 2022-12-02 05:08:00 | SPY | ETF | 407.44 | 407.53 | 407.44 | 407.53 | 4900.0 |
| 2022-12-02 05:09:00 | SPY | ETF | 407.58 | 407.58 | 407.58 | 407.58 | 300.0 |
> showing 50 of 269,578 rows — these rows as CSV