ELAYMonthly number of transactions
Updated 2022-12-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with datatables as (select TX_ID , AMOUNT , DECIMAL , CURRENCY ,
ACTION ,BLOCK_TIMESTAMP , LIQUIDITY_PROVIDER_ADDRESS
from osmosis.core.fact_liquidity_provider_actions
where pool_id[0]=773
and tx_status = 'SUCCEEDED'
and action in ('pool_joined','pool_exited'))
select count(distinct TX_ID) , sum(AMOUNT/pow(10,DECIMAL)) ,
count(distinct LIQUIDITY_PROVIDER_ADDRESS) ,'pool_joined' , trunc(BLOCK_TIMESTAMP, 'MONTH')
from datatables
where action in ('pool_joined')
group by 5
UNION
select
count(distinct TX_ID) , sum(AMOUNT/pow(10,DECIMAL)) ,
count(distinct LIQUIDITY_PROVIDER_ADDRESS) ,'pool_exited' , trunc(BLOCK_TIMESTAMP, 'MONTH')
from datatables
where action in ('pool_exited')
group by 5
Run a query to Download Data