DISTINCT parse_json(trim(replace(f.value, 'EVENT_JSON:'))):data:token_id as token,

FROM near.core.fact_actions_events_function_call

join lateral flatten (input => logs) f

WHERE receiver_id = 'meme-cooking.near'

AND method_name = 'on_finalize')

select split(token,'-')[0] as symbol,

sum(coalesce(amount_in_usd,amount_out_usd)) AS usd

from near.defi.ez_dex_swaps

join tokens on (token_out_contract= token or token_in_contract= token)

group by 1

order by 2 desc