WITH miners AS (
SELECT miner, COUNT(HASH) AS total_mines
FROM ethereum.core.fact_blocks
GROUP BY 1
)
SELECT
COUNT(DISTINCT tx_hash) AS number_of_sales,
COUNT(DISTINCT origin_from_address) AS number_of_users,
SUM(amount_in) AS total_amount,
SUM(amount_in_usd) AS total_amount_usd
FROM ethereum.core.ez_dex_swaps
WHERE symbol_in = 'WETH'
AND block_number >= '15537351'
AND block_timestamp::DATE >= '2022-09-01'