PREVIEW / etf_1hour / 2024-07-29
file: by_date/etf_1hour/2024/2024-07-29.parquet size: 544 KB rows: 20,682
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-29 04:00:00 | SPY | ETF | 545.24 | 546.09 | 545.11 | 545.64 | 11987.0 |
| 2024-07-29 05:00:00 | SPY | ETF | 545.62 | 546.02 | 545.42 | 546.02 | 4150.0 |
| 2024-07-29 06:00:00 | SPY | ETF | 546.33 | 546.8 | 546.3 | 546.64 | 14211.0 |
| 2024-07-29 07:00:00 | SPY | ETF | 546.46 | 547.06 | 545.8 | 546.82 | 255832.0 |
| 2024-07-29 08:00:00 | SPY | ETF | 546.45 | 547.91 | 545.32 | 546.81 | 200484.0 |
| 2024-07-29 09:00:00 | SPY | ETF | 546.76 | 546.76 | 544.75 | 546.63 | 4130573.0 |
| 2024-07-29 10:00:00 | SPY | ETF | 546.64 | 547.04 | 544.28 | 544.35 | 3826769.0 |
| 2024-07-29 11:00:00 | SPY | ETF | 544.33 | 545.8 | 542.72 | 545.61 | 3075033.0 |
| 2024-07-29 12:00:00 | SPY | ETF | 545.615 | 546.78 | 545.615 | 546.22 | 2324049.0 |
| 2024-07-29 13:00:00 | SPY | ETF | 546.21 | 547.05 | 544.97 | 545.4593 | 2346275.0 |
| 2024-07-29 14:00:00 | SPY | ETF | 545.47 | 545.49 | 544.46 | 545.14 | 2042895.0 |
| 2024-07-29 15:00:00 | SPY | ETF | 545.15 | 546.05 | 544.52 | 544.76 | 5845235.0 |
| 2024-07-29 16:00:00 | SPY | ETF | 544.75 | 545.05 | 544.5 | 544.88 | 3051631.0 |
| 2024-07-29 17:00:00 | SPY | ETF | 544.98 | 545.02 | 544.78 | 544.88 | 23274.0 |
| 2024-07-29 18:00:00 | SPY | ETF | 544.88 | 545.31 | 544.72 | 544.91 | 83138.0 |
| 2024-07-29 19:00:00 | SPY | ETF | 544.91 | 544.91 | 543.1 | 543.45 | 71903.0 |
| 2024-07-29 04:00:00 | QQQ | ETF | 464.61 | 465.66 | 464.38 | 464.89 | 49339.0 |
| 2024-07-29 05:00:00 | QQQ | ETF | 464.79 | 465.37 | 464.61 | 465.37 | 21482.0 |
| 2024-07-29 06:00:00 | QQQ | ETF | 465.43 | 465.9 | 465.18 | 465.74 | 24144.0 |
| 2024-07-29 07:00:00 | QQQ | ETF | 465.66 | 466.49 | 465.55 | 466.0 | 275183.0 |
| 2024-07-29 08:00:00 | QQQ | ETF | 465.75 | 467.57 | 464.44 | 466.37 | 453762.0 |
| 2024-07-29 09:00:00 | QQQ | ETF | 466.32 | 467.67 | 464.2 | 467.47 | 3708566.0 |
| 2024-07-29 10:00:00 | QQQ | ETF | 467.45 | 467.91 | 464.11 | 464.22 | 3462484.0 |
| 2024-07-29 11:00:00 | QQQ | ETF | 464.225 | 465.37 | 461.615 | 465.09 | 2979463.0 |
| 2024-07-29 12:00:00 | QQQ | ETF | 465.15 | 467.05 | 465.14 | 466.1852 | 2673136.0 |
| 2024-07-29 13:00:00 | QQQ | ETF | 466.24 | 467.195 | 464.7 | 464.932 | 2162230.0 |
| 2024-07-29 14:00:00 | QQQ | ETF | 464.97 | 465.0 | 463.29 | 464.12 | 1985823.0 |
| 2024-07-29 15:00:00 | QQQ | ETF | 464.15 | 465.235 | 463.58 | 463.84 | 3157200.0 |
| 2024-07-29 16:00:00 | QQQ | ETF | 463.82 | 464.11 | 463.36 | 464.09 | 862432.0 |
| 2024-07-29 17:00:00 | QQQ | ETF | 464.09 | 464.1 | 463.88 | 463.97 | 226803.0 |
| 2024-07-29 18:00:00 | QQQ | ETF | 464.0 | 464.5 | 463.8391 | 464.01 | 35534.0 |
| 2024-07-29 19:00:00 | QQQ | ETF | 464.04 | 464.04 | 461.77 | 462.0 | 60713.0 |
| 2024-07-29 04:00:00 | IWM | ETF | 226.1 | 226.1 | 224.69 | 225.44 | 31608.0 |
| 2024-07-29 05:00:00 | IWM | ETF | 225.3 | 225.76 | 224.92 | 225.74 | 34948.0 |
| 2024-07-29 06:00:00 | IWM | ETF | 225.77 | 225.78 | 225.57 | 225.67 | 54277.0 |
| 2024-07-29 07:00:00 | IWM | ETF | 225.56 | 226.34 | 225.33 | 226.25 | 84107.0 |
| 2024-07-29 08:00:00 | IWM | ETF | 225.55 | 226.35 | 224.88 | 225.5 | 235510.0 |
| 2024-07-29 09:00:00 | IWM | ETF | 225.5 | 225.51 | 223.81 | 224.83 | 3735500.0 |
| 2024-07-29 10:00:00 | IWM | ETF | 224.84 | 225.4172 | 221.85 | 222.371 | 5137614.0 |
| 2024-07-29 11:00:00 | IWM | ETF | 222.38 | 222.57 | 221.35 | 222.38 | 3508599.0 |
| 2024-07-29 12:00:00 | IWM | ETF | 222.34 | 222.7675 | 221.5486 | 221.66 | 1911170.0 |
| 2024-07-29 13:00:00 | IWM | ETF | 221.675 | 222.02 | 220.88 | 221.16 | 2530811.0 |
| 2024-07-29 14:00:00 | IWM | ETF | 221.17 | 221.48 | 220.77 | 221.145 | 1980055.0 |
| 2024-07-29 15:00:00 | IWM | ETF | 221.15 | 222.42 | 221.02 | 221.77 | 4044970.0 |
| 2024-07-29 16:00:00 | IWM | ETF | 221.73 | 221.87 | 221.63 | 221.66 | 3932985.0 |
| 2024-07-29 17:00:00 | IWM | ETF | 221.74 | 221.79 | 221.6408 | 221.7899 | 16957.0 |
| 2024-07-29 18:00:00 | IWM | ETF | 221.71 | 222.01 | 221.66 | 221.72 | 24992.0 |
| 2024-07-29 19:00:00 | IWM | ETF | 221.77 | 221.77 | 220.461 | 220.75 | 52222.0 |
| 2024-07-29 04:00:00 | DIA | ETF | 406.56 | 406.98 | 406.56 | 406.98 | 200.0 |
| 2024-07-29 05:00:00 | DIA | ETF | 406.82 | 406.82 | 406.74 | 406.74 | 500.0 |
> showing 50 of 20,682 rows — these rows as CSV