Soheil_MKUntitled Query
Updated 2022-12-06
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 types as (
select
distinct tx_id,
count(tx_id) as txs
from osmosis.core.fact_liquidity_provider_actions
WHERE tx_status = 'SUCCEEDED'
AND action = 'pool_exited'
and (POOL_ID ='634')
group by 1
),
--215A7B951917BF98066DE2F6386AD83326BBE256338F520440DB87D8BB4142A3 single atom/osmo
--5CACFCC6F38FE41ACDFEFF94C1A428458F6454C1111FAA8BCFCEDD720C6AA9C0 both atom/osmo
--F2CF9AA0235EEC740166F1F6017D7794E91AEF249F7C0A6C62CFA48C96CCAA0C single atom/xprt
--ABCAA0C5F6BE84192140FE88CBE370753F977122AE11A4F1E0C580D30BE55DB6 both atom/xprt
main1 as (
select
a.BLOCK_TIMESTAMP::date as date,
b.tx_id,
a.LIQUIDITY_PROVIDER_ADDRESS,
a.POOL_ID,
a.AMOUNT,
a.CURRENCY,
a.DECIMAL
from osmosis.core.fact_liquidity_provider_actions a
join types b
on a.TX_ID=b.TX_ID
where ACTION ='pool_exited'
and (POOL_ID ='634')
),
price as (
select
RECORDED_AT::date as date,
ADDRESS,
Run a query to Download Data