SELECT
Date_trunc(day, block_timestamp) AS Day
,COUNT(TX_HASH) "Number Of Transactions"
,SUM(gas_used * gas_price)/1e9 as "Total Gas Used"
,AVG(gas_used * gas_price)/1e9 as "Average Gas Used Per Day"
FROM
ethereum.core.fact_transactions
WHERE
TX_HASH IN ( SELECT
DISTINCT TX_HASH
FROM
ethereum.defi.ez_dex_swaps
WHERE
BLOCK_TIMESTAMP >= CURRENT_DATE - INTERVAL '6 MONTHS'
AND PLATFORM LIKE '%uniswap%'
)
GROUP BY
1