thea[Blur] Daily Active User on Blur
Updated 2022-12-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
select block_date,
count(distinct wallet) as wallets
from (
select date_trunc('day', block_timestamp) as block_date,
seller_address as wallet
from ethereum.core.ez_nft_sales
where platform_name = 'blur'
union all
select date_trunc('day', block_timestamp) as block_date,
buyer_address as wallet
from ethereum.core.ez_nft_sales
where platform_name = 'blur'
)
group by 1
order by 1
Run a query to Download Data