boomer77anc claim
Updated 2022-02-09
9
1
2
3
4
5
›
⌄
select date_trunc('day', block_timestamp) as dt, sum(claim_1_amount) as ANC_claimed, sum(claim_1_amount_usd) as anc_claimed_usd, count(distinct tx_id) as tx_count,
count(distinct sender) as claimer_count, avg(claim_1_amount) as average_anc_claimed
from anchor.reward_claims
where block_timestamp between '2022-01-01' and '2022-01-31'
group by 1
Run a query to Download Data