0x_spadeLP on SEI 2024
    Updated 2024-10-03
    SELECT
    DATE_TRUNC('month', block_timestamp) AS Month,
    COUNT(DISTINCT tx_id) AS LP_activity,
    count (distinct LIQUIDITY_PROVIDER_ADDRESS) as n_lps,
    lp_action,
    platform,
    FROM sei.defi.fact_lp_actions
    WHERE block_timestamp::date >= '2024-01-01'
    GROUP BY Month, platform, lp_action
    ORDER BY MONTH asc
    ;
    QueryRunArchived: QueryRun has been archived