SELECT

SUM(msg_value['coins'][0]['amount'] / POW(10,6)) as ANCH,

date_trunc('hour', block_timestamp) as h

FROM terra.msgs

--WHERE msg_value:contract = 'terra1sepfj7s0aeg5967uxnfk4thzlerrsktkpelm5s'

WHERE msg_value:execute_msg:deposit_stable is not null

AND block_timestamp > CURRENT_DATE - 14

GROUP BY 2

), mir_tlv as (

SELECT

date_trunc('hour', block_timestamp) as h,

SUM(msg_value:execute_msg:send:amount / POW(10,6)) as MIR

FROM terra.msgs

WHERE msg_value:contract like 'terra1hzh9vpxhsk8253se0vv5jj6etdvxu3nv8z07zu'

AND block_timestamp > CURRENT_DATE - 14

group by 1

SELECT * from mir_tlv left outer join anch_tlv on mir_tlv.h = anch_tlv.h