0xaimanUntitled Query
Updated 2022-11-27
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 tab1 as (
SELECT
address,
address_name
FROM crosschain.address_labels
WHERE blockchain LIKE 'polygon'
AND project_name LIKE 'sushiswap'
), tab2 as (
SELECT
address_name as a1,
symbol as s1,
sum(amount) as amt1
FROM polygon.udm_events LEFT outer join tab1 on address = to_address
WHERE to_address IN (SELECT address from tab1)
AND (ORIGIN_FUNCTION_NAME LIKE '%remove%' or ORIGIN_FUNCTION_NAME LIKE '%add%')
GROUP by 1,2
), tab3 as (
SELECT
address_name as a2,
symbol as s2,
sum(amount) as amt2
FROM polygon.udm_events LEFT outer join tab1 on address = from_address
WHERE from_address IN (SELECT address from tab1)
AND (ORIGIN_FUNCTION_NAME LIKE '%remove%' or ORIGIN_FUNCTION_NAME LIKE '%add%')
GROUP by 1,2
), tab4 as (
SELECT
a1,
s1,
amt1 - amt2 as amtg
FROM tab2 join tab3 on a1 = a2 and s2 = s1
), tab5 as (
SELECT
symbol,
avg(price) as p
FROM ethereum.token_prices_hourly
Run a query to Download Data