RhoninLargest Tokemak DEX Pools p2
Updated 2022-06-22
999
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 sushi_lp as (
SELECT
origin_from_address
FROM ethereum.core.fact_event_logs
WHERE event_inputs:"to" = '0xd4e7a6e2d03e4e48dfc27dd3f46df1c176647e38'
AND ORIGIN_FUNCTION_SIGNATURE = '0xf305d719'
AND origin_from_address not in (
SELECT
origin_from_address
FROM ethereum.core.fact_event_logs
WHERE event_inputs:"from" = '0xd4e7a6e2d03e4e48dfc27dd3f46df1c176647e38'
)
),
uni_lp as (
SELECT
origin_from_address
FROM ethereum.core.fact_event_logs
WHERE event_inputs:"to" = '0x5fa464cefe8901d66c09b85d5fcdc55b3738c688'
AND ORIGIN_FUNCTION_SIGNATURE = '0xf305d719'
AND origin_from_address not in (
SELECT
origin_from_address
FROM ethereum.core.fact_event_logs
WHERE event_inputs:"from" = '0x5fa464cefe8901d66c09b85d5fcdc55b3738c688'
)
),
sell as (
SELECT
origin_from_address
FROM ethereum.core.ez_dex_swaps
WHERE contract_address in (
'0x5fa464cefe8901d66c09b85d5fcdc55b3738c688' , '0xd4e7a6e2d03e4e48dfc27dd3f46df1c176647e38'
)
AND token_in = '0x2e9d63788249371f1dfc918a52f8d799f4a38c94'
AND block_timestamp >= '2022-06-01'
Run a query to Download Data