select

block_timestamp::date as time,

origin_from_address,

case when symbol_in = 'WETH' then amount_in * -1 end as "Sell Volume",

case

when origin_from_address in

('0x59abf3837fa962d6853b4cc0a19513aa031fd32b','0x52da49c343df2d1880ec79df9c89a962afc8691d',

'0x99072e1422377d808d5599a78aa7e772b988c0fb', '0xd11fd269ac6b602e42abb6f0f186cd5b27180ffd',

'0x44b53564b95530a0bc708900089e685eef12fa6e', '0xc0c847b14965df7e7eaa003ea987c6187211d85f',

'0x11133bcf0ecbe48e74a4d787bb047aa5bc2c5cab', '0x7f3debba84491401bd4fe51c1a1926b049189d57',

'0x3e957efc6d1bf1d9141212269cd04855ad92696e', '0xd53c2e2d17281487023c1e4433f7ac95b88d7277',

'0x5ab55afcbfde83e0b3fbeff67ed0da73ba7b629c', '0xa122d2d3d147732e2b5cce7d43a8c20e99c569f1',

'0x9b10ca213be20b8bc2a398839edd1f6406dc9b47', '0x8059c2b8ff915ec4b615c95e719861f269d68ada',

'0x866eeecd1f248d1a0a2e0263f13594a6b8b7c01a') then 'Hacker Wallets'

else 'Regular activity' end as swapper,

row_number() over (partition by time order by "Sell Volume" ASC) as rank

from ethereum.core.ez_dex_swaps

where block_timestamp >= CURRENT_DATE - 7

and (symbol_in = 'WETH' or symbol_out = 'WETH')

order by "Sell Volume" ASC

)

select

time, origin_from_address, sum("Sell Volume"), swapper, rank from trades

where rank <=5

group by time, origin_from_address, swapper, rank