PREVIEW / etf_30min / 2025-06-06
file: by_date/etf_30min/2025/2025-06-06.parquet size: 946 KB rows: 38,616
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-06-06 04:00:00 | SPY | ETF | 594.72 | 595.58 | 594.72 | 595.23 | 15932.0 |
| 2025-06-06 04:30:00 | SPY | ETF | 595.23 | 595.42 | 595.09 | 595.41 | 25331.0 |
| 2025-06-06 05:00:00 | SPY | ETF | 595.44 | 595.64 | 595.17 | 595.55 | 44130.0 |
| 2025-06-06 05:30:00 | SPY | ETF | 595.58 | 595.79 | 595.33 | 595.73 | 14790.0 |
| 2025-06-06 06:00:00 | SPY | ETF | 595.68 | 595.79 | 595.44 | 595.73 | 19087.0 |
| 2025-06-06 06:30:00 | SPY | ETF | 595.7 | 595.7 | 595.06 | 595.09 | 104591.0 |
| 2025-06-06 07:00:00 | SPY | ETF | 595.11 | 595.37 | 594.65 | 595.16 | 66853.0 |
| 2025-06-06 07:30:00 | SPY | ETF | 595.2 | 595.56 | 594.94 | 595.27 | 60840.0 |
| 2025-06-06 08:00:00 | SPY | ETF | 595.06 | 595.85 | 592.606 | 595.7 | 250629.0 |
| 2025-06-06 08:30:00 | SPY | ETF | 595.85 | 598.1 | 595.85 | 597.74 | 773993.0 |
| 2025-06-06 09:00:00 | SPY | ETF | 597.74 | 599.07 | 597.45 | 598.66 | 432586.0 |
| 2025-06-06 09:30:00 | SPY | ETF | 598.65 | 600.83 | 598.06 | 600.3 | 7743923.0 |
| 2025-06-06 10:00:00 | SPY | ETF | 600.31 | 600.48 | 598.85 | 599.18 | 3520536.0 |
| 2025-06-06 10:30:00 | SPY | ETF | 599.16 | 599.94 | 598.65 | 599.3 | 2383815.0 |
| 2025-06-06 11:00:00 | SPY | ETF | 599.29 | 600.37 | 597.25 | 598.51 | 4656724.0 |
| 2025-06-06 11:30:00 | SPY | ETF | 598.48 | 599.23 | 597.9699 | 598.6901 | 2367904.0 |
| 2025-06-06 12:00:00 | SPY | ETF | 598.7 | 599.39 | 598.38 | 598.59 | 1574900.0 |
| 2025-06-06 12:30:00 | SPY | ETF | 598.58 | 598.89 | 596.86 | 597.62 | 2710295.0 |
| 2025-06-06 13:00:00 | SPY | ETF | 597.61 | 598.59 | 597.125 | 598.19 | 2057886.0 |
| 2025-06-06 13:30:00 | SPY | ETF | 598.2 | 599.05 | 598.2 | 598.95 | 1486506.0 |
| 2025-06-06 14:00:00 | SPY | ETF | 598.95 | 600.13 | 598.95 | 599.58 | 2877516.0 |
| 2025-06-06 14:30:00 | SPY | ETF | 599.59 | 600.64 | 599.465 | 599.72 | 2863214.0 |
| 2025-06-06 15:00:00 | SPY | ETF | 599.73 | 600.06 | 599.18 | 599.35 | 2769195.0 |
| 2025-06-06 15:30:00 | SPY | ETF | 599.34 | 599.85 | 598.91 | 599.05 | 7549561.0 |
| 2025-06-06 16:00:00 | SPY | ETF | 599.03 | 599.6 | 598.84 | 599.39 | 2840999.0 |
| 2025-06-06 16:30:00 | SPY | ETF | 599.39 | 599.52 | 599.34 | 599.34 | 107221.0 |
| 2025-06-06 17:00:00 | SPY | ETF | 599.53 | 599.56 | 599.17 | 599.31 | 21867.0 |
| 2025-06-06 17:30:00 | SPY | ETF | 599.28 | 599.28 | 598.99 | 598.99 | 35640.0 |
| 2025-06-06 18:00:00 | SPY | ETF | 598.99 | 599.2 | 598.85 | 598.85 | 22889.0 |
| 2025-06-06 18:30:00 | SPY | ETF | 599.05 | 599.32 | 598.98 | 599.3001 | 15262.0 |
| 2025-06-06 19:00:00 | SPY | ETF | 599.33 | 599.7674 | 599.33 | 599.7 | 17088.0 |
| 2025-06-06 19:30:00 | SPY | ETF | 599.61 | 599.73 | 599.51 | 599.73 | 7727.0 |
| 2025-06-06 04:00:00 | QQQ | ETF | 526.55 | 526.93 | 525.84 | 526.46 | 33698.0 |
| 2025-06-06 04:30:00 | QQQ | ETF | 526.48 | 526.72 | 526.33 | 526.7 | 17960.0 |
| 2025-06-06 05:00:00 | QQQ | ETF | 526.7 | 527.22 | 526.54 | 527.1 | 14210.0 |
| 2025-06-06 05:30:00 | QQQ | ETF | 527.12 | 527.4 | 526.84 | 527.31 | 12315.0 |
| 2025-06-06 06:00:00 | QQQ | ETF | 527.3 | 527.5 | 527.01 | 527.39 | 15368.0 |
| 2025-06-06 06:30:00 | QQQ | ETF | 527.33 | 527.42 | 526.56 | 526.58 | 13899.0 |
| 2025-06-06 07:00:00 | QQQ | ETF | 526.57 | 527.15 | 526.27 | 526.91 | 88442.0 |
| 2025-06-06 07:30:00 | QQQ | ETF | 527.0 | 527.21 | 526.76 | 526.92 | 86109.0 |
| 2025-06-06 08:00:00 | QQQ | ETF | 526.59 | 527.3 | 525.183 | 526.96 | 311215.0 |
| 2025-06-06 08:30:00 | QQQ | ETF | 527.28 | 529.7 | 527.26 | 529.13 | 609257.0 |
| 2025-06-06 09:00:00 | QQQ | ETF | 529.14 | 530.32 | 528.8 | 530.0 | 355096.0 |
| 2025-06-06 09:30:00 | QQQ | ETF | 530.0 | 531.62 | 529.3 | 531.0208 | 5303654.0 |
| 2025-06-06 10:00:00 | QQQ | ETF | 531.07 | 531.33 | 529.29 | 529.7101 | 2453032.0 |
| 2025-06-06 10:30:00 | QQQ | ETF | 529.71 | 531.1 | 529.222 | 530.57 | 1946764.0 |
| 2025-06-06 11:00:00 | QQQ | ETF | 530.56 | 531.71 | 528.57 | 529.85 | 2862581.0 |
| 2025-06-06 11:30:00 | QQQ | ETF | 529.84 | 530.775 | 529.39 | 530.25 | 1576058.0 |
| 2025-06-06 12:00:00 | QQQ | ETF | 530.27 | 530.92 | 529.64 | 529.86 | 1078591.0 |
| 2025-06-06 12:30:00 | QQQ | ETF | 529.84 | 530.07 | 528.21 | 529.0208 | 1530438.0 |
> showing 50 of 38,616 rows — these rows as CSV