select date_trunc('month',date) as date, sum(volume) as "Monthly volume"

from external.defillama.fact_dex_volume

where chain = 'near'

group by 1

order by 1 desc, 2 desc