NuveveCryptoArchived$OP Inflow By CEX
Updated 2022-11-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with cex as (
select
address,
project_name
from optimism.core.dim_labels
where label_type = 'cex'
and label_subtype = 'hot_wallet'
)
select
cex.project_name as project_name,
sum(transfers.raw_amount)/pow(10, 18) as op_amount
from optimism.core.fact_token_transfers as transfers
inner join cex on transfers.origin_from_address = cex.address
where transfers.contract_address = '0x4200000000000000000000000000000000000042'
and transfers.block_timestamp >= '2022-11-07'
group by 1
Run a query to Download Data