intellidegentAugusta DEX Bounty
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
›
⌄
-- forked from 820214d4-5eb5-4b69-ba46-482349751151
-- Using the table ethereum.core.ez_dex_swaps,
-- describe any correlations in activity between Uniswap and Sushiswap.
-- One could use TVL, transactions, transaction volume,
-- number of unique users, or any other metric of your choosing to describe activity.
-- When there is a surge in activity on one platform, does it happen on the other?
-- For a challenge, use the polygon.core.fact_transactions or
-- polygon.core.fact_event_logs table to compare activity of one,
-- or both, of these DEXes across two chains (Ethereum and Polygon).
-- What are you able to extract from the transaction-level data?
SELECT
date_trunc('day', block_timestamp),
count(tx_hash) as Number_of_Transactions,
platform,
sum(amount_out_usd) as swapped_volume
FROM ethereum.core.ez_dex_swaps
WHERE
platform IN ('uniswap-v2', 'sushiswap', 'uniswap-v3')
AND block_timestamp::DATE BETWEEN '2023-01-01' AND '2023-01-31'
GROUP BY 1, 3
SELECT DISTINCT(PLATFORM)
FROM ethereum.core.ez_dex_swaps
WHERE PLATFORM LIKE '%swap%'
Run a query to Download Data