from osmosis.core.dim_labels

where LABEL= 'Tether USD' or

LABEL= 'USD Coin' or

LABEL= 'Dai Stablecoin')

select date_trunc('day', BLOCK_TIMESTAMP)as date , count(distinct TX_ID),sum(FROM_AMOUNT/FROM_DECIMAL) as amount, LABEL

from osmosis.core.fact_swaps

where date > CURRENT_DATE - 180

group by 1, 4