cybergenlab[Bridge Overview] Projects MAU copy
Updated 2024-11-16
99
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 [DEX Overview] Projects MAU @ https://flipsidecrypto.xyz/studio/queries/8b4e1500-f37d-4f66-bffc-c89dd17d7162
-- forked from [DeFi Overview] Projects MAU @ https://flipsidecrypto.xyz/studio/queries/e44dace0-7dad-4301-97c6-e5d17ea09ba1
-- forked from [Network Ecosystem] Projects MAU @ https://flipsidecrypto.xyz/studio/queries/d9254cb8-7dff-451d-9534-e43757983324
with ethereum_projects as (
select
address,
initcap(address_name) as address_name,
initcap(label) as project_name,
initcap(label_type) as label_type,
from ethereum.core.dim_labels
where label_type in ('bridge')
)
, project_events as (
select
date_trunc('month', block_timestamp) as time,
from_address as users,
from ethereum.core.fact_transactions as transactions
left join ethereum.core.dim_labels labels on transactions.to_address = labels.address
where block_timestamp >= dateadd(year, -2, date_trunc('month',current_date()))
and block_timestamp < date_trunc('month',current_date())
and status = 'SUCCESS'
)
, users as (
select
users,
min(time) as min_date
from project_events
group by 1
)
QueryRunArchived: QueryRun has been archived