PREVIEW / etf_1hour / 2025-01-24
file: by_date/etf_1hour/2025/2025-01-24.parquet size: 631 KB rows: 23,601
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-24 04:00:00 | SPY | ETF | 609.16 | 609.59 | 609.09 | 609.3 | 8127.0 |
| 2025-01-24 05:00:00 | SPY | ETF | 609.22 | 609.22 | 608.58 | 608.96 | 12610.0 |
| 2025-01-24 06:00:00 | SPY | ETF | 608.98 | 609.09 | 608.82 | 609.01 | 5747.0 |
| 2025-01-24 07:00:00 | SPY | ETF | 609.03 | 609.56 | 609.03 | 609.21 | 59843.0 |
| 2025-01-24 08:00:00 | SPY | ETF | 609.04 | 609.5 | 608.69 | 609.0 | 149959.0 |
| 2025-01-24 09:00:00 | SPY | ETF | 608.95 | 610.78 | 608.95 | 610.33 | 2651753.0 |
| 2025-01-24 10:00:00 | SPY | ETF | 610.35 | 610.54 | 609.06 | 609.1801 | 2202449.0 |
| 2025-01-24 11:00:00 | SPY | ETF | 609.18 | 610.325 | 609.08 | 609.53 | 1698227.0 |
| 2025-01-24 12:00:00 | SPY | ETF | 609.53 | 610.05 | 608.52 | 608.7 | 2127774.0 |
| 2025-01-24 13:00:00 | SPY | ETF | 608.6797 | 608.91 | 607.2 | 607.421 | 1982052.0 |
| 2025-01-24 14:00:00 | SPY | ETF | 607.42 | 607.92 | 606.93 | 607.38 | 2743156.0 |
| 2025-01-24 15:00:00 | SPY | ETF | 607.375 | 608.15 | 606.8 | 607.95 | 5899163.0 |
| 2025-01-24 16:00:00 | SPY | ETF | 607.92 | 608.58 | 607.18 | 607.83 | 3306143.0 |
| 2025-01-24 17:00:00 | SPY | ETF | 607.82 | 607.86 | 607.55 | 607.57 | 18924.0 |
| 2025-01-24 18:00:00 | SPY | ETF | 607.56 | 607.7958 | 607.5511 | 607.5511 | 2350.0 |
| 2025-01-24 19:00:00 | SPY | ETF | 607.55 | 607.64 | 607.4 | 607.49 | 21621.0 |
| 2025-01-24 04:00:00 | QQQ | ETF | 531.53 | 532.45 | 531.51 | 532.04 | 21458.0 |
| 2025-01-24 05:00:00 | QQQ | ETF | 532.06 | 532.11 | 531.64 | 532.06 | 34171.0 |
| 2025-01-24 06:00:00 | QQQ | ETF | 532.12 | 532.19 | 531.75 | 532.19 | 19765.0 |
| 2025-01-24 07:00:00 | QQQ | ETF | 532.13 | 532.95 | 532.13 | 532.64 | 63369.0 |
| 2025-01-24 08:00:00 | QQQ | ETF | 532.46 | 533.039 | 531.37 | 532.2 | 163470.0 |
| 2025-01-24 09:00:00 | QQQ | ETF | 532.2 | 533.79 | 531.9 | 533.34 | 2282411.0 |
| 2025-01-24 10:00:00 | QQQ | ETF | 533.35 | 533.6 | 531.4 | 531.59 | 1960486.0 |
| 2025-01-24 11:00:00 | QQQ | ETF | 531.58 | 532.75 | 531.2072 | 531.49 | 1454289.0 |
| 2025-01-24 12:00:00 | QQQ | ETF | 531.45 | 532.095 | 530.25 | 530.485 | 1557775.0 |
| 2025-01-24 13:00:00 | QQQ | ETF | 530.46 | 530.77 | 528.55 | 528.69 | 1701339.0 |
| 2025-01-24 14:00:00 | QQQ | ETF | 528.72 | 529.38 | 528.15 | 528.71 | 1965172.0 |
| 2025-01-24 15:00:00 | QQQ | ETF | 528.71 | 529.9 | 528.45 | 529.64 | 2635107.0 |
| 2025-01-24 16:00:00 | QQQ | ETF | 529.65 | 529.88 | 529.02 | 529.63 | 865968.0 |
| 2025-01-24 17:00:00 | QQQ | ETF | 529.6 | 529.6 | 529.3999 | 529.3999 | 8073.0 |
| 2025-01-24 18:00:00 | QQQ | ETF | 529.4 | 529.5783 | 529.239 | 529.3 | 19993.0 |
| 2025-01-24 19:00:00 | QQQ | ETF | 529.2776 | 529.33 | 528.92 | 528.9201 | 20027.0 |
| 2025-01-24 04:00:00 | IWM | ETF | 229.49 | 229.66 | 229.13 | 229.47 | 21390.0 |
| 2025-01-24 05:00:00 | IWM | ETF | 229.46 | 229.46 | 229.02 | 229.19 | 4550.0 |
| 2025-01-24 06:00:00 | IWM | ETF | 229.07 | 229.22 | 229.04 | 229.2 | 9298.0 |
| 2025-01-24 07:00:00 | IWM | ETF | 229.17 | 229.51 | 228.96 | 229.09 | 44197.0 |
| 2025-01-24 08:00:00 | IWM | ETF | 229.12 | 229.45 | 228.52 | 228.83 | 56387.0 |
| 2025-01-24 09:00:00 | IWM | ETF | 228.9 | 229.22 | 228.04 | 228.53 | 1877864.0 |
| 2025-01-24 10:00:00 | IWM | ETF | 228.53 | 229.27 | 228.11 | 229.18 | 1875425.0 |
| 2025-01-24 11:00:00 | IWM | ETF | 229.17 | 229.94 | 229.09 | 229.46 | 1561578.0 |
| 2025-01-24 12:00:00 | IWM | ETF | 229.45 | 230.23 | 228.99 | 229.18 | 1718351.0 |
| 2025-01-24 13:00:00 | IWM | ETF | 229.16 | 229.6 | 228.805 | 228.95 | 1197506.0 |
| 2025-01-24 14:00:00 | IWM | ETF | 228.94 | 229.16 | 228.515 | 228.75 | 1216745.0 |
| 2025-01-24 15:00:00 | IWM | ETF | 228.75 | 228.86 | 228.15 | 228.67 | 2497276.0 |
| 2025-01-24 16:00:00 | IWM | ETF | 228.69 | 228.82 | 228.52 | 228.82 | 717588.0 |
| 2025-01-24 17:00:00 | IWM | ETF | 228.81 | 228.86 | 228.6184 | 228.77 | 22946.0 |
| 2025-01-24 18:00:00 | IWM | ETF | 228.71 | 228.79 | 228.52 | 228.69 | 5345.0 |
| 2025-01-24 19:00:00 | IWM | ETF | 228.73 | 228.77 | 228.5 | 228.5 | 2763.0 |
| 2025-01-24 04:00:00 | DIA | ETF | 445.57 | 445.59 | 445.12 | 445.15 | 2716.0 |
| 2025-01-24 05:00:00 | DIA | ETF | 445.21 | 445.22 | 444.76 | 444.76 | 2300.0 |
> showing 50 of 23,601 rows — these rows as CSV