with tab1 AS

(select

BLOCK_TIMESTAMP:: date as day,

SYMBOL,

sum(CURRENT_BAL) as "circulating supply"

from ethereum.core.ez_balance_deltas

where

CONTRACT_ADDRESS = lower('0x7D1AfA7B718fb893dB30A3aBc0Cfc608AaCfeBB0')

and USER_ADDRESS not

in ('0x50d669f43b484166680ecc3670e4766cdb0945ce', '0xcbfe11b78c2e6cb25c6eda2c6ff46cd4755c8fca',

'0xb316fa9fa91700d7084d377bfdc81eb9f232f5ff', '0xccb04768f3abcf1af1e749085ef67d8ec7c5fdd2','0x5e3ef299fddf15eaa0432e6e66473ace8c13d908')

and day >= '2022-07-01'

group by 1 , 2

),

tab2 as

(

select

day ,

sum("amount") as "MATIC stake amount"

from

date_trunc(day,BLOCK_TIMESTAMP) as day ,

'Stader' as "name",

COUNT(DISTINCT TX_HASH ) AS "STAKE COUNT ",

sum(raw_amount/1e18) as "amount",

sum(AMOUNT_USD) as "USD amount"

from ethereum.core.ez_token_transfers

where from_address = '0x0000000000000000000000000000000000000000'

and CONTRACT_ADDRESS = '0xf03a7eb46d01d9ecaa104558c732cf82f6b6b645'

and day >= '2022-07-01'

group by 1