sarathcontratually obligated
    Updated 2022-03-09
    with data1 as (SELECT date(block_timestamp) as date1,tx_id,msg_value:sender as sender,msg_value:execute_msg:send:contract as contract from terra.msgs where msg_type='wasm/MsgExecuteContract'
    and contract is not null),
    data2 as (
    SELECT address,address_name,label from terra.labels
    ),
    data3 as(
    SELECT * from data1 join data2 on data1.contract=data2.address
    ),
    data4 as (
    SELECT contract,address,address_name,label,count(tx_id) from data3
    group by 1,2,3,4
    order by count(tx_id) desc
    )
    SELECT * from data4
    LIMIT 20

    -- msg_value:execute_msg:send:contract
    Run a query to Download Data