case

when DECODED_LOG:amount/1e18 >0 and DECODED_LOG:amount/1e18<=1 then 'Below One ETH'

when DECODED_LOG:amount/1e18 >1 and DECODED_LOG:amount/1e18<=5 then '1~5 ETH'

when DECODED_LOG:amount/1e18 >5 and DECODED_LOG:amount/1e18<=10 then '5~10 ETH'

when DECODED_LOG:amount/1e18 >10 and DECODED_LOG:amount/1e18<=20 then '10~20 ETH'

when DECODED_LOG:amount/1e18 >20 and DECODED_LOG:amount/1e18<=50 then '20~50 ETH'

when DECODED_LOG:amount/1e18 >50 and DECODED_LOG:amount/1e18<=100 then '50~100 ETH'

when DECODED_LOG:amount/1e18 >100 then 'Up To 100 ETH' end as dis_volume

,case

when BLOCK_TIMESTAMP>='2023-05-10' and BLOCK_TIMESTAMP<'2023-05-15' then '5 Days Before Enable'

when BLOCK_TIMESTAMP>='2023-05-15' and BLOCK_TIMESTAMP<='2023-05-19' then '5 Days After Enable' end as enable_time

,count(distinct DECODED_LOG:sender) as users

,count(distinct TX_HASH) as txs

from ethereum.core.ez_decoded_event_logs

where CONTRACT_ADDRESS ='0xae7ab96520de3a18e5e111b5eaab095312d7fe84'

and CONTRACT_NAME='Liquid staked Ether 2.0'

and EVENT_NAME='Submitted'

and BLOCK_TIMESTAMP>='2023-05-10' and BLOCK_TIMESTAMP<='2023-05-19'

and TX_STATUS='SUCCESS'

group by 1,2

order by 3 desc