flipside

    user weekly 1
    yasmin-n-d-r-huser weekly 1
    Updated 2024-05-15
    WITH
    t1 AS (
    SELECT
    tx_id,
    signers[0] AS user,
    tx_id AS transactions,
    block_timestamp,
    date_trunc('week', block_timestamp) AS week_start
    FROM
    solana.core.fact_events
    WHERE
    program_id = 'MFv2hWf31Z9kbCa1snEPYctwafyhdvnV7FZnsebVacA'
    AND succeeded = 'TRUE'
    AND block_timestamp >= CURRENT_DATE - INTERVAL '6 months'
    ),
    t2 AS (
    SELECT
    signers[0] AS user1,
    MIN(block_timestamp) AS min_block_time,
    date_trunc('week', MIN(block_timestamp)) AS week_start
    FROM
    solana.core.fact_transactions
    WHERE
    succeeded = 'TRUE'
    AND block_timestamp >= CURRENT_DATE - INTERVAL '6 months'
    AND signers[0] IN (
    SELECT
    user
    FROM
    t1
    )
    GROUP BY
    signers[0]
    )
    SELECT
    t2.week_start,
    QueryRunArchived: QueryRun has been archived