'cosmos --> stride' as type,

currency,

count(DISTINCT tx_id) as n_action,

count(DISTINCT sender) as n_user,

sum(amount/1e6) as amount

FROM cosmos.core.fact_transfers

WHERE receiver ilike 'stride%'

GROUP BY 2

ORDER BY n_action DESC

SELECT

'stride --> cosmos' as type,

currency,

count(DISTINCT tx_id) as n_action,

count(DISTINCT receiver) as n_user,

sum(amount/1e6) as amount

FROM cosmos.core.fact_transfers

WHERE sender ilike 'stride%'

GROUP BY 2

ORDER BY n_action DESC