flipside

    shrill-lime
    i_danshrill-lime
    Updated 2024-11-22
    WITH contract_info AS (
    SELECT
    *
    FROM (
    VALUES
    ('DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263', ' BONK', '@bonk_inu', '<img src="https://statics.solscan.io/cdn/imgs/s60?ref=68747470733a2f2f617277656176652e6e65742f685169505a4f73525a584758424a645f3832506856646c4d5f68414373545f713677717766356353593749" style="width:30px; border-radius: 100%;"><b> BONK </b>')
    , ('ukHH6c7mMyiWCf1b9pnWe25TSpkDDt3H5pQZgZ74J82', ' BOME', '@Bomebookofmemes', '<img src="https://statics.solscan.io/cdn/imgs/s60?ref=68747470733a2f2f6261666b726569687a746b35706f67653766326c7a366c6f67666a6d686337683775367368766761636f6b746e75657a6b73356f626c6d696575652e697066732e6e667473746f726167652e6c696e6b" style="width:30px; border-radius: 100%;"><b> BOME </b>')
    , ('EKpQGSJtjMFqKZ9KQanSqYXRcF8fBopzLHYxdM65zcjm', ' WIF', '@dogwifcoin', '<img src="https://statics.solscan.io/cdn/imgs/s60?ref=68747470733a2f2f6261666b726569626b33636f7673356c7479717861323732756f646863756c6272366b656136626574696466777933616a73617632766a7a79756d2e697066732e6e667473746f726167652e6c696e6b" style="width:30px; border-radius: 100%;"><b> WIF </b>')
    , ('7GCihgDB8fe6KNjn2MYtkzZcRjQy3t9GHdC8uHYmW2hr', ' POPCAT', '@POPCATSOLANA', '<img src="https://statics.solscan.io/cdn/imgs/s60?ref=68747470733a2f2f617277656176652e6e65742f41316574524e4d4b78686c4e4754662d674e42744a3735514a4a344e4a74624b685f555851546c4c587a49" style="width:30px; border-radius: 100%;"><b> POPCAT </b>')
    , ('2qEHjDLDLbuBgRYvsxhc5D6uDWAivNFZGan56P1tpump', ' PNUT', '@pnutsolana', '<img src="https://statics.solscan.io/cdn/imgs/s60?ref=68747470733a2f2f697066732e696f2f697066732f516d4e6454744a61757733397534447a477954615a3335725278345667417871623931774538397a6a7948576432" style="width:30px; border-radius: 100%;"><b> PNUT </b>')
    , ('CzLSujWBLFsSjncfkh59rUFqvafWcY5tzedWJSuypump', ' GOAT', '@truth_terminal', '<img src="https://statics.solscan.io/cdn/imgs/s60?ref=68747470733a2f2f697066732e696f2f697066732f516d617041713957744e7274796144746a5a504148484e596d70535a415155364879777776665357713464515656" style="width:30px; border-radius: 100%;"><b> GOAT </b>')
    , ('MEW1gQWJ3nEXg2qgERiKu7FAFj79PHvQVREQUzScPP5', ' MEW', '@MewsWorld', '<img src="https://statics.solscan.io/cdn/imgs/s60?ref=68747470733a2f2f6261666b726569646c777972353635647874616f326970737a6536626d7a70737a717a79627a37737169327a616574356673376b353368656e6a752e697066732e6e667473746f726167652e6c696e6b2f" style="width:30px; border-radius: 100%;"><b> MEW </b>')
    , ('GJAFwWjJ3vnTsrQVabjBVK2TYB1YtRCQXRDfDgUnpump', ' ACT', '@ACTICOMMUNITY', '<img src="https://pbs.twimg.com/profile_images/1849437252453040128/VaWuupdu_400x400.jpg" style="width:30px; border-radius: 100%;"><b> ACT </b>')
    , ('A8C3xuqscfmyLrte3VmTqrAq8kgMASius9AFNANwpump', ' FWOG', '@itsafwog', '<img src="https://pbs.twimg.com/profile_images/1847811775242063874/aPQtRzhg_400x400.jpg" style="width:30px; border-radius: 100%;"><b> FWOG </b>')
    ) AS t (contract_address, token_name, twitter,image)
    )

    --burn AS (
    --launch_prices AS (
    SELECT
    contract_address,
    token_name,
    price AS launch_price
    FROM (
    SELECT
    c.contract_address,
    c.token_name,
    p.price,
    ROW_NUMBER() OVER (PARTITION BY c.contract_address ORDER BY p.hour ASC) AS row_num
    FROM contract_info c
    JOIN solana.price.ez_prices_hourly p
    ON c.contract_address = p.token_address
    ) ranked_prices
    QueryRunArchived: QueryRun has been archived