date_trunc('day', BLOCK_TIMESTAMP) AS DATE,

AVG(ETH_VALUE)/1e18 as AVG_TX_VALUE,

count(ETH_VALUE) as TXN_COUNT,

AVG(GAS_USED) as AVG_GAS_USED,

AVG(GAS_PRICE)/1e18 as AVG_GAS_PRICE,

count(distinct FROM_ADDRESS) as unique_addr

FROM ethereum_core.fact_transactions

where DATE > '2021-01-01'

GROUP BY DATE

ORDER BY DATE ASC