with inflow as (

SELECT

'inflow' as type,

date_trunc('d', block_timestamp) as date,

sum(amount_usd) as volume

FROM avalanche.core.ez_token_transfers

WHERE to_address IN (SELECT address FROM avalanche.core.dim_labels where project_name ilike '%beefy%'

AND date >= dateadd('month', -12, current_date)

GROUP BY date

UNION

SELECT

'inflow' as type,

date_trunc('d', block_timestamp) as date,

sum(amount_usd) as volume

FROM avalanche.core.ez_native_transfers

WHERE to_address IN (SELECT address FROM avalanche.core.dim_labels where project_name ilike '%beefy%'

AND date >= dateadd('month', -12, current_date)

GROUP BY date

,

outflow as (

SELECT

'outflow' as type,

date_trunc('d', block_timestamp) as date,

-1 * sum(amount_usd) as volume

FROM avalanche.core.ez_token_transfers

WHERE from_address IN (SELECT address FROM avalanche.core.dim_labels where project_name ilike '%beefy%'

AND date >= dateadd('month', -12, current_date)

GROUP BY date

UNION

SELECT