sum(balance) AS totalMinted

from terra.daily_balances

where currency = 'LUNA'

and balance_type = 'liquid'

group by 1

select DISTINCT

date_trunc('day',block_timestamp) AS Date,

sum(event_attributes:minted/(1e6)) over (order by date_trunc('day',block_timestamp)) AS totalMinted

from terra.msg_events

where /*tx_id = 'C625CB8FE1E6AE5AB39024965DCFA1AE74D5F131B9E4AA8B8B5125B271D7C283'

and */event_attributes:"0_contract_address" = 'terra1mtwph2juhj0rvjz7dy92gvl6xvukaxu8rfv8ts'

and event_attributes:"1_contract_address" = 'terra1kc87mu460fwkqte29rquh4hc20m54fxwtsx7gp'

and event_attributes:"2_contract_address" = 'terra17yap3mhph35pcwvhza38c2lkj7gzywzy05h7l0'

order by 1 desc