0x_spadeLP on SEI 2024
Updated 2024-10-03
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
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