PREVIEW / etf_1hour / 2025-09-05
file: by_date/etf_1hour/2025/2025-09-05.parquet size: 685 KB rows: 25,993
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-09-05 04:00:00 | SPY | ETF | 650.36 | 650.81 | 649.88 | 650.58 | 31768.0 |
| 2025-09-05 05:00:00 | SPY | ETF | 650.76 | 650.76 | 650.43 | 650.44 | 26745.0 |
| 2025-09-05 06:00:00 | SPY | ETF | 650.42 | 650.62 | 650.28 | 650.41 | 40414.0 |
| 2025-09-05 07:00:00 | SPY | ETF | 650.4 | 650.71 | 649.86 | 649.86 | 137599.0 |
| 2025-09-05 08:00:00 | SPY | ETF | 650.55 | 651.66 | 648.44 | 651.63 | 1488345.0 |
| 2025-09-05 09:00:00 | SPY | ETF | 651.63 | 652.21 | 650.54 | 651.065 | 8101184.0 |
| 2025-09-05 10:00:00 | SPY | ETF | 651.06 | 651.095 | 644.0896 | 644.14 | 14913628.0 |
| 2025-09-05 11:00:00 | SPY | ETF | 644.15 | 646.9 | 643.33 | 645.67 | 8530362.0 |
| 2025-09-05 12:00:00 | SPY | ETF | 645.68 | 646.75 | 645.23 | 646.47 | 4991303.0 |
| 2025-09-05 13:00:00 | SPY | ETF | 646.47 | 646.55 | 644.61 | 645.12 | 4856286.0 |
| 2025-09-05 14:00:00 | SPY | ETF | 645.15 | 646.31 | 644.9 | 646.31 | 4952634.0 |
| 2025-09-05 15:00:00 | SPY | ETF | 646.29 | 647.41 | 645.9 | 647.21 | 11391411.0 |
| 2025-09-05 16:00:00 | SPY | ETF | 647.19 | 647.26 | 646.63 | 646.98 | 2207278.0 |
| 2025-09-05 17:00:00 | SPY | ETF | 646.93 | 647.048 | 646.1997 | 646.23 | 221224.0 |
| 2025-09-05 18:00:00 | SPY | ETF | 646.17 | 646.27 | 645.8894 | 646.07 | 141124.0 |
| 2025-09-05 19:00:00 | SPY | ETF | 646.06 | 646.09 | 645.88 | 645.96 | 96402.0 |
| 2025-09-05 04:00:00 | QQQ | ETF | 577.21 | 578.43 | 577.21 | 578.43 | 53713.0 |
| 2025-09-05 05:00:00 | QQQ | ETF | 578.5 | 578.5 | 578.19 | 578.28 | 30751.0 |
| 2025-09-05 06:00:00 | QQQ | ETF | 578.31 | 578.43 | 578.06 | 578.23 | 63872.0 |
| 2025-09-05 07:00:00 | QQQ | ETF | 578.11 | 578.7 | 577.98 | 577.98 | 55079.0 |
| 2025-09-05 08:00:00 | QQQ | ETF | 578.36 | 580.46 | 574.799 | 580.45 | 1424328.0 |
| 2025-09-05 09:00:00 | QQQ | ETF | 580.45 | 581.12 | 579.21 | 579.95 | 9608548.0 |
| 2025-09-05 10:00:00 | QQQ | ETF | 579.92 | 579.94 | 572.5 | 572.5542 | 13129226.0 |
| 2025-09-05 11:00:00 | QQQ | ETF | 572.56 | 575.5 | 571.53 | 574.27 | 7794282.0 |
| 2025-09-05 12:00:00 | QQQ | ETF | 574.26 | 575.24 | 573.71 | 575.15 | 4526997.0 |
| 2025-09-05 13:00:00 | QQQ | ETF | 575.14 | 575.32 | 573.49 | 574.175 | 4127836.0 |
| 2025-09-05 14:00:00 | QQQ | ETF | 574.18 | 575.35 | 573.92 | 575.215 | 2678838.0 |
| 2025-09-05 15:00:00 | QQQ | ETF | 575.21 | 576.12 | 574.84 | 576.03 | 6258234.0 |
| 2025-09-05 16:00:00 | QQQ | ETF | 576.05 | 576.15 | 575.46 | 575.58 | 1477371.0 |
| 2025-09-05 17:00:00 | QQQ | ETF | 575.52 | 575.71 | 575.08 | 575.08 | 71441.0 |
| 2025-09-05 18:00:00 | QQQ | ETF | 575.07 | 575.13 | 574.8548 | 575.0 | 15793.0 |
| 2025-09-05 19:00:00 | QQQ | ETF | 574.97 | 575.02 | 574.89 | 574.89 | 16789.0 |
| 2025-09-05 04:00:00 | IWM | ETF | 236.89 | 236.99 | 236.85 | 236.97 | 27194.0 |
| 2025-09-05 05:00:00 | IWM | ETF | 236.98 | 237.09 | 236.96 | 237.02 | 10305.0 |
| 2025-09-05 06:00:00 | IWM | ETF | 237.05 | 237.2 | 236.98 | 237.16 | 33988.0 |
| 2025-09-05 07:00:00 | IWM | ETF | 237.14 | 237.34 | 236.88 | 236.88 | 47425.0 |
| 2025-09-05 08:00:00 | IWM | ETF | 237.26 | 238.59 | 235.2 | 237.74 | 1123861.0 |
| 2025-09-05 09:00:00 | IWM | ETF | 237.79 | 239.68 | 237.61 | 239.16 | 5517707.0 |
| 2025-09-05 10:00:00 | IWM | ETF | 239.14 | 239.19 | 234.95 | 235.09 | 8587479.0 |
| 2025-09-05 11:00:00 | IWM | ETF | 235.09 | 237.245 | 235.05 | 236.79 | 4749410.0 |
| 2025-09-05 12:00:00 | IWM | ETF | 236.79 | 237.38 | 236.63 | 237.26 | 3452962.0 |
| 2025-09-05 13:00:00 | IWM | ETF | 237.26 | 237.305 | 236.16 | 236.38 | 3451712.0 |
| 2025-09-05 14:00:00 | IWM | ETF | 236.38 | 237.22 | 236.32 | 237.2001 | 2956499.0 |
| 2025-09-05 15:00:00 | IWM | ETF | 237.2 | 237.905 | 237.01 | 237.76 | 7177672.0 |
| 2025-09-05 16:00:00 | IWM | ETF | 237.77 | 237.86 | 237.6 | 237.7101 | 1026956.0 |
| 2025-09-05 17:00:00 | IWM | ETF | 237.68 | 237.78 | 237.29 | 237.29 | 7818.0 |
| 2025-09-05 18:00:00 | IWM | ETF | 237.31 | 237.62 | 237.31 | 237.46 | 2186.0 |
| 2025-09-05 19:00:00 | IWM | ETF | 237.53 | 237.54 | 237.25 | 237.26 | 4815.0 |
| 2025-09-05 04:00:00 | DIA | ETF | 457.19 | 457.3 | 457.19 | 457.21 | 700.0 |
| 2025-09-05 05:00:00 | DIA | ETF | 457.22 | 457.22 | 457.13 | 457.13 | 600.0 |
> showing 50 of 25,993 rows — these rows as CSV