with receive_axelar as ( select block_timestamp::date as date, tx_id, receiver, amount / pow (10,decimal) as Receive_Volume from axelar.core.fact_transfers where currency = 'uaxl' and transfer_type in ('AXELAR','IBC_TRANSFER_IN') ), send_axelar as ( select block_timestamp::date as date, tx_id, sender, amount / pow (10,decimal) as Send_Volume from axelar.core.fact_transfers where currency = 'uaxl' and transfer_type in ('AXELAR','IBC_TRANSFER_OUT') ), holder_daily_info as ( select t1.date, receiver as AXL_Holder, sum (Send_Volume) as Daily_Send_Volume, sum (Receive_Volume) as Daily_Receive_Volume from receive_axelar t1 join send_axelar t2 on t1.Date = t2.Date and t1.Receiver = t2.Sender group by 1,2 ), holder_balance_on_axelar as ( select AXL_Holder, ifnull (Daily_Receive_Volume, 0) as Daily_Receive_Volumes, ifnull (Daily_Send_Volume, 0) as Daily_Send_Volumes, Daily_Receive_Volumes - Daily_Send_Volumes as NET_AXL_Balance, sum (NET_AXL_Balance) over (partition by AXL_Holder order by date) as Balance from holder_daily_info ) , holder_balace_on_osmosis as ( select address, sum (balance/pow(10,decimal)) as Balance from osmosis.core.fact_daily_balances where currency = 'ibc/903A61A498756EA560B85A85132D3AEE21B5DEDD41213725D22ABF276EA6945E' and date = (select max (date) from osmosis.core.fact_daily_balances) group by 1 ) select 'Axelar' as chain, case when balance < 10 then 'c1: Less Than 10 $AXL' when balance >= 10 and balance < 1000 then 'c2: 10 - 1k $AXL' when balance >= 1000 and balance < 100000 then 'c3: 1K - 100K $AXL' when balance >= 100000 and balance < 1000000 then 'c4: 100K - 1M $AXL' when balance >= 1000000 and balance < 10000000 then 'c5: 1M - 10M $AXL' when balance >= 10000000 and balance < 100000000 then 'c6: 10M - 100M $AXL' else 'c7: More Than 100M $AXL' end as balance_type, count (distinct AXL_Holder) as holder_count from holder_balance_on_axelar where Balance > 0.001 group by 1 ,2 union ALL select 'Osmosis' as chain, case when balance < 10 then 'c1: Less Than 10 $AXL' when balance >= 10 and balance < 1000 then 'c2: 10 - 1k $AXL' when balance >= 1000 and balance < 100000 then 'c3: 1K - 100K $AXL' when balance >= 100000 and balance < 1000000 then 'c4: 100K - 1M $AXL' when balance >= 1000000 and balance < 10000000 then 'c5: 1M - 10M $AXL' when balance >= 10000000 and balance < 100000000 then 'c6: 10M - 100M $AXL' else 'c7: More Than 100M $AXL' end as balance_type, count (distinct address) as holder_count from holder_balace_on_osmosis where Balance > 0.001 group by 1 ,2

AXL Token Recap