winnie-fsWHALE Claimers copy
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
-- forked from 5a15a27f-99a3-4695-a956-5d576ea3b982
select
date_trunc('hour', block_timestamp) as date,
count(distinct tx_id) as claim_count,
sum(claim_count) over (order by date) as cumulative_claims,
sum(amount)/1000000 as amount_claimed,
sum(amount_claimed) over (order by date) as cumulative_amount
from
terra.core.ez_transfers
where
sender = 'terra1qdg94xw7vru5x57zf0gsjak7qzq46kptfm6y0s8ypsx3aqn9h7ts4p406e'
group by 1
order by 1 desc
Run a query to Download Data