PREVIEW / etf_30min / 2025-04-11
file: by_date/etf_30min/2025/2025-04-11.parquet size: 1000 KB rows: 41,572
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-04-11 04:00:00 | SPY | ETF | 525.2 | 527.46 | 522.9 | 523.68 | 214960.0 |
| 2025-04-11 04:30:00 | SPY | ETF | 523.57 | 524.02 | 520.78 | 522.42 | 132478.0 |
| 2025-04-11 05:00:00 | SPY | ETF | 522.29 | 524.3 | 521.5 | 523.8 | 64667.0 |
| 2025-04-11 05:30:00 | SPY | ETF | 523.54 | 529.1 | 523.4 | 529.07 | 54591.0 |
| 2025-04-11 06:00:00 | SPY | ETF | 528.9 | 530.32 | 527.44 | 529.7 | 74093.0 |
| 2025-04-11 06:30:00 | SPY | ETF | 529.38 | 530.64 | 527.71 | 528.78 | 77076.0 |
| 2025-04-11 07:00:00 | SPY | ETF | 528.79 | 529.65 | 525.65 | 526.39 | 154155.0 |
| 2025-04-11 07:30:00 | SPY | ETF | 526.3 | 527.94 | 524.32 | 526.95 | 171821.0 |
| 2025-04-11 08:00:00 | SPY | ETF | 529.15 | 532.48 | 524.27 | 527.25 | 385732.0 |
| 2025-04-11 08:30:00 | SPY | ETF | 527.5 | 529.77 | 525.31 | 525.55 | 534098.0 |
| 2025-04-11 09:00:00 | SPY | ETF | 525.7 | 526.641 | 521.5 | 523.11 | 1576072.0 |
| 2025-04-11 09:30:00 | SPY | ETF | 522.91 | 528.84 | 521.1 | 526.4001 | 7771474.0 |
| 2025-04-11 10:00:00 | SPY | ETF | 526.48 | 528.43 | 520.07 | 520.69 | 6913628.0 |
| 2025-04-11 10:30:00 | SPY | ETF | 520.8 | 526.71 | 520.09 | 523.17 | 4174391.0 |
| 2025-04-11 11:00:00 | SPY | ETF | 523.14 | 527.42 | 520.88 | 523.08 | 4102998.0 |
| 2025-04-11 11:30:00 | SPY | ETF | 523.03 | 527.11 | 522.42 | 526.94 | 2496608.0 |
| 2025-04-11 12:00:00 | SPY | ETF | 526.93 | 528.67 | 526.08 | 527.39 | 2560014.0 |
| 2025-04-11 12:30:00 | SPY | ETF | 527.535 | 532.85 | 527.4475 | 531.72 | 4165765.0 |
| 2025-04-11 13:00:00 | SPY | ETF | 531.77 | 533.09 | 529.48 | 529.83 | 2905989.0 |
| 2025-04-11 13:30:00 | SPY | ETF | 529.84 | 536.43 | 528.84 | 534.7 | 5315897.0 |
| 2025-04-11 14:00:00 | SPY | ETF | 534.72 | 534.99 | 531.57 | 533.17 | 3199639.0 |
| 2025-04-11 14:30:00 | SPY | ETF | 533.16 | 534.52 | 531.97 | 532.16 | 2672063.0 |
| 2025-04-11 15:00:00 | SPY | ETF | 532.23 | 535.68 | 532.11 | 534.74 | 3814795.0 |
| 2025-04-11 15:30:00 | SPY | ETF | 534.67 | 535.45 | 533.48 | 533.98 | 9976175.0 |
| 2025-04-11 16:00:00 | SPY | ETF | 533.98 | 534.94 | 533.53 | 534.5502 | 5460095.0 |
| 2025-04-11 16:30:00 | SPY | ETF | 534.6 | 534.82 | 534.16 | 534.37 | 427615.0 |
| 2025-04-11 17:00:00 | SPY | ETF | 534.3499 | 534.5001 | 534.02 | 534.37 | 52708.0 |
| 2025-04-11 17:30:00 | SPY | ETF | 534.38 | 534.4 | 533.83 | 534.08 | 40091.0 |
| 2025-04-11 18:00:00 | SPY | ETF | 533.9005 | 534.1 | 533.85 | 533.97 | 53407.0 |
| 2025-04-11 18:30:00 | SPY | ETF | 533.97 | 533.98 | 533.66 | 533.66 | 18419.0 |
| 2025-04-11 19:00:00 | SPY | ETF | 533.7 | 533.98 | 533.66 | 533.85 | 13835.0 |
| 2025-04-11 19:30:00 | SPY | ETF | 533.75 | 534.29 | 533.75 | 534.29 | 22189.0 |
| 2025-04-11 04:00:00 | QQQ | ETF | 447.22 | 449.53 | 444.52 | 445.02 | 183188.0 |
| 2025-04-11 04:30:00 | QQQ | ETF | 445.01 | 445.58 | 442.4 | 444.4 | 84116.0 |
| 2025-04-11 05:00:00 | QQQ | ETF | 444.25 | 445.83 | 443.5 | 445.17 | 58457.0 |
| 2025-04-11 05:30:00 | QQQ | ETF | 445.27 | 450.35 | 445.24 | 450.23 | 73343.0 |
| 2025-04-11 06:00:00 | QQQ | ETF | 450.14 | 451.31 | 448.68 | 450.8 | 58033.0 |
| 2025-04-11 06:30:00 | QQQ | ETF | 450.29 | 451.61 | 449.0 | 449.96 | 67306.0 |
| 2025-04-11 07:00:00 | QQQ | ETF | 449.96 | 450.5 | 447.05 | 447.41 | 83144.0 |
| 2025-04-11 07:30:00 | QQQ | ETF | 447.44 | 449.24 | 445.9 | 448.32 | 146887.0 |
| 2025-04-11 08:00:00 | QQQ | ETF | 450.12 | 453.8 | 443.5004 | 448.5 | 377082.0 |
| 2025-04-11 08:30:00 | QQQ | ETF | 448.25 | 450.785 | 446.25 | 446.63 | 509072.0 |
| 2025-04-11 09:00:00 | QQQ | ETF | 446.58 | 447.74 | 443.34 | 444.64 | 507798.0 |
| 2025-04-11 09:30:00 | QQQ | ETF | 444.65 | 450.379 | 443.21 | 448.3 | 4726515.0 |
| 2025-04-11 10:00:00 | QQQ | ETF | 448.31 | 449.76 | 441.33 | 442.09 | 3850203.0 |
| 2025-04-11 10:30:00 | QQQ | ETF | 442.17 | 447.91 | 441.34 | 444.8 | 2396560.0 |
| 2025-04-11 11:00:00 | QQQ | ETF | 444.69 | 448.6191 | 442.57 | 444.76 | 2066624.0 |
| 2025-04-11 11:30:00 | QQQ | ETF | 444.73 | 448.56 | 444.12 | 448.4 | 1499542.0 |
| 2025-04-11 12:00:00 | QQQ | ETF | 448.41 | 450.11 | 447.53 | 448.395 | 1705875.0 |
| 2025-04-11 12:30:00 | QQQ | ETF | 448.42 | 453.71 | 448.42 | 452.42 | 2608626.0 |
> showing 50 of 41,572 rows — these rows as CSV