strawbettyAmount that left to distribute
Updated 2022-05-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
›
⌄
with claim as (select
count(distinct EVENT_INPUTS:account) claimers,
sum(EVENT_INPUTS:amount/1e18) amount_distributed
from
ethereum_core.fact_event_logs
where contract_address = lower('0x1026cbed7b7E851426b959BC69dcC1bf5876512d')
and block_timestamp >= '2021-09-24'
and EVENT_NAME = 'Claimed' ),
total as (SELECT
count(distinct address) farmers,
sum(amount) amount_left
from ethereum_sushi.dim_distributor_reward_schedule
where merkle_root = '0x015e6c2cd1a4d6fa77aa1884c436b2435aae4beab5c9a091f18fd0c00dc7e577')
select
claim.claimers,
total.farmers,
claim.claimers/total.farmers * 100 user_percent_claimed,
claim.amount_distributed,
total.amount_left ,
(claim.amount_distributed/(total.amount_left + claim.amount_distributed )) * 100 amount_percent_distributed
from claim,total
Run a query to Download Data