BRIDGER | VOLUME_USD_READABLE | TOTAL_BRIDGE_TX | TOKENS_BRIDGED | |
|---|---|---|---|---|
1 | 0xa3410f80f7ea541dddb2fae89a0607fb96412ef9 | 263.96M | 199 | USD Coin, Ronin Wrapped Ether |
2 | 0xe69f81b825d7dc31ee9becef4dbeab5cf30e3abb | 89.55M | 75 | Axie Infinity Shard, USD Coin, Ronin Wrapped Ether, Smooth Love Potion |
3 | 0x8bd81a19420bad681b7bfc20e703ebd8e253782d | 34.34M | 1 | Axie Infinity Shard |
4 | 0x26c2a176c1c66748318ff549b1c7d1bfe07fb3f2 | 28.1M | 4 | PIXEL |
5 | 0xe02b4569698ac5f0b442a69b36333298f7f8fbcf | 24.24M | 3 | PIXEL |
6 | 0x2a2dfb6557e59da286497b0e7461ec3bfd38d604 | 23.34M | 3 | PIXEL |
7 | 0x4f04e98c3fc3abf1c34208ea64e19e4a222e0908 | 14.27M | 26 | Axie Infinity Shard, Ronin Wrapped Ether, Yield Guild Games Token |
8 | 0x5a84533ed5231dd12bf08a2660f2d40bccaff21d | 12.66M | 3 | PIXEL |
9 | 0x0e8cb007d7fe291d275cd83c18b4a7eefa112d62 | 10.1M | 31 | Ronin Wrapped Ether, USD Coin, Axie Infinity Shard |
10 | 0x8c691768f68cd8e201ed1ada0aa35949a2a582db | 7.53M | 1 | Axie Infinity Shard |
datavortexTop Bridger
Updated 2025-03-19
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
›
⌄
WITH transfer_from_ronin AS (
SELECT
t.tx_hash,
MAX(CASE WHEN t.event_name = 'Transfer' THEN COALESCE(t.decoded_log:_to, t.decoded_log:to) END) AS bridger,
MAX(CASE WHEN t.event_name = 'Transfer' THEN COALESCE(t.decoded_log:_value, t.decoded_log:value) END) AS transfer_value_raw,
MAX(CASE WHEN t.event_name = 'Transfer' THEN t.contract_address END) AS contract_address,
MAX(CASE WHEN t.event_name = 'Transfer' THEN t.contract_name END) AS contract_name,
MAX(DATE_TRUNC('day', t.block_timestamp)) AS event_date
FROM ronin.core.ez_decoded_event_logs t
WHERE t.event_name IN ('Transfer', 'Deposited')
AND t.ORIGIN_FUNCTION_SIGNATURE = '0xb9afa177'
AND (
(t.event_name = 'Deposited'
AND t.decoded_log:anonymous_1.mainchain.chainId = 1
AND t.decoded_log:anonymous_1.ronin.chainId = 2020)
OR (t.event_name = 'Transfer'
AND COALESCE(t.decoded_log:_from, t.decoded_log:from) = '0x0cf8ff40a508bdbc39fbe1bb679dcba64e65c7df')
)
AND t.contract_address NOT IN (
'0xf083289535052e8449d69e6dc41c0ae064d8e3f6',
'0x241a81fc0d6692707dad2b5025a3a7cf2cf25acf',
'0x5cf6654fc5f33dfbaf3f6f859fbbe5f017edcc3b'
)
GROUP BY t.tx_hash
),
transfer_to_ronin AS (
SELECT
t.tx_hash,
MAX(CASE WHEN t.event_name = 'Transfer' THEN COALESCE(t.decoded_log:_from, t.decoded_log:from) END) AS bridger,
MAX(CASE WHEN t.event_name = 'Transfer' THEN COALESCE(t.decoded_log:_value, t.decoded_log:value) END) AS transfer_value_raw,
MAX(CASE WHEN t.event_name = 'Transfer' THEN t.contract_address END) AS contract_address,
MAX(CASE WHEN t.event_name = 'Transfer' THEN t.contract_name END) AS contract_name,
MAX(DATE_TRUNC('day', t.block_timestamp)) AS event_date
FROM ronin.core.ez_decoded_event_logs t
WHERE t.event_name IN ('Transfer', 'WithdrawalRequested')
AND t.ORIGIN_FUNCTION_SIGNATURE = '0x0b1ff17f'
Last run: 2 months ago
10
886B
9s