SELECT date, SUM(balance) as cs , (822004150-sum(balance)) as ncs
FROM terra.daily_balances
WHERE address != 'terra1fl48vsnmsdzcv85q5d2q4z5ajdha8yu3nln0mh' and currency IN ('LUNA', 'bLUNA') and date > DATEADD(month, -1, CURRENT_DATE)
and balance_type = 'liquid' and (ADDRESS_LABEL IS NULL OR ADDRESS_LABEL_TYPE = 'cex' OR ADDRESS_LABEL_SUBTYPE = 'bridge')
GROUP BY date