Query editor
witherc20 as (selecttime, sum(amount_usd) as amount_usdfrom (selectdate_trunc('day', evt_block_time) as time, token_address, sum(cast(amount_raw as double) / pow(10, coalesce(p.decimals, 18)) * p.price) as amount_usdfrom transfers_ethereum.erc20 trleft join prices.usd_latest pon p.contract_address = tr.token_addressand p.blockchain = 'ethereum'where wallet_address = 0x10c6b61DbF44a083Aec3780aCF769C77BE747E23group by 1,2)agroup by 1), eth as (selecttime, sum(amount) as amountfrom (selectdate_trunc('day', block_time) as time, sum(cast(value as double) / pow(10,18)) as amountfrom ethereum.traceswhere to = 0x10c6b61DbF44a083Aec3780aCF769C77BE747E23and successand (call_type not in ('delegatecall', 'callcode', 'staticcall') or call_type is null)group by 1union allselectdate_trunc('day', block_time) as time, sum(cast(value as double) / pow(10,18)) * (-1) as amountfrom ethereum.traceswhere "from" = 0x10c6b61DbF44a083Aec3780aCF769C77BE747E23and successand (call_type not in ('delegatecall', 'callcode', 'staticcall') or call_type is null)group by 1)agroup by 1), gas_cost as (selectdate_trunc('day',block_time) as time, sum(cast(tx_fee_native as double)) as gas_costfrom gas.feeswhere tx_sender = 0x10c6b61DbF44a083Aec3780aCF769C77BE747E23and blockchain = 'ethereum'group by 1), eth_gas_cost as (select