CryptoIcicleOlympusDAO - 7. Olympus Pro Bonding
Updated 2022-04-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
-- How many distinct addresses have carried out a bond transaction in the last three months?
-- During this period, show the distribution of addresses based on the number of different tokens they have bonded.
-- (e.g. how many address have bonded 1 type of token, how many have bonded 2 types, etc)
select
block_timestamp::date as date,
from_address_name as type,
count(distinct origin_address) as n_users,
sum(n_users) over (partition by type order by date asc rows between unbounded preceding and current row) as cum_n_users
from ethereum.udm_events
where from_address_name like 'olympusdao%bond%'
and block_timestamp >= CURRENT_DATE - 90
and symbol = 'OHM'
group by date, type
Run a query to Download Data