mz0111redux 9
    Updated 2022-11-03
    SELECT
    "NAME",
    case
    when "USD bridge amount" between 0 and 10 then '0-10 USD'
    when "USD bridge amount" between 10 and 100 then '10-100 USD'
    when "USD bridge amount" between 100 and 1000 then '100-1000 USD'
    when "USD bridge amount" between 1000 and 10000 then '1000-10000 USD'
    when "USD bridge amount" > 10000 then 'MORE THAN 10000 USD'
    END AS "USD amount distribution",
    count("op bridge")
    from
    ( select
    DISTINCT TX_HASH as "op bridge",
    'USDC BRIDGE' AS "NAME",
    SUM(AMOUNT_USD) AS "USD bridge amount",
    avg(AMOUNT_USD) as "Average USD bridge amount"
    from ethereum.core.ez_token_transfers
    where to_address = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1'
    and SYMBOL LIKE 'USDC'
    group by 1

    union ALL

    select
    DISTINCT TX_HASH as "op bridge",
    'USDT BRIDGE' AS "NAME",
    SUM(AMOUNT_USD) AS "USD bridge amount",
    avg(AMOUNT_USD) as "Average USD bridge amount"
    from ethereum.core.ez_token_transfers
    where to_address = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1'
    and SYMBOL LIKE 'USDT'
    group by 1

    union ALL


    Run a query to Download Data