SELECT date(date) as date1,Address_name,count(Balance_USD),sum(Balance_usd)

from terra.daily_balances

where address_label='astroport' and currency='LUNA' and balance_type='liquid'

group by 1,2

SELECT * from data1

LIMIT 1000