PREVIEW / etf_daily / 2024-12-20
file: by_date/etf_daily/2024/2024-12-20.parquet size: 145 KB rows: 3,860
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-20 | SPY | ETF | 581.77 | 595.75 | 580.91 | 591.15 | 124827733.0 |
| 2024-12-20 | QQQ | ETF | 510.44 | 524.82 | 509.29 | 518.66 | 60529961.0 |
| 2024-12-20 | IWM | ETF | 218.6 | 224.655 | 218.07 | 221.92 | 52466382.0 |
| 2024-12-20 | DIA | ETF | 422.06 | 432.08 | 421.72 | 428.54 | 5680856.0 |
| 2024-12-20 | GLD | ETF | 241.41 | 242.955 | 241.17 | 242.1 | 9030143.0 |
| 2024-12-20 | TLT | ETF | 88.53 | 88.91 | 88.29 | 88.31 | 44969625.0 |
| 2024-12-20 | AAA | ETF | 25.14 | 25.19 | 25.14 | 25.16 | 8966.0 |
| 2024-12-20 | AAAU | ETF | 25.86 | 26.0157 | 25.8299 | 25.92 | 2233900.0 |
| 2024-12-20 | AADR | ETF | 69.5 | 69.74 | 69.19 | 69.2689 | 2330.0 |
| 2024-12-20 | AAPB | ETF | 33.26 | 35.06 | 32.84 | 35.0 | 94816.0 |
| 2024-12-20 | AAPD | ETF | 15.58 | 15.68 | 15.14 | 15.17 | 827234.0 |
| 2024-12-20 | AAPR | ETF | 26.29 | 26.3541 | 26.29 | 26.3541 | 1317.0 |
| 2024-12-20 | AAPU | ETF | 37.35 | 39.46 | 36.84 | 39.33 | 628571.0 |
| 2024-12-20 | AAPX | ETF | 38.18 | 40.21 | 37.7 | 40.21 | 40989.0 |
| 2024-12-20 | AAPY | ETF | 28.55 | 29.0989 | 28.48 | 29.0989 | 4637.0 |
| 2024-12-20 | AAXJ | ETF | 72.14 | 73.02 | 72.05 | 72.62 | 260031.0 |
| 2024-12-20 | ABCS | ETF | 28.3901 | 28.8991 | 28.3901 | 28.7366 | 2230.0 |
| 2024-12-20 | ABEQ | ETF | 31.45 | 31.85 | 31.43 | 31.7313 | 3909.0 |
| 2024-12-20 | ABFL | ETF | 67.92 | 67.92 | 67.52 | 67.58 | 14172.0 |
| 2024-12-20 | ABHY | ETF | 21.2 | 21.2 | 21.1627 | 21.1627 | 5391.0 |
| 2024-12-20 | ABLD | ETF | 29.58 | 29.827 | 29.58 | 29.77 | 757.0 |
| 2024-12-20 | ABLG | ETF | 26.74 | 28.9393 | 26.74 | 28.895 | 11548.0 |
| 2024-12-20 | ABNY | ETF | 72.95 | 76.125 | 72.95 | 75.45 | 2212.0 |
| 2024-12-20 | ABOT | ETF | 36.76 | 37.5434 | 36.76 | 37.38 | 3030.0 |
| 2024-12-20 | ACES | ETF | 25.4 | 26.65 | 25.4 | 26.23 | 481954.0 |
| 2024-12-20 | ACGR | ETF | 59.04 | 59.04 | 58.5269 | 58.5269 | 1578.0 |
| 2024-12-20 | ACIO | ETF | 40.11 | 40.67 | 40.0809 | 40.48 | 266920.0 |
| 2024-12-20 | ACLC | ETF | 70.1 | 71.7178 | 70.01 | 71.1306 | 10352.0 |
| 2024-12-20 | ACSI | ETF | 61.8477 | 61.8477 | 61.8477 | 61.8477 | 13.0 |
| 2024-12-20 | ACT | ETF | 32.27 | 33.03 | 32.27 | 32.72 | 404666.0 |
| 2024-12-20 | ACTV | ETF | 31.8 | 32.5 | 31.8 | 32.38 | 9308.0 |
| 2024-12-20 | ACVF | ETF | 43.5 | 44.5099 | 43.5 | 44.071 | 10386.0 |
| 2024-12-20 | ACWI | ETF | 116.49 | 119.04 | 116.355 | 118.12 | 4361902.0 |
| 2024-12-20 | ACWV | ETF | 108.7 | 109.88 | 108.43 | 109.3 | 168234.0 |
| 2024-12-20 | ACWX | ETF | 51.67 | 52.45 | 51.63 | 52.1 | 3640501.0 |
| 2024-12-20 | ADFI | ETF | 8.39 | 8.4261 | 8.39 | 8.4053 | 21723.0 |
| 2024-12-20 | ADIV | ETF | 15.2173 | 15.2173 | 15.2173 | 15.2173 | 844.0 |
| 2024-12-20 | ADME | ETF | 46.88 | 47.63 | 46.88 | 47.2547 | 75479.0 |
| 2024-12-20 | ADPV | ETF | 34.93 | 36.5 | 34.85 | 36.4249 | 18088.0 |
| 2024-12-20 | ADVE | ETF | 32.03 | 32.17 | 32.0139 | 32.0139 | 3358.0 |
| 2024-12-20 | AESR | ETF | 17.31 | 17.61 | 17.26 | 17.46 | 30548.0 |
| 2024-12-20 | AETH | ETF | 42.54 | 42.7 | 42.45 | 42.49 | 22409.0 |
| 2024-12-20 | AFIF | ETF | 9.19 | 9.19 | 9.1176 | 9.17 | 43376.0 |
| 2024-12-20 | AFIX | ETF | 24.6312 | 24.6312 | 24.6312 | 24.6312 | 4.0 |
| 2024-12-20 | AFK | ETF | 15.62 | 15.85 | 15.51 | 15.85 | 5365.0 |
| 2024-12-20 | AFLG | ETF | 34.39 | 35.0399 | 34.39 | 34.9 | 29348.0 |
| 2024-12-20 | AFMC | ETF | 31.66 | 32.05 | 31.66 | 31.777 | 3022.0 |
| 2024-12-20 | AFSM | ETF | 30.4573 | 30.58 | 30.26 | 30.26 | 7143.0 |
| 2024-12-20 | AGG | ETF | 97.05 | 97.22 | 96.94 | 96.96 | 8649189.0 |
| 2024-12-20 | AGGH | ETF | 20.72 | 20.72 | 20.5359 | 20.64 | 53006.0 |
> showing 50 of 3,860 rows — these rows as CSV