Query editor
with evm_token_transfer_records as (select 'Inflow' as ttype,cast(value as uint256) as value ,lower('0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2') as contract_address ,'ethereum' as chain, "from",block_timefrom ethereum.transactionswhere date_trunc('day', block_time) >= date '2023-01-01'and cast("to" as varchar) = lower('0x4E5B2e1dc63F6b91cb6Cd759936495434C7e972F')and "from" in ( select address from labels.all where category = 'institution')union allselect 'Inflow' as ttype,value ,cast(contract_address as varchar) as contract_address ,'ethereum' as chain, "from",evt_block_time as block_timefrom erc20_ethereum.evt_Transferwhere date_trunc('day', evt_block_time) >= date '2023-01-01'and cast("to" as varchar) = lower('0x4E5B2e1dc63F6b91cb6Cd759936495434C7e972F')and "from" in ( select address from labels.all where category = 'institution' )), evm_cash_flow as (select r.*,case when u.symbol = 'WETH' then 'ETH'when u.symbol = 'WBNB' then 'BNB'when u.symbol = 'WMATIC' then 'MATIC'else u.symbol end as transferred_token,(r.value / pow(10, u.decimals) * u.price) as usd_valuefrom evm_token_transfer_records r left join prices.usd u on cast(r.chain as varchar) = cast(u.blockchain as varchar) and date_trunc('minute', block_time) = u.minute and r.contract_address = cast(u.contract_address as varchar))select date_trunc('day', block_time) as dt, split_part(l.name, ' ', 1) as source, sum(usd_value) as usd_valuefrom evm_cash_flow f left join ( select * from labels.all where category = 'institution' ) l on f."from" = l.addressgroup by date_trunc('day', block_time), split_part(l.name, ' ', 1)order by 1