SELECT date_day AS date

FROM crosschain.core.dim_dates

WHERE date_day >= CURRENT_DATE - 365 AND date_day < CURRENT_DATE

),

depositors AS (

SELECT d.date, on_behalf_of AS depositor, sum(

CASE

WHEN action = 'deposit' THEN amount

WHEN action = 'withdraw' THEN -amount

END

) / POW(10, 6) AS net_supplied

FROM dates d

JOIN osmosis.mars.ez_redbank_actions a

ON block_timestamp <= d.date

WHERE a.currency = 'ibc/C140AFD542AE77BD7DCC83F13FDD8C5E5BB8C4929785E6EC2F4C636F98F17901'

GROUP BY d.date, depositor

SELECT d.date, count(DISTINCT depositor) AS depositors

FROM dates d

JOIN depositors dep ON d.date = dep.date

WHERE net_supplied > 0.01

GROUP BY d.date