Pmisha-bmlMdxwETH
Updated 2022-06-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select
date(BLOCK_TIMESTAMP) as dt,
ACTION,
sum(AMOUNT/1e18) as vol,
count(distinct tx_id) as no_txn,
count(distinct LIQUIDITY_PROVIDER_ADDRESS) as users
from osmosis.core.fact_liquidity_provider_actions
where BLOCK_TIMESTAMP>='2022-01-01'
and TX_STATUS='SUCCEEDED'
and POOL_ID=704--wETH
and CURRENCY='ibc/EA1D43981D5C9A1C4AAEA9C23BB1D4FA126BA9BC7020A25E0AE4AA841EA25DC5'
group by 1,2
Run a query to Download Data