SELECT *

FROM avalanche.core.dim_labels

WHERE label_type = 'dex'

),

txs AS (

SELECT *

FROM avalanche.core.fact_event_logs

WHERE tx_status = 'SUCCESS'

),

volume_dexs AS (

SELECT

date(t.block_timestamp) AS date,

t.tx_hash AS tx_hash

FROM txs t

JOIN dexs d ON t.contract_address = d.address

SELECT

v.date AS "Date",

COUNT(DISTINCT v.tx_hash) AS "Transactions"

FROM volume_dexs v

GROUP BY 1

ORDER BY 1