shadilTop 10 wallet addresses with the highest profits
Updated 2022-08-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
select top 10 table2.wallet_address,
round(sum(total_s-total_b), 0) as profit_total
from (select seller_address as wallet_address,
sum(price_usd) as total_s
from ethereum.core.ez_nft_sales ens join ethereum.core.dim_labels
on ens.nft_address = address
where ens.project_name ilike 'CRYPTOPUNKS%'
and ens.event_type in ('redeem', 'sale')
and ens.price_usd >= 0
group by wallet_address) as table1 join (select buyer_address as wallet_address,
sum(price_usd) as total_b
from ethereum.core.ez_nft_sales join ethereum.core.dim_labels
on nft_address = address
where project_name ilike 'CRYPTOPUNKS%'
and event_type in ('redeem', 'sale')
and price_usd >= 0
group by wallet_address) as table2
on table1.wallet_address = table2.wallet_address
group by table2.wallet_address
order by profit_total desc
Run a query to Download Data