MLDZMN$VEXT holders on Ethereum
    Updated 2023-10-30
    -- forked from $HXRO holders on Ethereum @ https://flipsidecrypto.xyz/edit/queries/e44a4d6f-cee5-4cbd-b9aa-8fcfd62aeac0

    with price_tab as (SELECT
    max(HOUR) as latest_hour,
    avg(PRICE) as token_price
    from ethereum.price.fact_hourly_token_prices
    where TOKEN_ADDRESS = lower('0xB2492E97a68a6E4B9E9a11B99F6C42E5aCCD38c7')
    and PROVIDER='coinmarketcap'
    )

    select
    distinct USER_ADDRESS as Wallet,
    round(CURRENT_BAL,2) as "VEXT Balance",
    round(CURRENT_BAL/1062588 * 100, 3) as "(%) of Supply"
    from ethereum.core.ez_current_balances,price_tab
    where CONTRACT_ADDRESS = lower('0xB2492E97a68a6E4B9E9a11B99F6C42E5aCCD38c7')
    order by "VEXT Balance" desc



    Run a query to Download Data