intellidegentUntitled Query
Updated 2022-11-25Copy Reference Fork
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
›
⌄
⌄
⌄
⌄
select
count(distinct(blockchain)),
count(distinct(address)),
count(distinct(creator)),
count(distinct(label_type)),
count(distinct(label_subtype)),
count(distinct(label)),
count(distinct(project_name))
from terra.core.dim_address_labels;
select * from terra.core.dim_address_labels;
select to_char(count(distinct(tx_sender)),'fm999G999') as "Unique Addresses"
from terra.core.fact_transactions;
select
dal.label,
ftx.tx_sender,
to_char(count(tx_id),'fm999G999') as Transactions
from terra.core.fact_transactions ftx
left join terra.core.dim_address_labels dal on ftx.tx_sender = dal.address
group by
dal.label,
ftx.tx_sender
order by count(tx_id) desc;
select
'EZ Transfers - Sender' as Type,
dal.label,
ezt.sender,
to_char(count(ezt.tx_id),'fm999G999') as Transactions
from terra.core.ez_transfers ezt
inner join terra.core.dim_address_labels dal on ezt.sender = dal.address
group by
Run a query to Download Data