PREVIEW / etf_30min / 2025-11-12
file: by_date/etf_30min/2025/2025-11-12.parquet size: 1.0 MB rows: 44,097
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 |
|---|---|---|---|---|---|---|---|
| 2025-11-12 04:00:00 | SPY | ETF | 685.88 | 685.88 | 684.62 | 685.19 | 16959.0 |
| 2025-11-12 04:30:00 | SPY | ETF | 685.21 | 685.7 | 685.21 | 685.56 | 12050.0 |
| 2025-11-12 05:00:00 | SPY | ETF | 685.58 | 685.75 | 685.19 | 685.19 | 7417.0 |
| 2025-11-12 05:30:00 | SPY | ETF | 685.28 | 685.28 | 684.74 | 685.08 | 32735.0 |
| 2025-11-12 06:00:00 | SPY | ETF | 685.1 | 685.2 | 684.49 | 684.49 | 39263.0 |
| 2025-11-12 06:30:00 | SPY | ETF | 684.26 | 684.76 | 684.04 | 684.22 | 66672.0 |
| 2025-11-12 07:00:00 | SPY | ETF | 684.25 | 685.37 | 684.0 | 685.36 | 87735.0 |
| 2025-11-12 07:30:00 | SPY | ETF | 685.31 | 685.52 | 684.77 | 685.28 | 46111.0 |
| 2025-11-12 08:00:00 | SPY | ETF | 684.03 | 685.73 | 683.77 | 685.17 | 122205.0 |
| 2025-11-12 08:30:00 | SPY | ETF | 685.15 | 685.4 | 683.74 | 685.23 | 66603.0 |
| 2025-11-12 09:00:00 | SPY | ETF | 685.21 | 685.22 | 684.77 | 684.82 | 82730.0 |
| 2025-11-12 09:30:00 | SPY | ETF | 684.81 | 684.96 | 683.12 | 683.735 | 6451000.0 |
| 2025-11-12 10:00:00 | SPY | ETF | 683.73 | 684.27 | 682.81 | 683.195 | 3804120.0 |
| 2025-11-12 10:30:00 | SPY | ETF | 683.2 | 683.2599 | 681.7954 | 682.35 | 3362820.0 |
| 2025-11-12 11:00:00 | SPY | ETF | 682.33 | 682.52 | 681.14 | 682.41 | 2948638.0 |
| 2025-11-12 11:30:00 | SPY | ETF | 682.4 | 683.01 | 680.945 | 681.76 | 2913190.0 |
| 2025-11-12 12:00:00 | SPY | ETF | 681.76 | 682.8 | 681.54 | 682.47 | 2189191.0 |
| 2025-11-12 12:30:00 | SPY | ETF | 682.47 | 683.85 | 682.38 | 683.63 | 2439900.0 |
| 2025-11-12 13:00:00 | SPY | ETF | 683.64 | 683.93 | 683.05 | 683.495 | 1860310.0 |
| 2025-11-12 13:30:00 | SPY | ETF | 683.5 | 684.1499 | 683.26 | 683.63 | 1877794.0 |
| 2025-11-12 14:00:00 | SPY | ETF | 683.64 | 683.8 | 682.48 | 682.73 | 2543748.0 |
| 2025-11-12 14:30:00 | SPY | ETF | 682.74 | 683.255 | 682.24 | 682.81 | 2911516.0 |
| 2025-11-12 15:00:00 | SPY | ETF | 682.8 | 683.4099 | 682.092 | 683.34 | 2881798.0 |
| 2025-11-12 15:30:00 | SPY | ETF | 683.34 | 684.07 | 682.6616 | 683.33 | 9242206.0 |
| 2025-11-12 16:00:00 | SPY | ETF | 683.3 | 684.0 | 683.1 | 683.49 | 2579318.0 |
| 2025-11-12 16:30:00 | SPY | ETF | 683.54 | 683.54 | 682.96 | 683.0 | 206412.0 |
| 2025-11-12 17:00:00 | SPY | ETF | 683.03 | 683.18 | 682.95 | 683.02 | 64472.0 |
| 2025-11-12 17:30:00 | SPY | ETF | 683.06 | 683.38 | 683.0 | 683.06 | 310163.0 |
| 2025-11-12 18:00:00 | SPY | ETF | 683.06 | 683.16 | 681.13 | 682.0 | 68561.0 |
| 2025-11-12 18:30:00 | SPY | ETF | 682.02 | 682.1 | 680.92 | 681.5 | 89438.0 |
| 2025-11-12 19:00:00 | SPY | ETF | 681.5875 | 682.64 | 681.5875 | 682.01 | 42908.0 |
| 2025-11-12 19:30:00 | SPY | ETF | 682.11 | 682.24 | 681.78 | 682.0825 | 16244.0 |
| 2025-11-12 04:00:00 | QQQ | ETF | 624.62 | 625.5 | 624.62 | 625.2 | 56328.0 |
| 2025-11-12 04:30:00 | QQQ | ETF | 625.18 | 625.95 | 625.18 | 625.83 | 40344.0 |
| 2025-11-12 05:00:00 | QQQ | ETF | 625.84 | 626.04 | 625.41 | 625.43 | 33336.0 |
| 2025-11-12 05:30:00 | QQQ | ETF | 625.54 | 625.54 | 624.88 | 625.14 | 37846.0 |
| 2025-11-12 06:00:00 | QQQ | ETF | 625.32 | 625.44 | 624.15 | 624.15 | 26477.0 |
| 2025-11-12 06:30:00 | QQQ | ETF | 624.02 | 624.55 | 623.68 | 623.76 | 53129.0 |
| 2025-11-12 07:00:00 | QQQ | ETF | 623.8 | 625.24 | 623.5 | 625.22 | 151741.0 |
| 2025-11-12 07:30:00 | QQQ | ETF | 625.17 | 625.41 | 624.64 | 625.18 | 179394.0 |
| 2025-11-12 08:00:00 | QQQ | ETF | 623.67 | 626.02 | 621.104 | 625.15 | 237190.0 |
| 2025-11-12 08:30:00 | QQQ | ETF | 625.13 | 625.57 | 625.1 | 625.37 | 92311.0 |
| 2025-11-12 09:00:00 | QQQ | ETF | 625.33 | 625.37 | 624.7 | 624.83 | 157558.0 |
| 2025-11-12 09:30:00 | QQQ | ETF | 624.84 | 624.86 | 619.6 | 620.35 | 6010914.0 |
| 2025-11-12 10:00:00 | QQQ | ETF | 620.36 | 621.96 | 619.89 | 620.81 | 3608730.0 |
| 2025-11-12 10:30:00 | QQQ | ETF | 620.82 | 621.03 | 618.84 | 619.44 | 3546796.0 |
| 2025-11-12 11:00:00 | QQQ | ETF | 619.45 | 620.2 | 617.98 | 620.03 | 2938623.0 |
| 2025-11-12 11:30:00 | QQQ | ETF | 620.04 | 620.66 | 617.81 | 618.85 | 2757870.0 |
| 2025-11-12 12:00:00 | QQQ | ETF | 618.84 | 619.9 | 618.56 | 619.43 | 1824010.0 |
| 2025-11-12 12:30:00 | QQQ | ETF | 619.41 | 621.16 | 619.312 | 620.71 | 2039250.0 |
> showing 50 of 44,097 rows — these rows as CSV