select distinct origin_from_address as claimer

from ethereum.core.ez_decoded_event_logs

where event_name = 'Transfer'

and contract_address = '0x36e66fbbce51e4cd5bd3c62b637eb411b18949d4'

and origin_to_address = '0xd0c155595929fd6be034c3848c00daebc6d330f6'

and block_timestamp >= '2024-01-01'

group by 1),

tbl as (

select

a.*,

b.TX_FEE

from

ethereum.core.ez_token_transfers a left join ethereum.core.fact_transactions b on a.TX_HASH = b.TX_HASH

where a.block_timestamp <= '2024-04-03'

and

( a.TO_ADDRESS = lower ('0x54945180db7943c0ed0fee7edab2bd24620256bc') --cbETH

or a.TO_ADDRESS = lower ('0x1bee69b7dfffa4e2d53c2a2df135c388ad25dcd2') --rETH

or a.TO_ADDRESS = lower ('0x93c4b944d05dfe6df7645a86cd2206016c51564d') --stETH

or a.TO_ADDRESS = lower ('0x57ba429517c3473B6d34CA9aCd56c0e735b94c02') --osETH

or a.TO_ADDRESS = lower ('0x0Fe4F44beE93503346A3Ac9EE5A26b130a5796d6') --swETH

or a.TO_ADDRESS = lower ('0x13760F50a9d7377e4F20CB8CF9e4c26586c658ff') --AnkrETH

or a.TO_ADDRESS = lower ('0x7CA911E83dabf90C90dD3De5411a10F1A6112184') --wBETH

or a.TO_ADDRESS = lower ('0x9d7eD45EE2E8FC5482fa2428f15C971e6369011d') --EthX

or a.TO_ADDRESS = lower ('0xa4C637e0F704745D182e4D38cAb7E7485321d059') --OETH

or a.TO_ADDRESS = lower ('0x8CA7A5d6f3acd3A7A8bC468a8CD0FB14B6BD28b6') --sfrxETH

or a.TO_ADDRESS = lower ('0xAe60d8180437b5C34bB956822ac2710972584473') --lsETH

or a.TO_ADDRESS = lower ('0x298aFB19A105D59E74658C4C334Ff360BadE6dd2') --mETH

)

and (

a.symbol = 'cbETH'

or a.symbol = 'rETH'

or a.symbol = 'stETH'