CryptoLionUntitled Query
Updated 2021-11-11
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
›
⌄
-- WITH val as (
-- SELECT DISTINCT
-- label,
-- vp_address as address,
-- delegator_address as del,
-- operator_address as op,
-- last_value(voting_power) over (partition by address ORDER BY block_timestamp) as voting_power
-- FROM terra.validator_voting_power
-- INNER JOIN terra.validator_labels vl on vl.vp_address = address
-- WHERE block_timestamp >= getdate() - interval '1 day'
-- ORDER BY 5 DESC
-- LIMIT 5
-- )
SELECT
event_attributes:delegator
FROM terra.msg_events
WHERE tx_id = '1094FB88CC7C328A8FB28EF21F119C01ACCC01E696A77782665B655BC857F41A'
LIMIT 1
-- SELECT DISTINCT
-- date_trunc('day',block_timestamp) as day,
-- val.label,
-- last_value(vp.voting_power) over (partition by vp.address ORDER BY block_timestamp) as voting_power
-- FROM terra.validator_voting_power vp
-- INNER JOIN val on val.address = vp.address
-- WHERE block_timestamp >= getdate() - interval '2 months'
Run a query to Download Data