flipside

    2024-01-11 12:09 PM
    AnalyticSages2024-01-11 12:09 PM
    Updated 2024-01-11
    SELECT
    c.value:accounts[1],
    c.value:programId
    --t.instructions--[1]:accounts[1] AS addrs
    FROM
    solana.core.fact_transactions t
    JOIN
    LATERAL FLATTEN(input => t.instructions) c
    limit 10

    --[{A-z: {a: 'apple', b: 'ball'}}]
    QueryRunArchived: QueryRun has been archived