mucryptotop 5 wallets by transactions
Updated 2023-03-05
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
›
⌄
with wallets as (select
date_trunc('day', block_timestamp) as day,
from_address,
count(tx_hash) as transactions
from ethereum.core.fact_transactions
where block_timestamp::date between '2022-05-04' and '2022-05-15'
and to_address is not null
group by 1,2
qualify row_number() over (partition by day order by transactions desc) <=10),
-- luna as (select
-- date(hour) as "Day",
-- avg(price) as "Average LUNA price, USD"
-- from ethereum.core.fact_hourly_token_prices
-- where "Day" between '2022-05-04' and '2022-05-15'
-- and symbol = 'LUNA'
-- group by 1),
labels as (select
address,
address_name,
case
when address_name = 'coinbase 6' then 'Coinbase'
when address_name = 'bittrex 1' then 'Bitrex'
when address_name = 'coinbase 5' then 'Coinbase'
when address_name = 'ethermine' then 'Ethermine: Mining Pool'
when address_name = 'coinbase 3' then 'Coinbase'
when address_name = 'coinbase 4' then 'Coinbase'
when address_name = 'coinbase 11' then 'Coinbase'
when address_name = 'ftx exchange 2' then 'FTX'
when address_name = 'ftx exchange' then 'FTX'
when address_name = 'binance 16' then 'Binance'
when address_name = 'binance 15' then 'Binance'
when address_name = 'binance 14' then 'Binance'
when address_name = 'kucoin deposit_wallet' then 'KuCoin'
when address_name = 'crypto.com 2' then 'Crypto.com'
Run a query to Download Data