avg (swap_to_amount/swap_from_amount) as SOLprice

from solana.fact_swaps

where swap_from_mint = 'So11111111111111111111111111111111111111112'

and swap_to_mint in ('EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v','Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB')

and swap_to_amount > 0

and swap_from_amount > 0

and succeeded = 'TRUE'

group by 1

)

select date_trunc('day', block_timestamp) as day,

count (distinct tx_id) as trxs,

count (distinct purchaser) as Buyers,

count (distinct seller) as Sellers,

sum (sales_amount) as volume_sol,

sum (sales_amount*Solprice) as volume_usd,

avg (sales_amount) as Average_SOL_Volume

from solana.core.fact_nft_sales t1 join price t2 on t1.block_timestamp::date = t2.day

where t1.succeeded = 'TRUE'

and marketplace = 'hadeswap'

group by 1