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 date_trunc('day',block_timestamp) as date,

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

sum(coalesce(amount_in_usd,amount_out_usd)) AS usd,

count(DISTINCT trader) as traders

from near.defi.ez_dex_swaps

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

group by 1,2