-- forked from Total Volume From Avax DEXs @ https://flipsidecrypto.xyz/edit/queries/656f37ea-25a5-47a9-b24a-cd3a2ec001b3

-- forked from 2023-04-29 10:16 AM @ https://flipsidecrypto.xyz/edit/queries/ea3beca4-ba34-4093-9d8b-cf575de5beae

platform AS DEX

, COUNT(DISTINCT tx_hash) AS VOLUME

FROM avalanche.core.ez_dex_swaps

WHERE 1=1

AND block_timestamp BETWEEN '{{Start_Date}} 00:00:00' AND '{{End_Date}} 00:00:00'

AND amount_in_usd::DECIMAL > 0

AND amount_out_usd::DECIMAL > 0

AND symbol_in IN (SELECT symbol FROM avalanche.core.fact_hourly_token_prices)

AND symbol_out IN (SELECT symbol FROM avalanche.core.fact_hourly_token_prices)

GROUP BY 1