Query editor
WITH transfer_events AS (SELECTcontract_address,evt_tx_hash,evt_index,evt_block_time,evt_block_number,chain,CAST(from_hex(json_extract_scalar(bridgeData, '$.sendingAssetId')) AS VARBINARY) AS fromAssetId,CAST(NULL AS VARBINARY) AS toAssetId,CAST(json_extract_scalar(bridgeData, '$.minAmount') AS DECIMAL) AS fromAmount,CAST(NULL AS DECIMAL) AS toAmount,json_extract_scalar(bridgeData, '$.integrator') AS integrator,json_extract_scalar(bridgeData, '$.receiver') AS receiver,json_extract_scalar(bridgeData, '$.referrer') AS referrer,json_extract_scalar(bridgeData, '$.transactionId') AS transactionIdFROM lifi_multichain.lifidiamond_v2_evt_lifitransferstartedWHERE json_extract_scalar(bridgeData, '$.integrator') = 'cryptex-finance'UNION ALLSELECTcontract_address,evt_tx_hash,evt_index,evt_block_time,evt_block_number,chain,CAST(from_hex(json_extract_scalar(bridgeData, '$.sendingAssetId')) AS VARBINARY) AS fromAssetId,CAST(NULL AS VARBINARY) AS toAssetId,CAST(json_extract_scalar(bridgeData, '$.minAmount') AS DECIMAL) AS fromAmount,CAST(NULL AS DECIMAL) AS toAmount,json_extract_scalar(bridgeData, '$.integrator') AS integrator,json_extract_scalar(bridgeData, '$.receiver') AS receiver,json_extract_scalar(bridgeData, '$.referrer') AS referrer,json_extract_scalar(bridgeData, '$.transactionId') AS transactionIdFROM lifi_multichain.lifidiamond_evt_lifitransferstartedWHERE json_extract_scalar(bridgeData, '$.integrator') = 'cryptex-finance'),swap_events AS (SELECTcontract_address,evt_tx_hash,evt_index,evt_block_time,evt_block_number,chain,fromAssetId,toAssetId,fromAmount,toAmount,integrator,receiver,referrer,transactionIdFROM lifi_multichain.lifidiamond_v2_evt_lifigenericswapcompletedWHERE integrator = 'cryptex-finance'