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.evt_block_date,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)SELECTevt_block_date AS block_date,COUNT(DISTINCT evt_tx_hash) AS tx_count,SUM(volume_usd) AS daily_volume_usdFROM pricedGROUP BY 1ORDER BY 1