select block_timestamp::date as "date"

,sum(amount) as tokens_emitted, 'emitted' as event

from solana.core.fact_transfers

where mint='BWXrrYFhT7bMHmNBFoQFWdsSgA3yXoAnMhDK6Fn1eSEn'

and tx_from='AojtngqK2RoX5WXhnEfBmduZnGZfZYi8jMy69wzXKYPM'

group by "date"

union

select block_timestamp::date as "date",sum(amount)*-1 as tokens_burned, 'tokens burned' as event from solana.core.fact_transfers

where tx_from in ('DP3zXYgexeiCrMs2wqmVoewWtHu1ZWnG3Dgrm11s8cPa','3Z4xR2Pn3qUrKxHaeFXmmShXb7xVe2aWUiKDwb3rPtCd')

and tx_to='d4sH8ckL3iowTSin8gQaXtY9nQvdKCx2jimiV9qdndd'

and mint='BWXrrYFhT7bMHmNBFoQFWdsSgA3yXoAnMhDK6Fn1eSEn'

and block_timestamp > CURRENT_DATE - interval ' 1 month'

group by "date"