PREVIEW / etf_daily / 2024-12-23
file: by_date/etf_daily/2024/2024-12-23.parquet size: 146 KB rows: 3,858
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-23 | SPY | ETF | 590.89 | 595.3 | 587.661 | 594.69 | 54282316.0 |
| 2024-12-23 | QQQ | ETF | 519.55 | 523.25 | 516.13 | 522.87 | 29672800.0 |
| 2024-12-23 | IWM | ETF | 221.74 | 222.4 | 219.38 | 221.41 | 29674684.0 |
| 2024-12-23 | DIA | ETF | 427.3 | 429.439 | 424.98 | 428.89 | 2467765.0 |
| 2024-12-23 | GLD | ETF | 241.6 | 241.67 | 240.65 | 240.96 | 5410663.0 |
| 2024-12-23 | TLT | ETF | 88.16 | 88.23 | 87.44 | 87.5 | 32717763.0 |
| 2024-12-23 | AAA | ETF | 25.19 | 25.2199 | 25.122 | 25.21 | 23495.0 |
| 2024-12-23 | AAAU | ETF | 25.88 | 25.88 | 25.775 | 25.805 | 1871638.0 |
| 2024-12-23 | AADR | ETF | 69.7299 | 69.7299 | 69.685 | 69.685 | 1329.0 |
| 2024-12-23 | AAPB | ETF | 35.13 | 35.29 | 34.7135 | 35.2 | 85102.0 |
| 2024-12-23 | AAPD | ETF | 15.0 | 15.075 | 14.945 | 14.96 | 727015.0 |
| 2024-12-23 | AAPR | ETF | 26.35 | 26.385 | 26.341 | 26.385 | 1965.0 |
| 2024-12-23 | AAPU | ETF | 39.16 | 39.37 | 38.72 | 39.3 | 252492.0 |
| 2024-12-23 | AAPX | ETF | 40.29 | 40.44 | 39.84 | 40.43 | 37973.0 |
| 2024-12-23 | AAPY | ETF | 29.09 | 29.29 | 29.0335 | 29.2475 | 4757.0 |
| 2024-12-23 | AAXJ | ETF | 72.84 | 73.31 | 72.65 | 73.25 | 222951.0 |
| 2024-12-23 | ABCS | ETF | 28.613 | 28.85 | 28.613 | 28.8253 | 1621.0 |
| 2024-12-23 | ABEQ | ETF | 31.66 | 31.8042 | 31.5373 | 31.8042 | 1960.0 |
| 2024-12-23 | ABFL | ETF | 67.171 | 67.6974 | 67.13 | 67.6974 | 56233.0 |
| 2024-12-23 | ABHY | ETF | 21.11 | 21.11 | 21.1 | 21.1 | 102.0 |
| 2024-12-23 | ABLD | ETF | 29.62 | 29.8358 | 29.62 | 29.8358 | 1153.0 |
| 2024-12-23 | ABLG | ETF | 28.76 | 28.92 | 28.6701 | 28.9045 | 29962.0 |
| 2024-12-23 | ABNY | ETF | 76.3 | 76.3 | 74.825 | 76.25 | 12822.0 |
| 2024-12-23 | ABOT | ETF | 37.1332 | 37.4461 | 37.1332 | 37.4461 | 3381.0 |
| 2024-12-23 | ACES | ETF | 26.24 | 26.62 | 26.22 | 26.6 | 322733.0 |
| 2024-12-23 | ACGR | ETF | 58.73 | 59.1954 | 58.73 | 59.1954 | 1843.0 |
| 2024-12-23 | ACIO | ETF | 40.54 | 40.69 | 40.3762 | 40.68 | 179270.0 |
| 2024-12-23 | ACLC | ETF | 70.97 | 71.7 | 70.97 | 71.6978 | 6685.0 |
| 2024-12-23 | ACSI | ETF | 61.4901 | 62.1749 | 61.4901 | 62.1749 | 1049.0 |
| 2024-12-23 | ACT | ETF | 32.43 | 32.77 | 32.37 | 32.52 | 128899.0 |
| 2024-12-23 | ACTV | ETF | 32.17 | 32.37 | 32.17 | 32.3612 | 3626.0 |
| 2024-12-23 | ACTX | ETF | 0.0002 | 0.0002 | 0.0002 | 0.0002 | 376.0 |
| 2024-12-23 | ACVF | ETF | 44.23 | 44.48 | 43.97 | 44.46 | 9919.0 |
| 2024-12-23 | ACWI | ETF | 117.9 | 118.95 | 117.55 | 118.85 | 3182005.0 |
| 2024-12-23 | ACWV | ETF | 109.15 | 109.55 | 108.73 | 109.475 | 157635.0 |
| 2024-12-23 | ACWX | ETF | 52.16 | 52.455 | 51.96 | 52.41 | 2370947.0 |
| 2024-12-23 | ADFI | ETF | 8.39 | 8.395 | 8.37 | 8.3791 | 30109.0 |
| 2024-12-23 | ADIV | ETF | 15.31 | 15.395 | 15.31 | 15.395 | 3829.0 |
| 2024-12-23 | ADME | ETF | 47.29 | 47.5399 | 47.15 | 47.5 | 16821.0 |
| 2024-12-23 | ADPV | ETF | 36.42 | 36.5025 | 36.1 | 36.4662 | 13135.0 |
| 2024-12-23 | ADVE | ETF | 32.06 | 32.2523 | 32.0599 | 32.2523 | 1950.0 |
| 2024-12-23 | AESR | ETF | 17.44 | 17.62 | 17.44 | 17.62 | 31754.0 |
| 2024-12-23 | AETH | ETF | 43.0 | 43.0 | 42.53 | 42.59 | 14003.0 |
| 2024-12-23 | AFIF | ETF | 9.14 | 9.16 | 9.1119 | 9.14 | 39523.0 |
| 2024-12-23 | AFIX | ETF | 24.5694 | 24.5694 | 24.5694 | 24.5694 | 2.0 |
| 2024-12-23 | AFK | ETF | 15.84 | 15.9 | 15.6101 | 15.84 | 6712.0 |
| 2024-12-23 | AFLG | ETF | 34.74 | 35.01 | 34.689 | 35.01 | 21376.0 |
| 2024-12-23 | AFMC | ETF | 31.85 | 31.85 | 31.8106 | 31.8106 | 271.0 |
| 2024-12-23 | AFSM | ETF | 30.3 | 30.3 | 30.06 | 30.2089 | 58055.0 |
| 2024-12-23 | AGG | ETF | 96.95 | 96.9699 | 96.6 | 96.66 | 10341301.0 |
> showing 50 of 3,858 rows — these rows as CSV