WITH transactions AS (

-- Inflows

SELECT

DATE_TRUNC('day', block_timestamp) AS date

, to_address AS address

, SUM(amount) AS amount

FROM

gnosis.core.ez_token_transfers

WHERE

contract_address = LOWER('{{token_address}}')

GROUP BY

date, address

UNION ALL

-- Outflows

SELECT

DATE_TRUNC('day', block_timestamp) AS date

, from_address AS address

, -SUM(amount) AS amount

FROM

ethereum.core.ez_token_transfers

WHERE

contract_address = LOWER('{{token_address}}')

GROUP BY

date, address

),

net_transfers AS ( -- Sum of daily in/out txs to have daily net transfers

SELECT

date

, address

, SUM(amount) AS amount

FROM