Query editor
/* ================================================================Unique Traders for Clanker Tokens (Base)---------------------------------------------------------------Uses query_4405741 as the token dictionary.================================================================ */WITH created_contracts AS (SELECT'Clanker' AS project,tokenAddressFROM query_4405741),dex_trades AS (SELECTtx_from AS trader,token_bought_address,token_sold_addressFROM dex.tradesWHEREblockchain = 'base'AND block_time > TRY_CAST('2024-11-08' AS TIMESTAMP)AND amount_usd > 1),unioned_trades AS (SELECT trader, token_bought_address AS tokenAddress FROM dex_tradesUNION ALLSELECT trader, token_sold_address AS tokenAddress FROM dex_trades),unique_traders AS (SELECT DISTINCTu.traderFROM unioned_trades uINNER JOIN created_contracts cON c.tokenAddress = u.tokenAddress)SELECT traderFROM unique_tradersORDER BY trader;