count(a.TX_HASH) as number_of_transaction,

b.TX_FEE as transaction_fee,

b.GAS_USED as gas_in_USD,

b.ETH_VALUE as valuee,

date_trunc('day', a.block_timestamp) as date

from ethereum.core.fact_token_transfers a

INNER JOIN ethereum.core.fact_transactions b

on a.TX_HASH = b.TX_HASH

where a.CONTRACT_ADDRESS='0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0'

AND a.block_timestamp >= current_date - 120

GROUP by 2,3,4,5

order by 5 DESC