alitaslimiSupply by Token
    Updated 2024-11-09
    with
    -------------------- Addresses --------------------
    addresses as (
    select
    *
    from
    $query('3bdeef4c-22d0-47e5-b1bc-1c5f4b31d03c')
    ),
    ------------------------------ Prices ------------------------------
    prices as (
    select
    response as price
    from
    (
    select
    livequery.live.udf_api(
    'https://api.coingecko.com/api/v3/simple/price?ids=bitcoin&vs_currencies=usd'
    ):data:"bitcoin":usd as response
    )
    ),
    ------------------------------ Arbitrum ------------------------------
    arbitrum as (
    select
    block_timestamp,
    tx_hash,
    'Arbitrum' as blockchain,
    'Mint' as event,
    symbol,
    amount
    from
    arbitrum.core.ez_token_transfers
    where
    contract_address in (select address from addresses where blockchain = 'Arbitrum')
    and from_address = '0x0000000000000000000000000000000000000000'
    and to_address != '0x0000000000000000000000000000000000000000'
    union all
    QueryRunArchived: QueryRun has been archived