PREVIEW / etf_1hour / 2024-02-23
file: by_date/etf_1hour/2024/2024-02-23.parquet size: 533 KB rows: 19,627
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-02-23 04:00:00 | SPY | ETF | 507.47 | 507.53 | 507.06 | 507.31 | 18197.0 |
| 2024-02-23 05:00:00 | SPY | ETF | 507.33 | 507.78 | 507.2 | 507.49 | 11891.0 |
| 2024-02-23 06:00:00 | SPY | ETF | 507.48 | 507.81 | 507.48 | 507.65 | 12990.0 |
| 2024-02-23 07:00:00 | SPY | ETF | 507.79 | 508.08 | 507.64 | 507.86 | 45274.0 |
| 2024-02-23 08:00:00 | SPY | ETF | 507.7894 | 508.62 | 507.3 | 508.59 | 126890.0 |
| 2024-02-23 09:00:00 | SPY | ETF | 508.55 | 510.13 | 508.53 | 509.74 | 5644496.0 |
| 2024-02-23 10:00:00 | SPY | ETF | 509.75 | 509.94 | 508.42 | 508.69 | 5526040.0 |
| 2024-02-23 11:00:00 | SPY | ETF | 508.7 | 508.79 | 507.1 | 508.51 | 7081153.0 |
| 2024-02-23 12:00:00 | SPY | ETF | 508.505 | 508.995 | 507.79 | 508.64 | 4182760.0 |
| 2024-02-23 13:00:00 | SPY | ETF | 508.62 | 509.06 | 508.33 | 508.53 | 3016776.0 |
| 2024-02-23 14:00:00 | SPY | ETF | 508.54 | 508.6 | 507.63 | 508.335 | 4221897.0 |
| 2024-02-23 15:00:00 | SPY | ETF | 508.335 | 508.76 | 507.71 | 507.82 | 13086451.0 |
| 2024-02-23 16:00:00 | SPY | ETF | 507.82 | 507.8802 | 507.3502 | 507.37 | 4158041.0 |
| 2024-02-23 17:00:00 | SPY | ETF | 507.41 | 507.41 | 507.16 | 507.4 | 45591.0 |
| 2024-02-23 18:00:00 | SPY | ETF | 507.41 | 507.41 | 507.16 | 507.25 | 26024.0 |
| 2024-02-23 19:00:00 | SPY | ETF | 507.25 | 507.25 | 507.01 | 507.05 | 7124.0 |
| 2024-02-23 04:00:00 | QQQ | ETF | 437.65 | 437.79 | 437.13 | 437.52 | 35831.0 |
| 2024-02-23 05:00:00 | QQQ | ETF | 437.44 | 437.76 | 437.28 | 437.57 | 22105.0 |
| 2024-02-23 06:00:00 | QQQ | ETF | 437.5 | 437.95 | 437.5 | 437.94 | 27633.0 |
| 2024-02-23 07:00:00 | QQQ | ETF | 438.0 | 438.19 | 437.65 | 438.15 | 88249.0 |
| 2024-02-23 08:00:00 | QQQ | ETF | 437.78 | 439.09 | 437.1604 | 438.9 | 190872.0 |
| 2024-02-23 09:00:00 | QQQ | ETF | 438.95 | 440.59 | 438.57 | 439.03 | 4490700.0 |
| 2024-02-23 10:00:00 | QQQ | ETF | 439.04 | 439.3301 | 437.425 | 437.515 | 5400709.0 |
| 2024-02-23 11:00:00 | QQQ | ETF | 437.52 | 438.02 | 435.79 | 437.99 | 5282006.0 |
| 2024-02-23 12:00:00 | QQQ | ETF | 437.99 | 438.62 | 436.96 | 438.14 | 2678068.0 |
| 2024-02-23 13:00:00 | QQQ | ETF | 438.14 | 438.575 | 437.75 | 437.965 | 2210701.0 |
| 2024-02-23 14:00:00 | QQQ | ETF | 438.0 | 438.02 | 436.83 | 437.46 | 2359252.0 |
| 2024-02-23 15:00:00 | QQQ | ETF | 437.46 | 437.585 | 436.23 | 436.75 | 5784005.0 |
| 2024-02-23 16:00:00 | QQQ | ETF | 436.75 | 436.78 | 436.05 | 436.15 | 1380710.0 |
| 2024-02-23 17:00:00 | QQQ | ETF | 436.12 | 436.18 | 436.05 | 436.1 | 20746.0 |
| 2024-02-23 18:00:00 | QQQ | ETF | 436.07 | 436.2 | 436.07 | 436.07 | 24455.0 |
| 2024-02-23 19:00:00 | QQQ | ETF | 436.07 | 436.1 | 435.6 | 435.75 | 27465.0 |
| 2024-02-23 04:00:00 | IWM | ETF | 199.09 | 199.11 | 198.43 | 198.45 | 31609.0 |
| 2024-02-23 05:00:00 | IWM | ETF | 198.5 | 198.79 | 198.37 | 198.7 | 20972.0 |
| 2024-02-23 06:00:00 | IWM | ETF | 198.69 | 199.11 | 198.69 | 199.04 | 26692.0 |
| 2024-02-23 07:00:00 | IWM | ETF | 199.05 | 199.31 | 198.98 | 199.21 | 32333.0 |
| 2024-02-23 08:00:00 | IWM | ETF | 198.96 | 199.6 | 198.4696 | 199.46 | 79632.0 |
| 2024-02-23 09:00:00 | IWM | ETF | 199.48 | 199.91 | 198.64 | 198.98 | 3790985.0 |
| 2024-02-23 10:00:00 | IWM | ETF | 198.96 | 199.97 | 198.565 | 199.8 | 4579815.0 |
| 2024-02-23 11:00:00 | IWM | ETF | 199.8 | 199.96 | 198.94 | 199.84 | 4291249.0 |
| 2024-02-23 12:00:00 | IWM | ETF | 199.83 | 201.08 | 199.78 | 200.8 | 3119307.0 |
| 2024-02-23 13:00:00 | IWM | ETF | 200.79 | 201.135 | 200.66 | 200.8801 | 1899657.0 |
| 2024-02-23 14:00:00 | IWM | ETF | 200.89 | 200.94 | 200.01 | 200.28 | 3093558.0 |
| 2024-02-23 15:00:00 | IWM | ETF | 200.28 | 200.35 | 199.83 | 199.95 | 5224883.0 |
| 2024-02-23 16:00:00 | IWM | ETF | 199.89 | 199.952 | 199.68 | 199.72 | 1155969.0 |
| 2024-02-23 17:00:00 | IWM | ETF | 199.75 | 199.77 | 199.4 | 199.65 | 32560.0 |
| 2024-02-23 18:00:00 | IWM | ETF | 199.56 | 199.89 | 199.55 | 199.61 | 28507.0 |
| 2024-02-23 19:00:00 | IWM | ETF | 199.6 | 199.6 | 199.43 | 199.45 | 6724.0 |
| 2024-02-23 04:00:00 | DIA | ETF | 390.55 | 390.58 | 390.54 | 390.58 | 2250.0 |
| 2024-02-23 05:00:00 | DIA | ETF | 390.61 | 390.7 | 390.61 | 390.7 | 671.0 |
> showing 50 of 19,627 rows — these rows as CSV