SELECT --*

-- date_trunc('day', block_timestamp) as day,

CASE WHEN symbol_in like 'BLUR' THEN 'Sell' ELSE 'Buy' END swap_type,

count(DISTINCT origin_from_address) as users,

sum(CASE WHEN symbol_out like 'BLUR' THEN amount_out_usd ELSE 0 END) - sum(CASE WHEN symbol_in like 'BLUR' THEN amount_in_usd ELSE 0 END) as NET_BUY_AMT_USD

FROM ethereum.core.ez_dex_swaps

WHERE (symbol_in LIKE 'BLUR' or symbol_out LIKE 'BLUR')

GROUP BY 1

--HAVING day > '2023-02-13'