maybeyonastest_lorenz
    Updated 2021-12-08
    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