PREVIEW / etf_1hour / 2025-02-10
file: by_date/etf_1hour/2025/2025-02-10.parquet size: 626 KB rows: 23,810
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-10 04:00:00 | SPY | ETF | 602.35 | 603.15 | 602.35 | 603.04 | 11503.0 |
| 2025-02-10 05:00:00 | SPY | ETF | 603.18 | 603.58 | 603.1 | 603.54 | 4104.0 |
| 2025-02-10 06:00:00 | SPY | ETF | 603.46 | 603.74 | 602.97 | 603.64 | 18549.0 |
| 2025-02-10 07:00:00 | SPY | ETF | 603.65 | 603.77 | 603.4 | 603.76 | 105082.0 |
| 2025-02-10 08:00:00 | SPY | ETF | 603.67 | 604.49 | 602.25 | 604.42 | 202573.0 |
| 2025-02-10 09:00:00 | SPY | ETF | 604.45 | 604.6 | 602.74 | 603.49 | 2554404.0 |
| 2025-02-10 10:00:00 | SPY | ETF | 603.51 | 605.33 | 603.33 | 604.8688 | 2874299.0 |
| 2025-02-10 11:00:00 | SPY | ETF | 604.85 | 605.13 | 603.84 | 604.425 | 1783893.0 |
| 2025-02-10 12:00:00 | SPY | ETF | 604.41 | 604.64 | 603.2108 | 604.59 | 1221633.0 |
| 2025-02-10 13:00:00 | SPY | ETF | 604.58 | 605.24 | 604.52 | 605.052 | 1212061.0 |
| 2025-02-10 14:00:00 | SPY | ETF | 605.05 | 605.4999 | 604.63 | 604.93 | 1620768.0 |
| 2025-02-10 15:00:00 | SPY | ETF | 604.95 | 605.19 | 604.2446 | 604.79 | 4807076.0 |
| 2025-02-10 16:00:00 | SPY | ETF | 604.78 | 604.85 | 604.2 | 604.7 | 2100969.0 |
| 2025-02-10 17:00:00 | SPY | ETF | 604.69 | 604.7696 | 604.4 | 604.61 | 33517.0 |
| 2025-02-10 18:00:00 | SPY | ETF | 604.45 | 604.45 | 603.22 | 603.68 | 110775.0 |
| 2025-02-10 19:00:00 | SPY | ETF | 603.68 | 604.07 | 603.43 | 603.98 | 29563.0 |
| 2025-02-10 04:00:00 | QQQ | ETF | 525.64 | 526.05 | 525.13 | 525.97 | 65816.0 |
| 2025-02-10 05:00:00 | QQQ | ETF | 525.92 | 526.53 | 525.92 | 526.35 | 21500.0 |
| 2025-02-10 06:00:00 | QQQ | ETF | 526.35 | 526.94 | 525.74 | 526.76 | 31177.0 |
| 2025-02-10 07:00:00 | QQQ | ETF | 526.72 | 527.0 | 526.23 | 526.61 | 132123.0 |
| 2025-02-10 08:00:00 | QQQ | ETF | 526.6018 | 527.74 | 522.528 | 527.6 | 238485.0 |
| 2025-02-10 09:00:00 | QQQ | ETF | 527.74 | 528.3299 | 526.75 | 527.92 | 2521440.0 |
| 2025-02-10 10:00:00 | QQQ | ETF | 527.93 | 530.3571 | 527.685 | 529.6538 | 2667972.0 |
| 2025-02-10 11:00:00 | QQQ | ETF | 529.68 | 530.17 | 528.982 | 529.8501 | 1490051.0 |
| 2025-02-10 12:00:00 | QQQ | ETF | 529.83 | 529.83 | 528.52 | 529.7 | 1269940.0 |
| 2025-02-10 13:00:00 | QQQ | ETF | 529.65 | 530.14 | 529.505 | 529.99 | 793871.0 |
| 2025-02-10 14:00:00 | QQQ | ETF | 529.96 | 530.06 | 529.17 | 529.6 | 965348.0 |
| 2025-02-10 15:00:00 | QQQ | ETF | 529.61 | 529.91 | 528.94 | 529.215 | 2714645.0 |
| 2025-02-10 16:00:00 | QQQ | ETF | 529.21 | 529.27 | 528.69 | 529.02 | 896057.0 |
| 2025-02-10 17:00:00 | QQQ | ETF | 528.96 | 529.04 | 528.76 | 528.8 | 27224.0 |
| 2025-02-10 18:00:00 | QQQ | ETF | 528.8 | 528.8 | 527.63 | 528.07 | 66757.0 |
| 2025-02-10 19:00:00 | QQQ | ETF | 528.07 | 528.5 | 527.78 | 528.4 | 35924.0 |
| 2025-02-10 04:00:00 | IWM | ETF | 226.67 | 226.94 | 226.66 | 226.7 | 17380.0 |
| 2025-02-10 05:00:00 | IWM | ETF | 226.64 | 226.92 | 226.64 | 226.92 | 6147.0 |
| 2025-02-10 06:00:00 | IWM | ETF | 226.84 | 227.04 | 226.82 | 226.91 | 16727.0 |
| 2025-02-10 07:00:00 | IWM | ETF | 226.91 | 227.03 | 226.78 | 226.97 | 54795.0 |
| 2025-02-10 08:00:00 | IWM | ETF | 226.8602 | 227.54 | 226.55 | 227.46 | 82442.0 |
| 2025-02-10 09:00:00 | IWM | ETF | 227.49 | 227.53 | 225.905 | 226.01 | 2594952.0 |
| 2025-02-10 10:00:00 | IWM | ETF | 226.02 | 226.73 | 225.86 | 226.46 | 1738655.0 |
| 2025-02-10 11:00:00 | IWM | ETF | 226.46 | 226.9549 | 226.0 | 226.945 | 1192259.0 |
| 2025-02-10 12:00:00 | IWM | ETF | 226.94 | 227.21 | 226.49 | 227.18 | 1042029.0 |
| 2025-02-10 13:00:00 | IWM | ETF | 227.175 | 227.52 | 226.85 | 227.41 | 710425.0 |
| 2025-02-10 14:00:00 | IWM | ETF | 227.41 | 227.43 | 227.05 | 227.101 | 577361.0 |
| 2025-02-10 15:00:00 | IWM | ETF | 227.105 | 227.2109 | 226.66 | 227.03 | 2833087.0 |
| 2025-02-10 16:00:00 | IWM | ETF | 227.02 | 227.1 | 226.75 | 227.03 | 766843.0 |
| 2025-02-10 17:00:00 | IWM | ETF | 227.03 | 227.15 | 226.93 | 226.93 | 14895.0 |
| 2025-02-10 18:00:00 | IWM | ETF | 227.03 | 227.03 | 226.32 | 226.58 | 44242.0 |
| 2025-02-10 19:00:00 | IWM | ETF | 226.6 | 226.78 | 226.51 | 226.66 | 13463.0 |
| 2025-02-10 04:00:00 | DIA | ETF | 444.22 | 444.22 | 444.22 | 444.22 | 100.0 |
| 2025-02-10 06:00:00 | DIA | ETF | 444.77 | 444.85 | 444.77 | 444.85 | 218.0 |
> showing 50 of 23,810 rows — these rows as CSV