Afonso_Diazosmosis-fees-7
Updated 2023-03-10
9
1
2
3
4
5
6
7
8
9
›
⌄
select
block_timestamp::date as day,
count(distinct tx_id) as lp_actions,
count(distinct liquidity_provider_address) as users,
sum(lp_actions) over (order by day) as cumulative_lp_actions
from osmosis.core.fact_liquidity_provider_actions
where block_timestamp > current_date - interval '{{ months }} months'
group by 1
order by 1
Run a query to Download Data