select

count(distinct TRADER) as "Traders",

count(distinct tx_hash) as "Swaps",

COUNT(DISTINCT CASE WHEN TOKEN_OUT_CONTRACT ='token.lonkingnearbackto2024.near' THEN TRADER END) as "Buyers",

COUNT(DISTINCT CASE WHEN TOKEN_IN_CONTRACT ='token.lonkingnearbackto2024.near' THEN TRADER END) as "Sellers",

ZEROIFNULL(sum(DISTINCT CASE WHEN TOKEN_OUT_CONTRACT ='token.lonkingnearbackto2024.near' THEN AMOUNT_IN_USD END)) as "Purchase volume",

ZEROIFNULL(sum(DISTINCT CASE WHEN TOKEN_IN_CONTRACT ='token.lonkingnearbackto2024.near' THEN AMOUNT_OUT_USD END)) as "Sell volume",

"Purchase volume"+"Sell volume" as "Volume",

avg(DISTINCT CASE WHEN TOKEN_OUT_CONTRACT ='token.lonkingnearbackto2024.near' THEN AMOUNT_IN_USD END) as "Avg purchase volume",

avg(DISTINCT CASE WHEN TOKEN_IN_CONTRACT ='token.lonkingnearbackto2024.near' THEN AMOUNT_OUT_USD END) as "Avg sell volume",

"Purchase volume"/"Buyers" as "Volume per buyer",

from near.defi.ez_dex_swaps

where BLOCK_TIMESTAMP>='2024-02-27' and BLOCK_TIMESTAMP<='2024-03-26'

and (TOKEN_IN_CONTRACT ='token.lonkingnearbackto2024.near' or TOKEN_OUT_CONTRACT= 'token.lonkingnearbackto2024.near')