BLOCK_TIMESTAMP::date AS date,

SUM(TX_FEE) AS total_fee

FROM

base.core.fact_transactions

WHERE

TX_HASH IN (

SELECT TX_HASH FROM base.defi.ez_dex_swaps WHERE PLATFORM = 'alienbase'

)

GROUP BY 1

ORDER BY 1;