Query editor
-- Tokenization / RWA Sector: Ondo, Centrifuge, Maple-- Using ERC20 transfer events as proxy for tokenized asset flowWITH ondo AS (SELECTCAST(block_time AS date) AS block_date,'Ondo' AS protocol,SUM(amount_usd) AS volume_usd,COUNT(DISTINCT CAST(tx_from AS varchar)) AS active_users,COUNT(*) AS transfer_countFROM dex.tradesWHERE (token_bought_symbol IN ('OUSG', 'USDY', 'ONDO') OR token_sold_symbol IN ('OUSG', 'USDY', 'ONDO'))AND block_month >= DATE_TRUNC('month', CURRENT_DATE - INTERVAL '90' DAY)AND block_time >= CURRENT_DATE - INTERVAL '90' DAYGROUP BY 1),centrifuge AS (SELECTCAST(block_time AS date) AS block_date,'Centrifuge' AS protocol,SUM(amount_usd) AS volume_usd,COUNT(DISTINCT CAST(tx_from AS varchar)) AS active_users,COUNT(*) AS transfer_countFROM dex.tradesWHERE (token_bought_symbol = 'CFG' OR token_sold_symbol = 'CFG')AND block_month >= DATE_TRUNC('month', CURRENT_DATE - INTERVAL '90' DAY)AND block_time >= CURRENT_DATE - INTERVAL '90' DAYGROUP BY 1),maple AS (SELECTCAST(block_time AS date) AS block_date,'Maple' AS protocol,SUM(amount_usd) AS volume_usd,COUNT(DISTINCT CAST(tx_from AS varchar)) AS active_users,COUNT(*) AS transfer_countFROM dex.tradesWHERE (token_bought_symbol IN ('MPL', 'SYRUP') OR token_sold_symbol IN ('MPL', 'SYRUP'))AND block_month >= DATE_TRUNC('month', CURRENT_DATE - INTERVAL '90' DAY)AND block_time >= CURRENT_DATE - INTERVAL '90' DAYGROUP BY 1),combined AS (SELECT *, volume_usd * 0.003 AS estimated_fees_usd FROM ondoUNION ALLSELECT *, volume_usd * 0.003 AS estimated_fees_usd FROM centrifugeUNION ALLSELECT *, volume_usd * 0.003 AS estimated_fees_usd FROM maple)SELECTblock_date,protocol,volume_usd,estimated_fees_usd,active_users,transfer_count,