flipside

    Try Quests to earn SOLTry Quests to earn SOL
    Share

    LILY NFT Collection

    The purpose of creating this dashboard is to get information about LILY NFT collection. This Collection is one of the 15 most popular Collections in the Magic Eden market.

    📖 INTRO

    LILY is a popular NFT collection in the Solana chain. This collection is currently ranked 14th among the popular collections in the Magic Eden market. The currently floor price of the tokens of this collection is about 8 sol. The total number of tokens in this collection is 10K and about 500 tokens have been released so far. This collection is actually one of the two collections of NFTs of the Lotus brand. Various NFT Marketplaces have offered tokens of this collection, which can be mentioned as Magic Eden, Solanart, and Coral Cube.

    db_img
    db_img

    🔧 METHOD

    By using the dim_labeles table and calling the data by putting the name of the collection in the label parameter and filtering parameters such as LABEL_SUBTYPE and ADDRESS_NAME and joining this table with the fact_nft_sales table and by placing the mints of the two tables equally, we were able to call the data related to the Lily collection.