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 not in ('cex','token') and PROJECT_NAME is not null

and initcap(PROJECT_NAME) IN (

'Here Wallet', 'Kaikai', 'Sweat', 'Playember', 'Ref Finance', 'Aurora', 'Proximity', 'Wormhole', 'Pyth', 'Usdc', 'Burrow', 'Meta Pool', 'Linear Protocol',

'Learn Near Club', 'Wbnb', 'Sol', 'Pumpopoly', 'Near Social', 'Tradeport', 'Astro Stakers', 'Neat'

)

),

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-06-01'

)

select

date_trunc('month', block_timestamp) as month_ordering,

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

label_type as project_category,