mmdrezaTop holders
Updated 2024-12-31
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with tab1 AS (
select
date_trunc('day', block_timestamp) as date,
nft_from_address as holder,
-SUM(CAST(1 as DOUBLE)) as token
from
ethereum.nft.ez_nft_transfers
where
nft_address = lower('0x74b6229ec051cb31ec4072305Bd203F16406c387')
group
by
1,2
union
select
date_trunc('day', block_timestamp) as date,
nft_to_address as holder,
SUM(CAST(1 as DOUBLE)) as token
from
ethereum.nft.ez_nft_transfers
where
nft_address = lower('0x74b6229ec051cb31ec4072305Bd203F16406c387')
group
by
1,2
)
SELECT
holder,
SUM(token) AS amount
from tab1
where
holder != '0x000000000000000000000000000000000000dead'
group by 1
order by 2 desc
QueryRunArchived: QueryRun has been archived