amelia-leeUntitled Query
Updated 2022-08-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
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