PREVIEW / etf_1hour / 2024-05-30
file: by_date/etf_1hour/2024/2024-05-30.parquet size: 534 KB rows: 19,926
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-30 04:00:00 | SPY | ETF | 523.5 | 523.89 | 523.31 | 523.89 | 13324.0 |
| 2024-05-30 05:00:00 | SPY | ETF | 523.89 | 523.95 | 523.55 | 523.68 | 4181.0 |
| 2024-05-30 06:00:00 | SPY | ETF | 523.6 | 524.07 | 523.36 | 524.03 | 42278.0 |
| 2024-05-30 07:00:00 | SPY | ETF | 523.96 | 524.18 | 523.8 | 523.88 | 143775.0 |
| 2024-05-30 08:00:00 | SPY | ETF | 523.91 | 524.8 | 522.7 | 524.34 | 565151.0 |
| 2024-05-30 09:00:00 | SPY | ETF | 524.329 | 524.99 | 523.92 | 524.59 | 3242292.0 |
| 2024-05-30 10:00:00 | SPY | ETF | 524.61 | 524.82 | 523.06 | 523.41 | 3958833.0 |
| 2024-05-30 11:00:00 | SPY | ETF | 523.38 | 524.38 | 522.89 | 523.7 | 2813462.0 |
| 2024-05-30 12:00:00 | SPY | ETF | 523.715 | 524.715 | 523.695 | 524.669 | 2122250.0 |
| 2024-05-30 13:00:00 | SPY | ETF | 524.67 | 525.2 | 524.5099 | 524.78 | 2294727.0 |
| 2024-05-30 14:00:00 | SPY | ETF | 524.78 | 524.83 | 523.6 | 524.07 | 2857751.0 |
| 2024-05-30 15:00:00 | SPY | ETF | 524.07 | 524.22 | 521.33 | 522.63 | 10520797.0 |
| 2024-05-30 16:00:00 | SPY | ETF | 522.64 | 522.6773 | 521.78 | 522.54 | 3551459.0 |
| 2024-05-30 17:00:00 | SPY | ETF | 522.44 | 522.6 | 521.99 | 522.31 | 196448.0 |
| 2024-05-30 18:00:00 | SPY | ETF | 522.46 | 522.53 | 521.9 | 522.1 | 97233.0 |
| 2024-05-30 19:00:00 | SPY | ETF | 522.07 | 522.15 | 521.79 | 521.82 | 30088.0 |
| 2024-05-30 04:00:00 | QQQ | ETF | 453.93 | 454.89 | 453.93 | 454.85 | 22115.0 |
| 2024-05-30 05:00:00 | QQQ | ETF | 454.82 | 454.85 | 454.45 | 454.68 | 11847.0 |
| 2024-05-30 06:00:00 | QQQ | ETF | 454.62 | 455.3 | 454.34 | 455.3 | 111331.0 |
| 2024-05-30 07:00:00 | QQQ | ETF | 455.25 | 455.429 | 454.95 | 455.04 | 100537.0 |
| 2024-05-30 08:00:00 | QQQ | ETF | 455.2502 | 456.03 | 453.0 | 455.51 | 270763.0 |
| 2024-05-30 09:00:00 | QQQ | ETF | 455.43 | 455.6992 | 453.9016 | 454.85 | 2576538.0 |
| 2024-05-30 10:00:00 | QQQ | ETF | 454.92 | 455.2199 | 452.62 | 452.9401 | 3718129.0 |
| 2024-05-30 11:00:00 | QQQ | ETF | 452.92 | 453.88 | 452.1 | 453.1602 | 1995282.0 |
| 2024-05-30 12:00:00 | QQQ | ETF | 453.18 | 454.07 | 453.18 | 453.84 | 1169808.0 |
| 2024-05-30 13:00:00 | QQQ | ETF | 453.85 | 454.61 | 453.62 | 454.01 | 1386117.0 |
| 2024-05-30 14:00:00 | QQQ | ETF | 453.98 | 454.032 | 452.74 | 453.21 | 1685644.0 |
| 2024-05-30 15:00:00 | QQQ | ETF | 453.21 | 453.31 | 450.21 | 451.55 | 6552732.0 |
| 2024-05-30 16:00:00 | QQQ | ETF | 451.56 | 451.62 | 450.36 | 451.38 | 2147637.0 |
| 2024-05-30 17:00:00 | QQQ | ETF | 451.32 | 451.4 | 450.37 | 450.71 | 368629.0 |
| 2024-05-30 18:00:00 | QQQ | ETF | 450.71 | 451.55 | 450.42 | 450.69 | 262507.0 |
| 2024-05-30 19:00:00 | QQQ | ETF | 450.68 | 450.9 | 450.37 | 450.44 | 80293.0 |
| 2024-05-30 04:00:00 | IWM | ETF | 201.92 | 202.46 | 201.91 | 202.46 | 21362.0 |
| 2024-05-30 05:00:00 | IWM | ETF | 202.52 | 202.57 | 202.33 | 202.5 | 3731.0 |
| 2024-05-30 06:00:00 | IWM | ETF | 202.47 | 202.62 | 202.26 | 202.62 | 6294.0 |
| 2024-05-30 07:00:00 | IWM | ETF | 202.6 | 202.74 | 202.27 | 202.63 | 61063.0 |
| 2024-05-30 08:00:00 | IWM | ETF | 202.5805 | 203.79 | 201.1 | 203.59 | 461605.0 |
| 2024-05-30 09:00:00 | IWM | ETF | 203.54 | 203.9 | 203.0802 | 203.8 | 2644130.0 |
| 2024-05-30 10:00:00 | IWM | ETF | 203.82 | 204.29 | 203.259 | 204.085 | 2211205.0 |
| 2024-05-30 11:00:00 | IWM | ETF | 204.08 | 204.755 | 203.73 | 204.43 | 1989235.0 |
| 2024-05-30 12:00:00 | IWM | ETF | 204.44 | 204.8799 | 204.44 | 204.7799 | 1101280.0 |
| 2024-05-30 13:00:00 | IWM | ETF | 204.78 | 204.939 | 204.58 | 204.765 | 1140363.0 |
| 2024-05-30 14:00:00 | IWM | ETF | 204.76 | 204.76 | 204.18 | 204.32 | 1115191.0 |
| 2024-05-30 15:00:00 | IWM | ETF | 204.32 | 204.38 | 203.26 | 204.05 | 4686078.0 |
| 2024-05-30 16:00:00 | IWM | ETF | 204.05 | 204.37 | 203.84 | 204.36 | 869287.0 |
| 2024-05-30 17:00:00 | IWM | ETF | 204.13 | 204.29 | 203.72 | 204.0 | 58002.0 |
| 2024-05-30 18:00:00 | IWM | ETF | 204.1 | 204.39 | 203.86 | 203.99 | 107101.0 |
| 2024-05-30 19:00:00 | IWM | ETF | 203.92 | 204.09 | 203.77 | 203.77 | 53247.0 |
| 2024-05-30 04:00:00 | DIA | ETF | 381.34 | 381.34 | 381.34 | 381.34 | 200.0 |
| 2024-05-30 05:00:00 | DIA | ETF | 381.53 | 381.53 | 381.2 | 381.2 | 1142.0 |
> showing 50 of 19,926 rows — these rows as CSV