adambalaUntitled Query
Updated 2022-09-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
select--date ,
count(distinct holders) as holder , count(distinct nft) as nft --, sum(holder) over (order by date) as ee
from
(select --BLOCK_TIMESTAMP::date as date ,
USER_ADDRESS as holders , CURRENT_BAL_UNADJ as nft
from
ethereum.core.ez_balance_deltas
where CONTRACT_ADDRESS=lower('0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d') and
BLOCK_TIMESTAMP in (select max(BLOCK_TIMESTAMP) from ethereum.core.ez_balance_deltas))
--group by 1
Run a query to Download Data