contract_address,

sum (amount_usd) as volume,

case when contract_address ='0x4c2393aae4f0ad55dfd4ddcfa192f817d1b28d1f' then 'OptiPunks'

when contract_address ='0xa698713a3bc386970cdc95a720b5754cc0f96931' then 'Words'

when contract_address = '0x81b30ff521d1feb67ede32db726d95714eb00637' then 'Optimistic Explorer'

when contract_address = '0x8e56343adafa62dac9c9a8ac8c742851b0fb8b03' then 'Bored Town'

when contract_address ='0xb8df6cc3050cc02f967db1ee48330ba23276a492' then 'OptiPunks'

when contract_address ='0x51e5426ede4e2d4c2586371372313b5782387222' then 'Apetimism'

when contract_address = '0xb91b2276bd5a98994bf1f496e3886f688f8d4581' then 'Kasou-shin Genesis NFTs'

when contract_address = '0x69a68eb548a37ee475d9f89646945588558796d1' then 'Oliens'

when contract_address = '0xa95579592078783b409803ddc75bb402c217a924' then 'Optimism Collective: Hello World'

when contract_address = '0x16d79da5b4894a1655a9d0e6125b9572b42fcc3b' then 'Mirror: Optimism Collective'

when contract_address = '0xe0a3711d4286e628998d47bef524c292defd1719' then 'Holo Mask : White & Black'

when contract_address = '0xc36442b4a4522e871399cd717abdd847ab11fe88' then 'Uniswap V3 Positions'

when contract_address = '0x40426c367f44c37e10f0a452574c2f84dcba3038' then 'Galaxy Gans'

when contract_address = '0x0d21136236c0731378286be2ea3611a19280dd56' then 'Holo Mask : Blue'

end as collection

from optimism.core.fact_event_logs t1 join optimism.core.ez_eth_transfers t2 on t1.tx_hash = t2.tx_hash

where t1.event_name = 'Transfer'

and t1.TX_STATUS = 'SUCCESS'

and identifier = 'CALL_ORIGIN'

and contract_address !='0x4200000000000000000000000000000000000042'

and t1.origin_to_address in ('0x3f9da045b0f77d707ea4061110339c4ea8ecfa70','0x065e8a87b8f11aed6facf9447abe5e8c5d7502b6','0x20975da6eb930d592b9d78f451a9156db5e4c77b')

and t1.origin_function_signature = '0x912d97fc'

group by 1,3

order by 2 desc

limit 4