PREVIEW / etf_1hour / 2025-03-24
file: by_date/etf_1hour/2025/2025-03-24.parquet size: 641 KB rows: 24,956
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-03-24 04:00:00 | SPY | ETF | 568.27 | 570.41 | 567.35 | 570.28 | 65583.0 |
| 2025-03-24 05:00:00 | SPY | ETF | 570.25 | 570.5 | 569.51 | 569.96 | 35437.0 |
| 2025-03-24 06:00:00 | SPY | ETF | 569.83 | 570.82 | 569.77 | 570.63 | 66949.0 |
| 2025-03-24 07:00:00 | SPY | ETF | 570.55 | 571.23 | 570.36 | 570.98 | 403041.0 |
| 2025-03-24 08:00:00 | SPY | ETF | 570.74 | 571.52 | 567.9 | 571.1402 | 438912.0 |
| 2025-03-24 09:00:00 | SPY | ETF | 571.24 | 572.98 | 570.2 | 572.74 | 5242436.0 |
| 2025-03-24 10:00:00 | SPY | ETF | 572.735 | 573.69 | 572.01 | 573.555 | 4771226.0 |
| 2025-03-24 11:00:00 | SPY | ETF | 573.55 | 573.99 | 573.11 | 573.8796 | 2894419.0 |
| 2025-03-24 12:00:00 | SPY | ETF | 573.87 | 574.39 | 572.77 | 573.1292 | 3505746.0 |
| 2025-03-24 13:00:00 | SPY | ETF | 573.14 | 573.375 | 572.45 | 573.0999 | 2809136.0 |
| 2025-03-24 14:00:00 | SPY | ETF | 573.1 | 573.71 | 572.05 | 573.635 | 4446926.0 |
| 2025-03-24 15:00:00 | SPY | ETF | 573.64 | 575.15 | 573.47 | 574.02 | 9695935.0 |
| 2025-03-24 16:00:00 | SPY | ETF | 574.01 | 574.68 | 573.5134 | 573.98 | 6338946.0 |
| 2025-03-24 17:00:00 | SPY | ETF | 574.0673 | 574.13 | 573.95 | 574.09 | 57235.0 |
| 2025-03-24 18:00:00 | SPY | ETF | 574.05 | 574.0907 | 573.6 | 573.65 | 69015.0 |
| 2025-03-24 19:00:00 | SPY | ETF | 573.65 | 574.04 | 573.65 | 573.8282 | 68445.0 |
| 2025-03-24 04:00:00 | QQQ | ETF | 485.66 | 486.99 | 484.72 | 486.75 | 83225.0 |
| 2025-03-24 05:00:00 | QQQ | ETF | 486.76 | 486.85 | 485.95 | 486.24 | 54019.0 |
| 2025-03-24 06:00:00 | QQQ | ETF | 486.16 | 487.1 | 486.05 | 486.77 | 47212.0 |
| 2025-03-24 07:00:00 | QQQ | ETF | 486.72 | 487.83 | 486.41 | 487.7 | 138451.0 |
| 2025-03-24 08:00:00 | QQQ | ETF | 486.86 | 488.24 | 483.95 | 488.15 | 520130.0 |
| 2025-03-24 09:00:00 | QQQ | ETF | 488.18 | 489.72 | 487.12 | 489.18 | 4223114.0 |
| 2025-03-24 10:00:00 | QQQ | ETF | 489.18 | 490.24 | 488.15 | 489.97 | 2893267.0 |
| 2025-03-24 11:00:00 | QQQ | ETF | 489.9968 | 490.52 | 489.51 | 490.11 | 2184150.0 |
| 2025-03-24 12:00:00 | QQQ | ETF | 490.11 | 490.725 | 489.2456 | 489.7799 | 2149890.0 |
| 2025-03-24 13:00:00 | QQQ | ETF | 489.78 | 489.99 | 489.02 | 489.81 | 1784707.0 |
| 2025-03-24 14:00:00 | QQQ | ETF | 489.82 | 490.5 | 489.01 | 490.38 | 2498090.0 |
| 2025-03-24 15:00:00 | QQQ | ETF | 490.38 | 491.51 | 490.2224 | 490.45 | 6070845.0 |
| 2025-03-24 16:00:00 | QQQ | ETF | 490.44 | 490.73 | 490.119 | 490.25 | 2337634.0 |
| 2025-03-24 17:00:00 | QQQ | ETF | 490.241 | 490.6 | 490.2 | 490.4 | 42431.0 |
| 2025-03-24 18:00:00 | QQQ | ETF | 490.4 | 490.44 | 489.89 | 490.06 | 73976.0 |
| 2025-03-24 19:00:00 | QQQ | ETF | 490.06 | 490.48 | 490.0 | 490.1981 | 97535.0 |
| 2025-03-24 04:00:00 | IWM | ETF | 205.33 | 206.35 | 205.33 | 206.35 | 41725.0 |
| 2025-03-24 05:00:00 | IWM | ETF | 206.37 | 206.42 | 205.98 | 206.22 | 16058.0 |
| 2025-03-24 06:00:00 | IWM | ETF | 206.15 | 206.67 | 206.14 | 206.55 | 42931.0 |
| 2025-03-24 07:00:00 | IWM | ETF | 206.55 | 206.75 | 206.45 | 206.5 | 28997.0 |
| 2025-03-24 08:00:00 | IWM | ETF | 206.5204 | 207.18 | 205.44 | 207.07 | 127811.0 |
| 2025-03-24 09:00:00 | IWM | ETF | 207.09 | 208.02 | 206.69 | 207.675 | 3318457.0 |
| 2025-03-24 10:00:00 | IWM | ETF | 207.67 | 208.445 | 207.31 | 208.43 | 2614524.0 |
| 2025-03-24 11:00:00 | IWM | ETF | 208.45 | 208.88 | 208.21 | 208.515 | 1982990.0 |
| 2025-03-24 12:00:00 | IWM | ETF | 208.52 | 208.84 | 207.75 | 207.83 | 2162383.0 |
| 2025-03-24 13:00:00 | IWM | ETF | 207.83 | 208.2 | 207.64 | 208.1 | 1150485.0 |
| 2025-03-24 14:00:00 | IWM | ETF | 208.11 | 208.7069 | 207.63 | 208.495 | 2684110.0 |
| 2025-03-24 15:00:00 | IWM | ETF | 208.49 | 209.23 | 208.36 | 208.91 | 4155134.0 |
| 2025-03-24 16:00:00 | IWM | ETF | 208.91 | 209.1 | 208.62 | 208.64 | 1511535.0 |
| 2025-03-24 17:00:00 | IWM | ETF | 208.69 | 208.89 | 208.51 | 208.89 | 18264.0 |
| 2025-03-24 18:00:00 | IWM | ETF | 208.69 | 208.76 | 208.44 | 208.47 | 28329.0 |
| 2025-03-24 19:00:00 | IWM | ETF | 208.47 | 208.53 | 208.3999 | 208.52 | 37427.0 |
| 2025-03-24 04:00:00 | DIA | ETF | 422.6 | 423.19 | 422.6 | 423.09 | 2420.0 |
| 2025-03-24 05:00:00 | DIA | ETF | 423.21 | 423.21 | 422.73 | 422.92 | 1600.0 |
> showing 50 of 24,956 rows — these rows as CSV