select

BLOCK_TIMESTAMP,

'ETH' as Symbol,

TX_HASH,

ORIGIN_FROM_ADDRESS,

AMOUNT_USD

from ethereum.core.ez_eth_transfers

where 1=1

and ETH_TO_ADDRESS = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1'

and AMOUNT_USD is not null

union ALL

select

BLOCK_TIMESTAMP,

Symbol,

TX_HASH,

ORIGIN_FROM_ADDRESS,

AMOUNT_USD

from ethereum.core.ez_token_transfers

where 1=1

and TO_ADDRESS = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1'

and AMOUNT_USD is not null

),

used as (

a.ORIGIN_FROM_ADDRESS,

case when l.PROJECT_NAME is null then 'Other' ELSE l.PROJECT_NAME end as project,

row_number() over (partition by a.ORIGIN_FROM_ADDRESS order by a.block_timestamp asc) as r,

a.tx_hash

FROM optimism.core.fact_event_logs a

LEFT outer JOIN bridge

on a.ORIGIN_FROM_ADDRESS = bridge.ORIGIN_FROM_ADDRESS

LEFT outer JOIN optimism.core.dim_labels l

ON l.address = a.contract_address