mariyaTotal distinct wallets ( bridge from Optimism to Ethereum )
    Updated 2022-09-12
    with ETHTable as (
    select count (distinct tx_hash) as TX_Count,
    count (distinct origin_from_address) as Users_Count,
    sum (amount_usd) as USD_Volume,
    sum (amount) as Volume
    from ethereum.core.ez_eth_transfers
    where origin_to_address = '0x25ace71c97b33cc4729cf772ae268934f7ab5fa1'),
    TokenTable as (
    select count (distinct tx_hash) as TX_Count,
    count (distinct origin_from_address) as Users_Count,
    sum (amount_usd) as USD_Volume,
    sum (amount) as Volume
    from ethereum.core.ez_token_transfers
    where origin_to_address = '0x25ace71c97b33cc4729cf772ae268934f7ab5fa1'
    and contract_address = lower('0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48'))

    select 'ETH' as type, *
    from ethtable
    union all
    select 'USDC' as type, *
    from tokentable
    Run a query to Download Data