winnie-fs2023-03-09 03:05 PM
Updated 2023-03-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
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