Query editor
WITH bs_toks AS (SELECT d.proxy AS addrFROM bstocks_bnb.securitiestokenfactory_evt_tokendeployed dJOIN tokens.erc20 e ON e.blockchain = 'bnb' AND e.contract_address = d.proxyWHERE UPPER(d.symbol) NOT LIKE 'TEST%' AND e.symbol IS NOT NULL),bs_tx AS (SELECTtx_hash,GREATEST(COALESCE(SUM(CASE WHEN token_bought_address IN (SELECT addr FROM bs_toks) THEN amount_usd ELSE 0 END), 0),COALESCE(SUM(CASE WHEN token_sold_address IN (SELECT addr FROM bs_toks) THEN amount_usd ELSE 0 END), 0)) AS usdFROM dex.tradesWHERE blockchain = 'bnb'AND block_date >= CURRENT_DATE - INTERVAL '7' DAYAND block_date < CURRENT_DATEAND (token_bought_address IN (SELECT addr FROM bs_toks)OR token_sold_address IN (SELECT addr FROM bs_toks))GROUP BY tx_hash),bs_total AS (SELECT COALESCE(SUM(usd), 0) AS v FROM bs_tx),ondo_total AS (SELECT COALESCE(SUM(usd), 0) AS vFROM (SELECT blockchain, tx_hash, MAX(amount_usd) AS usdFROM dune.ondo_team.result_dex_ondoWHERE block_date >= CURRENT_DATE - INTERVAL '7' DAYAND block_date < CURRENT_DATEGROUP BY 1, 2) t),xs_addrs AS (SELECT DISTINCT CAST(address AS varchar) AS address FROM query_5381782),xs_total AS (SELECT COALESCE(SUM(usd), 0) AS v FROM (SELECT tx_id, greatest(coalesce(sum(amount_usd) FILTER (WHERE side = 'buy'), 0),coalesce(sum(amount_usd) FILTER (WHERE side = 'sell'), 0)) AS usdFROM (SELECT tx_id, amount_usd,CASE WHEN token_bought_mint_address IN (SELECT address FROM xs_addrs) THEN 'buy' ELSE 'sell' END AS sideFROM dex_solana.tradesWHERE block_month >= date_trunc('month', CURRENT_DATE - INTERVAL '7' DAY)AND block_time >= CAST(CURRENT_DATE - INTERVAL '7' DAY AS timestamp)AND block_time < CAST(CURRENT_DATE AS timestamp)AND (token_bought_mint_address IN (SELECT address FROM xs_addrs)OR token_sold_mint_address IN (SELECT address FROM xs_addrs))AND tx_id <> '26kRGiSJxFtRu7PajK9TZwauLHzyjKmhA3uZ47RYRYVFHZVqZYunn7priX4qCEw2K39CNAsr7DbmYxqNfCzig94o') l GROUP BY tx_id) t),xse_addrs AS (SELECT address AS addr FROM query_5746671),xs_evm_total AS (SELECT COALESCE(SUM(usd), 0) AS v FROM (SELECT tx_hash,greatest(coalesce(sum(CASE WHEN token_bought_address IN (SELECT addr FROM xse_addrs) THEN amount_usd ELSE 0 END), 0),