binhachonCurve - Yearn: Zap in function - direct to yvBOOST - express by number of yvBOOST
    Updated 2021-09-25
    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