date_trunc('day', block_timestamp) as day,

COUNT(tx_id) as swaps_all_chains

FROM thorchain.swaps

WHERE block_timestamp >= CURRENT_DATE - 31

GROUP BY 1

),

to_rune as (SELECT

date_trunc('day', block_timestamp) as day,

tx_id,

CASE

WHEN blockchain = 'BNB' THEN 'BNB'

WHEN blockchain = 'ETH' THEN 'ETH'

WHEN blockchain = 'LTC' THEN 'LTC'

WHEN blockchain = 'THOR' THEN 'THOR'

WHEN blockchain = 'BTC' THEN 'BTC'

WHEN blockchain = 'BCH' THEN 'BCH'

END AS Chains

FROM thorchain.swaps

WHERE block_timestamp >= CURRENT_DATE - 31

AND blockchain = 'BNB'

OR blockchain = 'ETH'

OR blockchain = 'LTC'

OR blockchain = 'THOR'

OR blockchain = 'BTC'

OR blockchain = 'BCH'

AND to_asset = 'THOR.RUNE'

GROUP BY 1,2,blockchain

),

from_rune as (

date_trunc('day', block_timestamp) as day,

tx_id,