keshanArbitrum Bridges
Updated 2022-06-29
9
1
2
3
4
5
6
7
8
›
⌄
select block_timestamp::date as date, label_syubtype, label, address_name, sum(amount) as eth,
count(disticnt eth_from_address) as n_users, count(distinct tx_has) as txs
from ethereum.core.ez_eth_transfers
inner join ethereum.core.dim_labels on eth_from_address=address and label_type='cex'
geoup by date, label_subtype, label, address_name
--select * from ethereum.core.dim_labels where label_type='cex'
--select * from bsc.core.dim_labels where label_type='cex'
Run a query to Download Data