rahoterritorial-lime
    Updated 2025-01-10
    SELECT
    -- date,
    -- protocol,
    -- category,
    -- chain_tvl
    *
    FROM external.defillama.fact_pool_yields
    WHERE chain = 'Scroll'
    AND date = CURRENT_DATE()
    AND symbol LIKE 'SCR%'


    Last run: 2 months ago
    DATE
    POOL_ID
    PROJECTS
    CHAIN
    SYMBOL
    APY
    APY_BASE
    BASE_7D
    APY_BASE_INCEPTION
    APY_MEAN_30D
    APY_PCT_1D
    APY_PCT_7D
    APY_PCT_30D
    APY_REWARDS
    IL_7D
    IL_RISK
    REWARD_TOKENS
    MU
    SIGMA
    STABLECOIN
    TVL_USD
    UNDERLYING_TOKENS
    VOLUME_USD_1D
    VOLUME_USD_7D
    1
    2025-01-10 00:00:00.000bc949cf6-852f-43d1-906c-fe45f1874522aave-v3ScrollSCR0.033610.033610.018020.006350.03297no
    0.018640.00124FALSE228413
    ["0xd29687c813D741E2F938F4aC377128810E217b1b"]
    2
    2025-01-10 00:00:00.000777c0536-1116-400b-baa0-1fbcc577a2a9lore-financeScrollSCR0.569340.569342.59578-0.010090.5035no
    0.554920.04337FALSE19793
    ["0xd29687c813D741E2F938F4aC377128810E217b1b"]
    3
    2025-01-10 00:00:00.00020ec3941-ff26-4ff7-bf37-8b4bc4078ad6rho-marketsScrollSCR0.071040.071040.031620.000770.057450.05672no
    0.014250.00086FALSE157378
    ["0xd29687c813D741E2F938F4aC377128810E217b1b"]
    3
    771B
    2s