Query editor
with eth_price as (select pricefrom(selectprice,ROW_NUMBER() OVER (PARTITION BY contract_address ORDER BY minute DESC) AS indexfrom prices.usdwhere symbol = 'ETH') tmpwhere index = 1)selectcount(distinct "from") as total_user,sum(value/1e18) as total_amount,(select sum(amount) from query_3288585) as total_usdc_amount,now()-min(block_time) as after_deployed,sum(value/1e18) * (select avg(price) from eth_price) + (select sum(amount) from query_3288585) as total_amount_usdfrom ethereum.transactionswhere to = 0xdAf1695c41327b61B9b9965Ac6A5843A3198cf07and success