PREVIEW / etf_1hour / 2025-03-25
file: by_date/etf_1hour/2025/2025-03-25.parquet size: 621 KB rows: 23,674
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-25 04:00:00 | SPY | ETF | 573.52 | 573.54 | 572.91 | 573.27 | 19857.0 |
| 2025-03-25 05:00:00 | SPY | ETF | 573.15 | 573.82 | 572.99 | 573.82 | 10379.0 |
| 2025-03-25 06:00:00 | SPY | ETF | 573.83 | 574.56 | 573.28 | 574.56 | 26246.0 |
| 2025-03-25 07:00:00 | SPY | ETF | 574.52 | 575.59 | 573.95 | 575.56 | 125490.0 |
| 2025-03-25 08:00:00 | SPY | ETF | 574.65 | 576.03 | 573.29 | 575.3781 | 305594.0 |
| 2025-03-25 09:00:00 | SPY | ETF | 575.32 | 575.9303 | 574.02 | 574.66 | 3135659.0 |
| 2025-03-25 10:00:00 | SPY | ETF | 574.7 | 576.41 | 573.94 | 575.99 | 4353122.0 |
| 2025-03-25 11:00:00 | SPY | ETF | 575.97 | 576.21 | 574.56 | 574.7599 | 2316114.0 |
| 2025-03-25 12:00:00 | SPY | ETF | 574.76 | 575.09 | 574.17 | 574.955 | 1930441.0 |
| 2025-03-25 13:00:00 | SPY | ETF | 574.96 | 575.54 | 574.02 | 574.125 | 2327540.0 |
| 2025-03-25 14:00:00 | SPY | ETF | 574.12 | 574.9499 | 573.69 | 573.9392 | 2868825.0 |
| 2025-03-25 15:00:00 | SPY | ETF | 573.88 | 575.6 | 573.87 | 575.36 | 6535333.0 |
| 2025-03-25 16:00:00 | SPY | ETF | 575.35 | 575.94 | 574.71 | 575.89 | 3123872.0 |
| 2025-03-25 17:00:00 | SPY | ETF | 575.88 | 576.02 | 575.77 | 575.82 | 57398.0 |
| 2025-03-25 18:00:00 | SPY | ETF | 575.9 | 576.19 | 575.66 | 575.74 | 57331.0 |
| 2025-03-25 19:00:00 | SPY | ETF | 575.77 | 576.18 | 575.77 | 576.0 | 40507.0 |
| 2025-03-25 04:00:00 | QQQ | ETF | 489.95 | 490.22 | 488.77 | 489.09 | 87133.0 |
| 2025-03-25 05:00:00 | QQQ | ETF | 489.0 | 489.99 | 488.83 | 489.91 | 33461.0 |
| 2025-03-25 06:00:00 | QQQ | ETF | 489.9 | 490.9 | 489.46 | 490.73 | 38743.0 |
| 2025-03-25 07:00:00 | QQQ | ETF | 490.7 | 491.7 | 490.46 | 491.55 | 107976.0 |
| 2025-03-25 08:00:00 | QQQ | ETF | 491.1 | 492.42 | 488.8404 | 491.46 | 267714.0 |
| 2025-03-25 09:00:00 | QQQ | ETF | 491.45 | 492.15 | 490.42 | 491.5912 | 3040806.0 |
| 2025-03-25 10:00:00 | QQQ | ETF | 491.7 | 493.51 | 490.645 | 493.1888 | 3404732.0 |
| 2025-03-25 11:00:00 | QQQ | ETF | 493.16 | 493.62 | 492.11 | 492.36 | 1741929.0 |
| 2025-03-25 12:00:00 | QQQ | ETF | 492.35 | 492.81 | 491.75 | 492.545 | 1821100.0 |
| 2025-03-25 13:00:00 | QQQ | ETF | 492.605 | 493.26 | 491.371 | 491.65 | 1708898.0 |
| 2025-03-25 14:00:00 | QQQ | ETF | 491.61 | 492.67 | 491.38 | 491.9766 | 1543253.0 |
| 2025-03-25 15:00:00 | QQQ | ETF | 491.93 | 493.56 | 491.9 | 493.45 | 3098217.0 |
| 2025-03-25 16:00:00 | QQQ | ETF | 493.45 | 494.29 | 493.4 | 494.13 | 1292218.0 |
| 2025-03-25 17:00:00 | QQQ | ETF | 494.09 | 494.09 | 493.9 | 493.9899 | 29782.0 |
| 2025-03-25 18:00:00 | QQQ | ETF | 493.99 | 494.36 | 493.83 | 493.97 | 108737.0 |
| 2025-03-25 19:00:00 | QQQ | ETF | 494.01 | 494.52 | 494.0 | 494.28 | 43687.0 |
| 2025-03-25 04:00:00 | IWM | ETF | 208.07 | 208.11 | 207.83 | 207.94 | 24348.0 |
| 2025-03-25 05:00:00 | IWM | ETF | 207.92 | 208.12 | 207.86 | 208.1 | 8429.0 |
| 2025-03-25 06:00:00 | IWM | ETF | 208.13 | 208.33 | 207.95 | 208.32 | 11998.0 |
| 2025-03-25 07:00:00 | IWM | ETF | 208.34 | 208.69 | 208.14 | 208.65 | 70470.0 |
| 2025-03-25 08:00:00 | IWM | ETF | 208.66 | 208.73 | 207.81 | 208.46 | 124129.0 |
| 2025-03-25 09:00:00 | IWM | ETF | 208.43 | 209.27 | 207.99 | 208.11 | 2500250.0 |
| 2025-03-25 10:00:00 | IWM | ETF | 208.15 | 208.58 | 207.71 | 208.21 | 1853863.0 |
| 2025-03-25 11:00:00 | IWM | ETF | 208.19 | 208.54 | 207.65 | 207.83 | 1438695.0 |
| 2025-03-25 12:00:00 | IWM | ETF | 207.85 | 208.37 | 207.765 | 208.29 | 1120608.0 |
| 2025-03-25 13:00:00 | IWM | ETF | 208.295 | 208.69 | 207.94 | 207.955 | 898039.0 |
| 2025-03-25 14:00:00 | IWM | ETF | 207.96 | 208.23 | 207.49 | 207.75 | 1308249.0 |
| 2025-03-25 15:00:00 | IWM | ETF | 207.75 | 208.15 | 207.09 | 207.74 | 2952599.0 |
| 2025-03-25 16:00:00 | IWM | ETF | 207.74 | 208.1053 | 207.69 | 207.87 | 1073859.0 |
| 2025-03-25 17:00:00 | IWM | ETF | 207.86 | 207.99 | 207.71 | 207.76 | 8135.0 |
| 2025-03-25 18:00:00 | IWM | ETF | 207.79 | 207.9 | 207.65 | 207.7 | 18906.0 |
| 2025-03-25 19:00:00 | IWM | ETF | 207.72 | 207.83 | 207.69 | 207.6986 | 4550.0 |
| 2025-03-25 04:00:00 | DIA | ETF | 424.86 | 425.07 | 424.86 | 425.07 | 678.0 |
| 2025-03-25 05:00:00 | DIA | ETF | 424.95 | 425.0 | 424.95 | 425.0 | 765.0 |
> showing 50 of 23,674 rows — these rows as CSV