from thorchain.swaps),

synth as (select to_asset

from thorchain.swaps

where native_to_address like 'thor%' and to_asset!='THOR.RUNE'

group by 1),

broh as (select block_timestamp, tx_id, pool_name, native_to_address, from_asset, to_amount, case

when to_amount_usd = 0 then to_amount

else to_amount_usd end as vol_usd

from raw

where from_asset in (select to_asset from synth))

select date_trunc('day', block_timestamp) as dt, from_asset, count(distinct tx_id) as tx_count, count(distinct native_to_address) as minter_count, sum(vol_usd) as volume_usd

from broh

group by 1,2