HadisehTotal daily unique users
Updated 2022-06-17
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select date(block_timestamp) as day ,
count(DISTINCT(ORIGIN_FROM_ADDRESS)) as users ,
count(DISTINCT(TX_HASH)) as deposits,
sum(event_inputs:amount/pow(10,18)) as amount
from ethereum.core.fact_event_logs
where event_inputs:tokenId::string = '0' and EVENT_NAME = 'Deposit'
and contract_address = lower('0xabea9132b05a70803a4e85094fd0e1800777fbef')
and block_timestamp::date >= CURRENT_DATE - 60
group by 1
Run a query to Download Data