maybeyonastest_lorenz
Updated 2021-12-08
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
›
⌄
with zapin as(
select
msg_value:coins[0]:amount/pow(10,6) as vector,
msg_value:sender as sender
from terra.msgs
where
tx_status = 'SUCCEEDED'
and msg_value:contract::string = 'terra1leadedadm2fguezmd4e445h6fe337yzq8n2dxf'
and msg_value:execute_msg:zap_into_strategy:strategy_id is not null
),
today_bal as (
select
sender,
sum(vector) as balance
from zapin --redeems
-- where sender = 'terra1jse8nzxu5uf9tq5m4rw9v0hhqcfutahay6zj74'
group by 1
),
sum_bal as (
select
balance as round,
sum(balance) as balance_sum,
count(sender) as users
from today_bal
where balance > 0
group by 1
),
total_users as (
select sum(users) as t_users from sum_bal
),
cum_bal as (
select
round((sum(users) over (order by round rows between unbounded preceding and current row))*1000/t_users,-1) as users,
sum(balance_sum) over (order by round rows between unbounded preceding and current row) as t_bal
from sum_bal join total_users
)
Run a query to Download Data