DAY | TYPE | NEW | |
|---|---|---|---|
1 | 2024-01-23 00:00:00.000 | chadmin | 93968 |
2 | 2024-01-28 00:00:00.000 | chadmin | 38612 |
3 | 2024-03-24 00:00:00.000 | defi | 36671 |
4 | 2024-05-15 00:00:00.000 | chadmin | 24279 |
5 | 2024-12-09 00:00:00.000 | games | 1002 |
6 | 2024-04-14 00:00:00.000 | chadmin | 47709 |
7 | 2024-02-21 00:00:00.000 | dex | 1164 |
8 | 2024-03-13 00:00:00.000 | dex | 5173 |
9 | 2024-09-13 00:00:00.000 | dapp | 2916 |
10 | 2024-02-26 00:00:00.000 | defi | 984 |
11 | 2024-01-08 00:00:00.000 | nft | 200 |
12 | 2024-10-03 00:00:00.000 | defi | 1712 |
13 | 2024-06-27 00:00:00.000 | dex | 735 |
14 | 2024-03-01 00:00:00.000 | defi | 1007 |
15 | 2024-10-28 00:00:00.000 | dapp | 8543 |
16 | 2025-01-20 00:00:00.000 | games | 12784 |
17 | 2024-12-10 00:00:00.000 | games | 913 |
18 | 2024-03-29 00:00:00.000 | bridge | 5016 |
19 | 2024-05-05 00:00:00.000 | nft | 162 |
20 | 2024-12-27 00:00:00.000 | dex | 2440 |
0xHaM-dDaily Share of New Users
Updated 2025-03-14
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 hess / Daily Share of New Users @ https://flipsidecrypto.xyz/hess/q/47mriNzJv7Ha/daily-share-of-new-users
-- forked from top 10 projects @ https://flipsidecrypto.xyz/edit/queries/4c4bf731-766e-4225-8cb4-bf5cfe33558c
with users as ( select date(a.block_timestamp) as date,
a.tx_hash,
a.sender,
EVENT_ADDRESS
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'
Last run: 3 months ago
...
2937
115KB
600s