purifvalidators incentives
Updated 2024-09-14
999
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
›
⌄
⌄
with
--incentive tokens list, mostly important for decimals
tokens as (
SELECT token , address, decimals, price
FROM (
VALUES
('HONEY','0x0e4aaf1351de4c0264c5c7056ef3777b41bd8e03',1e18, 1),
('WBERA','0x7507c1dc16935b82698e4c63f2746a2fcf994df8',1e18, 25),
('USDC','0xd6D83aF58a19Cd14eF3CF6fe848C9A4d21e5727c',1e6,1),
('wBTC','0x2577D24a26f8FA19c1058a8b0106E2c7303454a4',1e8,750000)
) AS X(token , address,decimals, price)
),
bex_pricing_data as (select
value:BASE_TOKEN as base_token
, value:QUOTE_TOKEN as quote_token
, value:PRICE as price
, value:HOURLY_CHANGE_PAST_24H as hourly_change_past_24h
from (
select
live.udf_api('https://flipsidecrypto.xyz/api/v1/queries/8b2f7a19-c488-43b3-8e00-bdd895aac842/data/latest') as resp
), lateral flatten (input => resp:data)
),
--get all reward vaults created, returns deposit token and vault address
vaults as (select concat('0x',substr(TOPICS[1], 27,64)) as staking_token, concat('0x',substr(TOPICS[2], 27,64)) as vault_address from berachain.testnet.fact_event_logs
where topics[0]='0x5d9c31ffa0fecffd7cf379989a3c7af252f0335e0d2a1320b55245912c781f53'
and contract_address=lower('0x2b6e40f65d82a0cb98795bc7587a71bfa49fbb2b')),
--get list of currently whitelisted incentives for each reward vaults
--can be used to compare with tokens list above
--up to 3 different incentive tokens per vault
-- TODO : add removed ones to make sure list is correct
/*whitelisted_incentives as (
select contract_address as vault, concat('0x',substr(TOPICS[1], 27,64)) as incentive_token from berachain.testnet.fact_event_logs
where CONTRACT_ADDRESS in (select vault_address from vaults)
and topics[0]='0xa975f951c4e6314e31b3e4d9a56f84e05e0bf0d4a1e512caab2f9cc0a2494132'
),*/
QueryRunArchived: QueryRun has been archived