TGC Staking Leaderboard

ZookTGC Staking Leaderboard

Updated 16 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,

SUM(decoded_log:amount::NUMBER) / 1E18 AS total_deposits_staking

FROM ethereum.core.fact_decoded_event_logs

WHERE

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

AND

(CONTRACT_ADDRESS = lower('0x0916568854Fc53B720186052d8013D62A0409b47')

OR CONTRACT_ADDRESS = lower('0x258c3104388f8cd72c8b4336fc536033e6db764e'))

AND EVENT_NAME = 'Deposit'

GROUP BY FROM_ADDRESS

withdrawal_data AS (

SELECT

decoded_log:user::STRING AS TO_ADDRESS,

SUM(decoded_log:amount::NUMBER) / 1E18 AS total_withdrawals_unstaking

FROM ethereum.core.fact_decoded_event_logs

WHERE

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

AND

(CONTRACT_ADDRESS = lower('0x0916568854Fc53B720186052d8013D62A0409b47')

OR CONTRACT_ADDRESS = lower('0x258c3104388f8cd72c8b4336fc536033e6db764e'))

AND EVENT_NAME = 'Withdraw'

GROUP BY TO_ADDRESS

)

SELECT

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

...

4352

213KB

54s

flipside