PREVIEW / etf_daily / 2024-09-18
file: by_date/etf_daily/2024/2024-09-18.parquet size: 136 KB rows: 3,523
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-09-18 | SPY | ETF | 563.74 | 568.69 | 560.83 | 561.4 | 58862262.0 |
| 2024-09-18 | QQQ | ETF | 474.7 | 478.83 | 470.83 | 471.44 | 39909215.0 |
| 2024-09-18 | IWM | ETF | 219.23 | 224.94 | 218.25 | 219.45 | 53888466.0 |
| 2024-09-18 | DIA | ETF | 417.5 | 421.0 | 415.55 | 416.19 | 3152659.0 |
| 2024-09-18 | GLD | ETF | 238.19 | 240.2896 | 235.3 | 235.51 | 11069765.0 |
| 2024-09-18 | TLT | ETF | 100.24 | 100.7266 | 99.54 | 99.59 | 48889633.0 |
| 2024-09-18 | AAA | ETF | 25.1198 | 25.1199 | 25.02 | 25.085 | 6142.0 |
| 2024-09-18 | AAAU | ETF | 25.5 | 25.715 | 25.19 | 25.215 | 2715876.0 |
| 2024-09-18 | AADR | ETF | 62.9381 | 62.9381 | 62.9381 | 62.9381 | 135.0 |
| 2024-09-18 | AAPB | ETF | 26.33 | 27.5 | 26.33 | 27.02 | 107750.0 |
| 2024-09-18 | AAPD | ETF | 17.74 | 17.74 | 17.3402 | 17.5 | 538661.0 |
| 2024-09-18 | AAPR | ETF | 26.0296 | 26.0389 | 26.01 | 26.0389 | 2292.0 |
| 2024-09-18 | AAPU | ETF | 33.63 | 35.14 | 33.63 | 34.54 | 912426.0 |
| 2024-09-18 | AAPX | ETF | 30.4 | 31.61 | 30.4 | 31.24 | 15875.0 |
| 2024-09-18 | AAXJ | ETF | 72.65 | 73.13 | 72.16 | 72.26 | 192535.0 |
| 2024-09-18 | ABCS | ETF | 28.0 | 28.15 | 28.0 | 28.0049 | 2138.0 |
| 2024-09-18 | ABEQ | ETF | 32.6001 | 32.725 | 32.4601 | 32.5797 | 3325.0 |
| 2024-09-18 | ABNY | ETF | 81.3005 | 81.85 | 81.3005 | 81.6 | 544.0 |
| 2024-09-18 | ACES | ETF | 28.95 | 29.87 | 28.79 | 28.85 | 60682.0 |
| 2024-09-18 | ACIO | ETF | 39.16 | 39.3699 | 39.01 | 39.06 | 196840.0 |
| 2024-09-18 | ACSI | ETF | 57.0414 | 57.0414 | 57.0414 | 57.0414 | 16.0 |
| 2024-09-18 | ACT | ETF | 36.28 | 37.04 | 36.0898 | 36.64 | 331267.0 |
| 2024-09-18 | ACTV | ETF | 33.14 | 33.8458 | 33.14 | 33.327 | 2460.0 |
| 2024-09-18 | ACVF | ETF | 43.02 | 43.02 | 42.6847 | 42.6847 | 12122.0 |
| 2024-09-18 | ACWI | ETF | 116.55 | 117.6 | 116.03 | 116.16 | 1133563.0 |
| 2024-09-18 | ACWV | ETF | 113.46 | 113.81 | 112.89 | 113.07 | 118825.0 |
| 2024-09-18 | ACWX | ETF | 55.3 | 55.71 | 54.96 | 55.05 | 492268.0 |
| 2024-09-18 | ADFI | ETF | 8.84 | 8.84 | 8.8157 | 8.84 | 5723.0 |
| 2024-09-18 | ADIV | ETF | 15.28 | 15.28 | 15.1388 | 15.1388 | 8183.0 |
| 2024-09-18 | ADME | ETF | 45.59 | 45.59 | 45.2614 | 45.2894 | 6255.0 |
| 2024-09-18 | ADPV | ETF | 31.9531 | 32.2599 | 31.831 | 31.9748 | 5365.0 |
| 2024-09-18 | AEMB | ETF | 39.2619 | 39.2619 | 39.2619 | 39.2619 | 28.0 |
| 2024-09-18 | AESR | ETF | 16.57 | 16.7 | 16.5 | 16.529 | 12295.0 |
| 2024-09-18 | AETH | ETF | 29.71 | 30.14 | 29.52 | 29.8251 | 4519.0 |
| 2024-09-18 | AFIF | ETF | 9.25 | 9.2591 | 9.22 | 9.255 | 2222.0 |
| 2024-09-18 | AFK | ETF | 16.41 | 16.48 | 16.16 | 16.16 | 7280.0 |
| 2024-09-18 | AFLG | ETF | 33.27 | 33.47 | 33.2002 | 33.2002 | 2294.0 |
| 2024-09-18 | AFMC | ETF | 32.03 | 32.03 | 31.4613 | 31.4613 | 334.0 |
| 2024-09-18 | AFSM | ETF | 30.244 | 30.53 | 30.2342 | 30.3261 | 2366.0 |
| 2024-09-18 | AFTY | ETF | 13.54 | 13.54 | 13.4982 | 13.4982 | 1315.0 |
| 2024-09-18 | AGG | ETF | 101.68 | 102.03 | 101.53 | 101.56 | 6279411.0 |
| 2024-09-18 | AGGH | ETF | 21.95 | 21.96 | 21.81 | 21.94 | 68936.0 |
| 2024-09-18 | AGGS | ETF | 42.74 | 42.74 | 42.632 | 42.632 | 102.0 |
| 2024-09-18 | AGGY | ETF | 45.06 | 45.22 | 45.01 | 45.01 | 60092.0 |
| 2024-09-18 | AGIX | ETF | 24.3917 | 24.3978 | 24.3917 | 24.3978 | 993.0 |
| 2024-09-18 | AGMI | ETF | 27.81 | 27.81 | 27.14 | 27.14 | 111.0 |
| 2024-09-18 | AGNG | ETF | 32.7915 | 33.04 | 32.7915 | 32.8295 | 1904.0 |
| 2024-09-18 | AGOX | ETF | 28.46 | 28.76 | 28.29 | 28.61 | 27042.0 |
| 2024-09-18 | AGQ | ETF | 39.44 | 40.9078 | 37.01 | 37.42 | 4231763.0 |
| 2024-09-18 | AGQI | ETF | 14.5 | 14.5004 | 14.4522 | 14.4522 | 8983.0 |
> showing 50 of 3,523 rows — these rows as CSV