SniperDaily Mint Volume of Matic Liquid Staking Token
Updated 2022-09-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
WITH Staking_Token As(Select
Count(DISTINCT origin_from_address) as Count_Users,
Count(DISTINCT tx_hash) as Count_Events,
Sum(RAW_AMOUNT / power(10, 18)) as Sm_Volume ,
Date_trunc('Week', block_timestamp) as Week_Dt,
DECODE(contract_address,
lower('0x3aD736904E9e65189c3000c7DD2c8AC8bB7cD4e3') , 'MATICx',
lower('0x3A58a54C066FdC0f2D55FC9C89F0415C92eBf3C4'),'stMATIC',
lower('0x7ed6390f38d554B8518eF30B925b46972E768AF8') , 'csMATIC') As Token_Address
From polygon.core.fact_token_transfers
Where
from_address Like '0x0000000000000000000000000000000000000000'
And contract_address In (
lower('0x3aD736904E9e65189c3000c7DD2c8AC8bB7cD4e3'),
lower('0x3A58a54C066FdC0f2D55FC9C89F0415C92eBf3C4'),
lower('0x7ed6390f38d554B8518eF30B925b46972E768AF8'))
Group By Week_Dt,Token_Address
Order By Week_Dt,Token_Address)
Select Week_Dt,Token_Address,Count_Users,Count_Events,Sm_Volume from Staking_Token
Run a query to Download Data