SELECT --*
date_trunc('day', block_timestamp) as day,
median(swap_to_amount / swap_from_amount) as DUST_price
FROM solana.core.fact_swaps
WHERE swap_from_mint LIKE 'DUSTawucrTsGU8hcqRdHDCbuYhCPADMLM2VcCb8VnFnQ'
AND swap_to_mint LIKE 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
AND NOT SWAP_FROM_AMOUNT = 0
GROUP BY 1
--LIMIT 100