AephiaRQ - Upgrading | ATLAS claimed
    Updated 1 hour ago
    WITH profile_wallets AS (
    SELECT
    player_profile
    ,wallet

    FROM SOLANA.SA.PROFILE_WALLETS
    GROUP BY 1,2

    )

    ,atlas_claimed AS (
    select
    date_trunc('day', block_timestamp::date)-1 as date
    ,p.player_profile
    ,sum(case when instruction:accounts[4] = 'MUD6bCtMW8sAkMWcBD14bpG65KaJ9Li1mpxmtWhWSWM'
    then value:parsed:info:amount / POW(10,8) end) AS MUD_ATLAS_claimed
    ,sum(case when instruction:accounts[4] = 'oniXZY2D8nDXnmt8vSgqWoytdcegWaN7rhfoUWU2QxT'
    then value:parsed:info:amount / POW(10,8) end) AS ONI_ATLAS_claimed
    ,sum(case when instruction:accounts[4] = 'ustur3pr1QKYbaCJ3pQsCPUhQLRfLXZbsx4YWaJbt8r'
    then value:parsed:info:amount / POW(10,8) end) AS USTUR_ATLAS_claimed
    ,round(zeroifnull(MUD_ATLAS_claimed) + zeroifnull(ONI_ATLAS_claimed) + zeroifnull(USTUR_ATLAS_claimed),0) as ATLAS_claimed
    ,case when MUD_ATLAS_claimed > 0 then 'MUD'
    when ONI_ATLAS_claimed > 0 then 'ONI'
    when USTUR_ATLAS_claimed > 0 then 'USTUR'
    end as faction


    from profile_wallets p,
    solana.core.fact_events, lateral flatten(input => inner_instruction:instructions)
    WHERE program_id = 'PsToRxhEPScGt1Bxpm7zNDRzaMk31t8Aox7fyewoVse'
    AND succeeded = 'true'
    AND p.wallet IN (signers[0], signers[1])-- IN (p.wallet)
    AND block_timestamp > current_date-30 --AND block_timestamp < current_date
    group by 1,2
    Last run: about 1 hour agoAuto-refreshes every 6 hours
    DATE
    PLAYER_PROFILE
    MUD_ATLAS_CLAIMED
    ONI_ATLAS_CLAIMED
    USTUR_ATLAS_CLAIMED
    ATLAS_CLAIMED
    FACTION
    1
    2025-05-11 00:00:00.000b3Kcu1LpRFmdpXpudLj1tMaDZEDboou47BHxKEszbDT6497.608547386498ONI
    2
    2025-04-27 00:00:00.000b3Kcu1LpRFmdpXpudLj1tMaDZEDboou47BHxKEszbDT3018.068759213018ONI
    3
    2025-05-22 00:00:00.00052ZCGYSt7Q1rJBHeT4X8YJUgYnxYvAQSFXsDqRD7bZtz2774.489369242774MUD
    4
    2025-04-30 00:00:00.000SHn3DgpVPisDhWP41poevs7e2F3ZS452DK3GjtpDPyw80091.3816451380091MUD
    5
    2025-05-17 00:00:00.000CFxeBKAybsKbaRKexAcvwXYLfRCkGz4Lu83M4M2swBEi2100.982228622101MUD
    6
    2025-04-25 00:00:00.000ohNiDhVYg1USADAGKUmVyVMjkXdiT4TPARxXyBz89EY4373.920413034374USTUR
    7
    2025-04-28 00:00:00.000ohNiDhVYg1USADAGKUmVyVMjkXdiT4TPARxXyBz89EY4868.299415424868USTUR
    8
    2025-04-24 00:00:00.000ohNiDhVYg1USADAGKUmVyVMjkXdiT4TPARxXyBz89EY1220.755023541221USTUR
    9
    2025-04-28 00:00:00.0009uGSNXd7V9QG9DNYquFz5KBA6uuty5GWXWUjFC6qT2uv7550.517799797551MUD
    10
    2025-04-24 00:00:00.000A6W9BZ8PxmazqGs3uGw8QMujcdoZTiKg3B6eWYy5WDvX22611.1721043322611ONI
    11
    2025-05-07 00:00:00.000A6W9BZ8PxmazqGs3uGw8QMujcdoZTiKg3B6eWYy5WDvX19219.2786144219219ONI
    12
    2025-04-25 00:00:00.000A6W9BZ8PxmazqGs3uGw8QMujcdoZTiKg3B6eWYy5WDvX6603.459271876603ONI
    13
    2025-05-15 00:00:00.000A6W9BZ8PxmazqGs3uGw8QMujcdoZTiKg3B6eWYy5WDvX11783.2476198611783ONI
    14
    2025-04-29 00:00:00.000CSvCUgyZGNAyw88oKMZhirYibR2zdfA6G5EaSTJeSwGr10175.4080308210175MUD
    15
    2025-05-10 00:00:00.000HHT12Pj8gEZQa7wkfKJscFctWHLki2E84X6w9o1BDa7t74.1438981574USTUR
    16
    2025-05-22 00:00:00.000BwQZ3Sa1FcoWkvFaGhe6dcPFN3RFcwNEcEyWePVVBraK43553.6603657643554USTUR
    17
    2025-05-12 00:00:00.000FCB5Gr93eMeAFHn6shtsbG7vrPsj5CUAjQAtFwSNd6d12202.29856272202MUD
    18
    2025-04-27 00:00:00.000BwQZ3Sa1FcoWkvFaGhe6dcPFN3RFcwNEcEyWePVVBraK172719.37697041172719USTUR
    19
    2025-05-09 00:00:00.0007LYQWKRrVSFXHghzoFH5SVmLEbwhRakiYoSojxb45kX7200.26617738200USTUR
    20
    2025-05-06 00:00:00.000FCB5Gr93eMeAFHn6shtsbG7vrPsj5CUAjQAtFwSNd6d11434.565113571435MUD
    ...
    3183
    346KB
    5s