MetaLightTOKE DEX METRICS
Updated 2023-08-25
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
›
⌄
-- forked from jackguy / bonk 2 copy @ https://flipsidecrypto.xyz/jackguy/q/afuZTNm1SPxw/bonk-2-copy
-- forked from bonk 2 @ https://flipsidecrypto.xyz/edit/queries/797c71c5-b9c5-4a3b-96f9-0f97c536e1f8
WITH tab1 AS (
SELECT
date_trunc('day', block_timestamp) as the_day,
INITCAP(SPLIT(swap_program, ' ')[0]::string) AS the_dex,
COUNT(DISTINCT
CASE
WHEN swap_from_mint = 'Gmc26GMnhE3AWwdAQpxxsQPo6UYaob4wPRxUpmDsujoX' THEN swapper
ELSE NULL
END) AS unique_sellers,
COUNT(DISTINCT
CASE
WHEN swap_to_mint = 'Gmc26GMnhE3AWwdAQpxxsQPo6UYaob4wPRxUpmDsujoX' THEN swapper
ELSE NULL
END) AS unique_buyers,
COUNT(DISTINCT swapper) AS unique_swappers,
SUM(
CASE
WHEN swap_from_mint = 'Gmc26GMnhE3AWwdAQpxxsQPo6UYaob4wPRxUpmDsujoX' THEN -swap_from_amount
ELSE swap_to_amount
END) AS net_swap_amout,
SUM(
CASE
WHEN swap_from_mint = 'Gmc26GMnhE3AWwdAQpxxsQPo6UYaob4wPRxUpmDsujoX' THEN swap_from_amount
ELSE 0
END) AS swap_from_amount,
SUM(
CASE
WHEN swap_to_mint = 'Gmc26GMnhE3AWwdAQpxxsQPo6UYaob4wPRxUpmDsujoX' THEN swap_to_amount
ELSE 0
END) AS swap_to_amount,
SUM(
CASE
WHEN swap_to_mint = 'Gmc26GMnhE3AWwdAQpxxsQPo6UYaob4wPRxUpmDsujoX' THEN swap_to_amount
Run a query to Download Data