TGC Staking Leaderboard

ZookTGC Staking Leaderboard

Updated 3 hours ago

-- deposit transactions include :

--'Deposit' (to staking contract)

--'Claim and Stake'

--'Buy TGC with ETH and Stake'

--'Buy TGC with USDT and Stake'

--accrued TGC rewards are not included in the Net_TGC_staked result. Similarly, 'claim rewards' are not included in Withdrawals.

WITH deposit_data AS (

SELECT -- deposits

DECODED_LOG:user::STRING AS FROM_ADDRESS, -- Accessing 'user' field from the DECODED_LOG JSON object

SUM(DECODED_LOG:amount::NUMBER) / 1E18 AS total_deposits_staking -- Accessing 'amount' field

FROM ethereum.core.ez_decoded_event_logs -- UPDATED TABLE NAME

WHERE

BLOCK_TIMESTAMP > '2023-01-01 09:00:47.000'

AND

(lower(CONTRACT_ADDRESS) = lower('0x0916568854Fc53B720186052d8013D62A0409b47')

OR lower(CONTRACT_ADDRESS) = lower('0x258c3104388f8cd72c8b4336fc536033e6db764e')

OR lower(CONTRACT_ADDRESS) = lower('0x21d6D6d6FFD8b68e94bf5159Bb029635Af540aE8')

)

AND EVENT_NAME = 'Deposit'

GROUP BY FROM_ADDRESS

withdrawal_data AS (

SELECT

DECODED_LOG:user::STRING AS TO_ADDRESS, -- Accessing 'user' field from the DECODED_LOG JSON object

SUM(DECODED_LOG:amount::NUMBER) / 1E18 AS total_withdrawals_unstaking -- Accessing 'amount' field

FROM ethereum.core.ez_decoded_event_logs -- UPDATED TABLE NAME

WHERE

BLOCK_TIMESTAMP > '2023-01-01 09:00:47.000'

AND

(lower(CONTRACT_ADDRESS) = lower('0x0916568854Fc53B720186052d8013D62A0409b47')

OR lower(CONTRACT_ADDRESS) = lower('0x258c3104388f8cd72c8b4336fc536033e6db764e')

OR lower(CONTRACT_ADDRESS) = lower('0x21d6D6d6FFD8b68e94bf5159Bb029635Af540aE8')

)

Last run: about 3 hours agoAuto-refreshes every 24 hours

...

4391

214KB

291s

flipside