select block_timestamp as evt_block_time, decoded_log['aum'] as aum, decoded_log['supply'] as supply

from blast.core.fact_decoded_event_logs

where contract_address = lower('0xF0D92907236418Fa8Ee900E384b4c6928f7cADfc') and

event_name in ('AddLiquidity', 'RemoveLiquidity')

select evt_block_time as time,

(cast(aum as double) * 1.0 / 1e30) / (cast(supply as double) * 1.0 / 1e18) as price

from liquidity_service_log

where cast(supply as double) > 0

order by evt_block_time desc

limit 1