Query editor
WITH raw AS (SELECTblock_date AS date_,CONCAT('0x', SUBSTRING(TO_HEX(topic1), 25)) AS buyer_address,VARBINARY_TO_uint256(VARBINARY_LTRIM(topic2)) / 1e18 AS amountFROM kaia.logsWHEREcontract_address = 0x13af3a8f1428ddc20be8bd47821f69779e24f80cand block_date >= CAST('2025-01-10' AS date)),aa AS (SELECTdate_,count(distinct buyer_address) as traderCount,sum(amount) as tradingVolume,count(amount) as tradingCountFROM rawGROUP BY date_),bb AS (SELECTdate_,count(buyer_address) as newTradersFROM ( select distinct buyer_address as buyer_address, min(date_) as date_ from raw group by 1)GROUP BY 1)SELECTaa.date_,bb.newTraders,SUM(newTraders) OVER (ORDER BY aa.date_ ASC) AS cumulativeTraders,traderCount as dailyTraders,tradingVolume as dailyVolume,SUM(tradingVolume) OVER (ORDER BY aa.date_ ASC) AS cumulativeVolume,tradingCount as dailyTrades,SUM(tradingCount) OVER (ORDER BY aa.date_ ASC) AS cumulativeTradesFROM aa LEFT JOIN bb on aa.date_ = bb.date_ORDER BY aa.date_ DESC;