flipside

    total unique swappers of $BOME
    0xnightraventotal unique swappers of $BOME
    Updated 2024-06-09
    select --DATE_TRUNC('day',BLOCK_TIMESTAMP) as date1 ,
    count (distinct SWAPPER) as daily_swapperes
    from solana.defi.fact_swaps
    where SWAP_FROM_MINT = 'ukHH6c7mMyiWCf1b9pnWe25TSpkDDt3H5pQZgZ74J82'
    OR SWAP_TO_MINT = 'ukHH6c7mMyiWCf1b9pnWe25TSpkDDt3H5pQZgZ74J82'
    and SUCCEEDED = 'TRUE'
    /*with sp as (
    SELECT
    date_trunc('day',HOUR) as date,
    --avg( case when TOKEN_ADDRESS = '0xDE9B56f3Bb816f37b4F1b5081058465ed57826A3' then PRICE end )as wif_price,
    --avg( CASE WHEN TOKEN_ADDRESS = 'EKpQGSJtjMFqKZ9KQanSqYXRcF8fBopzLHYxdM65zcjm' then PRICE end) as solana_price
    -- avg (CASE WHEN TOKEN_ADDRESS = 'EKpQGSJtjMFqKZ9KQanSqYXRcF8fBopzLHYxdM65zcjm' then close end) / avg (CASE WHEN TOKEN_ADDRESS = '0xDE9B56f3Bb816f37b4F1b5081058465ed57826A3' then close end) as WIF_SOL_price
    AVG (price) as price
    FROM solana.price.ez_prices_hourly
    -- WHERE (TOKEN_ADDRESS = 'EKpQGSJtjMFqKZ9KQanSqYXRcF8fBopzLHYxdM65zcjm' or
    where date>='2024-01-01' and TOKEN_ADDRESS = 'EKpQGSJtjMFqKZ9KQanSqYXRcF8fBopzLHYxdM65zcjm'
    GROUP by 1
    ORDER BY 1),
    SW as (
    and date1>='2024-01-01'
    group by 1
    order by 1
    )
    select sp.date ,sp.price , SW.daily_swapperes
    from sp
    join SW on SW.date1 = sp.date
    order by 1*/
    QueryRunArchived: QueryRun has been archived