SELECT date(a.block_timestamp) AS date,

AMOUNT_USD,

WHEN project_name IN ('pangolin', 'pangolin v2') THEN 'pangolin'

ELSE project_name

END AS project_name

FROM avalanche.core.ez_token_transfers a

JOIN axelar.defi.ez_bridge_squid b ON a.tx_hash = b.tx_hash

JOIN crosschain.core.dim_labels c ON a.to_address = c.address

WHERE source_chain = 'avalanche'

AND label_type != 'cex'

SELECT project_name, SUM(AMOUNT_USD) AS volume

FROM avalanche

WHERE project_name NOT IN ('burn address', 'squid', 'axelar', 'burn_address')

AND date >= '{{Start_Date}}' AND date <= '{{End_Date}}'

GROUP BY 1;