prbhvgupta2023-03-22 10:17 PM
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 distinct a.to_address,a.cnt,b.name,b.label_type,b.subtype,b.label
from
(select to_address,count(*) as cnt from ethereum.core.fact_transactions
where block_timestamp >= date '2021-01-01' and block_timestamp <= date'2021-12-01'
and to_address is not null
group by 1
order by 2 desc
limit 10000) as a
left join
(select address,array_agg(address_name) as name,
array_agg(label_type) as label_type,
array_agg(label_subtype) as subtype, array_agg(label) as label
from ethereum.core.dim_labels
where blockchain = 'ethereum'
group by 1) as b
on a.to_address = b.address
order by a.cnt desc
select * from
(select * , ROW_NUMBER() OVER (ORDER BY address) AS row_number
from ethereum.core.dim_labels
where blockchain = 'ethereum'
and label = 'uniswap' ) as a
where row_number > 100000
order by row_number asc
and address = '0x7a250d5630b4cf539739df2c5dacb4c659f2488d'
group by 1
0x7a250d5630b4cf539739df2c5dacb4c659f2488d
select * from
ethereum.core.dim_labels
limit 10
select count(distinct address) from ethereum.core.dim_labels
Run a query to Download Data