with purchasert as (

select

block_timestamp,

purchaser,

mint,

sales_amount,

marketplace,

tx_id,

rank() over(partition by mint order by block_timestamp) as nft_sub_id

from solana.nft.fact_nft_sales

where purchaser='{{trader}}'

and succeeded),

sellert as (

select

block_timestamp,

Seller,

mint,

sales_amount,

marketplace,

tx_id,

rank() over(PARTITION BY mint ORDER BY block_timestamp) as nft_sub_id

from solana.nft.fact_nft_sales

where Seller='{{trader}}'

and succeeded),

finalt as (

select

p.block_timestamp as buy_date,

s.block_timestamp as sell_date,

p.mint as mint,

p.nft_sub_id as nft_sub_id,

purchaser,

s.sales_amount - p.sales_amount as net_profit,

DATEDIFF(hour, p.block_timestamp, s.block_timestamp ) as trade_time,