Is There A Way I Can Grab A Column Of A Table That Span Over Several Pages Using Python?

I am trying to get the tickers of ETFs from a table that spans over 46 pages: http://etfdb.com/type/region/north-america/us/#etfs&sort_name=assets_under_management&sort_ord

Solution 1:

You could use the etfdb-api Node.js package: https://www.npmjs.com/package/etfdb-api

It provides you with:

• Pagination
• Sorting by: Year to Date Return, Price, AUM, Avg. Volume, etc.
• Sort order: DESC | ASC

Here is a sample JSON response:

  {
    "symbol": {
      "type": "link",
      "text": "VIXM",
      "url": "/etf/VIXM/"
    },
    "name": {
      "type": "link",
      "text": "ProShares VIX Mid-Term Futures ETF",
      "url": "/etf/VIXM/"
    },
    "mobile_title": "VIXM - ProShares VIX Mid-Term Futures ETF",
    "price": "$26.47",
    "assets": "$48.21",
    "average_volume": "69,873",
    "ytd": "25.15%",
    "overall_rating": {
      "type": "restricted",
      "url": "/members/join/"
    },
    "asset_class": "Volatility"
  },
  {
    "symbol": {
      "type": "link",
      "text": "DGBP",
      "url": "/etf/DGBP/"
    },
    "name": {
      "type": "link",
      "text": "VelocityShares Daily 4x Long USD vs GBP ETN",
      "url": "/etf/DGBP/"
    },
    "mobile_title": "DGBP - VelocityShares Daily 4x Long USD vs GBP ETN",
    "price": "$30.62",
    "assets": "$4.85",
    "average_volume": "1,038",
    "ytd": "25.13%",
    "overall_rating": {
      "type": "restricted",
      "url": "/members/join/"
    },
    "asset_class": "Currency"
  }

Disclaimer: I'm the author. :)