SELECT tx_id, COUNT(1) AS n

FROM thorchain.swaps

GROUP BY 1

SELECT date(block_timestamp) as day , blockchain, sum(from_amount_usd) as total_amt,

sum(total_amt) over (partition by blockchain order by day ) as cumulative_amt

from

(SELECT * from

(SELECT s.*, CASE WHEN t.n = 1 THEN 0 ELSE 1 END AS two_sided_swap_via_rune

FROM thorchain.swaps s

JOIN t ON t.tx_id = s.tx_id)

where two_sided_swap_via_rune = 0)

where to_asset = 'THOR.RUNE' and blockchain != 'THOR'

GROUP by 1,2