select

sender

,min(block_timestamp)::date as min_date

from axelar.defi.ez_bridge_squid

group by 1

order by 1

select

min_date as date

,count(DISTINCT sender) as "New Users"

,(select count(DISTINCT tx_hash) from axelar.defi.ez_bridge_squid where block_timestamp::date = min_date) as tx_count

,tx_count/"New Users" as "Transaction to user ratio"

from lst_all

where min_date>=current_date-30

group by 1

order by 1