PREVIEW / etf_1hour / 2024-09-25
file: by_date/etf_1hour/2024/2024-09-25.parquet size: 558 KB rows: 20,874
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 |
|---|---|---|---|---|---|---|---|
| 2024-09-25 04:00:00 | SPY | ETF | 570.4 | 570.61 | 570.26 | 570.38 | 16786.0 |
| 2024-09-25 05:00:00 | SPY | ETF | 570.39 | 570.6 | 570.09 | 570.4 | 7839.0 |
| 2024-09-25 06:00:00 | SPY | ETF | 570.69 | 571.15 | 570.68 | 571.15 | 18187.0 |
| 2024-09-25 07:00:00 | SPY | ETF | 571.15 | 571.3 | 570.87 | 571.1 | 32456.0 |
| 2024-09-25 08:00:00 | SPY | ETF | 570.42 | 571.2396 | 569.68 | 571.1 | 151568.0 |
| 2024-09-25 09:00:00 | SPY | ETF | 571.07 | 571.8281 | 570.86 | 571.54 | 3795827.0 |
| 2024-09-25 10:00:00 | SPY | ETF | 571.58 | 571.89 | 570.6 | 571.23 | 3291612.0 |
| 2024-09-25 11:00:00 | SPY | ETF | 571.24 | 571.41 | 570.32 | 570.74 | 2560218.0 |
| 2024-09-25 12:00:00 | SPY | ETF | 570.74 | 570.83 | 569.88 | 569.99 | 2518832.0 |
| 2024-09-25 13:00:00 | SPY | ETF | 569.98 | 570.32 | 568.91 | 570.2719 | 3515331.0 |
| 2024-09-25 14:00:00 | SPY | ETF | 570.25 | 570.38 | 569.03 | 570.025 | 2453743.0 |
| 2024-09-25 15:00:00 | SPY | ETF | 570.02 | 570.26 | 569.33 | 570.0 | 5841767.0 |
| 2024-09-25 16:00:00 | SPY | ETF | 570.0 | 570.5 | 569.84 | 570.3 | 3156938.0 |
| 2024-09-25 17:00:00 | SPY | ETF | 570.26 | 570.54 | 570.22 | 570.4035 | 43292.0 |
| 2024-09-25 18:00:00 | SPY | ETF | 570.4 | 570.57 | 570.12 | 570.47 | 39010.0 |
| 2024-09-25 19:00:00 | SPY | ETF | 570.46 | 571.0 | 570.36 | 570.94 | 62084.0 |
| 2024-09-25 04:00:00 | QQQ | ETF | 484.16 | 484.2 | 483.41 | 483.62 | 29051.0 |
| 2024-09-25 05:00:00 | QQQ | ETF | 483.61 | 483.98 | 483.26 | 483.92 | 20031.0 |
| 2024-09-25 06:00:00 | QQQ | ETF | 483.97 | 484.56 | 483.95 | 484.45 | 36996.0 |
| 2024-09-25 07:00:00 | QQQ | ETF | 484.49 | 484.7 | 484.29 | 484.67 | 78767.0 |
| 2024-09-25 08:00:00 | QQQ | ETF | 484.67 | 485.07 | 483.0 | 484.93 | 99905.0 |
| 2024-09-25 09:00:00 | QQQ | ETF | 484.9002 | 486.93 | 484.68 | 486.9199 | 2280169.0 |
| 2024-09-25 10:00:00 | QQQ | ETF | 486.89 | 487.79 | 486.22 | 486.7742 | 2944637.0 |
| 2024-09-25 11:00:00 | QQQ | ETF | 486.8 | 487.17 | 485.6 | 486.2575 | 2222979.0 |
| 2024-09-25 12:00:00 | QQQ | ETF | 486.23 | 486.47 | 485.38 | 485.58 | 1544780.0 |
| 2024-09-25 13:00:00 | QQQ | ETF | 485.56 | 486.14 | 484.56 | 486.09 | 2175810.0 |
| 2024-09-25 14:00:00 | QQQ | ETF | 486.08 | 486.24 | 484.78 | 485.83 | 1968722.0 |
| 2024-09-25 15:00:00 | QQQ | ETF | 485.83 | 486.07 | 485.44 | 485.93 | 2602781.0 |
| 2024-09-25 16:00:00 | QQQ | ETF | 485.94 | 487.16 | 485.79 | 487.1 | 1597663.0 |
| 2024-09-25 17:00:00 | QQQ | ETF | 487.1 | 487.17 | 486.95 | 487.0501 | 104519.0 |
| 2024-09-25 18:00:00 | QQQ | ETF | 487.2 | 487.4 | 486.89 | 487.26 | 66041.0 |
| 2024-09-25 19:00:00 | QQQ | ETF | 487.24 | 488.07 | 487.11 | 487.95 | 79498.0 |
| 2024-09-25 04:00:00 | IWM | ETF | 220.53 | 220.53 | 219.95 | 220.11 | 17428.0 |
| 2024-09-25 05:00:00 | IWM | ETF | 220.11 | 220.23 | 219.97 | 220.23 | 10333.0 |
| 2024-09-25 06:00:00 | IWM | ETF | 220.33 | 220.74 | 220.32 | 220.74 | 8883.0 |
| 2024-09-25 07:00:00 | IWM | ETF | 220.81 | 220.93 | 220.5 | 220.74 | 19962.0 |
| 2024-09-25 08:00:00 | IWM | ETF | 220.7904 | 220.84 | 219.25 | 220.34 | 59928.0 |
| 2024-09-25 09:00:00 | IWM | ETF | 220.31 | 220.61 | 219.15 | 219.43 | 2620320.0 |
| 2024-09-25 10:00:00 | IWM | ETF | 219.45 | 220.0805 | 219.01 | 219.76 | 1863155.0 |
| 2024-09-25 11:00:00 | IWM | ETF | 219.8 | 219.985 | 218.9 | 219.0699 | 1316218.0 |
| 2024-09-25 12:00:00 | IWM | ETF | 219.0501 | 219.29 | 218.39 | 218.4301 | 1507390.0 |
| 2024-09-25 13:00:00 | IWM | ETF | 218.4498 | 218.6 | 217.655 | 218.25 | 1870490.0 |
| 2024-09-25 14:00:00 | IWM | ETF | 218.25 | 218.49 | 217.82 | 218.085 | 1578151.0 |
| 2024-09-25 15:00:00 | IWM | ETF | 218.08 | 218.51 | 217.54 | 217.73 | 3367946.0 |
| 2024-09-25 16:00:00 | IWM | ETF | 217.69 | 218.02 | 217.6383 | 217.8 | 1524577.0 |
| 2024-09-25 17:00:00 | IWM | ETF | 217.88 | 218.08 | 217.83 | 217.9601 | 14775.0 |
| 2024-09-25 18:00:00 | IWM | ETF | 217.96 | 218.03 | 217.8 | 218.01 | 16188.0 |
| 2024-09-25 19:00:00 | IWM | ETF | 217.9 | 218.11 | 217.84 | 218.0135 | 30816.0 |
| 2024-09-25 04:00:00 | DIA | ETF | 421.71 | 421.77 | 421.71 | 421.77 | 300.0 |
| 2024-09-25 05:00:00 | DIA | ETF | 421.66 | 421.9 | 421.66 | 421.9 | 318.0 |
> showing 50 of 20,874 rows — these rows as CSV