AlishBridge Users (Hop Protocol)
    Updated 2022-06-21
    with bridge as (
    select
    date(block_timestamp) as date , contract_address , ORIGIN_FROM_ADDRESS Address ,
    CASE
    WHEN (contract_address = lower('0x3e4a3a4796d16c0cd582c382691998f7c06420b6')
    OR contract_address = lower('0x3666f603Cc164936C1b87e207F36BEBa4AC5f18a')) then EVENT_INPUTS:amount /1e6
    ELSE EVENT_INPUTS:amount /1e18 END as total_amount
    from ethereum_core.fact_event_logs
    where event_name = 'TransferSentToL2'
    and date >= CURRENT_DATE-180)
    select
    date, case
    when contract_address = lower('0xb8901acb165ed027e32754e0ffe830802919727f') then 'ETHEREUM'
    when contract_address = lower('0x22b1cbb8d98a01a3b71d034bb899775a76eb1cc2') then 'MATIC'
    when contract_address = lower('0x3666f603Cc164936C1b87e207F36BEBa4AC5f18a') then 'USDC'
    when contract_address = lower('0x3d4Cc8A61c7528Fd86C55cfe061a78dCBA48EDd1') then 'DAI'
    when contract_address = lower('0x3e4a3a4796d16c0cd582c382691998f7c06420b6') then 'USDT'
    end as contracts,
    count(DISTINCT(Address)) as Unique_Users_bridged_token,
    sum(total_amount) as total_amount
    from bridge
    where contracts is not null and contracts != 'WBTC'
    group by 1,2
    order by 1
    Run a query to Download Data