nitsCurrent Pool Stats
    Updated 2022-12-14
    with enter as
    (SELECT currency, sum(amount/pow(10,decimal)) as amt_joined from osmosis.core.fact_liquidity_provider_actions a
    where pool_id [0] = '773'
    and tx_status = 'SUCCEEDED' and action = 'pool_joined'
    GROUP by 1 ),
    exit_ as
    (SELECT currency as c , sum(amount/pow(10,decimal)) as amt_exit from osmosis.core.fact_liquidity_provider_actions a
    where pool_id [0] = '773'
    and tx_status = 'SUCCEEDED' and action = 'pool_exited'
    GROUP by 1 )
    SELECT *, amt_joined - amt_exit as net_amount , case when c = 'uosmo' then net_amount*1.5 else net_amount*5.3 end as net_val,
    case when c = 'uosmo' then 'Osmo' else 'DOT' end as name,
    case when c = 'uosmo' then amt_joined*1.5 else amt_joined*5.3 end as net_val_joined,
    case when c = 'uosmo' then amt_exit*1.5 else amt_exit*5.3 end as net_val_exit
    from
    (SELECT * from enter join exit_
    on c = currency)
    LIMIT 199
    Run a query to Download Data