Afonso_Diaz2023-04-01 09:08 AM
Updated 2023-04-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
-- select
-- tx_id,
-- block_timestamp,
-- block_id,
-- delegator_address as user,
-- count(distinct validator_address) as validators
-- from osmosis.core.fact_staking a
-- where action = 'delegate'
-- and tx_succeeded = 1
-- and not exists (select * from osmosis.core.fact_staking_rewards b where a.tx_id = b.tx_id)
-- and block_timestamp >= '2023-03-01' and block_timestamp < '2023-03-16'
-- group by 1, 2, 3, 4
-- having validators >= 2
select
distinct action
from osmosis.core.fact_staking_rewards
where tx_id = '1A8D9C4F3F44FE4B356222C88DB424CC200A4CCA11D7A0AD50DA4B03F2E641EA'
Run a query to Download Data