with inflow AS (

SELECT

transfer.block_timestamp,

transfer.tx_hash,

transfer.from_address,

transfer.amount,

transfer.amount_usd,

tx_fee

FROM ethereum.core.ez_native_transfers transfer

INNER JOIN ethereum.core.fact_transactions transaction ON(transaction.tx_hash = transfer.tx_hash)

WHERE transfer.to_address = '0x63ca00232f471be2a3bf3c4e95bc1d2b3ea5db92'

AND transfer.block_timestamp:: date >= '2024-06-01'

AND transaction.block_timestamp:: date >= '2024-06-01'

SELECT

count(tx_hash) AS transactions,

count(DISTINCT from_address) AS user,

SUM(amount) AS eth_amount,

SUM(amount_usd) AS usd_amount,

MAX(amount) AS max_amount,

AVG(amount) AS avg_amount,

SUM(tx_fee) AS fee

FROM inflow