feyikemi$GHST Total Staked
Updated 2024-09-20
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 staked_ghst AS (
SELECT
SUM(amount) AS total_staked
FROM
polygon.core.ez_token_transfers
WHERE
contract_address = LOWER('0x385eeac5cb85a38a9a07a70c73e0a3271cfb54a7') -- $GHST Token Contract Address
AND to_address IN (
LOWER('0xA02d547512Bb90002807499F05495Fe9C4C3943f'), -- stkGHST-QUICK Address
LOWER('0x04439eC4ba8b09acfae0E9b5D75A82cC63b19f09'), -- stkGHST-USDC Address
LOWER('0xccb9d2100037f1253e6c1682adf7dc9944498aff'), -- GHST-WETH Liquidity Pool
LOWER('0x1fE64677Ab1397e20A1211AFae2758570fEa1B8c') -- GLTR Staking Address
)
),
unstaked_ghst AS (
SELECT
SUM(amount) AS total_unstaked
FROM
polygon.core.ez_token_transfers
WHERE
contract_address = LOWER('0x385eeac5cb85a38a9a07a70c73e0a3271cfb54a7') -- $GHST Token Contract Address
AND from_address IN (
LOWER('0xA02d547512Bb90002807499F05495Fe9C4C3943f'), -- stkGHST-QUICK Address
LOWER('0x04439eC4ba8b09acfae0E9b5D75A82cC63b19f09'), -- stkGHST-USDC Address
LOWER('0xccb9d2100037f1253e6c1682adf7dc9944498aff'), -- GHST-WETH Liquidity Pool
LOWER('0x1fE64677Ab1397e20A1211AFae2758570fEa1B8c') -- GLTR Staking Address
)
),
net_staked_ghst AS (
SELECT
COALESCE(SUM(total_staked), 0) - COALESCE(SUM(total_unstaked), 0) AS net_total_staked
FROM
staked_ghst,
unstaked_ghst
),
QueryRunArchived: QueryRun has been archived