date_trunc('day', block_timestamp) as date,

min(swap_from_amount/swap_to_amount) as aurory_price -- to get the average price for swaps

FROM solana.core.fact_swaps

WHERE swap_to_mint = 'AURYydfxJib1ZkTir1Jn1J9ECYUtjb6rKQVmtYaixWPP' -- AURY token

AND succeeded = 'TRUE'

AND swap_from_amount > 0 AND swap_to_amount > 0

AND swap_from_mint IN

('Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB') -- USDT token (has the most accurate volume, as compared to USDC)

GROUP BY date