Examples

Scenario inform...

Related scenari...

Resources

>  Get a list of the Top 100 Most Expensive NFTs Non Fungible Tokens on the FTX US NFT Marketplace Ranked by Offer Price including id, name, collection, series, issuer, SOL Solana mint address and ETH Ethereum contract address

[![button](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/scenarios/try-it-now.png)](https://app.cryptosheets.com/#/browse/FTX%20US/List%20NFTs%20US?scenarioId=600)

**Tags:** `sbf,nft,solana,sol,non fungible,mint,minting,non-fungible,erc721,erc-721,collectibles,ftx,ftx us exchange,apes`

![IMG](https://res.cloudinary.com/cryptosheets/image/upload/l_logos:ftxus-300x300,w_0.2,fl_relative,co_black,e_shadow:90,c_thumb,g_north_east,x_25,y_25,o_90/l_text:twitter.otf_125:Top%20100%20Most%20Expensive%20NFTs%20on%20FTX%20US%20NFT%20Marketplace%20Ranked%20by%20Offer%20Price,co_rgb:006630,e_shadow:40,c_fit,g_west,x_100,h_400,w_1300,g_south_west,x_25,y_250,g_north_west,x_25,y_150/l_text:twitter.otf_60_light:Get%20a%20list%20of%20the%20Top%20100%20Most%20Expensive%20NFTs%20Non%20Fungible%20Tokens%20on%20the%20FTX%20US%20NFT%20Marketplace%20Ranked%20by%20Offer%20Price%20including%20id%20name%20collection%20series%20issuer%20SOL%20Solana%20mint%20address%20and%20ETH%20Ethereum%20contract%20address,co_black,c_fit,g_west,x_100,h_400,w_1500,g_south_west,x_25,y_50/twitter/twitter-base-scenario4.png)


### Examples

Try the click + copy + paste spreadsheet formulas below: 

**Excel:**

<inline-code functionvalue='=CS.QUERY("FTX US","List NFTs US",{"_limit","100";"_path","[? offerPrice > `0`] | reverse(sort_by(@, &offerPrice)) | [*].{collection: collection, ethContractAddress: ethContractAddress, id: id, issuer: issuer, name: name, offerPrice: offerPrice, series: series, solMintAddress: solMintAddress}"})'> =CS.QUERY("FTX US","List NFTs US",{"_limit","100";"_path","[? offerPrice > `0`] | reverse(sort_by(@, &offerPrice)) | [*].{collection: collection, ethContractAddress: ethContractAddress, id: id, issuer: issuer, name: name, offerPrice: offerPrice, series: series, solMintAddress: solMintAddress}"})</inline-code>

**Google Sheets:**

<inline-code functionvalue='=CSQUERY("FTX US","List NFTs US",{"_limit","100";"_path","[? offerPrice > `0`] | reverse(sort_by(@, &offerPrice)) | [*].{collection: collection, ethContractAddress: ethContractAddress, id: id, issuer: issuer, name: name, offerPrice: offerPrice, series: series, solMintAddress: solMintAddress}"})'> =CSQUERY("FTX US","List NFTs US",{"_limit","100";"_path","[? offerPrice > `0`] | reverse(sort_by(@, &offerPrice)) | [*].{collection: collection, ethContractAddress: ethContractAddress, id: id, issuer: issuer, name: name, offerPrice: offerPrice, series: series, solMintAddress: solMintAddress}"})</inline-code>




### Scenario information

**Provider:** [FTX US](https://app.cryptosheets.com/#/browse/FTX%20US) **Endpoint:** [List NFTs US](https://docs.cryptosheets.com/providers/ftx-us) 

**Category:** `current` **Type:** `screener`

**Last Updated:** 2021-10-11 20:56:57.5380000 | **ScenarioId:** 600 | **Parameters:** 2

### Related scenarios & content

  - Browse all of our scenarios **[WebApp](https://app.cryptosheets.com/#/browse)**  |  **[Docs Portal](https://docs.cryptosheets.com/scenarios/)**
  - Browse other endpoints from [FTX US](https://app.cryptosheets.com/#/browse/FTX%20US) **[WebApp](https://app.cryptosheets.com/#/browse/FTX%20US)**  |  **[Docs Portal](https://docs.cryptosheets.com/providers/ftx-us)**

### Resources

Cryptosheets scenarios are dynamic combinations of pre-configured queries, transformations and filters easily searchable & accessible with one click. Scenarios are a gamechanger for the way you access and use crypto data inside a spreadsheet. Start saving time today and explore our tutorials, examples  & other resources below.

- [**How to use Cryptosheets Scenarios**](https://medium.com/cryptosheets/introducing-cryptosheets-scenarios-6a69d9e19886)
- [**Help Center**](https://intercom.help/cryptosheets/en/)
- [**Scenario Guides**](https://intercom.help/cryptosheets/en/articles/4571225-how-to-use-cryptosheets-scenarios)
- [**Scenario Tutorial Blog**](https://medium.com/cryptosheets/introducing-cryptosheets-scenarios-6a69d9e19886)
- [**Scenario YouTube Examples**](https://www.youtube.com/channel/UCReKkrBSlgKgNJlWHLASiPQ)

Example tutorials for using the Top 100 Most Expensive NFTs on FTX US NFT Marketplace Ranked by Offer Price spreadsheet scenario in Excel and Google Sheets