datavortexBonder Tokens
Updated 2024-11-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
SELECT
eob.LP_TOKEN_ADDRESS,
COUNT(DISTINCT eob.tx_hash) AS bonding_events,
CASE
WHEN fpt.lp_token_name IS NULL THEN 'others'
ELSE fpt.lp_token_name
END AS lp_token_name
FROM
crosschain.olas.ez_olas_bonding eob
LEFT JOIN crosschain.olas.fact_pol_transfers fpt ON eob.LP_TOKEN_ADDRESS = fpt.LP_TOKEN_ADDRESS
GROUP BY
eob.LP_TOKEN_ADDRESS,
fpt.lp_token_name
ORDER BY
bonding_events DESC
QueryRunArchived: QueryRun has been archived