select
date_trunc('{{Timeframe}}',BLOCK_TIMESTAMP) AS {{Timeframe}},
SYMBOL AS token,
case
when AMOUNT_USD >= 100000 then 'more than 10K USD'
else null end AS "USD SIZE",
count("USD SIZE") AS "events number"
from ethereum.core.ez_token_transfers
where from_ADDRESS in ('0x99c9fc46f92e8a1c0dec1b1747d010903e884be1','0x52ec2f3d7c5977a8e558c8d9c6000b615098e8fc')
and BLOCK_TIMESTAMP::date >= '{{start_date}}' and AMOUNT_USD>100000 and
(SYMBOL in ('USDC','USDT'))
group by 1,2,3