COUNT (DISTINCT TX_HASH) AS donations,

COUNT (DISTINCT DONOR_ADDRESS) AS donators,

SUM (ETH_AMOUNT) AS eth_donated,

SUM (ETH_AMOUNT_USD) AS usd_donated,

MIN (ETH_AMOUNT_USD) AS min_usd_donated,

AVG (ETH_AMOUNT_USD) AS avg_usd_donated,

MAX (ETH_AMOUNT_USD) AS max_usd_donated,

COUNT (DISTINCT NAME) AS services

FROM crosschain.olas.ez_service_donations

WHERE BLOCK_TIMESTAMP::date>='2024-01-01'