PREVIEW / etf_1min / 2023-12-20
file: by_date/etf_1min/2023/2023-12-20.parquet size: 5.5 MB rows: 311,687
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 |
|---|---|---|---|---|---|---|---|
| 2023-12-20 04:00:00 | SPY | ETF | 474.89 | 474.89 | 474.89 | 474.89 | 100.0 |
| 2023-12-20 04:02:00 | SPY | ETF | 474.45 | 474.45 | 474.45 | 474.45 | 910.0 |
| 2023-12-20 04:03:00 | SPY | ETF | 474.3 | 474.3 | 474.29 | 474.29 | 203.0 |
| 2023-12-20 04:04:00 | SPY | ETF | 474.15 | 474.15 | 474.15 | 474.15 | 100.0 |
| 2023-12-20 04:05:00 | SPY | ETF | 474.25 | 474.25 | 474.18 | 474.19 | 1156.0 |
| 2023-12-20 04:06:00 | SPY | ETF | 474.15 | 474.15 | 474.12 | 474.12 | 315.0 |
| 2023-12-20 04:08:00 | SPY | ETF | 474.1 | 474.1 | 474.1 | 474.1 | 130.0 |
| 2023-12-20 04:11:00 | SPY | ETF | 474.05 | 474.05 | 474.05 | 474.05 | 474.0 |
| 2023-12-20 04:12:00 | SPY | ETF | 474.02 | 474.02 | 474.02 | 474.02 | 200.0 |
| 2023-12-20 04:16:00 | SPY | ETF | 474.1 | 474.1 | 474.1 | 474.1 | 100.0 |
| 2023-12-20 04:17:00 | SPY | ETF | 474.0 | 474.0 | 474.0 | 474.0 | 1035.0 |
| 2023-12-20 04:18:00 | SPY | ETF | 474.05 | 474.05 | 474.05 | 474.05 | 300.0 |
| 2023-12-20 04:19:00 | SPY | ETF | 474.1 | 474.1 | 474.1 | 474.1 | 1187.0 |
| 2023-12-20 04:20:00 | SPY | ETF | 474.15 | 474.15 | 474.15 | 474.15 | 384.0 |
| 2023-12-20 04:21:00 | SPY | ETF | 474.15 | 474.15 | 474.15 | 474.15 | 187.0 |
| 2023-12-20 04:23:00 | SPY | ETF | 474.2 | 474.2 | 474.2 | 474.2 | 421.0 |
| 2023-12-20 04:30:00 | SPY | ETF | 474.15 | 474.15 | 474.15 | 474.15 | 300.0 |
| 2023-12-20 04:31:00 | SPY | ETF | 474.15 | 474.15 | 474.12 | 474.12 | 400.0 |
| 2023-12-20 04:34:00 | SPY | ETF | 474.02 | 474.07 | 474.02 | 474.07 | 1400.0 |
| 2023-12-20 04:35:00 | SPY | ETF | 474.06 | 474.11 | 474.06 | 474.11 | 1100.0 |
| 2023-12-20 04:41:00 | SPY | ETF | 474.04 | 474.04 | 474.04 | 474.04 | 300.0 |
| 2023-12-20 04:44:00 | SPY | ETF | 474.04 | 474.04 | 474.04 | 474.04 | 300.0 |
| 2023-12-20 04:46:00 | SPY | ETF | 474.07 | 474.07 | 474.07 | 474.07 | 600.0 |
| 2023-12-20 04:48:00 | SPY | ETF | 474.09 | 474.1 | 474.09 | 474.1 | 1315.0 |
| 2023-12-20 04:49:00 | SPY | ETF | 474.09 | 474.09 | 474.09 | 474.09 | 299.0 |
| 2023-12-20 04:50:00 | SPY | ETF | 474.15 | 474.15 | 474.15 | 474.15 | 1000.0 |
| 2023-12-20 04:51:00 | SPY | ETF | 474.09 | 474.09 | 474.09 | 474.09 | 100.0 |
| 2023-12-20 04:56:00 | SPY | ETF | 474.19 | 474.19 | 474.19 | 474.19 | 100.0 |
| 2023-12-20 05:00:00 | SPY | ETF | 474.17 | 474.17 | 474.17 | 474.17 | 200.0 |
| 2023-12-20 05:05:00 | SPY | ETF | 474.24 | 474.24 | 474.24 | 474.24 | 100.0 |
| 2023-12-20 05:09:00 | SPY | ETF | 474.27 | 474.29 | 474.27 | 474.29 | 200.0 |
| 2023-12-20 05:10:00 | SPY | ETF | 474.25 | 474.25 | 474.25 | 474.25 | 999.0 |
| 2023-12-20 05:12:00 | SPY | ETF | 474.29 | 474.29 | 474.28 | 474.28 | 1100.0 |
| 2023-12-20 05:15:00 | SPY | ETF | 474.31 | 474.31 | 474.31 | 474.31 | 200.0 |
| 2023-12-20 05:19:00 | SPY | ETF | 474.22 | 474.22 | 474.22 | 474.22 | 250.0 |
| 2023-12-20 05:21:00 | SPY | ETF | 474.15 | 474.15 | 474.15 | 474.15 | 300.0 |
| 2023-12-20 05:24:00 | SPY | ETF | 474.1 | 474.1 | 474.1 | 474.1 | 300.0 |
| 2023-12-20 05:25:00 | SPY | ETF | 474.1 | 474.1 | 474.1 | 474.1 | 100.0 |
| 2023-12-20 05:28:00 | SPY | ETF | 474.08 | 474.08 | 474.08 | 474.08 | 1400.0 |
| 2023-12-20 05:29:00 | SPY | ETF | 474.08 | 474.08 | 474.05 | 474.05 | 800.0 |
| 2023-12-20 05:31:00 | SPY | ETF | 474.1 | 474.1 | 474.08 | 474.08 | 500.0 |
| 2023-12-20 05:36:00 | SPY | ETF | 474.0 | 474.0 | 474.0 | 474.0 | 600.0 |
| 2023-12-20 05:38:00 | SPY | ETF | 474.11 | 474.11 | 474.11 | 474.11 | 400.0 |
| 2023-12-20 05:41:00 | SPY | ETF | 474.1 | 474.1 | 474.1 | 474.1 | 400.0 |
| 2023-12-20 05:42:00 | SPY | ETF | 474.09 | 474.09 | 474.09 | 474.09 | 300.0 |
| 2023-12-20 05:47:00 | SPY | ETF | 474.23 | 474.23 | 474.2 | 474.21 | 509.0 |
| 2023-12-20 05:54:00 | SPY | ETF | 474.13 | 474.13 | 474.13 | 474.13 | 200.0 |
| 2023-12-20 05:56:00 | SPY | ETF | 474.13 | 474.13 | 474.09 | 474.09 | 200.0 |
| 2023-12-20 05:57:00 | SPY | ETF | 474.05 | 474.05 | 474.05 | 474.05 | 100.0 |
| 2023-12-20 06:02:00 | SPY | ETF | 474.03 | 474.03 | 474.03 | 474.03 | 100.0 |
> showing 50 of 311,687 rows — these rows as CSV