theericstoneTerra-to-Ethereum bETH Bridging
    Updated 2021-12-08
    select
    date_trunc('hour',block_timestamp) as block_hour,
    sum(msg_value:execute_msg:burn:amount) / pow(10,6) as amount, -- looking specifically at burns
    'beth_holders_terra' as from_group,
    'beth_bridge_terra' as to_group
    from terra.msgs where block_timestamp > '2021-09-21'
    and msg_value:contract = 'terra1dzhzukyezv0etz22ud940z7adyv7xgcjkahuun' -- beth token
    and msg_value:execute_msg:burn:amount IS NOT NULL
    group by 1;
    Run a query to Download Data