DATE_TRUNC('week', block_timestamp) AS week,

LP_TOKEN_ADDRESS as "LP Tokens 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 'Unknown'

END AS "Lp Token name and Path",

COUNT(*) AS "Bonding Events",

SUM(olas_amount) AS "Total $OLAS Bonded"

crosschain.olas.ez_olas_bonding

GROUP BY

1,2