PREVIEW / etf_30min / 2025-10-10
file: by_date/etf_30min/2025/2025-10-10.parquet size: 1.1 MB rows: 47,151
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-10-10 04:00:00 | SPY | ETF | 671.94 | 672.3 | 671.9 | 672.2 | 8556.0 |
| 2025-10-10 04:30:00 | SPY | ETF | 672.1 | 672.42 | 672.09 | 672.25 | 3378.0 |
| 2025-10-10 05:00:00 | SPY | ETF | 672.29 | 672.29 | 671.5 | 671.7 | 17107.0 |
| 2025-10-10 05:30:00 | SPY | ETF | 671.59 | 671.61 | 670.67 | 670.76 | 9798.0 |
| 2025-10-10 06:00:00 | SPY | ETF | 670.83 | 671.49 | 670.77 | 671.33 | 39774.0 |
| 2025-10-10 06:30:00 | SPY | ETF | 671.3 | 671.61 | 671.03 | 671.61 | 26411.0 |
| 2025-10-10 07:00:00 | SPY | ETF | 671.63 | 671.94 | 671.59 | 671.94 | 81937.0 |
| 2025-10-10 07:30:00 | SPY | ETF | 671.95 | 672.19 | 671.75 | 672.15 | 51909.0 |
| 2025-10-10 08:00:00 | SPY | ETF | 672.16 | 672.48 | 670.66 | 672.13 | 99567.0 |
| 2025-10-10 08:30:00 | SPY | ETF | 672.1 | 672.2 | 671.46 | 671.67 | 80855.0 |
| 2025-10-10 09:00:00 | SPY | ETF | 671.67 | 672.21 | 671.67 | 672.15 | 119514.0 |
| 2025-10-10 09:30:00 | SPY | ETF | 672.14 | 673.95 | 671.88 | 673.01 | 6543963.0 |
| 2025-10-10 10:00:00 | SPY | ETF | 673.1 | 673.36 | 671.8 | 672.57 | 3844059.0 |
| 2025-10-10 10:30:00 | SPY | ETF | 672.59 | 673.065 | 667.66 | 669.16 | 5934705.0 |
| 2025-10-10 11:00:00 | SPY | ETF | 669.13 | 669.18 | 661.93 | 662.44 | 24844831.0 |
| 2025-10-10 11:30:00 | SPY | ETF | 662.44 | 664.09 | 659.47 | 661.85 | 15433219.0 |
| 2025-10-10 12:00:00 | SPY | ETF | 661.8108 | 662.66 | 660.22 | 661.57 | 7125761.0 |
| 2025-10-10 12:30:00 | SPY | ETF | 661.58 | 662.7556 | 658.91 | 659.12 | 5902208.0 |
| 2025-10-10 13:00:00 | SPY | ETF | 659.11 | 659.89 | 657.74 | 659.77 | 5312911.0 |
| 2025-10-10 13:30:00 | SPY | ETF | 659.74 | 660.93 | 658.77 | 659.59 | 4070431.0 |
| 2025-10-10 14:00:00 | SPY | ETF | 659.63 | 660.09 | 658.64 | 659.1 | 3680577.0 |
| 2025-10-10 14:30:00 | SPY | ETF | 659.11 | 659.51 | 656.78 | 657.18 | 4515913.0 |
| 2025-10-10 15:00:00 | SPY | ETF | 657.18 | 658.26 | 655.51 | 655.99 | 5164941.0 |
| 2025-10-10 15:30:00 | SPY | ETF | 656.01 | 656.81 | 652.84 | 653.11 | 16522588.0 |
| 2025-10-10 16:00:00 | SPY | ETF | 653.11 | 656.6822 | 652.6 | 654.17 | 4610091.0 |
| 2025-10-10 16:30:00 | SPY | ETF | 654.17 | 654.18 | 647.76 | 648.96 | 2160588.0 |
| 2025-10-10 17:00:00 | SPY | ETF | 648.96 | 650.0 | 648.0 | 648.35 | 629996.0 |
| 2025-10-10 17:30:00 | SPY | ETF | 648.39 | 648.39 | 646.5 | 646.9 | 460367.0 |
| 2025-10-10 18:00:00 | SPY | ETF | 646.8798 | 650.75 | 646.2 | 650.3 | 606395.0 |
| 2025-10-10 18:30:00 | SPY | ETF | 650.3 | 651.0 | 647.7 | 650.0 | 257680.0 |
| 2025-10-10 19:00:00 | SPY | ETF | 650.0 | 651.39 | 649.55 | 651.39 | 123197.0 |
| 2025-10-10 19:30:00 | SPY | ETF | 651.3 | 653.21 | 651.3 | 652.15 | 212879.0 |
| 2025-10-10 04:00:00 | QQQ | ETF | 611.56 | 611.95 | 611.45 | 611.8 | 37173.0 |
| 2025-10-10 04:30:00 | QQQ | ETF | 611.86 | 612.12 | 611.72 | 612.02 | 21645.0 |
| 2025-10-10 05:00:00 | QQQ | ETF | 612.04 | 612.07 | 610.91 | 611.24 | 61010.0 |
| 2025-10-10 05:30:00 | QQQ | ETF | 611.14 | 611.3 | 609.99 | 610.07 | 37791.0 |
| 2025-10-10 06:00:00 | QQQ | ETF | 610.11 | 611.0 | 610.1 | 610.8 | 24625.0 |
| 2025-10-10 06:30:00 | QQQ | ETF | 610.77 | 611.15 | 610.56 | 611.14 | 41753.0 |
| 2025-10-10 07:00:00 | QQQ | ETF | 611.17 | 611.55 | 611.15 | 611.38 | 30372.0 |
| 2025-10-10 07:30:00 | QQQ | ETF | 611.43 | 611.69 | 611.25 | 611.69 | 30751.0 |
| 2025-10-10 08:00:00 | QQQ | ETF | 611.35 | 612.32 | 610.07 | 611.77 | 102738.0 |
| 2025-10-10 08:30:00 | QQQ | ETF | 611.74 | 611.83 | 610.87 | 611.03 | 106407.0 |
| 2025-10-10 09:00:00 | QQQ | ETF | 611.07 | 611.5 | 611.03 | 611.49 | 90481.0 |
| 2025-10-10 09:30:00 | QQQ | ETF | 611.4 | 613.18 | 610.96 | 612.5 | 4004098.0 |
| 2025-10-10 10:00:00 | QQQ | ETF | 612.55 | 612.75 | 611.1319 | 611.895 | 1879337.0 |
| 2025-10-10 10:30:00 | QQQ | ETF | 611.93 | 612.42 | 606.93 | 608.52 | 2634882.0 |
| 2025-10-10 11:00:00 | QQQ | ETF | 608.47 | 608.54 | 599.1001 | 599.565 | 10025914.0 |
| 2025-10-10 11:30:00 | QQQ | ETF | 599.5 | 601.69 | 595.93 | 599.74 | 7761204.0 |
| 2025-10-10 12:00:00 | QQQ | ETF | 599.64 | 600.2164 | 597.701 | 598.81 | 3446453.0 |
| 2025-10-10 12:30:00 | QQQ | ETF | 598.74 | 599.92 | 595.42 | 595.67 | 3216767.0 |
> showing 50 of 47,151 rows — these rows as CSV