Afonso_DiazUntitled Query
Updated 2023-01-22
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
with t as (
select
block_timestamp::date as day,
count(distinct to_address) as active_holders_count
from ethereum.core.fact_token_transfers
where contract_address = '0x92d6c1e31e14520e676a687f0a93788b716beff5'
and block_timestamp > current_date - 90
group by 1
)
select avg(active_holders_count) as average_active_holders_count
from t
Run a query to Download Data