date_trunc('day',block_timestamp) as days, token_0_currency, token_1_currency, avg(price1_usd) as LUNA, avg(price0_usd) as UST

from

terra.swaps

where token_0_currency = 'UST' and token_1_currency = 'LUNA'

and days between '2021-06-01' and CURRENT_DATE

group by 1,2,3

limit 1000