pecio222monad pancake factory events
    Updated 2025-03-29
    select
    'MONAD' AS CHAIN,
    'PANCAKE V3 POOL' AS NAME,
    CONCAT('0x', SUBSTRING(TOPIC_1, 27, 42)) AS token_x_id,
    CONCAT('0x', SUBSTRING(TOPIC_2, 27, 42)) AS token_y_id,
    CONCAT('0x', SUBSTRING(DATA, 27 + 64, 42)) AS id
    from
    monad.testnet.fact_event_logs
    where
    CONTRACT_ADDRESS = LOWER('0x3b7838D96Fc18AD1972aFa17574686be79C50040') --monad factory pancakeswap
    and topics [0] = '0x783cca1c0412dd0d695e784568c96da2e9c22ff989357a2e8b1d9b2b4e6b7118'
    Last run: 3 months ago
    CHAIN
    NAME
    TOKEN_X_ID
    TOKEN_Y_ID
    ID
    1
    MONADPANCAKE V3 POOL0x760afe86e5de5fa0ee542fc7b7b713e1c54257010xb2f82d0f38dc453d596ad40a37799446cc89274a0x51b0692cd5af41f30e240c3f983f12ad0fa8ddf9
    2
    MONADPANCAKE V3 POOL0x3a98250f98dd388c211206983453837c8365bdc10x760afe86e5de5fa0ee542fc7b7b713e1c54257010x5acc63cfe5edd891d9c7569c54397c8333235e0c
    3
    MONADPANCAKE V3 POOL0x4b5a849594ed39214e60ab929e54009b8f559a310x760afe86e5de5fa0ee542fc7b7b713e1c54257010x60ec0f908db454e33ed79218d48cccf998ff7a16
    4
    MONADPANCAKE V3 POOL0xaeef2f6b429cb59c9b2d7bb2141ada993e8571c30xe0590015a873bf326bd645c3e1266d4db41c4e6b0x67cba5ac5f417ab88ab9d0ee3b7223beedba024f
    5
    MONADPANCAKE V3 POOL0x760afe86e5de5fa0ee542fc7b7b713e1c54257010xfe140e1dce99be9f4f15d657cd9b7bf622270c500xa6c382654548921d39888e95d9a904c1047d8770
    6
    MONADPANCAKE V3 POOL0x3904ce0d19121ad55fcc50da75d1074c1e9733bd0x760afe86e5de5fa0ee542fc7b7b713e1c54257010x410365e245f6bc6ba6f65ac60a4b7f4b0b00723c
    7
    MONADPANCAKE V3 POOL0x2ce5675f71bfd320346f817c99894b9582adfcd90x760afe86e5de5fa0ee542fc7b7b713e1c54257010xe1b80f478129db5d003af909de8d98a4ebd6cef3
    8
    MONADPANCAKE V3 POOL0x2cb34c249303b403aceaef53a94a4eb49121aa700x760afe86e5de5fa0ee542fc7b7b713e1c54257010xee4ba66827f06f27e4d90c92e1b7e48f160dc280
    9
    MONADPANCAKE V3 POOL0x760afe86e5de5fa0ee542fc7b7b713e1c54257010xf32c1fe68c9bef884d16e7ce19c356a6400665d70xf192d6ddb91b70073ddba37941840a897e10dcc0
    10
    MONADPANCAKE V3 POOL0x760afe86e5de5fa0ee542fc7b7b713e1c54257010xf17075841a13defb8b77add74e68158a1735398e0xee195e2c9f27287c02bacb1601502473cd18251c
    11
    MONADPANCAKE V3 POOL0xcf27f781841484d5cf7e155b44954d7224caf1dd0xf817257fed379853cde0fa4f97ab987181b1e5ea0xf190daeda55b72334900b742a2b1e38b61ee0ff9
    12
    MONADPANCAKE V3 POOL0xaeef2f6b429cb59c9b2d7bb2141ada993e8571c30xcf27f781841484d5cf7e155b44954d7224caf1dd0x62fb33ef81ff6983219eaf4f053e54eae75e570c
    13
    MONADPANCAKE V3 POOL0x5e00445e4db627ce71a4640a44cfa040d86177950xfe140e1dce99be9f4f15d657cd9b7bf622270c500x146d1a4ca89aedac2a49bd5042aed7bd0aec2467
    14
    MONADPANCAKE V3 POOL0x086cb51a278990b6f8bba981e36288ef467a33030x760afe86e5de5fa0ee542fc7b7b713e1c54257010x6080cbd6d4bbdb6ac50fc9b53cf68a54410c9e93
    15
    MONADPANCAKE V3 POOL0x07aabd925866e8353407e67c1d157836f7ad923e0xb2f82d0f38dc453d596ad40a37799446cc89274a0xfe409575c6c3100663766ee2c1c8997df000c24f
    16
    MONADPANCAKE V3 POOL0x673cd70fa883394a1f3deb3221937ceb7c2618d70xc259d241f98527e38fbbb74f7b37ea6c27833f110xd859159f9977dbb1901584d1a2770f1d68db80fc
    17
    MONADPANCAKE V3 POOL0x0f0bdebf0f83cd1ee3974779bcb7315f9808c7140xe0590015a873bf326bd645c3e1266d4db41c4e6b0xf560d68a85c1f91bff969e77ceb1ac4f2ff56c42
    18
    MONADPANCAKE V3 POOL0x673cd70fa883394a1f3deb3221937ceb7c2618d70xb5a30b0fdc5ea94a52fdc42e3e9760cb8449fb370x30f0ee036b785461c2cb57e3acf42f793cb2520e
    19
    MONADPANCAKE V3 POOL0x760afe86e5de5fa0ee542fc7b7b713e1c54257010xea542444162ccaeb6e46150406dcf5ed8b47ca1c0xa9e7d6d8894014cb775698de2d1d487495379acb
    20
    MONADPANCAKE V3 POOL0x6593f49ca8d3038ca002314c187b63dd348c2f940x760afe86e5de5fa0ee542fc7b7b713e1c54257010x9d9f3f4fd0034238aca160953ae5142dae6216cd
    ...
    374
    60KB
    16s