SELECT block_timestamp::DATE AS DAY,

SUM(amount) AS "Staked Matic Amount",

SUM(amount_usd) AS "Staked USD Amount"

FROM ethereum.core.ez_token_transfers

WHERE to_address = '0x5e3ef299fddf15eaa0432e6e66473ace8c13d908'

AND from_address <> '0x0000000000000000000000000000000000000000'

AND block_timestamp::DATE >= '2022-07-01'

GROUP BY 1

),

unstake_txs AS (

SELECT block_timestamp::DATE AS DAY,

SUM(amount) AS "Ustaked MATIC",

SUM(amount_usd) AS "Ustake in USD"

FROM ethereum.core.ez_token_transfers

WHERE from_address = '0x5e3ef299fddf15eaa0432e6e66473ace8c13d908'

AND block_timestamp::DATE >= '2022-07-01'

GROUP BY 1

SELECT s.DAY, "Staked Matic Amount", "Staked USD Amount", -"Ustaked MATIC", -"Ustake in USD"

FROM stake_txs s

LEFT JOIN unstake_txs u

ON s.DAY = u.DAY

ORDER BY 1