Query editor
With contracts as (SELECT * FROM (VALUES(0x6c247b1F6182318877311737BaC0844bAa518F5e, 'Morpho'),(0xc32e96B4C7EB7959B6A92f3f7eD5d2321e6ed3D4, 'Pendle: SY-thBILL'),(0x5886e46E6DD497d7501f103a58ff4242bCaa2556, 'Uniswap')) AS t(contract, project)),transfers as(select block_date, amount, b.projectfrom tokens.transfers a join contracts b on a.to = b.contractwhere blockchain = 'arbitrum'and block_month >= date('2025-08-01')and contract_address = 0xfDD22Ce6D1F66bc0Ec89b20BF16CcB6670F55A5aunion allselect block_date, -amount, b.project-- select min(block_date)from tokens.transfers a join contracts b on a."from" = b.contractwhere blockchain = 'arbitrum'and block_month >= date('2025-08-01')and contract_address = 0xfDD22Ce6D1F66bc0Ec89b20BF16CcB6670F55A5a),t1 as(select block_date as dt,project-- ,sum(amount) amount,SUM(SUM(amount)) OVER (PARTITION BY project ORDER BY block_date) AS amtfrom transfersgroup by 1,2)select * from t1where dt >= date('2025-09-01')ORDER BY 1 DESC, amt desc