PREVIEW / etf_1hour / 2024-10-31
file: by_date/etf_1hour/2024/2024-10-31.parquet size: 586 KB rows: 21,827
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-10-31 04:00:00 | SPY | ETF | 576.78 | 576.78 | 575.12 | 575.61 | 53719.0 |
| 2024-10-31 05:00:00 | SPY | ETF | 575.35 | 575.54 | 575.04 | 575.5 | 26612.0 |
| 2024-10-31 06:00:00 | SPY | ETF | 575.55 | 575.84 | 575.2 | 575.7 | 73011.0 |
| 2024-10-31 07:00:00 | SPY | ETF | 575.83 | 576.56 | 575.69 | 576.53 | 448916.0 |
| 2024-10-31 08:00:00 | SPY | ETF | 575.86 | 577.59 | 575.05 | 576.2 | 574509.0 |
| 2024-10-31 09:00:00 | SPY | ETF | 576.15 | 580.01 | 573.14 | 573.76 | 4946427.0 |
| 2024-10-31 10:00:00 | SPY | ETF | 573.74 | 573.79 | 570.95 | 571.1 | 6027624.0 |
| 2024-10-31 11:00:00 | SPY | ETF | 571.1 | 571.7 | 570.08 | 570.94 | 4348105.0 |
| 2024-10-31 12:00:00 | SPY | ETF | 570.9225 | 571.91 | 570.53 | 571.33 | 2736798.0 |
| 2024-10-31 13:00:00 | SPY | ETF | 571.32 | 571.99 | 570.11 | 570.36 | 2192764.0 |
| 2024-10-31 14:00:00 | SPY | ETF | 570.38 | 570.84 | 569.71 | 570.66 | 3954687.0 |
| 2024-10-31 15:00:00 | SPY | ETF | 570.67 | 572.0 | 568.44 | 568.55 | 9677429.0 |
| 2024-10-31 16:00:00 | SPY | ETF | 568.55 | 570.46 | 568.45 | 568.7509 | 5651498.0 |
| 2024-10-31 17:00:00 | SPY | ETF | 568.85 | 569.6 | 568.7 | 569.11 | 198227.0 |
| 2024-10-31 18:00:00 | SPY | ETF | 569.11 | 570.09 | 569.09 | 569.5 | 112596.0 |
| 2024-10-31 19:00:00 | SPY | ETF | 569.6 | 569.63 | 569.05 | 569.4 | 58382.0 |
| 2024-10-31 04:00:00 | QQQ | ETF | 492.28 | 492.28 | 490.48 | 491.13 | 81600.0 |
| 2024-10-31 05:00:00 | QQQ | ETF | 491.14 | 491.48 | 490.94 | 491.24 | 10290.0 |
| 2024-10-31 06:00:00 | QQQ | ETF | 491.34 | 491.77 | 490.59 | 491.74 | 77193.0 |
| 2024-10-31 07:00:00 | QQQ | ETF | 491.71 | 493.05 | 491.71 | 492.991 | 349769.0 |
| 2024-10-31 08:00:00 | QQQ | ETF | 492.09 | 496.16 | 490.4896 | 492.8 | 324105.0 |
| 2024-10-31 09:00:00 | QQQ | ETF | 492.75 | 493.05 | 487.21 | 487.61 | 4608334.0 |
| 2024-10-31 10:00:00 | QQQ | ETF | 487.6 | 488.43 | 485.32 | 485.73 | 4288479.0 |
| 2024-10-31 11:00:00 | QQQ | ETF | 485.7 | 486.37 | 484.17 | 485.27 | 3461396.0 |
| 2024-10-31 12:00:00 | QQQ | ETF | 485.26 | 486.12 | 484.79 | 485.68 | 2662917.0 |
| 2024-10-31 13:00:00 | QQQ | ETF | 485.67 | 486.36 | 484.22 | 484.46 | 2758314.0 |
| 2024-10-31 14:00:00 | QQQ | ETF | 484.47 | 484.9 | 483.82 | 484.76 | 3369968.0 |
| 2024-10-31 15:00:00 | QQQ | ETF | 484.745 | 486.78 | 483.75 | 483.9 | 5429758.0 |
| 2024-10-31 16:00:00 | QQQ | ETF | 483.85 | 486.0 | 483.81 | 484.55 | 2685242.0 |
| 2024-10-31 17:00:00 | QQQ | ETF | 484.57 | 485.72 | 484.14 | 485.17 | 217758.0 |
| 2024-10-31 18:00:00 | QQQ | ETF | 485.18 | 486.23 | 485.05 | 485.6 | 123437.0 |
| 2024-10-31 19:00:00 | QQQ | ETF | 485.67 | 485.7 | 485.21 | 485.32 | 59706.0 |
| 2024-10-31 04:00:00 | IWM | ETF | 221.16 | 221.18 | 220.52 | 221.06 | 23818.0 |
| 2024-10-31 05:00:00 | IWM | ETF | 220.97 | 221.07 | 220.6 | 221.07 | 20578.0 |
| 2024-10-31 06:00:00 | IWM | ETF | 221.08 | 221.25 | 220.76 | 221.13 | 39848.0 |
| 2024-10-31 07:00:00 | IWM | ETF | 221.17 | 221.67 | 221.0 | 221.6 | 219966.0 |
| 2024-10-31 08:00:00 | IWM | ETF | 221.41 | 221.91 | 220.6004 | 221.53 | 268521.0 |
| 2024-10-31 09:00:00 | IWM | ETF | 221.53 | 221.77 | 219.984 | 220.57 | 2475052.0 |
| 2024-10-31 10:00:00 | IWM | ETF | 220.56 | 220.73 | 218.77 | 218.8 | 2610868.0 |
| 2024-10-31 11:00:00 | IWM | ETF | 218.78 | 219.59 | 218.32 | 219.43 | 2184445.0 |
| 2024-10-31 12:00:00 | IWM | ETF | 219.45 | 220.06 | 219.21 | 219.4 | 1505768.0 |
| 2024-10-31 13:00:00 | IWM | ETF | 219.39 | 220.13 | 219.24 | 219.47 | 1322392.0 |
| 2024-10-31 14:00:00 | IWM | ETF | 219.48 | 219.61 | 218.84 | 219.26 | 1843903.0 |
| 2024-10-31 15:00:00 | IWM | ETF | 219.26 | 219.39 | 217.63 | 217.71 | 3692617.0 |
| 2024-10-31 16:00:00 | IWM | ETF | 217.71 | 217.96 | 217.0 | 217.49 | 1743216.0 |
| 2024-10-31 17:00:00 | IWM | ETF | 217.54 | 217.76 | 217.47 | 217.67 | 177347.0 |
| 2024-10-31 18:00:00 | IWM | ETF | 217.67 | 217.8592 | 217.4 | 217.62 | 12558.0 |
| 2024-10-31 19:00:00 | IWM | ETF | 217.52 | 217.71 | 217.4 | 217.5 | 30038.0 |
| 2024-10-31 04:00:00 | DIA | ETF | 420.0 | 420.0 | 419.69 | 419.77 | 750.0 |
| 2024-10-31 05:00:00 | DIA | ETF | 419.57 | 419.57 | 419.41 | 419.49 | 700.0 |
> showing 50 of 21,827 rows — these rows as CSV