PREVIEW / etf_1hour / 2024-08-07
file: by_date/etf_1hour/2024/2024-08-07.parquet size: 560 KB rows: 21,475
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-07 04:00:00 | SPY | ETF | 524.05 | 527.38 | 524.05 | 527.38 | 82720.0 |
| 2024-08-07 05:00:00 | SPY | ETF | 527.51 | 528.41 | 527.14 | 528.08 | 122236.0 |
| 2024-08-07 06:00:00 | SPY | ETF | 528.08 | 528.85 | 527.84 | 528.71 | 96443.0 |
| 2024-08-07 07:00:00 | SPY | ETF | 528.6 | 529.05 | 527.6 | 527.7 | 470212.0 |
| 2024-08-07 08:00:00 | SPY | ETF | 528.64 | 529.03 | 521.25 | 528.3 | 543378.0 |
| 2024-08-07 09:00:00 | SPY | ETF | 528.35 | 531.19 | 527.65 | 531.01 | 5749609.0 |
| 2024-08-07 10:00:00 | SPY | ETF | 531.04 | 531.59 | 528.28 | 530.415 | 5664544.0 |
| 2024-08-07 11:00:00 | SPY | ETF | 530.47 | 531.15 | 527.08 | 528.02 | 4010412.0 |
| 2024-08-07 12:00:00 | SPY | ETF | 528.03 | 528.08 | 524.65 | 525.075 | 4876681.0 |
| 2024-08-07 13:00:00 | SPY | ETF | 525.065 | 525.38 | 521.49 | 522.04 | 6897963.0 |
| 2024-08-07 14:00:00 | SPY | ETF | 522.03 | 522.21 | 518.83 | 519.5066 | 8291762.0 |
| 2024-08-07 15:00:00 | SPY | ETF | 519.45 | 522.1 | 518.0519 | 518.65 | 12380374.0 |
| 2024-08-07 16:00:00 | SPY | ETF | 518.65 | 522.9611 | 515.55 | 516.16 | 5283593.0 |
| 2024-08-07 17:00:00 | SPY | ETF | 516.18 | 518.66 | 515.75 | 516.57 | 565064.0 |
| 2024-08-07 18:00:00 | SPY | ETF | 516.68 | 517.67 | 516.25 | 517.1 | 215434.0 |
| 2024-08-07 19:00:00 | SPY | ETF | 516.94 | 517.27 | 514.14 | 515.95 | 152697.0 |
| 2024-08-07 04:00:00 | QQQ | ETF | 441.89 | 445.0 | 441.4 | 445.0 | 159665.0 |
| 2024-08-07 05:00:00 | QQQ | ETF | 445.03 | 446.21 | 444.5 | 445.47 | 60337.0 |
| 2024-08-07 06:00:00 | QQQ | ETF | 445.32 | 446.41 | 445.16 | 446.19 | 73383.0 |
| 2024-08-07 07:00:00 | QQQ | ETF | 446.04 | 446.64 | 444.71 | 445.0 | 210096.0 |
| 2024-08-07 08:00:00 | QQQ | ETF | 442.53 | 446.63 | 441.0 | 445.99 | 362593.0 |
| 2024-08-07 09:00:00 | QQQ | ETF | 445.93 | 449.0 | 445.3 | 448.11 | 4970069.0 |
| 2024-08-07 10:00:00 | QQQ | ETF | 448.12 | 448.98 | 445.31 | 447.88 | 4849314.0 |
| 2024-08-07 11:00:00 | QQQ | ETF | 447.93 | 448.76 | 443.8 | 445.2 | 3741390.0 |
| 2024-08-07 12:00:00 | QQQ | ETF | 445.23 | 445.31 | 441.78 | 442.34 | 3888762.0 |
| 2024-08-07 13:00:00 | QQQ | ETF | 442.28 | 442.72 | 437.84 | 438.4 | 5153374.0 |
| 2024-08-07 14:00:00 | QQQ | ETF | 438.33 | 438.76 | 435.55 | 436.22 | 5179488.0 |
| 2024-08-07 15:00:00 | QQQ | ETF | 436.2 | 439.09 | 434.37 | 434.83 | 6915469.0 |
| 2024-08-07 16:00:00 | QQQ | ETF | 434.88 | 447.3724 | 431.63 | 432.09 | 1759076.0 |
| 2024-08-07 17:00:00 | QQQ | ETF | 432.04 | 432.61 | 431.86 | 432.45 | 98042.0 |
| 2024-08-07 18:00:00 | QQQ | ETF | 432.58 | 433.7018 | 432.24 | 433.05 | 210674.0 |
| 2024-08-07 19:00:00 | QQQ | ETF | 432.97 | 433.12 | 429.47 | 431.66 | 279502.0 |
| 2024-08-07 04:00:00 | IWM | ETF | 206.02 | 207.93 | 206.0 | 207.86 | 43048.0 |
| 2024-08-07 05:00:00 | IWM | ETF | 207.84 | 208.19 | 207.53 | 208.14 | 59971.0 |
| 2024-08-07 06:00:00 | IWM | ETF | 208.2 | 208.47 | 207.93 | 208.29 | 115500.0 |
| 2024-08-07 07:00:00 | IWM | ETF | 208.25 | 208.5 | 207.54 | 207.77 | 202184.0 |
| 2024-08-07 08:00:00 | IWM | ETF | 208.1 | 208.48 | 205.56 | 207.93 | 255074.0 |
| 2024-08-07 09:00:00 | IWM | ETF | 207.93 | 208.03 | 206.48 | 207.7 | 3589330.0 |
| 2024-08-07 10:00:00 | IWM | ETF | 207.69 | 207.89 | 205.4 | 206.235 | 3226910.0 |
| 2024-08-07 11:00:00 | IWM | ETF | 206.25 | 206.88 | 204.85 | 205.58 | 1900908.0 |
| 2024-08-07 12:00:00 | IWM | ETF | 205.55 | 205.8 | 203.97 | 204.3 | 1818707.0 |
| 2024-08-07 13:00:00 | IWM | ETF | 204.29 | 204.52 | 202.38 | 202.8 | 2593557.0 |
| 2024-08-07 14:00:00 | IWM | ETF | 202.74 | 203.01 | 201.57 | 201.95 | 3039533.0 |
| 2024-08-07 15:00:00 | IWM | ETF | 201.94 | 203.12 | 201.56 | 202.05 | 4532211.0 |
| 2024-08-07 16:00:00 | IWM | ETF | 201.98 | 202.27 | 200.9 | 201.1 | 1398709.0 |
| 2024-08-07 17:00:00 | IWM | ETF | 201.1 | 201.98 | 200.71 | 201.25 | 187411.0 |
| 2024-08-07 18:00:00 | IWM | ETF | 201.25 | 201.79 | 201.12 | 201.42 | 51235.0 |
| 2024-08-07 19:00:00 | IWM | ETF | 201.4 | 201.4 | 199.99 | 200.98 | 143605.0 |
| 2024-08-07 04:00:00 | DIA | ETF | 391.87 | 392.82 | 391.84 | 392.69 | 1400.0 |
| 2024-08-07 05:00:00 | DIA | ETF | 392.98 | 393.18 | 392.88 | 393.1 | 2500.0 |
> showing 50 of 21,475 rows — these rows as CSV