FROM (

SELECT

*,

PARSE_JSON(reward_tokens)[0] AS reward_token,

PARSE_JSON(UNDERLYING_TOKENS)[0] AS token_1,

PARSE_JSON(UNDERLYING_TOKENS)[1] AS token_2

FROM

external.defillama.fact_pool_yields

WHERE

chain = 'Scroll'

WHERE token_1 = '0xd29687c813D741E2F938F4aC377128810E217b1b'

OR token_2 = '0xd29687c813D741E2F938F4aC377128810E217b1b'

ORDER BY date DESC, tvl_usd DESC