par_rnOlas
Updated 2024-11-21
9
1
2
3
4
5
6
7
8
9
›
⌄
SELECT date_trunc('month',BLOCK_TIMESTAMP) AS date,
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,
COUNT (DISTINCT NAME) AS services
FROM crosschain.olas.ez_service_donations
WHERE date>='2024-01-01'
GROUP BY date
QueryRunArchived: QueryRun has been archived