flipside

    Top Shot bridged moments and EVM addresses
    bz-0780Top Shot bridged moments and EVM addresses
    Updated 2025-04-03
    SELECT
    block_timestamp,
    event_contract,
    event_type,
    event_data:to::string as evm_recipient_address,
    event_data:id::string as nft_id,
    event_data:type::string as nft_type,
    event_data:evmContractAddress::string as evm_contract_address,
    event_data:bridgeAddress::string as bridge_address,
    event_data:uuid::string as uuid
    FROM flow.core.fact_events
    WHERE event_contract = 'A.1e4aa0b87d10b141.IFlowEVMNFTBridge'
    AND event_type = 'BridgedNFTToEVM'
    AND block_timestamp >= DATEADD('day', -90, CURRENT_DATE())
    ORDER BY block_timestamp DESC;
    Last run: about 2 months ago
    BLOCK_TIMESTAMP
    EVENT_CONTRACT
    EVENT_TYPE
    EVM_RECIPIENT_ADDRESS
    NFT_ID
    NFT_TYPE
    EVM_CONTRACT_ADDRESS
    BRIDGE_ADDRESS
    UUID
    1
    		2025-04-04 18:01:28.125A.1e4aa0b87d10b141.IFlowEVMNFTBridgeBridgedNFTToEVM0000000000000000000000021252945a8c83a96348925509A.0b2a3299cc857e29.TopShot.NFT50ab3a827ad268e9d5a24d340108fad5c25dad5f0x1e4aa0b87d10b141244091582757883
    2
    		2025-04-04 17:50:22.520A.1e4aa0b87d10b141.IFlowEVMNFTBridgeBridgedNFTToEVM000000000000000000000002c29665550f4c581942959059A.0b2a3299cc857e29.TopShot.NFT50ab3a827ad268e9d5a24d340108fad5c25dad5f0x1e4aa0b87d10b1411191005289
    3
    		2025-04-04 17:49:37.702A.1e4aa0b87d10b141.IFlowEVMNFTBridgeBridgedNFTToEVM00000000000000000000000214624f3dd5f7490648923819A.0b2a3299cc857e29.TopShot.NFT50ab3a827ad268e9d5a24d340108fad5c25dad5f0x1e4aa0b87d10b14149478024629114
    4
    		2025-04-04 17:49:07.334A.1e4aa0b87d10b141.IFlowEVMNFTBridgeBridgedNFTToEVM00000000000000000000000214624f3dd5f7490648898263A.0b2a3299cc857e29.TopShot.NFT50ab3a827ad268e9d5a24d340108fad5c25dad5f0x1e4aa0b87d10b141142936512995608
    5
    		2025-04-04 17:48:40.585A.1e4aa0b87d10b141.IFlowEVMNFTBridgeBridgedNFTToEVM00000000000000000000000214624f3dd5f7490649010723A.0b2a3299cc857e29.TopShot.NFT50ab3a827ad268e9d5a24d340108fad5c25dad5f0x1e4aa0b87d10b141204509164171880
    6
    		2025-04-04 17:48:11.876A.1e4aa0b87d10b141.IFlowEVMNFTBridgeBridgedNFTToEVM00000000000000000000000214624f3dd5f7490649023956A.0b2a3299cc857e29.TopShot.NFT50ab3a827ad268e9d5a24d340108fad5c25dad5f0x1e4aa0b87d10b141157230164178336
    7
    		2025-04-04 17:47:38.634A.1e4aa0b87d10b141.IFlowEVMNFTBridgeBridgedNFTToEVM00000000000000000000000214624f3dd5f7490649011657A.0b2a3299cc857e29.TopShot.NFT50ab3a827ad268e9d5a24d340108fad5c25dad5f0x1e4aa0b87d10b14139582420007327
    8
    		2025-04-04 17:41:31.751A.1e4aa0b87d10b141.IFlowEVMNFTBridgeBridgedNFTToEVM000000000000000000000002c29665550f4c581942267163A.0b2a3299cc857e29.TopShot.NFT50ab3a827ad268e9d5a24d340108fad5c25dad5f0x1e4aa0b87d10b1411014006485
    9
    		2025-04-04 17:41:05.403A.1e4aa0b87d10b141.IFlowEVMNFTBridgeBridgedNFTToEVM000000000000000000000002c29665550f4c581941453757A.0b2a3299cc857e29.TopShot.NFT50ab3a827ad268e9d5a24d340108fad5c25dad5f0x1e4aa0b87d10b141978498860
    10
    		2025-04-04 17:40:22.869A.1e4aa0b87d10b141.IFlowEVMNFTBridgeBridgedNFTToEVM000000000000000000000002c29665550f4c581941489214A.0b2a3299cc857e29.TopShot.NFT50ab3a827ad268e9d5a24d340108fad5c25dad5f0x1e4aa0b87d10b141978551447
    11
    		2025-04-04 17:39:58.665A.1e4aa0b87d10b141.IFlowEVMNFTBridgeBridgedNFTToEVM000000000000000000000002c29665550f4c581942271114A.0b2a3299cc857e29.TopShot.NFT50ab3a827ad268e9d5a24d340108fad5c25dad5f0x1e4aa0b87d10b1411014013036
    12
    		2025-04-04 17:39:32.722A.1e4aa0b87d10b141.IFlowEVMNFTBridgeBridgedNFTToEVM000000000000000000000002c29665550f4c581937519753A.0b2a3299cc857e29.TopShot.NFT50ab3a827ad268e9d5a24d340108fad5c25dad5f0x1e4aa0b87d10b141720466084
    13
    		2025-04-04 17:39:09.758A.1e4aa0b87d10b141.IFlowEVMNFTBridgeBridgedNFTToEVM000000000000000000000002c29665550f4c581939643007A.0b2a3299cc857e29.TopShot.NFT50ab3a827ad268e9d5a24d340108fad5c25dad5f0x1e4aa0b87d10b141874816411
    14
    		2025-04-04 17:38:46.134A.1e4aa0b87d10b141.IFlowEVMNFTBridgeBridgedNFTToEVM000000000000000000000002c29665550f4c581942314444A.0b2a3299cc857e29.TopShot.NFT50ab3a827ad268e9d5a24d340108fad5c25dad5f0x1e4aa0b87d10b1411014086599
    15
    		2025-04-04 15:21:08.140A.1e4aa0b87d10b141.IFlowEVMNFTBridgeBridgedNFTToEVM000000000000000000000002ac9889f3d032a59e40051547A.0b2a3299cc857e29.TopShot.NFT50ab3a827ad268e9d5a24d340108fad5c25dad5f0x1e4aa0b87d10b141890426673
    16
    		2025-04-04 15:20:39.315A.1e4aa0b87d10b141.IFlowEVMNFTBridgeBridgedNFTToEVM000000000000000000000002ac9889f3d032a59e40051829A.0b2a3299cc857e29.TopShot.NFT50ab3a827ad268e9d5a24d340108fad5c25dad5f0x1e4aa0b87d10b141890427037
    17
    		2025-04-04 15:18:48.846A.1e4aa0b87d10b141.IFlowEVMNFTBridgeBridgedNFTToEVM000000000000000000000002ac9889f3d032a59e39989445A.0b2a3299cc857e29.TopShot.NFT50ab3a827ad268e9d5a24d340108fad5c25dad5f0x1e4aa0b87d10b141890336259
    18
    		2025-04-04 15:18:18.841A.1e4aa0b87d10b141.IFlowEVMNFTBridgeBridgedNFTToEVM000000000000000000000002ac9889f3d032a59e39511612A.0b2a3299cc857e29.TopShot.NFT50ab3a827ad268e9d5a24d340108fad5c25dad5f0x1e4aa0b87d10b141874610804
    19
    		2025-04-04 15:17:54.421A.1e4aa0b87d10b141.IFlowEVMNFTBridgeBridgedNFTToEVM000000000000000000000002ac9889f3d032a59e39682032A.0b2a3299cc857e29.TopShot.NFT50ab3a827ad268e9d5a24d340108fad5c25dad5f0x1e4aa0b87d10b141874874763
    20
    		2025-04-04 12:40:39.568A.1e4aa0b87d10b141.IFlowEVMNFTBridgeBridgedNFTToEVM0000000000000000000000026997c37fa045b70247666397A.0b2a3299cc857e29.TopShot.NFT50ab3a827ad268e9d5a24d340108fad5c25dad5f0x1e4aa0b87d10b14141781442965010
    ...
    14721
    3MB
    4s