owner_address,

lp_token_address,

CASE

WHEN lp_token_address = lower('0x79c872ed3acb3fc5770dd8a0cd9cd5db3b3ac985') THEN 'OLAS-WXDAI via Balancer on Gnosis Chain'

WHEN lp_token_address = lower('0x36B203Cb3086269f005a4b987772452243c0767f') THEN 'OLAS-WETH via Balancer on Arbitrum'

WHEN lp_token_address = lower('0xf9825A563222f9eFC81e369311DAdb13D68e60a4') THEN 'OLAS-WMATIC via Balancer on Polygon POS'

WHEN lp_token_address = lower('0x09d1d767edf8fa23a64c51fa559e0688e526812f')THEN 'OLAS-ETH via Uniswap on Ethereum'

WHEN lp_token_address = lower('0x2FD007a534eB7527b535a1DF35aba6bD2a8b660F')THEN 'WETH-OLAS via Balancer on Optimism'

WHEN lp_token_address = lower('0x9946d6FD1210D85EC613Ca956F142D911C97a074') THEN 'OLAS-USDC via Balancer on Base'

WHEN lp_token_address = lower('0x3685b8cc36b8df09ed9e81c1690100306bf23e04') THEN 'WSOL-OLAS via Orca on Solana'

WHEN lp_token_address = lower('0xC085F31E4ca659fF8A17042dDB26f1dcA2fBdAB4') THEN 'CELO-OLAS via Ubeswap on Celo'

WHEN lp_token_address = lower('0x06512e620a8317da51a73690a596aca97287b31d') THEN '50WMATIC-50OLAS from Polygon'

WHEN lp_token_address = lower('0x27df632fd0dcf191c418c803801d521cd579f18e') THEN '50OLAS-50WXDAI from xDAI'

ELSE 'Unlabelled'

END AS "Lp Token name and Path",

date_trunc('day',block_timestamp) as Date,

date_trunc('day',maturity_timestamp) as "Maturity Date",

DATEDIFF('day', block_timestamp, maturity_timestamp) AS "Bonding Latency (Days)"

crosschain.olas.ez_olas_bonding;