with arb_claims as (

with base as (

SELECT

*

from arbitrum.core.fact_transactions

WHERE 1=1

AND to_address = lower('0x75A99528b5FC4D328473032c9f390db7C8BabdF1')

AND ORIGIN_FUNCTION_SIGNATURE='0x5435ed64'

--and tx_hash = lower('0x80a90bfea5f9383f0387c46c493001d8085238e127ee27be4cb6211cdfac884f')

)

SELECT

block_timestamp

, tx_hash

, from_address as sender

, to_address as claimer

, amount as token_amount

, amount_usd

, symbol

, CASE WHEN block_timestamp BETWEEN '2023-11-08' AND '2024-06-27' THEN 'ARB (STIP-1)' ELSE 'ARB (STIP-2)' END as label

FROM arbitrum.core.ez_token_transfers

WHERE 1=1

AND from_address = lower('0x75A99528b5FC4D328473032c9f390db7C8BabdF1')

AND tx_hash IN (SELECT tx_hash from base)

,

vertex_claims as (

with base as (

SELECT

*

from arbitrum.core.fact_transactions