Query editor
WITH stables AS (SELECT contract_address FROM (VALUES(0xdac17f958d2ee523a2206206994597c13d831ec7), -- USDT(0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48), -- USDC(0x6b175474e89094c44da98b954eedeac495271d0f), -- DAI(0x4fabb145d64652a948d72533023f6e7a623c7c53), -- BUSD(0x853d955acef822db058eb8505911ed77f175b99e), -- FRAX(0x0000000000085d4780b73119b644ae5ecd22b376), -- TUSD(0x8e870d67f660d95d5be530380d0ec0bd388289e1), -- USDP(0x6c3ea9036406852006290770bedfcaba0e23a0e8), -- PYUSD(0xdc035d45d973e3ec169d2276ddab16f1e407384f) -- USDS) AS t(contract_address)),xfer AS (SELECTdate_trunc('month', block_time) AS date,SUM(amount_usd) AS transfer_volume_usdFROM tokens.transfersWHERE blockchain = 'ethereum'AND contract_address IN (SELECT contract_address FROM stables)AND block_time >= TIMESTAMP '2021-01-01'GROUP BY 1),dex AS (SELECTdate_trunc('month', block_time) AS date,SUM(amount_usd) AS total_usd,SUM(CASE WHEN token_bought_address IN (SELECT contract_address FROM stables)OR token_sold_address IN (SELECT contract_address FROM stables)THEN amount_usd ELSE 0 END) AS stable_usdFROM dex.tradesWHERE blockchain = 'ethereum'AND block_time >= TIMESTAMP '2021-01-01'GROUP BY 1)SELECTx.date,x.transfer_volume_usd,d.stable_usd / NULLIF(d.total_usd, 0) AS dex_shareFROM xfer xLEFT JOIN dex d ON d.date = x.dateORDER BY x.date