PREVIEW / etf_1hour / 2024-09-23
file: by_date/etf_1hour/2024/2024-09-23.parquet size: 561 KB rows: 21,089
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-09-23 04:00:00 | SPY | ETF | 569.19 | 569.19 | 567.86 | 568.55 | 113161.0 |
| 2024-09-23 05:00:00 | SPY | ETF | 568.55 | 569.16 | 567.92 | 569.06 | 71741.0 |
| 2024-09-23 06:00:00 | SPY | ETF | 569.18 | 569.26 | 568.85 | 568.85 | 19539.0 |
| 2024-09-23 07:00:00 | SPY | ETF | 568.83 | 569.15 | 568.26 | 569.07 | 175283.0 |
| 2024-09-23 08:00:00 | SPY | ETF | 569.04 | 569.94 | 567.0 | 569.25 | 128230.0 |
| 2024-09-23 09:00:00 | SPY | ETF | 569.31 | 569.62 | 568.25 | 568.8 | 3322808.0 |
| 2024-09-23 10:00:00 | SPY | ETF | 568.78 | 570.3325 | 568.4001 | 569.85 | 3253935.0 |
| 2024-09-23 11:00:00 | SPY | ETF | 569.86 | 570.15 | 568.73 | 569.5995 | 2286380.0 |
| 2024-09-23 12:00:00 | SPY | ETF | 569.59 | 569.65 | 568.25 | 568.63 | 2382870.0 |
| 2024-09-23 13:00:00 | SPY | ETF | 568.6399 | 569.34 | 568.1 | 569.295 | 2098809.0 |
| 2024-09-23 14:00:00 | SPY | ETF | 569.29 | 569.54 | 568.83 | 569.46 | 1407722.0 |
| 2024-09-23 15:00:00 | SPY | ETF | 569.47 | 569.91 | 569.0524 | 569.6 | 5192521.0 |
| 2024-09-23 16:00:00 | SPY | ETF | 569.61 | 569.79 | 569.32 | 569.52 | 5373868.0 |
| 2024-09-23 17:00:00 | SPY | ETF | 569.52 | 569.54 | 569.4 | 569.4392 | 13310.0 |
| 2024-09-23 18:00:00 | SPY | ETF | 569.35 | 569.35 | 569.04 | 569.07 | 11700.0 |
| 2024-09-23 19:00:00 | SPY | ETF | 569.05 | 569.37 | 569.0 | 569.3 | 8566.0 |
| 2024-09-23 04:00:00 | QQQ | ETF | 482.48 | 482.87 | 481.61 | 482.21 | 109089.0 |
| 2024-09-23 05:00:00 | QQQ | ETF | 482.26 | 483.15 | 481.84 | 483.02 | 88666.0 |
| 2024-09-23 06:00:00 | QQQ | ETF | 483.18 | 483.31 | 482.82 | 482.82 | 27312.0 |
| 2024-09-23 07:00:00 | QQQ | ETF | 482.9 | 483.11 | 482.2 | 483.0 | 91850.0 |
| 2024-09-23 08:00:00 | QQQ | ETF | 482.96 | 484.82 | 480.15 | 483.1699 | 159671.0 |
| 2024-09-23 09:00:00 | QQQ | ETF | 483.2 | 483.67 | 481.87 | 482.72 | 2605782.0 |
| 2024-09-23 10:00:00 | QQQ | ETF | 482.73 | 484.14 | 482.21 | 483.44 | 3931741.0 |
| 2024-09-23 11:00:00 | QQQ | ETF | 483.44 | 484.09 | 482.28 | 483.66 | 1825847.0 |
| 2024-09-23 12:00:00 | QQQ | ETF | 483.64 | 483.67 | 482.01 | 482.26 | 1540399.0 |
| 2024-09-23 13:00:00 | QQQ | ETF | 482.2337 | 483.0 | 481.6 | 482.922 | 1491125.0 |
| 2024-09-23 14:00:00 | QQQ | ETF | 482.92 | 483.21 | 482.53 | 483.14 | 1223793.0 |
| 2024-09-23 15:00:00 | QQQ | ETF | 483.1131 | 483.32 | 482.47 | 483.02 | 2196459.0 |
| 2024-09-23 16:00:00 | QQQ | ETF | 483.02 | 483.23 | 482.5 | 482.67 | 1923345.0 |
| 2024-09-23 17:00:00 | QQQ | ETF | 482.6992 | 482.8 | 482.6499 | 482.65 | 9139.0 |
| 2024-09-23 18:00:00 | QQQ | ETF | 482.64 | 482.64 | 482.3 | 482.38 | 16475.0 |
| 2024-09-23 19:00:00 | QQQ | ETF | 482.38 | 482.88 | 482.25 | 482.82 | 25064.0 |
| 2024-09-23 04:00:00 | IWM | ETF | 222.15 | 222.8 | 221.8 | 222.17 | 22016.0 |
| 2024-09-23 05:00:00 | IWM | ETF | 222.04 | 222.26 | 221.93 | 222.23 | 3182.0 |
| 2024-09-23 06:00:00 | IWM | ETF | 222.3 | 222.69 | 222.3 | 222.69 | 14446.0 |
| 2024-09-23 07:00:00 | IWM | ETF | 222.41 | 222.79 | 222.3 | 222.74 | 111790.0 |
| 2024-09-23 08:00:00 | IWM | ETF | 222.44 | 223.27 | 221.2 | 222.64 | 71385.0 |
| 2024-09-23 09:00:00 | IWM | ETF | 222.7 | 223.11 | 221.44 | 222.26 | 2826391.0 |
| 2024-09-23 10:00:00 | IWM | ETF | 222.28 | 222.65 | 220.7 | 220.72 | 3135053.0 |
| 2024-09-23 11:00:00 | IWM | ETF | 220.73 | 220.9 | 220.02 | 220.83 | 1932095.0 |
| 2024-09-23 12:00:00 | IWM | ETF | 220.82 | 220.85 | 220.1101 | 220.7493 | 1252201.0 |
| 2024-09-23 13:00:00 | IWM | ETF | 220.73 | 221.11 | 220.5001 | 220.89 | 1060493.0 |
| 2024-09-23 14:00:00 | IWM | ETF | 220.895 | 221.155 | 220.57 | 220.885 | 942082.0 |
| 2024-09-23 15:00:00 | IWM | ETF | 220.88 | 221.23 | 220.68 | 220.77 | 2730611.0 |
| 2024-09-23 16:00:00 | IWM | ETF | 220.76 | 220.9 | 220.66 | 220.75 | 828485.0 |
| 2024-09-23 17:00:00 | IWM | ETF | 220.74 | 220.77 | 220.71 | 220.77 | 2281.0 |
| 2024-09-23 18:00:00 | IWM | ETF | 220.76 | 220.77 | 220.58 | 220.63 | 11713.0 |
| 2024-09-23 19:00:00 | IWM | ETF | 220.6 | 220.71 | 220.55 | 220.62 | 8986.0 |
| 2024-09-23 04:00:00 | DIA | ETF | 420.43 | 420.61 | 420.31 | 420.52 | 3359.0 |
| 2024-09-23 05:00:00 | DIA | ETF | 420.44 | 420.72 | 420.44 | 420.72 | 700.0 |
> showing 50 of 21,089 rows — these rows as CSV