binhachonCurve - Yearn: Zap out function - direct from yvBOOST
Updated 2021-09-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
›
⌄
SELECT
-- 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)
FROM
(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
-- WHERE A.BLOCK_TIMESTAMP >= getdate() - INTERVAL'1 month'