SUM(Trading_Volume) AS May_Trading_Volume

FROM (

SELECT

DATE_TRUNC('month', D.Block_Timestamp) AS Date,

SUM(D.Amount_In_Usd) + SUM(D.Amount_Out_Usd) AS Trading_Volume,

D.Pool_Name,

COUNT(D.Tx_Hash) AS Transaction_Overtime,

L.Label

FROM

ethereum.defi.ez_dex_swaps D

JOIN

ethereum.core.dim_labels AS L ON D.token_in = L.address

WHERE

D.token_in = LOWER('0x12652c6d93fdb6f4f37d48a8687783c782bb0d10')

AND D.Amount_In_Usd IS NOT NULL

AND Block_Timestamp >= '2024-05-01'

AND Block_Timestamp < '2024-06-01'

GROUP BY 1,3,5

) AS May_Trading_Volume;