mucryptodex label
Updated 2023-02-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with ethereum as (select
distinct to_address, from_address,
sum(eth_value) as eth,
count(distinct tx_hash) as txs
from ethereum.core.fact_transactions
where block_timestamp::date = '2022-05-04'
group by to_address, from_address
order by eth desc
limit 100),
cex as (select
address,
address_name
from ethereum.core.dim_labels
where label_type = 'dex')
select ethereum.eth, ethereum.to_address, ethereum.txs, cex.address_name
from ethereum
join cex
on ethereum.to_address=cex.address
order by ethereum.eth
Run a query to Download Data