SELECT

COUNT (DISTINCT TX_HASH) as UNIQUE_TX_7days,

sum(AMOUNT) as total_volume_ETH_7days,

sum(AMOUNT_USD) as total_volume_USD_7days,

count(DISTINCT ETH_FROM_ADDRESS) as unique_wallets

FROM ethereum.core.ez_eth_transfers

WHERE

(ETH_TO_ADDRESS=lower('0x99C9fc46f92E8a1c0deC1b1747d010903E884bE1'))

AND DATE_TRUNC('day', BLOCK_TIMESTAMP) >= CURRENT_DATE - 6