CASE WHEN

RAW_AMOUNT / power(10, 18) < 100 THEN 'Below 100'

WHEN RAW_AMOUNT / power(10, 18) Between 100 and 1000 Then 'Between 100 - 1,000 '

WHEN RAW_AMOUNT / power(10, 18) Between 1001 and 10000 Then 'Between 1,000 - 10,000 '

WHEN RAW_AMOUNT / power(10, 18) Between 10001 And 100000 Then 'Between 10,000 - 100,000 '

WHEN RAW_AMOUNT / power(10, 18) > 100000 Then 'Over 100,000 '

END as Matic_Transfer_Size,

CASE WHEN

contract_address LIKE lower('0x3A58a54C066FdC0f2D55FC9C89F0415C92eBf3C4') Then 'stMATIC'

WHEN contract_address LIKE lower('0x3aD736904E9e65189c3000c7DD2c8AC8bB7cD4e3') Then 'MATICx'

WHEN contract_address LIKE lower('0x7ed6390f38d554B8518eF30B925b46972E768AF8') Then 'csMATIC'

END as token_address,

Count(DISTINCT tx_hash) as events_count,

Count(DISTINCT origin_from_address) as users_count

From polygon.core.fact_token_transfers

Where contract_address IN (

lower('0x3A58a54C066FdC0f2D55FC9C89F0415C92eBf3C4'),

lower('0x3aD736904E9e65189c3000c7DD2c8AC8bB7cD4e3'),

lower('0x7ed6390f38d554B8518eF30B925b46972E768AF8'))

And Matic_Transfer_Size is not null

Group By Matic_Transfer_Size,token_address)

select * from Matic_Transfer