farokhtiabMy Terra Delegation Transaction
Updated 2022-07-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- isolate on that day, pick out your transactions
select
date_trunc('day',block_timestamp) as blook_day,
date_trunc('hour',block_timestamp) as blook_hour,
case
when delegator_address = 'terra1ft94vtqpnh9q7agzxlnkjk7gtrrmeth2ev8f29' then 'me'
else 'everyone else' end as delegator,
count(*) as transactions,
sum(event_amount_usd) as amount
from terra.staking
where
validator_address_name = 'terravaloper1r843mpk5zzkfgtnduskd0dzgeltv0n503ckzy6'
-- and date_trunc('day',block_timestamp) > CURRENT_DATE - 14
and date_trunc('day',block_timestamp) = '2022-01-13 00:00:00.000'
group by 1, 2, 3
order by 4 desc
-- find the day you delegated
-- select
-- date_trunc('day',block_timestamp) as blook_day,
-- case
-- when delegator_address = 'terra1ft94vtqpnh9q7agzxlnkjk7gtrrmeth2ev8f29' then 'me'
-- else 'everyone else' end as delegator,
-- count(*) as transactions,
-- sum(event_amount_usd) as amount
-- from terra.staking
-- where
-- validator_address_name = 'terravaloper1r843mpk5zzkfgtnduskd0dzgeltv0n503ckzy6'
-- and date_trunc('day',block_timestamp) > CURRENT_DATE - 14
-- group by 1, 2
-- order by 4 desc
Run a query to Download Data