NakedCollectorSOLANA: Tokens That Have Rebounded 4h vs. 24h
    Updated 2024-08-13
    WITH last_24h_data AS (
    SELECT
    SWAP_TO_MINT as "Address",
    SWAP_TO_SYMBOL as "Token",
    COALESCE(SUM(SWAP_TO_AMOUNT_USD), 0) as "Bought_24h",
    COALESCE(SUM(SWAP_FROM_AMOUNT_USD), 0) as "Sold_24h",
    COALESCE(SUM(SWAP_TO_AMOUNT_USD), 0) - COALESCE(SUM(SWAP_FROM_AMOUNT_USD), 0) as "Net_24h"
    FROM
    solana.defi.ez_dex_swaps
    WHERE
    BLOCK_TIMESTAMP >= CURRENT_DATE - INTERVAL '24 hours'
    GROUP BY
    1, 2
    ),
    last_12h_data AS (
    SELECT
    SWAP_TO_MINT as "Address",
    SWAP_TO_SYMBOL as "Token",
    count (distinct SWAPPER) as "Unique Swapper (12h)",
    COALESCE(SUM(SWAP_TO_AMOUNT_USD), 0) as "Bought_12h",
    COALESCE(SUM(SWAP_FROM_AMOUNT_USD), 0) as "Sold_12h",
    COALESCE(SUM(SWAP_TO_AMOUNT_USD), 0) - COALESCE(SUM(SWAP_FROM_AMOUNT_USD), 0) as "Net_12h"
    FROM
    solana.defi.ez_dex_swaps
    WHERE
    BLOCK_TIMESTAMP >= CURRENT_DATE - INTERVAL '4 hours'
    GROUP BY
    1, 2
    )
    SELECT
    l12."Address",
    l12."Token",
    l12."Unique Swapper (12h)",
    (l12."Bought_12h" + l24."Bought_24h")as "Bought",
    (l12."Sold_12h" + l24."Sold_24h")as "Sold",
    (l12."Net_12h" + l24."Net_24h")as "Net",
    QueryRunArchived: QueryRun has been archived