-- Tarik - revised from query by dauclari-689rph https://app.flipsidecrypto.com/dashboard/terra-37-mirror-volume-and-tvl-qnfwvX
select date(m.block_timestamp) date,
l1.label as contract,
sum(msg_value:execute_msg:send:amount) staked
from terra.msgs m
inner join terra.labels l1 on l1.address = m.msg_value:execute_msg:send:contract
where msg_value:execute_msg IS NOT NULL
and block_timestamp >= CAST('2021-01-01' as Date)
and m.msg_value:execute_msg:send:msg:stake_voting_tokens is not null
-- and l1.label = 'mirror'
group by 1, 2
order by date asc