PREVIEW / etf_1hour / 2024-05-31
file: by_date/etf_1hour/2024/2024-05-31.parquet size: 538 KB rows: 19,987
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-05-31 04:00:00 | SPY | ETF | 521.98 | 522.72 | 521.92 | 522.2 | 13890.0 |
| 2024-05-31 05:00:00 | SPY | ETF | 522.17 | 522.18 | 521.85 | 522.01 | 13778.0 |
| 2024-05-31 06:00:00 | SPY | ETF | 522.05 | 522.05 | 521.0 | 521.61 | 36687.0 |
| 2024-05-31 07:00:00 | SPY | ETF | 521.71 | 522.61 | 521.57 | 522.56 | 100536.0 |
| 2024-05-31 08:00:00 | SPY | ETF | 521.78 | 525.0 | 521.0696 | 524.61 | 782531.0 |
| 2024-05-31 09:00:00 | SPY | ETF | 524.61 | 524.81 | 522.94 | 523.15 | 3833444.0 |
| 2024-05-31 10:00:00 | SPY | ETF | 523.14 | 523.21 | 520.23 | 520.87 | 6542165.0 |
| 2024-05-31 11:00:00 | SPY | ETF | 520.88 | 520.94 | 519.58 | 519.69 | 4215390.0 |
| 2024-05-31 12:00:00 | SPY | ETF | 519.69 | 519.79 | 518.36 | 519.53 | 4703940.0 |
| 2024-05-31 13:00:00 | SPY | ETF | 519.53 | 521.04 | 519.52 | 520.85 | 4019884.0 |
| 2024-05-31 14:00:00 | SPY | ETF | 520.86 | 521.8 | 520.58 | 521.47 | 3911175.0 |
| 2024-05-31 15:00:00 | SPY | ETF | 521.465 | 527.5 | 521.035 | 527.35 | 24461094.0 |
| 2024-05-31 16:00:00 | SPY | ETF | 527.35 | 528.36 | 526.6 | 527.62 | 8321343.0 |
| 2024-05-31 17:00:00 | SPY | ETF | 527.5299 | 528.02 | 527.37 | 528.02 | 219168.0 |
| 2024-05-31 18:00:00 | SPY | ETF | 528.05 | 528.13 | 526.9052 | 528.0 | 661353.0 |
| 2024-05-31 19:00:00 | SPY | ETF | 528.04 | 528.2603 | 528.0 | 528.22 | 42021.0 |
| 2024-05-31 04:00:00 | QQQ | ETF | 450.24 | 451.0 | 449.8 | 450.36 | 68685.0 |
| 2024-05-31 05:00:00 | QQQ | ETF | 450.19 | 450.41 | 449.9 | 450.35 | 18281.0 |
| 2024-05-31 06:00:00 | QQQ | ETF | 450.4 | 450.42 | 448.99 | 449.81 | 87676.0 |
| 2024-05-31 07:00:00 | QQQ | ETF | 449.85 | 450.88 | 449.68 | 450.85 | 117889.0 |
| 2024-05-31 08:00:00 | QQQ | ETF | 450.18 | 453.38 | 449.0896 | 452.88 | 1008013.0 |
| 2024-05-31 09:00:00 | QQQ | ETF | 452.86 | 453.09 | 450.01 | 450.36 | 3004318.0 |
| 2024-05-31 10:00:00 | QQQ | ETF | 450.35 | 450.45 | 445.821 | 446.55 | 6834587.0 |
| 2024-05-31 11:00:00 | QQQ | ETF | 446.57 | 446.61 | 444.35 | 444.5 | 3607824.0 |
| 2024-05-31 12:00:00 | QQQ | ETF | 444.49 | 444.8 | 443.055 | 444.31 | 3719318.0 |
| 2024-05-31 13:00:00 | QQQ | ETF | 444.295 | 446.1 | 444.29 | 445.47 | 3425937.0 |
| 2024-05-31 14:00:00 | QQQ | ETF | 445.49 | 446.08 | 444.7401 | 445.74 | 2691858.0 |
| 2024-05-31 15:00:00 | QQQ | ETF | 445.74 | 451.76 | 445.43 | 451.72 | 11391682.0 |
| 2024-05-31 16:00:00 | QQQ | ETF | 451.71 | 452.35 | 450.71 | 451.02 | 2907403.0 |
| 2024-05-31 17:00:00 | QQQ | ETF | 451.034 | 451.5073 | 450.71 | 451.35 | 527094.0 |
| 2024-05-31 18:00:00 | QQQ | ETF | 451.39 | 451.5 | 451.3 | 451.49 | 27659.0 |
| 2024-05-31 19:00:00 | QQQ | ETF | 451.49 | 451.65 | 451.46 | 451.62 | 14244.0 |
| 2024-05-31 04:00:00 | IWM | ETF | 203.82 | 204.01 | 203.7 | 203.79 | 12855.0 |
| 2024-05-31 05:00:00 | IWM | ETF | 203.58 | 203.58 | 203.32 | 203.56 | 7872.0 |
| 2024-05-31 06:00:00 | IWM | ETF | 203.57 | 203.71 | 202.98 | 203.35 | 91544.0 |
| 2024-05-31 07:00:00 | IWM | ETF | 203.48 | 203.68 | 203.32 | 203.62 | 81426.0 |
| 2024-05-31 08:00:00 | IWM | ETF | 203.6997 | 205.91 | 203.2904 | 205.76 | 585859.0 |
| 2024-05-31 09:00:00 | IWM | ETF | 205.67 | 206.28 | 204.47 | 205.42 | 2296687.0 |
| 2024-05-31 10:00:00 | IWM | ETF | 205.4 | 205.45 | 203.735 | 204.26 | 2271439.0 |
| 2024-05-31 11:00:00 | IWM | ETF | 204.27 | 204.3 | 203.63 | 203.75 | 1927968.0 |
| 2024-05-31 12:00:00 | IWM | ETF | 203.74 | 203.75 | 203.08 | 203.65 | 1744504.0 |
| 2024-05-31 13:00:00 | IWM | ETF | 203.65 | 204.6 | 203.645 | 204.33 | 1963324.0 |
| 2024-05-31 14:00:00 | IWM | ETF | 204.33 | 204.54 | 203.955 | 204.205 | 1960494.0 |
| 2024-05-31 15:00:00 | IWM | ETF | 204.2 | 205.73 | 204.02 | 205.73 | 6159069.0 |
| 2024-05-31 16:00:00 | IWM | ETF | 205.77 | 206.25 | 205.5191 | 206.01 | 2562047.0 |
| 2024-05-31 17:00:00 | IWM | ETF | 206.01 | 206.22 | 205.96 | 206.13 | 60892.0 |
| 2024-05-31 18:00:00 | IWM | ETF | 206.18 | 206.43 | 206.1 | 206.4 | 56544.0 |
| 2024-05-31 19:00:00 | IWM | ETF | 206.29 | 206.49 | 206.24 | 206.47 | 21089.0 |
| 2024-05-31 04:00:00 | DIA | ETF | 381.55 | 381.87 | 381.55 | 381.61 | 1632.0 |
| 2024-05-31 05:00:00 | DIA | ETF | 381.44 | 381.5 | 381.39 | 381.44 | 4300.0 |
> showing 50 of 19,987 rows — these rows as CSV