Query editor
selectethereum_address as "Ethereum Address", SUM(amount) as "Staked Amount", duration as "Duration", casewhen duration = 7776000then '3_months'when duration = 15552000then '6_months'when duration = 23328000then '9_months'when duration = 31104000then '12_months'else'unknown_duration'end as duration_typefrom (selectLOWER(TO_HEX(bytearray_substring (topic1, 13, 20))) as ethereum_address, bytearray_to_int256 (bytearray_substring (topic2, 1, 32)) as duration, bytearray_to_int256 (bytearray_substring (data, 1, 32)) / POWER(10, 18) as amount, block_timefrom base.logswhere contract_address = 0xC9714F8f036087d801f38C4105194e150d3a1864and topic0 = 0x44cebfefa4561bee5b61d675ccfd8dc9969fff9cc15e7a4eccccd62af94f9c11 -- Lockedand block_time >= TIMESTAMP '2025-06-08 00:00:00') tgroup byethereum_address, durationorder by"Staked Amount" desclimit 100;