CryptoIcicleOsmosis One Year Anniversary
Updated 2022-06-23
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
›
⌄
-- Payout 94.78 OSMO
-- Grand Prize 284.33 OSMO
-- Level Intermediate
-- What did the users who received the initial airdrop of OSMO do with their tokens?
-- Create a visual that shows how many sold, staked, LPed, swapped, and held.
-- How many individuals who received the airdrop still hodl their OSMO one year later?
with airdrop as (
select
receiver as wallet,
sum(amount)/1e6 as airdrop_amount
from osmosis.core.fact_airdrop
where currency = 'uosmo'
group by wallet
),
swappers as (
select
trader as wallet,
sum(from_amount)/1e6 as swapped_amount
from osmosis.core.fact_swaps s join airdrop a on s.trader = a.wallet
where from_currency = 'uosmo'
group by trader
),
stakers as (
select
delegator_address as wallet,
sum(amount)/1e6 as staked_amount
from osmosis.core.fact_staking s join airdrop a on s.delegator_address = a.wallet
where currency = 'uosmo'
group by delegator_address
),
lpers as (
select
liquidity_provider_address as wallet,
sum(amount)/1e6 as lped_amount
Run a query to Download Data