--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,

SUM(TX_COUNT) as TXN_COUNT,

SUM(GAS_USED) as GAS_USED_BLOCKS,

count(DISTINCT block_hash) as BLOCKS,

min(BLOCK_ID) as FIRST_BLOCK

FROM flipside_prod_db.mdao_harmony.blocks

GROUP BY DATE

ORDER BY DATE ASC