PREVIEW / etf_1hour / 2025-02-19
file: by_date/etf_1hour/2025/2025-02-19.parquet size: 634 KB rows: 23,998
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-19 04:00:00 | SPY | ETF | 611.75 | 611.96 | 611.49 | 611.54 | 12346.0 |
| 2025-02-19 05:00:00 | SPY | ETF | 611.57 | 611.57 | 610.61 | 610.84 | 18035.0 |
| 2025-02-19 06:00:00 | SPY | ETF | 610.69 | 610.75 | 610.19 | 610.52 | 40146.0 |
| 2025-02-19 07:00:00 | SPY | ETF | 610.54 | 611.23 | 610.5 | 610.73 | 63355.0 |
| 2025-02-19 08:00:00 | SPY | ETF | 610.5199 | 611.98 | 609.83 | 610.14 | 131369.0 |
| 2025-02-19 09:00:00 | SPY | ETF | 610.14 | 610.48 | 609.6845 | 609.92 | 1888957.0 |
| 2025-02-19 10:00:00 | SPY | ETF | 609.92 | 610.89 | 609.56 | 610.14 | 2179749.0 |
| 2025-02-19 11:00:00 | SPY | ETF | 610.14 | 611.77 | 610.14 | 611.7 | 1725997.0 |
| 2025-02-19 12:00:00 | SPY | ETF | 611.66 | 611.96 | 610.86 | 611.56 | 1367224.0 |
| 2025-02-19 13:00:00 | SPY | ETF | 611.56 | 612.04 | 610.65 | 611.49 | 1458457.0 |
| 2025-02-19 14:00:00 | SPY | ETF | 611.52 | 613.23 | 611.4 | 613.11 | 2700391.0 |
| 2025-02-19 15:00:00 | SPY | ETF | 613.08 | 613.1 | 611.8 | 612.9 | 5335417.0 |
| 2025-02-19 16:00:00 | SPY | ETF | 612.91 | 612.93 | 611.6841 | 612.14 | 1973272.0 |
| 2025-02-19 17:00:00 | SPY | ETF | 612.14 | 612.18 | 612.04 | 612.1 | 46082.0 |
| 2025-02-19 18:00:00 | SPY | ETF | 612.1 | 612.36 | 611.87 | 612.15 | 156783.0 |
| 2025-02-19 19:00:00 | SPY | ETF | 612.01 | 612.3 | 611.81 | 612.3 | 9886.0 |
| 2025-02-19 04:00:00 | QQQ | ETF | 539.9 | 540.1 | 539.5 | 539.6 | 21879.0 |
| 2025-02-19 05:00:00 | QQQ | ETF | 539.6 | 539.61 | 538.6 | 538.9 | 16621.0 |
| 2025-02-19 06:00:00 | QQQ | ETF | 538.86 | 539.0 | 538.38 | 538.71 | 25503.0 |
| 2025-02-19 07:00:00 | QQQ | ETF | 538.71 | 539.77 | 538.65 | 539.15 | 102973.0 |
| 2025-02-19 08:00:00 | QQQ | ETF | 539.5 | 540.16 | 537.97 | 538.55 | 175075.0 |
| 2025-02-19 09:00:00 | QQQ | ETF | 538.54 | 538.94 | 537.33 | 537.6477 | 1483358.0 |
| 2025-02-19 10:00:00 | QQQ | ETF | 537.64 | 538.61 | 536.46 | 537.5 | 1952562.0 |
| 2025-02-19 11:00:00 | QQQ | ETF | 537.49 | 539.43 | 537.47 | 539.355 | 1537557.0 |
| 2025-02-19 12:00:00 | QQQ | ETF | 539.34 | 539.76 | 538.64 | 539.5 | 1374766.0 |
| 2025-02-19 13:00:00 | QQQ | ETF | 539.51 | 539.96 | 538.32 | 539.19 | 1268816.0 |
| 2025-02-19 14:00:00 | QQQ | ETF | 539.2 | 540.81 | 539.07 | 540.73 | 1484543.0 |
| 2025-02-19 15:00:00 | QQQ | ETF | 540.7 | 540.7 | 538.54 | 539.56 | 3482772.0 |
| 2025-02-19 16:00:00 | QQQ | ETF | 539.55 | 539.62 | 538.75 | 538.96 | 708846.0 |
| 2025-02-19 17:00:00 | QQQ | ETF | 538.97 | 539.05 | 538.64 | 538.7 | 35036.0 |
| 2025-02-19 18:00:00 | QQQ | ETF | 538.79 | 539.21 | 538.6704 | 538.8 | 92386.0 |
| 2025-02-19 19:00:00 | QQQ | ETF | 538.8 | 539.0699 | 538.431 | 539.02 | 65393.0 |
| 2025-02-19 04:00:00 | IWM | ETF | 227.2 | 227.2 | 226.84 | 226.93 | 30604.0 |
| 2025-02-19 05:00:00 | IWM | ETF | 226.9 | 226.92 | 226.24 | 226.36 | 23213.0 |
| 2025-02-19 06:00:00 | IWM | ETF | 226.33 | 226.35 | 225.79 | 225.81 | 39051.0 |
| 2025-02-19 07:00:00 | IWM | ETF | 225.83 | 226.41 | 225.83 | 226.06 | 107221.0 |
| 2025-02-19 08:00:00 | IWM | ETF | 225.8795 | 227.51 | 225.52 | 225.5293 | 124124.0 |
| 2025-02-19 09:00:00 | IWM | ETF | 225.54 | 226.04 | 225.08 | 225.975 | 2299457.0 |
| 2025-02-19 10:00:00 | IWM | ETF | 225.95 | 226.28 | 225.46 | 225.57 | 1536128.0 |
| 2025-02-19 11:00:00 | IWM | ETF | 225.57 | 226.47 | 225.505 | 226.29 | 950012.0 |
| 2025-02-19 12:00:00 | IWM | ETF | 226.27 | 226.37 | 225.81 | 225.83 | 879915.0 |
| 2025-02-19 13:00:00 | IWM | ETF | 225.813 | 226.22 | 225.56 | 226.04 | 745335.0 |
| 2025-02-19 14:00:00 | IWM | ETF | 226.05 | 227.15 | 225.915 | 226.89 | 1311365.0 |
| 2025-02-19 15:00:00 | IWM | ETF | 226.885 | 226.9 | 226.17 | 226.41 | 2118202.0 |
| 2025-02-19 16:00:00 | IWM | ETF | 226.43 | 226.43 | 225.9 | 225.9407 | 1761067.0 |
| 2025-02-19 17:00:00 | IWM | ETF | 225.97 | 226.08 | 225.92 | 225.97 | 20180.0 |
| 2025-02-19 18:00:00 | IWM | ETF | 226.02 | 226.15 | 225.86 | 226.03 | 38471.0 |
| 2025-02-19 19:00:00 | IWM | ETF | 225.93 | 226.06 | 225.7 | 226.03 | 97546.0 |
| 2025-02-19 04:00:00 | DIA | ETF | 446.3 | 446.3 | 446.3 | 446.3 | 100.0 |
| 2025-02-19 05:00:00 | DIA | ETF | 446.01 | 446.01 | 445.56 | 445.56 | 600.0 |
> showing 50 of 23,998 rows — these rows as CSV