TO_ADDRESS AS whale,

sum(ETH_VALUE) AS bought_amount_in_ETH

FROM optimism.core.fact_transactions

WHERE BLOCK_TIMESTAMP>CURRENT_DATE-7

AND STATUS='SUCCESS'

AND TX_JSON:receipt:logs[0]:address=lower('0x4200000000000000000000000000000000000042')

OR TX_JSON:receipt:logs[1]:address=lower('0x4200000000000000000000000000000000000042')

OR TX_JSON:receipt:logs[2]:address=lower('0x4200000000000000000000000000000000000042')

OR TX_JSON:receipt:logs[3]:address=lower('0x4200000000000000000000000000000000000042')

AND whale NOT IN('0x9c12939390052919af3155f41bf4160fd3666a6f', '0x68b3465833fb72a70ecdf485e0e4c7bd8665fc45'

,'0x6f9d14cf4a06dd9c70766bd161cf8d4387683e1b','0x2967e7bb9daa5711ac332caf874bd47ef99b3820','0xd7f1dd5d49206349cae8b585fcb0ce3d96f1696f'

,'0x69dd38645f7457be13571a847ffd905f9acbaf6d', '0xc36442b4a4522e871399cd717abdd847ab11fe88')

GROUP BY 1

ORDER BY 2 DESC

LIMIT 50