SELECT address FROM arbitrum.core.dim_labels WHERE project_name = 'stargate finance'

UNION

SELECT address FROM avalanche.core.dim_labels WHERE project_name = 'stargate finance'

UNION

SELECT address FROM bsc.core.dim_labels WHERE project_name = 'stargate finance'

UNION

SELECT address FROM ethereum.core.dim_labels WHERE label = 'stargate finance'

UNION

SELECT address FROM optimism.core.dim_labels WHERE project_name = 'stargate finance'

UNION

SELECT address FROM polygon.core.dim_labels WHERE project_name = 'stargate finance'

), arb_inflow_trn AS

SELECT date_trunc('week', block_timestamp) AS date

, origin_from_address AS user

, symbol

, amount

, amount_usd

FROM arbitrum.core.ez_token_transfers

WHERE origin_to_address IN (SELECT address FROM zero_address)

AND block_timestamp::date BETWEEN '{{From_Date}}' AND '{{To_Date}}'

AND coalesce(amount_usd, 0) > 0

UNION

SELECT date_trunc('week', block_timestamp) AS date

, origin_from_address AS user

, 'ETH' AS symbol

, amount

, amount_usd

FROM arbitrum.core.ez_eth_transfers

WHERE origin_to_address IN (SELECT address FROM zero_address)

AND block_timestamp::date BETWEEN '{{From_Date}}' AND '{{To_Date}}'

AND coalesce(amount_usd, 0) > 0

), arb_outflow_trn AS