tomwanhhdestination checking
Updated 2023-04-13
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 withdrawal_list as (select
withdrawal_address, sum(withdrawal_amount) as amount
from ethereum.beacon_chain.fact_withdrawals
group by 1)
-- cex as (
-- select distinct address, address_name
-- from crosschain.core.address_labels
-- where label_type='cex'
-- and blockchain = 'ethereum')
select * from (
select tx_hash, eth_to_address,
case when eth_to_address='0x40a50cf069e992aa4536211b23f286ef88752187'
then 'cow_swap'
when eth_to_address = '0xf78618d50a0d7e8ff2e97412d943a92ba43fff54'
then 'coinbase deposit_wallet'
else
coalesce(address_name,'untagged') end as address_name, sum(amount) as amount_eth
from ethereum.core.ez_eth_transfers a
left join crosschain.core.address_labels b
on eth_to_address = address
where block_timestamp >= '2023-04-12 22:28:23.000'
and eth_from_address in
(select distinct withdrawal_address from withdrawal_list)
group by 1,2,3
order by 4 desc )a
where address_name = 'untagged'
-- select *
-- from Ethereum.core.ez_dex_swaps
-- where block_timestamp >= '2023-04-12 22:28:23.000'
-- and origin_from_address in
-- (select distinct withdrawal_address from withdrawal_list)
-- and symbol_in = 'WETH'
Run a query to Download Data