flipside

    Ships in SCORE VWAP change
    AephiaShips in SCORE VWAP change
    Updated 6 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 6 hours agoAuto-refreshes every 12 hours
    DATE
    FF_VWAP_DAILY
    FF_VWAP_TOTAL
    1
    		2025-04-23 00:00:00.000-3244.9870782125.32
    2
    		2025-04-22 00:00:00.000-71743.6470785370.3
    3
    		2025-04-21 00:00:00.000-17884.270857113.94
    4
    		2025-04-20 00:00:00.000-1575496.7470874998.14
    5
    		2025-04-19 00:00:00.000-49344.3972450494.88
    6
    		2025-04-18 00:00:00.000-407788.4872499839.27
    7
    		2025-04-17 00:00:00.000-165356.2672907627.75
    8
    		2025-04-16 00:00:00.000-16700.8573072984.01
    9
    		2025-04-15 00:00:00.000-118033.5773089684.86
    10
    		2025-04-14 00:00:00.000-36772.2473207718.43
    11
    		2025-04-13 00:00:00.000-162083.1573244490.67
    12
    		2025-04-12 00:00:00.000-18641.0473406573.82
    13
    		2025-04-11 00:00:00.000-77142.2273425214.86
    14
    		2025-04-10 00:00:00.000-90658.6373502357.08
    15
    		2025-04-09 00:00:00.000-33210.1673593015.71
    16
    		2025-04-08 00:00:00.000-264269.8773626225.87
    17
    		2025-04-07 00:00:00.000-13922.0273890495.74
    18
    		2025-04-06 00:00:00.00036040.8673904417.76
    19
    		2025-04-05 00:00:00.000-11045.8473868376.9
    20
    		2025-04-04 00:00:00.000-27990.6773879422.74
    ...
    1225
    60KB
    410s