SpecterStakers leaderboard (TOP 20)
    Updated 2024-07-11
    WITH Parclstaking AS(
    select DATE_TRUNC('DAY',BLOCK_TIMESTAMP) AS Date,
    TX_ID,
    Instruction:parsed:info:amount / 1000000 AS Adjusted_amount,
    SIGNERS [0] AS stakers
    from solana.core.fact_events
    WHERE event_type = 'transfer'
    AND BLOCK_TIMESTAMP >= '2024-07-05'
    AND INDEX = 0
    AND SUCCEEDED = 'TRUE'
    ),
    parclfilter AS (
    SELECT
    tx_id
    FROM
    solana.core.fact_events
    WHERE program_id = '2gWf5xLAzZaKX9tQj9vuXsaxTWtzTZDFRn21J3zjNVgu'
    and index = 1
    ),
    ParclPrice AS (
    SELECT
    TRUNC(hour, 'day') AS day,
    AVG(price) AS price_usd
    FROM
    solana.price.ez_prices_hourly
    WHERE
    token_address = '4LLbsb5ReP3yEtYzmXewyGjcir5uXtKFURtaEUVC2AHs'
    AND Symbol = 'PRCL'
    GROUP BY
    day
    ),
    Filteredout AS (
    SELECT
    ps.tx_Id, ps.date,
    ps.Adjusted_amount,
    stakers
    QueryRunArchived: QueryRun has been archived