PREVIEW / etf_30min / 2025-07-30
file: by_date/etf_30min/2025/2025-07-30.parquet size: 1014 KB rows: 41,825
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-07-30 04:00:00 | SPY | ETF | 636.04 | 636.3 | 635.7 | 635.7 | 10275.0 |
| 2025-07-30 04:30:00 | SPY | ETF | 635.59 | 635.79 | 635.29 | 635.77 | 4615.0 |
| 2025-07-30 05:00:00 | SPY | ETF | 635.78 | 636.04 | 635.65 | 635.84 | 8243.0 |
| 2025-07-30 05:30:00 | SPY | ETF | 635.76 | 635.98 | 635.6 | 635.98 | 2194.0 |
| 2025-07-30 06:00:00 | SPY | ETF | 636.05 | 636.1 | 635.9 | 635.96 | 10300.0 |
| 2025-07-30 06:30:00 | SPY | ETF | 635.98 | 636.11 | 635.94 | 636.11 | 5490.0 |
| 2025-07-30 07:00:00 | SPY | ETF | 636.16 | 636.29 | 636.0 | 636.2 | 78902.0 |
| 2025-07-30 07:30:00 | SPY | ETF | 636.22 | 636.5 | 636.01 | 636.21 | 114970.0 |
| 2025-07-30 08:00:00 | SPY | ETF | 636.12 | 636.39 | 635.37 | 635.7203 | 173341.0 |
| 2025-07-30 08:30:00 | SPY | ETF | 635.9 | 636.37 | 635.5 | 635.86 | 224078.0 |
| 2025-07-30 09:00:00 | SPY | ETF | 635.83 | 636.1 | 635.54 | 635.96 | 194719.0 |
| 2025-07-30 09:30:00 | SPY | ETF | 635.96 | 636.23 | 635.29 | 635.735 | 4179877.0 |
| 2025-07-30 10:00:00 | SPY | ETF | 635.735 | 636.665 | 635.39 | 636.33 | 2485177.0 |
| 2025-07-30 10:30:00 | SPY | ETF | 636.32 | 636.82 | 636.195 | 636.24 | 2078716.0 |
| 2025-07-30 11:00:00 | SPY | ETF | 636.23 | 636.36 | 635.0 | 635.315 | 2624705.0 |
| 2025-07-30 11:30:00 | SPY | ETF | 635.32 | 636.175 | 635.09 | 636.175 | 1617850.0 |
| 2025-07-30 12:00:00 | SPY | ETF | 636.16 | 636.72 | 635.99 | 636.58 | 2112209.0 |
| 2025-07-30 12:30:00 | SPY | ETF | 636.58 | 636.65 | 636.24 | 636.46 | 1282525.0 |
| 2025-07-30 13:00:00 | SPY | ETF | 636.47 | 636.66 | 636.145 | 636.21 | 1076630.0 |
| 2025-07-30 13:30:00 | SPY | ETF | 636.22 | 636.95 | 636.115 | 636.66 | 1657359.0 |
| 2025-07-30 14:00:00 | SPY | ETF | 636.705 | 637.11 | 636.01 | 636.77 | 2673287.0 |
| 2025-07-30 14:30:00 | SPY | ETF | 636.77 | 637.68 | 632.59 | 632.84 | 8149670.0 |
| 2025-07-30 15:00:00 | SPY | ETF | 632.83 | 633.99 | 631.54 | 632.0893 | 8759022.0 |
| 2025-07-30 15:30:00 | SPY | ETF | 632.09 | 634.635 | 631.61 | 634.49 | 10730644.0 |
| 2025-07-30 16:00:00 | SPY | ETF | 634.5 | 638.16 | 634.09 | 637.41 | 2921433.0 |
| 2025-07-30 16:30:00 | SPY | ETF | 637.42 | 637.52 | 637.12 | 637.28 | 860032.0 |
| 2025-07-30 17:00:00 | SPY | ETF | 637.28 | 637.75 | 637.2 | 637.4 | 125991.0 |
| 2025-07-30 17:30:00 | SPY | ETF | 637.6017 | 638.68 | 634.27 | 638.48 | 645415.0 |
| 2025-07-30 18:00:00 | SPY | ETF | 638.37 | 638.631 | 637.84 | 638.391 | 168508.0 |
| 2025-07-30 18:30:00 | SPY | ETF | 638.5 | 639.18 | 638.5 | 638.95 | 190122.0 |
| 2025-07-30 19:00:00 | SPY | ETF | 638.91 | 639.3 | 638.88 | 639.06 | 150190.0 |
| 2025-07-30 19:30:00 | SPY | ETF | 639.0 | 639.17 | 638.91 | 638.95 | 62487.0 |
| 2025-07-30 04:00:00 | QQQ | ETF | 568.44 | 568.71 | 567.96 | 567.99 | 13318.0 |
| 2025-07-30 04:30:00 | QQQ | ETF | 567.96 | 568.18 | 567.65 | 568.05 | 8290.0 |
| 2025-07-30 05:00:00 | QQQ | ETF | 568.15 | 568.43 | 568.14 | 568.19 | 10260.0 |
| 2025-07-30 05:30:00 | QQQ | ETF | 568.19 | 568.31 | 567.9 | 568.31 | 9603.0 |
| 2025-07-30 06:00:00 | QQQ | ETF | 568.4 | 568.6 | 568.24 | 568.4 | 10167.0 |
| 2025-07-30 06:30:00 | QQQ | ETF | 568.39 | 568.65 | 568.36 | 568.63 | 25552.0 |
| 2025-07-30 07:00:00 | QQQ | ETF | 568.67 | 568.83 | 568.5 | 568.79 | 20535.0 |
| 2025-07-30 07:30:00 | QQQ | ETF | 568.86 | 569.0 | 568.56 | 568.68 | 49399.0 |
| 2025-07-30 08:00:00 | QQQ | ETF | 568.65 | 568.98 | 566.835 | 568.1 | 127911.0 |
| 2025-07-30 08:30:00 | QQQ | ETF | 568.05 | 568.6 | 567.86 | 568.28 | 133862.0 |
| 2025-07-30 09:00:00 | QQQ | ETF | 568.24 | 568.28 | 567.8 | 568.14 | 48281.0 |
| 2025-07-30 09:30:00 | QQQ | ETF | 568.18 | 569.11 | 567.27 | 568.06 | 3251718.0 |
| 2025-07-30 10:00:00 | QQQ | ETF | 568.06 | 569.0 | 567.67 | 568.57 | 1512391.0 |
| 2025-07-30 10:30:00 | QQQ | ETF | 568.58 | 569.468 | 568.58 | 568.8493 | 1330304.0 |
| 2025-07-30 11:00:00 | QQQ | ETF | 568.835 | 569.0901 | 567.875 | 568.17 | 1213611.0 |
| 2025-07-30 11:30:00 | QQQ | ETF | 568.18 | 569.21 | 567.91 | 569.2 | 886440.0 |
| 2025-07-30 12:00:00 | QQQ | ETF | 569.195 | 569.6 | 568.9 | 569.33 | 856047.0 |
| 2025-07-30 12:30:00 | QQQ | ETF | 569.335 | 569.49 | 568.94 | 569.3 | 536889.0 |
> showing 50 of 41,825 rows — these rows as CSV