feyikemi$GHST 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
DATE_TRUNC('week', block_timestamp) AS week,
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
)
GROUP BY 1
),
unstaked_ghst AS (
SELECT
DATE_TRUNC('week', block_timestamp) AS week,
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
)
GROUP BY 1
),
net_staked_ghst AS (
SELECT
COALESCE(s.week, u.week) AS week,
COALESCE(s.total_staked, 0) - COALESCE(u.total_unstaked, 0) AS net_total_staked
QueryRunArchived: QueryRun has been archived