PREVIEW / etf_30min / 2025-11-13
file: by_date/etf_30min/2025/2025-11-13.parquet size: 1.1 MB rows: 45,686
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-11-13 04:00:00 | SPY | ETF | 683.0 | 684.51 | 682.05 | 682.05 | 27098.0 |
| 2025-11-13 04:30:00 | SPY | ETF | 682.15 | 682.56 | 681.72 | 682.38 | 20375.0 |
| 2025-11-13 05:00:00 | SPY | ETF | 682.33 | 683.1 | 682.24 | 683.01 | 10741.0 |
| 2025-11-13 05:30:00 | SPY | ETF | 682.79 | 683.41 | 682.68 | 682.87 | 14231.0 |
| 2025-11-13 06:00:00 | SPY | ETF | 682.82 | 683.26 | 682.19 | 682.19 | 7789.0 |
| 2025-11-13 06:30:00 | SPY | ETF | 682.36 | 682.58 | 681.71 | 682.55 | 23870.0 |
| 2025-11-13 07:00:00 | SPY | ETF | 682.55 | 682.59 | 681.86 | 682.32 | 86900.0 |
| 2025-11-13 07:30:00 | SPY | ETF | 682.32 | 683.0 | 682.27 | 682.38 | 51962.0 |
| 2025-11-13 08:00:00 | SPY | ETF | 682.31 | 684.95 | 681.47 | 681.9999 | 168870.0 |
| 2025-11-13 08:30:00 | SPY | ETF | 681.96 | 684.11 | 680.73 | 680.88 | 226378.0 |
| 2025-11-13 09:00:00 | SPY | ETF | 680.91 | 681.1 | 679.94 | 680.5 | 431283.0 |
| 2025-11-13 09:30:00 | SPY | ETF | 680.51 | 680.71 | 677.53 | 678.8 | 7647353.0 |
| 2025-11-13 10:00:00 | SPY | ETF | 678.78 | 680.86 | 677.97 | 678.94 | 5204140.0 |
| 2025-11-13 10:30:00 | SPY | ETF | 678.95 | 679.03 | 675.34 | 676.48 | 6697559.0 |
| 2025-11-13 11:00:00 | SPY | ETF | 676.48 | 676.81 | 674.96 | 675.73 | 4864746.0 |
| 2025-11-13 11:30:00 | SPY | ETF | 675.72 | 676.62 | 674.22 | 675.19 | 4342907.0 |
| 2025-11-13 12:00:00 | SPY | ETF | 675.195 | 676.17 | 674.33 | 675.92 | 3796401.0 |
| 2025-11-13 12:30:00 | SPY | ETF | 675.9 | 676.5 | 673.97 | 674.15 | 3615028.0 |
| 2025-11-13 13:00:00 | SPY | ETF | 674.16 | 674.76 | 672.595 | 672.83 | 3583626.0 |
| 2025-11-13 13:30:00 | SPY | ETF | 672.82 | 672.895 | 671.52 | 672.69 | 4794376.0 |
| 2025-11-13 14:00:00 | SPY | ETF | 672.68 | 673.55 | 671.58 | 673.54 | 3961129.0 |
| 2025-11-13 14:30:00 | SPY | ETF | 673.51 | 673.63 | 670.52 | 671.69 | 4972173.0 |
| 2025-11-13 15:00:00 | SPY | ETF | 671.68 | 672.06 | 670.53 | 671.63 | 6151158.0 |
| 2025-11-13 15:30:00 | SPY | ETF | 671.62 | 673.02 | 670.76 | 672.06 | 13073735.0 |
| 2025-11-13 16:00:00 | SPY | ETF | 672.06 | 673.68 | 671.8502 | 672.9825 | 3627191.0 |
| 2025-11-13 16:30:00 | SPY | ETF | 673.11 | 673.15 | 671.8448 | 672.08 | 471702.0 |
| 2025-11-13 17:00:00 | SPY | ETF | 672.06 | 672.22 | 671.72 | 671.95 | 91099.0 |
| 2025-11-13 17:30:00 | SPY | ETF | 671.9107 | 672.38 | 671.9 | 672.3 | 279832.0 |
| 2025-11-13 18:00:00 | SPY | ETF | 672.23 | 673.1994 | 672.23 | 673.17 | 83075.0 |
| 2025-11-13 18:30:00 | SPY | ETF | 673.14 | 673.36 | 672.5 | 672.57 | 48751.0 |
| 2025-11-13 19:00:00 | SPY | ETF | 672.63 | 673.27 | 672.395 | 673.1198 | 94402.0 |
| 2025-11-13 19:30:00 | SPY | ETF | 673.09 | 673.19 | 672.48 | 672.6 | 81806.0 |
| 2025-11-13 04:00:00 | QQQ | ETF | 623.0 | 623.0 | 619.44 | 619.44 | 116973.0 |
| 2025-11-13 04:30:00 | QQQ | ETF | 619.53 | 620.07 | 618.92 | 619.66 | 78102.0 |
| 2025-11-13 05:00:00 | QQQ | ETF | 619.68 | 620.8 | 619.63 | 620.59 | 52216.0 |
| 2025-11-13 05:30:00 | QQQ | ETF | 620.62 | 621.25 | 620.3 | 620.59 | 45624.0 |
| 2025-11-13 06:00:00 | QQQ | ETF | 620.46 | 621.22 | 619.87 | 620.0 | 48712.0 |
| 2025-11-13 06:30:00 | QQQ | ETF | 620.19 | 620.43 | 619.37 | 620.35 | 44228.0 |
| 2025-11-13 07:00:00 | QQQ | ETF | 620.32 | 620.37 | 619.401 | 619.97 | 55710.0 |
| 2025-11-13 07:30:00 | QQQ | ETF | 619.94 | 620.9 | 619.84 | 620.25 | 85625.0 |
| 2025-11-13 08:00:00 | QQQ | ETF | 620.32 | 623.48 | 618.88 | 619.87 | 225529.0 |
| 2025-11-13 08:30:00 | QQQ | ETF | 619.8999 | 619.93 | 617.911 | 618.04 | 316238.0 |
| 2025-11-13 09:00:00 | QQQ | ETF | 618.04 | 618.3 | 616.56 | 617.57 | 469357.0 |
| 2025-11-13 09:30:00 | QQQ | ETF | 617.54 | 618.12 | 612.84 | 615.25 | 6143346.0 |
| 2025-11-13 10:00:00 | QQQ | ETF | 615.27 | 618.04 | 613.87 | 615.31 | 4233835.0 |
| 2025-11-13 10:30:00 | QQQ | ETF | 615.32 | 615.35 | 610.8 | 612.2901 | 4635683.0 |
| 2025-11-13 11:00:00 | QQQ | ETF | 612.3 | 612.77 | 610.42 | 611.46 | 3594702.0 |
| 2025-11-13 11:30:00 | QQQ | ETF | 611.45 | 612.41 | 609.88 | 610.68 | 3918504.0 |
| 2025-11-13 12:00:00 | QQQ | ETF | 610.61 | 612.01 | 609.68 | 611.67 | 3989143.0 |
| 2025-11-13 12:30:00 | QQQ | ETF | 611.64 | 612.18 | 609.05 | 609.32 | 2730665.0 |
> showing 50 of 45,686 rows — these rows as CSV