Query editor
WITH bs_toks AS (SELECT d.proxy AS addr, substr(e.symbol, 1, length(e.symbol) - 1) AS tickerFROM 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_legs AS (SELECTt.tx_hash,t.block_date AS day,t.tx_from AS trader,CASEWHEN t.token_bought_address IN (SELECT addr FROM bs_toks)THEN COALESCE(t.token_bought_symbol, '?') || '/' || COALESCE(t.token_sold_symbol, '?')ELSE COALESCE(t.token_sold_symbol, '?') || '/' || COALESCE(t.token_bought_symbol, '?')END AS pair,CASE WHEN t.token_bought_address IN (SELECT addr FROM bs_toks) THEN 'buy' ELSE 'sell' END AS side,t.amount_usdFROM dex.trades tWHERE t.blockchain = 'bnb'AND t.block_date >= CURRENT_DATE - INTERVAL '7' DAYAND t.block_date < CURRENT_DATEAND (t.token_bought_address IN (SELECT addr FROM bs_toks)OR t.token_sold_address IN (SELECT addr FROM bs_toks))),bs_tx_pair AS (SELECTpair,day,tx_hash,MAX(trader) AS trader,GREATEST(COALESCE(SUM(amount_usd) FILTER (WHERE side = 'buy'), 0),COALESCE(SUM(amount_usd) FILTER (WHERE side = 'sell'), 0)) AS usdFROM bs_legsGROUP BY 1, 2, 3),bs_daily AS (SELECT'bStocks' AS project,'bnb' AS blockchain,pair,day,SUM(usd) AS volume_usd,COUNT(*) AS trades,COUNT(DISTINCT trader) AS traders_dFROM bs_tx_pairGROUP BY 1, 2, 3, 4),ondo_evm_rows AS (SELECT tx_hash, block_date AS day, blockchain, symbol, trader, amount_usdFROM (SELECT *,ROW_NUMBER() OVER (PARTITION BY blockchain, tx_hash