Amy-G0sBO5assets have been bridged the most
Updated 2022-06-22
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
27
28
29
30
31
32
33
34
35
36
›
⌄
(select
date_trunc('day', block_timestamp::date) as "Date",
case
when ORIGIN_TO_ADDRESS = '0x3666f603cc164936c1b87e207f36beba4ac5f18a' then 'Hop Protocol: USDC Bridge'
when ORIGIN_TO_ADDRESS = '0x3e4a3a4796d16c0cd582c382691998f7c06420b6' then 'Hop Protocol: USDT Bridge'
when ORIGIN_TO_ADDRESS = '0x22b1cbb8d98a01a3b71d034bb899775a76eb1cc2' then 'Hop Protocol: MATIC Bridge'
else 'Hop Protocol: DAI Bridge' end as "Bridge",
count(distinct ORIGIN_FROM_ADDRESS) as "Daily Number of Unique Wallets",
sum(amount) as "Daily Amount Bridged",
sum(amount_usd) as "Daily Amount Bridged (USD Scale)"
from ethereum.core.ez_token_transfers
where ORIGIN_TO_ADDRESS in (
'0x22b1cbb8d98a01a3b71d034bb899775a76eb1cc2',
'0x3e4a3a4796d16c0cd582c382691998f7c06420b6',
'0x3666f603cc164936c1b87e207f36beba4ac5f18a',
'0x3d4cc8a61c7528fd86c55cfe061a78dcba48edd1')
and block_Timestamp >= CURRENT_DATE - 180
group by 1 , 2
order by 1)
union all
(select
date_trunc('day', block_timestamp::date) as "Date",
case
when ORIGIN_TO_ADDRESS = '0xb8901acb165ed027e32754e0ffe830802919727f' then 'Hop Protocol: ETH Bridge'
end as "Bridge",
count(distinct ORIGIN_FROM_ADDRESS) as "Daily Number of Unique Wallets",
sum(amount) as "Daily Amount Bridged",
sum(amount_usd) as "Daily Amount Bridged (USD Scale)"
from ethereum.core.ez_eth_transfers
where ORIGIN_TO_ADDRESS in ('0xb8901acb165ed027e32754e0ffe830802919727f')
and IDENTIFIER ='CALL_ORIGIN'
and block_Timestamp >= CURRENT_DATE - 180
group by 1 , 2
order by 1)
Run a query to Download Data