PREVIEW / etf_1min / 2023-11-21
file: by_date/etf_1min/2023/2023-11-21.parquet size: 4.7 MB rows: 269,763
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-11-21 04:00:00 | SPY | ETF | 454.4 | 454.4 | 453.98 | 454.02 | 3172.0 |
| 2023-11-21 04:01:00 | SPY | ETF | 453.95 | 453.99 | 453.88 | 453.88 | 882.0 |
| 2023-11-21 04:02:00 | SPY | ETF | 453.99 | 453.99 | 453.91 | 453.91 | 975.0 |
| 2023-11-21 04:03:00 | SPY | ETF | 453.89 | 453.89 | 453.89 | 453.89 | 100.0 |
| 2023-11-21 04:04:00 | SPY | ETF | 453.96 | 453.96 | 453.96 | 453.96 | 298.0 |
| 2023-11-21 04:05:00 | SPY | ETF | 453.97 | 453.97 | 453.97 | 453.97 | 100.0 |
| 2023-11-21 04:06:00 | SPY | ETF | 453.95 | 453.95 | 453.95 | 453.95 | 200.0 |
| 2023-11-21 04:07:00 | SPY | ETF | 453.92 | 453.92 | 453.92 | 453.92 | 100.0 |
| 2023-11-21 04:09:00 | SPY | ETF | 453.88 | 453.88 | 453.86 | 453.86 | 1100.0 |
| 2023-11-21 04:10:00 | SPY | ETF | 453.89 | 453.89 | 453.89 | 453.89 | 250.0 |
| 2023-11-21 04:11:00 | SPY | ETF | 453.91 | 453.99 | 453.91 | 453.99 | 298.0 |
| 2023-11-21 04:12:00 | SPY | ETF | 453.97 | 454.03 | 453.97 | 453.99 | 666.0 |
| 2023-11-21 04:13:00 | SPY | ETF | 453.98 | 453.99 | 453.98 | 453.99 | 400.0 |
| 2023-11-21 04:14:00 | SPY | ETF | 453.87 | 453.87 | 453.87 | 453.87 | 300.0 |
| 2023-11-21 04:15:00 | SPY | ETF | 453.85 | 453.9 | 453.85 | 453.9 | 300.0 |
| 2023-11-21 04:16:00 | SPY | ETF | 453.87 | 453.87 | 453.87 | 453.87 | 150.0 |
| 2023-11-21 04:17:00 | SPY | ETF | 453.86 | 453.9 | 453.85 | 453.85 | 462.0 |
| 2023-11-21 04:18:00 | SPY | ETF | 453.86 | 453.86 | 453.86 | 453.86 | 150.0 |
| 2023-11-21 04:19:00 | SPY | ETF | 453.94 | 453.97 | 453.94 | 453.97 | 355.0 |
| 2023-11-21 04:20:00 | SPY | ETF | 453.94 | 453.94 | 453.94 | 453.94 | 100.0 |
| 2023-11-21 04:21:00 | SPY | ETF | 453.94 | 453.99 | 453.94 | 453.97 | 519.0 |
| 2023-11-21 04:22:00 | SPY | ETF | 454.03 | 454.03 | 454.0 | 454.02 | 500.0 |
| 2023-11-21 04:24:00 | SPY | ETF | 454.1 | 454.1 | 454.1 | 454.1 | 100.0 |
| 2023-11-21 04:25:00 | SPY | ETF | 454.12 | 454.12 | 454.12 | 454.12 | 120.0 |
| 2023-11-21 04:26:00 | SPY | ETF | 454.1 | 454.1 | 454.1 | 454.1 | 100.0 |
| 2023-11-21 04:27:00 | SPY | ETF | 454.09 | 454.09 | 454.08 | 454.08 | 200.0 |
| 2023-11-21 04:28:00 | SPY | ETF | 454.05 | 454.13 | 454.05 | 454.13 | 312.0 |
| 2023-11-21 04:29:00 | SPY | ETF | 454.05 | 454.05 | 454.05 | 454.05 | 110.0 |
| 2023-11-21 04:30:00 | SPY | ETF | 454.06 | 454.11 | 454.06 | 454.06 | 500.0 |
| 2023-11-21 04:31:00 | SPY | ETF | 454.04 | 454.04 | 454.04 | 454.04 | 100.0 |
| 2023-11-21 04:33:00 | SPY | ETF | 454.06 | 454.06 | 454.06 | 454.06 | 101.0 |
| 2023-11-21 04:34:00 | SPY | ETF | 454.03 | 454.03 | 454.01 | 454.01 | 250.0 |
| 2023-11-21 04:38:00 | SPY | ETF | 454.15 | 454.15 | 454.15 | 454.15 | 239.0 |
| 2023-11-21 04:39:00 | SPY | ETF | 454.15 | 454.17 | 454.15 | 454.17 | 576.0 |
| 2023-11-21 04:40:00 | SPY | ETF | 454.16 | 454.2 | 454.15 | 454.15 | 429.0 |
| 2023-11-21 04:43:00 | SPY | ETF | 454.05 | 454.05 | 454.05 | 454.05 | 400.0 |
| 2023-11-21 04:44:00 | SPY | ETF | 454.02 | 454.02 | 454.0 | 454.0 | 266.0 |
| 2023-11-21 04:46:00 | SPY | ETF | 453.87 | 453.87 | 453.85 | 453.85 | 375.0 |
| 2023-11-21 04:49:00 | SPY | ETF | 453.8 | 453.8 | 453.8 | 453.8 | 300.0 |
| 2023-11-21 04:50:00 | SPY | ETF | 453.82 | 453.82 | 453.82 | 453.82 | 500.0 |
| 2023-11-21 04:51:00 | SPY | ETF | 453.76 | 453.76 | 453.74 | 453.74 | 995.0 |
| 2023-11-21 04:54:00 | SPY | ETF | 453.78 | 453.78 | 453.78 | 453.78 | 103.0 |
| 2023-11-21 04:56:00 | SPY | ETF | 453.75 | 453.75 | 453.75 | 453.75 | 200.0 |
| 2023-11-21 04:58:00 | SPY | ETF | 453.75 | 453.75 | 453.75 | 453.75 | 300.0 |
| 2023-11-21 05:00:00 | SPY | ETF | 453.75 | 453.75 | 453.75 | 453.75 | 100.0 |
| 2023-11-21 05:05:00 | SPY | ETF | 453.8 | 453.8 | 453.8 | 453.8 | 183.0 |
| 2023-11-21 05:06:00 | SPY | ETF | 453.84 | 453.85 | 453.84 | 453.85 | 995.0 |
| 2023-11-21 05:08:00 | SPY | ETF | 453.78 | 453.78 | 453.78 | 453.78 | 100.0 |
| 2023-11-21 05:10:00 | SPY | ETF | 453.75 | 453.75 | 453.75 | 453.75 | 100.0 |
| 2023-11-21 05:16:00 | SPY | ETF | 453.93 | 453.93 | 453.93 | 453.93 | 214.0 |
> showing 50 of 269,763 rows — these rows as CSV