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

ELSE 'Out'

END AS direction,

raw_amount * (pow(10, -1 * decimals)) as amount,

CASE WHEN c.address != '0xdac17f958d2ee523a2206206994597c13d831ec7' THEN 'SCAM token ⚠️'

ELSE symbol

END AS symbol,

to_address as destination, block_timestamp

FROM ethereum.core.fact_token_transfers t

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

WHERE (to_address = lower('0xf1445e654AEdB88f75fCC56CBC4f47a9d685B463')

OR from_address = lower('0xf1445e654AEdB88f75fCC56CBC4f47a9d685B463'))

AND amount != 0

ORDER BY block_timestamp DESC