select

tx_hash

from base.core.fact_transactions

where to_address LIKE lower('0xF66DeA7b3e897cD44A5a231c61B6B4423d613259')

and origin_function_signature LIKE '0x3c0b93aa'

and status like 'SUCCESS'

SELECT

date(block_timestamp) as date,

sum(amount) as fees_virtual,

sum(fees_virtual) over (order by date) as total_fees_virtual,

sum(amount_usd) as fees_usd,

sum(fees_usd) over (order by date) as total_fees_usd

FROM base.core.ez_token_transfers

WHERE tx_hash in (select * from tab1)

and contract_address like lower('0x0b3e328455c4059EEb9e3f84b5543F74E24e7E1b')

and FROM_ADDRESS = ORIGIN_FROM_ADDRESS

AND to_address like lower('0x86CbAC9d9Ac726F729eEf6627Dc4817BcBB03A9c')

GROUP BY 1

ORDER by 1 DESC