binhachonCurve - Yearn: Zap in function - direct to yvBOOST - express by number of 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', B.BLOCK_TIMESTAMP) as WEEK,
CASE WHEN A.SYMBOL IS NULL THEN 'yveCRV'
ELSE A.SYMBOL END AS SYMBOL,
SUM(B.AMOUNT_yveCRV) AS yveCRV_AMOUNT
FROM
(SELECT TX_ID, SYMBOL, AMOUNT AS AMOUNT_TOKEN, EVENT_TYPE FROM ethereum.udm_events
WHERE ORIGIN_FUNCTION_SIGNATURE = '0x38b32e68'
AND TO_ADDRESS = '0x92be6adb6a12da0ca607f9d87db2f9978cd6ec3e' --0x6953dcda0e38b0f57f3629d689b8b9c61cdb19e68eab6009357020761adcdf99
AND nvl(CONTRACT_ADDRESS,'stringNULL') <> '0x9d409a0a012cfba9b15f6d4b36ac57a46966ab9a'
AND nvl(CONTRACT_ADDRESS,'stringNULL') <> '0xc5bddf9843308380375a611c18b50fb9341f502a') A
RIGHT JOIN
(SELECT BLOCK_TIMESTAMP, TX_ID, AMOUNT AS AMOUNT_yveCRV FROM ethereum.udm_events
WHERE ORIGIN_FUNCTION_SIGNATURE = '0x38b32e68'
AND TO_ADDRESS = '0x92be6adb6a12da0ca607f9d87db2f9978cd6ec3e' --0x6953dcda0e38b0f57f3629d689b8b9c61cdb19e68eab6009357020761adcdf99
AND CONTRACT_ADDRESS = '0x9d409a0a012cfba9b15f6d4b36ac57a46966ab9a') B on A.TX_ID = B.TX_ID
GROUP BY 1,2
ORDER BY 1 DESC, 3 DESC
-- WHERE A.BLOCK_TIMESTAMP >= getdate() - INTERVAL'1 month'
Run a query to Download Data