D3 AnalyticsDaily NFT Trades
Updated 2025-03-31Copy 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
›
⌄
-- Inspiration https://flipsidecrypto.xyz/TheLaughingMan/q/zd9PrybB0sGM/daily-stats
with payment as (
SELECT to_address as contract_address
, tx_hash
, 1 as token_transfer_index
, 1 as payment_rows
, from_address as buyer
, 'RON' as symbol
, amount
, amount_usd
from ronin.core.ez_native_transfers
WHERE 1=1
AND trace_index = 0
AND to_address in (
'0x3b3adf1422f84254b7fbb0e7ca62bd0865133fe3' --Market Gateway Proxy
, '0x21a0a1c081dc2f3e48dc391786f53035f85ce0bc' --Market Gateway Proxy Multi Send Proxy
)
UNION ALL
--incase other erc20 not native
SELECT to_address as contract_address
, tx_hash
, row_number() over(partition by tx_hash order by event_index) token_transfer_index
, count(*) over(partition by tx_hash) payment_rows
, from_address as buyer
, symbol
, amount
, amount_usd
from ronin.core.ez_token_transfers
WHERE 1=1
AND to_address in (
'0x3b3adf1422f84254b7fbb0e7ca62bd0865133fe3' --Market Gateway Proxy
, '0x21a0a1c081dc2f3e48dc391786f53035f85ce0bc' --Market Gateway Proxy Multi Send Proxy
)
AND from_address <> '0x21a0a1c081dc2f3e48dc391786f53035f85ce0bc' -- Exclude intermediate cases where MG Multi Send Proxy indirectly forwards tokens to MG Proxy for token distribution
),
QueryRunArchived: QueryRun has been archived