PREVIEW / etf_1hour / 2025-04-11
file: by_date/etf_1hour/2025/2025-04-11.parquet size: 660 KB rows: 25,504
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-11 04:00:00 | SPY | ETF | 525.2 | 527.46 | 520.78 | 522.42 | 347438.0 |
| 2025-04-11 05:00:00 | SPY | ETF | 522.29 | 529.1 | 521.5 | 529.07 | 119258.0 |
| 2025-04-11 06:00:00 | SPY | ETF | 528.9 | 530.64 | 527.44 | 528.78 | 151169.0 |
| 2025-04-11 07:00:00 | SPY | ETF | 528.79 | 529.65 | 524.32 | 526.95 | 325976.0 |
| 2025-04-11 08:00:00 | SPY | ETF | 529.15 | 532.48 | 524.27 | 525.55 | 919830.0 |
| 2025-04-11 09:00:00 | SPY | ETF | 525.7 | 528.84 | 521.1 | 526.4001 | 9347546.0 |
| 2025-04-11 10:00:00 | SPY | ETF | 526.48 | 528.43 | 520.07 | 523.17 | 11088019.0 |
| 2025-04-11 11:00:00 | SPY | ETF | 523.14 | 527.42 | 520.88 | 526.94 | 6599606.0 |
| 2025-04-11 12:00:00 | SPY | ETF | 526.93 | 532.85 | 526.08 | 531.72 | 6725779.0 |
| 2025-04-11 13:00:00 | SPY | ETF | 531.77 | 536.43 | 528.84 | 534.7 | 8221886.0 |
| 2025-04-11 14:00:00 | SPY | ETF | 534.72 | 534.99 | 531.57 | 532.16 | 5871702.0 |
| 2025-04-11 15:00:00 | SPY | ETF | 532.23 | 535.68 | 532.11 | 533.98 | 13790970.0 |
| 2025-04-11 16:00:00 | SPY | ETF | 533.98 | 534.94 | 533.53 | 534.37 | 5887710.0 |
| 2025-04-11 17:00:00 | SPY | ETF | 534.3499 | 534.5001 | 533.83 | 534.08 | 92799.0 |
| 2025-04-11 18:00:00 | SPY | ETF | 533.9005 | 534.1 | 533.66 | 533.66 | 71826.0 |
| 2025-04-11 19:00:00 | SPY | ETF | 533.7 | 534.29 | 533.66 | 534.29 | 36024.0 |
| 2025-04-11 04:00:00 | QQQ | ETF | 447.22 | 449.53 | 442.4 | 444.4 | 267304.0 |
| 2025-04-11 05:00:00 | QQQ | ETF | 444.25 | 450.35 | 443.5 | 450.23 | 131800.0 |
| 2025-04-11 06:00:00 | QQQ | ETF | 450.14 | 451.61 | 448.68 | 449.96 | 125339.0 |
| 2025-04-11 07:00:00 | QQQ | ETF | 449.96 | 450.5 | 445.9 | 448.32 | 230031.0 |
| 2025-04-11 08:00:00 | QQQ | ETF | 450.12 | 453.8 | 443.5004 | 446.63 | 886154.0 |
| 2025-04-11 09:00:00 | QQQ | ETF | 446.58 | 450.379 | 443.21 | 448.3 | 5234313.0 |
| 2025-04-11 10:00:00 | QQQ | ETF | 448.31 | 449.76 | 441.33 | 444.8 | 6246763.0 |
| 2025-04-11 11:00:00 | QQQ | ETF | 444.69 | 448.6191 | 442.57 | 448.4 | 3566166.0 |
| 2025-04-11 12:00:00 | QQQ | ETF | 448.41 | 453.71 | 447.53 | 452.42 | 4314501.0 |
| 2025-04-11 13:00:00 | QQQ | ETF | 452.44 | 455.79 | 449.04 | 454.52 | 6256589.0 |
| 2025-04-11 14:00:00 | QQQ | ETF | 454.5999 | 454.89 | 451.85 | 452.45 | 3473202.0 |
| 2025-04-11 15:00:00 | QQQ | ETF | 452.48 | 455.5696 | 452.39 | 454.24 | 6488146.0 |
| 2025-04-11 16:00:00 | QQQ | ETF | 454.24 | 454.96 | 453.65 | 454.49 | 1488875.0 |
| 2025-04-11 17:00:00 | QQQ | ETF | 454.402 | 454.4799 | 454.0146 | 454.019 | 48848.0 |
| 2025-04-11 18:00:00 | QQQ | ETF | 454.02 | 454.02 | 453.51 | 453.51 | 14745.0 |
| 2025-04-11 19:00:00 | QQQ | ETF | 453.6 | 454.1399 | 453.55 | 454.12 | 21771.0 |
| 2025-04-11 04:00:00 | IWM | ETF | 182.09 | 182.3 | 180.5 | 181.18 | 103357.0 |
| 2025-04-11 05:00:00 | IWM | ETF | 181.15 | 183.6 | 180.71 | 183.55 | 37076.0 |
| 2025-04-11 06:00:00 | IWM | ETF | 183.51 | 183.73 | 182.57 | 183.0 | 90817.0 |
| 2025-04-11 07:00:00 | IWM | ETF | 183.06 | 183.45 | 180.72 | 181.58 | 273430.0 |
| 2025-04-11 08:00:00 | IWM | ETF | 183.25 | 184.5 | 180.96 | 181.67 | 322852.0 |
| 2025-04-11 09:00:00 | IWM | ETF | 181.67 | 182.61 | 179.88 | 181.42 | 5938796.0 |
| 2025-04-11 10:00:00 | IWM | ETF | 181.44 | 182.18 | 178.58 | 179.3 | 5915152.0 |
| 2025-04-11 11:00:00 | IWM | ETF | 179.3 | 181.019 | 178.59 | 180.28 | 2853139.0 |
| 2025-04-11 12:00:00 | IWM | ETF | 180.29 | 182.8 | 179.84 | 182.38 | 3174727.0 |
| 2025-04-11 13:00:00 | IWM | ETF | 182.4 | 184.85 | 181.45 | 184.155 | 4708369.0 |
| 2025-04-11 14:00:00 | IWM | ETF | 184.16 | 184.26 | 182.8 | 183.19 | 2829672.0 |
| 2025-04-11 15:00:00 | IWM | ETF | 183.21 | 184.8 | 183.18 | 184.38 | 5377645.0 |
| 2025-04-11 16:00:00 | IWM | ETF | 184.36 | 184.63 | 184.15 | 184.29 | 1170269.0 |
| 2025-04-11 17:00:00 | IWM | ETF | 184.45 | 184.58 | 184.34 | 184.49 | 28384.0 |
| 2025-04-11 18:00:00 | IWM | ETF | 184.36 | 184.43 | 184.14 | 184.15 | 14451.0 |
| 2025-04-11 19:00:00 | IWM | ETF | 184.19 | 184.39 | 184.19 | 184.3 | 14649.0 |
| 2025-04-11 04:00:00 | DIA | ETF | 396.31 | 396.66 | 393.11 | 393.11 | 16177.0 |
| 2025-04-11 05:00:00 | DIA | ETF | 393.72 | 397.55 | 393.71 | 397.54 | 2640.0 |
> showing 50 of 25,504 rows — these rows as CSV