PREVIEW / etf_1hour / 2024-11-08
file: by_date/etf_1hour/2024/2024-11-08.parquet size: 600 KB rows: 22,485
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-08 04:00:00 | SPY | ETF | 596.37 | 596.68 | 596.25 | 596.42 | 22879.0 |
| 2024-11-08 05:00:00 | SPY | ETF | 596.29 | 596.29 | 594.8 | 595.1 | 73875.0 |
| 2024-11-08 06:00:00 | SPY | ETF | 595.03 | 595.41 | 594.72 | 595.39 | 38988.0 |
| 2024-11-08 07:00:00 | SPY | ETF | 595.35 | 595.95 | 595.3 | 595.9 | 210794.0 |
| 2024-11-08 08:00:00 | SPY | ETF | 595.88 | 596.67 | 594.9596 | 595.57 | 181880.0 |
| 2024-11-08 09:00:00 | SPY | ETF | 595.55 | 597.24 | 595.46 | 597.16 | 3033186.0 |
| 2024-11-08 10:00:00 | SPY | ETF | 597.2 | 597.985 | 596.5708 | 597.78 | 3667292.0 |
| 2024-11-08 11:00:00 | SPY | ETF | 597.785 | 598.22 | 597.34 | 597.91 | 2677427.0 |
| 2024-11-08 12:00:00 | SPY | ETF | 597.9399 | 598.35 | 597.44 | 598.09 | 2446612.0 |
| 2024-11-08 13:00:00 | SPY | ETF | 598.09 | 599.21 | 597.96 | 599.01 | 2628091.0 |
| 2024-11-08 14:00:00 | SPY | ETF | 599.015 | 599.64 | 598.67 | 598.91 | 3168692.0 |
| 2024-11-08 15:00:00 | SPY | ETF | 598.92 | 598.98 | 597.62 | 598.24 | 9173017.0 |
| 2024-11-08 16:00:00 | SPY | ETF | 598.24 | 598.43 | 597.8833 | 597.92 | 3127047.0 |
| 2024-11-08 17:00:00 | SPY | ETF | 597.98 | 598.08 | 597.71 | 598.03 | 69657.0 |
| 2024-11-08 18:00:00 | SPY | ETF | 598.03 | 598.04 | 597.82 | 598.03 | 7981.0 |
| 2024-11-08 19:00:00 | SPY | ETF | 597.95 | 598.04 | 597.95 | 598.0 | 10693.0 |
| 2024-11-08 04:00:00 | QQQ | ETF | 514.12 | 514.45 | 514.01 | 514.02 | 43135.0 |
| 2024-11-08 05:00:00 | QQQ | ETF | 513.97 | 513.98 | 511.71 | 512.0 | 140104.0 |
| 2024-11-08 06:00:00 | QQQ | ETF | 511.98 | 512.56 | 511.51 | 512.42 | 86033.0 |
| 2024-11-08 07:00:00 | QQQ | ETF | 512.4 | 513.08 | 512.33 | 512.97 | 97647.0 |
| 2024-11-08 08:00:00 | QQQ | ETF | 512.48 | 514.82 | 511.8596 | 512.51 | 258527.0 |
| 2024-11-08 09:00:00 | QQQ | ETF | 512.49 | 514.156 | 512.31 | 513.65 | 2172349.0 |
| 2024-11-08 10:00:00 | QQQ | ETF | 513.59 | 514.0 | 512.41 | 513.2925 | 2280499.0 |
| 2024-11-08 11:00:00 | QQQ | ETF | 513.3 | 514.23 | 512.67 | 513.79 | 1496192.0 |
| 2024-11-08 12:00:00 | QQQ | ETF | 513.76 | 514.04 | 513.2701 | 513.8 | 1341846.0 |
| 2024-11-08 13:00:00 | QQQ | ETF | 513.8 | 514.9175 | 513.71 | 514.62 | 1802456.0 |
| 2024-11-08 14:00:00 | QQQ | ETF | 514.6 | 514.91 | 514.18 | 514.2 | 1305803.0 |
| 2024-11-08 15:00:00 | QQQ | ETF | 514.19 | 514.27 | 513.56 | 514.16 | 2821683.0 |
| 2024-11-08 16:00:00 | QQQ | ETF | 514.17 | 514.34 | 513.9 | 514.02 | 1284410.0 |
| 2024-11-08 17:00:00 | QQQ | ETF | 514.03 | 514.03 | 513.86 | 513.86 | 17517.0 |
| 2024-11-08 18:00:00 | QQQ | ETF | 514.005 | 514.08 | 513.89 | 514.0699 | 4552.0 |
| 2024-11-08 19:00:00 | QQQ | ETF | 514.0201 | 514.13 | 513.9998 | 514.05 | 8912.0 |
| 2024-11-08 04:00:00 | IWM | ETF | 236.64 | 237.01 | 236.43 | 236.63 | 18207.0 |
| 2024-11-08 05:00:00 | IWM | ETF | 236.69 | 236.71 | 235.69 | 236.22 | 14970.0 |
| 2024-11-08 06:00:00 | IWM | ETF | 236.02 | 236.52 | 235.96 | 236.44 | 16433.0 |
| 2024-11-08 07:00:00 | IWM | ETF | 236.38 | 236.58 | 236.01 | 236.09 | 45322.0 |
| 2024-11-08 08:00:00 | IWM | ETF | 236.09 | 236.86 | 235.8 | 235.85 | 161029.0 |
| 2024-11-08 09:00:00 | IWM | ETF | 235.83 | 237.44 | 235.65 | 236.74 | 2419936.0 |
| 2024-11-08 10:00:00 | IWM | ETF | 236.74 | 237.7 | 236.13 | 237.51 | 3453448.0 |
| 2024-11-08 11:00:00 | IWM | ETF | 237.53 | 237.53 | 236.76 | 236.88 | 2238530.0 |
| 2024-11-08 12:00:00 | IWM | ETF | 236.89 | 237.3272 | 236.34 | 237.2095 | 1490599.0 |
| 2024-11-08 13:00:00 | IWM | ETF | 237.18 | 237.82 | 236.88 | 237.685 | 1359970.0 |
| 2024-11-08 14:00:00 | IWM | ETF | 237.63 | 238.465 | 237.5201 | 238.17 | 1838168.0 |
| 2024-11-08 15:00:00 | IWM | ETF | 238.175 | 238.38 | 237.55 | 238.12 | 3589105.0 |
| 2024-11-08 16:00:00 | IWM | ETF | 238.15 | 238.38 | 238.04 | 238.05 | 1140014.0 |
| 2024-11-08 17:00:00 | IWM | ETF | 238.05 | 238.1035 | 237.84 | 238.03 | 42755.0 |
| 2024-11-08 18:00:00 | IWM | ETF | 238.0 | 238.12 | 237.89 | 238.11 | 8744.0 |
| 2024-11-08 19:00:00 | IWM | ETF | 238.0304 | 238.13 | 238.0209 | 238.11 | 10635.0 |
| 2024-11-08 04:00:00 | DIA | ETF | 437.77 | 437.83 | 437.77 | 437.83 | 200.0 |
| 2024-11-08 05:00:00 | DIA | ETF | 437.42 | 437.42 | 437.35 | 437.35 | 592.0 |
> showing 50 of 22,485 rows — these rows as CSV