with data as (

select

block_timestamp::date as date

,date_trunc('week', block_timestamp)::date as week

,'ETH' as chain

, amount_usd as amount_usd1

, origin_to_address to1

,*

from ethereum.core.ez_token_transfers

where 1=1

and to_address in (

lower('0x6460D14DbAeb27AEfec8eBeF85dB35DefA31c3b9')

,lower('0x27213E28D7fDA5c57Fe9e5dD923818DBCcf71c47')

,lower('0x37a8f295612602f2774d331e562be9e61B83a327')

)

and block_timestamp::date > '2024-04-22'

and origin_from_address != '0xc8c0e780960f954c3426a32b6ab453248d632b59' -- excludes our swaps, when we conver tokens to weth/usdc

select *

from data

where 1=1

and amount_usd is not null

and symbol not in ('Shiba 2.0')

order by amount_usd1 desc

limit 100