PREVIEW / etf_1hour / 2025-02-11
file: by_date/etf_1hour/2025/2025-02-11.parquet size: 621 KB rows: 23,369
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-02-11 04:00:00 | SPY | ETF | 603.2 | 603.7 | 602.84 | 603.0 | 19772.0 |
| 2025-02-11 05:00:00 | SPY | ETF | 602.88 | 603.26 | 602.57 | 602.57 | 28370.0 |
| 2025-02-11 06:00:00 | SPY | ETF | 602.74 | 603.39 | 602.74 | 603.39 | 6960.0 |
| 2025-02-11 07:00:00 | SPY | ETF | 603.36 | 603.51 | 602.85 | 603.31 | 75874.0 |
| 2025-02-11 08:00:00 | SPY | ETF | 603.04 | 603.57 | 601.92 | 601.99 | 225223.0 |
| 2025-02-11 09:00:00 | SPY | ETF | 601.91 | 603.59 | 601.91 | 603.33 | 1725849.0 |
| 2025-02-11 10:00:00 | SPY | ETF | 603.31 | 605.22 | 602.7 | 604.7062 | 2293560.0 |
| 2025-02-11 11:00:00 | SPY | ETF | 604.7 | 605.05 | 604.03 | 604.21 | 1619447.0 |
| 2025-02-11 12:00:00 | SPY | ETF | 604.18 | 604.43 | 603.1 | 603.7599 | 2226815.0 |
| 2025-02-11 13:00:00 | SPY | ETF | 603.75 | 605.3 | 603.5 | 604.59 | 1559103.0 |
| 2025-02-11 14:00:00 | SPY | ETF | 604.56 | 605.86 | 604.39 | 605.41 | 2051791.0 |
| 2025-02-11 15:00:00 | SPY | ETF | 605.41 | 605.65 | 604.61 | 605.21 | 5420880.0 |
| 2025-02-11 16:00:00 | SPY | ETF | 605.21 | 605.37 | 604.87 | 605.04 | 2629748.0 |
| 2025-02-11 17:00:00 | SPY | ETF | 605.05 | 605.11 | 604.8 | 604.99 | 47969.0 |
| 2025-02-11 18:00:00 | SPY | ETF | 604.99 | 605.4 | 604.68 | 605.33 | 39259.0 |
| 2025-02-11 19:00:00 | SPY | ETF | 605.26 | 605.63 | 605.15 | 605.31 | 28821.0 |
| 2025-02-11 04:00:00 | QQQ | ETF | 528.0 | 528.0 | 526.91 | 527.08 | 40515.0 |
| 2025-02-11 05:00:00 | QQQ | ETF | 527.1 | 527.3 | 526.5 | 526.6 | 46041.0 |
| 2025-02-11 06:00:00 | QQQ | ETF | 526.64 | 527.33 | 526.64 | 527.29 | 22188.0 |
| 2025-02-11 07:00:00 | QQQ | ETF | 527.44 | 527.44 | 526.55 | 526.99 | 96196.0 |
| 2025-02-11 08:00:00 | QQQ | ETF | 527.25 | 528.16 | 525.17 | 525.29 | 363159.0 |
| 2025-02-11 09:00:00 | QQQ | ETF | 525.15 | 528.33 | 525.1 | 527.69 | 1690123.0 |
| 2025-02-11 10:00:00 | QQQ | ETF | 527.67 | 529.92 | 527.28 | 529.17 | 2191508.0 |
| 2025-02-11 11:00:00 | QQQ | ETF | 529.19 | 529.39 | 527.83 | 527.98 | 1574609.0 |
| 2025-02-11 12:00:00 | QQQ | ETF | 527.95 | 528.07 | 526.171 | 527.33 | 1911671.0 |
| 2025-02-11 13:00:00 | QQQ | ETF | 527.3 | 528.99 | 526.91 | 528.27 | 1333778.0 |
| 2025-02-11 14:00:00 | QQQ | ETF | 528.24 | 529.17 | 528.0 | 528.8 | 1125591.0 |
| 2025-02-11 15:00:00 | QQQ | ETF | 528.88 | 529.16 | 527.37 | 527.95 | 2800829.0 |
| 2025-02-11 16:00:00 | QQQ | ETF | 527.97 | 528.12 | 527.6 | 528.0 | 1408565.0 |
| 2025-02-11 17:00:00 | QQQ | ETF | 528.05 | 528.15 | 527.9 | 527.94 | 25966.0 |
| 2025-02-11 18:00:00 | QQQ | ETF | 527.97 | 528.61 | 527.74 | 528.4175 | 39915.0 |
| 2025-02-11 19:00:00 | QQQ | ETF | 528.53 | 528.89 | 528.37 | 528.47 | 67847.0 |
| 2025-02-11 04:00:00 | IWM | ETF | 225.98 | 226.26 | 225.85 | 225.92 | 14865.0 |
| 2025-02-11 05:00:00 | IWM | ETF | 225.92 | 226.07 | 225.83 | 225.86 | 3376.0 |
| 2025-02-11 06:00:00 | IWM | ETF | 225.92 | 226.01 | 225.77 | 225.94 | 23548.0 |
| 2025-02-11 07:00:00 | IWM | ETF | 225.89 | 225.94 | 225.48 | 225.93 | 61542.0 |
| 2025-02-11 08:00:00 | IWM | ETF | 225.95 | 226.44 | 225.03 | 225.05 | 176843.0 |
| 2025-02-11 09:00:00 | IWM | ETF | 225.12 | 226.05 | 224.71 | 225.78 | 2933131.0 |
| 2025-02-11 10:00:00 | IWM | ETF | 225.78 | 226.31 | 225.1684 | 226.12 | 1943827.0 |
| 2025-02-11 11:00:00 | IWM | ETF | 226.14 | 226.42 | 225.5231 | 225.58 | 1127591.0 |
| 2025-02-11 12:00:00 | IWM | ETF | 225.57 | 225.57 | 225.0 | 225.0956 | 1063945.0 |
| 2025-02-11 13:00:00 | IWM | ETF | 225.08 | 225.61 | 225.0257 | 225.235 | 745052.0 |
| 2025-02-11 14:00:00 | IWM | ETF | 225.23 | 225.6968 | 225.0101 | 225.5201 | 1085366.0 |
| 2025-02-11 15:00:00 | IWM | ETF | 225.53 | 225.8 | 225.36 | 225.705 | 3235518.0 |
| 2025-02-11 16:00:00 | IWM | ETF | 225.7 | 225.93 | 225.6998 | 225.87 | 690335.0 |
| 2025-02-11 17:00:00 | IWM | ETF | 225.86 | 225.98 | 225.73 | 225.73 | 11019.0 |
| 2025-02-11 18:00:00 | IWM | ETF | 225.82 | 225.98 | 225.67 | 225.81 | 27013.0 |
| 2025-02-11 19:00:00 | IWM | ETF | 225.84 | 225.98 | 225.76 | 225.8499 | 33836.0 |
| 2025-02-11 04:00:00 | DIA | ETF | 444.11 | 444.17 | 443.8 | 443.8 | 1591.0 |
| 2025-02-11 05:00:00 | DIA | ETF | 444.12 | 444.12 | 444.12 | 444.12 | 100.0 |
> showing 50 of 23,369 rows — these rows as CSV