sum (TX_FEE) as Redemptions_fee ,count(distinct TX_ID) as txs_num , BLOCK_TIMESTAMP::date as date

from flipside_prod_db.ethereum.transactions

where

SUCCESS ='TRUE' and FUNCTION_SIGNATURE ='0xbe5021ec' and TO_ADDRESS ='0xa4b41efc1b6f73355c90119aeefddb1ffcf907b0'

group by 3