solana.core.fact_swaps

where

SWAP_FROM_MINT='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' AND SWAP_TO_MINT='So11111111111111111111111111111111111111112'

group by 2),

t2 as

(select SELLER as user ,sum(SALES_AMOUNT) as sol_number , date_trunc('day',BLOCK_TIMESTAMP) as date from solana.core.fact_nft_sales

group by 1,3)

union all

(select PURCHASER as user ,sum(SALES_AMOUNT) as sol_number , date_trunc('day',BLOCK_TIMESTAMP) as date from solana.core.fact_nft_sales

group by 1,3)),

t3 as

(select USER,sum(SOL_NUMBER) as SOL_NUMBER , date from t2

group by 1,3 ),

t4 as

(select USER,sum(SOL_NUMBER*SOL_PRISE) as usd_volume from t3 a left join t1 b on a.date=b.date

where SOL_NUMBER is not null

group by 1

order by 2 desc)

select sum(usd_volume) as "Total volume of transaction of Solana" from t4