--date_trunc('day', BLOCK_TIMESTAMP) AS DATE,

--AVG(VALUE)/1e18 as AVG_TX_VALUE,

--count(VALUE) as TXN_COUNT

--AVG(GAS) as AVG_GAS,

--AVG(GAS_PRICE)/1e18 as AVG_GAS_PRICE,

--count(distinct FROM_ADDRESS) as unique_addr,

--AVG(NONCE) as AVG_NONCE

SELECT

date_trunc('day', BLOCK_TIMESTAMP) AS DATE,

count(tx_hash) as SWAPS,

count(distinct from_address) as SWAPPERS

FROM flipside_prod_db.mdao_harmony.swaps

GROUP BY DATE

ORDER BY DATE ASC