Hadisehnon-lp holder
    Updated 2022-07-13
    with t1 as ( select LIQUIDITY_PROVIDER_ADDRESS
    from osmosis.core.fact_liquidity_provider_actions
    where currency = 'uosmo' and block_timestamp::date >= CURRENT_DATE - 90),
    ts as ( select DISTINCT TX_CALLER_ADDRESS
    from osmosis.core.fact_staking
    where action = 'delegate' and blockchain = 'osmosis' and TX_STATUS = 'SUCCEEDED'),
    t2 as ( select trunc(block_timestamp,'day') as day ,
    sum(to_amount/pow(10,to_decimal)) as amount,
    count(DISTINCT tx_id) as transactions ,
    count(DISTINCT trader) as traders
    from osmosis.core.fact_swaps
    where trader in (select receiver
    from osmosis.core.fact_transfers where currency = 'uosmo' and block_timestamp::date >= CURRENT_DATE - 90) and block_timestamp::date >= CURRENT_DATE - 90
    and trader not in ( select LIQUIDITY_PROVIDER_ADDRESS from t1 ) and trader not in ( select TX_CALLER_ADDRESS from ts)
    group by 1),
    t3 as ( select trunc(block_timestamp,'day') as day ,
    sum(to_amount/pow(10,to_decimal)) as amount,
    count(DISTINCT tx_id) as transactions ,
    count(DISTINCT trader) as traders
    from osmosis.core.fact_swaps
    where trader in (select LIQUIDITY_PROVIDER_ADDRESS from t1 where block_timestamp::date >= CURRENT_DATE - 90) and
    trader not in ( select TX_CALLER_ADDRESS from ts) and block_timestamp::date >= CURRENT_DATE - 90
    group by 1),
    t4 as ( select trunc(block_timestamp,'day') as day ,
    sum(to_amount/pow(10,to_decimal)) as amount,
    count(DISTINCT tx_id) as transactions ,
    count(DISTINCT trader) as traders
    from osmosis.core.fact_swaps
    where trader in (select TX_CALLER_ADDRESS from ts) and trader not in (select LIQUIDITY_PROVIDER_ADDRESS from t1) and
    block_timestamp::date >= CURRENT_DATE - 90
    group by 1)

    Run a query to Download Data