amelia-leeUntitled Query
    Updated 2022-07-29
    with last_30d_eth_blocks AS
    (
    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'
    Run a query to Download Data