date_trunc('day',block_timestamp) as days,

sum(offer_amount_usd) as swapUSD,

sum(swap_fee_amount_usd) as feeUSD,

feeUSD/swapUSD as ratio

from terra.swaps

group by 1