Query editor
WITH bridge_txns AS (SELECT contract_address, evt_tx_hash, evt_index, evt_block_time, evt_block_number, bridgeData, 'arbitrum' AS src_blockchainFROM lifi_arbitrum.LiFiDiamond_v2_evt_LiFiTransferStartedWHERE json_extract_scalar(bridgeData, '$.integrator') = 'cryptex-finance'UNIONSELECT contract_address, evt_tx_hash, evt_index, evt_block_time, evt_block_number, bridgeData, 'ethereum' AS src_blockchainFROM lifi_ethereum.LiFiDiamond_v2_evt_LiFiTransferStartedWHERE json_extract_scalar(bridgeData, '$.integrator') = 'cryptex-finance'UNIONSELECT contract_address, evt_tx_hash, evt_index, evt_block_time, evt_block_number, bridgeData, 'optimism' AS src_blockchainFROM lifi_optimism.LiFiDiamond_v2_evt_LiFiTransferStartedWHERE json_extract_scalar(bridgeData, '$.integrator') = 'cryptex-finance'UNIONSELECT contract_address, evt_tx_hash, evt_index, evt_block_time, evt_block_number, bridgeData, 'polygon' AS src_blockchainFROM lifi_polygon.LiFiDiamond_v2_evt_LiFiTransferStartedWHERE json_extract_scalar(bridgeData, '$.integrator') = 'cryptex-finance'UNIONSELECT contract_address, evt_tx_hash, evt_index, evt_block_time, evt_block_number, bridgeData, 'avalanche' AS src_blockchainFROM lifi_avalanche_c.LiFiDiamond_v2_evt_LiFiTransferStartedWHERE json_extract_scalar(bridgeData, '$.integrator') = 'cryptex-finance'UNIONSELECT contract_address, evt_tx_hash, evt_index, evt_block_time, evt_block_number, bridgeData, 'bnb' AS src_blockchainFROM lifi_bnb.LiFiDiamond_v2_evt_LiFiTransferStartedWHERE json_extract_scalar(bridgeData, '$.integrator') = 'cryptex-finance'UNIONSELECT contract_address, evt_tx_hash, evt_index, evt_block_time, evt_block_number, bridgeData, 'fantom' AS src_blockchainFROM lifi_fantom.LiFiDiamond_v2_evt_LiFiTransferStartedWHERE json_extract_scalar(bridgeData, '$.integrator') = 'cryptex-finance'UNIONSELECT contract_address, evt_tx_hash, evt_index, evt_block_time, evt_block_number, bridgeData, 'gnosis' AS src_blockchainFROM lifi_gnosis.LiFiDiamond_v2_evt_LiFiTransferStartedWHERE json_extract_scalar(bridgeData, '$.integrator') = 'cryptex-finance'UNIONSELECT contract_address, evt_tx_hash, evt_index, evt_block_time, evt_block_number, bridgeData, 'base' AS src_blockchainFROM lifi_base.LiFiDiamond_v2_evt_LiFiTransferStartedWHERE json_extract_scalar(bridgeData, '$.integrator') = 'cryptex-finance'UNIONSELECT contract_address, evt_tx_hash, evt_index, evt_block_time, evt_block_number, bridgeData, 'celo' AS src_blockchainFROM lifi_celo.LiFiDiamond_v2_evt_LiFiTransferStartedWHERE json_extract_scalar(bridgeData, '$.integrator') = 'cryptex-finance'UNIONSELECT contract_address, evt_tx_hash, evt_index, evt_block_time, evt_block_number, bridgeData, 'zksync' AS src_blockchainFROM lifi_zksync.LiFiDiamond_v2_evt_LiFiTransferStartedWHERE json_extract_scalar(bridgeData, '$.integrator') = 'cryptex-finance'UNIONSELECT contract_address, evt_tx_hash, evt_index, evt_block_time, evt_block_number, bridgeData, 'blast' AS src_blockchainFROM lifi_blast.LiFiDiamond_v2_evt_LiFiTransferStartedWHERE json_extract_scalar(bridgeData, '$.integrator') = 'cryptex-finance'UNIONSELECT contract_address, evt_tx_hash, evt_index, evt_block_time, evt_block_number, bridgeData, 'mantle' AS src_blockchainFROM lifi_mantle.LiFiDiamond_v2_evt_LiFiTransferStartedWHERE json_extract_scalar(bridgeData, '$.integrator') = 'cryptex-finance'UNIONSELECT contract_address, evt_tx_hash, evt_index, evt_block_time, evt_block_number, bridgeData, 'zkevm' AS src_blockchainFROM lifi_zkevm.LiFiDiamond_v2_evt_LiFiTransferStartedWHERE json_extract_scalar(bridgeData, '$.integrator') = 'cryptex-finance'),bridge_txns_ext AS (SELECT