with ingoing as (

SELECT a.date_day,

sum(b.vol) as ingoing,

sum(b.count) as ingoing_count

FROM crosschain.core.dim_dates a

LEFT JOIN

SELECT date_trunc('d',block_timestamp) as date,

sum (zeroifnull(amount_usd)) as vol,

count(DISTINCT tx_hash) as count

FROM {{chain}}.core.ez_token_transfers

WHERE block_timestamp >=current_date - {{past_days}}

AND TO_ADDRESS = lower('{{contract_address}}')

GROUP BY 1

UNION ALL

SELECT date_trunc('d',block_timestamp) as date,

sum(zeroifnull(amount_usd)) as vol,

count(DISTINCT tx_hash) as count

FROM {{chain}}.core.ez_native_transfers

WHERE block_timestamp >=current_date - {{past_days}}

AND TO_ADDRESS = lower('{{contract_address}}')

GROUP BY 1

) b

on a.date_day = b.date

WHERE a.date_day BETWEEN current_date - {{past_days}} AND current_date

GROUP BY 1

,

outgoing as (

SELECT a.date_day,

sum(b.vol) as outgoing,

sum(b.count) as outgoing_count

FROM crosschain.core.dim_dates a

LEFT JOIN