flipside

    Liquidity Pools Details
    Yousefi_1994Liquidity Pools Details
    Updated 2025-02-03
    WITH POOLS_ICECREAMSWAP_CREATED AS (
    SELECT
    TX_HASH,
    CASE
    WHEN CONTRACT_ADDRESS = '0x9e6d21e759a7a288b80eef94e4737d313d31c13f' AND TOPIC_0 = '0x0d3648bd0f6ba80134a33ba9275ac585d9d315f0ad8355cddefde31afa28d0e9' THEN 'V2'
    WHEN CONTRACT_ADDRESS = '0xa8a3aad4f592b7f30d6514ee9a863a4ceff6531d' AND TOPIC_0 = '0x783cca1c0412dd0d695e784568c96da2e9c22ff989357a2e8b1d9b2b4e6b7118' THEN 'V3'
    ELSE 'Unknown'
    END AS VERSION,

    CASE
    WHEN CONTRACT_ADDRESS = '0x9e6d21e759a7a288b80eef94e4737d313d31c13f' AND TOPIC_0 = '0x0d3648bd0f6ba80134a33ba9275ac585d9d315f0ad8355cddefde31afa28d0e9' THEN CONCAT('0x', SUBSTR(DATA, 27 + 64 * 0, 40))
    WHEN CONTRACT_ADDRESS = '0xa8a3aad4f592b7f30d6514ee9a863a4ceff6531d' AND TOPIC_0 = '0x783cca1c0412dd0d695e784568c96da2e9c22ff989357a2e8b1d9b2b4e6b7118' THEN CONCAT('0x', SUBSTR(DATA, 27 + 64 * 1, 40))
    ELSE 'Unknown'
    END AS POOL_ADDRESS,

    CONCAT('0x', SUBSTR(TOPIC_1, 27, 40)) AS TOKEN_0_ADDRESS,
    CONCAT('0x', SUBSTR(TOPIC_2, 27, 40)) AS TOKEN_1_ADDRESS
    FROM
    core.core.fact_event_logs
    WHERE
    CONTRACT_ADDRESS IN ('0x9e6d21e759a7a288b80eef94e4737d313d31c13f', '0xa8a3aad4f592b7f30d6514ee9a863a4ceff6531d')
    AND
    TX_SUCCEEDED = TRUE
    AND
    TOPIC_0 IN ('0x0d3648bd0f6ba80134a33ba9275ac585d9d315f0ad8355cddefde31afa28d0e9' , '0x783cca1c0412dd0d695e784568c96da2e9c22ff989357a2e8b1d9b2b4e6b7118')
    ),

    POOLS_ICECREAMSWAP_CREATED_WITH_TOKEN_0_DETAILS AS (
    SELECT
    POOLS.*,
    CONTRACTS.SYMBOL AS TOKEN_0_SYMBOL,
    CONTRACTS.NAME AS TOKEN_0_NAME,
    CONTRACTS.DECIMALS AS TOKEN_0_DECIMALS
    FROM
    POOLS_ICECREAMSWAP_CREATED POOLS
    LEFT JOIN
    Last run: 2 months ago
    TX_HASH
    VERSION
    POOL_ADDRESS
    PAIR
    TOKEN_0_ADDRESS
    TOKEN_0_SYMBOL
    TOKEN_0_DECIMALS
    TOKEN_1_ADDRESS
    TOKEN_1_SYMBOL
    TOKEN_1_DECIMALS
    1
    		0xa67986b9d95f449a6e6c0649cc3568125690ee3c835b50b72fb1c6f8cf2d4670V30xef33af89bad0509b8e25aa37acf72bd599d9e552USDT-EthUSD0x900101d06a7426441ae63e9ab3b9b0f63be145f1USDT60xc6bc19079a0f192c83b99bb5443fb5bb88acf547EthUSD18
    2
    		0xced73e42632e4d8a77ea7eb5aa0cb16dcd7d74fa737060c0a9bde7291db143c1V20xc0272c17e35fa13b84877ee143e06102447b5137USDT-EthUSD0x900101d06a7426441ae63e9ab3b9b0f63be145f1USDT60xc6bc19079a0f192c83b99bb5443fb5bb88acf547EthUSD18
    3
    		0x423ebf18aaff4cdaa7e6e8f39b830d5599a64adbcaec06881fdfc36f52376834V30x807d8a2cb875640b5b046accb7326d58f0122c18UFIVA-FIVA0x333bd0fdafab4d596766e6ab127a54f21b8a2433UFIVA180x33a599de0e343abbedf75c07ed2687678e6ecc33FIVA18
    4
    		0x12a9c0a45648eb5ee05be22648e0b4a0d59649e21852473c5890cfd79dd2e907V20x5dd8f8ff1c322fa7c8b9ec5ce68cead395fb0374WCORE-ANT COIN0x40375c92d9faf44d2f9db9bd9ba41a3317a2404fWCORE180xfbb036a54260799fd03d32f4ab11b17b59428278ANT COIN18
    5
    		0xb2a92ead56061c36d11cf724cf2b081166f5bcfca09a7ea02a2472dc18622029V20xe66aee20f2496c03bd578d7304d02009ee9f08b3WCORE-KAI0x40375c92d9faf44d2f9db9bd9ba41a3317a2404fWCORE180x77e59eac374a5396c98693aae65dd90fde4248d6KAI3
    6
    		0xa013fb3363dfcb2e7aff1355f17cfa95283f8648b19463eee2cb1d33f91bbceaV20xf4e7f56556f4d8168aee960742aee830fc515f8aWCORE-$HAY0x40375c92d9faf44d2f9db9bd9ba41a3317a2404fWCORE180xd698320cd0b571b62e57826d470c2b8d2ff1d04e$HAY18
    7
    		0xb2b6084a82892a8f3a1d3faf4d06706d3b35133826651e843fd63339f3ae965fV20x6cfe6b9d66a0a98bb2a94b85888af27e9cf55310WCORE-Satoshi Perps0x40375c92d9faf44d2f9db9bd9ba41a3317a2404fWCORE180xeaf03a785f402dd4cfab212640657445edd82b82Satoshi Perps18
    8
    		0x66c9dd5094e13f87ec06834ee105f0587856fa8495f360a500ade9faaedbc1d4V20x9279be3c986963e2bcc167b1e7476dbfa951d510WCORE-UCORE0x40375c92d9faf44d2f9db9bd9ba41a3317a2404fWCORE180xfe9c75448e6d067bb058267b403bbd6db4ef8ca8UCORE18
    9
    		0x2478ce15da0313a74a7ecd97bd1ba88a6c31e946c7b081a5e2ad42d2b15fdbcbV20xb80c46d8c802113f35a80613e20a42090fd7c738WCORE-BCH/core0x40375c92d9faf44d2f9db9bd9ba41a3317a2404fWCORE180x6cff5cf7f6f897ae026e431f3cf1123cbbdc59b0BCH/core18
    10
    		0x9e7b0706bb412961b6a4c92805206b57fabb3ddcffb6b61648559794d1d2d2d3V20xd56dc1f47b0a780b0be6ea2037465e1da5eb39e1WCORE-coreBTC0x40375c92d9faf44d2f9db9bd9ba41a3317a2404fWCORE180x75e980f6bd9595a1b66b7dbdac7944aa1845346ccoreBTC18
    11
    		0x34659a8ba22a5f76c3478025ee3cd9e0bca578df8cbba22bd0ed416215808e49V20xae9160c510f68d8e1f9918974dab394ffb192e70USDT-coreBTC0x330de0cfbc590973accbcc13c383f7584c5b0630USDT180x75e980f6bd9595a1b66b7dbdac7944aa1845346ccoreBTC18
    12
    		0xb4c00a8af03ca13031ccec4023e700c42b6e3beafec475a5539686603bb463b6V20x6165f1cef962801ee72b2f0568a1c3d1024cc755WCORE-SQUID0x40375c92d9faf44d2f9db9bd9ba41a3317a2404fWCORE180x45dfb8a42c79405cc9e50925226d6e374549552dSQUID18
    13
    		0xac8889c27840de5a2be8c2c154c8decfdd3942572f22ec19dd6e0e217158bbedV20x4aa43a2c55ee61aaa4608d5552d548f2691c0692WCORE-SH0x40375c92d9faf44d2f9db9bd9ba41a3317a2404fWCORE180x887d60f535501b9eb985694e2b4f9a5823a1377aSH18
    14
    		0xbbc799f64363882a4f59112433186aea0fd2d97f386afc62b5fb04419cc044abV20xad785787d7a20434cc83762c5c45b554a97c04d2WCORE-x3140x40375c92d9faf44d2f9db9bd9ba41a3317a2404fWCORE180xac9db37a1e384bda18ba1c167da1dc5cb3782b81x31418
    15
    		0x88192645b5a5b5ba9cafba27cf5546b290945a5db8c49548885f7214853c33e3V20xfd2f0b2787afd2cbaa505ac5150458c9b80e723dWCORE-Pi Network0x40375c92d9faf44d2f9db9bd9ba41a3317a2404fWCORE180x42d0db9c1575c521d462bf380478a97442304864Pi Network18
    16
    		0x05640054b9699164d0d26d7f11018ea12a2aebe1480d4bb91d70710535abcc8bV20x6e4bd019998f2da99ca8d505689dcbf9e24e0473WCORE-BOMEX0x40375c92d9faf44d2f9db9bd9ba41a3317a2404fWCORE180xca9d732de82de769462ec73faae1910c13437a0eBOMEX18
    17
    		0xbee36d085356f91211aabd846e5b1bed0b49b83275b149c825776a21a19fbebbV20xed1a9e0654e5d60973f31ce3175a5df82f4b9e9dWCORE-PELL0x40375c92d9faf44d2f9db9bd9ba41a3317a2404fWCORE180x7ad67c29e10dd1ee3bf85578d0f16591f87ba6c8PELL18
    18
    		0x36ca2330f4f58f48a22a1f1cbb4eef660b335450f8df2e89c78843ea4e3a19d7V20x531cecbf76d444ce5fdf8b1ca4bfbf3cc9e9468cWCORE-Pixiu0x40375c92d9faf44d2f9db9bd9ba41a3317a2404fWCORE180xb7b2e4dec3dc0e91f8e02cd9d39bfbd11562046bPixiu18
    19
    		0x8846d17f208b77266d69a4741545e0e5cb40bcc97968a499f08923e88e4889f5V20x93f3eb88ee92c29fd68121c1ccc7fdfabda7de01WCORE-Serpent0x40375c92d9faf44d2f9db9bd9ba41a3317a2404fWCORE180x66f43a42d465f978c8e582a712284143ec07381aSerpent18
    20
    		0xe0f24424fb00dcafa114d88ec3b99c573adc1cfb93b3b05df298e7d69c8641d6V20x972daabd25c11407ebc7a21d8ddb75bf748daf14WCORE-MAYO0x40375c92d9faf44d2f9db9bd9ba41a3317a2404fWCORE180x4d1e6f4fcd885cca68fc12a9785edfc194ea7d30MAYO18
    ...
    9274
    2MB
    6s