flipside

    TOP COLLECTION 7 day TX JUST SALE
    yasminTOP COLLECTION 7 day TX JUST SALE
    Updated 2025-05-02
    WITH collection_tx AS (
    SELECT DECODED_LOG:collection AS COLLECTION,
    Count(DISTINCT TX_HASH) AS TX
    FROM avalanche.core.ez_decoded_event_logs
    WHERE CONTRACT_ADDRESS in('0xd0996694bc687a3c3e5de6332e6e542ad774dd3f' ,'0x8d904c8b6bb673d88cdbcd5798cda439f33cb3a4') -- SALVOR v1 v2
    AND ORIGIN_FUNCTION_SIGNATURE IN ('0x8c20729a', '0xdc13a78f', '0xba88ea95')
    AND EVENT_NAME IN ('Redeem', 'AcceptOffer')
    AND TX_STATUS = 'SUCCESS'
    AND BLOCK_TIMESTAMP >= DATEADD(day, -7, CURRENT_DATE())
    GROUP BY DECODED_LOG:collection
    )
    SELECT
    COALESCE(dim_contracts.NAME, collection_TX.COLLECTION) AS COLLECTION_NAME,
    -- RANK() OVER (ORDER BY collection_volumes.TOTAL_VOLUME DESC) AS RANK,
    CASE
    WHEN COALESCE(dim_contracts.NAME, collection_tx.COLLECTION) = 'The Salvors' THEN
    '<img src="https://image.nftscan.com/avax/logo/0xce4fee23ab35d0d9a4b6b644881ddd8adebeb300.png" style="width:30px;"><b> Salvors </b>'
    ---------
    WHEN COALESCE(dim_contracts.NAME, collection_tx.COLLECTION) = 'The Face 1966' THEN
    '<img src="https://i.postimg.cc/RVFRDZJZ/eb459a63-84d9-4f04-a885-d59007811a4f.webp" style="width:30px;"><b> The Face 1966 </b>'
    -------------
    WHEN COALESCE(dim_contracts.NAME, collection_tx.COLLECTION) ILIKE '%Cayden%' THEN
    '<img src="https://i.postimg.cc/hvmyTvS9/4815336477145628112-272016743.avif" style="width:30px;"><b> Cayden s Avax Army </b>'

    -- WHEN COALESCE(dim_contracts.NAME, collection_tx.COLLECTION) ILIKE '%Lil Coq%' THEN
    -- '<img src="https://i.postimg.cc/C1MTYjsz/67c264a4-f6ff-4a44-84d7-bb3031f2d9e4.webp" style="width:30px;"><b> Lil Coq </b>'

    -- WHEN COALESCE(dim_contracts.NAME, collection_tx.COLLECTION) ILIKE '%Bruskies%' THEN
    -- '<img src="https://i.postimg.cc/bvq7Pxq4/70b0af66-5009-462d-a34a-0006bab6e73c.webp" style="width:30px;"><b> Bruskies </b>'
    END AS "image"
    ,collection_TX.TX
    FROM collection_TX
    LEFT JOIN avalanche.core.dim_contracts dim_contracts
    ON collection_TX.COLLECTION = dim_contracts.ADDRESS
    where "image" is not null
    ORDER BY collection_TX.TX DESC