ludicrousCrafting fee total USE
    Updated 8 days ago
    -- forked from Crafting fee USE @ https://flipsidecrypto.xyz/studio/queries/a82e0c66-232c-45ef-9e7c-8d8438107943

    SELECT
    CASE when signers[0] = 'FEEPAYye6DtaJhSXFR65ENXMroiseL1jqYT4QxHKRoZr'
    then signers[1] else signers[0] end AS WALLET

    ,ROUND(zeroifnull(sum(CASE when value:parsed:info:destination = '5XJei3jBZi8WuqDGUQ5KCe8t72vMRMTWLr6ok3hhXE2R'
    AND value:parsed:type = 'transfer'
    then value:parsed:info:amount / POW(10,8)
    end)),2) AS ATLAS


    FROM solana.core.fact_events, lateral flatten(input => inner_instruction:instructions)
    WHERE program_id IN ('SAGE2HAwep459SNq61LHvjxPk4pLPEJLoMETef7f7EE')
    AND block_timestamp > '2024-04-01' AND block_timestamp < '2025-05-01'
    AND wallet != 'FEEPAYye6DtaJhSXFR65ENXMroiseL1jqYT4QxHKRoZr'
    GROUP BY 1
    ORDER BY 2 DESC


    Last run: 8 days ago
    WALLET
    ATLAS
    1
    HajLgwYKTvxuJVg8GhWhx1GkeqQ4P3wWk9SHbZJPvJnh
    20540431.89
    2
    7szk9kq77N8qj6M1wVgTWLHz1ijZ6ar2tDF8w4mXUM48
    16873069.6
    3
    E9XsGpXLHw6NyA6jraFdzLHWksDCBV6X1b3nrnRYg7AN
    11600395.51
    4
    6LVuNtS4BHc5bdXr6V5v1fFUyRnWwYPF4bDABoh3evrt
    9727033.26
    5
    H7C39WVE2teJgDwj8xsCW2XZGFnreRdp7njY3SzDkr7G
    8312817.87
    6
    8fvJhm5p7QQFLRofFHeT1bjNDa8FppZZwLkb6MR257Cp
    8225539.57
    7
    DoM5yS39H8Vam3FnWMgAJGRfxByqXv5rB9PmGSC5iVfr
    7420149.68
    8
    HFb6x3wLLp9CrJP9eGgvi9TBnJkqkKGoDeGP61b1EHUD
    6960403.72
    9
    ESrRf8M6G5gV5xAEHmEeUPBffzXXxU4fb9Hq5iY4ZNC9
    6467558.68
    10
    G29mGtMUX2WqJ5zqjfUHBxqFZDWWG4bW9SM86tKrgGCw
    5297237.03
    11
    FK2nVHmxSNGY6DSoohurCPABeyK5teH6pnfysnYdh1dQ
    4948432.47
    12
    BcNjxc5BJG6NS5wfa6NnkvEo5qU8D8YZzTA4Y4NU9WG3
    4463198.27
    13
    5pTZytiQTSedoWMUD4XGQkbM3RqkJWCkWShsApNUW7ex
    3924840.02
    14
    6bQFKL5AAY6xYPSbajfxa9c88jqPBfh7w4MwisFrdrp1
    3622068.84
    15
    AM6vdxe2PDjNWBWyGFd3p3h2yXxb5UnHvQiyahcijcyC
    3551770.37
    16
    4BD3wry4uzBbqBc6Fok1pM3YPASyakvMtbzG4ueijnHs
    3060221.43
    17
    7Z74tABrm7ob2RqXVj399nKijaWh8nFs4Vd9gUJJ9kwg
    2965135.56
    18
    HoJEaf2b6i7aRrswA3BHXDpVDZ2eDUcKqpQXNXUSFSAx
    2951441.86
    19
    DtuhBQ6eZ8p2jGBKHWW5VUmcco5rg66E3iWA4bF56wDW
    2948467.37
    20
    7edjdvKdivY18HpYkSic2mMcvwqeGw2ni19GYXhyi3nn
    2902873.44
    ...
    14090
    725KB
    195s