(with raw as ( select * , case when symbols = 'ETH' then 'WETH' else symbols end as symbol from (select *, replace(replace(TOKENs,'axl'),'st') symbols from (select *, iff (TOKEN_SYMBOL ilike '%.%',split(TOKEN_SYMBOL,'.')[1] ,TOKEN_SYMBOL) TOKENs from axelar.core.ez_satellite )) ) , p_t as (select date(HOUR) as days, symbol token , avg(PRICE) as price from ethereum.core.fact_hourly_token_prices group by 1,2) , base as ( select *, AMOUNT*price as amount_usd from raw inner join p_t on token = SYMBOL and BLOCK_TIMESTAMP::date = days) select case when amount_usd < 10 then 'under 10 $' when amount_usd >= 10 and amount_usd < 100 then '10-100 $' when amount_usd >= 100 and amount_usd < 1000 then '100-1000 $' when amount_usd >= 1000 and amount_usd < 10000 then '1k-10k $' when amount_usd >= 10000 and amount_usd < 100000 then '10k-100k $' when amount_usd >= 100000 then 'over 100k $' end as tier , count(distinct SENDER) as senders , count(distinct tx_hash) as txns, 'Satellite' as platform from base where BLOCK_TIMESTAMP between CURRENT_DATE - {{days_back}} and CURRENT_DATE-1 and amount_usd is not null group by 1) union all (with raw as ( select * , case when symbols = 'ETH' then 'WETH' else symbols end as symbol from (select *, replace(replace(TOKENs,'axl'),'st') symbols from (select *, iff (TOKEN_SYMBOL ilike '%.%',split(TOKEN_SYMBOL,'.')[1] ,TOKEN_SYMBOL) TOKENs from axelar.core.ez_Squid )) ) , p_t as (select date(HOUR) as days, symbol token , avg(PRICE) as price from ethereum.core.fact_hourly_token_prices group by 1,2) , base as ( select *, AMOUNT*price as amount_usd from raw inner join p_t on token = SYMBOL and BLOCK_TIMESTAMP::date = days) select case when amount_usd < 10 then 'under 10 $' when amount_usd >= 10 and amount_usd < 100 then '10-100 $' when amount_usd >= 100 and amount_usd < 1000 then '100-1000 $' when amount_usd >= 1000 and amount_usd < 10000 then '1k-10k $' when amount_usd >= 10000 and amount_usd < 100000 then '10k-100k $' when amount_usd >= 100000 then 'over 100k $' end as tier , count(distinct SENDER) as senders , count(distinct tx_hash) as txns, 'Squid' as platform from base where BLOCK_TIMESTAMP between CURRENT_DATE - {{days_back}} and CURRENT_DATE-1 and amount_usd is not null group by 1)

Axelar Bridges