protocol,

chain,

SUM(volume) AS TotalVolume,

SUM(volume) / COUNT(DISTINCT DATE_TRUNC('day', date)) AS AvgVolumePerDay

FROM external.defillama.fact_dex_volume

WHERE chain ILIKE 'solana'

AND protocol ILIKE 'raydium'

GROUP BY protocol, chain

ORDER BY TotalVolume DESC;