DB_V2 Claimers
Updated 2023-11-14
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 v2_claim_count,
sum(v2_claim_count) over (order by date) as cumulative_v2_claims,
sum(amount)/1000000 as amount_v2_claimed,
sum(amount_v2_claimed) over (order by date) as v2_cumulative_amount
from
terra.core.ez_transfers
where
sender = 'terra1un27xdwxcdt44xgeez7r5ysmc53tmfzyr7km0ydecqj7h5cuxcus5qk5uz'
group by 1
order by 1 desc
Run a query to Download Data