mo115Whale Sellers
Updated 2022-07-19
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
›
⌄
with A as( select date_trunc('day',BLOCK_TIMESTAMP) as date, SELLER as SELLER,
count(TX_ID) as NFTs,
'FLOW' as network
from flow.core.fact_nft_sales
where date > CURRENT_DATE - 60
group by 1,2
having NFTs>=100
union
select date_trunc('day',BLOCK_TIMESTAMP) as date, SELLER as SELLER,
count(TX_ID) as NFTs,
'SOLANA' as network
from solana.core.fact_nft_sales
where date > CURRENT_DATE - 60
group by 1,2
having NFTs>=100
union
select date_trunc('day',BLOCK_TIMESTAMP) as date,SELLER_ADDRESS as SELLER,
count(TX_HASH) as NFTs,
'ETHEREUM' as network
from ethereum.core.ez_nft_sales
where date > CURRENT_DATE - 60
group by 1,2
having NFTs>=100
)
select date, count(SELLER) as whale_SELLERs, sum(nfts)as nfts, network
from A
group by 1, 4
Run a query to Download Data