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_dat AS (SELECT block_date AS day, COUNT(DISTINCT tx_from) AS datFROM dex.tradesWHERE blockchain = 'bnb'AND block_date >= CURRENT_DATE - INTERVAL '30' DAYAND (token_bought_address IN (SELECT addr FROM bs_toks)OR token_sold_address IN (SELECT addr FROM bs_toks))GROUP BY 1),ondo_dat AS (SELECT block_date AS day, COUNT(DISTINCT trader) AS datFROM dune.ondo_team.result_dex_ondo WHERE block_date >= CURRENT_DATE - INTERVAL '30' DAY GROUP BY 1),xs_addrs AS (SELECT DISTINCT CAST(address AS varchar) AS address FROM query_5381782),xse_addrs AS (SELECT address AS addr FROM query_5746671),xs_dat AS (SELECT day, COUNT(DISTINCT trader) AS dat FROM (SELECT CAST(date_trunc('day', block_time) AS date) AS day, CAST(trader_id AS varchar) AS traderFROM dex_solana.tradesWHERE block_month >= date_trunc('month', CURRENT_DATE - INTERVAL '30' DAY)AND block_time >= CAST(CURRENT_DATE - INTERVAL '30' DAY 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'UNION ALLSELECT block_date, '0x' || to_hex(tx_from)FROM dex.tradesWHERE blockchain <> 'xlayer'AND block_date >= CURRENT_DATE - INTERVAL '30' DAYAND (token_bought_address IN (SELECT addr FROM xse_addrs) OR token_sold_address IN (SELECT addr FROM xse_addrs))UNION ALLSELECT day, '0x' || TO_HEX(wallet)FROM dune.okxweb3wallet.result_xlayer_xstocks_tx_tradesWHERE day >= CAST(CURRENT_TIMESTAMP + INTERVAL '8' HOUR AS DATE) - INTERVAL '30' DAY) u GROUP BY day),sunrise_toks AS (SELECT token_mint_address AS address FROM tokens_solana.fungibleWHERE token_version = 'spl_token_2022' AND token_uri LIKE 'https://trek-labs.github.io/heart-metadata/stocks/%'),sunrise_dat AS (SELECT CAST(date_trunc('day', block_time) AS date) AS day, COUNT(DISTINCT trader_id) AS datFROM dex_solana.tradesWHERE block_month >= date_trunc('month', CURRENT_DATE - INTERVAL '30' DAY)AND block_time >= CAST(CURRENT_DATE - INTERVAL '30' DAY AS timestamp)AND (token_bought_mint_address IN (SELECT address FROM sunrise_toks)OR token_sold_mint_address IN (SELECT address FROM sunrise_toks))GROUP BY 1),rh_toks AS (SELECT DISTINCT address AS addr FROM robinhood.creation_traces