PREVIEW / etf_30min / 2026-04-30
file: by_date/etf_30min/2026/2026-04-30.parquet size: 1.1 MB rows: 46,709
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 |
|---|---|---|---|---|---|---|---|
| 2026-04-30 04:00:00 | SPY | ETF | 711.48 | 711.89 | 708.2 | 711.26 | 131883.0 |
| 2026-04-30 04:30:00 | SPY | ETF | 711.41 | 711.75 | 711.15 | 711.28 | 24216.0 |
| 2026-04-30 05:00:00 | SPY | ETF | 711.27 | 712.0 | 710.64 | 712.0 | 51562.0 |
| 2026-04-30 05:30:00 | SPY | ETF | 712.0 | 713.14 | 711.71 | 711.93 | 35207.0 |
| 2026-04-30 06:00:00 | SPY | ETF | 711.93 | 712.95 | 711.93 | 712.82 | 48625.0 |
| 2026-04-30 06:30:00 | SPY | ETF | 712.96 | 713.35 | 712.2 | 712.65 | 81315.0 |
| 2026-04-30 07:00:00 | SPY | ETF | 712.8283 | 714.66 | 712.67 | 714.6 | 194342.0 |
| 2026-04-30 07:30:00 | SPY | ETF | 714.58 | 714.6 | 713.78 | 714.0512 | 250971.0 |
| 2026-04-30 08:00:00 | SPY | ETF | 714.1 | 715.8 | 711.58 | 715.52 | 201593.0 |
| 2026-04-30 08:30:00 | SPY | ETF | 715.63 | 715.65 | 714.38 | 715.07 | 219791.0 |
| 2026-04-30 09:00:00 | SPY | ETF | 715.02 | 715.58 | 714.61 | 714.74 | 193939.0 |
| 2026-04-30 09:30:00 | SPY | ETF | 714.63 | 714.73 | 710.78 | 711.27 | 5247977.0 |
| 2026-04-30 10:00:00 | SPY | ETF | 711.26 | 712.34 | 710.445 | 712.01 | 3546859.0 |
| 2026-04-30 10:30:00 | SPY | ETF | 712.01 | 714.16 | 711.18 | 713.87 | 2528736.0 |
| 2026-04-30 11:00:00 | SPY | ETF | 713.87 | 714.59 | 713.55 | 714.43 | 1987624.0 |
| 2026-04-30 11:30:00 | SPY | ETF | 714.41 | 715.07 | 713.47 | 714.6 | 1657483.0 |
| 2026-04-30 12:00:00 | SPY | ETF | 714.6 | 715.39 | 714.07 | 715.18 | 1355949.0 |
| 2026-04-30 12:30:00 | SPY | ETF | 715.18 | 715.33 | 713.9 | 714.3474 | 1362543.0 |
| 2026-04-30 13:00:00 | SPY | ETF | 714.35 | 715.89 | 714.325 | 715.81 | 1251812.0 |
| 2026-04-30 13:30:00 | SPY | ETF | 715.82 | 717.16 | 715.82 | 717.0601 | 1520431.0 |
| 2026-04-30 14:00:00 | SPY | ETF | 717.08 | 718.11 | 717.03 | 717.88 | 2272860.0 |
| 2026-04-30 14:30:00 | SPY | ETF | 717.9 | 718.82 | 717.87 | 718.37 | 2374288.0 |
| 2026-04-30 15:00:00 | SPY | ETF | 718.36 | 719.43 | 718.28 | 719.12 | 2441759.0 |
| 2026-04-30 15:30:00 | SPY | ETF | 719.11 | 719.79 | 718.35 | 718.43 | 10574688.0 |
| 2026-04-30 16:00:00 | SPY | ETF | 718.42 | 719.68 | 718.42 | 719.49 | 4154398.0 |
| 2026-04-30 16:30:00 | SPY | ETF | 719.41 | 719.8 | 718.66 | 719.28 | 512093.0 |
| 2026-04-30 17:00:00 | SPY | ETF | 719.15 | 719.15 | 718.2 | 718.48 | 214419.0 |
| 2026-04-30 17:30:00 | SPY | ETF | 718.48 | 720.3 | 718.48 | 720.05 | 392732.0 |
| 2026-04-30 18:00:00 | SPY | ETF | 720.05 | 720.82 | 719.83 | 720.3 | 163382.0 |
| 2026-04-30 18:30:00 | SPY | ETF | 720.29 | 720.3 | 719.3 | 719.5 | 57490.0 |
| 2026-04-30 19:00:00 | SPY | ETF | 719.5594 | 720.02 | 719.5 | 719.95 | 16746.0 |
| 2026-04-30 19:30:00 | SPY | ETF | 719.98 | 720.25 | 719.6 | 719.87 | 30638.0 |
| 2026-04-30 04:00:00 | QQQ | ETF | 664.0 | 664.0 | 658.17 | 662.3697 | 232178.0 |
| 2026-04-30 04:30:00 | QQQ | ETF | 662.45 | 663.13 | 662.31 | 662.38 | 63650.0 |
| 2026-04-30 05:00:00 | QQQ | ETF | 662.49 | 663.14 | 661.67 | 663.14 | 56737.0 |
| 2026-04-30 05:30:00 | QQQ | ETF | 663.15 | 664.25 | 662.24 | 662.71 | 77600.0 |
| 2026-04-30 06:00:00 | QQQ | ETF | 662.61 | 663.8405 | 662.5649 | 663.6 | 45663.0 |
| 2026-04-30 06:30:00 | QQQ | ETF | 663.77 | 664.07 | 662.23 | 662.67 | 125870.0 |
| 2026-04-30 07:00:00 | QQQ | ETF | 662.61 | 665.44 | 662.6 | 665.44 | 165764.0 |
| 2026-04-30 07:30:00 | QQQ | ETF | 665.41 | 665.52 | 664.13 | 664.26 | 257975.0 |
| 2026-04-30 08:00:00 | QQQ | ETF | 664.28 | 666.6 | 661.074 | 666.51 | 192016.0 |
| 2026-04-30 08:30:00 | QQQ | ETF | 666.74 | 666.75 | 663.49 | 666.25 | 227528.0 |
| 2026-04-30 09:00:00 | QQQ | ETF | 666.25 | 666.619 | 665.34 | 665.36 | 266941.0 |
| 2026-04-30 09:30:00 | QQQ | ETF | 665.39 | 665.415 | 658.6 | 659.58 | 5125564.0 |
| 2026-04-30 10:00:00 | QQQ | ETF | 659.6 | 660.95 | 657.56 | 659.13 | 3042630.0 |
| 2026-04-30 10:30:00 | QQQ | ETF | 659.07 | 662.7 | 657.77 | 662.29 | 2823653.0 |
| 2026-04-30 11:00:00 | QQQ | ETF | 662.32 | 663.6697 | 662.24 | 663.375 | 1732042.0 |
| 2026-04-30 11:30:00 | QQQ | ETF | 663.39 | 664.19 | 661.64 | 662.965 | 1464071.0 |
| 2026-04-30 12:00:00 | QQQ | ETF | 662.99 | 664.1 | 662.27 | 663.65 | 788570.0 |
| 2026-04-30 12:30:00 | QQQ | ETF | 663.67 | 663.87 | 662.03 | 662.53 | 1126221.0 |
> showing 50 of 46,709 rows — these rows as CSV