permaryLoyalty scores
    Updated 2024-10-28
    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