STAKING_CONTRACT | PARTICIPANTS | |
|---|---|---|
1 | Pearl Beta 5 | 91 |
2 | Pearl Beta 3 | 20 |
3 | Pearl Beta 4 | 19 |
4 | Pearl Beta 1 | 376 |
5 | Pearl Beta 2 | 127 |
6 | Pearl Beta 6 | 98 |
Flipside TeamBeta Pearl total contracts
Updated 8 days ago
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
›
⌄
with pearl_beta as (
-- beta Pearl
select
BLOCK_TIMESTAMP,
tx_hash,
CONTRACT_ADDRESS,
concat('0x',substring(topics[3], 26+1, 40)) AS multisig,
concat('0x',substring(topics[2], 26+1, 40)) AS owner,
ethereum.public.udf_hex_to_int(TOPICS[1])::float as serviceId,
row_number() OVER (partition BY serviceId order by BLOCK_TIMESTAMP desc) as r_no
from gnosis.core.fact_event_logs
where (CONTRACT_ADDRESS = lower('0xeF44Fb0842DDeF59D37f85D61A1eF492bbA6135d')
OR contract_address = lower('0x1c2F82413666d2a3fD8bC337b0268e62dDF67434')
OR contract_address = lower('0xbd59ff0522aa773cb6074ce83cd1e4a05a457bc1')
OR contract_address = lower('0x3052451e1eaee78e62e169afdf6288f8791f2918')
OR contract_address = lower('0x4abe376fda28c2f43b84884e5f822ea775dea9f4')
OR contract_address = lower('0x6c6d01e8ea8f806ef0c22f0ef7ed81d868c1ab39')
)
and TOPICS[0] = '0xaa6b005b4958114a0c90492461c24af6525ae0178db7fbf44125ae9217c69ccb'
),
last_staked_beta as (
select
*
from
pearl_beta
where
r_no = 1
)
select
case
when CONTRACT_ADDRESS = lower('0xeF44Fb0842DDeF59D37f85D61A1eF492bbA6135d') then 'Pearl Beta 1'
when CONTRACT_ADDRESS = lower('0x1c2F82413666d2a3fD8bC337b0268e62dDF67434') then 'Pearl Beta 2'
when CONTRACT_ADDRESS = lower('0xbd59ff0522aa773cb6074ce83cd1e4a05a457bc1') then 'Pearl Beta 3'
Last run: 8 days ago
6
123B
22s