PREVIEW / etf_1hour / 2024-07-26
file: by_date/etf_1hour/2024/2024-07-26.parquet size: 549 KB rows: 20,389
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 |
|---|---|---|---|---|---|---|---|
| 2024-07-26 04:00:00 | SPY | ETF | 541.5 | 543.15 | 541.5 | 543.15 | 53381.0 |
| 2024-07-26 05:00:00 | SPY | ETF | 543.09 | 543.1 | 542.53 | 542.61 | 31295.0 |
| 2024-07-26 06:00:00 | SPY | ETF | 542.63 | 543.0 | 542.4 | 542.43 | 75221.0 |
| 2024-07-26 07:00:00 | SPY | ETF | 542.46 | 543.21 | 541.45 | 543.21 | 335163.0 |
| 2024-07-26 08:00:00 | SPY | ETF | 542.8 | 543.83 | 540.6 | 542.59 | 703434.0 |
| 2024-07-26 09:00:00 | SPY | ETF | 542.6 | 543.18 | 541.49 | 542.9 | 4240328.0 |
| 2024-07-26 10:00:00 | SPY | ETF | 542.88 | 544.63 | 541.67 | 543.42 | 5322074.0 |
| 2024-07-26 11:00:00 | SPY | ETF | 543.43 | 544.96 | 542.7802 | 544.85 | 3570155.0 |
| 2024-07-26 12:00:00 | SPY | ETF | 544.86 | 546.875 | 544.78 | 546.7306 | 4168456.0 |
| 2024-07-26 13:00:00 | SPY | ETF | 546.73 | 547.19 | 544.01 | 544.96 | 5501999.0 |
| 2024-07-26 14:00:00 | SPY | ETF | 544.94 | 545.46 | 543.38 | 543.57 | 3278974.0 |
| 2024-07-26 15:00:00 | SPY | ETF | 543.58 | 545.07 | 542.725 | 544.38 | 9802726.0 |
| 2024-07-26 16:00:00 | SPY | ETF | 544.37 | 544.72 | 544.03 | 544.33 | 3687952.0 |
| 2024-07-26 17:00:00 | SPY | ETF | 544.3 | 544.44 | 543.99 | 544.16 | 82616.0 |
| 2024-07-26 18:00:00 | SPY | ETF | 544.3228 | 544.43 | 544.15 | 544.4 | 11797.0 |
| 2024-07-26 19:00:00 | SPY | ETF | 544.43 | 544.43 | 544.21 | 544.27 | 45453.0 |
| 2024-07-26 04:00:00 | QQQ | ETF | 461.91 | 463.98 | 461.91 | 463.95 | 84848.0 |
| 2024-07-26 05:00:00 | QQQ | ETF | 464.09 | 464.09 | 463.11 | 463.44 | 138235.0 |
| 2024-07-26 06:00:00 | QQQ | ETF | 463.45 | 463.54 | 462.75 | 462.78 | 77459.0 |
| 2024-07-26 07:00:00 | QQQ | ETF | 462.77 | 463.92 | 462.6 | 463.85 | 211609.0 |
| 2024-07-26 08:00:00 | QQQ | ETF | 462.771 | 464.75 | 457.917 | 463.08 | 804754.0 |
| 2024-07-26 09:00:00 | QQQ | ETF | 463.04 | 463.19 | 460.23 | 461.98 | 3838126.0 |
| 2024-07-26 10:00:00 | QQQ | ETF | 462.02 | 463.37 | 459.77 | 461.81 | 5787001.0 |
| 2024-07-26 11:00:00 | QQQ | ETF | 461.82 | 463.45 | 460.99 | 463.22 | 3826584.0 |
| 2024-07-26 12:00:00 | QQQ | ETF | 463.23 | 465.72 | 463.05 | 465.46 | 3916125.0 |
| 2024-07-26 13:00:00 | QQQ | ETF | 465.46 | 465.93 | 462.4 | 463.52 | 4473688.0 |
| 2024-07-26 14:00:00 | QQQ | ETF | 463.44 | 464.13 | 461.62 | 461.87 | 2114657.0 |
| 2024-07-26 15:00:00 | QQQ | ETF | 461.89 | 463.37 | 461.27 | 463.0 | 4842550.0 |
| 2024-07-26 16:00:00 | QQQ | ETF | 462.98 | 463.33 | 462.65 | 462.96 | 992524.0 |
| 2024-07-26 17:00:00 | QQQ | ETF | 462.95 | 463.0 | 462.7539 | 462.9 | 36841.0 |
| 2024-07-26 18:00:00 | QQQ | ETF | 462.9 | 463.1205 | 462.9 | 463.12 | 7945.0 |
| 2024-07-26 19:00:00 | QQQ | ETF | 463.12 | 463.18 | 462.85 | 462.85 | 19220.0 |
| 2024-07-26 04:00:00 | IWM | ETF | 224.14 | 224.9 | 223.13 | 224.84 | 99856.0 |
| 2024-07-26 05:00:00 | IWM | ETF | 224.86 | 225.13 | 223.97 | 223.97 | 40091.0 |
| 2024-07-26 06:00:00 | IWM | ETF | 223.98 | 224.44 | 223.9 | 224.01 | 23555.0 |
| 2024-07-26 07:00:00 | IWM | ETF | 224.0 | 224.55 | 223.53 | 224.36 | 252761.0 |
| 2024-07-26 08:00:00 | IWM | ETF | 223.97 | 224.9496 | 222.49 | 223.38 | 893463.0 |
| 2024-07-26 09:00:00 | IWM | ETF | 223.35 | 225.2 | 223.18 | 224.41 | 5666785.0 |
| 2024-07-26 10:00:00 | IWM | ETF | 224.41 | 225.39 | 222.07 | 222.5687 | 8042665.0 |
| 2024-07-26 11:00:00 | IWM | ETF | 222.57 | 223.53 | 221.7 | 223.44 | 3515710.0 |
| 2024-07-26 12:00:00 | IWM | ETF | 223.46 | 223.97 | 223.09 | 223.75 | 2731755.0 |
| 2024-07-26 13:00:00 | IWM | ETF | 223.75 | 223.88 | 222.7 | 223.44 | 2484204.0 |
| 2024-07-26 14:00:00 | IWM | ETF | 223.41 | 223.85 | 223.28 | 223.46 | 1769318.0 |
| 2024-07-26 15:00:00 | IWM | ETF | 223.45 | 224.61 | 223.05 | 224.25 | 5622393.0 |
| 2024-07-26 16:00:00 | IWM | ETF | 224.22 | 224.44 | 224.14 | 224.1799 | 898698.0 |
| 2024-07-26 17:00:00 | IWM | ETF | 224.18 | 224.5 | 224.1 | 224.5 | 32782.0 |
| 2024-07-26 18:00:00 | IWM | ETF | 224.49 | 224.69 | 224.4605 | 224.69 | 11394.0 |
| 2024-07-26 19:00:00 | IWM | ETF | 224.5997 | 224.69 | 224.56 | 224.56 | 19515.0 |
| 2024-07-26 04:00:00 | DIA | ETF | 401.39 | 401.72 | 401.37 | 401.59 | 4774.0 |
| 2024-07-26 05:00:00 | DIA | ETF | 401.66 | 401.66 | 401.52 | 401.57 | 800.0 |
> showing 50 of 20,389 rows — these rows as CSV