with users as ( select date(a.block_timestamp) as date,

a.tx_hash,

a.sender,

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

where a.success = 'TRUE'

and a.tx_type = 'user_transaction'

,

project as (

select date,

case

when event_address = '0x17f1e926a81639e9557f4e4934df93452945ec30bc962e11351db59eb0d78c33' then 'amnis finance'

when event_address = '0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06' then 'merkle'

when event_address = '0x17f1e926a81639e9557f4e4934df93452945ec30bc962e11351db59eb0d78c33' then 'VibrantX'

when event_address = '0x9770fa9c725cbd97eb50b2be5f7416efdfd1f1554beb0750d4dae4c64e860da3' then 'Aries'

when event_address = '0x6f986d146e4a90b828d8c12c14b6f4e003fdff11a8eecceceb63744363eaac01'then 'thala'

when event_address = '0x6b3720cd988adeaf721ed9d4730da4324d52364871a68eac62b46d21e4d2fa99' then 'thala'

when event_address = '0x3c4a58b4a8dffe6d14448072efcdd5a0e0089a22c6837b94f1d7e8bb1552137f'then 'thala'

when event_address = '0xe7c7bb0e53fc6fb86aa7464645fbac96b96716463b4e2269c62945c135aa26fd' then 'Galxe'

when event_address = '0x31a6675cbe84365bf2b0cbce617ece6c47023ef70826533bde5203d32171dc3c' then 'sushiswap'

when event_address = '0x54ad3d30af77b60d939ae356e6606de9a4da67583f02b962d2d3f2e481484e90' then 'layerzero'

when event_address = '0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1' then 'Cellana'

when event_address = '0x1c3206329806286fd2223647c9f9b130e66baeb6d7224a18c1f642ffe48f3b4c' then 'Panora'

when event_address = '0x3c1d4a86594d681ff7e5d5a233965daeabdc6a15fe5672ceeda5260038857183' then 'Abtin'

when event_address = '0x43d8cad89263e6936921a0adb8d5d49f0e236c229460f01b14dca073114df2b9' then 'layerzero'

when event_address = '0xfe2ffdb3a74307f7314a1c8ab3762b6b5869a3c1278cdd5d230249453e15a1db' then 'petra name'

when event_address = '0x7893a5d6cd60610f2bad22bb29668e596d14245b682d508a0794ce69613bcaab' then 'amnis finance'

when event_address = '0xc0188ad3f42e66b5bd3596e642b8f72749b67d84e6349ce325b27117a9406bdf' then 'Abel'

when event_address = '0xfaf4e633ae9eb31366c9ca24214231760926576c7b625313b3688b5e900731f6' then 'thala'

when event_address = '0xd1fd99c1944b84d1670a2536417e997864ad12303d19eac725891691b04d614e' then 'bluemove'

when event_address = '0x16fe2df00ea7dde4a63409201f7f4e536bde7bb7335526a35d05111e68aa322c' then 'Animeswap'

when event_address = '0x867ed1f6bf916171b1de3ee92849b8978b7d1b9e0a8cc982a3d19d535dfd9c0c' then 'aptos name service'

when event_address = '0x890812a6bbe27dd59188ade3bbdbe40a544e6e104319b7ebc6617d3eb947ac07' then 'Hippo aggregator'