select

BLOCK_TIMESTAMP as "Date and Time",

'WETH' as "Reserve Asset",

DECODED_LOG:liquidityRate/pow(10,25) as "Supply APY",

DECODED_LOG:variableBorrowRate/pow(10,25) as "Borrow APY | Variable"

from base.core.ez_decoded_event_logs

where CONTRACT_ADDRESS = '0xa238dd80c259a72e81d7e4664a9801593f98d1c5'

and EVENT_NAME = 'ReserveDataUpdated'

and DECODED_LOG:reserve = '0x4200000000000000000000000000000000000006'

order by BLOCK_TIMESTAMP desc

limit 1),

usdbc_config as (

select

BLOCK_TIMESTAMP,

'USDbC' as symbols,

DECODED_LOG:liquidityRate/pow(10,25) as "Supply APY",

DECODED_LOG:variableBorrowRate/pow(10,25) as "Borrow APY | Variable"

from base.core.ez_decoded_event_logs

where CONTRACT_ADDRESS = '0xa238dd80c259a72e81d7e4664a9801593f98d1c5'

and EVENT_NAME = 'ReserveDataUpdated'

and DECODED_LOG:reserve = '0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca'

order by BLOCK_TIMESTAMP desc

limit 1),

cbeth_config as (

select

BLOCK_TIMESTAMP,

'cbETH' as symbols,

DECODED_LOG:liquidityRate/pow(10,25) as "Supply APY",

DECODED_LOG:variableBorrowRate/pow(10,25) as "Borrow APY | Variable"

from base.core.ez_decoded_event_logs

where CONTRACT_ADDRESS = '0xa238dd80c259a72e81d7e4664a9801593f98d1c5'

and EVENT_NAME = 'ReserveDataUpdated'

and DECODED_LOG:reserve = '0x2ae3f1ec7f1f5012cfeab0185bfc7aa3cf0dec22'