mariyaTotal bridges
Updated 2022-09-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with ETHTable as (
select count (distinct tx_hash) as TX_Count,
count (distinct eth_from_address) as Users_Count,
sum (amount_usd) as USD_Volume,
sum (amount) as Volume
from ethereum.core.ez_eth_transfers
where eth_to_address = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1'),
TokenTable as (
select count (distinct tx_hash) as TX_Count,
count (distinct origin_from_address) as Users_Count,
sum (amount_usd) as USD_Volume,
sum (amount) as Volume
from ethereum.core.ez_token_transfers
where to_address = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1'
and contract_address = lower('0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48'))
select 'ETH' as type, *
from ethtable
union all
select 'USDC' as type, *
from tokentable
Run a query to Download Data