from (

select from_address

from ethereum.transactions

WHERE to_address = '0x57f1887a8bf19b14fc0df6fd9b2acc9af147ea85'

and block_timestamp::date < '2021-11-08T00:00:00Z'::date

GROUP BY from_address)

as eligible_adressess INNER join ethereum.udm_events on(eligible_adressess.from_address = ethereum.udm_events.origin_address )

WHERE ethereum.udm_events.contract_address = '0xc18360217d8f7ab5e7c516566761ea12ce7f9d72'

and ethereum.udm_events.event_name = 'Claim' -- transfer

GROUP BY origin_address