PREVIEW / etf_daily / 2024-12-17
file: by_date/etf_daily/2024/2024-12-17.parquet size: 145 KB rows: 3,823
schema
date DATE symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| date | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2024-12-17 | SPY | ETF | 604.19 | 605.17 | 602.885 | 604.29 | 53248802.0 |
| 2024-12-17 | QQQ | ETF | 536.36 | 537.48 | 534.13 | 535.8 | 28579070.0 |
| 2024-12-17 | IWM | ETF | 232.67 | 233.44 | 230.55 | 231.07 | 31402857.0 |
| 2024-12-17 | DIA | ETF | 436.18 | 436.825 | 434.43 | 435.57 | 3086875.0 |
| 2024-12-17 | GLD | ETF | 243.8 | 244.55 | 243.23 | 243.94 | 4274569.0 |
| 2024-12-17 | TLT | ETF | 90.52 | 90.985 | 90.455 | 90.64 | 23329364.0 |
| 2024-12-17 | AAA | ETF | 25.16 | 25.16 | 25.13 | 25.15 | 8190.0 |
| 2024-12-17 | AAAU | ETF | 26.12 | 26.1899 | 26.06 | 26.13 | 1546852.0 |
| 2024-12-17 | AADR | ETF | 71.51 | 71.8899 | 71.51 | 71.88 | 4731.0 |
| 2024-12-17 | AAPB | ETF | 34.0 | 34.83 | 34.0 | 34.76 | 50070.0 |
| 2024-12-17 | AAPD | ETF | 15.4 | 15.44 | 15.215 | 15.23 | 196700.0 |
| 2024-12-17 | AAPR | ETF | 26.495 | 26.495 | 26.495 | 26.495 | 151.0 |
| 2024-12-17 | AAPU | ETF | 38.11 | 39.21 | 38.0 | 39.11 | 367787.0 |
| 2024-12-17 | AAPX | ETF | 38.84 | 39.97 | 38.84 | 39.96 | 40789.0 |
| 2024-12-17 | AAPY | ETF | 28.89 | 29.03 | 28.89 | 29.0193 | 4301.0 |
| 2024-12-17 | AAXJ | ETF | 73.47 | 73.82 | 73.3 | 73.73 | 285398.0 |
| 2024-12-17 | ABCS | ETF | 29.52 | 29.52 | 29.3799 | 29.4056 | 2392.0 |
| 2024-12-17 | ABEQ | ETF | 32.24 | 32.24 | 32.175 | 32.2 | 7792.0 |
| 2024-12-17 | ABFL | ETF | 68.88 | 69.07 | 68.8241 | 69.0161 | 23494.0 |
| 2024-12-17 | ABHY | ETF | 21.33 | 21.33 | 21.33 | 21.33 | 134.0 |
| 2024-12-17 | ABLD | ETF | 30.8 | 30.8 | 30.7 | 30.7241 | 2873.0 |
| 2024-12-17 | ABLG | ETF | 29.57 | 29.58 | 29.47 | 29.5361 | 16348.0 |
| 2024-12-17 | ABNY | ETF | 75.3 | 75.35 | 74.55 | 75.0 | 5901.0 |
| 2024-12-17 | ABOT | ETF | 38.24 | 38.24 | 38.17 | 38.2325 | 2309.0 |
| 2024-12-17 | ACES | ETF | 27.41 | 27.7072 | 27.165 | 27.42 | 54207.0 |
| 2024-12-17 | ACGR | ETF | 59.74 | 59.9595 | 59.74 | 59.9595 | 280.0 |
| 2024-12-17 | ACIO | ETF | 40.94 | 41.03 | 40.88 | 41.01 | 328598.0 |
| 2024-12-17 | ACLC | ETF | 72.65 | 72.8696 | 72.59 | 72.8029 | 82870.0 |
| 2024-12-17 | ACSI | ETF | 62.8475 | 62.8475 | 62.8475 | 62.8475 | 12.0 |
| 2024-12-17 | ACT | ETF | 34.05 | 34.37 | 33.77 | 33.92 | 212435.0 |
| 2024-12-17 | ACTV | ETF | 33.4751 | 33.4751 | 33.26 | 33.3739 | 11788.0 |
| 2024-12-17 | ACVF | ETF | 45.12 | 45.12 | 45.0 | 45.0355 | 6733.0 |
| 2024-12-17 | ACWI | ETF | 120.84 | 120.99 | 120.55 | 120.78 | 3607243.0 |
| 2024-12-17 | ACWV | ETF | 111.1 | 111.1 | 110.59 | 110.75 | 225672.0 |
| 2024-12-17 | ACWX | ETF | 53.39 | 53.59 | 53.25 | 53.42 | 1409600.0 |
| 2024-12-17 | ADFI | ETF | 8.47 | 8.48 | 8.46 | 8.4648 | 12637.0 |
| 2024-12-17 | ADIV | ETF | 15.34 | 15.41 | 15.34 | 15.41 | 1678.0 |
| 2024-12-17 | ADME | ETF | 48.12 | 48.28 | 48.12 | 48.2581 | 21803.0 |
| 2024-12-17 | ADPV | ETF | 37.26 | 37.26 | 36.6178 | 36.9755 | 8518.0 |
| 2024-12-17 | ADVE | ETF | 33.9486 | 33.9486 | 33.9486 | 33.9486 | 1.0 |
| 2024-12-17 | AESR | ETF | 17.91 | 17.91 | 17.78 | 17.8 | 27108.0 |
| 2024-12-17 | AETH | ETF | 50.69 | 50.69 | 49.655 | 49.6882 | 6700.0 |
| 2024-12-17 | AFIF | ETF | 9.165 | 9.168 | 9.15 | 9.155 | 15080.0 |
| 2024-12-17 | AFIX | ETF | 24.8207 | 24.8207 | 24.8207 | 24.8207 | 2.0 |
| 2024-12-17 | AFK | ETF | 16.16 | 16.2699 | 15.9501 | 16.15 | 6616.0 |
| 2024-12-17 | AFLG | ETF | 35.48 | 35.489 | 35.3499 | 35.39 | 16375.0 |
| 2024-12-17 | AFMC | ETF | 33.135 | 33.135 | 32.75 | 32.82 | 7641.0 |
| 2024-12-17 | AFSM | ETF | 31.75 | 31.75 | 31.36 | 31.5092 | 24729.0 |
| 2024-12-17 | AGG | ETF | 98.0 | 98.13 | 97.95 | 98.01 | 7208918.0 |
| 2024-12-17 | AGGH | ETF | 20.88 | 20.88 | 20.77 | 20.77 | 145043.0 |
> showing 50 of 3,823 rows — these rows as CSV