select
date_trunc('hour',block_timestamp) as block_hour,
sum(msg_value:execute_msg:mint:amount) / pow(10,6) as amount, -- amount minted
'beth_bridge_ethereum' as from_group,
'beth_holders_terra' as to_group
from terra.msgs where block_timestamp > '2021-08-12'
and msg_value:sender = 'terra13yxhrk08qvdf5zdc9ss5mwsg5sf7zva9xrgwgc' -- beth minter contract
and msg_value:execute_msg:mint:amount IS NOT NULL
group by 1;