chill2pennalytic
Updated 2023-05-09
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
›
⌄
select project_name as pn , count(*) as tx , count(distinct tx_signer) as users
, sum(deposit/1e24 ) as volume , trunc(block_timestamp, 'MONTH') as m
from near.core.dim_address_labels
inner join near.core.fact_transfers
on address=tx_receiver and project_name='ref finance' and block_timestamp>'2021-03-01'
group by pn , m
UNION
select project_name as pn , count(*) as tx , count(distinct tx_signer) as users
, sum(deposit/1e24 ) as volume , trunc(block_timestamp, 'MONTH') as m
from near.core.dim_address_labels
inner join near.core.fact_transfers
on address=tx_receiver and project_name='skyward' and block_timestamp>'2021-03-01'
group by pn , m
UNION
select project_name as pn , count(*) as tx , count(distinct tx_signer) as users
, sum(deposit/1e24 ) as volume , trunc(block_timestamp, 'MONTH') as m
from near.core.dim_address_labels
inner join near.core.fact_transfers
on address=tx_receiver and project_name='metapool' and block_timestamp>'2021-03-01'
group by pn , m
Run a query to Download Data