Query editor
--Possibly relevant tables based on your question: ['uniswap_v2_ethereum.trades', 'uniswap_ethereum.UniToken_evt_Transfer', 'uniswap_ethereum.Exchange_evt_Transfer']WITH ReceivedLEND AS (SELECTevt_block_time,"to" AS wallet,SUM(amount) AS total_received_lendFROM uniswap_ethereum.UniToken_evt_TransferWHEREcontract_address = 0x2C06BA9e7F0dACcbC1f6A33EA67e85bb68fbEE3aAND "to" IN (0xba694bAc1387DD1e10c1E2CFb29fD5890431B8A0)GROUP BY1,2), SoldLEND AS (SELECTDATE_TRUNC('day', t.block_time) AS block_day,t.tx_from AS wallet,SUM(token_sold_amount) AS total_sold_lendFROM uniswap_v2_ethereum.trades AS tWHEREtoken_sold_symbol = 'LEND'AND token_sold_address = 0x2C06BA9e7F0dACcbC1f6A33EA67e85bb68fbEE3aAND t.tx_from IN (0xba694bAc1387DD1e10c1E2CFb29fD5890431B8A0)GROUP BY1,2)SELECTr.evt_block_time AS block_day,r.wallet,r.total_received_lend,COALESCE(s.total_sold_lend, 0) AS total_sold_lendFROM ReceivedLEND AS rLEFT JOIN SoldLEND AS sON r.wallet = s.wallet AND DATE_TRUNC('day', r.evt_block_time) = s.block_dayUNIONSELECTs.block_day,s.wallet,COALESCE(r.total_received_lend, 0) AS total_received_lend,s.total_sold_lendFROM SoldLEND AS sLEFT JOIN ReceivedLEND AS rON r.wallet = s.wallet AND DATE_TRUNC('day', r.evt_block_time) = s.block_day