Yousefi_1994Liquidity Pools Details
Updated 2025-02-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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