flipside

    top 50 address
    boomer77top 50 address
    Updated 2022-02-18
    with addy as (select distinct sender
    from anchor.bonds
    where block_timestamp >= CURRENT_DATE - 7
    union
    select distinct sender
    from anchor.borrows
    where block_timestamp >= CURRENT_DATE - 7
    UNION
    select distinct sender
    from anchor.burns
    where block_timestamp >= CURRENT_DATE - 7
    UNION
    select distinct sender
    from anchor.collateral
    where block_timestamp >= CURRENT_DATE - 7
    UNION
    select distinct sender
    from anchor.deposits
    where block_timestamp >= CURRENT_DATE - 7
    UNION
    select distinct sender
    from anchor.gov_staking
    where block_timestamp >= CURRENT_DATE - 7
    UNION
    select distinct voter
    from anchor.gov_vote
    where block_timestamp >= CURRENT_DATE - 7
    UNION
    select distinct sender
    from anchor.redeem
    where block_timestamp >= CURRENT_DATE - 7
    UNION
    select distinct sender
    from anchor.repay
    where block_timestamp >= CURRENT_DATE - 7
    UNION
    Run a query to Download Data