In Total by Direction

0xHaM-dIn Total by Direction

Updated 24 hours ago

-- forked from In Total @ https://flipsidecrypto.xyz/studio/queries/c43831b6-2d16-4e80-a5b3-abbd35e670f0

WITH 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,

(log.DECODED_LOG:receipt:info:quantity::int/pow(10,p.decimals)) as amount,

(log.DECODED_LOG:receipt:info:quantity::int/pow(10,p.decimals))*p.price as amount_usd,

from ethereum.core.ez_decoded_event_logs log

left join crosschain.price.ez_prices_hourly p on (date_trunc('hour',log.block_timestamp)=p.hour and log.DECODED_LOG:receipt:mainchain:tokenAddr=p.token_address)

left join ethereum.core.dim_contracts cont on (log.DECODED_LOG:receipt:mainchain:tokenAddr=cont.address)

where log.TOPIC_0 = '0xd7b25068d9dc8d00765254cfb7f5070f98d263c8d68931d937c7362fa738048b'

and log.block_timestamp >= '2025-01-01'

and log.TX_SUCCEEDED = TRUE

and p.BLOCKCHAIN='ethereum'

and log.CONTRACT_ADDRESS = '0x64192819ac13ef72bf6b5ae239ac672b43a9af08'

)

from_ron_to_eth as ( -- native bridge

with

bridge_data as (

select

BLOCK_TIMESTAMP,

TX_HASH,

ORIGIN_FROM_ADDRESS::VARCHAR as sender,

regexp_substr_all(SUBSTR(DATA, 3, len(DATA)), '.{64}') AS segmented_data,

Last run: about 24 hours ago

	DIRECTION	NUMBER_OF_BRIDGE_TRANSACTIONS	NUMBER_OF_BRIDGERS	TOTAL_VOLUME
1	outbound	6603	3120	37473750.1718942
2	inbound	8595	4564	89976702.0286813

80B

163s