flipside

    Total Staking by Web3 Gamers [By Game]
    steven-sabol-dir-of-economyTotal Staking by Web3 Gamers [By Game]
    Updated 2025-04-07
    -- forked from Liquid Staking Web3 Gamers [By Game] copy @ https://flipsidecrypto.xyz/studio/queries/26650e58-4124-4ae1-bc9e-43a4996bfe2f

    -- forked from Liquid Staking Web3 Gamers [By Game] @ https://flipsidecrypto.xyz/studio/queries/197e737e-7f5b-4e4c-a323-b3e04eaf64a8

    -- forked from Liquid Staking Web3 Gamers [Tokens] @ https://flipsidecrypto.xyz/studio/queries/0a3bdbba-0e07-4f88-aa7f-dfdc72b9fda3

    -- forked from Liquid Staking Web3 Gamers @ https://flipsidecrypto.xyz/studio/queries/74cea7cc-bcf7-4d00-b75d-654ce7cb8287

    -- forked from FTX Token Sales (Mil. USD) copy copy @ https://flipsidecrypto.xyz/studio/queries/a2c1bca7-de0a-43cc-9e86-b9fdc100d8ad

    --- M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K -- Magic Eden
    -- 'TCMPhJdwDryooaGtiocG1u3xcYbRpiJzb283XfCZsDp' -- Tensor
    -- '6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P' -- pump.fun
    --- KLend2g3cP87fffoy8q1mQqGKjrxjC8boSyAYavgmjD -- Kamino Lend
    --- 'FarmsPZpWu9i7Kky8tPN37rs2TpmMrAZrC7S7vJa91Hr' -- Kamino Farms



    with w1 as (
    SELECT
    -- date_trunc('month', block_timestamp) as date,
    DISTINCT
    Case when signers[0] in ('FUnDSXuqNmhZxoeE4PC7F199HhrxX3kSBC21XgVRoUxG','FEEPAYye6DtaJhSXFR65ENXMroiseL1jqYT4QxHKRoZr')
    then signers[1] else signers[0] end as wallet,
    'Star Atlas' as wallet_label
    FROM solana.core.fact_events
    WHERE succeeded = TRUE
    AND program_id IN('FLEET1qqzpexyaDpqb2DGsSzE2sDCizewCg9WjrA6DBW','SAGEqqFewepDHH6hMDcmWy7yjHPpyKLDnRXKb3Ki8e6',
    'gateVwTnKyFrE8nxUUgfzoZTPKgJQZUbLsEidpG4Dp2','Lock7kBijGCQLEFAmXcengzXKA88iDNQPriQ7TbgeyG','STAKEr4Bh8sbBMoAVmTDBRqouPzgdocVrvtjmhJhd65',
    'ATLocKpzDbTokxgvnLew3d7drZkEzLzDpzwgrgWKDbmc','pprofELXjL5Kck7Jn5hCpwAL82DpTkSYBENzahVtbc9','TESTWCwvEv2idx6eZVQrFFdvEJqGHfVA1soApk2NFKQ'
    ,'SAGE2HAwep459SNq61LHvjxPk4pLPEJLoMETef7f7EE', 'Cargo2VNTPPTi9c1vq1Jw5d3BWUNr18MjRtSupAghKEk','Point2iBvz7j5TMVef8nEgpmz4pDr7tU7v3RjAfkQbM','PsToRxhEPScGt1Bxpm7zNDRzaMk31t8Aox7fyewoVse','traderDnaR5w6Tcoi3NFm53i48FTDNbGjBSZwWXDRrg'
    )
    -- AND block_timestamp >= '2021-12-01'
    AND block_timestamp >= current_date() - 90
    ),

    Last run: 22 days ago
    DATE
    WALLET_LABEL
    Total Non-Liquid Staked
    Total Liquid Staked
    Total Non-Liquid Staked (USD)
    Total Liquid Staked (USD)
    Total Liquid Staked (SOL)
    Total Staked (USD)
    Total Staked (SOL) - unadj
    Total Staked (SOL)
    1
    		2023-01-01 00:00:00.000Star Atlas61196.872443301-36903.692554685606475.728625295-395439.079083652-39940.215697821211036.64954164224293.17988861621256.65674548
    2
    		2023-01-01 00:00:00.000Photo Finish10896.3625513357249.529649203108165.99847504678036.6921722787881.87734234186202.69064732418145.89220053818778.239893675
    3
    		2023-01-01 00:00:00.000Honeyland1.494266375-15.65896754614.833281628-168.687098086-17.037767483-153.853816459-14.164701171-15.543501108
    4
    		2023-01-01 00:00:00.000Heist559.02399776112441.5618193795550.226748244133441.97648501113477.932773628138992.20323325413000.5858171414036.956771389
    5
    		2023-01-01 00:00:00.000Genopets841.9124329171306.3672317718434.1220500113974.9817360891411.50385593122409.10378612148.2796646882253.416288848
    6
    		2023-01-01 00:00:00.000Elementerra44.923386983-13.999216211445.945423072-150.871897918-15.238393129295.07352515330.92417077229.684993854
    7
    		2023-01-01 00:00:00.000Aurory-11954.31719528716402.038581609-118668.101343343174882.10462860117663.47675283256214.0032852574447.7213863225709.159557545
    8
    		2023-01-02 00:00:00.000Star Atlas61342.870322-36848.086766929676106.274471255-440361.309248367-41190.065932957235744.96522288824494.78355507120152.804389044
    9
    		2023-01-02 00:00:00.000Photo Finish10946.3625513357249.529649203120478.78758589986850.7756604918123.759060236207329.5632463918195.89220053819070.121611571
    10
    		2023-01-02 00:00:00.000Honeyland1.494266375-15.65896754616.446321812-187.710087243-17.557834232-171.263765431-14.164701171-16.063567857
    11
    		2023-01-02 00:00:00.000Heist4559.02399776112441.56181937950177.918121146148773.62541361613915.835272475198951.54353476217000.5858171418474.859270236
    12
    		2023-01-02 00:00:00.000Genopets941.9124329171311.43662608810366.95682220815658.5891500741464.65710307226025.5459722822253.3490590052406.569535989
    13
    		2023-01-02 00:00:00.000Elementerra44.92201474-13.999216211494.424503702-167.854609691-15.700612872326.56989401130.92279852929.221401868
    14
    		2023-01-02 00:00:00.000Aurory-11956.59701893816309.034981609-131597.716203831194544.60170394918197.11405791862946.8855001184352.4379626716240.51703898
    15
    		2023-01-03 00:00:00.000Star Atlas61878.08903606-36847.994090617739741.508817408-472253.580645654-39239.086809307267487.92817175425030.09494544322639.002226753
    16
    		2023-01-03 00:00:00.000Photo Finish11051.3625513357249.529649203132116.97551701293024.5704772677729.320318473225141.54599427918300.89220053818780.682869808
    17
    		2023-01-03 00:00:00.000Honeyland1.494266375-15.65896754617.863675467-201.025848025-16.703040538-183.162172559-14.164701171-15.208774163
    18
    		2023-01-03 00:00:00.000Heist4559.02399776112441.56181937954502.280519328159388.63496290713243.445343868213890.91548223517000.5858171417802.469341629
    19
    		2023-01-03 00:00:00.000Genopets941.9124329171311.43662608811260.38723829916780.3570763941394.26341058528040.7443146932253.3490590052336.175843502
    20
    		2023-01-03 00:00:00.000Elementerra44.92201474-13.999216211537.034297265-179.755105184-14.935675378357.27919208230.92279852929.986339362
    ...
    5796
    932KB
    149s