flipside

    Number of Traders
    ZSaedNumber of Traders
    Updated 2022-10-06
    /* n the live call, we’ll go over the swaps and labels table (osmosis.core.fact_swaps and osmosis.core.dim_labels) to recreate a dashboard showcasing the following:

    Number of unique traders in the past week
    Number of unique traders all time
    Top 5 trending assets people are buying in the past week in terms of number of transactions
    */
    select COUNT(DISTINCT TX_ID) as num_trade , count(DISTINCT(TRADER) ) as num_trader , 'Last Six Day' as time
    from osmosis.core.fact_swaps
    where BLOCK_TIMESTAMP::date >= CURRENT_DATE -6
    UNION
    select COUNT(DISTINCT TX_ID) as num_trade , count(DISTINCT(TRADER) ) as num_trader , 'All The Time' as time
    from osmosis.core.fact_swaps



    Run a query to Download Data