Abolfazl_771025Untitled Query
    Updated 2022-08-28
    select
    *
    --then 'Hop Protocol: USDC Bridge'
    -- when ORIGIN_TO_ADDRESS = '0x3e4a3a4796d16c0cd582c382691998f7c06420b6' then 'Hop Protocol: USDT Bridge'
    --when ORIGIN_TO_ADDRESS = '0x22b1cbb8d98a01a3b71d034bb899775a76eb1cc2' then 'Hop Protocol: MATIC Bridge'
    -- else 'Hop Protocol: DAI Bridge' end as "Bridge",
    --count(distinct ORIGIN_FROM_ADDRESS) as "Total Number of Unique Wallets",
    --sum(RAW_AMOUNT/1e18) as "Total Amount Bridged"
    --sum(amount_usd) as "Total Amount Bridged (USD Scale)"
    from arbitrum.core.fact_token_transfers
    where ORIGIN_to_ADDRESS = '0x0ce6c85cF43553DE10FC56cecA0aef6Ff0DD444d'
    limit 10
    Run a query to Download Data