SELECT BLOCK_TIMESTAMP, SWAP_TO_AMOUNT / SWAP_FROM_AMOUNT AS price

FROM solana.core.fact_swaps

WHERE SWAP_FROM_MINT = 'AURYydfxJib1ZkTir1Jn1J9ECYUtjb6rKQVmtYaixWPP'

AND SWAP_TO_MINT = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'

AND tx_id <> '5pDDppHqj5Fvsc4BvB5CJWqPi7dvPvoyuwf2R8SyDzgZ3Quqbqp6PNuywsG9iBWTSRDtYSZXGKbQ1ramiNs42hmX'

AND SUCCEEDED = TRUE

ORDER BY 1

),

aurory AS (

SELECT MINT FROM solana.core.dim_nft_metadata

WHERE CONTRACT_NAME = 'Aurory'

SELECT date_trunc(DAY, s.BLOCK_TIMESTAMP::DATE + 1) AS DAY, COUNT(DISTINCT tx_id) AS "Number of Sales", ROUND(AVG(price), 2) AS price

FROM solana.core.fact_nft_sales s

INNER JOIN price p

ON p.BLOCK_TIMESTAMP::DATE = s.BLOCK_TIMESTAMP::DATE

WHERE MINT IN (SELECT MINT FROM aurory)

GROUP BY 1

ORDER BY 1 DESC