PREVIEW / etf_1hour / 2024-11-26
file: by_date/etf_1hour/2024/2024-11-26.parquet size: 599 KB rows: 22,434
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-11-26 04:00:00 | SPY | ETF | 597.13 | 597.62 | 596.97 | 597.53 | 21373.0 |
| 2024-11-26 05:00:00 | SPY | ETF | 597.73 | 598.01 | 597.2 | 598.0 | 14598.0 |
| 2024-11-26 06:00:00 | SPY | ETF | 598.0 | 599.19 | 597.69 | 598.96 | 17792.0 |
| 2024-11-26 07:00:00 | SPY | ETF | 598.95 | 599.22 | 598.6 | 599.15 | 339525.0 |
| 2024-11-26 08:00:00 | SPY | ETF | 599.2 | 599.33 | 596.73 | 598.8799 | 199372.0 |
| 2024-11-26 09:00:00 | SPY | ETF | 598.95 | 599.61 | 598.5 | 599.02 | 3552393.0 |
| 2024-11-26 10:00:00 | SPY | ETF | 598.96 | 599.43 | 598.07 | 599.05 | 3053014.0 |
| 2024-11-26 11:00:00 | SPY | ETF | 599.11 | 599.87 | 598.87 | 599.75 | 2253353.0 |
| 2024-11-26 12:00:00 | SPY | ETF | 599.74 | 600.1299 | 599.07 | 600.075 | 1433255.0 |
| 2024-11-26 13:00:00 | SPY | ETF | 600.07 | 600.19 | 599.602 | 600.149 | 1173275.0 |
| 2024-11-26 14:00:00 | SPY | ETF | 600.11 | 600.41 | 599.22 | 600.03 | 3035644.0 |
| 2024-11-26 15:00:00 | SPY | ETF | 600.02 | 601.33 | 599.93 | 600.74 | 9785089.0 |
| 2024-11-26 16:00:00 | SPY | ETF | 600.73 | 601.29 | 600.65 | 601.11 | 4821529.0 |
| 2024-11-26 17:00:00 | SPY | ETF | 601.2 | 601.2 | 600.65 | 601.06 | 47634.0 |
| 2024-11-26 18:00:00 | SPY | ETF | 601.0 | 601.23 | 600.651 | 601.05 | 35604.0 |
| 2024-11-26 19:00:00 | SPY | ETF | 601.02 | 601.14 | 600.65 | 601.1 | 97287.0 |
| 2024-11-26 04:00:00 | QQQ | ETF | 505.72 | 507.1 | 505.72 | 506.76 | 51523.0 |
| 2024-11-26 05:00:00 | QQQ | ETF | 507.02 | 507.22 | 506.27 | 507.06 | 31250.0 |
| 2024-11-26 06:00:00 | QQQ | ETF | 507.0 | 508.31 | 506.75 | 508.1 | 43754.0 |
| 2024-11-26 07:00:00 | QQQ | ETF | 508.11 | 508.48 | 507.9 | 508.35 | 217644.0 |
| 2024-11-26 08:00:00 | QQQ | ETF | 508.47 | 508.5 | 506.24 | 508.23 | 213125.0 |
| 2024-11-26 09:00:00 | QQQ | ETF | 508.26 | 510.14 | 507.79 | 508.88 | 3265220.0 |
| 2024-11-26 10:00:00 | QQQ | ETF | 508.9 | 509.47 | 507.63 | 508.3502 | 2492093.0 |
| 2024-11-26 11:00:00 | QQQ | ETF | 508.38 | 509.17 | 507.72 | 508.72 | 1635212.0 |
| 2024-11-26 12:00:00 | QQQ | ETF | 508.7 | 509.16 | 507.81 | 509.0849 | 1358557.0 |
| 2024-11-26 13:00:00 | QQQ | ETF | 509.05 | 509.0782 | 508.21 | 508.815 | 1168641.0 |
| 2024-11-26 14:00:00 | QQQ | ETF | 508.79 | 509.11 | 507.23 | 507.91 | 2723490.0 |
| 2024-11-26 15:00:00 | QQQ | ETF | 507.88 | 509.71 | 507.79 | 509.3 | 3974442.0 |
| 2024-11-26 16:00:00 | QQQ | ETF | 509.31 | 509.73 | 509.28 | 509.589 | 946531.0 |
| 2024-11-26 17:00:00 | QQQ | ETF | 509.59 | 509.59 | 509.03 | 509.25 | 69133.0 |
| 2024-11-26 18:00:00 | QQQ | ETF | 509.28 | 509.43 | 508.81 | 509.23 | 48970.0 |
| 2024-11-26 19:00:00 | QQQ | ETF | 509.23 | 509.35 | 508.88 | 509.19 | 90026.0 |
| 2024-11-26 04:00:00 | IWM | ETF | 240.94 | 241.15 | 240.79 | 241.1 | 15781.0 |
| 2024-11-26 05:00:00 | IWM | ETF | 241.1 | 241.64 | 240.89 | 241.49 | 19950.0 |
| 2024-11-26 06:00:00 | IWM | ETF | 241.53 | 242.21 | 241.41 | 242.07 | 33726.0 |
| 2024-11-26 07:00:00 | IWM | ETF | 242.17 | 242.6 | 241.96 | 242.27 | 110057.0 |
| 2024-11-26 08:00:00 | IWM | ETF | 242.1712 | 242.54 | 240.9 | 241.58 | 255056.0 |
| 2024-11-26 09:00:00 | IWM | ETF | 241.65 | 241.8 | 240.38 | 240.54 | 2580831.0 |
| 2024-11-26 10:00:00 | IWM | ETF | 240.56 | 241.23 | 239.429 | 240.96 | 2786470.0 |
| 2024-11-26 11:00:00 | IWM | ETF | 241.02 | 241.52 | 240.0801 | 241.15 | 1995760.0 |
| 2024-11-26 12:00:00 | IWM | ETF | 241.12 | 241.6068 | 240.765 | 241.29 | 1079329.0 |
| 2024-11-26 13:00:00 | IWM | ETF | 241.27 | 241.34 | 240.45 | 240.8 | 989163.0 |
| 2024-11-26 14:00:00 | IWM | ETF | 240.79 | 241.06 | 240.19 | 240.31 | 1328776.0 |
| 2024-11-26 15:00:00 | IWM | ETF | 240.3 | 240.98 | 240.24 | 240.6 | 3607085.0 |
| 2024-11-26 16:00:00 | IWM | ETF | 240.62 | 241.29 | 240.57 | 241.08 | 1137340.0 |
| 2024-11-26 17:00:00 | IWM | ETF | 241.05 | 241.28 | 241.0001 | 241.1 | 25119.0 |
| 2024-11-26 18:00:00 | IWM | ETF | 241.23 | 241.32 | 240.94 | 241.24 | 10681.0 |
| 2024-11-26 19:00:00 | IWM | ETF | 241.3 | 241.3 | 241.06 | 241.27 | 15288.0 |
| 2024-11-26 04:00:00 | DIA | ETF | 447.51 | 447.51 | 447.51 | 447.51 | 100.0 |
| 2024-11-26 05:00:00 | DIA | ETF | 447.37 | 447.81 | 447.37 | 447.81 | 620.0 |
> showing 50 of 22,434 rows — these rows as CSV