Query editor
SELECTSUM(CAST(t.value AS DOUBLE) / 1e18 * p.price) AS total_revenue_usd,COUNT(*) AS total_transactionsFROM base.traces tLEFT JOIN prices.day pON p.symbol = 'WETH'AND p.blockchain = 'ethereum'AND p.timestamp = date_trunc('day', t.block_time)WHERE t."to" = 0x7500a83df2af99b2755c47b6b321a8217d876a85AND t.value > UINT256 '0'AND t.block_time >= TIMESTAMP '2025-02-01'AND t.success = trueAND t.tx_success = trueAND (CAST(t.value AS DOUBLE) / 1e18 * p.price) <= 0.5