mucrypto2023-03-02 09:54 AM
Updated 2023-03-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with transfers as (select
date_trunc('day', block_timestamp) as day,
contract_address,
count(tx_hash) as n_of_transfers
from ethereum.core.fact_token_transfers
where block_timestamp::date between '2023-01-01' and '2023-03-01'
group by 1,2
qualify row_number() over (partition by day order by n_of_transfers desc) <= 5),
labels as (select
address,
address_name
from ethereum.core.dim_labels
group by 1,2)
select transfers.day, transfers.n_of_transfers, labels.address, labels.address_name
from transfers
join labels
on transfers.contract_address=labels.address
Run a query to Download Data