User Breakdown

0xHaM-dUser Breakdown

Updated 2025-04-03

WITH chain_ids AS (

SELECT *

FROM (

VALUES

(1, 'ethereum', 'Ethereum Mainnet'),

(10, 'optimism', 'Optimism'),

(137, 'polygon', 'Polygon'),

(42161, 'arbitrum', 'Arbitrum One'),

(43114, 'avalanche', 'Avalanche C-Chain'),

(56, 'bsc', 'BNB Smart Chain'),

(8453, 'base', 'Base'),

(2020, 'ronin', 'Ronin'),

(5, 'ethereum', 'Goerli Testnet'),

(11155111, 'ethereum', 'Sepolia Testnet'),

(80001, 'polygon', 'Mumbai Testnet'),

(421613, 'arbitrum', 'Arbitrum Goerli'),

(97, 'bsc', 'BSC Testnet'),

(43113, 'avalanche', 'Avalanche Fuji Testnet'),

(84531, 'base', 'Base Goerli')

) AS v (chain_id, BLOCKCHAIN, network_name)

)

from_eth_to_ron as ( -- native bridge

select

BLOCK_TIMESTAMP,

TX_HASH,

ORIGIN_FROM_ADDRESS as sender,

DECODED_LOG:receipt:mainchain:tokenAddr as token_address,

DECODED_LOG:receipt:ronin:addr as receiver,

DECODED_LOG:receipt:ronin:tokenAddr as destination_tokenAddr,

DECODED_LOG:receipt:info:quantity as quantity,

'Ethereum'::VARCHAR as BLOCKCHAIN,

'axie infinity: ronin bridge v2'::VARCHAR as platform,

'ronin'::VARCHAR as destination_chain,

'inbound'::VARCHAR as direction,

coalesce(p.symbol,cont.symbol)::VARCHAR as symbol,

Last run: 13 days ago

141B

163s

flipside