CryptoIcicleOsmosis - 1. Osmosis & Stride - LP Actions
Updated 2023-02-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- How has Stride's LSD stOSMO impacted validators in the active set? Track the impact of undelegations & transfers to Stride.
-- Which validators were the most impacted by stOSMO? Have the validators most impacted by undelegation received ample delegations from the Stride ICA?
-- How has Strides ICA staking activity increased/decreased decentralization across the active set?
-- Basis of Payment:
-- To be eligible for payment.
-- The submission must be sent before the deadline indicated on the bounty page.
-- The submission must score a minimum of 6 points according to the Evaluation Criteria.
-- 💰 Payout
-- Rank Based Payout
-- Payout is in OSMO and xMETRIC, where the top eligible scorers are paid the amounts below.
-- Only the top 5 submissions are eligible for payout, and Submissions must have a score of 10 or higher to be eligible for payout, and only the top 5 are paid!
-- If there are not enough eligible submissions for a category, remaining funds will either be paid to lower tier submissions
-- or reserved for future bounty programs. Final determination of payouts and rankings are at the discretion of the MetricsDAO Bounty Operations Team.
-- OSMO Payouts:
-- Rank OSMO amount
-- 1st Rank 425 USD worth of OSMO
-- 2st Rank 250 USD worth of OSMO
-- 3rd Rank 150 USD worth of OSMO
-- 4th Rank 100 USD worth of OSMO
-- 5th Rank 75 USD worth of OSMO
-- SQL Credit: https://app.flipsidecrypto.com/velocity/queries/1b22de17-3a59-4ddd-ab06-ca93fc3d47ee
SELECT
date_trunc('{{date_range}}',block_timestamp) as date,
concat("ACTION",'::',iff(pool_id[0]=803, 'stATOM/ATOM','stOSMO/OSMO')) as type,
count(distinct liquidity_provider_address) as n_wallets,
count(distinct tx_id) as n_transfers,
sum(iff("ACTION" = 'lp_tokens_burned', -1 * amount/pow(10,decimal), amount/pow(10,decimal))) as osmo_volume,
sum(n_wallets) over (partition by type order by date asc rows between unbounded preceding and current row) as cum_n_wallets,
sum(n_transfers) over (partition by type order by date asc rows between unbounded preceding and current row) as cum_n_transfers,
sum(osmo_volume) over (partition by type order by date asc rows between unbounded preceding and current row) as cum_osmo_volume,
sum(osmo_volume) over (order by date asc rows between unbounded preceding and current row) as net_osmo_volume
from osmosis.core.fact_liquidity_provider_actions
Run a query to Download Data