select

hour,

price as wewe_price

from base.price.ez_prices_hourly

where hour::date >= '2024-07-07'

and symbol = 'WEWE'

and token_address = '0x6b9bb36519538e0c073894e964e90172e1c0b41f'

qualify row_number () over (order by hour desc) = 1

,

wewe_locked as (

select

sum(amount) as wewe_amount_locked

from base.core.ez_token_transfers

where to_address = lower('0x30091c97Fd47873c44D03F7F1b960473D300D269')

and contract_address = '0x6b9bb36519538e0c073894e964e90172e1c0b41f'

select

wewe_amount_locked,

wewe_amount_locked * wewe_price as wewe_amount_locked_usd

from wewe_locked

join wewe_price ON TRUE