Query editor
/*ЗАДАЧА: Считать ежедневный объем вывода (withdrawals) ETH через официальный мост Base за последние 30 дней.АНАЛИЗ ПРОБЛЕМЫ "No results":Адрес 0x49048044D57e1C92A77f79988d21Fa8fAF74E97e — это контракт Portal в сети Ethereum (L1).В сети Base (L2) за вывод ETH отвечает контракт L2StandardBridge: 0x4200000000000000000000000000000000000010.Когда мы ищем в `base.transactions`, нам нужно использовать именно L2 адрес.*/WITH daily_eth_withdrawals AS (SELECTdate_trunc('day', block_time) AS day,SUM(CAST(value AS DOUBLE) / 1e18) AS eth_amountFROM base.transactionsWHERE "to" = 0x4200000000000000000000000000000000000010 -- L2 Standard Bridge на BaseAND success = trueAND block_time > now() - interval '30' dayAND value > 0 -- Нас интересуют только транзакции с ETHGROUP BY 1),eth_prices AS (SELECTdate_trunc('day', minute) AS day,AVG(price) AS avg_priceFROM prices.usdWHERE blockchain = 'ethereum'AND symbol = 'WETH'AND minute > now() - interval '30' dayGROUP BY 1)SELECTw.day,ROUND(w.eth_amount, 4) AS eth_withdrawn,ROUND(w.eth_amount * p.avg_price, 2) AS usd_valueFROM daily_eth_withdrawals wLEFT JOIN eth_prices p ON w.day = p.dayORDER BY w.day DESC