flipside

    Terra Active Contract Senders Statistics
    rajsTerra Active Contract Senders Statistics
    Updated 2022-12-21
    SELECT
    count(distinct message_value:sender) as no_of_active_contract_senders,
    count(distinct case when block_timestamp >= CURRENT_DATE - interval '24 hours' then message_value:sender end) as no_of_active_contract_senders_24_hrs,
    count(distinct case when block_timestamp >= CURRENT_DATE - interval '30 days' then message_value:sender end) as no_of_active_contract_senders_30_days
    from terra.core.ez_messages
    where message_type = '/cosmwasm.wasm.v1.MsgInstantiateContract'

    Run a query to Download Data