PREVIEW / etf_30min / 2025-02-21
file: by_date/etf_30min/2025/2025-02-21.parquet size: 976 KB rows: 39,446
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-02-21 04:00:00 | SPY | ETF | 610.3 | 610.6 | 610.3 | 610.45 | 2464.0 |
| 2025-02-21 04:30:00 | SPY | ETF | 610.69 | 610.71 | 610.65 | 610.7 | 3043.0 |
| 2025-02-21 05:00:00 | SPY | ETF | 610.63 | 610.8 | 610.56 | 610.77 | 3711.0 |
| 2025-02-21 05:30:00 | SPY | ETF | 610.72 | 610.72 | 610.56 | 610.68 | 3987.0 |
| 2025-02-21 06:00:00 | SPY | ETF | 610.77 | 610.82 | 610.72 | 610.72 | 11482.0 |
| 2025-02-21 06:30:00 | SPY | ETF | 610.78 | 610.78 | 610.5 | 610.66 | 5919.0 |
| 2025-02-21 07:00:00 | SPY | ETF | 610.59 | 611.08 | 610.2 | 610.94 | 27026.0 |
| 2025-02-21 07:30:00 | SPY | ETF | 610.94 | 611.02 | 610.86 | 610.96 | 15852.0 |
| 2025-02-21 08:00:00 | SPY | ETF | 610.29 | 611.05 | 609.89 | 610.86 | 68918.0 |
| 2025-02-21 08:30:00 | SPY | ETF | 610.88 | 611.1 | 610.73 | 610.9699 | 93108.0 |
| 2025-02-21 09:00:00 | SPY | ETF | 610.9 | 611.17 | 610.15 | 610.16 | 141556.0 |
| 2025-02-21 09:30:00 | SPY | ETF | 610.17 | 610.3 | 608.24 | 608.4701 | 2885258.0 |
| 2025-02-21 10:00:00 | SPY | ETF | 608.5 | 608.65 | 606.52 | 606.76 | 2998102.0 |
| 2025-02-21 10:30:00 | SPY | ETF | 606.75 | 607.06 | 605.766 | 606.8399 | 1872214.0 |
| 2025-02-21 11:00:00 | SPY | ETF | 606.84 | 607.48 | 606.18 | 606.94 | 1596707.0 |
| 2025-02-21 11:30:00 | SPY | ETF | 606.95 | 607.5 | 606.31 | 606.805 | 1402228.0 |
| 2025-02-21 12:00:00 | SPY | ETF | 606.8 | 607.1292 | 605.16 | 605.7199 | 1435262.0 |
| 2025-02-21 12:30:00 | SPY | ETF | 605.755 | 605.79 | 603.62 | 603.82 | 2095740.0 |
| 2025-02-21 13:00:00 | SPY | ETF | 603.83 | 603.8493 | 602.1001 | 602.16 | 3432828.0 |
| 2025-02-21 13:30:00 | SPY | ETF | 602.145 | 603.225 | 601.57 | 601.7535 | 2366857.0 |
| 2025-02-21 14:00:00 | SPY | ETF | 601.76 | 602.33 | 599.65 | 599.91 | 3008292.0 |
| 2025-02-21 14:30:00 | SPY | ETF | 599.9099 | 600.66 | 599.47 | 600.035 | 2824867.0 |
| 2025-02-21 15:00:00 | SPY | ETF | 600.03 | 600.64 | 599.66 | 600.56 | 2717732.0 |
| 2025-02-21 15:30:00 | SPY | ETF | 600.58 | 600.91 | 599.5 | 600.0 | 7486309.0 |
| 2025-02-21 16:00:00 | SPY | ETF | 600.0 | 600.4 | 599.75 | 600.21 | 4389935.0 |
| 2025-02-21 16:30:00 | SPY | ETF | 600.2 | 600.31 | 599.85 | 599.94 | 196626.0 |
| 2025-02-21 17:00:00 | SPY | ETF | 599.97 | 600.15 | 599.89 | 599.98 | 126668.0 |
| 2025-02-21 17:30:00 | SPY | ETF | 600.1399 | 600.33 | 599.88 | 600.33 | 585564.0 |
| 2025-02-21 18:00:00 | SPY | ETF | 600.32 | 600.35 | 600.3 | 600.32 | 17939.0 |
| 2025-02-21 18:30:00 | SPY | ETF | 600.29 | 600.3 | 600.05 | 600.11 | 22659.0 |
| 2025-02-21 19:00:00 | SPY | ETF | 600.1 | 600.38 | 600.05 | 600.19 | 11061.0 |
| 2025-02-21 19:30:00 | SPY | ETF | 600.17 | 600.2993 | 600.05 | 600.24 | 31862.0 |
| 2025-02-21 04:00:00 | QQQ | ETF | 537.49 | 537.71 | 537.33 | 537.69 | 15059.0 |
| 2025-02-21 04:30:00 | QQQ | ETF | 537.65 | 537.95 | 537.65 | 537.92 | 5627.0 |
| 2025-02-21 05:00:00 | QQQ | ETF | 537.94 | 538.12 | 537.75 | 538.0 | 4172.0 |
| 2025-02-21 05:30:00 | QQQ | ETF | 537.99 | 537.99 | 537.75 | 537.94 | 4473.0 |
| 2025-02-21 06:00:00 | QQQ | ETF | 538.0 | 538.04 | 537.89 | 537.89 | 5213.0 |
| 2025-02-21 06:30:00 | QQQ | ETF | 537.97 | 537.97 | 537.62 | 537.84 | 4369.0 |
| 2025-02-21 07:00:00 | QQQ | ETF | 537.85 | 538.92 | 537.77 | 538.83 | 56648.0 |
| 2025-02-21 07:30:00 | QQQ | ETF | 538.86 | 539.16 | 538.76 | 539.1 | 30147.0 |
| 2025-02-21 08:00:00 | QQQ | ETF | 537.97 | 539.42 | 536.69 | 539.15 | 155366.0 |
| 2025-02-21 08:30:00 | QQQ | ETF | 539.16 | 540.0 | 539.08 | 539.33 | 69613.0 |
| 2025-02-21 09:00:00 | QQQ | ETF | 539.26 | 539.59 | 538.38 | 538.419 | 146914.0 |
| 2025-02-21 09:30:00 | QQQ | ETF | 538.38 | 538.4 | 535.9 | 536.19 | 2315022.0 |
| 2025-02-21 10:00:00 | QQQ | ETF | 536.18 | 536.54 | 533.71 | 534.0201 | 2062611.0 |
| 2025-02-21 10:30:00 | QQQ | ETF | 534.02 | 534.36 | 532.47 | 534.049 | 1887067.0 |
| 2025-02-21 11:00:00 | QQQ | ETF | 534.03 | 534.57 | 533.03 | 533.7109 | 1409890.0 |
| 2025-02-21 11:30:00 | QQQ | ETF | 533.6401 | 534.4 | 532.93 | 533.37 | 713143.0 |
| 2025-02-21 12:00:00 | QQQ | ETF | 533.35 | 533.83 | 531.14 | 532.1209 | 1217636.0 |
| 2025-02-21 12:30:00 | QQQ | ETF | 532.1599 | 532.23 | 529.92 | 530.28 | 1843527.0 |
> showing 50 of 39,446 rows — these rows as CSV