PREVIEW / etf_1hour / 2025-04-24
file: by_date/etf_1hour/2025/2025-04-24.parquet size: 638 KB rows: 24,447
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-04-24 04:00:00 | SPY | ETF | 533.01 | 533.6 | 531.22 | 532.01 | 38816.0 |
| 2025-04-24 05:00:00 | SPY | ETF | 532.14 | 533.37 | 532.04 | 533.12 | 110120.0 |
| 2025-04-24 06:00:00 | SPY | ETF | 533.43 | 536.41 | 533.05 | 535.96 | 141010.0 |
| 2025-04-24 07:00:00 | SPY | ETF | 535.94 | 536.03 | 533.57 | 534.36 | 349641.0 |
| 2025-04-24 08:00:00 | SPY | ETF | 535.86 | 536.4 | 532.51 | 536.11 | 546556.0 |
| 2025-04-24 09:00:00 | SPY | ETF | 536.12 | 539.6462 | 535.4504 | 539.48 | 4387696.0 |
| 2025-04-24 10:00:00 | SPY | ETF | 539.48 | 543.31 | 539.01 | 542.46 | 7782234.0 |
| 2025-04-24 11:00:00 | SPY | ETF | 542.45 | 543.9 | 541.89 | 542.76 | 4705402.0 |
| 2025-04-24 12:00:00 | SPY | ETF | 542.81 | 545.8479 | 542.2503 | 545.44 | 4622194.0 |
| 2025-04-24 13:00:00 | SPY | ETF | 545.43 | 545.59 | 544.03 | 545.27 | 3150744.0 |
| 2025-04-24 14:00:00 | SPY | ETF | 545.29 | 546.9 | 545.03 | 546.08 | 4830084.0 |
| 2025-04-24 15:00:00 | SPY | ETF | 546.05 | 547.43 | 544.28 | 546.54 | 11162294.0 |
| 2025-04-24 16:00:00 | SPY | ETF | 546.55 | 549.33 | 546.52 | 547.38 | 4312373.0 |
| 2025-04-24 17:00:00 | SPY | ETF | 547.3604 | 548.74 | 547.2 | 548.5 | 335413.0 |
| 2025-04-24 18:00:00 | SPY | ETF | 548.5 | 548.97 | 547.27 | 548.43 | 340207.0 |
| 2025-04-24 19:00:00 | SPY | ETF | 548.46 | 548.9 | 548.15 | 548.37 | 82385.0 |
| 2025-04-24 04:00:00 | QQQ | ETF | 451.74 | 452.28 | 449.72 | 450.48 | 108540.0 |
| 2025-04-24 05:00:00 | QQQ | ETF | 450.61 | 452.06 | 450.55 | 452.06 | 69190.0 |
| 2025-04-24 06:00:00 | QQQ | ETF | 452.14 | 455.47 | 452.12 | 455.08 | 152743.0 |
| 2025-04-24 07:00:00 | QQQ | ETF | 455.0 | 455.18 | 453.0 | 453.84 | 253810.0 |
| 2025-04-24 08:00:00 | QQQ | ETF | 454.64 | 456.23 | 450.7596 | 455.96 | 471012.0 |
| 2025-04-24 09:00:00 | QQQ | ETF | 456.0 | 460.94 | 455.31 | 460.75 | 3498800.0 |
| 2025-04-24 10:00:00 | QQQ | ETF | 460.77 | 463.82 | 460.56 | 462.9 | 6087445.0 |
| 2025-04-24 11:00:00 | QQQ | ETF | 462.88 | 464.62 | 462.4 | 463.33 | 3287856.0 |
| 2025-04-24 12:00:00 | QQQ | ETF | 463.385 | 466.18 | 462.86 | 465.78 | 3593252.0 |
| 2025-04-24 13:00:00 | QQQ | ETF | 465.78 | 466.06 | 464.4 | 465.93 | 2507739.0 |
| 2025-04-24 14:00:00 | QQQ | ETF | 465.88 | 467.34 | 465.765 | 466.55 | 2556258.0 |
| 2025-04-24 15:00:00 | QQQ | ETF | 466.52 | 467.66 | 464.78 | 467.2 | 5802169.0 |
| 2025-04-24 16:00:00 | QQQ | ETF | 467.2 | 469.36 | 466.99 | 467.99 | 2384653.0 |
| 2025-04-24 17:00:00 | QQQ | ETF | 468.05 | 470.0 | 467.35 | 469.88 | 365836.0 |
| 2025-04-24 18:00:00 | QQQ | ETF | 469.87 | 469.87 | 468.2 | 469.41 | 295278.0 |
| 2025-04-24 19:00:00 | QQQ | ETF | 469.3292 | 470.1 | 469.14 | 469.58 | 97227.0 |
| 2025-04-24 04:00:00 | IWM | ETF | 189.63 | 189.69 | 188.66 | 188.95 | 32189.0 |
| 2025-04-24 05:00:00 | IWM | ETF | 188.98 | 189.28 | 188.98 | 189.18 | 24501.0 |
| 2025-04-24 06:00:00 | IWM | ETF | 189.25 | 190.24 | 189.25 | 190.09 | 73718.0 |
| 2025-04-24 07:00:00 | IWM | ETF | 190.15 | 190.2 | 189.36 | 189.6 | 97797.0 |
| 2025-04-24 08:00:00 | IWM | ETF | 189.79 | 190.44 | 189.25 | 190.35 | 136516.0 |
| 2025-04-24 09:00:00 | IWM | ETF | 190.3215 | 191.495 | 189.89 | 191.46 | 2349482.0 |
| 2025-04-24 10:00:00 | IWM | ETF | 191.44 | 192.55 | 191.14 | 191.92 | 3455435.0 |
| 2025-04-24 11:00:00 | IWM | ETF | 191.93 | 192.805 | 191.795 | 192.485 | 1846186.0 |
| 2025-04-24 12:00:00 | IWM | ETF | 192.52 | 193.86 | 192.5 | 193.675 | 2427563.0 |
| 2025-04-24 13:00:00 | IWM | ETF | 193.7 | 193.79 | 193.33 | 193.6623 | 1316822.0 |
| 2025-04-24 14:00:00 | IWM | ETF | 193.67 | 194.13 | 193.51 | 193.89 | 1535279.0 |
| 2025-04-24 15:00:00 | IWM | ETF | 193.88 | 194.37 | 193.27 | 194.05 | 4104103.0 |
| 2025-04-24 16:00:00 | IWM | ETF | 194.06 | 194.91 | 193.84 | 194.0 | 1178813.0 |
| 2025-04-24 17:00:00 | IWM | ETF | 194.19 | 194.48 | 193.99 | 194.48 | 27792.0 |
| 2025-04-24 18:00:00 | IWM | ETF | 194.28 | 194.34 | 193.75 | 194.15 | 37883.0 |
| 2025-04-24 19:00:00 | IWM | ETF | 194.09 | 194.21 | 193.95 | 193.9699 | 23309.0 |
| 2025-04-24 04:00:00 | DIA | ETF | 393.82 | 393.88 | 392.59 | 393.23 | 5400.0 |
| 2025-04-24 05:00:00 | DIA | ETF | 393.8 | 393.8 | 393.8 | 393.8 | 100.0 |
> showing 50 of 24,447 rows — these rows as CSV