0xC2eAf96831Cd62f8dC3B85674D749154F205562cWido JediSwap TVL
Updated 2023-10-02
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
›
⌄
SELECT
TOKEN_ADDRESS,
AMOUNT_USD
FROM
(
SELECT
e1.CONTRACT as TOKEN_ADDRESS,
COALESCE(SUM(e1.PARAMETERS [2] :value [0] :value), 0) as AMOUNT,
case
when e1.CONTRACT = '0x068f5c6a61780768455de69077e07e89787839bf8166decfbf92b645209c0fb8' then 1 / POW(10, 6) -- USDT
when e1.CONTRACT = '0x00da114221cb83fa859dbdb4c44beeaa0bb37c7537ad5ae66fe5e0efd20e6eb3' then 1 / POW(10, 18) -- DAI
when e1.CONTRACT = '0x03fe2b97c1fd336e750087d68b9b867997fd64a2661ff3ca5a7c771641e8e7ac' then 26000 / POW(10, 8) -- WBTC
when e1.CONTRACT = '0x049d36570d4e46f48e99674bd3fcc84644ddd6b96f7c741b1562b82f9e004dc7' then 1670 / POW(10, 18) -- ETH
when e1.CONTRACT = '0x077c9e85c7d7a79009880b1aad66c70b40c3e90adfd3200aeb790c909ae4ee91' then 0 -- STRK
when e1.CONTRACT = '0x053c91253bc9682c04929ca02ed00b3e423f6710d2ee7e0d5ebb06f3ecf368a8' then 1 / POW(10, 6) -- USDC
else 0
end as usd_multiplier,
usd_multiplier * AMOUNT as AMOUNT_USD
FROM
external.tokenflow_starknet.decoded_events as e1
JOIN external.tokenflow_starknet.decoded_events as e2 ON e2.TX_HASH = e1.TX_HASH
WHERE
e1.NAME = 'Transfer'
AND (
e1.PARAMETERS [0] :value = '0x7ee4864babdb42fb752870241a8613b28b575b159cab931ce71c10de31be070'
OR e1.PARAMETERS [1] :value = '0x7ee4864babdb42fb752870241a8613b28b575b159cab931ce71c10de31be070'
)
AND e2.PARAMETERS [4] ['value'] = '0x18aa467e40e1defb1956708830a343c1d01d3d7c'
GROUP BY
e1.CONTRACT
)
ORDER BY
AMOUNT_USD DESC
Run a query to Download Data