flipside

    Collection Summary
    feyikemiCollection Summary
    Updated 2025-04-07
    WITH Price AS (
    SELECT
    HOUR::date AS date,
    token_address,
    AVG(price) AS price_usd
    FROM ronin.price.ez_prices_hourly
    GROUP BY 1, 2
    ),

    NFT_TXNS AS (
    SELECT
    tx_hash,
    block_timestamp,
    from_address AS seller,
    to_address AS buyer,
    name AS collection,
    token_id,
    quantity,
    decoded_log:acceptedSettlePrice / 1e18 AS nft_price,
    (decoded_log:acceptedSettlePrice / 1e18) * price_usd AS nft_price_usd
    FROM ronin.nft.ez_nft_transfers tr
    JOIN ronin.core.ez_decoded_event_logs log
    USING (tx_hash, block_timestamp)
    LEFT JOIN Price p
    ON block_timestamp::date = p.date
    AND log.decoded_log:settleToken = token_address
    WHERE event_name = 'OrderMatched'
    AND decoded_log:order[0]:extraData[0][2] = token_id
    AND tx_succeeded
    AND name IS NOT NULL
    -- AND block_timestamp >= CURRENT_DATE - INTERVAL '30 days'
    ),

    Collection_Sales AS (
    SELECT
    collection,
    Last run: about 2 months ago
    COLLECTION
    TOTAL_SALES_VOLUME_USD
    MARKET_PERCENTAGE_VOLUME
    TOTAL_SALES
    TOTAL_TRADERS
    FIRST_TRADE_DATE
    1
    		Axie3683956.4312.5%36139132802024-10-01 00:00:00.000
    2
    		Axie Material3208674.4110.89%841544782024-10-01 00:00:00.000
    3
    		Axie Land3002261.2410.19%239618302024-10-01 00:00:00.000
    4
    		Lumiterra Game Item2316531.37.86%17582754022024-10-01 00:00:00.000
    5
    		Nyang Kit1736576.195.89%951448222024-10-01 00:00:00.000
    6
    		Axie Consumable Item1337365.164.54%299615872024-10-02 00:00:00.000
    7
    		Wild Forest Packs970389.463.29%689526362024-10-01 00:00:00.000
    8
    		Moki Collection936813.323.18%364532532024-10-01 00:00:00.000
    9
    		CambriaCores907606.633.08%285522642024-12-20 00:00:00.000
    10
    		Farm Land862012.922.93%4435082024-10-01 00:00:00.000
    11
    		Fableborne Kingdoms741181.62.52%241622712025-02-20 00:00:00.000
    12
    		Sabong Saga Genesis639598.222.17%127710452025-01-17 00:00:00.000
    13
    		RuniverseLand626809.022.13%223816812024-10-01 00:00:00.000
    14
    		PHZM607523.942.06%974172252024-10-16 00:00:00.000
    15
    		KaidroPilot592387.32.01%138310402024-11-22 00:00:00.000
    16
    		Original Kanstar583822.121.98%267421122025-01-03 00:00:00.000
    17
    		Ragnarok Monsters554118.731.88%3790477272024-10-01 00:00:00.000
    18
    		Wild Forest Units545694.121.85%69215101002024-10-01 00:00:00.000
    19
    		Primal HeroZ505171.561.71%2470757472024-10-24 00:00:00.000
    20
    		Sabong Saga Items477850.351.62%311215842025-01-19 00:00:00.000
    94
    7KB
    13s