NuveveCryptoArchivedHolders Over 90 days
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with blockly as (
select
block_timestamp::date as date,
contract_address,
count(distinct user_address) as holders
from ethereum.core.fact_token_balances
where contract_address = '0x5f98805a4e8be255a32880fdec7f6728c6568ba0' -- lusd
or contract_address = '0x6dea81c8171d0ba574754ef6f8b412f2ed88c54d' -- lqty
group by block_timestamp, contract_address
)
select
date,
contracts.symbol as token,
holders as holders
from blockly
inner join ethereum.core.dim_contracts as contracts on blockly.contract_address = contracts.address
where blockly.date >= current_date - 90
Run a query to Download Data