SELECT from_address , tx_id,platform,amount_usd ,date_trunc('day',block_timestamp) as date ,pool_name

FROM ethereum.dex_swaps

WHERE --TO_LABEL_SUBTYPE = 'pool' and

pool_name ilike'FRZ-WETH 10000 200 UNI-V3 LP'

--'0x2d94aa3e47d9d5024503ca8491fce9a2fb4da198'

and BLOCK_TIMESTAMP > '2022-01-01'

group by 1,2,3,4,5,6)

select

count(distinct tx_id) as tx_id_number,

count(distinct from_address) as user_number,

sum(amount_usd) as amount,

date ,

platform,

from convex

group by 4,5,6