cron.log

fetch_stock_prices.py Starting Stock Price Update
fetch_stock_prices.py started at: 2025-06-11 17:21:02
fetch_stock_prices.py estimated completion time: 32.00 minutes
fetch_stock_prices.py inserted 3718 stock price entries
fetch_stock_prices.py finished at: 2025-06-11 17:54:08
fetch_stock_prices.py used log files: stock_prices.log, db_inserts.log

fetch_stock_prices.py Starting Stock Price Update
fetch_stock_prices.py started at: 2025-06-12 17:21:01
fetch_stock_prices.py estimated completion time: 32.00 minutes
fetch_stock_prices.py inserted 3718 stock price entries
fetch_stock_prices.py finished at: 2025-06-12 17:54:14
fetch_stock_prices.py used log files: stock_prices.log, db_inserts.log

fetch_stock_prices.py Starting Stock Price Update
fetch_stock_prices.py started at: 2025-06-13 17:21:01
fetch_stock_prices.py estimated completion time: 32.00 minutes
fetch_stock_prices.py inserted 3718 stock price entries
fetch_stock_prices.py finished at: 2025-06-13 17:54:01
fetch_stock_prices.py used log files: stock_prices.log, db_inserts.log

ERROR:root:❌ Error fetching crypto prices: HTTPSConnectionPool(host='pro-api.coinmarketcap.com', port=443): Max retries exceeded with url: /v1/cryptocurrency/quotes/latest?symbol=SKI%2CETH%2CVIRTUAL%2CBTC%2CSOL%2CXRP%2CAERO%2CGRT%2CVELO%2CLTC%2CANKR%2CADA%2CREQ%2CKRL&convert=USD (Caused by NameResolutionError(": Failed to resolve 'pro-api.coinmarketcap.com' ([Errno -3] Temporary failure in name resolution)"))
Traceback (most recent call last):
  File "/home/srsimpson/webscraper/env/lib/python3.11/site-packages/urllib3/connection.py", line 198, in _new_conn
    sock = connection.create_connection(
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/srsimpson/webscraper/env/lib/python3.11/site-packages/urllib3/util/connection.py", line 60, in create_connection
    for res in socket.getaddrinfo(host, port, family, socket.SOCK_STREAM):
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/lib/python3.11/socket.py", line 962, in getaddrinfo
    for res in _socket.getaddrinfo(host, port, family, type, proto, flags):
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
socket.gaierror: [Errno -3] Temporary failure in name resolution

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/home/srsimpson/webscraper/env/lib/python3.11/site-packages/urllib3/connectionpool.py", line 787, in urlopen
    response = self._make_request(
               ^^^^^^^^^^^^^^^^^^^
  File "/home/srsimpson/webscraper/env/lib/python3.11/site-packages/urllib3/connectionpool.py", line 488, in _make_request
    raise new_e
  File "/home/srsimpson/webscraper/env/lib/python3.11/site-packages/urllib3/connectionpool.py", line 464, in _make_request
    self._validate_conn(conn)
  File "/home/srsimpson/webscraper/env/lib/python3.11/site-packages/urllib3/connectionpool.py", line 1093, in _validate_conn
    conn.connect()
  File "/home/srsimpson/webscraper/env/lib/python3.11/site-packages/urllib3/connection.py", line 704, in connect
    self.sock = sock = self._new_conn()
                       ^^^^^^^^^^^^^^^^
  File "/home/srsimpson/webscraper/env/lib/python3.11/site-packages/urllib3/connection.py", line 205, in _new_conn
    raise NameResolutionError(self.host, self, e) from e
urllib3.exceptions.NameResolutionError: : Failed to resolve 'pro-api.coinmarketcap.com' ([Errno -3] Temporary failure in name resolution)

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/home/srsimpson/webscraper/env/lib/python3.11/site-packages/requests/adapters.py", line 667, in send
    resp = conn.urlopen(
           ^^^^^^^^^^^^^
  File "/home/srsimpson/webscraper/env/lib/python3.11/site-packages/urllib3/connectionpool.py", line 841, in urlopen
    retries = retries.increment(
              ^^^^^^^^^^^^^^^^^^
  File "/home/srsimpson/webscraper/env/lib/python3.11/site-packages/urllib3/util/retry.py", line 519, in increment
    raise MaxRetryError(_pool, url, reason) from reason  # type: ignore[arg-type]
    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
urllib3.exceptions.MaxRetryError: HTTPSConnectionPool(host='pro-api.coinmarketcap.com', port=443): Max retries exceeded with url: /v1/cryptocurrency/quotes/latest?symbol=SKI%2CETH%2CVIRTUAL%2CBTC%2CSOL%2CXRP%2CAERO%2CGRT%2CVELO%2CLTC%2CANKR%2CADA%2CREQ%2CKRL&convert=USD (Caused by NameResolutionError(": Failed to resolve 'pro-api.coinmarketcap.com' ([Errno -3] Temporary failure in name resolution)"))

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/home/srsimpson/webscraper/scripts/fetch_crypto_prices.py", line 106, in fetch_crypto_prices_normal
    response = requests.get(COINMARKETCAP_API_URL, headers=headers, params=params)
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/srsimpson/webscraper/env/lib/python3.11/site-packages/requests/api.py", line 73, in get
    return request("get", url, params=params, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/srsimpson/webscraper/env/lib/python3.11/site-packages/requests/api.py", line 59, in request
    return session.request(method=method, url=url, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/srsimpson/webscraper/env/lib/python3.11/site-packages/requests/sessions.py", line 589, in request
    resp = self.send(prep, **send_kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/srsimpson/webscraper/env/lib/python3.11/site-packages/requests/sessions.py", line 703, in send
    r = adapter.send(request, **kwargs)
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/srsimpson/webscraper/env/lib/python3.11/site-packages/requests/adapters.py", line 700, in send
    raise ConnectionError(e, request=request)
requests.exceptions.ConnectionError: HTTPSConnectionPool(host='pro-api.coinmarketcap.com', port=443): Max retries exceeded with url: /v1/cryptocurrency/quotes/latest?symbol=SKI%2CETH%2CVIRTUAL%2CBTC%2CSOL%2CXRP%2CAERO%2CGRT%2CVELO%2CLTC%2CANKR%2CADA%2CREQ%2CKRL&convert=USD (Caused by NameResolutionError(": Failed to resolve 'pro-api.coinmarketcap.com' ([Errno -3] Temporary failure in name resolution)"))
INFO:crypto_prices:ℹ No crypto prices to insert.
INFO:crypto_prices:✅ fetch_crypto_prices.py finished execution.