PREVIEW / etf_30min / 2026-03-09
file: by_date/etf_30min/2026/2026-03-09.parquet size: 1.1 MB rows: 50,397
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-09 04:00:00 | SPY | ETF | 662.47 | 665.28 | 661.72 | 663.02 | 245487.0 |
| 2026-03-09 04:30:00 | SPY | ETF | 663.2 | 664.33 | 662.75 | 663.93 | 56881.0 |
| 2026-03-09 05:00:00 | SPY | ETF | 664.08 | 666.6 | 663.27 | 666.29 | 73181.0 |
| 2026-03-09 05:30:00 | SPY | ETF | 666.39 | 668.36 | 665.7 | 666.42 | 261669.0 |
| 2026-03-09 06:00:00 | SPY | ETF | 666.65 | 666.86 | 665.08 | 665.2 | 106764.0 |
| 2026-03-09 06:30:00 | SPY | ETF | 665.1 | 666.04 | 664.43 | 665.07 | 90105.0 |
| 2026-03-09 07:00:00 | SPY | ETF | 665.0 | 666.0 | 664.38 | 664.59 | 192497.0 |
| 2026-03-09 07:30:00 | SPY | ETF | 664.61 | 666.01 | 664.52 | 665.1 | 135952.0 |
| 2026-03-09 08:00:00 | SPY | ETF | 665.09 | 668.0875 | 659.24 | 667.22 | 649583.0 |
| 2026-03-09 08:30:00 | SPY | ETF | 667.12 | 667.29 | 664.49 | 665.3 | 316428.0 |
| 2026-03-09 09:00:00 | SPY | ETF | 665.32 | 666.71 | 665.2 | 666.38 | 513561.0 |
| 2026-03-09 09:30:00 | SPY | ETF | 666.39 | 667.63 | 662.7 | 664.08 | 9652882.0 |
| 2026-03-09 10:00:00 | SPY | ETF | 664.05 | 665.96 | 662.39 | 664.06 | 7223157.0 |
| 2026-03-09 10:30:00 | SPY | ETF | 664.03 | 668.31 | 663.98 | 667.58 | 5493689.0 |
| 2026-03-09 11:00:00 | SPY | ETF | 667.58 | 669.92 | 667.58 | 669.77 | 4993745.0 |
| 2026-03-09 11:30:00 | SPY | ETF | 669.77 | 669.89 | 668.37 | 669.44 | 3967028.0 |
| 2026-03-09 12:00:00 | SPY | ETF | 669.46 | 671.6 | 669.1699 | 670.87 | 4087533.0 |
| 2026-03-09 12:30:00 | SPY | ETF | 670.87 | 672.25 | 669.89 | 671.2699 | 4153431.0 |
| 2026-03-09 13:00:00 | SPY | ETF | 671.275 | 671.36 | 668.71 | 668.845 | 3899712.0 |
| 2026-03-09 13:30:00 | SPY | ETF | 668.84 | 669.34 | 668.09 | 668.815 | 3519114.0 |
| 2026-03-09 14:00:00 | SPY | ETF | 668.84 | 670.87 | 668.77 | 670.06 | 3944382.0 |
| 2026-03-09 14:30:00 | SPY | ETF | 670.06 | 671.3 | 669.9378 | 670.08 | 3584247.0 |
| 2026-03-09 15:00:00 | SPY | ETF | 670.1 | 677.515 | 669.9 | 677.39 | 10840491.0 |
| 2026-03-09 15:30:00 | SPY | ETF | 677.37 | 679.92 | 675.88 | 678.31 | 14146161.0 |
| 2026-03-09 16:00:00 | SPY | ETF | 678.3 | 679.0 | 676.28 | 677.5 | 4163585.0 |
| 2026-03-09 16:30:00 | SPY | ETF | 677.32 | 678.177 | 676.81 | 677.52 | 653182.0 |
| 2026-03-09 17:00:00 | SPY | ETF | 677.7 | 677.93 | 677.4 | 677.65 | 88583.0 |
| 2026-03-09 17:30:00 | SPY | ETF | 677.69 | 677.69 | 676.86 | 677.62 | 158923.0 |
| 2026-03-09 18:00:00 | SPY | ETF | 677.69 | 678.0 | 675.53 | 676.98 | 446002.0 |
| 2026-03-09 18:30:00 | SPY | ETF | 676.87 | 676.87 | 675.66 | 675.9896 | 82692.0 |
| 2026-03-09 19:00:00 | SPY | ETF | 675.91 | 676.4182 | 675.68 | 676.1302 | 27517.0 |
| 2026-03-09 19:30:00 | SPY | ETF | 676.12 | 676.187 | 674.72 | 675.3392 | 91928.0 |
| 2026-03-09 04:00:00 | QQQ | ETF | 590.51 | 591.48 | 589.1 | 590.51 | 174728.0 |
| 2026-03-09 04:30:00 | QQQ | ETF | 590.52 | 591.86 | 590.33 | 591.32 | 120003.0 |
| 2026-03-09 05:00:00 | QQQ | ETF | 591.34 | 594.09 | 590.69 | 593.73 | 148875.0 |
| 2026-03-09 05:30:00 | QQQ | ETF | 593.72 | 595.74 | 593.03 | 593.83 | 214021.0 |
| 2026-03-09 06:00:00 | QQQ | ETF | 594.05 | 594.22 | 592.75 | 592.92 | 172879.0 |
| 2026-03-09 06:30:00 | QQQ | ETF | 592.98 | 593.82 | 592.1 | 592.82 | 115114.0 |
| 2026-03-09 07:00:00 | QQQ | ETF | 592.75 | 593.77 | 592.3 | 592.51 | 123043.0 |
| 2026-03-09 07:30:00 | QQQ | ETF | 592.59 | 594.0 | 592.43 | 593.01 | 105967.0 |
| 2026-03-09 08:00:00 | QQQ | ETF | 592.92 | 595.75 | 585.87 | 594.7487 | 736186.0 |
| 2026-03-09 08:30:00 | QQQ | ETF | 594.76 | 594.83 | 592.29 | 592.92 | 276030.0 |
| 2026-03-09 09:00:00 | QQQ | ETF | 592.98 | 594.53 | 592.86 | 594.24 | 437800.0 |
| 2026-03-09 09:30:00 | QQQ | ETF | 594.2 | 596.47 | 591.33 | 592.72 | 9765488.0 |
| 2026-03-09 10:00:00 | QQQ | ETF | 592.71 | 595.27 | 591.56 | 593.47 | 7833387.0 |
| 2026-03-09 10:30:00 | QQQ | ETF | 593.44 | 597.88 | 593.37 | 597.05 | 5779325.0 |
| 2026-03-09 11:00:00 | QQQ | ETF | 597.03 | 599.48 | 597.03 | 599.32 | 4185454.0 |
| 2026-03-09 11:30:00 | QQQ | ETF | 599.33 | 599.67 | 598.07 | 599.31 | 3577952.0 |
| 2026-03-09 12:00:00 | QQQ | ETF | 599.31 | 601.35 | 599.04 | 600.45 | 3629405.0 |
| 2026-03-09 12:30:00 | QQQ | ETF | 600.45 | 601.85 | 599.53 | 600.88 | 3313731.0 |
> showing 50 of 50,397 rows — these rows as CSV