BSC/ LiFi: ez_transactions

SocioCryptoBSC/ LiFi: ez_transactions

Updated 2024-01-15

-- forked from Polygon/ LiFi: ez_transactions @ https://flipsidecrypto.xyz/edit/queries/eec2a3a1-7194-4165-89ec-ad43beda019a

-- block_number / block_timestamp / tx_hash / sender / token_address / [token_symbol] / dest_chain_id / route / receiver / amount / gas_fee / bridge / swap_involved / tx_status

WITH main as (

--lifiDiamond

SELECT a.block_number, a.block_timestamp, a.tx_hash, 'lifiDiamond' as contract, a.origin_from_address as sender,

to_varchar(b.decoded_log:asset) as token_address, --token sender deposited

-- to_varchar(decoded_log:bridgeData:sendingAssetId) as token_in, -- token sent by LiFi

'BNB Smart Chain Mainnet' as src_chain,

to_varchar(a.decoded_log:bridgeData:destinationChainId) as dest_chain_id,

to_varchar(a.decoded_log:bridgeData:receiver) as receiver,

-- to_number(a.decoded_log:bridgeData:minAmount*price/pow(10,decimals)) as amnt,

b.decoded_log:amount as raw_amnt,

to_varchar(a.decoded_log:bridgeData:bridge) as bridge,

a.tx_status

FROM

bsc.core.ez_decoded_event_logs a, bsc.core.ez_decoded_event_logs b

WHERE a.tx_hash = b.tx_hash

And a.block_timestamp >= '2023-11-15'

AND a.event_name = 'LiFiTransferStarted' AND b.event_name = 'XCalled'

AND a.contract_address = '0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae' --LiFiDiamond

AND a.origin_to_address = '0xaec23140408534b378bf5832defc426df8604b59' --metamask

-- AND b.decoded_log:from = '0xaec23140408534b378bf5832defc426df8604b59'

AND b.origin_to_address = '0xaec23140408534b378bf5832defc426df8604b59' --metamask

-- AND a.tx_hash = '0xcd367bbdc489b6e90b12489926dd8d16b586de6c38ce00ef2b1a89405ff0cf1b'

UNION

-- cbridgefacetpacked

SELECT a.block_number, a.block_timestamp, a.tx_hash, 'cBridgeFacetPacked' as contract, b.origin_from_address as sender,

to_varchar(b.contract_address) as token_address, --token sender deposited

-- to_varchar(a.decoded_log:token) as token_in, -- token sent by LiFi

'BNB Smart Chain Mainnet' as src_chain,

to_varchar(a.decoded_log:dstChainId) as dest_chain_id,

QueryRunArchived: QueryRun has been archived