select

'0xe94b5eec1fa96ceecbd33ef5baa8d00e4493f4f3' as treasury,

'0x19b3eb3af5d93b77a5619b047de0eed7115a19e7' as multisig,

'0x7b18913D945242A9c313573E6c99064cd940c6aF' as sushiHouse

), inflow AS (

SELECT

CAST(DATE_TRUNC('DAY', BLOCK_TIMESTAMP) AS DATE) AS date,

symbol,

SUM(RAW_AMOUNT/POWER(10, DECIMALS)) AS amount

FROM ethereum.core.ez_token_transfers

WHERE TO_ADDRESS=(SELECT treasury FROM variables)

GROUP BY date, symbol

), outflow AS (

SELECT

CAST(DATE_TRUNC('DAY', BLOCK_TIMESTAMP) AS DATE) AS date,

symbol,

SUM(-1 * RAW_AMOUNT/POWER(10, DECIMALS)) AS amount

FROM ethereum.core.ez_token_transfers

WHERE FROM_ADDRESS=(SELECT treasury FROM variables)

GROUP BY date, symbol

), SUSHI AS (

SELECT

inflow.date,

inflow.symbol,

inflow.amount AS inflow,

COALESCE(outflow.amount, 0) AS outflow

FROM inflow

LEFT JOIN(

SELECT * FROM outflow

WHERE symbol='SUSHI'

) outflow

ON inflow.date=outflow.date

WHERE inflow.symbol='SUSHI'

ORDER BY date DESC