nitsNew Users Daily on APOLLO
Updated 2022-02-05
9
1
2
3
4
5
6
7
8
9
›
⌄
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