WITH summation AS (
SELECT
SUM(RAW_AMOUNT) / POW(10, 18) AS summation
FROM
ethereum.core.fact_token_transfers
WHERE
ORIGIN_TO_ADDRESS = '0x025c6da5bd0e6a5dd1350fda9e3b6a614b205a1f'
AND ORIGIN_FUNCTION_SIGNATURE = '0x48c54b9d'
AND BLOCK_TIMESTAMP::date > '2022-03-17'
GROUP BY BLOCK_TIMESTAMP::date
)
SELECT
BLOCK_TIMESTAMP::date AS date,
SUM(RAW_AMOUNT) / POW(10, 18) AS apes,
(SELECT ROUND(AVG(summation), 0) FROM summation) AS average
FROM
ethereum.core.fact_token_transfers
WHERE
ORIGIN_TO_ADDRESS = '0x025c6da5bd0e6a5dd1350fda9e3b6a614b205a1f' -- AirdropGrapesToken
AND ORIGIN_FUNCTION_SIGNATURE = '0x48c54b9d' -- Claim Tokens Method
AND DATE > '2022-03-17'
GROUP BY
date
ORDER BY
date DESC