TomoData13 Liquidity Providers Stats
Updated 2022-08-24
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 lp as (SELECT
BLOCK_TIMESTAMP,
ORIGIN_FROM_ADDRESS ,
AMOUNT_USD as amount_povided,
rank()over(partition by ORIGIN_FROM_ADDRESS order by BLOCK_TIMESTAMP asc) as rank
from
ethereum.core.ez_token_transfers
where
TO_ADDRESS in (SELECT POOL_ADDRESS
from ethereum.core.dim_dex_liquidity_pools
from ethereum.core.dim_dex_liquidity_pools
where ORIGIN_TO_ADDRESS in ('0xef0881ec094552b2e128cf945ef17a6752b4ec5d')
and
ORIGIN_FUNCTION_SIGNATURE in ('0x8dbdbe6d')
and BLOCK_TIMESTAMP >= '2021-08-23'
),
wd as (
SELECT
BLOCK_TIMESTAMP,
ORIGIN_FROM_ADDRESS,
AMOUNT_USD amount_removed,
rank()over(partition by ORIGIN_FROM_ADDRESS order by BLOCK_TIMESTAMP asc) as rank
from
ethereum.core.ez_token_transfers
where
TO_ADDRESS in (SELECT POOL_ADDRESS
from ethereum.core.dim_dex_liquidity_pools
from ethereum.core.dim_dex_liquidity_pools
where ORIGIN_TO_ADDRESS in ('0xef0881ec094552b2e128cf945ef17a6752b4ec5d')
and
ORIGIN_FUNCTION_SIGNATURE in ('0x8dbdbe6d')
and BLOCK_TIMESTAMP >= '2021-08-23'
),
Run a query to Download Data