sarathcontratually obligated
Updated 2022-03-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
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