AlishBridge Users (Hop Protocol)
Updated 2022-06-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
›
⌄
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