PREVIEW / etf_30min / 2025-04-16
file: by_date/etf_30min/2025/2025-04-16.parquet size: 978 KB rows: 40,084
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-16 04:00:00 | SPY | ETF | 530.0 | 535.09 | 529.44 | 532.96 | 57376.0 |
| 2025-04-16 04:30:00 | SPY | ETF | 533.68 | 537.44 | 533.23 | 533.86 | 124627.0 |
| 2025-04-16 05:00:00 | SPY | ETF | 534.0 | 535.27 | 533.48 | 534.77 | 41845.0 |
| 2025-04-16 05:30:00 | SPY | ETF | 534.72 | 535.02 | 533.32 | 533.32 | 71881.0 |
| 2025-04-16 06:00:00 | SPY | ETF | 533.53 | 534.5 | 533.48 | 533.9 | 20697.0 |
| 2025-04-16 06:30:00 | SPY | ETF | 533.78 | 533.91 | 533.3 | 533.68 | 55821.0 |
| 2025-04-16 07:00:00 | SPY | ETF | 533.71 | 534.0 | 532.99 | 533.69 | 165936.0 |
| 2025-04-16 07:30:00 | SPY | ETF | 533.69 | 534.65 | 533.45 | 533.67 | 98088.0 |
| 2025-04-16 08:00:00 | SPY | ETF | 533.5 | 534.42 | 529.2 | 533.6065 | 135996.0 |
| 2025-04-16 08:30:00 | SPY | ETF | 533.86 | 534.17 | 532.42 | 532.49 | 206349.0 |
| 2025-04-16 09:00:00 | SPY | ETF | 532.5 | 532.76 | 531.35 | 531.63 | 382244.0 |
| 2025-04-16 09:30:00 | SPY | ETF | 531.68 | 533.86 | 529.92 | 529.92 | 5260039.0 |
| 2025-04-16 10:00:00 | SPY | ETF | 529.9 | 532.21 | 529.65 | 531.77 | 2885775.0 |
| 2025-04-16 10:30:00 | SPY | ETF | 531.76 | 532.96 | 531.305 | 532.27 | 1743071.0 |
| 2025-04-16 11:00:00 | SPY | ETF | 532.29 | 535.11 | 531.7058 | 534.64 | 2383647.0 |
| 2025-04-16 11:30:00 | SPY | ETF | 534.66 | 534.73 | 531.38 | 531.71 | 1841068.0 |
| 2025-04-16 12:00:00 | SPY | ETF | 531.73 | 531.87 | 530.765 | 531.505 | 1624584.0 |
| 2025-04-16 12:30:00 | SPY | ETF | 531.5 | 532.12 | 530.53 | 530.89 | 1567799.0 |
| 2025-04-16 13:00:00 | SPY | ETF | 530.93 | 531.71 | 530.22 | 531.5295 | 1502864.0 |
| 2025-04-16 13:30:00 | SPY | ETF | 531.55 | 531.62 | 523.94 | 524.1 | 6563684.0 |
| 2025-04-16 14:00:00 | SPY | ETF | 524.1 | 526.8398 | 524.065 | 526.0 | 3941815.0 |
| 2025-04-16 14:30:00 | SPY | ETF | 526.0 | 526.1797 | 522.71 | 522.84 | 3050697.0 |
| 2025-04-16 15:00:00 | SPY | ETF | 522.83 | 523.29 | 520.29 | 520.665 | 5131836.0 |
| 2025-04-16 15:30:00 | SPY | ETF | 520.69 | 526.17 | 520.69 | 525.73 | 11017968.0 |
| 2025-04-16 16:00:00 | SPY | ETF | 525.73 | 528.773 | 525.23 | 526.3 | 3155790.0 |
| 2025-04-16 16:30:00 | SPY | ETF | 526.23 | 526.64 | 524.34 | 525.0 | 581124.0 |
| 2025-04-16 17:00:00 | SPY | ETF | 524.95 | 525.85 | 524.9 | 525.85 | 187103.0 |
| 2025-04-16 17:30:00 | SPY | ETF | 525.81 | 526.58 | 525.66 | 526.0 | 206081.0 |
| 2025-04-16 18:00:00 | SPY | ETF | 526.0 | 526.4 | 525.2 | 525.9 | 272699.0 |
| 2025-04-16 18:30:00 | SPY | ETF | 525.96 | 526.3 | 525.65 | 525.9681 | 112469.0 |
| 2025-04-16 19:00:00 | SPY | ETF | 526.19 | 526.29 | 524.97 | 526.14 | 54843.0 |
| 2025-04-16 19:30:00 | SPY | ETF | 526.05 | 526.17 | 524.63 | 525.95 | 52255.0 |
| 2025-04-16 04:00:00 | QQQ | ETF | 447.82 | 452.41 | 447.31 | 450.76 | 90225.0 |
| 2025-04-16 04:30:00 | QQQ | ETF | 450.77 | 455.44 | 450.77 | 452.02 | 125091.0 |
| 2025-04-16 05:00:00 | QQQ | ETF | 452.24 | 453.24 | 451.55 | 452.56 | 57544.0 |
| 2025-04-16 05:30:00 | QQQ | ETF | 452.55 | 452.9 | 451.22 | 451.22 | 39387.0 |
| 2025-04-16 06:00:00 | QQQ | ETF | 451.24 | 452.38 | 451.22 | 451.87 | 28627.0 |
| 2025-04-16 06:30:00 | QQQ | ETF | 451.96 | 451.97 | 451.06 | 451.51 | 46307.0 |
| 2025-04-16 07:00:00 | QQQ | ETF | 451.57 | 451.78 | 450.63 | 451.78 | 58152.0 |
| 2025-04-16 07:30:00 | QQQ | ETF | 451.7 | 452.3 | 451.35 | 451.63 | 64568.0 |
| 2025-04-16 08:00:00 | QQQ | ETF | 451.25 | 453.5904 | 447.19 | 451.73 | 115507.0 |
| 2025-04-16 08:30:00 | QQQ | ETF | 451.73 | 452.0 | 450.11 | 450.22 | 172647.0 |
| 2025-04-16 09:00:00 | QQQ | ETF | 450.22 | 450.44 | 448.75 | 448.98 | 249355.0 |
| 2025-04-16 09:30:00 | QQQ | ETF | 449.01 | 451.28 | 447.53 | 447.56 | 3446357.0 |
| 2025-04-16 10:00:00 | QQQ | ETF | 447.53 | 450.32 | 447.22 | 449.86 | 2053128.0 |
| 2025-04-16 10:30:00 | QQQ | ETF | 449.82 | 451.0199 | 449.324 | 450.0337 | 1443317.0 |
| 2025-04-16 11:00:00 | QQQ | ETF | 450.09 | 452.62 | 449.2 | 451.99 | 1756443.0 |
| 2025-04-16 11:30:00 | QQQ | ETF | 452.01 | 452.07 | 448.83 | 449.04 | 1135746.0 |
| 2025-04-16 12:00:00 | QQQ | ETF | 449.12 | 449.52 | 448.23 | 449.17 | 990834.0 |
| 2025-04-16 12:30:00 | QQQ | ETF | 449.145 | 449.8 | 448.16 | 448.42 | 1028162.0 |
> showing 50 of 40,084 rows — these rows as CSV