Query editor
WITH all_events AS (SELECT chain AS blockchain, evt_block_date, evt_tx_hash, token, amountFROM rhino_fi_multichain.dvfdepositcontract_evt_bridgeddepositWHERE evt_block_date >= CURRENT_DATE - INTERVAL '30' DAYAND evt_block_date < CURRENT_DATEUNION ALLSELECT chain AS blockchain, evt_block_date, evt_tx_hash, token, amountFROM rhino_fi_multichain.dvfdepositcontract_evt_bridgedwithdrawalWHERE evt_block_date >= CURRENT_DATE - INTERVAL '30' DAYAND evt_block_date < CURRENT_DATE),priced AS (SELECTe.blockchain,e.evt_tx_hash,CAST(e.amount AS DOUBLE) / POWER(10, COALESCE(t.decimals, 18)) * COALESCE(p.price, 0) AS volume_usdFROM all_events eLEFT JOIN tokens.erc20 tON e.blockchain = t.blockchain AND e.token = t.contract_addressLEFT JOIN prices.usd_daily pON e.blockchain = p.blockchainAND e.token = p.contract_addressAND e.evt_block_date = p.day)SELECTblockchain,COUNT(DISTINCT evt_tx_hash) AS tx_count,SUM(volume_usd) AS volume_usd,SUM(CASE WHEN volume_usd > 0 THEN 1 ELSE 0 END) AS priced_txs,SUM(CASE WHEN volume_usd = 0 THEN 1 ELSE 0 END) AS unpriced_txsFROM pricedGROUP BY 1ORDER BY volume_usd DESC