PREVIEW / etf_30min / 2025-12-15
file: by_date/etf_30min/2025/2025-12-15.parquet size: 1.1 MB rows: 45,445
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-15 04:00:00 | SPY | ETF | 684.15 | 684.67 | 683.87 | 684.55 | 26029.0 |
| 2025-12-15 04:30:00 | SPY | ETF | 684.61 | 684.92 | 684.48 | 684.84 | 15899.0 |
| 2025-12-15 05:00:00 | SPY | ETF | 684.75 | 685.18 | 684.68 | 685.0 | 18196.0 |
| 2025-12-15 05:30:00 | SPY | ETF | 684.95 | 685.14 | 684.71 | 685.07 | 12625.0 |
| 2025-12-15 06:00:00 | SPY | ETF | 685.05 | 685.1 | 684.86 | 684.98 | 12383.0 |
| 2025-12-15 06:30:00 | SPY | ETF | 685.03 | 685.26 | 684.93 | 685.14 | 39778.0 |
| 2025-12-15 07:00:00 | SPY | ETF | 685.11 | 685.13 | 684.45 | 684.59 | 264880.0 |
| 2025-12-15 07:30:00 | SPY | ETF | 684.56 | 685.23 | 684.551 | 685.03 | 113405.0 |
| 2025-12-15 08:00:00 | SPY | ETF | 685.04 | 685.26 | 682.94 | 685.02 | 239961.0 |
| 2025-12-15 08:30:00 | SPY | ETF | 685.03 | 685.46 | 681.73 | 685.36 | 180323.0 |
| 2025-12-15 09:00:00 | SPY | ETF | 685.36 | 685.87 | 685.22 | 685.71 | 260774.0 |
| 2025-12-15 09:30:00 | SPY | ETF | 685.72 | 685.76 | 682.3 | 682.43 | 9326217.0 |
| 2025-12-15 10:00:00 | SPY | ETF | 682.43 | 682.585 | 679.25 | 679.82 | 8258832.0 |
| 2025-12-15 10:30:00 | SPY | ETF | 679.82 | 682.16 | 679.59 | 681.15 | 6121537.0 |
| 2025-12-15 11:00:00 | SPY | ETF | 681.14 | 683.06 | 680.56 | 682.79 | 4395491.0 |
| 2025-12-15 11:30:00 | SPY | ETF | 682.79 | 682.92 | 680.14 | 680.88 | 5228905.0 |
| 2025-12-15 12:00:00 | SPY | ETF | 680.88 | 681.33 | 680.21 | 680.65 | 3040362.0 |
| 2025-12-15 12:30:00 | SPY | ETF | 680.65 | 681.45 | 679.42 | 680.5044 | 3558220.0 |
| 2025-12-15 13:00:00 | SPY | ETF | 680.5 | 681.19 | 679.51 | 679.98 | 2768133.0 |
| 2025-12-15 13:30:00 | SPY | ETF | 679.98 | 681.4 | 679.62 | 681.02 | 2850676.0 |
| 2025-12-15 14:00:00 | SPY | ETF | 681.02 | 681.5497 | 680.44 | 680.8355 | 3227391.0 |
| 2025-12-15 14:30:00 | SPY | ETF | 680.835 | 681.78 | 680.44 | 681.69 | 3173159.0 |
| 2025-12-15 15:00:00 | SPY | ETF | 681.69 | 681.74 | 680.69 | 681.07 | 4142557.0 |
| 2025-12-15 15:30:00 | SPY | ETF | 681.09 | 681.6 | 680.55 | 680.7 | 10664287.0 |
| 2025-12-15 16:00:00 | SPY | ETF | 680.71 | 681.1668 | 680.55 | 680.75 | 2689465.0 |
| 2025-12-15 16:30:00 | SPY | ETF | 680.8 | 681.08 | 680.8 | 681.02 | 165983.0 |
| 2025-12-15 17:00:00 | SPY | ETF | 680.97 | 681.05 | 680.97 | 681.0 | 27099.0 |
| 2025-12-15 17:30:00 | SPY | ETF | 681.0 | 681.23 | 680.7 | 681.01 | 316295.0 |
| 2025-12-15 18:00:00 | SPY | ETF | 681.1 | 681.4 | 680.78 | 680.91 | 62843.0 |
| 2025-12-15 18:30:00 | SPY | ETF | 680.949 | 680.96 | 679.93 | 680.4 | 29706.0 |
| 2025-12-15 19:00:00 | SPY | ETF | 680.37 | 680.5714 | 679.21 | 680.24 | 37327.0 |
| 2025-12-15 19:30:00 | SPY | ETF | 680.1796 | 680.29 | 679.46 | 679.48 | 40249.0 |
| 2025-12-15 04:00:00 | QQQ | ETF | 617.0 | 617.0 | 614.65 | 616.27 | 64817.0 |
| 2025-12-15 04:30:00 | QQQ | ETF | 616.29 | 616.61 | 616.17 | 616.45 | 24825.0 |
| 2025-12-15 05:00:00 | QQQ | ETF | 616.36 | 616.84 | 616.27 | 616.7 | 24609.0 |
| 2025-12-15 05:30:00 | QQQ | ETF | 616.7 | 616.83 | 616.4 | 616.71 | 30050.0 |
| 2025-12-15 06:00:00 | QQQ | ETF | 616.71 | 617.06 | 616.52 | 616.92 | 27300.0 |
| 2025-12-15 06:30:00 | QQQ | ETF | 616.98 | 617.24 | 616.95 | 617.18 | 34238.0 |
| 2025-12-15 07:00:00 | QQQ | ETF | 617.15 | 617.15 | 616.4 | 616.58 | 85096.0 |
| 2025-12-15 07:30:00 | QQQ | ETF | 616.6 | 617.28 | 616.58 | 617.08 | 117697.0 |
| 2025-12-15 08:00:00 | QQQ | ETF | 617.1502 | 617.19 | 613.16 | 617.03 | 240110.0 |
| 2025-12-15 08:30:00 | QQQ | ETF | 617.04 | 617.8 | 616.95 | 617.73 | 265294.0 |
| 2025-12-15 09:00:00 | QQQ | ETF | 617.7 | 618.35 | 617.53 | 618.33 | 311846.0 |
| 2025-12-15 09:30:00 | QQQ | ETF | 618.39 | 618.42 | 613.65 | 613.94 | 6602568.0 |
| 2025-12-15 10:00:00 | QQQ | ETF | 613.93 | 614.17 | 609.32 | 610.17 | 5726523.0 |
| 2025-12-15 10:30:00 | QQQ | ETF | 610.14 | 613.25 | 609.82 | 612.16 | 3494542.0 |
| 2025-12-15 11:00:00 | QQQ | ETF | 612.16 | 614.91 | 611.43 | 614.63 | 2516298.0 |
| 2025-12-15 11:30:00 | QQQ | ETF | 614.635 | 614.78 | 611.38 | 612.41 | 2780671.0 |
| 2025-12-15 12:00:00 | QQQ | ETF | 612.42 | 612.775 | 611.59 | 612.07 | 1408039.0 |
| 2025-12-15 12:30:00 | QQQ | ETF | 612.1 | 612.98 | 610.51 | 611.6601 | 1566828.0 |
> showing 50 of 45,445 rows — these rows as CSV