0xPrzUnique $MATIC Stakers
Updated 2022-09-22Copy Reference Fork
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
›
⌄
-- Define what liquid staking is in your words, and evaluate the different liquidity staking options based on three different metrics of your choice.
-- Pay by Quality
-- Your score determines your final payout.
-- Grand Prize 112.5 USDC (A score of 11 or 12 earns you a Grand Prize title)
-- Payout 75 USDC
-- Score Multiplier0-7 : 0% 8 : 50% 9 : 75% 10 : 100% 11 : 125% 12 : 150%
-- Payout Network Ethereum
-- Level Intermediate
-- Difficulty Hard
-- Define what liquid staking is in your words, and evaluate the different liquidity staking options based on three different metrics of your choice.
-- Bonus: How do people use these "liquid" derivatives? Do you see any trends?
-- Reference: https://blog.polygon.technology/defiforall-introduction-to-liquid-staking-on-polygon/“it
with txns as (
select
case contract_address
when '0x03a97594aa5ece130e2e956fc0ced2fea8ed8989' then 'aMATICb Ankr'
when '0x3a58a54c066fdc0f2d55fc9c89f0415c92ebf3c4' then 'stMATIC Lido'
when '0x7ed6390f38d554b8518ef30b925b46972e768af8' then 'csMATIC ClayStack'
when '0x3ad736904e9e65189c3000c7dd2c8ac8bb7cd4e3' then 'MaticX Stader'
end as token,
*
from polygon.core.fact_token_transfers
where contract_address in (
'0x03a97594aa5ece130e2e956fc0ced2fea8ed8989', --aMATICb Ankr
'0x3a58a54c066fdc0f2d55fc9c89f0415c92ebf3c4', --stMATIC Lido
'0x7ed6390f38d554b8518ef30b925b46972e768af8', --csMATIC ClayStack
'0x3ad736904e9e65189c3000c7dd2c8ac8bb7cd4e3' --MaticX Stader
)
and from_address = '0x0000000000000000000000000000000000000000'
)
select
date_trunc('{{date_range}}',block_timestamp) as date,
Run a query to Download Data