sarathGnomsis_1s
Updated 2022-10-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
›
⌄
select
date_trunc('day', block_timestamp) as date,
project_name,
address_name,
label_type,
label_subtype,
sum(raw_amount)/POW(10,18) as amount,
count(distinct tx_hash) as transactions,
count(distinct origin_from_address) as unique_transfer_users
from gnosis.core.fact_token_transfers a
left join gnosis.core.dim_labels b
on a.contract_address = b.address
where address_name is not null
and date >= CURRENT_DATE - 30
group by 1,2,3,4,5
order by amount descselect
date_trunc('day', block_timestamp) as date,
project_name,
address_name,
label_type,
label_subtype,
sum(raw_amount)/POW(10,18) as amount,
count(distinct tx_hash) as transactions,
count(distinct origin_from_address) as unique_transfer_users
from gnosis.core.fact_token_transfers a
left join gnosis.core.dim_labels b
on a.contract_address = b.address
where address_name is not null
and date >= CURRENT_DATE - 30
group by 1,2,3,4,5
order by amount desc
Run a query to Download Data