PREVIEW / etf_1hour / 2024-07-25
file: by_date/etf_1hour/2024/2024-07-25.parquet size: 560 KB rows: 21,176
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-25 04:00:00 | SPY | ETF | 541.88 | 542.28 | 539.28 | 541.69 | 78398.0 |
| 2024-07-25 05:00:00 | SPY | ETF | 541.72 | 542.15 | 540.28 | 540.43 | 96804.0 |
| 2024-07-25 06:00:00 | SPY | ETF | 540.49 | 540.73 | 539.67 | 540.59 | 59141.0 |
| 2024-07-25 07:00:00 | SPY | ETF | 540.6 | 541.27 | 539.97 | 539.97 | 210181.0 |
| 2024-07-25 08:00:00 | SPY | ETF | 541.02 | 542.69 | 539.4 | 541.7 | 584324.0 |
| 2024-07-25 09:00:00 | SPY | ETF | 541.69 | 541.69 | 539.61 | 539.858 | 4153525.0 |
| 2024-07-25 10:00:00 | SPY | ETF | 539.87 | 542.82 | 537.45 | 542.79 | 9084453.0 |
| 2024-07-25 11:00:00 | SPY | ETF | 542.8 | 544.6297 | 542.0974 | 543.97 | 4510460.0 |
| 2024-07-25 12:00:00 | SPY | ETF | 543.97 | 546.64 | 543.3 | 546.12 | 4468460.0 |
| 2024-07-25 13:00:00 | SPY | ETF | 546.13 | 547.455 | 544.1 | 544.635 | 4176961.0 |
| 2024-07-25 14:00:00 | SPY | ETF | 544.635 | 544.6796 | 540.52 | 540.8299 | 5111737.0 |
| 2024-07-25 15:00:00 | SPY | ETF | 540.81 | 543.68 | 538.13 | 538.34 | 11361970.0 |
| 2024-07-25 16:00:00 | SPY | ETF | 538.34 | 538.7 | 537.5 | 538.65 | 4115710.0 |
| 2024-07-25 17:00:00 | SPY | ETF | 538.61 | 538.74 | 538.39 | 538.74 | 87218.0 |
| 2024-07-25 18:00:00 | SPY | ETF | 538.74 | 539.47 | 538.74 | 538.8 | 62163.0 |
| 2024-07-25 19:00:00 | SPY | ETF | 538.85 | 539.33 | 538.77 | 539.33 | 45283.0 |
| 2024-07-25 04:00:00 | QQQ | ETF | 463.83 | 463.83 | 460.02 | 463.28 | 209494.0 |
| 2024-07-25 05:00:00 | QQQ | ETF | 463.44 | 464.07 | 461.75 | 461.92 | 187036.0 |
| 2024-07-25 06:00:00 | QQQ | ETF | 462.16 | 462.53 | 460.87 | 462.21 | 255439.0 |
| 2024-07-25 07:00:00 | QQQ | ETF | 462.32 | 463.47 | 461.7 | 461.73 | 356184.0 |
| 2024-07-25 08:00:00 | QQQ | ETF | 462.4 | 465.1 | 460.6 | 464.18 | 805006.0 |
| 2024-07-25 09:00:00 | QQQ | ETF | 464.13 | 464.42 | 458.87 | 459.2 | 4990170.0 |
| 2024-07-25 10:00:00 | QQQ | ETF | 459.19 | 463.7695 | 455.63 | 463.7 | 10424699.0 |
| 2024-07-25 11:00:00 | QQQ | ETF | 463.7 | 465.24 | 461.98 | 464.19 | 5163850.0 |
| 2024-07-25 12:00:00 | QQQ | ETF | 464.18 | 467.21 | 463.14 | 466.56 | 4208882.0 |
| 2024-07-25 13:00:00 | QQQ | ETF | 466.59 | 467.94 | 464.4224 | 465.49 | 3296311.0 |
| 2024-07-25 14:00:00 | QQQ | ETF | 465.5299 | 465.62 | 461.17 | 461.574 | 3558583.0 |
| 2024-07-25 15:00:00 | QQQ | ETF | 461.57 | 464.4 | 458.05 | 458.25 | 7509556.0 |
| 2024-07-25 16:00:00 | QQQ | ETF | 458.27 | 458.61 | 457.1 | 458.32 | 2035238.0 |
| 2024-07-25 17:00:00 | QQQ | ETF | 458.29 | 458.3 | 457.8 | 458.29 | 122411.0 |
| 2024-07-25 18:00:00 | QQQ | ETF | 458.34 | 459.25 | 458.34 | 458.67 | 298199.0 |
| 2024-07-25 19:00:00 | QQQ | ETF | 458.66 | 459.08 | 458.42 | 459.07 | 70305.0 |
| 2024-07-25 04:00:00 | IWM | ETF | 218.0 | 218.76 | 216.8 | 218.76 | 51725.0 |
| 2024-07-25 05:00:00 | IWM | ETF | 218.8 | 218.8 | 217.76 | 217.76 | 49395.0 |
| 2024-07-25 06:00:00 | IWM | ETF | 217.88 | 218.6 | 217.45 | 218.17 | 112294.0 |
| 2024-07-25 07:00:00 | IWM | ETF | 218.06 | 218.66 | 217.77 | 217.77 | 148921.0 |
| 2024-07-25 08:00:00 | IWM | ETF | 218.3 | 219.28 | 217.2 | 219.12 | 384099.0 |
| 2024-07-25 09:00:00 | IWM | ETF | 219.07 | 220.59 | 218.2 | 220.024 | 5573461.0 |
| 2024-07-25 10:00:00 | IWM | ETF | 220.04 | 222.05 | 218.42 | 222.04 | 6044969.0 |
| 2024-07-25 11:00:00 | IWM | ETF | 222.045 | 222.61 | 221.48 | 222.5301 | 3946662.0 |
| 2024-07-25 12:00:00 | IWM | ETF | 222.52 | 223.61 | 221.97 | 223.36 | 3144446.0 |
| 2024-07-25 13:00:00 | IWM | ETF | 223.36 | 224.02 | 222.41 | 222.675 | 3650836.0 |
| 2024-07-25 14:00:00 | IWM | ETF | 222.67 | 222.69 | 220.7027 | 220.95 | 3571780.0 |
| 2024-07-25 15:00:00 | IWM | ETF | 220.94 | 222.15 | 220.47 | 220.5 | 6532521.0 |
| 2024-07-25 16:00:00 | IWM | ETF | 220.57 | 220.93 | 220.27 | 220.84 | 2716823.0 |
| 2024-07-25 17:00:00 | IWM | ETF | 220.78 | 221.21 | 220.7 | 221.09 | 110993.0 |
| 2024-07-25 18:00:00 | IWM | ETF | 221.06 | 221.41 | 221.0 | 221.24 | 54982.0 |
| 2024-07-25 19:00:00 | IWM | ETF | 221.25 | 221.54 | 221.16 | 221.54 | 39389.0 |
| 2024-07-25 04:00:00 | DIA | ETF | 398.75 | 399.94 | 398.58 | 399.9 | 6258.0 |
| 2024-07-25 05:00:00 | DIA | ETF | 399.94 | 399.94 | 399.34 | 399.34 | 996.0 |
> showing 50 of 21,176 rows — these rows as CSV