PREVIEW / etf_daily / 2024-12-26
file: by_date/etf_daily/2024/2024-12-26.parquet size: 146 KB rows: 3,843
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-26 | SPY | ETF | 599.5 | 602.48 | 598.0825 | 601.34 | 40929412.0 |
| 2024-12-26 | QQQ | ETF | 528.32 | 531.24 | 526.31 | 529.6 | 19141494.0 |
| 2024-12-26 | IWM | ETF | 222.42 | 226.1407 | 221.465 | 225.68 | 19960596.0 |
| 2024-12-26 | DIA | ETF | 430.97 | 433.67 | 430.92 | 433.21 | 1853703.0 |
| 2024-12-26 | GLD | ETF | 242.39 | 243.56 | 242.195 | 243.07 | 4423220.0 |
| 2024-12-26 | TLT | ETF | 87.21 | 87.96 | 87.2 | 87.82 | 19932342.0 |
| 2024-12-26 | AAA | ETF | 25.18 | 25.18 | 25.04 | 25.075 | 24087.0 |
| 2024-12-26 | AAAU | ETF | 25.94 | 26.085 | 25.94 | 26.035 | 1103725.0 |
| 2024-12-26 | AADR | ETF | 70.4928 | 70.4928 | 70.19 | 70.19 | 866.0 |
| 2024-12-26 | AAPB | ETF | 36.02 | 36.475 | 35.86 | 36.23 | 104704.0 |
| 2024-12-26 | AAPD | ETF | 14.8 | 14.835 | 14.7 | 14.76 | 508361.0 |
| 2024-12-26 | AAPR | ETF | 26.48 | 26.49 | 26.47 | 26.49 | 2543.0 |
| 2024-12-26 | AAPU | ETF | 40.19 | 40.72 | 39.97 | 40.43 | 300307.0 |
| 2024-12-26 | AAPX | ETF | 34.32 | 34.85 | 34.28 | 34.62 | 32714.0 |
| 2024-12-26 | AAPY | ETF | 27.76 | 27.8 | 27.66 | 27.77 | 15160.0 |
| 2024-12-26 | AAXJ | ETF | 72.93 | 73.46 | 72.93 | 73.3 | 109577.0 |
| 2024-12-26 | ABCS | ETF | 28.91 | 29.1308 | 28.89 | 29.1308 | 1224.0 |
| 2024-12-26 | ABEQ | ETF | 32.01 | 32.01 | 31.97 | 31.9772 | 4123.0 |
| 2024-12-26 | ABFL | ETF | 68.0115 | 68.2559 | 68.0115 | 68.2559 | 43010.0 |
| 2024-12-26 | ABHY | ETF | 21.14 | 21.14 | 21.12 | 21.1399 | 3299.0 |
| 2024-12-26 | ABLD | ETF | 30.0099 | 30.0099 | 29.9 | 29.95 | 2422.0 |
| 2024-12-26 | ABLG | ETF | 29.0004 | 29.0535 | 28.98 | 29.0086 | 27849.0 |
| 2024-12-26 | ABNY | ETF | 76.35 | 76.75 | 76.1695 | 76.75 | 1032.0 |
| 2024-12-26 | ABOT | ETF | 37.7 | 37.8858 | 37.7 | 37.8858 | 2722.0 |
| 2024-12-26 | ACES | ETF | 26.74 | 27.18 | 26.6401 | 27.04 | 167458.0 |
| 2024-12-26 | ACGR | ETF | 59.65 | 59.99 | 59.65 | 59.8479 | 455.0 |
| 2024-12-26 | ACIO | ETF | 40.86 | 41.01 | 40.81 | 40.97 | 115412.0 |
| 2024-12-26 | ACLC | ETF | 72.36 | 72.6371 | 72.3 | 72.5776 | 7686.0 |
| 2024-12-26 | ACSI | ETF | 62.35 | 62.4104 | 62.35 | 62.4104 | 142.0 |
| 2024-12-26 | ACT | ETF | 32.62 | 32.955 | 32.48 | 32.91 | 128387.0 |
| 2024-12-26 | ACTV | ETF | 32.53 | 32.8246 | 32.53 | 32.8246 | 5880.0 |
| 2024-12-26 | ACVF | ETF | 44.71 | 44.92 | 44.7 | 44.91 | 10173.0 |
| 2024-12-26 | ACWI | ETF | 119.5 | 120.19 | 119.42 | 119.95 | 1480746.0 |
| 2024-12-26 | ACWV | ETF | 109.76 | 110.31 | 109.76 | 110.29 | 119108.0 |
| 2024-12-26 | ACWX | ETF | 52.68 | 52.79 | 52.515 | 52.71 | 1255750.0 |
| 2024-12-26 | ADFI | ETF | 8.36 | 8.406 | 8.31 | 8.405 | 5070.0 |
| 2024-12-26 | ADIV | ETF | 15.53 | 15.5445 | 15.53 | 15.5445 | 749.0 |
| 2024-12-26 | ADME | ETF | 48.04 | 48.1214 | 47.9602 | 48.1 | 7800.0 |
| 2024-12-26 | ADPV | ETF | 36.82 | 37.0928 | 36.7243 | 37.0928 | 1614.0 |
| 2024-12-26 | ADVE | ETF | 32.3317 | 32.3317 | 32.3317 | 32.3317 | 17.0 |
| 2024-12-26 | AESR | ETF | 17.69 | 17.8 | 17.69 | 17.75 | 6051.0 |
| 2024-12-26 | AETH | ETF | 38.25 | 38.85 | 37.05 | 37.0868 | 5763.0 |
| 2024-12-26 | AFIF | ETF | 9.12 | 9.1329 | 9.1139 | 9.1329 | 4838.0 |
| 2024-12-26 | AFIX | ETF | 24.6036 | 24.6036 | 24.6036 | 24.6036 | 4.0 |
| 2024-12-26 | AFK | ETF | 15.7 | 15.9308 | 15.66 | 15.73 | 4983.0 |
| 2024-12-26 | AFLG | ETF | 35.35 | 35.36 | 35.29 | 35.34 | 7056.0 |
| 2024-12-26 | AFMC | ETF | 32.02 | 32.1496 | 32.02 | 32.1496 | 229.0 |
| 2024-12-26 | AFSM | ETF | 30.648 | 30.74 | 30.52 | 30.73 | 23737.0 |
| 2024-12-26 | AGG | ETF | 96.52 | 96.8799 | 96.51 | 96.84 | 10590435.0 |
| 2024-12-26 | AGGH | ETF | 20.45 | 20.55 | 20.29 | 20.55 | 60838.0 |
> showing 50 of 3,843 rows — these rows as CSV