select

*,

amount / lag(amount, 1) over(

order by

supply asc

) -1 as change_price

from

(

select

cast(decoded_log:supply as double) as supply,

cast(avg(decoded_log:ethAmount / 1e18) as double) as amount

from

base.core.ez_decoded_event_logs

where

decoded_log:shareAmount = 1

and contract_address = '0xcf205808ed36593aa40a44f10c7f7c2f67d4a4d4'

and TX_STATUS = 'SUCCESS'

group by

1

) a qualify supply > 1

),

block as (

select

decoded_log:subject as subject,

'ETH' as symbol,

max(block_timestamp) as latest,

sum(

cast(decoded_log:subjectEthAmount as double) / 1e18

) as creator_earnings_eth

from

base.core.ez_decoded_event_logs

where

contract_address = '0xcf205808ed36593aa40a44f10c7f7c2f67d4a4d4'

and TX_STATUS = 'SUCCESS'

group by