BLOCK_TIMESTAMP::DATE AS Date

, SUM(AMOUNT_IN_USD) AS Trading_volume

, COUNT(*) AS Trades_number

, COUNT(DISTINCT SWAPPER) AS Traders

, SUM(CASE WHEN SYMBOL_IN != 'SHRIMP' THEN AMOUNT_IN_USD ELSE 0 END) AS "bought volume"

, SUM(CASE WHEN SYMBOL_IN = 'SHRIMP' THEN AMOUNT_IN_USD ELSE 0 END) AS "sold volume"

, SUM(CASE WHEN SYMBOL_IN != 'SHRIMP' THEN AMOUNT_IN_USD ELSE AMOUNT_IN_USD * -1 END) AS "Net flow"

, SUM("bought volume") OVER (ORDER BY DATE) AS "Total bought volume"

, SUM("sold volume") OVER (ORDER BY DATE) AS "Total sold volume"

, SUM("Net flow") OVER (ORDER BY DATE) AS "Total Net flow"

, SUM(Trading_volume) OVER (ORDER BY DATE) AS "Total trading volume"

, SUM(Trades_number) OVER (ORDER BY DATE) AS "Total Trades number"

FROM

aptos.defi.ez_dex_swaps

WHERE

SYMBOL_IN = 'SHRIMP'

SYMBOL_OUT = 'SHRIMP'

GROUP BY 1

ORDER BY 1 DESC