SELECT

DATE_TRUNC('day', block_timestamp) AS day,

swap_program,

SUM(

COALESCE(swap_from_amount, 0) + COALESCE(swap_to_amount, 0)

) AS volume

FROM

SOLANA.defi.fact_swaps

WHERE

(

swap_from_mint = 'J1toso1uCk3RLmjorhTtrVwY9HJ7X8V9yYac6Y7kGCPn'

OR swap_to_mint = 'J1toso1uCk3RLmjorhTtrVwY9HJ7X8V9yYac6Y7kGCPn'

)

AND block_timestamp >= current_date - 30

GROUP BY

day,

swap_program

day AS "Date",

swap_program AS "Program",

SUM(volume) AS "Volume"

jito_swaps

GROUP BY

day,

swap_program

ORDER BY

day DESC,

"Volume" DESC;