monthly_trade_volume AS (

SELECT

DATE_TRUNC('month', block_timestamp) AS month,

SUM(swap_from_amount_usd) AS monthly_trade_total

FROM

solana.defi.ez_dex_swaps

WHERE

swap_program LIKE 'jupiter%'

AND swapper = '{{Address}}'

GROUP BY

month

),

monthly_dca_volume AS (

SELECT

DATE_TRUNC('month', s.block_timestamp) AS month,

SUM(s.swap_from_amount_usd) AS monthly_dca_total

FROM

solana.defi.ez_dex_swaps AS s

INNER JOIN

solana.core.fact_transfers AS t

ON t.tx_id = s.tx_id

WHERE

t.tx_to = '{{Address}}'

AND s.swapper ILIKE 'DCA%'

GROUP BY

month

),

monthly_limit_volume AS (

SELECT

DATE_TRUNC('month', s.block_timestamp) AS month,

SUM(s.swap_from_amount_usd) AS monthly_limit_total

FROM

solana.defi.ez_dex_swaps AS s

INNER JOIN

solana.core.fact_transfers AS t