peteer2opnear
Updated 2023-05-08
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
›
⌄
with dapps_to_near as (select count(distinct TX_HASH) as tx ,count(distinct TX_RECEIVER) as users
, sum(DEPOSIT/1e24) as amount , sum(TRANSACTION_FEE/1e24) as fees , PROJECT_NAME
from near.core.fact_transfers
inner join near.core.dim_address_labels
on TX_SIGNER= address
where project_name in ('sweat','nearcrowd','playember','sweat economy','learnnear') and status=1
group by PROJECT_NAME)
, near_to_dapps as (select count(distinct TX_HASH) as tx ,count(distinct TX_SIGNER) as users
, sum(DEPOSIT/1e24) as amount, sum(TRANSACTION_FEE/1e24) as fees ,PROJECT_NAME
from near.core.fact_transfers
inner join near.core.dim_address_labels
on TX_RECEIVER= address
where project_name in ('sweat','nearcrowd','playember','sweat economy','learnnear') and status=1
group by PROJECT_NAME)
, dapps_to_near_weekly as (select count(distinct TX_HASH) as tx ,count(distinct TX_RECEIVER) as users
, sum(DEPOSIT/1e24) as amount , sum(TRANSACTION_FEE/1e24) as fees
, PROJECT_NAME , date_trunc('week', block_timestamp) as dates
from near.core.fact_transfers
inner join near.core.dim_address_labels
on TX_SIGNER= address
where project_name in ('sweat','nearcrowd','playember','sweat economy','learnnear') and status=1
and dates is not null
group by PROJECT_NAME , dates)
, near_to_dapps_weekly as (select count(distinct TX_HASH) as tx ,count(distinct TX_SIGNER) as users
, sum(DEPOSIT/1e24) as amount, sum(TRANSACTION_FEE/1e24) as fees ,PROJECT_NAME,date_trunc('week', block_timestamp) as dates
from near.core.fact_transfers
inner join near.core.dim_address_labels
on TX_RECEIVER= address
where project_name in ('sweat','nearcrowd','playember','sweat economy','learnnear') and status=1
and dates is not null
group by PROJECT_NAME , dates)
Run a query to Download Data