nitsUntitled Query
    Updated 2022-11-29
    osmosisosmosiswith pricet as (
    select recorded_at::date as day,
    address,
    symbol,
    avg (price) as USDPrice
    from osmosis.core.dim_prices t1 join osmosis.core.dim_labels t2 on t1.symbol = t2.project_name
    where symbol != 'IOV'
    group by 1,2,3),

    SingleSideT as (
    select tx_id,
    count (tx_id) as TXS_Count
    from osmosis.core.fact_liquidity_provider_actions
    where action = 'pool_joined'
    and tx_status = 'SUCCEEDED'
    group by 1
    having TXS_Count < 2),

    BothAssetsT as (
    select tx_id,
    count (tx_id) as TXS_Count
    from osmosis.core.fact_liquidity_provider_actions
    where action = 'pool_joined'
    and tx_status = 'SUCCEEDED'
    group by 1
    having TXS_Count > 1)
    select 'Carefully Wade In (Single Side)' as join_type,
    count (distinct tx_id) as TX_Count,
    count (distinct liquidity_provider_address) as Users_Count
    from osmosis.core.fact_liquidity_provider_actions
    where tx_status = 'SUCCEEDED'
    and tx_id in (select tx_id from SingleSideT)

    union ALL

    Run a query to Download Data