PREVIEW / etf_30min / 2026-03-20
file: by_date/etf_30min/2026/2026-03-20.parquet size: 968 KB rows: 41,982
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-03-20 04:00:00 | SPY | ETF | 659.2 | 659.81 | 658.66 | 658.66 | 23514.0 |
| 2026-03-20 04:30:00 | SPY | ETF | 658.52 | 659.49 | 658.42 | 658.69 | 26377.0 |
| 2026-03-20 05:00:00 | SPY | ETF | 658.57 | 659.1 | 657.04 | 657.14 | 52824.0 |
| 2026-03-20 05:30:00 | SPY | ETF | 657.0 | 657.66 | 655.15 | 655.58 | 83678.0 |
| 2026-03-20 06:00:00 | SPY | ETF | 655.67 | 655.71 | 653.2 | 653.76 | 145430.0 |
| 2026-03-20 06:30:00 | SPY | ETF | 654.1 | 655.54 | 654.1 | 654.74 | 145704.0 |
| 2026-03-20 07:00:00 | SPY | ETF | 654.78 | 656.31 | 654.59 | 655.82 | 207220.0 |
| 2026-03-20 07:30:00 | SPY | ETF | 655.88 | 656.1 | 654.84 | 655.77 | 331516.0 |
| 2026-03-20 08:00:00 | SPY | ETF | 655.75 | 659.75 | 653.26 | 656.6 | 382280.0 |
| 2026-03-20 08:30:00 | SPY | ETF | 656.62 | 656.79 | 655.43 | 656.6 | 369139.0 |
| 2026-03-20 09:00:00 | SPY | ETF | 656.66 | 657.05 | 655.73 | 656.56 | 372061.0 |
| 2026-03-20 09:30:00 | SPY | ETF | 656.51 | 656.69 | 653.0 | 653.15 | 9653173.0 |
| 2026-03-20 10:00:00 | SPY | ETF | 653.17 | 653.8111 | 651.48 | 651.86 | 7086139.0 |
| 2026-03-20 10:30:00 | SPY | ETF | 651.86 | 653.5 | 651.2 | 652.12 | 5343129.0 |
| 2026-03-20 11:00:00 | SPY | ETF | 652.11 | 654.16 | 651.5 | 651.92 | 5314800.0 |
| 2026-03-20 11:30:00 | SPY | ETF | 651.94 | 653.26 | 651.73 | 652.945 | 3049435.0 |
| 2026-03-20 12:00:00 | SPY | ETF | 652.97 | 653.99 | 652.78 | 653.1 | 3652362.0 |
| 2026-03-20 12:30:00 | SPY | ETF | 653.1 | 653.4 | 651.95 | 652.77 | 3326314.0 |
| 2026-03-20 13:00:00 | SPY | ETF | 652.76 | 653.25 | 651.75 | 652.16 | 3552334.0 |
| 2026-03-20 13:30:00 | SPY | ETF | 652.19 | 652.37 | 650.55 | 651.4 | 4382926.0 |
| 2026-03-20 14:00:00 | SPY | ETF | 651.41 | 651.695 | 648.66 | 649.43 | 8128764.0 |
| 2026-03-20 14:30:00 | SPY | ETF | 649.43 | 649.655 | 647.64 | 648.07 | 7859171.0 |
| 2026-03-20 15:00:00 | SPY | ETF | 648.08 | 648.645 | 646.78 | 647.12 | 8760357.0 |
| 2026-03-20 15:30:00 | SPY | ETF | 647.13 | 648.54 | 644.72 | 648.54 | 22552735.0 |
| 2026-03-20 16:00:00 | SPY | ETF | 648.51 | 650.11 | 647.14 | 649.32 | 7915571.0 |
| 2026-03-20 16:30:00 | SPY | ETF | 649.32 | 656.8393 | 649.21 | 650.97 | 2509618.0 |
| 2026-03-20 17:00:00 | SPY | ETF | 650.97 | 655.0 | 650.09 | 653.11 | 2338532.0 |
| 2026-03-20 17:30:00 | SPY | ETF | 653.11 | 654.51 | 652.41 | 654.36 | 1125248.0 |
| 2026-03-20 18:00:00 | SPY | ETF | 654.35 | 655.45 | 653.9 | 653.99 | 504826.0 |
| 2026-03-20 18:30:00 | SPY | ETF | 654.0 | 654.68 | 653.0 | 654.25 | 241068.0 |
| 2026-03-20 19:00:00 | SPY | ETF | 654.25 | 654.32 | 653.55 | 653.6 | 121940.0 |
| 2026-03-20 19:30:00 | SPY | ETF | 653.65 | 653.85 | 653.25 | 653.28 | 159162.0 |
| 2026-03-20 04:00:00 | QQQ | ETF | 593.87 | 594.2 | 593.05 | 593.05 | 60313.0 |
| 2026-03-20 04:30:00 | QQQ | ETF | 593.01 | 593.89 | 592.78 | 592.85 | 62266.0 |
| 2026-03-20 05:00:00 | QQQ | ETF | 592.83 | 593.44 | 591.32 | 591.49 | 86852.0 |
| 2026-03-20 05:30:00 | QQQ | ETF | 591.42 | 591.89 | 589.23 | 589.74 | 197127.0 |
| 2026-03-20 06:00:00 | QQQ | ETF | 589.91 | 589.94 | 587.06 | 588.04 | 197952.0 |
| 2026-03-20 06:30:00 | QQQ | ETF | 588.18 | 589.75 | 588.16 | 589.16 | 140320.0 |
| 2026-03-20 07:00:00 | QQQ | ETF | 589.2 | 590.64 | 588.97 | 590.24 | 224612.0 |
| 2026-03-20 07:30:00 | QQQ | ETF | 590.25 | 590.52 | 589.29 | 590.05 | 126002.0 |
| 2026-03-20 08:00:00 | QQQ | ETF | 590.08 | 594.3 | 587.19 | 591.2 | 511122.0 |
| 2026-03-20 08:30:00 | QQQ | ETF | 591.2 | 591.4 | 590.0 | 591.26 | 251585.0 |
| 2026-03-20 09:00:00 | QQQ | ETF | 591.33 | 592.04 | 590.4042 | 591.13 | 306835.0 |
| 2026-03-20 09:30:00 | QQQ | ETF | 591.1 | 591.17 | 586.16 | 586.3 | 7651616.0 |
| 2026-03-20 10:00:00 | QQQ | ETF | 586.3 | 587.34 | 585.235 | 585.945 | 6059680.0 |
| 2026-03-20 10:30:00 | QQQ | ETF | 585.97 | 587.28 | 584.97 | 585.9 | 5377497.0 |
| 2026-03-20 11:00:00 | QQQ | ETF | 585.8987 | 587.63 | 585.1 | 585.75 | 4494977.0 |
| 2026-03-20 11:30:00 | QQQ | ETF | 585.78 | 587.14 | 585.54 | 586.91 | 2356708.0 |
| 2026-03-20 12:00:00 | QQQ | ETF | 586.91 | 587.94 | 586.65 | 586.745 | 3193427.0 |
| 2026-03-20 12:30:00 | QQQ | ETF | 586.75 | 586.75 | 585.08 | 585.94 | 2878910.0 |
> showing 50 of 41,982 rows — these rows as CSV