PREVIEW / etf_1hour / 2025-03-26
file: by_date/etf_1hour/2025/2025-03-26.parquet size: 626 KB rows: 23,685
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-26 04:00:00 | SPY | ETF | 575.1 | 575.24 | 574.48 | 574.78 | 15761.0 |
| 2025-03-26 05:00:00 | SPY | ETF | 574.79 | 574.92 | 574.35 | 574.35 | 18391.0 |
| 2025-03-26 06:00:00 | SPY | ETF | 574.26 | 575.36 | 574.24 | 575.27 | 16982.0 |
| 2025-03-26 07:00:00 | SPY | ETF | 575.35 | 575.81 | 575.13 | 575.69 | 45030.0 |
| 2025-03-26 08:00:00 | SPY | ETF | 575.4 | 575.94 | 574.7596 | 575.72 | 132610.0 |
| 2025-03-26 09:00:00 | SPY | ETF | 575.72 | 576.33 | 573.33 | 573.63 | 3305372.0 |
| 2025-03-26 10:00:00 | SPY | ETF | 573.62 | 574.52 | 572.486 | 573.44 | 4672921.0 |
| 2025-03-26 11:00:00 | SPY | ETF | 573.42 | 573.84 | 570.12 | 570.66 | 3293144.0 |
| 2025-03-26 12:00:00 | SPY | ETF | 570.66 | 571.39 | 569.28 | 569.49 | 3450123.0 |
| 2025-03-26 13:00:00 | SPY | ETF | 569.49 | 570.1999 | 567.94 | 568.0498 | 3565536.0 |
| 2025-03-26 14:00:00 | SPY | ETF | 568.06 | 569.49 | 567.2 | 567.41 | 3228054.0 |
| 2025-03-26 15:00:00 | SPY | ETF | 567.4 | 569.58 | 567.19 | 568.74 | 9426207.0 |
| 2025-03-26 16:00:00 | SPY | ETF | 568.74 | 568.9438 | 568.1 | 568.29 | 3755764.0 |
| 2025-03-26 17:00:00 | SPY | ETF | 568.27 | 568.49 | 566.81 | 567.17 | 276462.0 |
| 2025-03-26 18:00:00 | SPY | ETF | 567.02 | 568.06 | 566.03 | 566.69 | 351841.0 |
| 2025-03-26 19:00:00 | SPY | ETF | 566.69 | 567.8 | 566.5 | 567.62 | 198943.0 |
| 2025-03-26 04:00:00 | QQQ | ETF | 493.28 | 494.0 | 492.37 | 492.66 | 33581.0 |
| 2025-03-26 05:00:00 | QQQ | ETF | 492.68 | 492.93 | 492.16 | 492.16 | 37366.0 |
| 2025-03-26 06:00:00 | QQQ | ETF | 492.15 | 493.13 | 492.1 | 493.12 | 23512.0 |
| 2025-03-26 07:00:00 | QQQ | ETF | 493.18 | 493.63 | 492.83 | 493.39 | 87380.0 |
| 2025-03-26 08:00:00 | QQQ | ETF | 493.24 | 493.67 | 492.6096 | 493.28 | 229778.0 |
| 2025-03-26 09:00:00 | QQQ | ETF | 493.27 | 493.4 | 489.11 | 489.3504 | 3013375.0 |
| 2025-03-26 10:00:00 | QQQ | ETF | 489.38 | 490.31 | 487.2101 | 488.87 | 4111247.0 |
| 2025-03-26 11:00:00 | QQQ | ETF | 488.87 | 489.48 | 485.89 | 486.4 | 2842570.0 |
| 2025-03-26 12:00:00 | QQQ | ETF | 486.39 | 487.0 | 484.78 | 484.9401 | 2816044.0 |
| 2025-03-26 13:00:00 | QQQ | ETF | 484.915 | 485.56 | 483.59 | 483.74 | 2997842.0 |
| 2025-03-26 14:00:00 | QQQ | ETF | 483.75 | 485.3 | 482.95 | 483.1 | 2630929.0 |
| 2025-03-26 15:00:00 | QQQ | ETF | 483.09 | 484.9584 | 482.82 | 484.4 | 4574651.0 |
| 2025-03-26 16:00:00 | QQQ | ETF | 484.39 | 484.65 | 483.7 | 483.9 | 1741624.0 |
| 2025-03-26 17:00:00 | QQQ | ETF | 483.95 | 483.99 | 482.89 | 482.89 | 204085.0 |
| 2025-03-26 18:00:00 | QQQ | ETF | 482.8 | 483.999 | 481.82 | 482.16 | 365906.0 |
| 2025-03-26 19:00:00 | QQQ | ETF | 482.17 | 483.4 | 482.02 | 483.1004 | 152045.0 |
| 2025-03-26 04:00:00 | IWM | ETF | 207.42 | 207.55 | 207.19 | 207.25 | 14047.0 |
| 2025-03-26 05:00:00 | IWM | ETF | 207.21 | 207.39 | 207.1 | 207.19 | 9040.0 |
| 2025-03-26 06:00:00 | IWM | ETF | 207.14 | 207.66 | 207.13 | 207.66 | 39567.0 |
| 2025-03-26 07:00:00 | IWM | ETF | 207.69 | 208.0 | 207.55 | 207.94 | 23733.0 |
| 2025-03-26 08:00:00 | IWM | ETF | 207.57 | 208.14 | 207.23 | 208.02 | 51425.0 |
| 2025-03-26 09:00:00 | IWM | ETF | 208.1 | 208.82 | 207.29 | 207.43 | 1549559.0 |
| 2025-03-26 10:00:00 | IWM | ETF | 207.42 | 207.89 | 206.84 | 207.05 | 2059660.0 |
| 2025-03-26 11:00:00 | IWM | ETF | 207.08 | 207.21 | 205.74 | 206.03 | 1543340.0 |
| 2025-03-26 12:00:00 | IWM | ETF | 206.0 | 206.46 | 205.53 | 205.561 | 1248497.0 |
| 2025-03-26 13:00:00 | IWM | ETF | 205.56 | 205.975 | 204.87 | 205.0 | 1434929.0 |
| 2025-03-26 14:00:00 | IWM | ETF | 205.03 | 205.54 | 204.71 | 204.74 | 1554188.0 |
| 2025-03-26 15:00:00 | IWM | ETF | 204.75 | 205.67 | 204.68 | 205.56 | 3270843.0 |
| 2025-03-26 16:00:00 | IWM | ETF | 205.59 | 205.65 | 205.3228 | 205.48 | 1489093.0 |
| 2025-03-26 17:00:00 | IWM | ETF | 205.49 | 205.57 | 204.42 | 204.68 | 33371.0 |
| 2025-03-26 18:00:00 | IWM | ETF | 204.6 | 205.19 | 204.15 | 204.5718 | 166180.0 |
| 2025-03-26 19:00:00 | IWM | ETF | 204.521 | 205.03 | 204.46 | 204.97 | 37491.0 |
| 2025-03-26 04:00:00 | DIA | ETF | 425.58 | 425.69 | 425.24 | 425.24 | 1500.0 |
| 2025-03-26 05:00:00 | DIA | ETF | 425.43 | 425.53 | 425.43 | 425.53 | 200.0 |
> showing 50 of 23,685 rows — these rows as CSV