IBC_insidergame 2
Updated 2023-03-31
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with t1 as
(select
sum (AMOUNT_USD) as volume ,
count(*) as number ,
ORIGIN_TO_ADDRESS
from
ethereum.core.ez_token_transfers
where
BLOCK_TIMESTAMP> current_date-7 and AMOUNT_USD is not null
group by 3
order by volume desc
limit 10
)
select LABEL,ORIGIN_TO_ADDRESS,volume from t1 a left join ethereum.core.dim_labels b
on a.ORIGIN_TO_ADDRESS=b.address
order by volume desc
Run a query to Download Data