amelia-leeUntitled Query
    Updated 2022-08-01
    select origin_from_address, count(distinct tx_hash) as bridge_count, CASE
    when event_name='LockedEther' THEN 'ETH'
    when event_name='LockedERC20' THEN 'ERC20'
    end as asset
    from ethereum.core.fact_event_logs
    where ORIGIN_TO_ADDRESS='0xa0c68c638235ee32657e8f720a23cec1bfc77c77' and
    (event_name='LockedEther' or event_name='LockedERC20')
    group by 1,3
    order by 2 DESC
    limit 10



    --Emanoel91

    Run a query to Download Data