staking as (

SELECT

date_trunc('hour', b.block_timestamp) AS date,

sum( b.AMOUNT) AS stak_amount ,

sum (b.AMOUNT_USD) AS stak_usd_amount

FROM polygon.core.dim_labels h

INNER JOIN polygon.core.ez_matic_transfers b ON

h.ADDRESS = b.MATIC_TO_ADDRESS

WHERE BLOCK_TIMESTAMP >= '2022-07-01'

AND ADDRESS_NAME LIKE '%stak%'

AND LABEL_SUBTYPE = 'pool'

GROUP BY 1

ORDER BY 1

),

normal AS (

SELECT

sum(b.AMOUNT ) AS normal_amount,

sum (b.AMOUNT_USD) AS normal_usd_amount ,

date_trunc('hour', b.block_timestamp) AS date

FROM polygon.core.dim_labels h

INNER JOIN polygon.core.ez_matic_transfers b ON

h.ADDRESS = b.MATIC_TO_ADDRESS

WHERE BLOCK_TIMESTAMP >= '2022-07-01'

AND not ADDRESS_NAME LIKE '%stak%'

AND h.LABEL_TYPE = 'dex'

GROUP BY date

ORDER BY date

SELECT c.date , c.stak_usd_AMOUNT ,d.normal_usd_AMOUNT

FROM staking c

LEFT JOIN normal d

ON c.date = d.date

ORDER BY c.date ASC