LordkingP11
Updated 2022-09-18Copy 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
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH
a as
(select
BLOCK_TIMESTAMP,
TX_HASH ,
SELLER_ADDRESS as seller ,
BUYER_ADDRESS as buyer ,
NFT_ADDRESS as CONTRACT_ADDRESS,
TOKENID as token_id ,
CURRENCY_SYMBOL ,
PRICE as volume
from optimism.core.ez_nft_sales
where EVENT_TYPE='sale' and PLATFORM_NAME =('quixotic') ),
b as
(select
BLOCK_TIMESTAMP,
TX_HASH ,
SELLER_ADDRESS as seller ,
BUYER_ADDRESS as buyer ,
NFT_ADDRESS as CONTRACT_ADDRESS,
TOKENID as token_id ,
CURRENCY_SYMBOL ,
PRICE as volume
from optimism.core.ez_nft_sales
where EVENT_TYPE='sale' and PLATFORM_NAME =('quixotic') ),
c as (
select t1.buyer,
sum (t2.volume - t1.volume) as ETH_Profit
from a t1 join b t2 on t1.buyer = t2.seller
group by 1
order by 2 DESC
)
Run a query to Download Data