permaryLoyalty scores
Updated 2024-10-28
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT
swapper,
platform,
(COUNT(tx_hash) * 0.5 + COUNT(DISTINCT date_trunc('month', block_timestamp)) * 0.3 + 1 / COUNT(DISTINCT platform) * 0.2) AS loyalty_score
FROM
aptos.defi.ez_dex_swaps
WHERE
block_timestamp BETWEEN DATEADD(month, -3, CURRENT_DATE()) AND CURRENT_DATE()
GROUP BY
swapper, platform
QueryRunArchived: QueryRun has been archived