NFT_NAME | CONTRACT_ADDRESS | TOTAL_BRIDGE_TRANSACTIONS | TOTAL_BRIDGERS | |
|---|---|---|---|---|
1 | Farm Land | 0xf083289535052e8449d69e6dc41c0ae064d8e3f6 | 531 | 196 |
2 | CyberKong Vx | 0x241a81fc0d6692707dad2b5025a3a7cf2cf25acf | 49 | 3 |
3 | Genkai | 0x1f7c16fce4fc894143afb5545bf04f676bf7dcf3 | 1 | 1 |
datavortexNFT bridged
Updated 2025-03-18
99
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
›
⌄
WITH nft_transfers_from_ronin AS (
SELECT
t.tx_hash,
MAX(t.decoded_log:to) AS bridger,
MAX(t.contract_address) AS contract_address
FROM
ronin.core.ez_decoded_event_logs t
WHERE
t.event_name = 'Transfer'
AND t.ORIGIN_FUNCTION_SIGNATURE = '0xb9afa177'
AND t.decoded_log:from = '0x0cf8ff40a508bdbc39fbe1bb679dcba64e65c7df'
AND t.contract_address IN (
'0xf083289535052e8449d69e6dc41c0ae064d8e3f6', -- Farm Land
'0x241a81fc0d6692707dad2b5025a3a7cf2cf25acf', -- CyberKong Vx
'0x1f7c16fce4fc894143afb5545bf04f676bf7dcf3' -- Genkai
)
GROUP BY
t.tx_hash
),
nft_transfers_to_ronin AS (
SELECT
t.tx_hash,
MAX(t.decoded_log:from) AS bridger,
MAX(t.contract_address) AS contract_address
FROM
ronin.core.ez_decoded_event_logs t
WHERE
t.event_name = 'Transfer'
AND t.ORIGIN_FUNCTION_SIGNATURE = '0x0b1ff17f'
AND t.decoded_log:to = '0x0cf8ff40a508bdbc39fbe1bb679dcba64e65c7df'
AND t.contract_address IN (
'0xf083289535052e8449d69e6dc41c0ae064d8e3f6', -- Farm Land
'0x241a81fc0d6692707dad2b5025a3a7cf2cf25acf', -- CyberKong Vx
'0x1f7c16fce4fc894143afb5545bf04f676bf7dcf3' -- Genkai
)
GROUP BY
Last run: about 2 months ago
3
195B
7s