flipside

    RQ - Refill & Harvest
    AephiaRQ - Refill & Harvest
    Updated 5 hours ago
    WITH wallets_used AS (
    SELECT
    player_profile
    ,wallet

    FROM SOLANA.SA.PROFILE_WALLETS
    GROUP BY 1,2

    )

    ,refill as (
    select
    date_trunc('day', block_timestamp::date) as date
    --,(SELECT player_profile FROM SOLANA.SA.PROFILE_WALLETS) as player_profile
    ,case when signers[0] = 'FEEPAYye6DtaJhSXFR65ENXMroiseL1jqYT4QxHKRoZr'
    then signers[1] else signers[0] end as wallet
    ,sum(case when value:parsed:info:mint = 'fueL3hBZjLLLJHiFH9cqZoozTG3XQZ53diwFPwbzNim'
    AND value:parsed:info:authority = wallet
    AND value:parsed:type = 'transferChecked'
    then value:parsed:info:tokenAmount:uiAmount
    when value:parsed:info:mint = 'fueL3hBZjLLLJHiFH9cqZoozTG3XQZ53diwFPwbzNim'
    AND value:parsed:info:authority != wallet
    AND value:parsed:type = 'transferChecked'
    then value:parsed:info:tokenAmount:uiAmount*-1 end) AS fuel_refill
    ,sum(case when value:parsed:info:mint = 'foodQJAztMzX1DKpLaiounNe2BDMds5RNuPC6jsNrDG'
    AND value:parsed:info:authority = wallet
    AND value:parsed:type = 'transferChecked'
    then value:parsed:info:tokenAmount:uiAmount
    when value:parsed:info:mint = 'foodQJAztMzX1DKpLaiounNe2BDMds5RNuPC6jsNrDG'
    AND value:parsed:info:authority != wallet
    AND value:parsed:type = 'transferChecked'
    then value:parsed:info:tokenAmount:uiAmount*-1 end) AS food_refill
    ,sum(case when value:parsed:info:mint = 'ammoK8AkX2wnebQb35cDAZtTkvsXQbi82cGeTnUvvfK'
    AND value:parsed:info:authority = wallet
    AND value:parsed:type = 'transferChecked'
    Last run: about 5 hours ago
    DATE
    PLAYER_PROFILE
    FUEL_REFILL
    FOOD_REFILL
    AMMO_REFILL
    TOOL_REFILL
    FUEL_HARVEST
    FOOD_HARVEST
    AMMO_HARVEST
    TOOL_HARVEST
    1
    		2025-04-15 00:00:00.000Bcow9LZXNVUwX77W1x3zgaVdYCvL1T9N73nnSQ7grFJb1197484116
    2
    		2025-04-04 00:00:00.000Bcow9LZXNVUwX77W1x3zgaVdYCvL1T9N73nnSQ7grFJb1368596132
    3
    		2025-04-03 00:00:00.000Bcow9LZXNVUwX77W1x3zgaVdYCvL1T9N73nnSQ7grFJb17141599213522904174281127454071
    4
    		2025-04-01 00:00:00.000Bcow9LZXNVUwX77W1x3zgaVdYCvL1T9N73nnSQ7grFJb16651558206722224011270126373911
    5
    		2025-04-11 00:00:00.000Bcow9LZXNVUwX77W1x3zgaVdYCvL1T9N73nnSQ7grFJb72933190868123434302289728294196
    6
    		2025-03-21 00:00:00.000Bcow9LZXNVUwX77W1x3zgaVdYCvL1T9N73nnSQ7grFJb16741566208122344048272626633949
    7
    		2025-03-30 00:00:00.000Bcow9LZXNVUwX77W1x3zgaVdYCvL1T9N73nnSQ7grFJb16131517199821493831258025203737
    8
    		2025-03-26 00:00:00.000Bcow9LZXNVUwX77W1x3zgaVdYCvL1T9N73nnSQ7grFJb13061227160117293012202819812938
    9
    		2025-04-09 00:00:00.000Bcow9LZXNVUwX77W1x3zgaVdYCvL1T9N73nnSQ7grFJb18161680227224334496302329554384
    10
    		2025-04-10 00:00:00.000Bcow9LZXNVUwX77W1x3zgaVdYCvL1T9N73nnSQ7grFJb1368596132
    11
    		2025-03-23 00:00:00.000Bcow9LZXNVUwX77W1x3zgaVdYCvL1T9N73nnSQ7grFJb1224114714941617
    12
    		2025-03-27 00:00:00.000Bcow9LZXNVUwX77W1x3zgaVdYCvL1T9N73nnSQ7grFJb1491140818371979
    13
    		2025-03-24 00:00:00.000Bcow9LZXNVUwX77W1x3zgaVdYCvL1T9N73nnSQ7grFJb15281444188420294496302329554384
    14
    		2025-04-14 00:00:00.000Bcow9LZXNVUwX77W1x3zgaVdYCvL1T9N73nnSQ7grFJb64973241455069984496302329554384
    15
    		2025-03-19 00:00:00.000Bcow9LZXNVUwX77W1x3zgaVdYCvL1T9N73nnSQ7grFJb18161680227224344496302329554384
    16
    		2025-03-29 00:00:00.000Bcow9LZXNVUwX77W1x3zgaVdYCvL1T9N73nnSQ7grFJb13561276166417974496302329554384
    17
    		2025-03-28 00:00:00.000D9JFPZ9NwkNrnBT76RDrUHNcU4AejTvQUiyhkZPMXT3h7488249636437303247303166294162551241154
    18
    		2025-03-31 00:00:00.000D9JFPZ9NwkNrnBT76RDrUHNcU4AejTvQUiyhkZPMXT3h72410835707938491970247303166294162551241154
    19
    		2025-04-02 00:00:00.000D9JFPZ9NwkNrnBT76RDrUHNcU4AejTvQUiyhkZPMXT3h25764170932779332889247303166294162551241154
    20
    		2025-04-15 00:00:00.000D9JFPZ9NwkNrnBT76RDrUHNcU4AejTvQUiyhkZPMXT3h69883817517640788784247303166294162551241154
    ...
    3281
    379KB
    52s