PREVIEW / etf_30min / 2025-02-10
file: by_date/etf_30min/2025/2025-02-10.parquet size: 943 KB rows: 38,334
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-02-10 04:00:00 | SPY | ETF | 602.35 | 603.15 | 602.35 | 603.02 | 7014.0 |
| 2025-02-10 04:30:00 | SPY | ETF | 603.1 | 603.15 | 602.76 | 603.04 | 4489.0 |
| 2025-02-10 05:00:00 | SPY | ETF | 603.18 | 603.32 | 603.1 | 603.32 | 2177.0 |
| 2025-02-10 05:30:00 | SPY | ETF | 603.18 | 603.58 | 603.18 | 603.54 | 1927.0 |
| 2025-02-10 06:00:00 | SPY | ETF | 603.46 | 603.69 | 602.97 | 603.69 | 8471.0 |
| 2025-02-10 06:30:00 | SPY | ETF | 603.61 | 603.74 | 603.53 | 603.64 | 10078.0 |
| 2025-02-10 07:00:00 | SPY | ETF | 603.65 | 603.75 | 603.4 | 603.55 | 90505.0 |
| 2025-02-10 07:30:00 | SPY | ETF | 603.54 | 603.77 | 603.4 | 603.76 | 14577.0 |
| 2025-02-10 08:00:00 | SPY | ETF | 603.67 | 604.26 | 602.25 | 604.21 | 91535.0 |
| 2025-02-10 08:30:00 | SPY | ETF | 604.22 | 604.49 | 604.18 | 604.42 | 111038.0 |
| 2025-02-10 09:00:00 | SPY | ETF | 604.45 | 604.6 | 603.83 | 603.99 | 141590.0 |
| 2025-02-10 09:30:00 | SPY | ETF | 603.99 | 604.1 | 602.74 | 603.49 | 2412814.0 |
| 2025-02-10 10:00:00 | SPY | ETF | 603.51 | 604.79 | 603.33 | 604.73 | 1536418.0 |
| 2025-02-10 10:30:00 | SPY | ETF | 604.74 | 605.33 | 604.56 | 604.8688 | 1337881.0 |
| 2025-02-10 11:00:00 | SPY | ETF | 604.85 | 605.13 | 604.05 | 604.31 | 1005594.0 |
| 2025-02-10 11:30:00 | SPY | ETF | 604.3199 | 604.49 | 603.84 | 604.425 | 778299.0 |
| 2025-02-10 12:00:00 | SPY | ETF | 604.41 | 604.46 | 603.2108 | 603.6286 | 761727.0 |
| 2025-02-10 12:30:00 | SPY | ETF | 603.65 | 604.64 | 603.64 | 604.59 | 459906.0 |
| 2025-02-10 13:00:00 | SPY | ETF | 604.58 | 604.99 | 604.52 | 604.68 | 576818.0 |
| 2025-02-10 13:30:00 | SPY | ETF | 604.6801 | 605.24 | 604.56 | 605.052 | 635243.0 |
| 2025-02-10 14:00:00 | SPY | ETF | 605.05 | 605.4999 | 604.63 | 605.19 | 773538.0 |
| 2025-02-10 14:30:00 | SPY | ETF | 605.18 | 605.37 | 604.72 | 604.93 | 847230.0 |
| 2025-02-10 15:00:00 | SPY | ETF | 604.95 | 605.19 | 604.7516 | 604.89 | 933798.0 |
| 2025-02-10 15:30:00 | SPY | ETF | 604.88 | 605.03 | 604.2446 | 604.79 | 3873278.0 |
| 2025-02-10 16:00:00 | SPY | ETF | 604.78 | 604.85 | 604.2 | 604.6299 | 2043575.0 |
| 2025-02-10 16:30:00 | SPY | ETF | 604.66 | 604.74 | 604.55 | 604.7 | 57394.0 |
| 2025-02-10 17:00:00 | SPY | ETF | 604.69 | 604.72 | 604.64 | 604.72 | 8535.0 |
| 2025-02-10 17:30:00 | SPY | ETF | 604.7696 | 604.7696 | 604.4 | 604.61 | 24982.0 |
| 2025-02-10 18:00:00 | SPY | ETF | 604.45 | 604.45 | 603.22 | 603.49 | 79391.0 |
| 2025-02-10 18:30:00 | SPY | ETF | 603.5 | 603.7 | 603.471 | 603.68 | 31384.0 |
| 2025-02-10 19:00:00 | SPY | ETF | 603.68 | 603.77 | 603.43 | 603.77 | 12041.0 |
| 2025-02-10 19:30:00 | SPY | ETF | 603.771 | 604.07 | 603.77 | 603.98 | 17522.0 |
| 2025-02-10 04:00:00 | QQQ | ETF | 525.64 | 526.05 | 525.13 | 526.04 | 45613.0 |
| 2025-02-10 04:30:00 | QQQ | ETF | 525.99 | 526.05 | 525.59 | 525.97 | 20203.0 |
| 2025-02-10 05:00:00 | QQQ | ETF | 525.92 | 526.33 | 525.92 | 526.27 | 10882.0 |
| 2025-02-10 05:30:00 | QQQ | ETF | 526.27 | 526.53 | 526.21 | 526.35 | 10618.0 |
| 2025-02-10 06:00:00 | QQQ | ETF | 526.35 | 526.8 | 525.74 | 526.8 | 20761.0 |
| 2025-02-10 06:30:00 | QQQ | ETF | 526.73 | 526.94 | 526.59 | 526.76 | 10416.0 |
| 2025-02-10 07:00:00 | QQQ | ETF | 526.72 | 527.0 | 526.4 | 526.58 | 88226.0 |
| 2025-02-10 07:30:00 | QQQ | ETF | 526.51 | 526.61 | 526.23 | 526.61 | 43897.0 |
| 2025-02-10 08:00:00 | QQQ | ETF | 526.6018 | 527.2 | 522.528 | 527.15 | 120751.0 |
| 2025-02-10 08:30:00 | QQQ | ETF | 527.15 | 527.74 | 527.1079 | 527.6 | 117734.0 |
| 2025-02-10 09:00:00 | QQQ | ETF | 527.74 | 527.88 | 526.82 | 527.2 | 133720.0 |
| 2025-02-10 09:30:00 | QQQ | ETF | 527.25 | 528.3299 | 526.75 | 527.92 | 2387720.0 |
| 2025-02-10 10:00:00 | QQQ | ETF | 527.93 | 529.85 | 527.685 | 529.625 | 1404885.0 |
| 2025-02-10 10:30:00 | QQQ | ETF | 529.64 | 530.3571 | 529.56 | 529.6538 | 1263087.0 |
| 2025-02-10 11:00:00 | QQQ | ETF | 529.68 | 530.17 | 529.18 | 529.45 | 763395.0 |
| 2025-02-10 11:30:00 | QQQ | ETF | 529.45 | 529.8501 | 528.982 | 529.8501 | 726656.0 |
| 2025-02-10 12:00:00 | QQQ | ETF | 529.83 | 529.83 | 528.52 | 528.7 | 785093.0 |
| 2025-02-10 12:30:00 | QQQ | ETF | 528.72 | 529.74 | 528.67 | 529.7 | 484847.0 |
> showing 50 of 38,334 rows — these rows as CSV