boomer77anc gov staking
Updated 2022-02-10
9
1
2
3
4
5
›
⌄
select date_trunc('day', block_timestamp) as dt, sum(msg_value:execute_msg:send:amount/1e6) as stake_anc
from terra.msgs
where msg_value:sender::string in (select sender from anc) and msg_value:execute_msg:send:contract::string = 'terra1f32xyep306hhcxxxf7mlyh0ucggc00rm2s9da5'
and msg_value:contract::string = 'terra14z56l0fp2lsf86zy3hty2z47ezkhnthtr9yq76' and block_timestamp between '2022-01-01' and '2022-01-31'
group by 1