with x as

(SELECT

date_trunc('day', BLOCK_TIMESTAMP) AS DAY,

TX_TO AS address,

AMOUNT/pow(10,decimal) AS amountx,

'inflow' AS direction

FROM eclipse.core.fact_transfers

WHERE

MINT = 'LaihKXA47apnS599tyEyasY2REfEzBNe4heunANhsMx'

GROUP BY all

UNION

-- Outflow

SELECT

date_trunc('day', BLOCK_TIMESTAMP) AS DAY,

TX_from AS address,

AMOUNT/pow(10,decimal) AS amountx,

'outflow' AS direction

FROM eclipse.core.fact_transfers

WHERE

MINT = 'LaihKXA47apnS599tyEyasY2REfEzBNe4heunANhsMx'

GROUP BY all)

select DAY, direction, count(DISTINCT address) as users from x group by all