-- forked from forgash / Terra - Unique Wallets Participating in Staking Events [Flash119] @ https://flipsidecrypto.xyz/forgash/q/CMdUCUYEVJgF/terra-unique-wallets-participating-in-staking-events-flash119]
SELECT
date_trunc('day', block_timestamp) as date,
CASE
WHEN msg_type = 'distribution/MsgWithdrawDelegatorReward' THEN 'distribution/MsgWithdrawDelegationReward' -- label changes on 10/1 idk why
ELSE msg_type
END AS msg_type,
count(distinct msg_value:delegator_address) as unique_wallets
FROM terra.classic.fact_messages
WHERE msg_value:delegator_address IS NOT NULL
-- AND block_timestamp > CURRENT_DATE - 30
AND msg_module != 'oracle'
AND msg_module != 'core'
GROUP BY 1,2
ORDER BY 1,2