Query editor
WITH bridgeincoming_ethereum AS (SELECTblock_time AS in_bt,"from" AS sender,"to" AS receiver,ROUND(amount) AS amount, -- Rounded to nearest whole numbertx_hash AS evt_tx_hash,contract_address,CASEWHEN "to" = 0x3ee18b2214aff97000d974cf647e7c347e8fa585 THEN 'sent TO bridge (Ethereum side) 🟢'ELSE NULLEND AS "action"FROMtokens_ethereum.transfersWHEREcontract_address = 0x6de037ef9ad2725eb40118bb1702ebb27e4aeb24AND "to" = 0x3ee18b2214aff97000d974cf647e7c347e8fa585AND amount > 1000),bridgeoutgoing_solana AS (SELECTblock_time AS in_bt,from_owner AS sender,to_owner AS receiver,ROUND(amount / pow(10, tks.decimals)) AS amount, -- Rounded to nearest whole numbertx_id AS evt_tx_hash,trf.token_mint_address,CASEWHEN from_owner = 'AYm4Knn6Sw1f52Eq42ujQ2ez5Xb7iBJeviprFCA7ADCy' THEN 'sent FROM bridge (Solana side) 🔴'ELSE NULLEND AS "action2"FROMtokens_solana.transfers trfLEFT JOINtokens_solana.fungible tks ON trf.token_mint_address = tks.token_mint_addressWHEREtrf.token_mint_address = 'rndrizKT3MK1iimdxRdWabcF7Zg7AR5T4nud4EkHBof'AND from_owner = 'AYm4Knn6Sw1f52Eq42ujQ2ez5Xb7iBJeviprFCA7ADCy'AND amount / pow(10, tks.decimals) > 1000)SELECTin_bt AS block_time,amount, -- This is now roundedaction,'<a href=https://platform.arkhamintelligence.com/explorer/address/' || cast(sender as varchar) || ' target=_blank">' || cast(sender as varchar) || '</a>' as sender,CASE WHEN receiver = 0x3ee18b2214aff97000d974cf647e7c347e8fa585 THEN CONCAT('<a href="https://etherscan.io/advanced-filter?fadd=0x3ee18b2214aff97000d974cf647e7c347e8fa585&tadd=0x3ee18b2214aff97000d974cf647e7c347e8fa585&tkn=0x6de037ef9ad2725eb40118bb1702ebb27e4aeb24">', 'Bridge(Ethereum side)', '</a>') ELSE NULL END AS "receiver",'<a href=https://platform.arkhamintelligence.com/explorer/tx/' || cast(evt_tx_hash as varchar) || ' target=_blank">' || cast(evt_tx_hash as varchar) || '</a>' as transactionFROMbridgeincoming_ethereumUNION ALLSELECTin_bt AS block_time,amount, -- This is now roundedaction2,CASE WHEN sender = 'AYm4Knn6Sw1f52Eq42ujQ2ez5Xb7iBJeviprFCA7ADCy' THEN CONCAT('<a href="https://solscan.io/account/AYm4Knn6Sw1f52Eq42ujQ2ez5Xb7iBJeviprFCA7ADCy#transfers">', 'Bridge(Solana side)', '</a>') ELSE NULL END AS "sender",'<a href=https://solscan.io/account/' || cast(receiver as varchar) || ' target=_blank">' || cast(receiver as varchar) || '</a>' as receiver,'<a href=https://solscan.io/tx/' || cast(evt_tx_hash as varchar) || ' target=_blank">' || cast(evt_tx_hash as varchar) || '</a>' as transactionFROMbridgeoutgoing_solanaORDER BY