PREVIEW / etf_1hour / 2022-09-28
file: by_date/etf_1hour/2022/2022-09-28.parquet size: 469 KB rows: 17,458
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 |
|---|---|---|---|---|---|---|---|
| 2022-09-28 04:00:00 | SPY | ETF | 361.77 | 361.87 | 360.19 | 361.02 | 96614.0 |
| 2022-09-28 05:00:00 | SPY | ETF | 360.94 | 360.98 | 358.72 | 359.11 | 174285.0 |
| 2022-09-28 06:00:00 | SPY | ETF | 359.07 | 363.83 | 358.83 | 362.32 | 733270.0 |
| 2022-09-28 07:00:00 | SPY | ETF | 362.23 | 362.5 | 360.64 | 361.2 | 523972.0 |
| 2022-09-28 08:00:00 | SPY | ETF | 361.25 | 365.41 | 359.0004 | 364.4 | 1372181.0 |
| 2022-09-28 09:00:00 | SPY | ETF | 364.4 | 365.25 | 362.6 | 364.305 | 9948499.0 |
| 2022-09-28 10:00:00 | SPY | ETF | 364.305 | 367.5 | 363.15 | 366.51 | 12483583.0 |
| 2022-09-28 11:00:00 | SPY | ETF | 366.54 | 368.46 | 366.16 | 368.3216 | 8518960.0 |
| 2022-09-28 12:00:00 | SPY | ETF | 368.35 | 369.57 | 368.11 | 368.88 | 7329503.0 |
| 2022-09-28 13:00:00 | SPY | ETF | 368.9 | 370.0 | 368.23 | 368.71 | 7463840.0 |
| 2022-09-28 14:00:00 | SPY | ETF | 368.71 | 369.8048 | 368.38 | 369.46 | 6033274.0 |
| 2022-09-28 15:00:00 | SPY | ETF | 369.47 | 372.3 | 369.36 | 370.48 | 19463384.0 |
| 2022-09-28 16:00:00 | SPY | ETF | 370.48 | 371.1676 | 370.1 | 370.25 | 6129332.0 |
| 2022-09-28 17:00:00 | SPY | ETF | 370.11 | 370.53 | 370.11 | 370.25 | 203052.0 |
| 2022-09-28 18:00:00 | SPY | ETF | 370.25 | 370.78 | 369.59 | 369.89 | 152887.0 |
| 2022-09-28 19:00:00 | SPY | ETF | 369.89 | 370.15 | 369.76 | 370.0 | 116232.0 |
| 2022-09-28 04:00:00 | QQQ | ETF | 272.83 | 272.83 | 270.95 | 271.67 | 95593.0 |
| 2022-09-28 05:00:00 | QQQ | ETF | 271.69 | 271.78 | 270.03 | 270.27 | 117616.0 |
| 2022-09-28 06:00:00 | QQQ | ETF | 270.13 | 273.99 | 269.96 | 272.41 | 930626.0 |
| 2022-09-28 07:00:00 | QQQ | ETF | 272.53 | 272.74 | 271.15 | 271.72 | 612082.0 |
| 2022-09-28 08:00:00 | QQQ | ETF | 272.61 | 275.05 | 270.1904 | 274.25 | 1462211.0 |
| 2022-09-28 09:00:00 | QQQ | ETF | 274.25 | 275.0 | 272.945 | 274.0101 | 7512867.0 |
| 2022-09-28 10:00:00 | QQQ | ETF | 274.03 | 276.92 | 273.04 | 276.07 | 10361639.0 |
| 2022-09-28 11:00:00 | QQQ | ETF | 276.09 | 278.1 | 275.76 | 278.04 | 6330056.0 |
| 2022-09-28 12:00:00 | QQQ | ETF | 278.04 | 278.85 | 277.44 | 277.97 | 4936699.0 |
| 2022-09-28 13:00:00 | QQQ | ETF | 278.0 | 278.9802 | 277.44 | 277.96 | 4688543.0 |
| 2022-09-28 14:00:00 | QQQ | ETF | 277.96 | 279.19 | 277.84 | 278.9464 | 3922692.0 |
| 2022-09-28 15:00:00 | QQQ | ETF | 278.955 | 281.25 | 278.86 | 279.87 | 9366807.0 |
| 2022-09-28 16:00:00 | QQQ | ETF | 279.86 | 280.18 | 279.41 | 279.5 | 3296714.0 |
| 2022-09-28 17:00:00 | QQQ | ETF | 279.52 | 279.94 | 279.5 | 279.69 | 695857.0 |
| 2022-09-28 18:00:00 | QQQ | ETF | 279.68 | 280.05 | 279.1 | 279.3 | 135221.0 |
| 2022-09-28 19:00:00 | QQQ | ETF | 279.34 | 279.53 | 279.11 | 279.38 | 111234.0 |
| 2022-09-28 04:00:00 | IWM | ETF | 163.95 | 164.12 | 163.36 | 163.9 | 56917.0 |
| 2022-09-28 05:00:00 | IWM | ETF | 163.8 | 163.8 | 162.77 | 163.1 | 46019.0 |
| 2022-09-28 06:00:00 | IWM | ETF | 163.03 | 165.5 | 163.03 | 164.6 | 99625.0 |
| 2022-09-28 07:00:00 | IWM | ETF | 164.62 | 164.89 | 163.92 | 164.12 | 126246.0 |
| 2022-09-28 08:00:00 | IWM | ETF | 164.64 | 166.32 | 163.99 | 165.65 | 344100.0 |
| 2022-09-28 09:00:00 | IWM | ETF | 165.54 | 166.91 | 164.94 | 166.6 | 2837754.0 |
| 2022-09-28 10:00:00 | IWM | ETF | 166.59 | 168.155 | 165.99 | 167.605 | 4776586.0 |
| 2022-09-28 11:00:00 | IWM | ETF | 167.56 | 169.14 | 167.38 | 169.075 | 3226859.0 |
| 2022-09-28 12:00:00 | IWM | ETF | 169.09 | 169.565 | 168.73 | 169.045 | 3293063.0 |
| 2022-09-28 13:00:00 | IWM | ETF | 169.05 | 169.59 | 168.86 | 169.26 | 1672857.0 |
| 2022-09-28 14:00:00 | IWM | ETF | 169.28 | 169.82 | 169.22 | 169.68 | 1542532.0 |
| 2022-09-28 15:00:00 | IWM | ETF | 169.7 | 170.99 | 169.64 | 169.95 | 5417351.0 |
| 2022-09-28 16:00:00 | IWM | ETF | 169.94 | 170.4037 | 169.85 | 170.0 | 1533655.0 |
| 2022-09-28 17:00:00 | IWM | ETF | 170.0 | 170.12 | 169.94 | 170.03 | 58286.0 |
| 2022-09-28 18:00:00 | IWM | ETF | 170.03 | 170.31 | 169.73 | 169.79 | 78476.0 |
| 2022-09-28 19:00:00 | IWM | ETF | 169.8 | 169.93 | 169.71 | 169.86 | 23706.0 |
| 2022-09-28 04:00:00 | DIA | ETF | 289.25 | 290.0 | 288.0 | 289.66 | 1670.0 |
| 2022-09-28 05:00:00 | DIA | ETF | 288.9 | 288.9 | 288.13 | 288.46 | 6045.0 |
> showing 50 of 17,458 rows — these rows as CSV