rswETH Holders

0xHaM-drswETH Holders

Updated 2025-04-06

with eventTb11 as (

select

BLOCK_TIMESTAMP,

ORIGIN_FROM_ADDRESS as address,

(DECODED_LOG:value/1e18) as amount

from swell.core.ez_decoded_event_logs

where EVENT_NAME ilike 'Transfer'

and CONTRACT_NAME ilike 'rswETH'

-- and CONTRACT_NAME ilike 'rSWELL'

)

eventTb2 as (

select

BLOCK_TIMESTAMP,

ORIGIN_FROM_ADDRESS as address,

-- DECODED_LOG:to::string as address,

(DECODED_LOG:value/1e18) as amount

from swell.core.ez_decoded_event_logs

where EVENT_NAME ilike 'Transfer'

and CONTRACT_NAME ilike 'rswETH'

-- and CONTRACT_NAME ilike 'rSWELL'

and DECODED_LOG:to in (select address from eventTb11)

union all

select

BLOCK_TIMESTAMP,

DECODED_LOG:to::string as address,

(DECODED_LOG:value/1e18) as amount

from swell.core.ez_decoded_event_logs

where EVENT_NAME ilike 'Transfer'

and CONTRACT_NAME ilike 'rswETH'

-- and CONTRACT_NAME ilike 'rSWELL'

-- and ORIGIN_FROM_ADDRESS not in (select address from eventTb11)

and DECODED_LOG:from not in (select address from eventTb11)

)

Last run: 19 days ago

...

471

27KB

flipside