mz0111redux 11
    Updated 2022-11-03
    select
    'ETH BRIDGE' AS "NAME",
    count (DISTINCT tx_hash) as "op bridge count" ,
    sum (AMOUNT_USD) AS "USD amount"
    from ethereum.core.ez_eth_transfers
    where ORIGIN_TO_ADDRESS = '0x25ace71c97b33cc4729cf772ae268934f7ab5fa1'

    union ALL

    select
    'USDC BRIDGE' AS "NAME",
    count (DISTINCT tx_hash) " bridge count",
    sum (AMOUNT_USD) "USD amount"
    from ethereum.core.ez_token_transfers
    where SYMBOL like 'USDC'
    and ORIGIN_TO_ADDRESS = '0x25ace71c97b33cc4729cf772ae268934f7ab5fa1'

    union ALL

    select
    'USDT BRIDGE' AS "NAME",
    count (DISTINCT tx_hash) " bridge count",
    sum (AMOUNT_USD) "USD amount"
    from ethereum.core.ez_token_transfers
    where SYMBOL like 'USDT'
    and ORIGIN_TO_ADDRESS = '0x25ace71c97b33cc4729cf772ae268934f7ab5fa1'

    union ALL

    select
    'sUSD BRIDGE' AS "NAME",
    count (DISTINCT tx_hash) " bridge count",
    sum (AMOUNT_USD) "USD amount"
    from ethereum.core.ez_token_transfers
    where SYMBOL like 'sUSD'
    and ORIGIN_TO_ADDRESS = '0x25ace71c97b33cc4729cf772ae268934f7ab5fa1'
    Run a query to Download Data