contract_name='KashiPairMediumRiskV1' and event_name='LogWithdrawFees')

, SushiSwapTxId as (select tx_hash from ethereum.core.ez_dex_swaps where platform='sushiswap')

, Kashi_fee as (select sum(tx_fee) as fee,block_timestamp::date from ethereum.core.fact_transactions where tx_hash in (select tx_hash from KashiFeeTxId)

group by block_timestamp::date)

, Sushiplatform_swap_fee as (select sum(tx_fee) as fee,block_timestamp::date from ethereum.core.fact_transactions where tx_hash in (select tx_hash from SushiSwapTxId)

group by block_timestamp::date)

, SushiSwapSUSHI_fee as (select sum(tx_fee) as fee,block_timestamp::date from ethereum.core.fact_transactions where to_address='0x795065dcc9f64b5614c407a6efdc400da6221fb0'

group by block_timestamp::date)

, Sushimaker_fee as (select sum(tx_fee) as fee,block_timestamp::date from ethereum.core.fact_transactions where to_address='0x5ad6211cd3fde39a9cecb5df6f380b8263d1e277'

group by block_timestamp::date)

, Sushibar_fee as (select sum(tx_fee) as fee,block_timestamp::date from ethereum.core.fact_transactions where to_address='0x8798249c2e607446efb7ad49ec89dd1865ff4272'

group by block_timestamp::date)

select sum(fee) from Kashi_fee