PS0G1The amount of daily bridge transactions from Ethereum
Updated 2022-09-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
--credit mlh
select date_trunc('day', block_timestamp) as daily,
count (DISTINCT tx_hash) as trxs,
count (DISTINCT ORIGIN_FROM_ADDRESS) as users,
sum (amount_usd) as USD_volume,
case when contract_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' then 'USDC'
when contract_address = '0xdac17f958d2ee523a2206206994597c13d831ec7' then 'USDT'
end as coin
from ethereum.core.ez_token_transfers
where to_address ='0x99c9fc46f92e8a1c0dec1b1747d010903e884be1'
group by 1, 5
HAVING coin is not NULL
UNION
select date_trunc('day', block_timestamp) as daily,
count (DISTINCT tx_hash) as trxs,
count (DISTINCT ORIGIN_FROM_ADDRESS) as users,
sum (amount_usd) as USD_volume,
'ETH' as coin
from ethereum.core.ez_eth_transfers
where eth_to_address = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1'
group by 1, 5
Run a query to Download Data