PREVIEW / etf_1hour / 2025-02-14
file: by_date/etf_1hour/2025/2025-02-14.parquet size: 629 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-14 04:00:00 | SPY | ETF | 609.97 | 610.5 | 609.85 | 609.95 | 28959.0 |
| 2025-02-14 05:00:00 | SPY | ETF | 609.92 | 609.92 | 609.26 | 609.35 | 21810.0 |
| 2025-02-14 06:00:00 | SPY | ETF | 609.21 | 609.23 | 608.62 | 608.99 | 31286.0 |
| 2025-02-14 07:00:00 | SPY | ETF | 608.96 | 609.34 | 608.94 | 609.34 | 55960.0 |
| 2025-02-14 08:00:00 | SPY | ETF | 609.27 | 611.02 | 608.9981 | 609.72 | 180779.0 |
| 2025-02-14 09:00:00 | SPY | ETF | 609.75 | 610.64 | 609.65 | 610.465 | 2546214.0 |
| 2025-02-14 10:00:00 | SPY | ETF | 610.48 | 610.99 | 609.73 | 610.51 | 2234411.0 |
| 2025-02-14 11:00:00 | SPY | ETF | 610.53 | 610.85 | 609.4 | 610.23 | 2013587.0 |
| 2025-02-14 12:00:00 | SPY | ETF | 610.22 | 610.245 | 609.07 | 609.92 | 1341727.0 |
| 2025-02-14 13:00:00 | SPY | ETF | 609.92 | 610.7506 | 609.7 | 610.48 | 997203.0 |
| 2025-02-14 14:00:00 | SPY | ETF | 610.49 | 610.72 | 609.83 | 610.22 | 1608299.0 |
| 2025-02-14 15:00:00 | SPY | ETF | 610.21 | 610.29 | 609.545 | 609.7 | 5210894.0 |
| 2025-02-14 16:00:00 | SPY | ETF | 609.69 | 610.0901 | 609.42 | 609.98 | 1975824.0 |
| 2025-02-14 17:00:00 | SPY | ETF | 609.93 | 609.95 | 609.7 | 609.87 | 23263.0 |
| 2025-02-14 18:00:00 | SPY | ETF | 609.78 | 609.8 | 609.48 | 609.55 | 28976.0 |
| 2025-02-14 19:00:00 | SPY | ETF | 609.55 | 609.83 | 609.55 | 609.78 | 20872.0 |
| 2025-02-14 04:00:00 | QQQ | ETF | 536.27 | 537.0 | 536.1 | 536.53 | 62694.0 |
| 2025-02-14 05:00:00 | QQQ | ETF | 536.5 | 536.53 | 535.81 | 536.09 | 38276.0 |
| 2025-02-14 06:00:00 | QQQ | ETF | 536.01 | 536.01 | 534.53 | 535.02 | 86044.0 |
| 2025-02-14 07:00:00 | QQQ | ETF | 535.04 | 535.57 | 534.89 | 535.54 | 52609.0 |
| 2025-02-14 08:00:00 | QQQ | ETF | 535.2 | 537.36 | 534.91 | 536.05 | 164303.0 |
| 2025-02-14 09:00:00 | QQQ | ETF | 536.04 | 536.89 | 535.67 | 536.53 | 1549317.0 |
| 2025-02-14 10:00:00 | QQQ | ETF | 536.54 | 537.6 | 535.85 | 537.44 | 2154840.0 |
| 2025-02-14 11:00:00 | QQQ | ETF | 537.45 | 537.58 | 535.99 | 536.84 | 1338080.0 |
| 2025-02-14 12:00:00 | QQQ | ETF | 536.82 | 537.38 | 535.71 | 537.265 | 1021587.0 |
| 2025-02-14 13:00:00 | QQQ | ETF | 537.27 | 538.2463 | 536.98 | 537.93 | 1107467.0 |
| 2025-02-14 14:00:00 | QQQ | ETF | 537.93 | 538.41 | 537.25 | 537.79 | 1137310.0 |
| 2025-02-14 15:00:00 | QQQ | ETF | 537.77 | 538.84 | 537.33 | 538.12 | 2743112.0 |
| 2025-02-14 16:00:00 | QQQ | ETF | 538.14 | 538.73 | 537.85 | 538.3 | 1384477.0 |
| 2025-02-14 17:00:00 | QQQ | ETF | 538.31 | 538.42 | 538.15 | 538.3 | 15473.0 |
| 2025-02-14 18:00:00 | QQQ | ETF | 538.33 | 538.5735 | 538.12 | 538.12 | 10818.0 |
| 2025-02-14 19:00:00 | QQQ | ETF | 538.12 | 538.22 | 538.1 | 538.11 | 10431.0 |
| 2025-02-14 04:00:00 | IWM | ETF | 226.21 | 226.54 | 226.19 | 226.3 | 27231.0 |
| 2025-02-14 05:00:00 | IWM | ETF | 226.25 | 226.29 | 226.02 | 226.25 | 8811.0 |
| 2025-02-14 06:00:00 | IWM | ETF | 226.12 | 226.5 | 226.03 | 226.46 | 50051.0 |
| 2025-02-14 07:00:00 | IWM | ETF | 226.44 | 226.55 | 226.32 | 226.55 | 10415.0 |
| 2025-02-14 08:00:00 | IWM | ETF | 226.3996 | 227.01 | 226.22 | 226.97 | 186049.0 |
| 2025-02-14 09:00:00 | IWM | ETF | 226.9601 | 227.98 | 226.8 | 227.56 | 2232206.0 |
| 2025-02-14 10:00:00 | IWM | ETF | 227.575 | 227.77 | 226.5 | 226.5801 | 1649896.0 |
| 2025-02-14 11:00:00 | IWM | ETF | 226.59 | 226.99 | 225.87 | 226.26 | 1560944.0 |
| 2025-02-14 12:00:00 | IWM | ETF | 226.23 | 226.28 | 225.61 | 225.925 | 800463.0 |
| 2025-02-14 13:00:00 | IWM | ETF | 225.94 | 226.325 | 225.81 | 226.19 | 439227.0 |
| 2025-02-14 14:00:00 | IWM | ETF | 226.19 | 226.32 | 225.94 | 226.27 | 621206.0 |
| 2025-02-14 15:00:00 | IWM | ETF | 226.27 | 226.36 | 225.66 | 225.99 | 2334590.0 |
| 2025-02-14 16:00:00 | IWM | ETF | 225.97 | 226.14 | 225.81 | 226.14 | 819444.0 |
| 2025-02-14 17:00:00 | IWM | ETF | 226.1 | 226.19 | 226.03 | 226.19 | 55628.0 |
| 2025-02-14 18:00:00 | IWM | ETF | 226.14 | 226.23 | 225.93 | 225.93 | 12000.0 |
| 2025-02-14 19:00:00 | IWM | ETF | 226.02 | 226.0281 | 225.97 | 225.97 | 471.0 |
| 2025-02-14 04:00:00 | DIA | ETF | 447.21 | 447.21 | 447.21 | 447.21 | 300.0 |
| 2025-02-14 05:00:00 | DIA | ETF | 446.67 | 446.67 | 446.2 | 446.2 | 2216.0 |
> showing 50 of 23,369 rows — these rows as CSV