Abolfazl_771025Untitled Query
Updated 2022-08-28Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
*
--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 "Total Number of Unique Wallets",
--sum(RAW_AMOUNT/1e18) as "Total Amount Bridged"
--sum(amount_usd) as "Total Amount Bridged (USD Scale)"
from arbitrum.core.fact_token_transfers
where ORIGIN_to_ADDRESS = '0x0ce6c85cF43553DE10FC56cecA0aef6Ff0DD444d'
limit 10
Run a query to Download Data