33crescoSolana Blockchain Game Wallets 14-Day
Updated 2024-07-19
99
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 all_interactions AS (
SELECT DISTINCT
DATE_TRUNC('Day', block_timestamp) AS block_timestamp,
program_id,
CASE
WHEN program_id IN (
'FLEET1qqzpexyaDpqb2DGsSzE2sDCizewCg9WjrA6DBW',
'traderDnaR5w6Tcoi3NFm53i48FTDNbGjBSZwWXDRrg',
'gateVwTnKyFrE8nxUUgfzoZTPKgJQZUbLsEidpG4Dp2',
'SAGE2HAwep459SNq61LHvjxPk4pLPEJLoMETef7f7EE',
'CRAFT2RPXPJWCEix4WpJST3E7NLf79GTqZUL75wngXo5',
'Cargo2VNTPPTi9c1vq1Jw5d3BWUNr18MjRtSupAghKEk',
'STAKEr4Bh8sbBMoAVmTDBRqouPzgdocVrvtjmhJhd65',
'SAGEqqFewepDHH6hMDcmWy7yjHPpyKLDnRXKb3Ki8e6',
'Name2A6WDmJ8unSp12rTWTrp9gdYWPDrwdUKujDyEF6',
'pprofELXjL5Kck7Jn5hCpwAL82DpTkSYBENzahVtbc9',
'pFACSRuobDmvfMKq1bAzwj27t6d2GJhSCHb1VcfnRmq',
'pv1ttom8tbyh83C1AVh6QH2naGRdVQUVt3HY1Yst5sv',
'Cargo8a1e6NkGyrjy4BQEW4ASGKs9KSyDyUrXMfpJoiH',
'Craftf1EGzEoPFJ1rpaTSQG1F6hhRRBAf4gRo9hdSZjR',
'AtFeepWnrZzfLrkP5iCv3YJ8TQNuWxYYBvb9Yw9P846p'
) THEN 'Star Atlas'
WHEN program_id IN (
'HAbiTatJVqoCJd9asyr6RxMEdwtfrQugwp7VAFyKWb1g',
'CrAFTUv7zKXBaS5471aCwHx7mq9Jp1eQQB5FQgdiSLyi',
'StaKe9nb7aUjXpjpZ45o6uJBsZxj2BWCDBtjk8LCg2v',
'srmv4uTCPF81hWDaPyEN2mLZ8XbvzuEM6LsAxR8NpjU'
) THEN 'Genopets'
WHEN program_id IN (
'EXpwP3pqPzA4arF8i89w7smtvxHzyYETmCpPspLPrR7J',
'STkwf3sbMapjy7KV3hgrJtcVvY4SvRxWQ8pj4Enw1i5',
'StKLLTf7CQ9n5BgXPSDXENovLTCuNc7N2ehvTb6JZ5x',
'comp8FLpN5bbNUC2fhnkFtM7T16DWvaHs8N5dcaoZWP',
'CAsieqooSrgVxhgWRwh21gyjq7Rmuhmo4qTW9XzXtAvW'
) THEN 'Aurory'
WHEN program_id IN (
QueryRunArchived: QueryRun has been archived