andurilGaming Data - Programs and Tokens
Updated 2024-09-06
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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