Query editor
WITH ADDRESS_TOKEN_BALANCE AS (SELECTgtx.address,tkb.balance,tkb.token_symbol,tkb.token_address,ROW_NUMBER() OVER (PARTITION BY tkb.address, tkb.token_address ORDER BY block_number DESC) AS rnFROM tokens_ethereum.balances tkbINNER JOIN dune.elric.result_gtx_step_4_core_addresses gtxON tkb.address = gtx.addressWHERE tkb.blockchain = 'ethereum'AND tkb.token_address IN (0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48,0xdac17f958d2ee523a2206206994597c13d831ec7,0x6b175474e89094c44da98b954eedeac495271d0f)),LAST_SEEN AS (SELECTgtx.address, MAX(mt.block_time) AS last_seen_onchainFROM ethereum.transactions mtINNER JOIN dune.elric.result_gtx_step_4_core_addresses gtxON mt."from" = gtx.addressGROUP BY 1ORDER BY 2 DESC)SELECTgtx.address, ls.last_seen_onchain, erc1.balance AS USDT_balance, erc2.balance AS USDC_balance, erc3.balance AS DAI_balanceFROM dune.elric.result_gtx_step_4_core_addresses gtxLEFT JOIN LAST_SEEN lsON gtx.address = ls.addressLEFT JOIN ADDRESS_TOKEN_BALANCE erc1ON gtx.address = erc1.addressAND erc1.token_address = 0xdac17f958d2ee523a2206206994597c13d831ec7AND erc1.rn = 1LEFT JOIN ADDRESS_TOKEN_BALANCE erc2ON gtx.address = erc2.addressAND erc2.token_address = 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48AND erc2.rn = 1LEFT JOIN ADDRESS_TOKEN_BALANCE erc3ON gtx.address = erc3.addressAND erc3.token_address = 0x6b175474e89094c44da98b954eedeac495271d0fAND erc3.rn = 1ORDER BY 2 DESC