with tab1 as (

select

from base.core.ez_decoded_event_logs

where EVENT_NAME='LiFiTransferStarted'

and DECODED_LOG:bridgeData:integrator='jumper.exchange'

and ORIGIN_TO_ADDRESS='0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae'

),

tab2 as (

select BLOCK_TIMESTAMP::date as day

,ORIGIN_FROM_ADDRESS

,DECODED_LOG:mintAmount/1e6 as volume

,TX_HASH

from base.core.ez_decoded_event_logs

where ORIGIN_TO_ADDRESS='0xedc817a28e8b93b03976fbd4a3ddbc9f7d176c22'

and EVENT_NAME='Mint'

and CONTRACT_NAME='Moonwell USDC'

and BLOCK_TIMESTAMP::date>='2024-07-08'

select case

when volume>0 and volume<10 then 'Below $10'

when volume>=10 and volume<=100 then '$10~$100'

when volume>100 and volume<=1000 then '$100~$1K'

when volume>1000 and volume<=10000 then '$1K~$10K'

when volume>10000 then 'Up to $10K' end as dis_volume

,count(distinct tab2.ORIGIN_FROM_ADDRESS) as Suppliers

,count(distinct TX_HASH) as supplies

from tab1

left join tab2

on tab1.ORIGIN_FROM_ADDRESS=tab2.ORIGIN_FROM_ADDRESS

where dis_volume is not null

group by 1