PREVIEW / etf_30min / 2026-03-18
file: by_date/etf_30min/2026/2026-03-18.parquet size: 968 KB rows: 40,996
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-18 04:00:00 | SPY | ETF | 673.5 | 674.63 | 673.5 | 674.0 | 29166.0 |
| 2026-03-18 04:30:00 | SPY | ETF | 674.02 | 674.4 | 673.81 | 674.18 | 9673.0 |
| 2026-03-18 05:00:00 | SPY | ETF | 674.3 | 674.54 | 673.89 | 674.29 | 11677.0 |
| 2026-03-18 05:30:00 | SPY | ETF | 674.35 | 674.54 | 674.07 | 674.23 | 11526.0 |
| 2026-03-18 06:00:00 | SPY | ETF | 674.18 | 674.7 | 674.0 | 674.54 | 35297.0 |
| 2026-03-18 06:30:00 | SPY | ETF | 674.44 | 674.67 | 673.86 | 673.86 | 11404.0 |
| 2026-03-18 07:00:00 | SPY | ETF | 673.89 | 674.25 | 672.5 | 672.5 | 214226.0 |
| 2026-03-18 07:30:00 | SPY | ETF | 672.4 | 673.73 | 672.39 | 672.86 | 227063.0 |
| 2026-03-18 08:00:00 | SPY | ETF | 674.38 | 674.93 | 670.39 | 671.08 | 659107.0 |
| 2026-03-18 08:30:00 | SPY | ETF | 671.04 | 671.04 | 667.06 | 667.3896 | 1798330.0 |
| 2026-03-18 09:00:00 | SPY | ETF | 667.42 | 668.66 | 666.9 | 668.3 | 558368.0 |
| 2026-03-18 09:30:00 | SPY | ETF | 668.33 | 669.72 | 667.88 | 669.28 | 6878029.0 |
| 2026-03-18 10:00:00 | SPY | ETF | 669.28 | 669.41 | 665.72 | 665.96 | 4680468.0 |
| 2026-03-18 10:30:00 | SPY | ETF | 665.97 | 667.155 | 665.66 | 667.14 | 3796956.0 |
| 2026-03-18 11:00:00 | SPY | ETF | 667.13 | 668.0 | 666.4 | 666.9342 | 3255346.0 |
| 2026-03-18 11:30:00 | SPY | ETF | 666.91 | 667.62 | 666.67 | 667.04 | 2367160.0 |
| 2026-03-18 12:00:00 | SPY | ETF | 667.03 | 667.58 | 666.4918 | 667.07 | 1859977.0 |
| 2026-03-18 12:30:00 | SPY | ETF | 667.07 | 667.296 | 665.83 | 666.55 | 2105492.0 |
| 2026-03-18 13:00:00 | SPY | ETF | 666.54 | 666.63 | 665.43 | 665.84 | 2462947.0 |
| 2026-03-18 13:30:00 | SPY | ETF | 665.84 | 666.87 | 665.29 | 666.72 | 2847416.0 |
| 2026-03-18 14:00:00 | SPY | ETF | 666.71 | 667.44 | 665.38 | 666.12 | 3759906.0 |
| 2026-03-18 14:30:00 | SPY | ETF | 666.11 | 666.3 | 663.32 | 663.41 | 6242051.0 |
| 2026-03-18 15:00:00 | SPY | ETF | 663.4 | 664.72 | 662.68 | 662.91 | 6223088.0 |
| 2026-03-18 15:30:00 | SPY | ETF | 662.9 | 663.2192 | 661.19 | 661.51 | 12702676.0 |
| 2026-03-18 16:00:00 | SPY | ETF | 661.54 | 661.9 | 659.37 | 659.77 | 5849533.0 |
| 2026-03-18 16:30:00 | SPY | ETF | 659.77 | 660.73 | 659.77 | 660.27 | 584859.0 |
| 2026-03-18 17:00:00 | SPY | ETF | 660.31 | 661.47 | 660.2641 | 661.0352 | 337355.0 |
| 2026-03-18 17:30:00 | SPY | ETF | 661.0798 | 661.4098 | 661.0 | 661.2 | 64597.0 |
| 2026-03-18 18:00:00 | SPY | ETF | 661.2 | 661.2 | 659.861 | 659.9 | 153064.0 |
| 2026-03-18 18:30:00 | SPY | ETF | 659.91 | 660.27 | 659.63 | 660.26 | 66161.0 |
| 2026-03-18 19:00:00 | SPY | ETF | 660.21 | 660.99 | 660.19 | 660.97 | 57944.0 |
| 2026-03-18 19:30:00 | SPY | ETF | 660.96 | 661.4 | 660.41 | 660.9114 | 120353.0 |
| 2026-03-18 04:00:00 | QQQ | ETF | 607.47 | 607.64 | 606.02 | 607.08 | 94103.0 |
| 2026-03-18 04:30:00 | QQQ | ETF | 607.05 | 607.52 | 606.92 | 607.35 | 31029.0 |
| 2026-03-18 05:00:00 | QQQ | ETF | 607.3 | 607.76 | 607.03 | 607.67 | 32047.0 |
| 2026-03-18 05:30:00 | QQQ | ETF | 607.66 | 607.78 | 607.25 | 607.31 | 26095.0 |
| 2026-03-18 06:00:00 | QQQ | ETF | 607.31 | 607.96 | 607.2 | 607.77 | 50027.0 |
| 2026-03-18 06:30:00 | QQQ | ETF | 607.72 | 607.93 | 607.07 | 607.1 | 25250.0 |
| 2026-03-18 07:00:00 | QQQ | ETF | 607.08 | 607.43 | 605.74 | 605.74 | 103064.0 |
| 2026-03-18 07:30:00 | QQQ | ETF | 605.71 | 606.77 | 605.6 | 605.91 | 106117.0 |
| 2026-03-18 08:00:00 | QQQ | ETF | 607.61 | 608.22 | 602.858 | 603.82 | 646232.0 |
| 2026-03-18 08:30:00 | QQQ | ETF | 603.76 | 603.76 | 600.1 | 600.3241 | 1100824.0 |
| 2026-03-18 09:00:00 | QQQ | ETF | 600.41 | 601.69 | 599.96 | 601.49 | 516880.0 |
| 2026-03-18 09:30:00 | QQQ | ETF | 601.49 | 603.16 | 600.93 | 602.4799 | 5365141.0 |
| 2026-03-18 10:00:00 | QQQ | ETF | 602.45 | 602.79 | 598.71 | 598.97 | 3919616.0 |
| 2026-03-18 10:30:00 | QQQ | ETF | 598.96 | 600.42 | 598.84 | 600.4 | 3225030.0 |
| 2026-03-18 11:00:00 | QQQ | ETF | 600.41 | 601.55 | 599.87 | 600.53 | 3421316.0 |
| 2026-03-18 11:30:00 | QQQ | ETF | 600.53 | 601.2 | 600.25 | 600.78 | 2295809.0 |
| 2026-03-18 12:00:00 | QQQ | ETF | 600.77 | 601.07 | 599.9901 | 600.5 | 1816255.0 |
| 2026-03-18 12:30:00 | QQQ | ETF | 600.48 | 600.67 | 599.14 | 599.48 | 1866858.0 |
> showing 50 of 40,996 rows — these rows as CSV