from ethereum_core.fact_event_logs F

WHERE CONTRACT_NAME like '%KashiPairMediumRiskV%')

, wall as (

SELECT block_timestamp::date as daily, count(F.tx_hash) as number , sum(number) over (order by daily) as cumulative

FROM ethereum_core.fact_event_logs F , kashi K

where event_name = 'LogWithdraw'

and K.tx_hash = f.tx_hash

group by 1 )

,

bento as (

SELECT block_timestamp::date as daily, count(F.tx_hash) as number , sum(number) over (order by daily) as cumulative

FROM ethereum_core.fact_event_logs F , kashi K

where CONTRACT_NAME = 'BentoBoxV1'

and K.tx_hash = f.tx_hash

group by 1

SELECT B.daily , B.cumulative as Bentobox , w.cumulative as wallet

from bento B , wall w

where B.daily = W.daily