ValiMohammadiTop 10
Updated 2022-12-03Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with selltable as (
select seller_address,
sum (price_usd) as Total_USD_Volume
from ethereum.core.ez_nft_sales
where nft_address = '0xb2a3fe3d512c1e0102d85f89caab403b94b7d0de'
and price_usd > 0
group by 1),
buytable as (
select buyer_address,
sum (price_usd) as Total_USD_Volume
from ethereum.core.ez_nft_sales
where nft_address = '0xb2a3fe3d512c1e0102d85f89caab403b94b7d0de'
and price_usd > 0
group by 1)
select t1.seller_address,
sum (t1.total_usd_volume - t2.total_usd_volume) as Profit
from selltable t1 join buytable t2 on t1.seller_address = t2.buyer_address
group by 1
order by 2 DESC
limit 10
Run a query to Download Data