top 10 in categories dapp excludes wallets copy

winnie-fstop 10 in categories dapp excludes wallets copy

Updated 2025-03-19

-- forked from charliemarketplace / top 10 in categories dapp excludes wallets @ https://flipsidecrypto.xyz/charliemarketplace/q/WsyUQroOM8tz/top-10-in-categories-dapp-excludes-wallets

-- forked from top 10 in categories gaming @ https://flipsidecrypto.xyz/studio/queries/76d996f7-8b65-41de-b608-bad269a9160a

with near_projects as (

select ADDRESS,

initcap(PROJECT_NAME) as PROJECT_NAME,

initcap(LABEL_TYPE) as LABEL_TYPE

from near.core.dim_address_labels

-- where LABEL_TYPE in ('dapp', 'games', 'defi', 'bridge', 'nft')

where LABEL_TYPE in ('dapp')

and PROJECT_NAME is not null

projects_events as (

select

BLOCK_TIMESTAMP,

TX_HASH,

SIGNER_ID,

RECEIVER_ID,

PROJECT_NAME,

ADDRESS,

LABEL_TYPE,

DEPOSIT/1e24 as Volume

from near.core.fact_actions_events_function_call

inner join near_projects

on RECEIVER_ID=ADDRESS

where RECEIPT_SUCCEEDED=true

and block_timestamp >= '2024-11-01'

monthly_metrics as (

select

date_trunc('month', block_timestamp) as month_ordering,

INITCAP(TO_VARCHAR(date_trunc('month', block_timestamp), 'mon. yyyy')) as month_,

project_name,

Last run: 24 days ago

	MONTH_ORDERING	MONTH_	PROJECT_CATEGORY	PROJECT_NAME	CATEGORY_RANK	# Tx	# Unique Signers	Direct $NEAR Volume (if applicable)
1	2025-02-01 00:00:00.000	Feb. 2025	Dapp	Hot Near Wallet	3	1640352	137821	3585
2	2025-02-01 00:00:00.000	Feb. 2025	Dapp	Pyth	4	288699	85	4019
3	2025-02-01 00:00:00.000	Feb. 2025	Dapp	Meme Cooking	5	251844	1547	13
4	2025-02-01 00:00:00.000	Feb. 2025	Dapp	Learn Near Club	6	25612	9517	3
5	2025-02-01 00:00:00.000	Feb. 2025	Dapp	Mintbase	7	21840	719	158
6	2025-02-01 00:00:00.000	Feb. 2025	Dapp	Tkn	8	11220	1739	5
7	2025-02-01 00:00:00.000	Feb. 2025	Dapp	Hapi Protocol	9	6705	5884	867
8	2025-02-01 00:00:00.000	Feb. 2025	Dapp	Near Social	10	2126	472	40

615B

28s