alessio9567USDz Supply 2
    Updated 6 days ago
    SELECT
    chain,
    usdz_supply
    from
    (
    select
    chain,
    day,
    ROW_NUMBER() OVER (
    PARTITION BY chain
    ORDER BY
    day DESC
    ) AS row_num,
    sum(usdz_minted_amount) as daily_net_usdz_minted_amount,
    sum(daily_net_usdz_minted_amount) over (
    partition by chain
    order by
    day
    ) as usdz_supply
    from
    (
    -- mint
    SELECT
    'ethereum' as chain,
    date_trunc('day', block_timestamp) as day,
    SUM(amount) as usdz_minted_amount
    from
    ethereum.core.ez_token_transfers
    where
    contract_address = '0xa469b7ee9ee773642b3e93e842e5d9b5baa10067'
    and from_address = '0x0000000000000000000000000000000000000000'
    GROUP by
    day
    union
    all -- reedem
    SELECT
    Last run: 6 days agoAuto-refreshes every 24 hours
    CHAIN
    USDZ_SUPPLY
    1
    arbitrum79013.6990648
    2
    blast146726.239184
    3
    base79306721.744043
    4
    ethereum17119027.0730277
    4
    107B
    333s