feyikemi2024-05-25 01:24 PM
Updated 2024-05-25
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
TO_ADDRESS AS staking_Address,
AMOUNT_USD 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
)
UNION ALL
SELECT
FROM_ADDRESS AS staking_Address,
AMOUNT_USD*(-1) AS total_staked
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
)
)
SELECT
SUM(total_staked) AS total_staked_ghst
FROM
staked_ghst;
QueryRunArchived: QueryRun has been archived