API for data farming

Endpoints

POST /allocations

Queries allocations table. Queryable fields:

chainID,nft_addr,LP_addr,percent,ve_allocated

POST /volume

Queries nft_vols table. Queryable fields:

chainID,basetoken_addr,nft_addr,vol_amt

POST /nftinfo

Queries nft_info table. Queryable fields:

chainID,nft_addr,did,symbol,name,ve_allocated ocean_allocated,ve_allocated_owner, ocean_allocated_owner,ve_allocated_realtime,ocean_allocated_realtime,ve_allocated_realtime_owner,ocean_allocated_realtime_owner,volume,is_purgatory,apr,apy,roundYield,owner_addr,round

POST /vebals

Queries vebals table.
Queryable fields:

LP_addr,balance

POST /rewards

Queries rewards_info table.
Queryable fields:

chainID,LP_addr,nft_addr,amt,token

POST /rewardsSummary

Queries rewards_summary table.
Queryable fields:

LP_addr,passive_amt,curating_amt

Request examples

POST /nft_vols

"query":{
   "vol_amt":{"$gt":3}
}

Returns the list of DataNFTs where the vol_amt is greater than 3.

---

POST /nft_vols

"query":{
  "nft_addr":"0x18b025e44bcd8dafd00638ce87bddbd38c4c38e7"
}

Returns the info for DataNFT with the address 0x18b025e44bcd8dafd00638ce87bddbd38c4c38e7

---

POST /volume

"query":{
  "$or": [
    {
      "$and": {
        "chainID": 4,
        "vol_amt": {
          "$gt": 3
        }
      }
    },
    {
      "$and": {
        "chainID": 1,
        "vol_amt": {
          "$gt": 5
        }
      }
    }
  ]
}

Returns the list of DataNFTs where chainID is 4 and vol_amt is greater than 3 or chainID is 1 and vol_amt is greater than 5.

---

POST /nft_vols

"query":{
  "vol_amt":{"$gt":3}
},
"sort":{
  "vol_amt":-1
},
"limit":10

Returns the list of 10 DataNFTs where the vol_amt is greater than 3. Sorted by vol_amt descending.

---

POST /nft_vols

"query":{
  "vol_amt":{"$gt":3}
},
"sort":{
  "vol_amt":-1
},
"limit":10,
"offset":10

Same as above + skips the first 10 DataNFTs.

---

POST /rewards_info

{
  "fields": [
    {
      "expression": {
        "pattern": "sum(amt)"
      }
    },
    "nft_addr"
  ],
  "group": "nft_addr"
}

Returns the reward amount per nft.

---

POST /nft_info

{
  "join": [
    {
      "alias": "t0",
      "type": "left",
      "on": {
        "nft_info.nft_addr": "t0.nft_addr"
      },
      "select": {
        "table": "rewards_info",
        "fields": [
          {
            "expression": {
              "pattern": "sum(amt)"
            }
          },
          "nft_addr"
        ],
        "group": "nft_addr"
      }
    }
  ]
}

Returns the DataNFT list with the total reward amount for each DataNFT.