SELECT date_trunc('day', Block_timestamp) as sol_date,

count(DISTINCT TX_ID

) as sol_n_unique_user

FROM solana.core.fact_transactions

WHERE sol_date between '2022-02-01' and CURRENT_DATE-1

group by sol_date

),

ethereum_uu as

(SELECT date_trunc('day', Block_timestamp) as eth_date,

count(DISTINCT from_address) as eth_n_unique_user

FROM ethereum.core.fact_transactions

WHERE eth_date between '2022-02-01' and CURRENT_DATE-1

group by eth_date),

FLOW_uu as

(SELECT date_trunc('day', Block_timestamp) as FLOW_date,

count(DISTINCT TX_ID) as FLOW_n_unique_user

FROM flow.core.fact_transactions

WHERE FLOW_date between '2022-02-01' and CURRENT_DATE-1

group by FLOW_date)

SELECT c.eth_date,

a.sol_n_unique_user,

b.FLOW_n_unique_user,

c.eth_n_unique_user

FROM solana_uu a

full JOIN FLOW_uu b

on a.sol_date = b.FLOW_date

full JOIN ethereum_uu c

on a.sol_date=c.eth_date