nitsNew Users Daily on APOLLO
    Updated 2022-02-05
    select date(first_use) as day, count(DISTINCT sender) as unique_senders from
    (select sender, min(block_timestamp) as first_use from (select *, msg_value:sender as sender, msg_value:execute_msg:transfer:recipient as receiver , msg_value:execute_msgtransfer:amount as amt
    from terra.msgs
    where msg_value:contract = 'terra100yeqvww74h4yaejj6h733thgcafdaukjtw397')
    GROUP by 1 )
    where day > CURRENT_DATE -90
    GROUP by 1
    ORDER BY 1
    LIMIT 100