-- forked from travernorm_messari / axelar_address_daily @ https://flipsidecrypto.xyz/travernorm_messari/q/RnpUYrqWP78p/axelar_address_daily
with transactions AS (
select date_trunc('day', block_timestamp) as day, * from axelar.core.fact_transactions
)
select day, count(distinct(tx_from)) as addresses
from transactions
where tx_succeeded
group by 1
order by 1 desc