SniperDaily Mint Volume of Matic Liquid Staking Token
    Updated 2022-09-21
    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