Postgres 14

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table nftdata (collection_id text, data jsonb);
insert into  nftdata (collection_id, data) values
('collection1', '{
  "api_version": "0.1",
  "result": {
    "api_code": 200,
    "api_response": "Success",
    "data": {
      "collection": "XXX NFT",
      "ranking_url": "https://nft",
      "twitter": "https://twitter.com/nft/",
      "discord": "https://discord.com/invite/",
      "website": "https://nft.io/",
      "description": "2",
      "logo": "https://icons/f245c3aea5e279691f5f460d9d499afe.jpg",
      "items": [
        {
          "id": 2414,
          "link": "/2414",
          "mint": "FHAJS21yJBtYDuix1x7woZPUo",
          "name": "NFT #2414",
          "description": "-",
          "image": "https://arweave.net/mKbawCJP4dX9_IZg",
          "attributes": [
            "Deleted to shorten post"
          ],
          "rank": 1,
          "rank_algo": "h",
          "all_ranks": {
            "is": 1,
            "trait_normalized": 1,
            "statistical_rarity": 1876
          }
        },
        {
          "id": 198,
          "link": "/198",
          "mint": "EiGbBm7CsB8ZeZF5Hg",
          "name": "NFT #198",
          "description": "-",
          "image": "https://arweave.net/fAVzxoqcsracjf",
          "attributes": [
            "Deleted to shorten post"
          ],
          "rank": 2,
          "rank_algo": "h",
          "all_ranks": {
            "is": 2,
            "trait_normalized": 2,
            "statistical_rarity": 2246
          }
        }
      ]
    }
  }
}'),
('collection2', '{
  "api_version": "0.1",
  "result": {
    "api_code": 200,
    "api_response": "Success",
    "data": {
      "collection": "XXX NFT",
      "ranking_url": "https://nft",
      "twitter": "https://twitter.com/nft/",
      "discord": "https://discord.com/invite/",
      "website": "https://nft.io/",
      "description": "2",
      "logo": "https://icons/f245c3aea5e279691f5f460d9d499afe.jpg",
      "items": [
        {
          "id": 2415,
          "link": "/2414",
          "mint": "FHAJS21yJBtYDuix1x7woZPUo",
          "name": "NFT #2414",
          "description": "-",
          "image": "https://arweave.net/mKbawCJP4dX9_IZg",
          "attributes": [
            "Deleted to shorten post"
          ],
          "rank": 1,
          "rank_algo": "h",
          "all_ranks": {
            "is": 1,
            "trait_normalized": 1,
            "statistical_rarity": 1876
          }
        },
        {
          "id": 199,
          "link": "/198",
          "mint": "EiGbBm7CsB8ZeZF5Hg",
          "name": "NFT #198",
          "description": "-",
          "image": "https://arweave.net/fAVzxoqcsracjf",
          "attributes": [
            "Deleted to shorten post"
          ],
          "rank": 2,
          "rank_algo": "h",
          "all_ranks": {
            "is": 2,
            "trait_normalized": 2,
            "statistical_rarity": 2246
          }
        }
      ]
    }
  }
}');

2 rows affected

item
{"id": 2414, "link": "/2414", "mint": "FHAJS21yJBtYDuix1x7woZPUo", "name": "NFT #2414", "rank": 1, "image": "https://arweave.net/mKbawCJP4dX9_IZg", "all_ranks": {"is": 1, "trait_normalized": 1, "statistical_rarity": 1876}, "rank_algo": "h", "attributes": ["Deleted to shorten post"], "description": "-"}