Popex404Memecoin Pool data
Updated 2023-05-16
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
›
⌄
select
distinct
contract_Address as pool_main_contract_address,
token_in,
token_out,
Case
when token_in = '0x3301ee63fb29f863f2333bd4466acb46cd8323e6' then '$AKITA' -- AKITA
when token_in = '0x95ad61b0a150d79219dcf64e1e6cc01f0b64c4ce' then '$SHIB' -- SHIB
when token_in = '0x12970e6868f88f6557b76120662c1b3e50a646bf' then '$LADYS' -- LADYS
when token_in = '0xcf0c122c6b73ff809c693db761e7baebe62b6a2e' then '$FLOKI' -- FLOKI
when token_in = '0x5026F006B85729a8b14553FAE6af249aD16c9aaB' then '$WOJAK' -- WOJAK
when token_in = '0x6982508145454ce325ddbe47a25d4ec3d2311933' then '$PEPE' -- PEPE
end as memesymbol_IN_contract_address,
Case
when token_out = '0x3301ee63fb29f863f2333bd4466acb46cd8323e6' then '$AKITA' -- AKITA
when token_out = '0x95ad61b0a150d79219dcf64e1e6cc01f0b64c4ce' then '$SHIB' -- SHIB
when token_out = '0x12970e6868f88f6557b76120662c1b3e50a646bf' then '$LADYS' -- LADYS
when token_out = '0xcf0c122c6b73ff809c693db761e7baebe62b6a2e' then '$FLOKI' -- FLOKI
when token_out = '0x5026F006B85729a8b14553FAE6af249aD16c9aaB' then '$WOJAK' -- WOJAK
when token_out = '0x6982508145454ce325ddbe47a25d4ec3d2311933' then '$PEPE' -- PEPE
end as memesymbol_OUT_contract_address,
pool_name,
coalesce(memesymbol_IN_contract_address,'Other')|| ' ↔ ' || coalesce(memesymbol_OUT_contract_address,'Other'),
platform
from ethereum.core.ez_dex_swaps
where token_in in
( '0x3301ee63fb29f863f2333bd4466acb46cd8323e6' -- AKITA
, '0x95ad61b0a150d79219dcf64e1e6cc01f0b64c4ce' -- SHIB
, '0x12970e6868f88f6557b76120662c1b3e50a646bf' -- LADYS
, '0xcf0c122c6b73ff809c693db761e7baebe62b6a2e' -- FLOKI
, '0x5026F006B85729a8b14553FAE6af249aD16c9aaB' -- WOJAK
, '0x6982508145454ce325ddbe47a25d4ec3d2311933') -- PEPE
or token_in in
( '0x3301ee63fb29f863f2333bd4466acb46cd8323e6' -- AKITA
, '0x95ad61b0a150d79219dcf64e1e6cc01f0b64c4ce' -- SHIB
, '0x12970e6868f88f6557b76120662c1b3e50a646bf' -- LADYS
Run a query to Download Data