block_timestamp::DATE AS block_timestamp,

tx_id,

to_address as wallet,

symbol,

FROM

polygon.udm_events

where symbol IS NOT NULL

AND origin_address = '0x0000000000000000000000000000000000000000'

AND amount > 0

AND block_timestamp > CURRENT_DATE - 30),

first_transfer as (

SELECT

ft.block_timestamp,

ft.tx_id,

ft.symbol,

ft.from_address as wallet,

ft.amount_usd,

ft.to_address,

ft.to_address_name,

ft.to_label,

row_number() over(partition by ft.from_address order by ft.block_timestamp ) as rank

FROM polygon.udm_events AS ft

WHERE EXISTS ( select 1 from main bridge where ft.block_timestamp > bridge.block_timestamp AND bridge.wallet = ft.from_address )

AND ft.amount_usd IS NOT NULL

QUALIFY rank = 1),

main_query as (