date_trunc('day',block_timestamp) as days, avg(event_amount) as amt, avg(event_amount_usd) as usd, usd/amt as LUNA_price

from terra.transfers

where event_currency = 'LUNA'

and days < CURRENT_DATE

group by 1

order by 1 desc

limit 14