SniperTop Swap Token Pairs
Updated 2024-06-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
34
35
36
›
⌄
------Credit for Hess
with token_bonk as ( Select VALUE:"DECIMAL" as decimal,
value:"TOKEN_ADDRESS" as token_address,
value:"TOKEN_NAME" as token_name
from (
SELECT livequery.live.udf_api(
'https://flipsidecrypto.xyz/api/v1/queries/afb49a72-5616-4521-bc64-019467ed698b/data/latest') as resp
),LATERAL FLATTEN (input => resp:data)),
------end------------
tbl1 as(
select (t2.token_name)as token_out,
CURRENCY_in,
amount_in,
tx_id,
swapper
from sei.defi.fact_dex_swaps t1
JOIN token_bonk t2 on t2.token_address = t1.CURRENCY_out
),
tbl2 as (select token_out,(t2.token_name)as token_in,
amount_in,
tx_id,
swapper,
-- t2.price
from tbl1 t1
JOIN token_bonk t2 on t2.token_address = t1.CURRENCY_in
)
SELECT concat(token_out,' → ',token_in) as pair_tokens,
count (DISTINCT tx_id) as swaps,
count (DISTINCT swapper) as swappers,
-- sum(amount_in/1e6) as volume_USD
from tbl2
GROUP by 1
ORDER by 2 DESC
QueryRunArchived: QueryRun has been archived