PREVIEW / etf_1hour / 2024-08-01
file: by_date/etf_1hour/2024/2024-08-01.parquet size: 566 KB rows: 21,538
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-08-01 04:00:00 | SPY | ETF | 552.26 | 552.35 | 550.67 | 551.09 | 49539.0 |
| 2024-08-01 05:00:00 | SPY | ETF | 551.07 | 552.53 | 551.0 | 552.46 | 151921.0 |
| 2024-08-01 06:00:00 | SPY | ETF | 552.66 | 552.82 | 552.25 | 552.82 | 27855.0 |
| 2024-08-01 07:00:00 | SPY | ETF | 552.82 | 553.48 | 552.4 | 552.47 | 224204.0 |
| 2024-08-01 08:00:00 | SPY | ETF | 552.87 | 554.08 | 551.0496 | 553.5 | 538284.0 |
| 2024-08-01 09:00:00 | SPY | ETF | 553.5 | 554.8688 | 552.1 | 554.04 | 4448201.0 |
| 2024-08-01 10:00:00 | SPY | ETF | 553.99 | 554.33 | 547.24 | 547.47 | 8027228.0 |
| 2024-08-01 11:00:00 | SPY | ETF | 547.47 | 547.68 | 544.17 | 544.72 | 5537524.0 |
| 2024-08-01 12:00:00 | SPY | ETF | 544.72 | 546.4054 | 543.14 | 543.74 | 5778842.0 |
| 2024-08-01 13:00:00 | SPY | ETF | 543.73 | 543.95 | 540.47 | 542.56 | 6018617.0 |
| 2024-08-01 14:00:00 | SPY | ETF | 542.54 | 542.8596 | 539.43 | 539.9789 | 6180345.0 |
| 2024-08-01 15:00:00 | SPY | ETF | 539.975 | 543.47 | 539.7 | 543.04 | 14882200.0 |
| 2024-08-01 16:00:00 | SPY | ETF | 543.04 | 543.44 | 539.79 | 542.03 | 3639627.0 |
| 2024-08-01 17:00:00 | SPY | ETF | 542.1 | 542.2 | 540.67 | 541.21 | 427413.0 |
| 2024-08-01 18:00:00 | SPY | ETF | 541.31 | 542.21 | 539.7 | 540.2 | 216711.0 |
| 2024-08-01 19:00:00 | SPY | ETF | 540.24 | 541.7195 | 539.97 | 541.1084 | 67430.0 |
| 2024-08-01 04:00:00 | QQQ | ETF | 474.9 | 474.9 | 471.3 | 471.78 | 190179.0 |
| 2024-08-01 05:00:00 | QQQ | ETF | 471.68 | 473.61 | 471.58 | 473.28 | 46044.0 |
| 2024-08-01 06:00:00 | QQQ | ETF | 473.37 | 473.71 | 472.6 | 473.32 | 45519.0 |
| 2024-08-01 07:00:00 | QQQ | ETF | 473.31 | 474.32 | 472.9 | 473.03 | 241382.0 |
| 2024-08-01 08:00:00 | QQQ | ETF | 472.98 | 475.61 | 470.717 | 473.3901 | 436633.0 |
| 2024-08-01 09:00:00 | QQQ | ETF | 473.45 | 475.55 | 471.2 | 474.71 | 3903593.0 |
| 2024-08-01 10:00:00 | QQQ | ETF | 474.62 | 475.17 | 467.0501 | 467.37 | 5344743.0 |
| 2024-08-01 11:00:00 | QQQ | ETF | 467.36 | 467.67 | 462.66 | 463.06 | 5618076.0 |
| 2024-08-01 12:00:00 | QQQ | ETF | 463.05 | 464.86 | 460.97 | 461.36 | 4563454.0 |
| 2024-08-01 13:00:00 | QQQ | ETF | 461.41 | 461.73 | 457.06 | 459.61 | 5036464.0 |
| 2024-08-01 14:00:00 | QQQ | ETF | 459.6 | 459.97 | 455.98 | 456.5 | 4087002.0 |
| 2024-08-01 15:00:00 | QQQ | ETF | 456.42 | 460.63 | 456.33 | 459.68 | 7930518.0 |
| 2024-08-01 16:00:00 | QQQ | ETF | 459.76 | 460.31 | 455.6 | 458.3 | 3301090.0 |
| 2024-08-01 17:00:00 | QQQ | ETF | 458.36 | 459.66 | 455.9 | 457.67 | 433552.0 |
| 2024-08-01 18:00:00 | QQQ | ETF | 457.67 | 458.6 | 455.37 | 455.89 | 288775.0 |
| 2024-08-01 19:00:00 | QQQ | ETF | 455.77 | 457.94 | 455.71 | 457.06 | 197875.0 |
| 2024-08-01 04:00:00 | IWM | ETF | 222.85 | 224.26 | 221.57 | 222.3 | 67868.0 |
| 2024-08-01 05:00:00 | IWM | ETF | 222.21 | 223.01 | 222.17 | 222.72 | 20470.0 |
| 2024-08-01 06:00:00 | IWM | ETF | 222.88 | 223.29 | 222.86 | 222.87 | 24914.0 |
| 2024-08-01 07:00:00 | IWM | ETF | 223.01 | 223.53 | 222.92 | 223.3 | 95700.0 |
| 2024-08-01 08:00:00 | IWM | ETF | 223.41 | 224.95 | 221.98 | 224.57 | 495917.0 |
| 2024-08-01 09:00:00 | IWM | ETF | 224.4 | 224.89 | 222.32 | 222.4278 | 4321732.0 |
| 2024-08-01 10:00:00 | IWM | ETF | 222.4 | 222.84 | 218.0599 | 218.13 | 11030984.0 |
| 2024-08-01 11:00:00 | IWM | ETF | 218.14 | 218.27 | 216.02 | 217.02 | 10712653.0 |
| 2024-08-01 12:00:00 | IWM | ETF | 217.03 | 217.68 | 215.93 | 216.74 | 5398253.0 |
| 2024-08-01 13:00:00 | IWM | ETF | 216.74 | 216.83 | 215.52 | 216.59 | 5115706.0 |
| 2024-08-01 14:00:00 | IWM | ETF | 216.58 | 216.73 | 215.06 | 215.38 | 5006617.0 |
| 2024-08-01 15:00:00 | IWM | ETF | 215.35 | 217.35 | 215.06 | 216.64 | 9522449.0 |
| 2024-08-01 16:00:00 | IWM | ETF | 216.66 | 216.7 | 216.13 | 216.57 | 2453601.0 |
| 2024-08-01 17:00:00 | IWM | ETF | 216.52 | 216.59 | 215.684 | 215.99 | 98567.0 |
| 2024-08-01 18:00:00 | IWM | ETF | 216.03 | 216.69 | 215.9904 | 216.1 | 130584.0 |
| 2024-08-01 19:00:00 | IWM | ETF | 216.16 | 216.66 | 216.11 | 216.45 | 32469.0 |
| 2024-08-01 04:00:00 | DIA | ETF | 408.08 | 408.08 | 408.05 | 408.05 | 240.0 |
| 2024-08-01 05:00:00 | DIA | ETF | 408.38 | 408.39 | 408.38 | 408.39 | 1000.0 |
> showing 50 of 21,538 rows — these rows as CSV