toal users | avg daily users | avg weekly users | avg monhtly users | |
|---|---|---|---|---|
1 | 141451 | 469.936877 | 3214.795455 | 12859.181818 |
Starknet reportsfdn_stark - dau -carmine tot
Updated 2024-02-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with jedi_all as (sELECT timestamp::date as date, tx_hash,caller as user
from external.tokenflow_starknet.decoded_traces
where --tx_hash = '0x06648d87ffa7617fea45f6bcb0f6aea3191244a37fd0dc442fcf9833962e033a'and
--tx_hash in ('0x06648d87ffa7617fea45f6bcb0f6aea3191244a37fd0dc442fcf9833962e033a' ,'0x06506f8d03af43837ce69c921073e89ef8f5dfb02bc8d785030919cda73d7fed','0x00cc8990620fb1ceeaba25c37b631a73c5210ad94a99119a91135d06d89c1223') and
CONTRACT = '0x076dbabc4293db346b0a56b29b6ea9fe18e93742c73f12348c8747ecfc1050aa' and
FUNCTION = '__default__'
and chain_id = 'mainnet')
SELECT count(DISTINCT user) as "toal users",
count(DISTINCT user)/count(DISTINCT date_trunc('day',date)) as "avg daily users",
count(DISTINCT user)/count(DISTINCT date_trunc('week',date)) as "avg weekly users",
count(DISTINCT user)/count(DISTINCT date_trunc('month',date)) as "avg monhtly users"
from jedi_all
Last run: about 1 year ago
1
46B
11s