HadisehMost bridged assets
Updated 2022-06-19
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
›
⌄
with hop as ( select tx_hash
from ethereum_core.fact_event_logs
where block_timestamp >= '2022-01-20' and event_name = 'TransferSentToL2'
and contract_address in ( '0x22b1cbb8d98a01a3b71d034bb899775a76eb1cc2' , '0x3d4cc8a61c7528fd86c55cfe061a78dcba48edd1' ,
'0x3666f603cc164936c1b87e207f36beba4ac5f18a', '0x3e4a3a4796d16c0cd582c382691998f7c06420b6', '0xb8901acb165ed027e32754e0ffe830802919727f') and TX_STATUS = 'SUCCESS' and block_timestamp::date >= '2022-01-20'
group by 1
order by 1)
,
erc_20 as ( select trunc(block_timestamp, 'day') as date , symbol , amount_usd, from_address
from ethereum.core.ez_token_transfers
where tx_hash in ( select tx_hash from hop) and origin_from_address not in ( '0x305933e09871d4043b5036e09af794facb3f6170', '0xa6a688f107851131f0e1dce493ebbebfaf99203e',
'0xd8781ca9163e9f132a4d8392332e64115688013a','0x15ec4512516d980090050fe101de21832c8edfee', '0x710bda329b2a6224e4b44833de30f38e7f81d564')
)
,
eth as ( select trunc(block_timestamp, 'day') as date , 'ETH' as symbol , amount_usd, ETH_FROM_ADDRESS
from ethereum.core.ez_eth_transfers
where tx_hash in ( select tx_hash from hop) and origin_from_address not in ( '0x305933e09871d4043b5036e09af794facb3f6170', '0xa6a688f107851131f0e1dce493ebbebfaf99203e',
'0xd8781ca9163e9f132a4d8392332e64115688013a','0x15ec4512516d980090050fe101de21832c8edfee', '0x710bda329b2a6224e4b44833de30f38e7f81d564')
)
,
result as ( select date, symbol , amount_usd, from_address
from erc_20
UNION
select date , symbol , amount_usd, ETH_FROM_ADDRESS
from eth
)
select symbol as token, sum (amount_usd) as total_volume, count(DISTINCT(from_address)) as total_user
from result
where token in ( 'USDC', 'USDT', 'MATIC', 'WETH', 'ETH', 'DAI')
group by 1
Run a query to Download Data