select chain,type, count(*) as transfer_count

from

SELECT

'solana' as chain,

TX_ID,

amount as volume,

CASE

WHEN volume<=100 THEN '1_lower than 100'

WHEN volume>100 and volume<=1000 THEN '2_100-1K'

WHEN volume>1000 and volume<=10000 THEN '3_1K-10K'

WHEN volume>10000 and volume<=100000 THEN '4_10k-100K'

WHEN volume>100000 and volume<=1000000 THEN '5_100k-1M'

WHEN volume>1000000 and volume<=10000000 THEN '6_1M-10M'

WHEN volume>10000000 and volume<=100000000 THEN '7_10M-100M'

WHEN volume>100000000 THEN '8_more than 100M'

END as type

FROM algorand.core.ez_transfer

where asset_id = '31566704'

AND block_timestamp::date >='{{start_time}}' and block_timestamp::date <='{{end_date}}'

and volume!=0

group by 1,2

order by 2