Query editor
------------------------------------------------------------- Ethereum -------------------------------------------------------------WITH harvestProtocolFees AS (SELECT'ethereum' AS Chain, 'Ethereum' AS Category, 'pzETH' AS Silo, call_block_time, contract_address, output_amount, CASEWHEN ELEMENT_AT(output_harvestedAmounts, 1) = output_amount THEN 'pzETH'WHEN ELEMENT_AT(output_harvestedAmounts, 2) = output_amount THEN 'WETH'WHEN ELEMENT_AT(output_harvestedAmounts, 3) = output_amount THEN 'USDC'ELSE NULL END AS Token, call_tx_hashFROM silo_ethereum.Silo_Ethereum_pzETH_call_harvestProtocolFeesCROSS JOIN UNNEST(output_harvestedAmounts) AS t(output_amount)UNION ALLSELECT'ethereum' AS Chain, 'Ethereum' AS Category, 'Re7LRT' AS Silo, call_block_time, contract_address, output_amount, CASEWHEN ELEMENT_AT(output_harvestedAmounts, 1) = output_amount THEN 'Re7LRT'WHEN ELEMENT_AT(output_harvestedAmounts, 2) = output_amount THEN 'WETH'WHEN ELEMENT_AT(output_harvestedAmounts, 3) = output_amount THEN 'USDC'ELSE NULL END AS Token, call_tx_hashFROM silo_ethereum.Silo_Ethereum_Re7LRT_call_harvestProtocolFeesCROSS JOIN UNNEST(output_harvestedAmounts) AS t(output_amount)UNION ALLSELECT'ethereum' AS Chain, 'Ethereum' AS Category, 'amphrETH' AS Silo, call_block_time, contract_address, output_amount, CASEWHEN ELEMENT_AT(output_harvestedAmounts, 1) = output_amount THEN 'amphrETH'WHEN ELEMENT_AT(output_harvestedAmounts, 2) = output_amount THEN 'WETH'WHEN ELEMENT_AT(output_harvestedAmounts, 3) = output_amount THEN 'USDC'ELSE NULL END AS Token, call_tx_hashFROM silo_ethereum.Silo_Ethereum_amphrETH_call_harvestProtocolFeesCROSS JOIN UNNEST(output_harvestedAmounts) AS t(output_amount)UNION ALLSELECT'ethereum' AS Chain