DATE | SECTOR | N_USERS | |
|---|---|---|---|
1 | 2025-03-28 00:00:00.000 | nft | 3 |
2 | 2025-03-28 00:00:00.000 | dapp | 15 |
3 | 2025-03-28 00:00:00.000 | dex | 30 |
4 | 2025-03-28 00:00:00.000 | defi | 45 |
5 | 2025-03-27 00:00:00.000 | nft | 62 |
6 | 2025-03-27 00:00:00.000 | bridge | 1 |
7 | 2025-03-27 00:00:00.000 | dex | 62 |
8 | 2025-03-27 00:00:00.000 | dapp | 35 |
9 | 2025-03-27 00:00:00.000 | defi | 196 |
10 | 2025-03-26 00:00:00.000 | dapp | 31 |
11 | 2025-03-26 00:00:00.000 | dex | 101 |
12 | 2025-03-26 00:00:00.000 | nft | 26 |
13 | 2025-03-26 00:00:00.000 | defi | 218 |
14 | 2025-03-25 00:00:00.000 | nft | 35 |
15 | 2025-03-25 00:00:00.000 | dex | 54 |
16 | 2025-03-25 00:00:00.000 | defi | 119 |
17 | 2025-03-25 00:00:00.000 | dapp | 73 |
18 | 2025-03-24 00:00:00.000 | bridge | 1 |
19 | 2025-03-24 00:00:00.000 | dapp | 96 |
20 | 2025-03-24 00:00:00.000 | defi | 233 |
0xHaM-dPACT Participants' Activities Across Aptos[2025]
Updated 2025-03-28
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- forked from Bridgers' Activities After Bridging to Aptos[2025] @ https://flipsidecrypto.xyz/studio/queries/03a7b8f9-efaa-483e-ae82-62643599444e
-- forked from Bridgers' Activities After Bridging to Aptos @ https://flipsidecrypto.xyz/studio/queries/23859cbc-beff-43b0-a29a-d3dc29cde0bf
with functionTb as (
select
BLOCK_TIMESTAMP,
case
when split(PAYLOAD_FUNCTION, '::')[0] ilike '0x6d138096fb880d1c16b48f10686b98a96000c0ac18501425378f784c6b81c34d' then 'eragon'
when split(PAYLOAD_FUNCTION, '::')[0] ilike '0x8e80b817291d0f2875dec36677d32d6a58205877e02e382429ce1d342a23c086' then 'eragon'
when split(PAYLOAD_FUNCTION, '::')[0] ilike '0xb2346c5482beea3d2e9dcd197d19d7fdbe1e43fefc58bed20e71ad0b896a0cf2' then 'eragon'
when split(PAYLOAD_FUNCTION, '::')[0] ilike '0x0183e47c7bca37445c7c8e1442cd480329ce247a6a91d9a27043ab1100a8cdd4' then 'eragon'
when split(PAYLOAD_FUNCTION, '::')[0] ilike '0x3022a85102011994552104c12171702f3c37c9ecce5a92293101c5de638b3a36' then 'eragon'
when split(PAYLOAD_FUNCTION, '::')[0] ilike '0xf9552a68230e0f4c0aa4ff3521b622ccabd8a8f07d17e453fe6fa3c091c8d495' then 'eragon'
when split(PAYLOAD_FUNCTION, '::')[0] ilike '0x17f1e926a81639e9557f4e4934df93452945ec30bc962e11351db59eb0d78c33' then 'amnis finance'
when split(PAYLOAD_FUNCTION, '::')[0] ilike '0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06' then 'merkle'
when split(PAYLOAD_FUNCTION, '::')[0] ilike '0x17f1e926a81639e9557f4e4934df93452945ec30bc962e11351db59eb0d78c33' then 'VibrantX'
when split(PAYLOAD_FUNCTION, '::')[0] ilike '0x9770fa9c725cbd97eb50b2be5f7416efdfd1f1554beb0750d4dae4c64e860da3' then 'Aries'
when split(PAYLOAD_FUNCTION, '::')[0] ilike '0xc6bc659f1649553c1a3fa05d9727433dc03843baac29473c817d06d39e7621ba' then 'Echelon'
when split(PAYLOAD_FUNCTION, '::')[0] ilike '0x6f986d146e4a90b828d8c12c14b6f4e003fdff11a8eecceceb63744363eaac01'then 'thala'
when split(PAYLOAD_FUNCTION, '::')[0] ilike '0x92e95ed77b5ac815d3fbc2227e76db238339e9ca43ace45031ec2589bea5b8c' then 'thala'
when split(PAYLOAD_FUNCTION, '::')[0] ilike '0x163df34fccbf003ce219d3f1d9e70d140b60622cb9dd47599c25fb2f797ba6e' then 'liquidswap'
when split(PAYLOAD_FUNCTION, '::')[0] ilike '0xb247ddeee87e848315caf9a33b8e4c71ac53db888cb88143d62d2370cca0ead2' then 'liquidswap'
when split(PAYLOAD_FUNCTION, '::')[0] ilike '0x54cb0bb2c18564b86e34539b9f89cfe1186e39d89fce54e1cd007b8e61673a85' then 'liquidswap'
when split(PAYLOAD_FUNCTION, '::')[0] ilike '0x6b3720cd988adeaf721ed9d4730da4324d52364871a68eac62b46d21e4d2fa99' then 'thala'
when split(PAYLOAD_FUNCTION, '::')[0] ilike '0x3c4a58b4a8dffe6d14448072efcdd5a0e0089a22c6837b94f1d7e8bb1552137f'then 'thala'
when split(PAYLOAD_FUNCTION, '::')[0] ilike '0x8d2d7bcde13b2513617df3f98cdd5d0e4b9f714c6308b9204fe18ad900d92609'then 'Chingari'
when split(PAYLOAD_FUNCTION, '::')[0] ilike '0xe7c7bb0e53fc6fb86aa7464645fbac96b96716463b4e2269c62945c135aa26fd' then 'Galxe'
when split(PAYLOAD_FUNCTION, '::')[0] ilike '0x31a6675cbe84365bf2b0cbce617ece6c47023ef70826533bde5203d32171dc3c' then 'sushiswap'
when split(PAYLOAD_FUNCTION, '::')[0] ilike '0x54ad3d30af77b60d939ae356e6606de9a4da67583f02b962d2d3f2e481484e90' then 'layerzero'
when split(PAYLOAD_FUNCTION, '::')[0] ilike '0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1' then 'Cellana'
when split(PAYLOAD_FUNCTION, '::')[0] ilike '0x1c3206329806286fd2223647c9f9b130e66baeb6d7224a18c1f642ffe48f3b4c' then 'Panora'
when split(PAYLOAD_FUNCTION, '::')[0] ilike '0x3c1d4a86594d681ff7e5d5a233965daeabdc6a15fe5672ceeda5260038857183' then 'Aptin'
when split(PAYLOAD_FUNCTION, '::')[0] ilike '0x5a96fab415f43721a44c5a761ecfcccc3dae9c21f34313f0e594b49d8d4564f4' then 'KGeN'
when split(PAYLOAD_FUNCTION, '::')[0] ilike '0xb7f5dd022310be46f769af231fb761b9ca18bc2f63237cb6d004aed8ce01336c' then 'KGeN'
when split(PAYLOAD_FUNCTION, '::')[0] ilike '0x06b43eae979756527d8475fd3645d149177cdef13ecec1d1d65d04d420411c55' then 'KGeN'
Last run: 12 days ago
...
392
15KB
51s