ShapeShiftCEX composition
Updated 2024-07-10
999
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
›
⌄
-- forked from mo115 / CEX NetFlow top 3- mpine @ https://flipsidecrypto.xyz/mo115/q/B7YaH4KWMsAz/cex-netflow-top-3--mpine
-- forked from MLDZMN / CEX NetFlow top 3- mpine @ https://flipsidecrypto.xyz/MLDZMN/q/alHmAZ08sP7W/cex-netflow-top-3--mpine
-- forked from Sandesh / CEX NetFlow top 3 @ https://flipsidecrypto.xyz/Sandesh/q/mVE0_5kPP3_4/cex-netflow-top-3
-- forked from CEX base Flow @ https://flipsidecrypto.xyz/edit/queries/6443b7a5-1978-4ee1-bd1c-bd44a00ae7f9
-- forked from CEX base query @ https://flipsidecrypto.xyz/edit/queries/993f0b58-3930-4534-b916-0ef4d0b49e97
with
deposits as
(
SELECT
eth.block_timestamp::date as date,
dl.label,
eth.to_address as CEX_address,
--sum(eth.amount) as eth_amount,
sum(eth.amount_usd) as usd_amount
from
ethereum.core.ez_native_transfers eth
inner join
ethereum.core.dim_labels dl
on eth.to_address=dl.address
where 1=1
and dl.label_type='cex'
and dl.label_subtype='hot_wallet'
group by
date,
dl.label,
CEX_address
union all
SELECT
erc.block_timestamp::date as date,
QueryRunArchived: QueryRun has been archived