Afonso_DiazBy symbol and type
    Updated 2025-04-06
    with

    main as (
    select
    tx_hash,
    block_timestamp,
    to_address as user,
    symbol,
    amount,
    amount_usd,
    'Bridge to Ink' as type
    from
    ink.core.ez_token_transfers
    where
    origin_to_address = '0xfebcf17b11376c724ab5a5229803c6e838b6eae5'
    and from_address = '0x0000000000000000000000000000000000000000'

    union all

    select
    tx_hash,
    block_timestamp,
    from_address as user,
    symbol,
    amount,
    amount_usd,
    'Bridge from Ink' as type
    from
    ink.core.ez_token_transfers
    where
    origin_to_address = '0x1cb6de532588fca4a21b7209de7c456af8434a65'
    and from_address = origin_from_address
    and to_address = '0x0000000000000000000000000000000000000000'

    union all

    Last run: 27 days ago
    TYPE
    SYMBOL
    TRANSACTIONS
    USERS
    VOLUME_USD
    AVERAGE_AMOUNT_USD
    1
    Bridge from InkUSDC.e1274717854348.41616.172307994
    2
    Bridge from InkUSD₮03235159029296998.339056.25914374
    3
    Bridge to InkUSDC.e17793150089500779417.030067597
    4
    Bridge to InkUSD₮021229769144649.674309.448477851
    5
    Bridge to InkfrxUSD22204.79102.395
    5
    299B
    1s