mcfemi6Untitled Query
Updated 2022-10-28
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
›
⌄
--Total Active Users on Uniswap
select
count(DISTINCT Lp_provider.tx_hash) as LP_transaction, count(DISTINCT swappers.tx_hash) as Swap_transaction,
count(DISTINCT Lp_provider.liquidity_provider) as Total_liquidity_provider,
count(DISTINCT swappers.sender) as Total_swapper
From ethereum.uniswapv3.ez_lp_actions AS Lp_provider
Join ethereum.uniswapv3.ez_swaps AS swappers
Where Lp_provider.blockchain = swappers.blockchain
Select DISTINCT
Pool_name, sum(amount0_usd), sum(amount1_usd)
from ethereum.uniswapv3.ez_swaps
group by 1
order by 2 DESC, 1 DESC
--Where amount0_usd IS NOT NULL AND amount1_usd IS NOT NULL and token0_symbol IS NOT NULL and token1_symbol IS NOT NULL
--Group by 1,2
--order by 3 DESC, 4 ASC;
Select
ORIGIN_FUNCTION_NAME,
FROM_LABEL_TYPE,
FROM_LABEL,
EVENT_NAME,
Symbol,
sum(AMOUNT_USD)
from ethereum.udm_events
Where ORIGIN_FUNCTION_NAME = 'swap' AND FROM_LABEL_TYPE = 'dex' AND FROM_LABEL = 'Uniswap' AND EVENT_NAME IN ('Swap', 'Swapped')
Group by 1, 2, 3, 4, 5
limit 10
select *
Run a query to Download Data