PREVIEW / etf_1hour / 2025-04-10
file: by_date/etf_1hour/2025/2025-04-10.parquet size: 666 KB rows: 26,570
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-10 04:00:00 | SPY | ETF | 540.14 | 540.14 | 530.68 | 531.67 | 692179.0 |
| 2025-04-10 05:00:00 | SPY | ETF | 531.92 | 534.21 | 530.7 | 532.77 | 262561.0 |
| 2025-04-10 06:00:00 | SPY | ETF | 532.83 | 537.35 | 532.55 | 533.8 | 605188.0 |
| 2025-04-10 07:00:00 | SPY | ETF | 533.75 | 536.04 | 533.42 | 535.37 | 679530.0 |
| 2025-04-10 08:00:00 | SPY | ETF | 535.25 | 543.01 | 531.0 | 533.19 | 2630078.0 |
| 2025-04-10 09:00:00 | SPY | ETF | 533.3 | 535.15 | 528.51 | 529.0025 | 11183708.0 |
| 2025-04-10 10:00:00 | SPY | ETF | 528.99 | 531.96 | 526.05 | 526.29 | 11309136.0 |
| 2025-04-10 11:00:00 | SPY | ETF | 526.29 | 528.7 | 517.91 | 518.6143 | 11910397.0 |
| 2025-04-10 12:00:00 | SPY | ETF | 518.56 | 520.55 | 509.32 | 519.76 | 22837129.0 |
| 2025-04-10 13:00:00 | SPY | ETF | 519.67 | 525.55 | 512.87 | 524.28 | 15623422.0 |
| 2025-04-10 14:00:00 | SPY | ETF | 524.19 | 529.71 | 520.31 | 526.07 | 13045465.0 |
| 2025-04-10 15:00:00 | SPY | ETF | 526.17 | 529.43 | 518.2 | 524.7 | 23510690.0 |
| 2025-04-10 16:00:00 | SPY | ETF | 524.67 | 526.88 | 523.346 | 525.16 | 5246175.0 |
| 2025-04-10 17:00:00 | SPY | ETF | 525.16 | 525.25 | 524.3 | 524.3 | 167729.0 |
| 2025-04-10 18:00:00 | SPY | ETF | 524.43 | 527.5 | 524.43 | 525.75 | 187539.0 |
| 2025-04-10 19:00:00 | SPY | ETF | 525.81 | 526.03 | 521.29 | 522.1017 | 230573.0 |
| 2025-04-10 04:00:00 | QQQ | ETF | 458.61 | 460.0 | 451.71 | 453.4 | 747870.0 |
| 2025-04-10 05:00:00 | QQQ | ETF | 453.32 | 456.33 | 452.84 | 455.05 | 157849.0 |
| 2025-04-10 06:00:00 | QQQ | ETF | 455.24 | 458.65 | 455.13 | 455.65 | 270374.0 |
| 2025-04-10 07:00:00 | QQQ | ETF | 455.67 | 457.63 | 455.58 | 457.02 | 353745.0 |
| 2025-04-10 08:00:00 | QQQ | ETF | 456.24 | 463.0 | 452.24 | 454.5 | 1370177.0 |
| 2025-04-10 09:00:00 | QQQ | ETF | 454.54 | 456.3 | 450.48 | 450.52 | 8545396.0 |
| 2025-04-10 10:00:00 | QQQ | ETF | 450.51 | 453.92 | 448.27 | 448.69 | 8727135.0 |
| 2025-04-10 11:00:00 | QQQ | ETF | 448.7 | 450.93 | 440.8015 | 441.32 | 8895581.0 |
| 2025-04-10 12:00:00 | QQQ | ETF | 441.31 | 442.67 | 432.63 | 442.15 | 13204989.0 |
| 2025-04-10 13:00:00 | QQQ | ETF | 442.09 | 447.0 | 435.47 | 445.75 | 10408367.0 |
| 2025-04-10 14:00:00 | QQQ | ETF | 445.68 | 450.82 | 441.91 | 447.71 | 8784444.0 |
| 2025-04-10 15:00:00 | QQQ | ETF | 447.68 | 450.48 | 440.38 | 446.19 | 10478669.0 |
| 2025-04-10 16:00:00 | QQQ | ETF | 446.22 | 448.3999 | 445.0 | 446.73 | 3084804.0 |
| 2025-04-10 17:00:00 | QQQ | ETF | 446.63 | 446.83 | 445.65 | 445.65 | 87644.0 |
| 2025-04-10 18:00:00 | QQQ | ETF | 445.81 | 448.989 | 445.81 | 447.26 | 160733.0 |
| 2025-04-10 19:00:00 | QQQ | ETF | 447.18 | 447.45 | 442.31 | 443.19 | 219441.0 |
| 2025-04-10 04:00:00 | IWM | ETF | 186.69 | 187.26 | 184.42 | 184.49 | 130561.0 |
| 2025-04-10 05:00:00 | IWM | ETF | 184.57 | 185.01 | 183.78 | 184.36 | 166930.0 |
| 2025-04-10 06:00:00 | IWM | ETF | 184.4 | 185.87 | 184.38 | 184.85 | 86493.0 |
| 2025-04-10 07:00:00 | IWM | ETF | 184.87 | 185.75 | 184.75 | 185.18 | 358209.0 |
| 2025-04-10 08:00:00 | IWM | ETF | 185.14 | 189.24 | 182.82 | 184.24 | 1060184.0 |
| 2025-04-10 09:00:00 | IWM | ETF | 184.24 | 185.48 | 182.89 | 182.93 | 6887556.0 |
| 2025-04-10 10:00:00 | IWM | ETF | 182.91 | 184.3 | 181.95 | 182.11 | 6525042.0 |
| 2025-04-10 11:00:00 | IWM | ETF | 182.11 | 182.87 | 179.375 | 179.76 | 5037348.0 |
| 2025-04-10 12:00:00 | IWM | ETF | 179.73 | 180.54 | 176.98 | 180.17 | 6801053.0 |
| 2025-04-10 13:00:00 | IWM | ETF | 180.12 | 182.76 | 177.77 | 182.19 | 8248221.0 |
| 2025-04-10 14:00:00 | IWM | ETF | 182.195 | 183.65 | 180.55 | 181.51 | 6936530.0 |
| 2025-04-10 15:00:00 | IWM | ETF | 181.55 | 182.76 | 179.16 | 181.81 | 8372120.0 |
| 2025-04-10 16:00:00 | IWM | ETF | 181.71 | 182.6262 | 181.29 | 181.76 | 2060906.0 |
| 2025-04-10 17:00:00 | IWM | ETF | 181.84 | 182.13 | 181.3201 | 181.54 | 58544.0 |
| 2025-04-10 18:00:00 | IWM | ETF | 181.5 | 182.86 | 181.48 | 182.25 | 119701.0 |
| 2025-04-10 19:00:00 | IWM | ETF | 182.19 | 182.25 | 180.6 | 180.81 | 59976.0 |
| 2025-04-10 04:00:00 | DIA | ETF | 401.0 | 401.69 | 399.03 | 399.37 | 8444.0 |
| 2025-04-10 05:00:00 | DIA | ETF | 399.37 | 400.79 | 399.37 | 400.63 | 1600.0 |
> showing 50 of 26,570 rows — these rows as CSV