rajsTerra 2.0 New and Active Contracts
Updated 2022-12-21Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT
count(distinct case when message_type = '/cosmwasm.wasm.v1.MsgExecuteContract' then message_value:contract end) as active_contracts,
count(distinct case when message_type = '/cosmwasm.wasm.v1.MsgExecuteContract' and
block_timestamp >= CURRENT_DATE - interval '24 hours' then message_value:contract end) as active_contracts_24_hrs,
count(distinct case when message_type = '/cosmwasm.wasm.v1.MsgExecuteContract' and
block_timestamp >= CURRENT_DATE - interval '30 days' then message_value:contract end) as active_contracts_30_days,
count(distinct case when message_type = '/cosmwasm.wasm.v1.MsgInstantiateContract' then attributes:instantiate:_contract_address end) as new_contracts,
count(distinct case when message_type = '/cosmwasm.wasm.v1.MsgInstantiateContract' and
block_timestamp >= CURRENT_DATE - interval '24 hours' then attributes:instantiate:_contract_address end) as new_contracts_24_hrs,
count(distinct case when message_type = '/cosmwasm.wasm.v1.MsgInstantiateContract' and
block_timestamp >= CURRENT_DATE - interval '30 days' then attributes:instantiate:_contract_address end) as new_contracts_30_days
from terra.core.ez_messages
Run a query to Download Data