flipside

    Player VWAP copy
    ludicrousPlayer VWAP copy
    Updated 2024-06-27
    -- forked from tankshipguy-YPATzb / Player VWAP @ https://flipsidecrypto.xyz/tankshipguy-YPATzb/q/0VbrKq2eHLGM/player-vwap

    -- forked from steven-sabol-dir-of-economy / Player Earnings Over The Last 30 days [w/ EOP VWAPS] @ https://flipsidecrypto.xyz/steven-sabol-dir-of-economy/q/URgLxKH8ofNV/player-earnings-over-the-last-30-days-w-eop-vwaps
    with score_in as(
    select
    signers[0] as wallet,

    sum(case when value:parsed:info:mint = 'Ev3xUhc1Leqi4qR2E5VoG9pcxCvHHmnAaSRVPg485xAT' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS OPALJ_in,
    sum(case when value:parsed:info:mint = '267DbhCypYzvTqv72ZG5UKHeFu56qXFsuoz3rw832eC5' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS PX5_in,
    sum(case when value:parsed:info:mint = '9czEqEZ4EkRt7N3HWDcw9qqwys3xRRjGdbn8Jhk8Khwj' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS VZUSOP_in,
    sum(case when value:parsed:info:mint = 'AkNbg12E9PatjkiAWJ3tAbM479gtcoA1gi6Joa925WKi' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS CALCH_in,
    sum(case when value:parsed:info:mint = 'CWxNX9sTexuqvQefqskhP9f6AP5C8hq2VNkicRseqAT5' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS OGKATP_in,
    sum(case when value:parsed:info:mint = '2iMhgB4pbdKvwJHVyitpvX5z1NBNypFonUgaSAt9dtDt' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS PX4_in,
    sum(case when value:parsed:info:mint = '9ABNesWj7NVdkDgko7UjVaDp5pTh8a6wfXHLWz3bZM6W' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS OPALJJ_in,
    sum(case when value:parsed:info:mint = '7V9C2XUQgCb31n7hGKqKGu4ENcvqXhJLJzU77CAQtXhw' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS FBLBPL_in,
    sum(case when value:parsed:info:mint = 'DdpXnnYsyUQgJby8TDHbmPwkKyGF4U6bXwCXTQZsrfKP' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS CALG_in,
    sum(case when value:parsed:info:mint = '9MvZS3TVfv4DZL9W2pT12po384aBHf7wi89KXQ9Z7uwW' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS PF4_in,
    sum(case when value:parsed:info:mint = 'FpwV1Da6BZJnYPr1JSLUm14UwBmZHA7J5WLY4TXgbde8' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS FBLEGR_in,
    sum(case when value:parsed:info:mint = 'HzBx8PP86pyPrrboTHqPYWhxnEB5vXDHDBP8femWfPTS' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS OM_in,
    sum(case when value:parsed:info:mint = '2bCgKTo11QayWBy6QryHZMqZL2ZgWd5LEAZKiTGQi4g7' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS PR8_in,
    sum(case when value:parsed:info:mint = 'H2jHqvXA2oxSpEp6dKkpK7WeszQEdFW5n25mNfrJFAc1' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS VZUSAM_in,
    sum(case when value:parsed:info:mint = '5f1jUARhtSypVA4uTpgpLp76WYGdB2dGr8zMbh4WjYRf' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS PC9_in,
    sum(case when value:parsed:info:mint = '9ifQ16N5DdUFoejCwsgR73ihUwadAe3srCo9HhQe2zL2' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS PC11_in,
    sum(case when value:parsed:info:mint = 'DsJHgpnNovjJ981QJJnqMggexAekNawbSavfV1QuTpis' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS CHI_in,
    sum(case when value:parsed:info:mint = 'HJBmBYyGR8z1oajAM4jiK46uobuxeJoKDYpFwzWHBvhb' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS OGKAJA_in,
    sum(case when value:parsed:info:mint = '4txpjHspP4usEsQTr3AcrpyHVjN4fi3d4taM6cmKJnd1' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS CALEV_in,
    sum(case when value:parsed:info:mint = 'HsdbLvZrEgN2ZhsrZs5ag4F2FNFCHjjuXPfbVAhkeJBZ' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS TUFAFE_in,
    sum(case when value:parsed:info:mint = '6SqLuwHNRC1qjo9KATLKJLszFHMWyYaNxDXraCEUtfdR' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS FBLBEA_in,
    sum(case when value:parsed:info:mint = '8RveLFEyteyL1vbCKPQJxjf3JT1ACyrzs46TXbJStrHG' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS PX6_in,
    sum(case when value:parsed:info:mint = '7M6RHgPiHXiZAin5ManH63cLYGt3miQ54KaGynUQoERS' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS FBLEBO_in,
    sum(case when value:parsed:info:mint = 'HqPN13pLUVJRiuGSsKjfWZvGKAagK98PshuKu51bnG4E' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS FBLETR_in,
    sum(case when value:parsed:info:mint = 'Fw8PqtznYtg4swMk7Yjj89Tsj23u5CJLfW5Bk8ro4G1s' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS FBLAIR_in,
    sum(case when value:parsed:info:mint = 'FMHHwUB6amLWYhWxtiZHC2g5azy9usPTLMq46N3HEgFU' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS OGKAMK_in,
    sum(case when value:parsed:info:mint = '9zrgra3XQkZPt8XNs4fowbqmj7B8bBx76aEmsKSnm9BW' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS FBLEUN_in,
    sum(case when value:parsed:info:mint = 'EbLBLN44BVLjifLNBbchXFr8QjEkAGYENKuNEaDuyVPL' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS ARC_in,
    sum(case when value:parsed:info:mint = '7Xs3yt9eJPuEexZrKSGVbQMXHwWUKHGeDZnM4ZksZmyS' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS FBLLOW_in,
    QueryRunArchived: QueryRun has been archived