select

origin_from_address as ETH_Lockers, block_timestamp, tx_hash

from ethereum.core.fact_event_logs

where origin_to_address = '0xa4b41efc1b6f73355c90119aeefddb1ffcf907b0'

and contract_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'

and event_name = 'Transfer'

group by 1, 2, 3),

next_transactions as (

select ft.tx_hash as tx, from_address, ft.block_timestamp

from ethereum.core.fact_transactions ft

inner join mint_fr m on m.ETH_Lockers = ft.from_address

where from_address in (select ETH_Lockers from mint_fr)

and ft.block_timestamp::date = m.block_timestamp::date

and ft.block_timestamp > m.block_timestamp

and from_address != '0x0fbb8d17027b16810795b12cbeadc65b252530c4'

order by ft.block_timestamp ASC)

select count(tx_hash) as count, event_name, origin_to_address as contract

from ethereum.core.fact_event_logs

where tx_hash in (select tx from next_transactions)

and event_name is not null

group by 2, 3