a.tx_hash,

a.sender,

case when b.PAYLOAD_FUNCTION = '0x7de3fea83cd5ca0e1def27c3f3803af619882db51f34abf30dd04ad12ee6af31::tapos::play' then 'Tapos'

when b.PAYLOAD_FUNCTION ilike '%0x8d2d7bcde13b2513617df3f98cdd5d0e4b9f714c6308b9204fe18ad900d92609%' then 'Chingari' else event_address end as event

from aptos.core.fact_transactions a join aptos.core.fact_events b on a.tx_hash = b.tx_hash

where a.success = 'TRUE'

and b.SUCCESS = 'TRUE'

and a.tx_type = 'user_transaction'

and b.tx_type = 'user_transaction'

,

project as (select date,

case when event = '0x17f1e926a81639e9557f4e4934df93452945ec30bc962e11351db59eb0d78c33' then 'amnis finance'

when event = '0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06' then 'merkle'

when event = '0x17f1e926a81639e9557f4e4934df93452945ec30bc962e11351db59eb0d78c33' then 'VibrantX'

when event = '0x9770fa9c725cbd97eb50b2be5f7416efdfd1f1554beb0750d4dae4c64e860da3' then 'Aries'

when event = '0xc6bc659f1649553c1a3fa05d9727433dc03843baac29473c817d06d39e7621ba' then 'Echelon'

when event = '0x6f986d146e4a90b828d8c12c14b6f4e003fdff11a8eecceceb63744363eaac01'then 'thala'

when event = '0x92e95ed77b5ac815d3fbc2227e76db238339e9ca43ace45031ec2589bea5b8c' then 'thala'

when event = '0x163df34fccbf003ce219d3f1d9e70d140b60622cb9dd47599c25fb2f797ba6e' then 'liquidswap'

when event = '0xb247ddeee87e848315caf9a33b8e4c71ac53db888cb88143d62d2370cca0ead2' then 'liquidswap'

when event = '0x54cb0bb2c18564b86e34539b9f89cfe1186e39d89fce54e1cd007b8e61673a85' then 'liquidswap'

when event = '0x6b3720cd988adeaf721ed9d4730da4324d52364871a68eac62b46d21e4d2fa99' then 'thala'

when event = '0x3c4a58b4a8dffe6d14448072efcdd5a0e0089a22c6837b94f1d7e8bb1552137f'then 'thala'

when event = 'Chingari'then 'Chingari'

when event = '0xe7c7bb0e53fc6fb86aa7464645fbac96b96716463b4e2269c62945c135aa26fd' then 'Galxe'

when event = '0x31a6675cbe84365bf2b0cbce617ece6c47023ef70826533bde5203d32171dc3c' then 'sushiswap'

when event = '0x54ad3d30af77b60d939ae356e6606de9a4da67583f02b962d2d3f2e481484e90' then 'layerzero'

when event = '0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1' then 'Cellana'

when event = '0x1c3206329806286fd2223647c9f9b130e66baeb6d7224a18c1f642ffe48f3b4c' then 'Panora'

when event = '0x3c1d4a86594d681ff7e5d5a233965daeabdc6a15fe5672ceeda5260038857183' then 'Aptin'

when event = '0x5a96fab415f43721a44c5a761ecfcccc3dae9c21f34313f0e594b49d8d4564f4' then 'KGeN'

when event = '0xb7f5dd022310be46f769af231fb761b9ca18bc2f63237cb6d004aed8ce01336c' then 'KGeN'

when event = '0x06b43eae979756527d8475fd3645d149177cdef13ecec1d1d65d04d420411c55' then 'KGeN'