0xHaM-dLast 10 Steps of Intent Users - In Origin Chains
    Updated 2025-02-05
    -- forked from Intent Users - In Origin Chains @ https://flipsidecrypto.xyz/studio/queries/3ad4a03d-9808-4817-a601-aeae98a3fe6f

    -- forked from forgash / Intent Users - top wallets by USD @ https://flipsidecrypto.xyz/forgash/q/loJNCwc7y0xt/intent-users---top-wallets-by-usd

    with
    nep245_source_data AS (
    select *
    from $query('364f1258-e117-436f-81b1-ddfaea206abb')
    -- from $query('f7283bcc-2a59-45fe-8173-276bc7031ad0')
    where receipt_succeeded
    ),
    dip4_source_data AS (
    select
    receipt_id,
    account_id
    from $query('18c98585-fac8-402a-849d-c61e5748cbf8')
    where receipt_succeeded
    ),
    join_signer as (
    select
    dip4.account_id as intent_signer,
    nep245.*
    from nep245_source_data nep245
    left join dip4_source_data dip4 on dip4.receipt_id = nep245.receipt_id
    where log_event = 'mt_transfer'
    and dip4.account_id is not null
    qualify(row_number() over (partition by nep245.receipt_id order by log_index desc, amount_usd is not null desc) = 1)
    )
    , top_intent_signer as (
    select
    intent_signer,
    sum(amount_usd) as gross_transfer_volume
    from join_signer
    group by 1
    order by 2 DESC
    )
    QueryRunArchived: QueryRun has been archived