SELECT

block_id

FROM

ethereum.transactions

where datediff(day, block_timestamp, current_date())<30

),

T1 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 to_label = 'polygon'

AND to_label_subtype = 'bridge'

--AND block_id IN (select block_id from last_30d_eth_blocks)

),

T2 as (

select

BLOCK_TIMESTAMP,

FROM_ADDRESS

from T1

where

FUNCTION_SIGNATURE='0x4faa8a26'

or FUNCTION_SIGNATURE='0xe3dec8fb'