PREVIEW / etf_30min / 2025-03-24
file: by_date/etf_30min/2025/2025-03-24.parquet size: 975 KB rows: 40,388
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-03-24 04:00:00 | SPY | ETF | 568.27 | 570.38 | 567.35 | 570.15 | 54728.0 |
| 2025-03-24 04:30:00 | SPY | ETF | 570.17 | 570.41 | 569.98 | 570.28 | 10855.0 |
| 2025-03-24 05:00:00 | SPY | ETF | 570.25 | 570.5 | 569.96 | 570.01 | 16990.0 |
| 2025-03-24 05:30:00 | SPY | ETF | 569.94 | 570.12 | 569.51 | 569.96 | 18447.0 |
| 2025-03-24 06:00:00 | SPY | ETF | 569.83 | 570.44 | 569.77 | 570.44 | 27328.0 |
| 2025-03-24 06:30:00 | SPY | ETF | 570.44 | 570.82 | 570.44 | 570.63 | 39621.0 |
| 2025-03-24 07:00:00 | SPY | ETF | 570.55 | 571.2 | 570.36 | 571.09 | 224958.0 |
| 2025-03-24 07:30:00 | SPY | ETF | 570.99 | 571.23 | 570.69 | 570.98 | 178083.0 |
| 2025-03-24 08:00:00 | SPY | ETF | 570.74 | 571.2 | 567.9 | 571.1 | 244932.0 |
| 2025-03-24 08:30:00 | SPY | ETF | 571.11 | 571.52 | 571.03 | 571.1402 | 193980.0 |
| 2025-03-24 09:00:00 | SPY | ETF | 571.24 | 571.5 | 570.73 | 570.76 | 437834.0 |
| 2025-03-24 09:30:00 | SPY | ETF | 570.8 | 572.98 | 570.2 | 572.74 | 4804602.0 |
| 2025-03-24 10:00:00 | SPY | ETF | 572.735 | 573.34 | 572.01 | 573.13 | 2433048.0 |
| 2025-03-24 10:30:00 | SPY | ETF | 573.15 | 573.69 | 572.68 | 573.555 | 2338178.0 |
| 2025-03-24 11:00:00 | SPY | ETF | 573.55 | 573.99 | 573.11 | 573.71 | 1560976.0 |
| 2025-03-24 11:30:00 | SPY | ETF | 573.72 | 573.9199 | 573.14 | 573.8796 | 1333443.0 |
| 2025-03-24 12:00:00 | SPY | ETF | 573.87 | 574.39 | 573.22 | 573.25 | 1899355.0 |
| 2025-03-24 12:30:00 | SPY | ETF | 573.26 | 573.58 | 572.77 | 573.1292 | 1606391.0 |
| 2025-03-24 13:00:00 | SPY | ETF | 573.14 | 573.19 | 572.45 | 573.05 | 1499456.0 |
| 2025-03-24 13:30:00 | SPY | ETF | 573.05 | 573.375 | 572.78 | 573.0999 | 1309680.0 |
| 2025-03-24 14:00:00 | SPY | ETF | 573.1 | 573.13 | 572.05 | 572.405 | 1486179.0 |
| 2025-03-24 14:30:00 | SPY | ETF | 572.4 | 573.71 | 572.0747 | 573.635 | 2960747.0 |
| 2025-03-24 15:00:00 | SPY | ETF | 573.64 | 574.21 | 573.47 | 573.95 | 2084598.0 |
| 2025-03-24 15:30:00 | SPY | ETF | 573.96 | 575.15 | 573.84 | 574.02 | 7611337.0 |
| 2025-03-24 16:00:00 | SPY | ETF | 574.01 | 574.68 | 573.5134 | 574.36 | 6209368.0 |
| 2025-03-24 16:30:00 | SPY | ETF | 574.32 | 574.42 | 573.95 | 573.98 | 129578.0 |
| 2025-03-24 17:00:00 | SPY | ETF | 574.0673 | 574.08 | 573.95 | 574.0299 | 41126.0 |
| 2025-03-24 17:30:00 | SPY | ETF | 574.0194 | 574.13 | 574.0 | 574.09 | 16109.0 |
| 2025-03-24 18:00:00 | SPY | ETF | 574.05 | 574.0907 | 573.64 | 573.64 | 47231.0 |
| 2025-03-24 18:30:00 | SPY | ETF | 573.72 | 573.91 | 573.6 | 573.65 | 21784.0 |
| 2025-03-24 19:00:00 | SPY | ETF | 573.65 | 573.8 | 573.65 | 573.71 | 21974.0 |
| 2025-03-24 19:30:00 | SPY | ETF | 573.75 | 574.04 | 573.75 | 573.8282 | 46471.0 |
| 2025-03-24 04:00:00 | QQQ | ETF | 485.66 | 486.99 | 484.72 | 486.55 | 46135.0 |
| 2025-03-24 04:30:00 | QQQ | ETF | 486.51 | 486.99 | 486.37 | 486.75 | 37090.0 |
| 2025-03-24 05:00:00 | QQQ | ETF | 486.76 | 486.85 | 486.28 | 486.35 | 21897.0 |
| 2025-03-24 05:30:00 | QQQ | ETF | 486.23 | 486.43 | 485.95 | 486.24 | 32122.0 |
| 2025-03-24 06:00:00 | QQQ | ETF | 486.16 | 486.7 | 486.05 | 486.66 | 13923.0 |
| 2025-03-24 06:30:00 | QQQ | ETF | 486.68 | 487.1 | 486.65 | 486.77 | 33289.0 |
| 2025-03-24 07:00:00 | QQQ | ETF | 486.72 | 487.6 | 486.41 | 487.5 | 58016.0 |
| 2025-03-24 07:30:00 | QQQ | ETF | 487.44 | 487.83 | 487.12 | 487.7 | 80435.0 |
| 2025-03-24 08:00:00 | QQQ | ETF | 486.86 | 487.85 | 483.95 | 487.8402 | 290809.0 |
| 2025-03-24 08:30:00 | QQQ | ETF | 487.85 | 488.24 | 487.83 | 488.15 | 229321.0 |
| 2025-03-24 09:00:00 | QQQ | ETF | 488.18 | 488.47 | 487.7 | 487.73 | 316148.0 |
| 2025-03-24 09:30:00 | QQQ | ETF | 487.74 | 489.72 | 487.12 | 489.18 | 3906966.0 |
| 2025-03-24 10:00:00 | QQQ | ETF | 489.18 | 489.93 | 488.15 | 489.7108 | 1710612.0 |
| 2025-03-24 10:30:00 | QQQ | ETF | 489.75 | 490.24 | 489.22 | 489.97 | 1182655.0 |
| 2025-03-24 11:00:00 | QQQ | ETF | 489.9968 | 490.52 | 489.535 | 490.11 | 1280275.0 |
| 2025-03-24 11:30:00 | QQQ | ETF | 490.115 | 490.23 | 489.51 | 490.11 | 903875.0 |
| 2025-03-24 12:00:00 | QQQ | ETF | 490.11 | 490.725 | 489.6 | 489.69 | 1393117.0 |
| 2025-03-24 12:30:00 | QQQ | ETF | 489.76 | 490.25 | 489.2456 | 489.7799 | 756773.0 |
> showing 50 of 40,388 rows — these rows as CSV