select

tx_hash,

count(distinct origin_from_address) as depositors_count,

sum(amount_usd) as amount_usd,

block_timestamp::date as TIME

from ethereum.core.ez_token_transfers

where origin_to_address in ('0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9', '0x135896de8421be2ec868e0b811006171d9df802a')

and to_address = '0xffc97d72e13e01096502cb8eb52dee56f74dad7b'

and contract_address = '0x7fc66500c84a76ad7e9c93437bfc5ac33e2ddae9'

and block_timestamp > CURRENT_DATE -365

group by TIME, tx_hash),

withdraws as (

select

tx_hash,

count(distinct origin_from_address) as Withdrawers_count,

sum(amount_usd) as amount_usd,

block_timestamp::date as TIME

from ethereum.core.ez_token_transfers

where origin_to_address in ('0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9', '0x135896de8421be2ec868e0b811006171d9df802a')

and to_address = '0x0000000000000000000000000000000000000000'

and contract_address = '0xffc97d72e13e01096502cb8eb52dee56f74dad7b'

and block_timestamp > CURRENT_DATE -365

group by TIME, tx_hash

select (d.amount_usd - w.amount_usd) as daily_sum, sum(daily_sum) over (order by d.TIME) as cum_sum,

d.amount_usd as deposit_usd, w.amount_usd as withdrawn_usd, d.TIME

from deposits d inner join withdraws w on w.TIME = d.TIME