ArioPEPE Add liquidity source
Updated 2023-05-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with PEPE_POOLs as (
select POOL_NAME,
POOL_ADDRESS,
PLATFORM
from ethereum.core.dim_dex_liquidity_pools
where (TOKEN0 = '0x6982508145454ce325ddbe47a25d4ec3d2311933'
or TOKEN1 = '0x6982508145454ce325ddbe47a25d4ec3d2311933')
)
select
date_trunc(day, BLOCK_TIMESTAMP) as date,
LABEL as Source,
sum(AMOUNT_USD) as "Inflow Volume"
from ethereum.core.ez_token_transfers a join PEPE_POOLs b
on a.to_address = b.POOL_ADDRESS
join ethereum.core.dim_labels c on a.from_address = c.address
where 1=1
and AMOUNT_USD is not null
and POOL_NAME is not null
group by 1,2
Run a query to Download Data