sarathsushi extra yield 4
    Updated 2022-07-20
    WITH

    kashi_lending_pools AS (
    SELECT DISTINCT lending_pool_address FROM ethereum.sushi.ez_borrowing
    UNION
    SELECT DISTINCT lending_pool_address FROM ethereum.sushi.ez_lending
    ),


    masterchef_pool_allocation AS (
    SELECT column1 AS pool_address
    , column2 AS alloc_points
    FROM ( VALUES
    ('0xfb736dad22b879f055c7aebf3a2e8a197f923ea1', 797987)
    , ('0x3485a7c8913d640245e38564ddc05bfb40104635', 1)
    , ('0x418bc3ff0ba33ad64931160a91c92fa26b35acb0', 1)
    , ('0x5f92e4300024c447a103c161614e6918e794c764', 1)
    , ('0x9a13867048e01c663ce8ce2fe0cdae69ff9f35e3', 1)
    , ('0x77337ff10206480739a768124a18f3aa8c089153', 2)
    , ('0x0589e281d35ee1acf6d4fd32f1fba60effb5281b', 2)
    , ('0x0f82e57804d0b1f6fab2370a43dcfad3c7cb239c', 3)
    , ('0xa73df646512c82550c2b3c0324c4eedee53b400c', 5)
    , ('0x742c15d71ea7444964bc39b0ed729b3729adc361', 5)
    , ('0xfb55af0ef0dcdec92bd3752e7a9237dfefb8acc0', 5)
    , ('0xc926990039045611eb1de520c1e249fd0d20a8ea', 5)
    , ('0x0652687e87a4b8b5370b05bc298ff00d205d9b5f', 5)
    , ('0x57024267e8272618f9c5037d373043a8646507e5', 5)
    , ('0x561770b93d0530390eb70e17acbbd6e5d2f52a31', 5)
    , ('0x668edab8a38a962d30602d6fa7ca489484ee3224', 5)
    , ('0xf678b4a096bb49309b81b2a1c8a966ef5f9756ba', 5)
    , ('0x328dfd0139e26cb0fef7b0742b49b0fe4325f821', 5)
    , ('0xf39ff863730268c9bb867b3a69d031d1c1614b31', 5)
    , ('0x96f5b7c2be10dc7de02fa8858a8f1bd19c2fa72a', 5)
    , ('0xf55c33d94150d93c2cfb833bcca30be388b14964', 10)
    , ('0xa75f7c2f025f470355515482bde9efa8153536a8', 10)
    , ('0xec8c342bc3e07f05b9a782bc34e7f04fb9b44502', 10)
    Run a query to Download Data