flipside

    art.2
    Pmisha-bmlMdxart.2
    Updated 2022-07-07
    SELECT
    DATE(block_timestamp) as date,
    count(distinct msg_value:sender::string) sender_address,
    count(distinct msg_value:contract) as no_protocols
    FROM terra.msgs
    WHERE tx_id is not null
    AND block_timestamp>= '2022-01-01'
    GROUP BY 1
    ORDER BY 1
    Run a query to Download Data