--FROM

SELECT date_trunc('day', block_timestamp), avg(event_amount_usd/event_amount)

--distinct(origin_address) as addresses_claimed, amount_usd

--as Total_amount_in_USD, sum(amount) as Total_tokens_claimed

--event_name, event_type, block_timestamp

from terra.transfers

where event_currency = 'LUNA'

-- group by block_timestamp

AND block_timestamp > CURRENT_DATE - 7

group by block_timestamp

order by block_timestamp desc