Query editor
WITH fees AS (SELECT DATE_TRUNC('day', block_time) AS day,SUM(CAST(varbinary_to_uint256(varbinary_substring(data, 1, 32)) AS DOUBLE) / 1e18) AS protocol_ethFROM robinhood.logsWHERE contract_address = 0x50b9af842dacb8fc7476660cc86d3787cad66ac4AND topic0 = 0x5c0ce1b1916761250fab78a3ec6e398bbaabd1537003983889748c0c1e5644e3AND varbinary_substring(topic1, 13, 20) = 0x0000000f7ccd4072641b091f59f2ccd107fed445GROUP BY 1), eth_price AS (SELECT DATE_TRUNC('day', timestamp) AS day, AVG(price) AS eth_usdFROM prices.dayWHERE blockchain = 'robinhood'AND contract_address = 0x0bd7d308f8e1639fab988df18a8011f41eacad73GROUP BY 1)SELECT COALESCE(SUM(f.protocol_eth * p.eth_usd), 0) AS total_protocol_revenue_usdFROM fees f LEFT JOIN eth_price p ON p.day = f.day