sum(amount) as sale_volume,

date_trunc('day', block_timestamp::date) as TIME,

case

when origin_to_address = '0x20975da6eb930d592b9d78f451a9156db5e4c77b' then 'Pre-Exploit0'

when origin_to_address = '0x065e8a87b8f11aed6facf9447abe5e8c5d7502b6' then 'Pre-Exploit1'

when origin_to_address = '0x3f9da045b0f77d707ea4061110339c4ea8ecfa70' then 'Post-Exploit'

end as contracts

from optimism.core.ez_eth_transfers

where eth_to_address in (

'0x20975da6eb930d592b9d78f451a9156db5e4c77b',

'0x065e8a87b8f11aed6facf9447abe5e8c5d7502b6',

'0x3f9da045b0f77d707ea4061110339c4ea8ecfa70')

and origin_to_address in (

'0x20975da6eb930d592b9d78f451a9156db5e4c77b',

'0x065e8a87b8f11aed6facf9447abe5e8c5d7502b6',

'0x3f9da045b0f77d707ea4061110339c4ea8ecfa70')

and IDENTIFIER = 'CALL_ORIGIN'

group by TIME, contracts