PREVIEW / etf_1hour / 2024-10-03
file: by_date/etf_1hour/2024/2024-10-03.parquet size: 567 KB rows: 21,243
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-10-03 04:00:00 | SPY | ETF | 567.78 | 567.78 | 566.11 | 566.86 | 36121.0 |
| 2024-10-03 05:00:00 | SPY | ETF | 566.94 | 567.2 | 566.65 | 567.1 | 9104.0 |
| 2024-10-03 06:00:00 | SPY | ETF | 567.2 | 567.48 | 566.8 | 567.47 | 22365.0 |
| 2024-10-03 07:00:00 | SPY | ETF | 567.58 | 568.35 | 567.3 | 568.34 | 77833.0 |
| 2024-10-03 08:00:00 | SPY | ETF | 568.38 | 568.73 | 565.9 | 567.37 | 232666.0 |
| 2024-10-03 09:00:00 | SPY | ETF | 567.41 | 568.29 | 566.82 | 567.84 | 2860868.0 |
| 2024-10-03 10:00:00 | SPY | ETF | 567.81 | 569.8025 | 566.24 | 566.68 | 6342347.0 |
| 2024-10-03 11:00:00 | SPY | ETF | 566.67 | 568.9799 | 566.24 | 568.44 | 2291357.0 |
| 2024-10-03 12:00:00 | SPY | ETF | 568.46 | 569.16 | 565.86 | 566.4 | 3233549.0 |
| 2024-10-03 13:00:00 | SPY | ETF | 566.4 | 567.45 | 565.49 | 567.089 | 3670048.0 |
| 2024-10-03 14:00:00 | SPY | ETF | 567.0609 | 567.42 | 566.47 | 566.76 | 1783344.0 |
| 2024-10-03 15:00:00 | SPY | ETF | 566.77 | 568.27 | 566.05 | 567.78 | 6946293.0 |
| 2024-10-03 16:00:00 | SPY | ETF | 567.8 | 568.26 | 567.3 | 567.32 | 2321778.0 |
| 2024-10-03 17:00:00 | SPY | ETF | 567.45 | 567.53 | 567.32 | 567.4994 | 52384.0 |
| 2024-10-03 18:00:00 | SPY | ETF | 567.28 | 568.1 | 567.0 | 567.79 | 80313.0 |
| 2024-10-03 19:00:00 | SPY | ETF | 567.78 | 567.92 | 567.51 | 567.8001 | 40399.0 |
| 2024-10-03 04:00:00 | QQQ | ETF | 479.2 | 480.12 | 479.03 | 479.73 | 39625.0 |
| 2024-10-03 05:00:00 | QQQ | ETF | 479.69 | 480.1 | 479.43 | 479.89 | 25693.0 |
| 2024-10-03 06:00:00 | QQQ | ETF | 479.97 | 480.55 | 479.6 | 480.55 | 26436.0 |
| 2024-10-03 07:00:00 | QQQ | ETF | 480.58 | 481.29 | 480.2 | 481.26 | 89090.0 |
| 2024-10-03 08:00:00 | QQQ | ETF | 480.82 | 481.7 | 478.49 | 480.0 | 314681.0 |
| 2024-10-03 09:00:00 | QQQ | ETF | 479.96 | 482.99 | 479.37 | 482.46 | 2141449.0 |
| 2024-10-03 10:00:00 | QQQ | ETF | 482.41 | 484.545 | 479.8087 | 480.44 | 5036615.0 |
| 2024-10-03 11:00:00 | QQQ | ETF | 480.44 | 483.2525 | 480.13 | 482.7913 | 2332103.0 |
| 2024-10-03 12:00:00 | QQQ | ETF | 482.79 | 483.09 | 479.54 | 479.97 | 2407278.0 |
| 2024-10-03 13:00:00 | QQQ | ETF | 479.97 | 481.6 | 478.99 | 480.98 | 2096705.0 |
| 2024-10-03 14:00:00 | QQQ | ETF | 480.985 | 481.3 | 480.09 | 480.54 | 1078683.0 |
| 2024-10-03 15:00:00 | QQQ | ETF | 480.52 | 482.03 | 479.82 | 481.63 | 3294953.0 |
| 2024-10-03 16:00:00 | QQQ | ETF | 481.62 | 482.29 | 480.84 | 480.96 | 966366.0 |
| 2024-10-03 17:00:00 | QQQ | ETF | 481.0 | 481.59 | 480.98 | 481.16 | 24379.0 |
| 2024-10-03 18:00:00 | QQQ | ETF | 481.04 | 481.79 | 480.53 | 481.47 | 71531.0 |
| 2024-10-03 19:00:00 | QQQ | ETF | 481.56 | 481.61 | 481.13 | 481.46 | 62042.0 |
| 2024-10-03 04:00:00 | IWM | ETF | 215.99 | 216.3 | 215.84 | 216.09 | 13112.0 |
| 2024-10-03 05:00:00 | IWM | ETF | 216.12 | 216.35 | 215.95 | 216.23 | 5241.0 |
| 2024-10-03 06:00:00 | IWM | ETF | 216.28 | 216.38 | 215.92 | 216.3 | 4732.0 |
| 2024-10-03 07:00:00 | IWM | ETF | 216.41 | 216.9 | 216.37 | 216.9 | 34122.0 |
| 2024-10-03 08:00:00 | IWM | ETF | 216.44 | 217.22 | 215.75 | 216.56 | 109473.0 |
| 2024-10-03 09:00:00 | IWM | ETF | 216.48 | 216.68 | 215.16 | 215.95 | 2701303.0 |
| 2024-10-03 10:00:00 | IWM | ETF | 215.98 | 217.23 | 215.18 | 215.53 | 3279838.0 |
| 2024-10-03 11:00:00 | IWM | ETF | 215.49 | 216.98 | 215.37 | 216.74 | 1352569.0 |
| 2024-10-03 12:00:00 | IWM | ETF | 216.7592 | 217.13 | 215.51 | 215.6615 | 1408377.0 |
| 2024-10-03 13:00:00 | IWM | ETF | 215.66 | 215.98 | 215.08 | 215.6 | 1999505.0 |
| 2024-10-03 14:00:00 | IWM | ETF | 215.56 | 216.23 | 215.4197 | 215.688 | 1492650.0 |
| 2024-10-03 15:00:00 | IWM | ETF | 215.695 | 216.18 | 215.485 | 216.11 | 3121990.0 |
| 2024-10-03 16:00:00 | IWM | ETF | 216.13 | 216.23 | 215.93 | 215.95 | 1048459.0 |
| 2024-10-03 17:00:00 | IWM | ETF | 215.98 | 216.03 | 215.76 | 215.95 | 20805.0 |
| 2024-10-03 18:00:00 | IWM | ETF | 215.99 | 216.45 | 215.85 | 216.29 | 32718.0 |
| 2024-10-03 19:00:00 | IWM | ETF | 216.271 | 216.6 | 216.17 | 216.5 | 68375.0 |
| 2024-10-03 04:00:00 | DIA | ETF | 419.85 | 420.47 | 419.85 | 420.35 | 1910.0 |
| 2024-10-03 05:00:00 | DIA | ETF | 420.6 | 420.6 | 420.57 | 420.58 | 1200.0 |
> showing 50 of 21,243 rows — these rows as CSV