-- SELECT
-- WEEK,
-- SYMBOL,
-- SUM(AMOUNT_yvBOOST) OVER (PARTITION BY WEEK) as TOTAL,
-- AMOUNT_yvBOOST
-- FROM
SELECT
DATE_TRUNC('Week', B.BLOCK_TIMESTAMP) as WEEK,
A.SYMBOL AS SYMBOL,
SUM(B.AMOUNT_yvBOOST) AS AMOUNT_yvBOOST
-- B.BLOCK_TIMESTAMP,
-- A.TX_ID,
-- B.TX_ID,
-- A.SYMBOL,
-- AMOUNT_yvBOOST
FROM
(SELECT TX_ID, SYMBOL, AMOUNT AS AMOUNT_TOKEN, EVENT_TYPE FROM ethereum.udm_events
WHERE ORIGIN_FUNCTION_SIGNATURE IN ('0x91027c5b', '0x247482ba', '0xcfd7789c') --0x6953dcda0e38b0f57f3629d689b8b9c61cdb19e68eab6009357020761adcdf99
AND TO_ADDRESS = ORIGIN_ADDRESS ) A
RIGHT JOIN
(SELECT BLOCK_TIMESTAMP, TX_ID, AMOUNT AS AMOUNT_yvBOOST FROM ethereum.udm_events
WHERE ORIGIN_FUNCTION_SIGNATURE IN ('0x91027c5b', '0x247482ba', '0xcfd7789c')
AND FROM_ADDRESS = '0x9461173740d27311b176476fa27e94c681b1ea6b' --0x6953dcda0e38b0f57f3629d689b8b9c61cdb19e68eab6009357020761adcdf99
AND CONTRACT_ADDRESS = '0x9d409a0a012cfba9b15f6d4b36ac57a46966ab9a') B on A.TX_ID = B.TX_ID
WHERE SYMBOL <> ''
GROUP BY 1,2
ORDER BY 1 DESC, 3 ASC
-- WHERE A.BLOCK_TIMESTAMP >= getdate() - INTERVAL'1 month'