jackguyWETH/THOR Pool 2
Updated 2022-09-12
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
›
⌄
--SELECT DISTINCT pool_address, pool_name
--FROM ethereum.core.dim_dex_liquidity_pools
--WHERE pool_name LIKE 'THOR-WETH LP'
with tab1 as (
SELECT
*,
event_inputs:amount0,
event_inputs:amount1
FROM ethereum.core.fact_event_logs
WHERE contract_address LIKE '0x3d3f13f2529ec3c84b2940155effbf9b39a8f3ec'
AND event_name like 'Mint'
), tab2 as (
SELECT
*,
event_inputs:amount0,
event_inputs:amount1
FROM ethereum.core.fact_event_logs
WHERE contract_address LIKE '0x3d3f13f2529ec3c84b2940155effbf9b39a8f3ec'
AND event_name like 'Burn'
), tab3 as (
SELECT
'Deposit Liquidity' as event_type,
sum(amount_usd) as volume,
count(DISTINCT tx_hash) as events,
count(DISTINCT ORIGIN_FROM_ADDRESS) as users
FROM ethereum.core.ez_token_transfers
WHERE tx_hash in (SELECT tx_hash FROM tab1)
GROUP by 1
UNION
SELECT
'Withdraw Liquidity' as event_type,
sum(amount_usd) as volume,
count(DISTINCT tx_hash) as events,
count(DISTINCT ORIGIN_FROM_ADDRESS) as users
Run a query to Download Data