PREVIEW / etf_30min / 2025-12-17
file: by_date/etf_30min/2025/2025-12-17.parquet size: 1.1 MB rows: 45,467
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-12-17 04:00:00 | SPY | ETF | 679.5 | 680.47 | 679.5 | 680.21 | 70562.0 |
| 2025-12-17 04:30:00 | SPY | ETF | 680.33 | 681.08 | 680.19 | 680.9 | 35636.0 |
| 2025-12-17 05:00:00 | SPY | ETF | 680.85 | 681.34 | 680.78 | 681.16 | 19183.0 |
| 2025-12-17 05:30:00 | SPY | ETF | 681.18 | 681.5 | 680.95 | 681.34 | 17743.0 |
| 2025-12-17 06:00:00 | SPY | ETF | 681.32 | 681.49 | 680.94 | 681.07 | 13362.0 |
| 2025-12-17 06:30:00 | SPY | ETF | 681.07 | 681.5 | 681.06 | 681.36 | 56522.0 |
| 2025-12-17 07:00:00 | SPY | ETF | 681.38 | 681.44 | 681.0 | 681.06 | 144158.0 |
| 2025-12-17 07:30:00 | SPY | ETF | 681.08 | 681.5 | 681.051 | 681.14 | 75663.0 |
| 2025-12-17 08:00:00 | SPY | ETF | 681.37 | 681.5 | 677.71 | 680.62 | 431695.0 |
| 2025-12-17 08:30:00 | SPY | ETF | 680.61 | 681.33 | 679.102 | 680.72 | 190055.0 |
| 2025-12-17 09:00:00 | SPY | ETF | 680.68 | 681.09 | 679.82 | 679.88 | 197537.0 |
| 2025-12-17 09:30:00 | SPY | ETF | 679.89 | 680.435 | 677.6 | 679.26 | 9127133.0 |
| 2025-12-17 10:00:00 | SPY | ETF | 679.265 | 679.68 | 678.11 | 678.93 | 4373324.0 |
| 2025-12-17 10:30:00 | SPY | ETF | 678.92 | 679.17 | 674.02 | 674.56 | 8978628.0 |
| 2025-12-17 11:00:00 | SPY | ETF | 674.55 | 675.7 | 673.43 | 674.635 | 6092794.0 |
| 2025-12-17 11:30:00 | SPY | ETF | 674.63 | 674.76 | 673.07 | 674.23 | 4600800.0 |
| 2025-12-17 12:00:00 | SPY | ETF | 674.22 | 675.05 | 673.08 | 674.15 | 3962142.0 |
| 2025-12-17 12:30:00 | SPY | ETF | 674.16 | 675.07 | 673.0 | 673.8 | 2928673.0 |
| 2025-12-17 13:00:00 | SPY | ETF | 673.81 | 674.8766 | 673.02 | 673.37 | 3256524.0 |
| 2025-12-17 13:30:00 | SPY | ETF | 673.36 | 673.62 | 672.08 | 672.555 | 4529139.0 |
| 2025-12-17 14:00:00 | SPY | ETF | 672.555 | 673.0 | 672.055 | 672.47 | 5013575.0 |
| 2025-12-17 14:30:00 | SPY | ETF | 672.46 | 673.2978 | 672.22 | 673.13 | 4078413.0 |
| 2025-12-17 15:00:00 | SPY | ETF | 673.12 | 673.32 | 672.24 | 672.52 | 4861987.0 |
| 2025-12-17 15:30:00 | SPY | ETF | 672.53 | 673.0 | 671.195 | 671.3 | 13195152.0 |
| 2025-12-17 16:00:00 | SPY | ETF | 671.31 | 673.09 | 671.2617 | 672.45 | 2916072.0 |
| 2025-12-17 16:30:00 | SPY | ETF | 672.45 | 672.79 | 672.13 | 672.13 | 131399.0 |
| 2025-12-17 17:00:00 | SPY | ETF | 672.29 | 672.45 | 671.93 | 672.18 | 136760.0 |
| 2025-12-17 17:30:00 | SPY | ETF | 672.23 | 672.66 | 672.19 | 672.66 | 34735.0 |
| 2025-12-17 18:00:00 | SPY | ETF | 672.66 | 672.87 | 671.88 | 672.25 | 98022.0 |
| 2025-12-17 18:30:00 | SPY | ETF | 672.3301 | 672.73 | 671.7 | 671.88 | 29748.0 |
| 2025-12-17 19:00:00 | SPY | ETF | 671.84 | 672.6288 | 671.26 | 672.189 | 47435.0 |
| 2025-12-17 19:30:00 | SPY | ETF | 672.09 | 672.8826 | 671.84 | 672.84 | 31619.0 |
| 2025-12-17 04:00:00 | QQQ | ETF | 612.86 | 613.56 | 612.3 | 613.29 | 89940.0 |
| 2025-12-17 04:30:00 | QQQ | ETF | 613.32 | 614.19 | 613.25 | 614.04 | 64052.0 |
| 2025-12-17 05:00:00 | QQQ | ETF | 614.03 | 614.5 | 613.86 | 614.2 | 43736.0 |
| 2025-12-17 05:30:00 | QQQ | ETF | 614.28 | 614.72 | 614.04 | 614.51 | 49306.0 |
| 2025-12-17 06:00:00 | QQQ | ETF | 614.51 | 614.88 | 614.15 | 614.33 | 42187.0 |
| 2025-12-17 06:30:00 | QQQ | ETF | 614.32 | 614.8 | 614.32 | 614.78 | 33823.0 |
| 2025-12-17 07:00:00 | QQQ | ETF | 614.79 | 614.9 | 614.31 | 614.4 | 140063.0 |
| 2025-12-17 07:30:00 | QQQ | ETF | 614.37 | 615.13 | 614.35 | 614.719 | 92849.0 |
| 2025-12-17 08:00:00 | QQQ | ETF | 612.86 | 615.11 | 609.95 | 613.63 | 842565.0 |
| 2025-12-17 08:30:00 | QQQ | ETF | 613.6 | 614.74 | 613.06 | 614.11 | 340299.0 |
| 2025-12-17 09:00:00 | QQQ | ETF | 614.11 | 614.48 | 612.92 | 613.07 | 316102.0 |
| 2025-12-17 09:30:00 | QQQ | ETF | 613.06 | 613.65 | 608.89 | 611.06 | 6951013.0 |
| 2025-12-17 10:00:00 | QQQ | ETF | 611.05 | 611.36 | 609.73 | 610.71 | 3039814.0 |
| 2025-12-17 10:30:00 | QQQ | ETF | 610.67 | 611.0298 | 603.91 | 604.51 | 6175250.0 |
| 2025-12-17 11:00:00 | QQQ | ETF | 604.48 | 606.03 | 603.27 | 604.74 | 4522874.0 |
| 2025-12-17 11:30:00 | QQQ | ETF | 604.7 | 604.72 | 602.77 | 603.99 | 3372797.0 |
| 2025-12-17 12:00:00 | QQQ | ETF | 603.98 | 604.995 | 602.72 | 604.15 | 4071705.0 |
| 2025-12-17 12:30:00 | QQQ | ETF | 604.15 | 605.15 | 602.75 | 603.68 | 2438080.0 |
> showing 50 of 45,467 rows — these rows as CSV