trunc(DATE,'day') as date,

PROTOCOL,

sum(volume) as volume

from external.defillama.fact_dex_volume

WHERE chain = 'klaytn'

and date between (current_date - 31) and (current_date - 1)

GROUP by 1,2