block_timestamp::date as date,

count(distinct(native_from_address)) as active_users

from flipside_prod_db.mdao_harmony.txs

where block_timestamp >= current_date - 30

group by date