WITH miners as (

SELECT

DISTINCT miner

FROM ethereum.core.fact_blocks

WHERE block_timestamp < '2022-09-16'

--GROUP BY 1,2

SELECT

date_trunc('day', block_timestamp) as day,

sum(AMOUNT_IN_USD),

COUNT(DISTINCT tx_hash),

COUNT(DISTINCT origin_from_address)

FROM ethereum.core.ez_dex_swaps

WHERE origin_from_address in (SELECT * from miners)

AND token_in LIKE '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'

AND block_timestamp >= '2022-09-01'

GROUP BY 1