PREVIEW / etf_1min / 2024-10-22
file: by_date/etf_1min/2024/2024-10-22.parquet size: 5.4 MB rows: 299,309
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 |
|---|---|---|---|---|---|---|---|
| 2024-10-22 04:00:00 | SPY | ETF | 582.78 | 582.78 | 582.36 | 582.36 | 1849.0 |
| 2024-10-22 04:01:00 | SPY | ETF | 582.35 | 582.5 | 582.35 | 582.5 | 3155.0 |
| 2024-10-22 04:02:00 | SPY | ETF | 582.44 | 582.44 | 582.43 | 582.43 | 676.0 |
| 2024-10-22 04:03:00 | SPY | ETF | 582.31 | 582.31 | 582.31 | 582.31 | 146.0 |
| 2024-10-22 04:04:00 | SPY | ETF | 582.18 | 582.18 | 582.18 | 582.18 | 100.0 |
| 2024-10-22 04:06:00 | SPY | ETF | 582.17 | 582.17 | 582.17 | 582.17 | 239.0 |
| 2024-10-22 04:07:00 | SPY | ETF | 582.25 | 582.25 | 582.25 | 582.25 | 321.0 |
| 2024-10-22 04:10:00 | SPY | ETF | 582.41 | 582.41 | 582.41 | 582.41 | 100.0 |
| 2024-10-22 04:11:00 | SPY | ETF | 582.35 | 582.35 | 582.35 | 582.35 | 100.0 |
| 2024-10-22 04:13:00 | SPY | ETF | 582.4 | 582.48 | 582.4 | 582.48 | 1000.0 |
| 2024-10-22 04:14:00 | SPY | ETF | 582.44 | 582.45 | 582.41 | 582.45 | 959.0 |
| 2024-10-22 04:15:00 | SPY | ETF | 582.52 | 582.53 | 582.52 | 582.53 | 3754.0 |
| 2024-10-22 04:16:00 | SPY | ETF | 582.4 | 582.4 | 582.4 | 582.4 | 374.0 |
| 2024-10-22 04:17:00 | SPY | ETF | 582.4 | 582.4 | 582.4 | 582.4 | 569.0 |
| 2024-10-22 04:19:00 | SPY | ETF | 582.46 | 582.46 | 582.46 | 582.46 | 462.0 |
| 2024-10-22 04:20:00 | SPY | ETF | 582.51 | 582.51 | 582.51 | 582.51 | 300.0 |
| 2024-10-22 04:29:00 | SPY | ETF | 582.31 | 582.31 | 582.31 | 582.31 | 100.0 |
| 2024-10-22 04:31:00 | SPY | ETF | 582.25 | 582.25 | 582.25 | 582.25 | 358.0 |
| 2024-10-22 04:32:00 | SPY | ETF | 582.21 | 582.21 | 582.0 | 582.0 | 500.0 |
| 2024-10-22 04:33:00 | SPY | ETF | 581.92 | 581.93 | 581.89 | 581.89 | 874.0 |
| 2024-10-22 04:34:00 | SPY | ETF | 581.84 | 581.84 | 581.84 | 581.84 | 100.0 |
| 2024-10-22 04:35:00 | SPY | ETF | 581.72 | 581.72 | 581.72 | 581.72 | 100.0 |
| 2024-10-22 04:37:00 | SPY | ETF | 581.81 | 581.81 | 581.81 | 581.81 | 500.0 |
| 2024-10-22 04:38:00 | SPY | ETF | 581.86 | 581.86 | 581.86 | 581.86 | 100.0 |
| 2024-10-22 04:43:00 | SPY | ETF | 581.88 | 581.88 | 581.88 | 581.88 | 114.0 |
| 2024-10-22 04:49:00 | SPY | ETF | 582.29 | 582.29 | 582.29 | 582.29 | 100.0 |
| 2024-10-22 05:00:00 | SPY | ETF | 581.65 | 581.65 | 581.62 | 581.62 | 3692.0 |
| 2024-10-22 05:01:00 | SPY | ETF | 581.64 | 581.64 | 581.6 | 581.62 | 612.0 |
| 2024-10-22 05:02:00 | SPY | ETF | 581.61 | 581.61 | 581.53 | 581.53 | 1764.0 |
| 2024-10-22 05:03:00 | SPY | ETF | 581.64 | 581.64 | 581.64 | 581.64 | 167.0 |
| 2024-10-22 05:06:00 | SPY | ETF | 581.64 | 581.64 | 581.64 | 581.64 | 151.0 |
| 2024-10-22 05:08:00 | SPY | ETF | 581.74 | 581.74 | 581.68 | 581.68 | 300.0 |
| 2024-10-22 05:14:00 | SPY | ETF | 581.5 | 581.53 | 581.5 | 581.53 | 809.0 |
| 2024-10-22 05:16:00 | SPY | ETF | 581.44 | 581.44 | 581.28 | 581.28 | 765.0 |
| 2024-10-22 05:18:00 | SPY | ETF | 581.27 | 581.27 | 581.21 | 581.21 | 624.0 |
| 2024-10-22 05:19:00 | SPY | ETF | 581.29 | 581.3 | 581.23 | 581.23 | 1040.0 |
| 2024-10-22 05:20:00 | SPY | ETF | 581.27 | 581.27 | 581.25 | 581.25 | 1154.0 |
| 2024-10-22 05:21:00 | SPY | ETF | 581.23 | 581.23 | 581.23 | 581.23 | 901.0 |
| 2024-10-22 05:22:00 | SPY | ETF | 581.2 | 581.2 | 581.2 | 581.2 | 400.0 |
| 2024-10-22 05:23:00 | SPY | ETF | 581.13 | 581.13 | 580.91 | 581.02 | 2362.0 |
| 2024-10-22 05:24:00 | SPY | ETF | 581.0 | 581.05 | 581.0 | 581.03 | 3127.0 |
| 2024-10-22 05:25:00 | SPY | ETF | 581.0 | 581.0 | 580.96 | 580.99 | 853.0 |
| 2024-10-22 05:26:00 | SPY | ETF | 581.01 | 581.05 | 581.01 | 581.05 | 2115.0 |
| 2024-10-22 05:27:00 | SPY | ETF | 581.01 | 581.04 | 580.96 | 581.02 | 2802.0 |
| 2024-10-22 05:28:00 | SPY | ETF | 580.94 | 580.96 | 580.94 | 580.96 | 1513.0 |
| 2024-10-22 05:29:00 | SPY | ETF | 580.96 | 580.97 | 580.96 | 580.97 | 1024.0 |
| 2024-10-22 05:30:00 | SPY | ETF | 580.99 | 580.99 | 580.99 | 580.99 | 340.0 |
| 2024-10-22 05:31:00 | SPY | ETF | 581.06 | 581.06 | 581.06 | 581.06 | 514.0 |
| 2024-10-22 05:32:00 | SPY | ETF | 581.15 | 581.15 | 581.11 | 581.11 | 440.0 |
| 2024-10-22 05:34:00 | SPY | ETF | 581.21 | 581.21 | 581.08 | 581.14 | 3000.0 |
> showing 50 of 299,309 rows — these rows as CSV