case when tx_from='DP3zXYgexeiCrMs2wqmVoewWtHu1ZWnG3Dgrm11s8cPa' then 'Burned through POL- Protocol owned liquidity'

when tx_from='3Z4xR2Pn3qUrKxHaeFXmmShXb7xVe2aWUiKDwb3rPtCd' then 'Burned through auctions'

else 'other'

end as type

,sum(amount) as amount_

, sum(amount_) over(order by "date" asc) as total_amt

, sum(amount_) over(partition by type order by "date" asc) as total_amtpart

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 1,2

order by 1 desc