PS0G1The amount of daily bridge transactions from Ethereum
    Updated 2022-09-15
    --credit mlh
    select date_trunc('day', block_timestamp) as daily,
    count (DISTINCT tx_hash) as trxs,
    count (DISTINCT ORIGIN_FROM_ADDRESS) as users,
    sum (amount_usd) as USD_volume,
    case when contract_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' then 'USDC'
    when contract_address = '0xdac17f958d2ee523a2206206994597c13d831ec7' then 'USDT'
    end as coin
    from ethereum.core.ez_token_transfers
    where to_address ='0x99c9fc46f92e8a1c0dec1b1747d010903e884be1'
    group by 1, 5
    HAVING coin is not NULL
    UNION

    select date_trunc('day', block_timestamp) as daily,
    count (DISTINCT tx_hash) as trxs,
    count (DISTINCT ORIGIN_FROM_ADDRESS) as users,
    sum (amount_usd) as USD_volume,
    'ETH' as coin
    from ethereum.core.ez_eth_transfers
    where eth_to_address = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1'
    group by 1, 5
    Run a query to Download Data