SELECT

BLOCK_TIMESTAMP::date AS date,

AVG(RAW_AMOUNT) / POW(10, 18) AS average

FROM

ethereum.core.fact_token_transfers

WHERE

ORIGIN_TO_ADDRESS = '0x025c6da5bd0e6a5dd1350fda9e3b6a614b205a1f'

AND ORIGIN_FUNCTION_SIGNATURE = '0x48c54b9d'

GROUP BY BLOCK_TIMESTAMP::date

SElECT * FROM average