PREVIEW / etf_1hour / 2025-01-29
file: by_date/etf_1hour/2025/2025-01-29.parquet size: 610 KB rows: 23,364
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 |
|---|---|---|---|---|---|---|---|
| 2025-01-29 04:00:00 | SPY | ETF | 605.96 | 605.96 | 604.57 | 605.06 | 20170.0 |
| 2025-01-29 05:00:00 | SPY | ETF | 605.13 | 605.39 | 604.8 | 605.19 | 11453.0 |
| 2025-01-29 06:00:00 | SPY | ETF | 605.14 | 605.58 | 605.0 | 605.4 | 20004.0 |
| 2025-01-29 07:00:00 | SPY | ETF | 605.39 | 605.39 | 604.45 | 604.64 | 25203.0 |
| 2025-01-29 08:00:00 | SPY | ETF | 605.2 | 605.81 | 602.89 | 603.54 | 293237.0 |
| 2025-01-29 09:00:00 | SPY | ETF | 603.51 | 603.99 | 602.4452 | 603.27 | 2064813.0 |
| 2025-01-29 10:00:00 | SPY | ETF | 603.31 | 604.13 | 602.48 | 602.78 | 2101499.0 |
| 2025-01-29 11:00:00 | SPY | ETF | 602.82 | 603.176 | 601.93 | 602.29 | 1695819.0 |
| 2025-01-29 12:00:00 | SPY | ETF | 602.2947 | 603.46 | 601.95 | 602.08 | 1333666.0 |
| 2025-01-29 13:00:00 | SPY | ETF | 602.1 | 602.63 | 599.66 | 601.49 | 2601596.0 |
| 2025-01-29 14:00:00 | SPY | ETF | 601.49 | 603.28 | 599.22 | 602.32 | 5957336.0 |
| 2025-01-29 15:00:00 | SPY | ETF | 602.29 | 603.6801 | 600.55 | 601.8 | 5563046.0 |
| 2025-01-29 16:00:00 | SPY | ETF | 601.81 | 604.7041 | 599.24 | 602.62 | 3641931.0 |
| 2025-01-29 17:00:00 | SPY | ETF | 602.35 | 603.36 | 602.0 | 602.09 | 212143.0 |
| 2025-01-29 18:00:00 | SPY | ETF | 602.08 | 602.5 | 601.14 | 601.95 | 135470.0 |
| 2025-01-29 19:00:00 | SPY | ETF | 601.71 | 603.06 | 601.71 | 603.06 | 45616.0 |
| 2025-01-29 04:00:00 | QQQ | ETF | 523.22 | 524.35 | 523.0 | 524.07 | 94177.0 |
| 2025-01-29 05:00:00 | QQQ | ETF | 524.11 | 524.24 | 523.54 | 524.22 | 29602.0 |
| 2025-01-29 06:00:00 | QQQ | ETF | 523.91 | 524.62 | 523.64 | 524.5 | 54904.0 |
| 2025-01-29 07:00:00 | QQQ | ETF | 524.41 | 524.46 | 523.5 | 523.63 | 109013.0 |
| 2025-01-29 08:00:00 | QQQ | ETF | 524.02 | 524.7 | 521.5896 | 522.518 | 332714.0 |
| 2025-01-29 09:00:00 | QQQ | ETF | 522.55 | 523.1 | 519.94 | 520.5403 | 2497261.0 |
| 2025-01-29 10:00:00 | QQQ | ETF | 520.55 | 521.63 | 519.02 | 520.191 | 1849910.0 |
| 2025-01-29 11:00:00 | QQQ | ETF | 520.23 | 520.65 | 519.29 | 519.67 | 1268365.0 |
| 2025-01-29 12:00:00 | QQQ | ETF | 519.71 | 521.18 | 519.58 | 519.75 | 1008347.0 |
| 2025-01-29 13:00:00 | QQQ | ETF | 519.73 | 520.44 | 516.8988 | 519.255 | 2356180.0 |
| 2025-01-29 14:00:00 | QQQ | ETF | 519.22 | 521.92 | 517.35 | 521.01 | 4549298.0 |
| 2025-01-29 15:00:00 | QQQ | ETF | 520.99 | 522.48 | 519.18 | 520.78 | 3739850.0 |
| 2025-01-29 16:00:00 | QQQ | ETF | 520.83 | 522.68 | 517.0 | 521.87 | 1882180.0 |
| 2025-01-29 17:00:00 | QQQ | ETF | 521.81 | 523.18 | 520.83 | 520.83 | 442741.0 |
| 2025-01-29 18:00:00 | QQQ | ETF | 521.15 | 522.05 | 520.16 | 521.05 | 396293.0 |
| 2025-01-29 19:00:00 | QQQ | ETF | 520.9 | 522.1 | 520.67 | 522.05 | 137735.0 |
| 2025-01-29 04:00:00 | IWM | ETF | 227.15 | 227.15 | 226.89 | 227.09 | 10758.0 |
| 2025-01-29 05:00:00 | IWM | ETF | 227.18 | 227.29 | 227.04 | 227.27 | 4121.0 |
| 2025-01-29 06:00:00 | IWM | ETF | 227.27 | 227.45 | 227.27 | 227.32 | 43235.0 |
| 2025-01-29 07:00:00 | IWM | ETF | 227.29 | 227.34 | 227.0 | 227.2 | 20767.0 |
| 2025-01-29 08:00:00 | IWM | ETF | 227.32 | 227.5 | 226.3 | 226.32 | 105872.0 |
| 2025-01-29 09:00:00 | IWM | ETF | 226.44 | 227.3 | 226.38 | 227.2 | 1194848.0 |
| 2025-01-29 10:00:00 | IWM | ETF | 227.235 | 228.22 | 226.79 | 226.8 | 1266660.0 |
| 2025-01-29 11:00:00 | IWM | ETF | 226.81 | 226.93 | 226.35 | 226.5342 | 1058053.0 |
| 2025-01-29 12:00:00 | IWM | ETF | 226.52 | 226.98 | 226.45 | 226.63 | 500655.0 |
| 2025-01-29 13:00:00 | IWM | ETF | 226.63 | 226.94 | 226.04 | 226.7 | 1264916.0 |
| 2025-01-29 14:00:00 | IWM | ETF | 226.7 | 227.7399 | 224.58 | 226.14 | 6080030.0 |
| 2025-01-29 15:00:00 | IWM | ETF | 226.11 | 226.8 | 225.11 | 226.25 | 3674703.0 |
| 2025-01-29 16:00:00 | IWM | ETF | 226.23 | 227.5 | 226.22 | 226.27 | 898786.0 |
| 2025-01-29 17:00:00 | IWM | ETF | 226.3298 | 226.8 | 226.03 | 226.55 | 24156.0 |
| 2025-01-29 18:00:00 | IWM | ETF | 226.55 | 226.99 | 226.52 | 226.988 | 17535.0 |
| 2025-01-29 19:00:00 | IWM | ETF | 226.8 | 227.28 | 226.8 | 227.11 | 25759.0 |
| 2025-01-29 04:00:00 | DIA | ETF | 447.96 | 447.96 | 447.81 | 447.81 | 300.0 |
| 2025-01-29 06:00:00 | DIA | ETF | 448.46 | 448.46 | 448.46 | 448.46 | 300.0 |
> showing 50 of 23,364 rows — these rows as CSV