-- DATE_TRUNC('Week', A.BLOCK_TIMESTAMP),

-- A.CONTRACT_ADDRESS,

-- A.SYMBOL,

-- SUM(A.AMOUNT),

-- SUM(B.AMOUNT)

DATE_TRUNC('Week',BLOCK_TIMESTAMP),

SYMBOL,

--SUM(B.AMOUNT_yvBOOST) AS yvBOOST_AMOUNT

SUM(AMOUNT_TOKEN),

SUM(AMOUNT_yvBOOST)

(SELECT TX_ID, SYMBOL, AMOUNT AS AMOUNT_TOKEN, EVENT_TYPE FROM ethereum.udm_events

WHERE ORIGIN_FUNCTION_SIGNATURE = '0x89c6973b'

AND ORIGIN_ADDRESS = TO_ADDRESS) A

RIGHT JOIN

(SELECT BLOCK_TIMESTAMP, TX_ID, AMOUNT AS AMOUNT_yvBOOST FROM ethereum.udm_events

WHERE ORIGIN_FUNCTION_SIGNATURE = '0x89c6973b'

AND ORIGIN_ADDRESS = FROM_ADDRESS

AND TO_ADDRESS = '0xd6b88257e91e4e4d4e990b3a858c849ef2dfde8c'

AND CONTRACT_ADDRESS = '0x9d409a0a012cfba9b15f6d4b36ac57a46966ab9a') B on A.TX_ID = B.TX_ID

GROUP BY 1,2

ORDER BY 1 DESC,4 DESC