CASE WHEN to_address = lower('0x9AaF7a59c1A66f8b1C12D4D032Da248A99233207') THEN 'In'

ELSE 'Out'

END AS direction,

CASE WHEN direction = 'In' THEN raw_amount * (pow(10, -1 * c.decimals))

ELSE (-1 * raw_amount * (pow(10, -1 * c.decimals)))

END AS amount,

c.symbol, from_address, to_address,

amount * price as amount_usd

FROM ethereum.core.fact_token_transfers t

JOIN ethereum.core.dim_contracts c ON t.contract_address = c.address

JOIN ethereum.price.ez_hourly_token_prices p ON t.contract_address = p.token_address AND p.hour = date_trunc('hour', t.block_timestamp)

WHERE (to_address = lower('0x9AaF7a59c1A66f8b1C12D4D032Da248A99233207')

OR from_address = lower('0x9AaF7a59c1A66f8b1C12D4D032Da248A99233207'))

AND amount != 0)

SELECT SUM(amount_usd) * -1 as sent_usd, COUNT(DISTINCT to_address) as receiving_addresses

FROM all_transfers

WHERE direction = 'Out'