ethereum.core.ez_dex_swaps.EVENT_NAME,

ethereum.core.ez_dex_swaps.PLATFORM,

ethereum.core.ez_dex_swaps.TX_HASH,

ethereum.core.ez_dex_swaps.BLOCK_TIMESTAMP,

ethereum.core.ez_dex_swaps.SYMBOL_IN,

ethereum.core.ez_dex_swaps.SYMBOL_OUT,

ethereum.core.ez_dex_swaps.AMOUNT_IN,

--AMOUNT_IN_USD,

ethereum.core.ez_dex_swaps.AMOUNT_OUT,

ethereum.core.ez_dex_swaps.AMOUNT_OUT_USD,

ethereum.core.ez_dex_swaps.AMOUNT_IN / ethereum.core.ez_dex_swaps.AMOUNT_OUT AS "Token Price",

ethereum.core.fact_transactions.*

FROM ethereum.core.ez_dex_swaps

INNER JOIN ethereum.core.fact_transactions ON ethereum.core.ez_dex_swaps.TX_HASH = ethereum.core.fact_transactions.TX_HASH

WHERE ethereum.core.ez_dex_swaps.SYMBOL_IN = 'USDC'

AND ethereum.core.ez_dex_swaps.SYMBOL_OUT != ''

AND ethereum.core.ez_dex_swaps.AMOUNT_OUT_USD > 0

LIMIT 10