jackguyCEX to DEX and DEX to CEX
Updated 2022-04-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
WITH tab1 as (
SELECT
address,
project_name
FROM crosschain.address_labels
WHERE label_type like 'cex'
AND blockchain LIKE 'ethereum'
)
SELECT
-- date_trunc('day', block_timestamp),
project_name,
count(*) as trasnfers,
SUM(amount_usd) as volume
FROM ethereum.udm_events
join tab1 on address = to_address
WHERE to_address in (SELECT address from tab1)
AND symbol LIKE 'UNI'
AND block_timestamp > '2022-01-01'
GROUP by 1
ORDER by 3 DESC
LIMIT 10
Run a query to Download Data