PREVIEW / etf_1hour / 2024-08-08
file: by_date/etf_1hour/2024/2024-08-08.parquet size: 554 KB rows: 20,789
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-08 04:00:00 | SPY | ETF | 516.59 | 518.5 | 516.5 | 518.35 | 35076.0 |
| 2024-08-08 05:00:00 | SPY | ETF | 518.52 | 519.0 | 516.35 | 517.0 | 27748.0 |
| 2024-08-08 06:00:00 | SPY | ETF | 517.1 | 518.42 | 516.42 | 518.18 | 60861.0 |
| 2024-08-08 07:00:00 | SPY | ETF | 518.0 | 519.32 | 517.72 | 519.15 | 327068.0 |
| 2024-08-08 08:00:00 | SPY | ETF | 519.24 | 523.4498 | 516.26 | 522.5 | 1898981.0 |
| 2024-08-08 09:00:00 | SPY | ETF | 522.62 | 525.05 | 521.84 | 525.04 | 6337066.0 |
| 2024-08-08 10:00:00 | SPY | ETF | 525.05 | 528.45 | 524.66 | 528.2 | 7070235.0 |
| 2024-08-08 11:00:00 | SPY | ETF | 528.19 | 528.48 | 526.405 | 527.675 | 4033165.0 |
| 2024-08-08 12:00:00 | SPY | ETF | 527.675 | 529.0162 | 526.65 | 527.85 | 3631440.0 |
| 2024-08-08 13:00:00 | SPY | ETF | 527.83 | 530.52 | 526.735 | 530.24 | 4241808.0 |
| 2024-08-08 14:00:00 | SPY | ETF | 530.21 | 531.29 | 529.51 | 530.13 | 4610708.0 |
| 2024-08-08 15:00:00 | SPY | ETF | 530.12 | 531.03 | 528.2 | 530.63 | 11781652.0 |
| 2024-08-08 16:00:00 | SPY | ETF | 530.64 | 531.82 | 530.42 | 531.01 | 6370198.0 |
| 2024-08-08 17:00:00 | SPY | ETF | 531.05 | 531.2 | 530.64 | 530.74 | 197678.0 |
| 2024-08-08 18:00:00 | SPY | ETF | 530.74 | 531.2 | 530.45 | 530.95 | 225370.0 |
| 2024-08-08 19:00:00 | SPY | ETF | 530.98 | 532.07 | 530.77 | 531.59 | 95743.0 |
| 2024-08-08 04:00:00 | QQQ | ETF | 434.78 | 435.5 | 433.29 | 435.45 | 98144.0 |
| 2024-08-08 05:00:00 | QQQ | ETF | 435.5 | 435.94 | 433.51 | 434.43 | 63926.0 |
| 2024-08-08 06:00:00 | QQQ | ETF | 434.46 | 435.5 | 433.67 | 434.93 | 52555.0 |
| 2024-08-08 07:00:00 | QQQ | ETF | 434.86 | 435.74 | 434.14 | 435.43 | 215074.0 |
| 2024-08-08 08:00:00 | QQQ | ETF | 434.66 | 440.46 | 433.13 | 439.43 | 1132790.0 |
| 2024-08-08 09:00:00 | QQQ | ETF | 439.5 | 441.64 | 437.15 | 440.6025 | 5277599.0 |
| 2024-08-08 10:00:00 | QQQ | ETF | 440.68 | 446.09 | 440.19 | 445.49 | 5853507.0 |
| 2024-08-08 11:00:00 | QQQ | ETF | 445.53 | 445.7 | 443.37 | 445.32 | 3378977.0 |
| 2024-08-08 12:00:00 | QQQ | ETF | 445.32 | 446.85 | 444.28 | 445.37 | 2704691.0 |
| 2024-08-08 13:00:00 | QQQ | ETF | 445.42 | 448.43 | 444.22 | 447.995 | 3476892.0 |
| 2024-08-08 14:00:00 | QQQ | ETF | 448.0 | 448.99 | 446.99 | 447.47 | 3018400.0 |
| 2024-08-08 15:00:00 | QQQ | ETF | 447.43 | 448.66 | 445.34 | 448.2 | 7304013.0 |
| 2024-08-08 16:00:00 | QQQ | ETF | 448.18 | 449.91 | 448.05 | 449.16 | 2249656.0 |
| 2024-08-08 17:00:00 | QQQ | ETF | 449.16 | 449.24 | 448.07 | 448.8924 | 165570.0 |
| 2024-08-08 18:00:00 | QQQ | ETF | 448.84 | 449.429 | 448.4 | 449.02 | 102239.0 |
| 2024-08-08 19:00:00 | QQQ | ETF | 449.16 | 450.48 | 449.13 | 450.15 | 106826.0 |
| 2024-08-08 04:00:00 | IWM | ETF | 200.96 | 202.0 | 200.87 | 201.99 | 29171.0 |
| 2024-08-08 05:00:00 | IWM | ETF | 202.08 | 202.22 | 200.68 | 201.03 | 21652.0 |
| 2024-08-08 06:00:00 | IWM | ETF | 200.9 | 201.65 | 200.84 | 200.91 | 18398.0 |
| 2024-08-08 07:00:00 | IWM | ETF | 200.99 | 202.0 | 200.77 | 201.73 | 87571.0 |
| 2024-08-08 08:00:00 | IWM | ETF | 201.03 | 205.68 | 200.75 | 203.82 | 775988.0 |
| 2024-08-08 09:00:00 | IWM | ETF | 203.85 | 204.99 | 203.06 | 204.55 | 3251119.0 |
| 2024-08-08 10:00:00 | IWM | ETF | 204.57 | 205.83 | 204.3 | 205.78 | 2966762.0 |
| 2024-08-08 11:00:00 | IWM | ETF | 205.77 | 205.79 | 204.9 | 205.47 | 1655393.0 |
| 2024-08-08 12:00:00 | IWM | ETF | 205.43 | 205.95 | 204.64 | 205.34 | 1173733.0 |
| 2024-08-08 13:00:00 | IWM | ETF | 205.35 | 206.74 | 204.72 | 206.25 | 1873039.0 |
| 2024-08-08 14:00:00 | IWM | ETF | 206.25 | 206.82 | 206.15 | 206.48 | 1642136.0 |
| 2024-08-08 15:00:00 | IWM | ETF | 206.47 | 207.0 | 205.89 | 206.86 | 4728056.0 |
| 2024-08-08 16:00:00 | IWM | ETF | 206.89 | 207.29 | 206.72 | 206.89 | 1349868.0 |
| 2024-08-08 17:00:00 | IWM | ETF | 206.99 | 206.99 | 206.52 | 206.73 | 80026.0 |
| 2024-08-08 18:00:00 | IWM | ETF | 206.76 | 207.0 | 206.57 | 206.69 | 19263.0 |
| 2024-08-08 19:00:00 | IWM | ETF | 206.75 | 207.2394 | 206.58 | 207.19 | 97668.0 |
| 2024-08-08 04:00:00 | DIA | ETF | 386.7 | 386.79 | 386.53 | 386.79 | 400.0 |
| 2024-08-08 05:00:00 | DIA | ETF | 387.36 | 387.36 | 386.04 | 386.04 | 6477.0 |
> showing 50 of 20,789 rows — these rows as CSV