( SELECT block_id FROM

ethereum.transactions where datediff(day, block_timestamp, current_date())<30

),

base2 AS( select BLOCK_TIMESTAMP,

TX_ID, FROM_ADDRESS, TO_ADDRESS, TO_LABEL_TYPE,

TO_LABEL_SUBTYPE, TO_LABEL, TO_ADDRESS_NAME,

FUNCTION_NAME, FUNCTION_SIGNATURE

FROM ethereum.transactions WHERE base = 'polygon' AND to_label_subtype = 'bridge' ),

Table2 as (

select BLOCK_TIMESTAMP, FROM_ADDRESS

from base2

where FUNCTION_SIGNATURE='0x4faa8a26' or FUNCTION_SIGNATURE='0xe3dec8fb' or FUNCTION_SIGNATURE='0xe3dec8f' or FUNCTION_SIGNATURE='0x' or FUNCTION_SIGNATURE='0x0c53c51' or FUNCTION_SIGNATURE='0x9173b139'

),

Table3 as( select

a.from_address, min(a.BLOCK_NUMBER) as block_id

FROM polygon.core.fact_token_transfers a JOIN Table2 b

on a.from_address = b.from_address where a.BLOCK_TIMESTAMP>b.BLOCK_TIMESTAMP

group by 1

),

Table4 as (

select BLOCK_TIMESTAMP,

TX_HASH, from_address,

to_address,

CONTRACT_ADDRESS, ORIGIN_FUNCTION_SIGNATURE,

RANK() OVER (PARTITION BY from_address ORDER BY BLOCK_NUMBER) as rank

from polygon.core.fact_token_transfers where FROM_ADDRESS in (select FROM_ADDRESS from Table3)

),

Table5 AS( select

TX_HASH,

from_address, to_address, CONTRACT_ADDRESS, ORIGIN_FUNCTION_SIGNATURE