PREVIEW / etf_daily / 2024-12-18
file: by_date/etf_daily/2024/2024-12-18.parquet size: 147 KB rows: 3,849
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-18 | SPY | ETF | 603.98 | 606.405 | 585.89 | 586.28 | 104384745.0 |
| 2024-12-18 | QQQ | ETF | 535.15 | 536.8799 | 515.01 | 516.47 | 54703155.0 |
| 2024-12-18 | IWM | ETF | 232.24 | 233.076 | 218.92 | 220.84 | 49433306.0 |
| 2024-12-18 | DIA | ETF | 435.98 | 438.04 | 423.98 | 424.22 | 5776602.0 |
| 2024-12-18 | GLD | ETF | 243.57 | 243.7095 | 238.82 | 239.26 | 7943082.0 |
| 2024-12-18 | TLT | ETF | 89.97 | 90.37 | 89.14 | 89.16 | 60137920.0 |
| 2024-12-18 | AAA | ETF | 25.17 | 25.18 | 25.07 | 25.1509 | 19720.0 |
| 2024-12-18 | AAAU | ETF | 26.09 | 26.0999 | 25.57 | 25.625 | 2239414.0 |
| 2024-12-18 | AADR | ETF | 68.65 | 68.65 | 68.65 | 68.65 | 293.0 |
| 2024-12-18 | AAPB | ETF | 34.56 | 34.9341 | 33.16 | 33.16 | 57637.0 |
| 2024-12-18 | AAPD | ETF | 15.32 | 15.58 | 15.185 | 15.55 | 786920.0 |
| 2024-12-18 | AAPR | ETF | 26.455 | 26.54 | 26.3152 | 26.3152 | 1715.0 |
| 2024-12-18 | AAPU | ETF | 38.73 | 39.34 | 37.32 | 37.39 | 492615.0 |
| 2024-12-18 | AAPX | ETF | 39.53 | 40.065 | 38.07 | 38.07 | 36666.0 |
| 2024-12-18 | AAPY | ETF | 28.95 | 29.09 | 28.64 | 28.8357 | 4617.0 |
| 2024-12-18 | AAXJ | ETF | 73.77 | 73.94 | 72.105 | 72.15 | 498896.0 |
| 2024-12-18 | ABCS | ETF | 29.51 | 29.51 | 28.4844 | 28.4844 | 1100.0 |
| 2024-12-18 | ABEQ | ETF | 32.1 | 32.18 | 31.5 | 31.5065 | 5775.0 |
| 2024-12-18 | ABFL | ETF | 68.6781 | 68.679 | 66.782 | 66.782 | 12922.0 |
| 2024-12-18 | ABHY | ETF | 21.31 | 21.34 | 21.14 | 21.14 | 3306.0 |
| 2024-12-18 | ABLD | ETF | 30.69 | 30.69 | 29.7623 | 29.7623 | 3260.0 |
| 2024-12-18 | ABLG | ETF | 29.44 | 29.5 | 28.847 | 28.847 | 6092.0 |
| 2024-12-18 | ABNY | ETF | 75.35 | 75.55 | 72.45 | 72.45 | 2245.0 |
| 2024-12-18 | ABOT | ETF | 37.85 | 38.17 | 36.8473 | 36.8473 | 3353.0 |
| 2024-12-18 | ACES | ETF | 27.4 | 27.7194 | 25.95 | 26.08 | 49277.0 |
| 2024-12-18 | ACGR | ETF | 60.05 | 60.05 | 58.05 | 58.2348 | 2314.0 |
| 2024-12-18 | ACIO | ETF | 40.985 | 41.1097 | 40.2461 | 40.26 | 248583.0 |
| 2024-12-18 | ACLC | ETF | 72.65 | 73.0599 | 70.755 | 70.8567 | 7023.0 |
| 2024-12-18 | ACSI | ETF | 61.3194 | 61.3194 | 61.3194 | 61.3194 | 44.0 |
| 2024-12-18 | ACT | ETF | 33.93 | 34.095 | 32.51 | 32.6 | 340460.0 |
| 2024-12-18 | ACTV | ETF | 33.52 | 33.52 | 32.26 | 32.26 | 24192.0 |
| 2024-12-18 | ACVF | ETF | 45.025 | 45.16 | 43.7846 | 43.85 | 8395.0 |
| 2024-12-18 | ACWI | ETF | 120.75 | 121.035 | 117.02 | 117.19 | 6811197.0 |
| 2024-12-18 | ACWV | ETF | 110.61 | 110.725 | 108.57 | 108.6 | 334290.0 |
| 2024-12-18 | ACWX | ETF | 53.45 | 53.49 | 52.035 | 52.1 | 1800172.0 |
| 2024-12-18 | ADFI | ETF | 8.46 | 8.47 | 8.3923 | 8.4006 | 30083.0 |
| 2024-12-18 | ADIV | ETF | 15.23 | 15.23 | 15.14 | 15.1539 | 1222.0 |
| 2024-12-18 | ADME | ETF | 48.2941 | 48.3572 | 47.01 | 47.01 | 22766.0 |
| 2024-12-18 | ADPV | ETF | 36.8996 | 36.9 | 35.233 | 35.233 | 6854.0 |
| 2024-12-18 | ADVE | ETF | 32.0032 | 32.0032 | 31.8427 | 31.8427 | 5784.0 |
| 2024-12-18 | AESR | ETF | 17.9037 | 17.9037 | 17.29 | 17.29 | 56438.0 |
| 2024-12-18 | AETH | ETF | 48.78 | 49.13 | 46.27 | 46.52 | 7879.0 |
| 2024-12-18 | AFIF | ETF | 9.19 | 9.19 | 9.02 | 9.15 | 59602.0 |
| 2024-12-18 | AFIX | ETF | 24.6532 | 24.6532 | 24.6532 | 24.6532 | 8.0 |
| 2024-12-18 | AFK | ETF | 16.11 | 16.11 | 15.37 | 15.57 | 10965.0 |
| 2024-12-18 | AFLG | ETF | 35.51 | 35.51 | 34.45 | 34.47 | 20811.0 |
| 2024-12-18 | AFMC | ETF | 32.0625 | 32.0625 | 31.6814 | 31.6814 | 1340.0 |
| 2024-12-18 | AFSM | ETF | 31.8 | 31.8 | 30.25 | 30.27 | 11143.0 |
| 2024-12-18 | AGG | ETF | 97.66 | 97.8 | 96.9 | 96.95 | 14228627.0 |
| 2024-12-18 | AGGH | ETF | 20.85 | 20.85 | 20.63 | 20.73 | 82338.0 |
> showing 50 of 3,849 rows — these rows as CSV