from thorchain.swaps

where pool_name = 'DOGE.DOGE'

group by 1),

total as (select date_trunc('day', block_timestamp) as dt, sum(from_amount_usd) as vol, count(distinct tx_id) as total_tx

from thorchain.swaps

where pool_name not in ('DOGE.DOGE')

group by 1)

select a.dt, a.vol as Vol_Doge, b.vol as Total_Swap, round(((vol_doge/total_swap)*100),2) as "% Doge Vol", round(((a.doge_tx/b.total_tx)*100),2) as "% Doge Tx"

from doge A

left join total B on a.dt = b.dt