nitsAnchor Borrows Claim
Updated 2022-02-10
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
with borrow_details as (select block_Timestamp, sender, amount, AMOUNt_usd, currency from anchor.borrows),
staking_details as (select block_Timestamp, sender, amount, AMOUNt_usd, currency from anchor.gov_staking ),
deposit_details as (select block_timestamp , sender, deposit_amount, deposit_AMOUNt_usd, deposit_currency from anchor.deposits)
select date(block_timestamp) as day, count(DISTINCT sender) as unique_senders , sum(claim_0_amount_usd+claim_1_amount_usd) as total_claim, sum(total_claim) over (order by day) as cumulative_claim from anchor.reward_claims
where sender in
(select sender from borrow_details
where sender not in (select sender from staking_details)
and sender not in (select sender from deposit_details))
GROUP by 1
order by 1
limit 1000
Run a query to Download Data