flipside

    Ships in SCORE VWAP change
    AephiaShips in SCORE VWAP change
    Updated 3 hours ago
    WITH ships_in as (
    select
    date_trunc('day', block_timestamp::date) as date,
    -----------------------------------------------------------------------------------------------------
    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,
    sum(case when value:parsed:info:mint = 'FTk1E5UoWkiZEUttCWSYYaVokxWNNp3yJ42HbNDCAkdt' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS THRILL_in,
    sum(case when value:parsed:info:mint = 'FFkPvwLDYuKDW9eAAr5UNfuX3U9PcTGeSk7gqNX7EpNc' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS VZUSBA_in,
    sum(case when value:parsed:info:mint = '4gR3ChfdQxR4BTbgeWSdf6b8kD8Ysu6WBAQqtJ9oLgbF' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS CALMED_in,
    Last run: about 3 hours agoAuto-refreshes every 12 hours
    DATE
    FF_VWAP_DAILY
    FF_VWAP_TOTAL
    1
    		2025-05-25 00:00:00.000069818263
    2
    		2025-05-24 00:00:00.000-14608.0269818263
    3
    		2025-05-23 00:00:00.00053282.6769832871.02
    4
    		2025-05-22 00:00:00.00022638.5269779588.35
    5
    		2025-05-21 00:00:00.000-101560.669756949.83
    6
    		2025-05-20 00:00:00.0008029.169858510.43
    7
    		2025-05-19 00:00:00.000-11933.169850481.33
    8
    		2025-05-18 00:00:00.000-4194.6869862414.43
    9
    		2025-05-17 00:00:00.000106746.6969866609.11
    10
    		2025-05-16 00:00:00.000-205505.1569759862.42
    11
    		2025-05-15 00:00:00.000-24397.6269965367.57
    12
    		2025-05-14 00:00:00.000-25326.8769989765.19
    13
    		2025-05-13 00:00:00.000-33097.6670015092.06
    14
    		2025-05-12 00:00:00.000-74732.4370048189.72
    15
    		2025-05-11 00:00:00.000-27784.6970122922.15
    16
    		2025-05-10 00:00:00.000-15453.8370150706.84
    17
    		2025-05-09 00:00:00.000-38591.0770166160.67
    18
    		2025-05-08 00:00:00.000-19452.5270204751.74
    19
    		2025-05-07 00:00:00.000-42690.8670224204.26
    20
    		2025-05-06 00:00:00.000-10744.5570266895.12
    ...
    1257
    62KB
    521s