rajsTerra 2.0 New and Active Contracts
    Updated 2022-12-21
    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