shreyash-5873Validator Label Join
Updated 2021-07-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
/* with luna_rewards as (select
date(block_timestamp) as block_date,
event_attributes:validator::string as validator,
l.address_name,
l.label,
l.label_type,
l.label_subtype,
event,
sum(event_attributes:amount[0]:amount / POW(10, 6)) as Daily_LUNA_reward
from terra.transitions t
inner join terra.labels l
on event_attributes:validator::string = l.address
where transition_type = 'end_block'
and event = 'rewards'
and date(block_timestamp) >= CURRENT_DATE() - 31 and date(block_timestamp) < CURRENT_DATE()
group by 1, 2, 3, 4, 5, 6, 7) */
select * from terra.labels limit 100;
Run a query to Download Data