andurilGaming Data - Programs and Tokens
    Updated 2024-09-06
    with programs_agg as (
    select
    date_trunc('month',block_timestamp) as month,
    CASE
    when program_id in (
    'EXpwP3pqPzA4arF8i89w7smtvxHzyYETmCpPspLPrR7J',
    'STkwf3sbMapjy7KV3hgrJtcVvY4SvRxWQ8pj4Enw1i5',
    'StKLLTf7CQ9n5BgXPSDXENovLTCuNc7N2ehvTb6JZ5x',
    'comp8FLpN5bbNUC2fhnkFtM7T16DWvaHs8N5dcaoZWP',
    'CAsieqooSrgVxhgWRwh21gyjq7Rmuhmo4qTW9XzXtAvW') then 'Aurory'
    when program_id in (
    'FLEET1qqzpexyaDpqb2DGsSzE2sDCizewCg9WjrA6DBW',
    'traderDnaR5w6Tcoi3NFm53i48FTDNbGjBSZwWXDRrg',
    'Lock7kBijGCQLEFAmXcengzXKA88iDNQPriQ7TbgeyG',
    'gateVwTnKyFrE8nxUUgfzoZTPKgJQZUbLsEidpG4Dp2',
    'ATLocKpzDbTokxgvnLew3d7drZkEzLzDpzwgrgWKDbmc',
    'govdobVk4Si5cLuHDRa47GaQBcGi1rxiQtg1oxRBvSd',
    'FACTNmq2FhA2QNTnGM2aWJH3i7zT3cND5CgvjYTjyVYe',
    'TESTWCwvEv2idx6eZVQrFFdvEJqGHfVA1soApk2NFKQ',
    'Name2A6WDmJ8unSp12rTWTrp9gdYWPDrwdUKujDyEF6',
    'pprofELXjL5Kck7Jn5hCpwAL82DpTkSYBENzahVtbc9',
    'pFACSRuobDmvfMKq1bAzwj27t6d2GJhSCHb1VcfnRmq',
    'pFACSRuobDmvfMKq1bAzwj27t6d2GJhSCHb1VcfnRmq',
    'pv1ttom8tbyh83C1AVh6QH2naGRdVQUVt3HY1Yst5sv',
    'SAGEqqFewepDHH6hMDcmWy7yjHPpyKLDnRXKb3Ki8e6',
    'Cargo8a1e6NkGyrjy4BQEW4ASGKs9KSyDyUrXMfpJoiH',
    'Craftf1EGzEoPFJ1rpaTSQG1F6hhRRBAf4gRo9hdSZjR',
    'AtFeepWnrZzfLrkP5iCv3YJ8TQNuWxYYBvb9Yw9P846p',
    'SAGE2HAwep459SNq61LHvjxPk4pLPEJLoMETef7f7EE',
    'CRAFT2RPXPJWCEix4WpJST3E7NLf79GTqZUL75wngXo5',
    'Cargo2VNTPPTi9c1vq1Jw5d3BWUNr18MjRtSupAghKEk',
    'Point2iBvz7j5TMVef8nEgpmz4pDr7tU7v3RjAfkQbM',
    'PsToRxhEPScGt1Bxpm7zNDRzaMk31t8Aox7fyewoVse',
    'APR1MEny25pKupwn72oVqMH4qpDouArsX8zX4VwwfoXD',
    'STAKEr4Bh8sbBMoAVmTDBRqouPzgdocVrvtjmhJhd65'
    ) then 'Star Atlas'
    QueryRunArchived: QueryRun has been archived