Query editor
WITH marketplaces AS (SELECT *FROM (VALUES('OTC ELF @GiftElfRobot', UPPER('0:77624ec871b5b041367733cbce52c38263ba8eda3d9249183dfde0432a5f7761')),('TONNEL Marketplace @Tonnel_Network_bot', UPPER('0:59b357b68790b09b143198024b18da843dc43d894dc10838f4352cdbc138866b')),('TONNEL Marketplace Withdrawal @Tonnel_Network_bot', UPPER('0:ee59aff2efcd2ba6211ead3bf9259b41abcb24a2f5a9d0d3cb1ed2558b7441e3')),('Nest Store @nestore_robot', UPPER('0:835e549f3148722eed4a5e4526207d9c76bee38578b742c1d61a1245e68966fe')),('WTS @wtstonbot', UPPER('0:2f110ae2feb3ca85cba7a088e03864776968486fcb7b8e338223b57ee0d6c846')),('Giftpot @giftpot_bot', UPPER('0:4a65b3ab29951a2af941c2bff1cf5c023f156cb4b33e59e5c437342e287af435')),('GiftON Market @gifton_market_bot', UPPER('0:3a127974baf796039db8bf5c55feecf808e2622d439b866ef5ec0848075e77ac'))) AS t(marketplace_name, marketplace_address)),deduped_messages AS (SELECT DISTINCT msg_hash, source, destination, valueFROM ton.messagesWHERE block_date > CAST('2025-01-01' AS DATE)),marketplace_flows AS (-- Case 1: user sent to marketplaceSELECTsource AS wallet,destination AS marketplace_address,valueFROM deduped_messagesJOIN marketplaces ON destination = marketplace_addressUNION ALL-- Case 2: marketplace sent to userSELECTdestination AS wallet,source AS marketplace_address,valueFROM deduped_messagesJOIN marketplaces ON source = marketplace_address)SELECTmf.wallet,m.marketplace_name,SUM(mf.value) / 1e9 AS total_volume_tonFROM marketplace_flows mfJOIN marketplaces m ON mf.marketplace_address = m.marketplace_addressGROUP BY m.marketplace_name, mf.walletORDER BY mf.wallet, total_volume_ton DESC;