marquAXL Launch - 24h AXL actions
Updated 2022-12-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with
pool_axl as (
select
block_timestamp,
amount / pow(10,6) as axl,
case
when action = 'pool_joined' then 'Deposit'
else 'Withdraw'
end as label_action
from osmosis.core.fact_liquidity_provider_actions
where pool_id = 812
and action in ('pool_joined','pool_exited')
and currency = 'ibc/903A61A498756EA560B85A85132D3AEE21B5DEDD41213725D22ABF276EA6945E' -- AXL
and block_timestamp >= current_timestamp() - interval '24 hours'
and tx_status = 'SUCCEEDED'
)
select *
from pool_axl
Run a query to Download Data