0xHaM-dLast 10 Steps of Intent Users - In Origin Chains
Updated 2025-02-05Copy Reference Fork
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- 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