PapasotTerra new users (last 90 days)
    Updated 2022-03-10
    with new_user as (

    SELECT
    msg_value:sender::string as sender,
    min(block_timestamp) as First_transaction
    FROM terra.msgs
    GROUP BY 1
    ORDER BY 2
    )

    select
    msg_value:sender::string as senders,
    count(tx_id)
    FROM
    terra.msgs m
    RIGHT JOIN new_user n ON m.msg_value:sender::string = n.sender
    where First_transaction >= CURRENT_DATE - 90
    group by 1
    order by 2 DESC

    Run a query to Download Data