, count (distinct tx_signer) AS active_addresses

FROM near.core.fact_transactions

WHERE 1=1

and tx_receiver = ('v2.ref-finance.near')

AND date > CURRENT_DATE - interval ' 1 month'

-- AND chain_name = 'avalanche_mainnet'

GROUP BY date

ORDER BY date desc