NuveveCryptoArchivedDaily Active Users
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with daily as (
select
block_timestamp::date as date,
symbol,
count(distinct from_address) as active_users
from ethereum.core.ez_token_transfers
where contract_address = '0x5f98805a4e8be255a32880fdec7f6728c6568ba0' -- lusd
or contract_address = '0x6dea81c8171d0ba574754ef6f8b412f2ed88c54d' -- lusd
group by date , symbol
)
select
date,
symbol,
active_users
from daily
where date >= current_date - 90
Run a query to Download Data