mariyaTotal ETH 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 origin_from_address) as Users_Count,
sum (amount_usd) as USD_Volume,
sum (amount) as Volume
from ethereum.core.ez_eth_transfers
where origin_to_address = '0x25ace71c97b33cc4729cf772ae268934f7ab5fa1'),
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 origin_to_address = '0x25ace71c97b33cc4729cf772ae268934f7ab5fa1'
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