alirsBridger Destinations-part-02
    Updated 2022-08-01
    WITH matic_bridge_txns AS (
    select
    block_timestamp,
    block_id,
    tx_id,
    to_address as wallet,
    symbol,
    amount_usd
    from polygon.udm_events
    where amount is not null
    and symbol is not NULL
    and origin_address = '0x0000000000000000000000000000000000000000'
    and amount > 0
    and block_timestamp >'2022-01-01'
    ),
    first_transfer as (
    SELECT
    evt.block_timestamp,
    evt.tx_id,
    evt.symbol,
    evt.from_address as wallet,
    evt.amount_usd,
    evt.to_address,
    evt.to_address_name,
    evt.to_label,
    row_number() over(partition by evt.from_address order by evt.block_timestamp ) as rank
    FROM polygon.udm_events AS evt
    WHERE EXISTS ( select 1 from matic_bridge_txns bridge where evt.block_timestamp > bridge.block_timestamp and bridge.wallet = evt.from_address )
    and evt.amount_usd > 1000
    QUALIFY rank = 1
    ),
    joined as (
    SELECT
    bridge.block_timestamp as bridge_time,
    Run a query to Download Data