Pmisha-bmlMdxuser.growth.dex
Updated 2022-05-07
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
date_trunc('week',block_timestamp) as dt,
--RECIPIENT_LABEL_TYPE,
--RECIPIENT_LABEL_SUBTYPE,
RECIPIENT_LABEL,
--RECIPIENT_ADDRESS_NAME,
count(distinct sender) as senders,
sum(senders) over (partition by RECIPIENT_LABEL order by dt) as cum_senders
from terra.transfer_events
where block_timestamp>='2022-01-01'
and RECIPIENT_LABEL_TYPE in ('dex')
group by 1,2
Run a query to Download Data