select (balance) as supply ,
date_trunc('day',date) as date
from terra.daily_balances where currency = 'LUNA'
and date>'2021-11-01'
and is_native ='TRUE'
and address_label_subtype <> 'mints_burns'
and balance_type !='staked'
and address != 'terra1fl48vsnmsdzcv85q5d2q4z5ajdha8yu3nln0mh'
group by 1,2