Skip to content

Instantly share code, notes, and snippets.

@johnfelipe

johnfelipe/alllog.sh

Created December 12, 2023 14:19
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save johnfelipe/22bb27a7f88bd2dc22fd54cbe7aca630 to your computer and use it in GitHub Desktop.
Save johnfelipe/22bb27a7f88bd2dc22fd54cbe7aca630 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
alllog.sh
Defaulting to user installation because normal site-packages is not writeable
Collecting investorzilla
Downloading investorzilla-2.4.1-py3-none-any.whl (72 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 72.5/72.5 KB 1.0 MB/s eta 0:00:00
Collecting pandas-datareader
Downloading pandas_datareader-0.10.0-py3-none-any.whl (109 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 109.5/109.5 KB 2.5 MB/s eta 0:00:00
Collecting sqlalchemy
Downloading SQLAlchemy-2.0.23-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (3.0 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 3.0/3.0 MB 20.1 MB/s eta 0:00:00
Requirement already satisfied: certifi in /usr/lib/python3/dist-packages (from investorzilla) (2020.6.20)
Collecting pyaml
Downloading pyaml-23.9.7-py3-none-any.whl (23 kB)
Collecting google-auth-oauthlib
Downloading google_auth_oauthlib-1.1.0-py2.py3-none-any.whl (19 kB)
Requirement already satisfied: pandas>=2 in /usr/local/lib/python3.10/dist-packages (from investorzilla) (2.1.4)
Collecting matplotlib
Downloading matplotlib-3.8.2-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (11.6 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 11.6/11.6 MB 32.5 MB/s eta 0:00:00
Collecting google-api-python-client
Downloading google_api_python_client-2.110.0-py2.py3-none-any.whl (12.9 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 12.9/12.9 MB 18.9 MB/s eta 0:00:00
Requirement already satisfied: streamlit in /usr/local/lib/python3.10/dist-packages (from investorzilla) (1.29.0)
Collecting google-auth-httplib2
Downloading google_auth_httplib2-0.1.1-py2.py3-none-any.whl (9.3 kB)
Requirement already satisfied: tzdata>=2022.1 in /usr/local/lib/python3.10/dist-packages (from pandas>=2->investorzilla) (2023.3)
Requirement already satisfied: numpy<2,>=1.22.4 in /usr/local/lib/python3.10/dist-packages (from pandas>=2->investorzilla) (1.26.2)
Requirement already satisfied: python-dateutil>=2.8.2 in /usr/local/lib/python3.10/dist-packages (from pandas>=2->investorzilla) (2.8.2)
Requirement already satisfied: pytz>=2020.1 in /usr/lib/python3/dist-packages (from pandas>=2->investorzilla) (2022.1)
Collecting google-auth<3.0.0.dev0,>=1.19.0
Downloading google_auth-2.25.2-py2.py3-none-any.whl (184 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 184.2/184.2 KB 15.1 MB/s eta 0:00:00
Collecting google-api-core!=2.0.*,!=2.1.*,!=2.2.*,!=2.3.0,<3.0.0.dev0,>=1.31.5
Downloading google_api_core-2.15.0-py3-none-any.whl (121 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 122.0/122.0 KB 22.2 MB/s eta 0:00:00
Requirement already satisfied: httplib2<1.dev0,>=0.15.0 in /usr/lib/python3/dist-packages (from google-api-python-client->investorzilla) (0.20.2)
Collecting uritemplate<5,>=3.0.1
Downloading uritemplate-4.1.1-py2.py3-none-any.whl (10 kB)
Collecting requests-oauthlib>=0.7.0
Downloading requests_oauthlib-1.3.1-py2.py3-none-any.whl (23 kB)
Collecting cycler>=0.10
Downloading cycler-0.12.1-py3-none-any.whl (8.3 kB)
Requirement already satisfied: packaging>=20.0 in /usr/local/lib/python3.10/dist-packages (from matplotlib->investorzilla) (23.2)
Requirement already satisfied: pillow>=8 in /usr/local/lib/python3.10/dist-packages (from matplotlib->investorzilla) (10.1.0)
Requirement already satisfied: pyparsing>=2.3.1 in /usr/lib/python3/dist-packages (from matplotlib->investorzilla) (2.4.7)
Collecting fonttools>=4.22.0
Downloading fonttools-4.46.0-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (4.6 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 4.6/4.6 MB 14.6 MB/s eta 0:00:00
Collecting contourpy>=1.0.1
Downloading contourpy-1.2.0-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (310 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 310.7/310.7 KB 16.5 MB/s eta 0:00:00
Collecting kiwisolver>=1.3.1
Downloading kiwisolver-1.4.5-cp310-cp310-manylinux_2_12_x86_64.manylinux2010_x86_64.whl (1.6 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 1.6/1.6 MB 13.1 MB/s eta 0:00:00
Requirement already satisfied: requests>=2.19.0 in /usr/local/lib/python3.10/dist-packages (from pandas-datareader->investorzilla) (2.31.0)
Collecting lxml
Downloading lxml-4.9.3-cp310-cp310-manylinux_2_28_x86_64.whl (7.9 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 7.9/7.9 MB 13.9 MB/s eta 0:00:00
Requirement already satisfied: PyYAML in /usr/lib/python3/dist-packages (from pyaml->investorzilla) (5.4.1)
Collecting greenlet!=0.4.17
Downloading greenlet-3.0.2-cp310-cp310-manylinux_2_24_x86_64.manylinux_2_28_x86_64.whl (613 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 613.4/613.4 KB 15.3 MB/s eta 0:00:00
Requirement already satisfied: typing-extensions>=4.2.0 in /usr/local/lib/python3.10/dist-packages (from sqlalchemy->investorzilla) (4.9.0)
Requirement already satisfied: click<9,>=7.0 in /usr/lib/python3/dist-packages (from streamlit->investorzilla) (8.0.3)
Requirement already satisfied: cachetools<6,>=4.0 in /usr/local/lib/python3.10/dist-packages (from streamlit->investorzilla) (5.3.2)
Requirement already satisfied: pyarrow>=6.0 in /usr/local/lib/python3.10/dist-packages (from streamlit->investorzilla) (14.0.1)
Requirement already satisfied: blinker<2,>=1.0.0 in /usr/lib/python3/dist-packages (from streamlit->investorzilla) (1.4)
Requirement already satisfied: altair<6,>=4.0 in /usr/local/lib/python3.10/dist-packages (from streamlit->investorzilla) (5.2.0)
Requirement already satisfied: protobuf<5,>=3.20 in /usr/local/lib/python3.10/dist-packages (from streamlit->investorzilla) (4.25.1)
Requirement already satisfied: toml<2,>=0.10.1 in /usr/local/lib/python3.10/dist-packages (from streamlit->investorzilla) (0.10.2)
Requirement already satisfied: watchdog>=2.1.5 in /usr/local/lib/python3.10/dist-packages (from streamlit->investorzilla) (3.0.0)
Requirement already satisfied: rich<14,>=10.14.0 in /usr/local/lib/python3.10/dist-packages (from streamlit->investorzilla) (13.7.0)
Requirement already satisfied: validators<1,>=0.2 in /usr/local/lib/python3.10/dist-packages (from streamlit->investorzilla) (0.22.0)
Requirement already satisfied: pydeck<1,>=0.8.0b4 in /usr/local/lib/python3.10/dist-packages (from streamlit->investorzilla) (0.8.1b0)
Requirement already satisfied: importlib-metadata<7,>=1.4 in /usr/lib/python3/dist-packages (from streamlit->investorzilla) (4.6.4)
Requirement already satisfied: gitpython!=3.1.19,<4,>=3.0.7 in /usr/local/lib/python3.10/dist-packages (from streamlit->investorzilla) (3.1.40)
Requirement already satisfied: tornado<7,>=6.0.3 in /usr/local/lib/python3.10/dist-packages (from streamlit->investorzilla) (6.4)
Requirement already satisfied: tenacity<9,>=8.1.0 in /usr/local/lib/python3.10/dist-packages (from streamlit->investorzilla) (8.2.3)
Requirement already satisfied: tzlocal<6,>=1.1 in /usr/local/lib/python3.10/dist-packages (from streamlit->investorzilla) (5.2)
Requirement already satisfied: jsonschema>=3.0 in /usr/lib/python3/dist-packages (from altair<6,>=4.0->streamlit->investorzilla) (3.2.0)
Requirement already satisfied: toolz in /usr/local/lib/python3.10/dist-packages (from altair<6,>=4.0->streamlit->investorzilla) (0.12.0)
Requirement already satisfied: jinja2 in /usr/local/lib/python3.10/dist-packages (from altair<6,>=4.0->streamlit->investorzilla) (3.0.0)
Requirement already satisfied: gitdb<5,>=4.0.1 in /usr/local/lib/python3.10/dist-packages (from gitpython!=3.1.19,<4,>=3.0.7->streamlit->investorzilla) (4.0.11)
Collecting googleapis-common-protos<2.0.dev0,>=1.56.2
Downloading googleapis_common_protos-1.62.0-py2.py3-none-any.whl (228 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 228.7/228.7 KB 17.2 MB/s eta 0:00:00
Requirement already satisfied: pyasn1-modules>=0.2.1 in /usr/lib/python3/dist-packages (from google-auth<3.0.0.dev0,>=1.19.0->google-api-python-client->investorzilla) (0.2.1)
Collecting rsa<5,>=3.1.4
Downloading rsa-4.9-py3-none-any.whl (34 kB)
Requirement already satisfied: six>=1.5 in /usr/lib/python3/dist-packages (from python-dateutil>=2.8.2->pandas>=2->investorzilla) (1.16.0)
Requirement already satisfied: urllib3<3,>=1.21.1 in /usr/lib/python3/dist-packages (from requests>=2.19.0->pandas-datareader->investorzilla) (1.26.5)
Requirement already satisfied: idna<4,>=2.5 in /usr/lib/python3/dist-packages (from requests>=2.19.0->pandas-datareader->investorzilla) (3.3)
Requirement already satisfied: charset-normalizer<4,>=2 in /usr/local/lib/python3.10/dist-packages (from requests>=2.19.0->pandas-datareader->investorzilla) (3.3.2)
Requirement already satisfied: oauthlib>=3.0.0 in /usr/lib/python3/dist-packages (from requests-oauthlib>=0.7.0->google-auth-oauthlib->investorzilla) (3.2.0)
Requirement already satisfied: markdown-it-py>=2.2.0 in /usr/local/lib/python3.10/dist-packages (from rich<14,>=10.14.0->streamlit->investorzilla) (3.0.0)
Requirement already satisfied: pygments<3.0.0,>=2.13.0 in /usr/local/lib/python3.10/dist-packages (from rich<14,>=10.14.0->streamlit->investorzilla) (2.17.2)
Requirement already satisfied: smmap<6,>=3.0.1 in /usr/local/lib/python3.10/dist-packages (from gitdb<5,>=4.0.1->gitpython!=3.1.19,<4,>=3.0.7->streamlit->investorzilla) (5.0.1)
Requirement already satisfied: MarkupSafe>=2.0.0rc2 in /usr/lib/python3/dist-packages (from jinja2->altair<6,>=4.0->streamlit->investorzilla) (2.0.1)
Requirement already satisfied: mdurl~=0.1 in /usr/local/lib/python3.10/dist-packages (from markdown-it-py>=2.2.0->rich<14,>=10.14.0->streamlit->investorzilla) (0.1.2)
Requirement already satisfied: pyasn1>=0.1.3 in /usr/lib/python3/dist-packages (from rsa<5,>=3.1.4->google-auth<3.0.0.dev0,>=1.19.0->google-api-python-client->investorzilla) (0.4.8)
Installing collected packages: uritemplate, rsa, pyaml, lxml, kiwisolver, greenlet, googleapis-common-protos, fonttools, cycler, contourpy, sqlalchemy, requests-oauthlib, matplotlib, google-auth, pandas-datareader, google-auth-oauthlib, google-auth-httplib2, google-api-core, google-api-python-client, investorzilla
WARNING: The scripts pyrsa-decrypt, pyrsa-encrypt, pyrsa-keygen, pyrsa-priv2pub, pyrsa-sign and pyrsa-verify are installed in '/home/felipe/.local/bin' which is not on PATH.
Consider adding this directory to PATH or, if you prefer to suppress this warning, use --no-warn-script-location.
WARNING: The script pyaml is installed in '/home/felipe/.local/bin' which is not on PATH.
Consider adding this directory to PATH or, if you prefer to suppress this warning, use --no-warn-script-location.
WARNING: The scripts fonttools, pyftmerge, pyftsubset and ttx are installed in '/home/felipe/.local/bin' which is not on PATH.
Consider adding this directory to PATH or, if you prefer to suppress this warning, use --no-warn-script-location.
WARNING: The script google-oauthlib-tool is installed in '/home/felipe/.local/bin' which is not on PATH.
Consider adding this directory to PATH or, if you prefer to suppress this warning, use --no-warn-script-location.
WARNING: The script investorzilla is installed in '/home/felipe/.local/bin' which is not on PATH.
Consider adding this directory to PATH or, if you prefer to suppress this warning, use --no-warn-script-location.
Successfully installed contourpy-1.2.0 cycler-0.12.1 fonttools-4.46.0 google-api-core-2.15.0 google-api-python-client-2.110.0 google-auth-2.25.2 google-auth-httplib2-0.1.1 google-auth-oauthlib-1.1.0 googleapis-common-protos-1.62.0 greenlet-3.0.2 investorzilla-2.4.1 kiwisolver-1.4.5 lxml-4.9.3 matplotlib-3.8.2 pandas-datareader-0.10.0 pyaml-23.9.7 requests-oauthlib-1.3.1 rsa-4.9 sqlalchemy-2.0.23 uritemplate-4.1.1
felipe@template:~/investorzilla$ cd investorzilla/
felipe@template:~/investorzilla/investorzilla$ mkdir myportfolio
felipe@template:~/investorzilla/investorzilla$ cp /root/investorzilla/config_examples/investorzilla.yaml /root/investorzilla/myportfolio/investorzilla.yaml
cp: failed to access '/root/investorzilla/myportfolio/investorzilla.yaml': Permission denied
felipe@template:~/investorzilla/investorzilla$ cp /home/felipe/investorzilla/config_examples/investorzilla.yaml /home/felipe/investorzilla/myportfolio/investorzilla.yaml
cp: cannot create regular file '/home/felipe/investorzilla/myportfolio/investorzilla.yaml': No such file or directory
felipe@template:~/investorzilla/investorzilla$ ls
currency __init__.py marketindex portfolio.py
datacache.py investor.py monetary_time_series.py portfolios
fund.py __main__.py myportfolio streamlit_ui.py
felipe@template:~/investorzilla/investorzilla$ 2023-12-12 13:58:59,251|INFO|investorzilla.datacache.DataCache|Set cache to kind=YahooMarketIndex, id=QQQ, time=2023-12-12 13:58:59.250565+00:00
2023-12-12 13:58:59.502 Uncaught app exception
Traceback (most recent call last):
File "/root/investorzilla/env/lib/python3.10/site-packages/streamlit/runtime/scriptrunner/script_runner.py", line 534, in _run_script
File "/root/investorzilla/env/lib/python3.10/site-packages/investorzilla/streamlit_ui.py", line 511, in <module>
File "/root/investorzilla/env/lib/python3.10/site-packages/investorzilla/streamlit_ui.py", line 76, in __init__
File "/root/investorzilla/env/lib/python3.10/site-packages/investorzilla/investor.py", line 49, in __init__
File "/root/investorzilla/env/lib/python3.10/site-packages/investorzilla/investor.py", line 125, in loadDomains
File "/usr/lib/python3.10/concurrent/futures/_base.py", line 451, in result
return self.__get_result()
File "/usr/lib/python3.10/concurrent/futures/_base.py", line 403, in __get_result
raise self._exception
File "/usr/lib/python3.10/concurrent/futures/thread.py", line 58, in run
result = self.fn(*self.args, **self.kwargs)
File "/root/investorzilla/env/lib/python3.10/site-packages/investorzilla/marketindex/brasil_banco_central.py", line 42, in __init__
File "/root/investorzilla/env/lib/python3.10/site-packages/investorzilla/monetary_time_series.py", line 200, in __init__
File "/root/investorzilla/env/lib/python3.10/site-packages/investorzilla/monetary_time_series.py", line 28, in __init__
File "/root/investorzilla/env/lib/python3.10/site-packages/investorzilla/monetary_time_series.py", line 77, in getData
File "/root/investorzilla/env/lib/python3.10/site-packages/investorzilla/marketindex/brasil_banco_central.py", line 54, in refreshData
File "/root/investorzilla/env/lib/python3.10/site-packages/pandas/io/json/_json.py", line 804, in read_json
File "/root/investorzilla/env/lib/python3.10/site-packages/pandas/io/json/_json.py", line 1014, in read
File "/root/investorzilla/env/lib/python3.10/site-packages/pandas/io/json/_json.py", line 1040, in _get_object_parser
File "/root/investorzilla/env/lib/python3.10/site-packages/pandas/io/json/_json.py", line 1173, in parse
File "/root/investorzilla/env/lib/python3.10/site-packages/pandas/io/json/_json.py", line 1366, in _parse
ValueError: Expected object or value
^C
felipe@template:~/investorzilla/investorzilla$ cp /home/felipe/investorzilla/config_examples/investorzilla.yaml /home/felipe/investorzilla/myportfolio/investorzilla.yaml
cp: cannot create regular file '/home/felipe/investorzilla/myportfolio/investorzilla.yaml': No such file or directory
felipe@template:~/investorzilla/investorzilla$ cd ..
felipe@template:~/investorzilla$ mkdir myportfolio
felipe@template:~/investorzilla$ cp /home/felipe/investorzilla/config_examples/investorzilla.yaml /home/felipe/investorzilla/myportfolio/investorzilla.yaml
felipe@template:~/investorzilla$ cd myportfolio
felipe@template:~/investorzilla/myportfolio$ investorzilla
investorzilla: command not found
felipe@template:~/investorzilla/myportfolio$ pip3 install investorzilla
Defaulting to user installation because normal site-packages is not writeable
Requirement already satisfied: investorzilla in /home/felipe/.local/lib/python3.10/site-packages (2.4.1)
Requirement already satisfied: certifi in /usr/lib/python3/dist-packages (from investorzilla) (2020.6.20)
Requirement already satisfied: pandas-datareader in /home/felipe/.local/lib/python3.10/site-packages (from investorzilla) (0.10.0)
Requirement already satisfied: google-auth-httplib2 in /home/felipe/.local/lib/python3.10/site-packages (from investorzilla) (0.1.1)
Requirement already satisfied: sqlalchemy in /home/felipe/.local/lib/python3.10/site-packages (from investorzilla) (2.0.23)
Requirement already satisfied: matplotlib in /home/felipe/.local/lib/python3.10/site-packages (from investorzilla) (3.8.2)
Requirement already satisfied: google-auth-oauthlib in /home/felipe/.local/lib/python3.10/site-packages (from investorzilla) (1.1.0)
Requirement already satisfied: streamlit in /usr/local/lib/python3.10/dist-packages (from investorzilla) (1.29.0)
Requirement already satisfied: pyaml in /home/felipe/.local/lib/python3.10/site-packages (from investorzilla) (23.9.7)
Requirement already satisfied: pandas>=2 in /usr/local/lib/python3.10/dist-packages (from investorzilla) (2.1.4)
Requirement already satisfied: google-api-python-client in /home/felipe/.local/lib/python3.10/site-packages (from investorzilla) (2.110.0)
Requirement already satisfied: tzdata>=2022.1 in /usr/local/lib/python3.10/dist-packages (from pandas>=2->investorzilla) (2023.3)
Requirement already satisfied: python-dateutil>=2.8.2 in /usr/local/lib/python3.10/dist-packages (from pandas>=2->investorzilla) (2.8.2)
Requirement already satisfied: numpy<2,>=1.22.4 in /usr/local/lib/python3.10/dist-packages (from pandas>=2->investorzilla) (1.26.2)
Requirement already satisfied: pytz>=2020.1 in /usr/lib/python3/dist-packages (from pandas>=2->investorzilla) (2022.1)
Requirement already satisfied: uritemplate<5,>=3.0.1 in /home/felipe/.local/lib/python3.10/site-packages (from google-api-python-client->investorzilla) (4.1.1)
Requirement already satisfied: httplib2<1.dev0,>=0.15.0 in /usr/lib/python3/dist-packages (from google-api-python-client->investorzilla) (0.20.2)
Requirement already satisfied: google-auth<3.0.0.dev0,>=1.19.0 in /home/felipe/.local/lib/python3.10/site-packages (from google-api-python-client->investorzilla) (2.25.2)
Requirement already satisfied: google-api-core!=2.0.*,!=2.1.*,!=2.2.*,!=2.3.0,<3.0.0.dev0,>=1.31.5 in /home/felipe/.local/lib/python3.10/site-packages (from google-api-python-client->investorzilla) (2.15.0)
Requirement already satisfied: requests-oauthlib>=0.7.0 in /home/felipe/.local/lib/python3.10/site-packages (from google-auth-oauthlib->investorzilla) (1.3.1)
Requirement already satisfied: fonttools>=4.22.0 in /home/felipe/.local/lib/python3.10/site-packages (from matplotlib->investorzilla) (4.46.0)
Requirement already satisfied: contourpy>=1.0.1 in /home/felipe/.local/lib/python3.10/site-packages (from matplotlib->investorzilla) (1.2.0)
Requirement already satisfied: cycler>=0.10 in /home/felipe/.local/lib/python3.10/site-packages (from matplotlib->investorzilla) (0.12.1)
Requirement already satisfied: pyparsing>=2.3.1 in /usr/lib/python3/dist-packages (from matplotlib->investorzilla) (2.4.7)
Requirement already satisfied: pillow>=8 in /usr/local/lib/python3.10/dist-packages (from matplotlib->investorzilla) (10.1.0)
Requirement already satisfied: packaging>=20.0 in /usr/local/lib/python3.10/dist-packages (from matplotlib->investorzilla) (23.2)
Requirement already satisfied: kiwisolver>=1.3.1 in /home/felipe/.local/lib/python3.10/site-packages (from matplotlib->investorzilla) (1.4.5)
Requirement already satisfied: requests>=2.19.0 in /usr/local/lib/python3.10/dist-packages (from pandas-datareader->investorzilla) (2.31.0)
Requirement already satisfied: lxml in /home/felipe/.local/lib/python3.10/site-packages (from pandas-datareader->investorzilla) (4.9.3)
Requirement already satisfied: PyYAML in /usr/lib/python3/dist-packages (from pyaml->investorzilla) (5.4.1)
Requirement already satisfied: greenlet!=0.4.17 in /home/felipe/.local/lib/python3.10/site-packages (from sqlalchemy->investorzilla) (3.0.2)
Requirement already satisfied: typing-extensions>=4.2.0 in /usr/local/lib/python3.10/dist-packages (from sqlalchemy->investorzilla) (4.9.0)
Requirement already satisfied: blinker<2,>=1.0.0 in /usr/lib/python3/dist-packages (from streamlit->investorzilla) (1.4)
Requirement already satisfied: pyarrow>=6.0 in /usr/local/lib/python3.10/dist-packages (from streamlit->investorzilla) (14.0.1)
Requirement already satisfied: rich<14,>=10.14.0 in /usr/local/lib/python3.10/dist-packages (from streamlit->investorzilla) (13.7.0)
Requirement already satisfied: tornado<7,>=6.0.3 in /usr/local/lib/python3.10/dist-packages (from streamlit->investorzilla) (6.4)
Requirement already satisfied: watchdog>=2.1.5 in /usr/local/lib/python3.10/dist-packages (from streamlit->investorzilla) (3.0.0)
Requirement already satisfied: importlib-metadata<7,>=1.4 in /usr/lib/python3/dist-packages (from streamlit->investorzilla) (4.6.4)
Requirement already satisfied: tenacity<9,>=8.1.0 in /usr/local/lib/python3.10/dist-packages (from streamlit->investorzilla) (8.2.3)
Requirement already satisfied: click<9,>=7.0 in /usr/lib/python3/dist-packages (from streamlit->investorzilla) (8.0.3)
Requirement already satisfied: cachetools<6,>=4.0 in /usr/local/lib/python3.10/dist-packages (from streamlit->investorzilla) (5.3.2)
Requirement already satisfied: gitpython!=3.1.19,<4,>=3.0.7 in /usr/local/lib/python3.10/dist-packages (from streamlit->investorzilla) (3.1.40)
Requirement already satisfied: altair<6,>=4.0 in /usr/local/lib/python3.10/dist-packages (from streamlit->investorzilla) (5.2.0)
Requirement already satisfied: protobuf<5,>=3.20 in /usr/local/lib/python3.10/dist-packages (from streamlit->investorzilla) (4.25.1)
Requirement already satisfied: validators<1,>=0.2 in /usr/local/lib/python3.10/dist-packages (from streamlit->investorzilla) (0.22.0)
Requirement already satisfied: toml<2,>=0.10.1 in /usr/local/lib/python3.10/dist-packages (from streamlit->investorzilla) (0.10.2)
Requirement already satisfied: tzlocal<6,>=1.1 in /usr/local/lib/python3.10/dist-packages (from streamlit->investorzilla) (5.2)
Requirement already satisfied: pydeck<1,>=0.8.0b4 in /usr/local/lib/python3.10/dist-packages (from streamlit->investorzilla) (0.8.1b0)
Requirement already satisfied: toolz in /usr/local/lib/python3.10/dist-packages (from altair<6,>=4.0->streamlit->investorzilla) (0.12.0)
Requirement already satisfied: jsonschema>=3.0 in /usr/lib/python3/dist-packages (from altair<6,>=4.0->streamlit->investorzilla) (3.2.0)
Requirement already satisfied: jinja2 in /usr/local/lib/python3.10/dist-packages (from altair<6,>=4.0->streamlit->investorzilla) (3.0.0)
Requirement already satisfied: gitdb<5,>=4.0.1 in /usr/local/lib/python3.10/dist-packages (from gitpython!=3.1.19,<4,>=3.0.7->streamlit->investorzilla) (4.0.11)
Requirement already satisfied: googleapis-common-protos<2.0.dev0,>=1.56.2 in /home/felipe/.local/lib/python3.10/site-packages (from google-api-core!=2.0.*,!=2.1.*,!=2.2.*,!=2.3.0,<3.0.0.dev0,>=1.31.5->google-api-python-client->investorzilla) (1.62.0)
Requirement already satisfied: pyasn1-modules>=0.2.1 in /usr/lib/python3/dist-packages (from google-auth<3.0.0.dev0,>=1.19.0->google-api-python-client->investorzilla) (0.2.1)
Requirement already satisfied: rsa<5,>=3.1.4 in /home/felipe/.local/lib/python3.10/site-packages (from google-auth<3.0.0.dev0,>=1.19.0->google-api-python-client->investorzilla) (4.9)
Requirement already satisfied: six>=1.5 in /usr/lib/python3/dist-packages (from python-dateutil>=2.8.2->pandas>=2->investorzilla) (1.16.0)
Requirement already satisfied: urllib3<3,>=1.21.1 in /usr/lib/python3/dist-packages (from requests>=2.19.0->pandas-datareader->investorzilla) (1.26.5)
Requirement already satisfied: charset-normalizer<4,>=2 in /usr/local/lib/python3.10/dist-packages (from requests>=2.19.0->pandas-datareader->investorzilla) (3.3.2)
Requirement already satisfied: idna<4,>=2.5 in /usr/lib/python3/dist-packages (from requests>=2.19.0->pandas-datareader->investorzilla) (3.3)
Requirement already satisfied: oauthlib>=3.0.0 in /usr/lib/python3/dist-packages (from requests-oauthlib>=0.7.0->google-auth-oauthlib->investorzilla) (3.2.0)
Requirement already satisfied: pygments<3.0.0,>=2.13.0 in /usr/local/lib/python3.10/dist-packages (from rich<14,>=10.14.0->streamlit->investorzilla) (2.17.2)
Requirement already satisfied: markdown-it-py>=2.2.0 in /usr/local/lib/python3.10/dist-packages (from rich<14,>=10.14.0->streamlit->investorzilla) (3.0.0)
Requirement already satisfied: smmap<6,>=3.0.1 in /usr/local/lib/python3.10/dist-packages (from gitdb<5,>=4.0.1->gitpython!=3.1.19,<4,>=3.0.7->streamlit->investorzilla) (5.0.1)
Requirement already satisfied: MarkupSafe>=2.0.0rc2 in /usr/lib/python3/dist-packages (from jinja2->altair<6,>=4.0->streamlit->investorzilla) (2.0.1)
Requirement already satisfied: mdurl~=0.1 in /usr/local/lib/python3.10/dist-packages (from markdown-it-py>=2.2.0->rich<14,>=10.14.0->streamlit->investorzilla) (0.1.2)
Requirement already satisfied: pyasn1>=0.1.3 in /usr/lib/python3/dist-packages (from rsa<5,>=3.1.4->google-auth<3.0.0.dev0,>=1.19.0->google-api-python-client->investorzilla) (0.4.8)
felipe@template:~/investorzilla/myportfolio$ investorzilla
investorzilla: command not found
felipe@template:~/investorzilla/myportfolio$ sudo investorzilla
sudo: investorzilla: command not found
felipe@template:~/investorzilla/myportfolio$ ls
investorzilla.yaml
felipe@template:~/investorzilla/myportfolio$ pip install investorzilla --user
Requirement already satisfied: investorzilla in /home/felipe/.local/lib/python3.10/site-packages (2.4.1)
Requirement already satisfied: pandas>=2 in /usr/local/lib/python3.10/dist-packages (from investorzilla) (2.1.4)
Requirement already satisfied: pyaml in /home/felipe/.local/lib/python3.10/site-packages (from investorzilla) (23.9.7)
Requirement already satisfied: sqlalchemy in /home/felipe/.local/lib/python3.10/site-packages (from investorzilla) (2.0.23)
Requirement already satisfied: streamlit in /usr/local/lib/python3.10/dist-packages (from investorzilla) (1.29.0)
Requirement already satisfied: google-auth-oauthlib in /home/felipe/.local/lib/python3.10/site-packages (from investorzilla) (1.1.0)
Requirement already satisfied: certifi in /usr/lib/python3/dist-packages (from investorzilla) (2020.6.20)
Requirement already satisfied: pandas-datareader in /home/felipe/.local/lib/python3.10/site-packages (from investorzilla) (0.10.0)
Requirement already satisfied: matplotlib in /home/felipe/.local/lib/python3.10/site-packages (from investorzilla) (3.8.2)
Requirement already satisfied: google-auth-httplib2 in /home/felipe/.local/lib/python3.10/site-packages (from investorzilla) (0.1.1)
Requirement already satisfied: google-api-python-client in /home/felipe/.local/lib/python3.10/site-packages (from investorzilla) (2.110.0)
Requirement already satisfied: pytz>=2020.1 in /usr/lib/python3/dist-packages (from pandas>=2->investorzilla) (2022.1)
Requirement already satisfied: tzdata>=2022.1 in /usr/local/lib/python3.10/dist-packages (from pandas>=2->investorzilla) (2023.3)
Requirement already satisfied: numpy<2,>=1.22.4 in /usr/local/lib/python3.10/dist-packages (from pandas>=2->investorzilla) (1.26.2)
Requirement already satisfied: python-dateutil>=2.8.2 in /usr/local/lib/python3.10/dist-packages (from pandas>=2->investorzilla) (2.8.2)
Requirement already satisfied: google-api-core!=2.0.*,!=2.1.*,!=2.2.*,!=2.3.0,<3.0.0.dev0,>=1.31.5 in /home/felipe/.local/lib/python3.10/site-packages (from google-api-python-client->investorzilla) (2.15.0)
Requirement already satisfied: httplib2<1.dev0,>=0.15.0 in /usr/lib/python3/dist-packages (from google-api-python-client->investorzilla) (0.20.2)
Requirement already satisfied: uritemplate<5,>=3.0.1 in /home/felipe/.local/lib/python3.10/site-packages (from google-api-python-client->investorzilla) (4.1.1)
Requirement already satisfied: google-auth<3.0.0.dev0,>=1.19.0 in /home/felipe/.local/lib/python3.10/site-packages (from google-api-python-client->investorzilla) (2.25.2)
Requirement already satisfied: requests-oauthlib>=0.7.0 in /home/felipe/.local/lib/python3.10/site-packages (from google-auth-oauthlib->investorzilla) (1.3.1)
Requirement already satisfied: cycler>=0.10 in /home/felipe/.local/lib/python3.10/site-packages (from matplotlib->investorzilla) (0.12.1)
Requirement already satisfied: pillow>=8 in /usr/local/lib/python3.10/dist-packages (from matplotlib->investorzilla) (10.1.0)
Requirement already satisfied: packaging>=20.0 in /usr/local/lib/python3.10/dist-packages (from matplotlib->investorzilla) (23.2)
Requirement already satisfied: kiwisolver>=1.3.1 in /home/felipe/.local/lib/python3.10/site-packages (from matplotlib->investorzilla) (1.4.5)
Requirement already satisfied: pyparsing>=2.3.1 in /usr/lib/python3/dist-packages (from matplotlib->investorzilla) (2.4.7)
Requirement already satisfied: contourpy>=1.0.1 in /home/felipe/.local/lib/python3.10/site-packages (from matplotlib->investorzilla) (1.2.0)
Requirement already satisfied: fonttools>=4.22.0 in /home/felipe/.local/lib/python3.10/site-packages (from matplotlib->investorzilla) (4.46.0)
Requirement already satisfied: requests>=2.19.0 in /usr/local/lib/python3.10/dist-packages (from pandas-datareader->investorzilla) (2.31.0)
Requirement already satisfied: lxml in /home/felipe/.local/lib/python3.10/site-packages (from pandas-datareader->investorzilla) (4.9.3)
Requirement already satisfied: PyYAML in /usr/lib/python3/dist-packages (from pyaml->investorzilla) (5.4.1)
Requirement already satisfied: greenlet!=0.4.17 in /home/felipe/.local/lib/python3.10/site-packages (from sqlalchemy->investorzilla) (3.0.2)
Requirement already satisfied: typing-extensions>=4.2.0 in /usr/local/lib/python3.10/dist-packages (from sqlalchemy->investorzilla) (4.9.0)
Requirement already satisfied: click<9,>=7.0 in /usr/lib/python3/dist-packages (from streamlit->investorzilla) (8.0.3)
Requirement already satisfied: protobuf<5,>=3.20 in /usr/local/lib/python3.10/dist-packages (from streamlit->investorzilla) (4.25.1)
Requirement already satisfied: tornado<7,>=6.0.3 in /usr/local/lib/python3.10/dist-packages (from streamlit->investorzilla) (6.4)
Requirement already satisfied: toml<2,>=0.10.1 in /usr/local/lib/python3.10/dist-packages (from streamlit->investorzilla) (0.10.2)
Requirement already satisfied: blinker<2,>=1.0.0 in /usr/lib/python3/dist-packages (from streamlit->investorzilla) (1.4)
Requirement already satisfied: validators<1,>=0.2 in /usr/local/lib/python3.10/dist-packages (from streamlit->investorzilla) (0.22.0)
Requirement already satisfied: cachetools<6,>=4.0 in /usr/local/lib/python3.10/dist-packages (from streamlit->investorzilla) (5.3.2)
Requirement already satisfied: tzlocal<6,>=1.1 in /usr/local/lib/python3.10/dist-packages (from streamlit->investorzilla) (5.2)
Requirement already satisfied: tenacity<9,>=8.1.0 in /usr/local/lib/python3.10/dist-packages (from streamlit->investorzilla) (8.2.3)
Requirement already satisfied: gitpython!=3.1.19,<4,>=3.0.7 in /usr/local/lib/python3.10/dist-packages (from streamlit->investorzilla) (3.1.40)
Requirement already satisfied: watchdog>=2.1.5 in /usr/local/lib/python3.10/dist-packages (from streamlit->investorzilla) (3.0.0)
Requirement already satisfied: rich<14,>=10.14.0 in /usr/local/lib/python3.10/dist-packages (from streamlit->investorzilla) (13.7.0)
Requirement already satisfied: pydeck<1,>=0.8.0b4 in /usr/local/lib/python3.10/dist-packages (from streamlit->investorzilla) (0.8.1b0)
Requirement already satisfied: altair<6,>=4.0 in /usr/local/lib/python3.10/dist-packages (from streamlit->investorzilla) (5.2.0)
Requirement already satisfied: importlib-metadata<7,>=1.4 in /usr/lib/python3/dist-packages (from streamlit->investorzilla) (4.6.4)
Requirement already satisfied: pyarrow>=6.0 in /usr/local/lib/python3.10/dist-packages (from streamlit->investorzilla) (14.0.1)
Requirement already satisfied: jsonschema>=3.0 in /usr/lib/python3/dist-packages (from altair<6,>=4.0->streamlit->investorzilla) (3.2.0)
Requirement already satisfied: toolz in /usr/local/lib/python3.10/dist-packages (from altair<6,>=4.0->streamlit->investorzilla) (0.12.0)
Requirement already satisfied: jinja2 in /usr/local/lib/python3.10/dist-packages (from altair<6,>=4.0->streamlit->investorzilla) (3.0.0)
Requirement already satisfied: gitdb<5,>=4.0.1 in /usr/local/lib/python3.10/dist-packages (from gitpython!=3.1.19,<4,>=3.0.7->streamlit->investorzilla) (4.0.11)
Requirement already satisfied: googleapis-common-protos<2.0.dev0,>=1.56.2 in /home/felipe/.local/lib/python3.10/site-packages (from google-api-core!=2.0.*,!=2.1.*,!=2.2.*,!=2.3.0,<3.0.0.dev0,>=1.31.5->google-api-python-client->investorzilla) (1.62.0)
Requirement already satisfied: rsa<5,>=3.1.4 in /home/felipe/.local/lib/python3.10/site-packages (from google-auth<3.0.0.dev0,>=1.19.0->google-api-python-client->investorzilla) (4.9)
Requirement already satisfied: pyasn1-modules>=0.2.1 in /usr/lib/python3/dist-packages (from google-auth<3.0.0.dev0,>=1.19.0->google-api-python-client->investorzilla) (0.2.1)
Requirement already satisfied: six>=1.5 in /usr/lib/python3/dist-packages (from python-dateutil>=2.8.2->pandas>=2->investorzilla) (1.16.0)
Requirement already satisfied: charset-normalizer<4,>=2 in /usr/local/lib/python3.10/dist-packages (from requests>=2.19.0->pandas-datareader->investorzilla) (3.3.2)
Requirement already satisfied: idna<4,>=2.5 in /usr/lib/python3/dist-packages (from requests>=2.19.0->pandas-datareader->investorzilla) (3.3)
Requirement already satisfied: urllib3<3,>=1.21.1 in /usr/lib/python3/dist-packages (from requests>=2.19.0->pandas-datareader->investorzilla) (1.26.5)
Requirement already satisfied: oauthlib>=3.0.0 in /usr/lib/python3/dist-packages (from requests-oauthlib>=0.7.0->google-auth-oauthlib->investorzilla) (3.2.0)
Requirement already satisfied: markdown-it-py>=2.2.0 in /usr/local/lib/python3.10/dist-packages (from rich<14,>=10.14.0->streamlit->investorzilla) (3.0.0)
Requirement already satisfied: pygments<3.0.0,>=2.13.0 in /usr/local/lib/python3.10/dist-packages (from rich<14,>=10.14.0->streamlit->investorzilla) (2.17.2)
Requirement already satisfied: smmap<6,>=3.0.1 in /usr/local/lib/python3.10/dist-packages (from gitdb<5,>=4.0.1->gitpython!=3.1.19,<4,>=3.0.7->streamlit->investorzilla) (5.0.1)
Requirement already satisfied: MarkupSafe>=2.0.0rc2 in /usr/lib/python3/dist-packages (from jinja2->altair<6,>=4.0->streamlit->investorzilla) (2.0.1)
Requirement already satisfied: mdurl~=0.1 in /usr/local/lib/python3.10/dist-packages (from markdown-it-py>=2.2.0->rich<14,>=10.14.0->streamlit->investorzilla) (0.1.2)
Requirement already satisfied: pyasn1>=0.1.3 in /usr/lib/python3/dist-packages (from rsa<5,>=3.1.4->google-auth<3.0.0.dev0,>=1.19.0->google-api-python-client->investorzilla) (0.4.8)
felipe@template:~/investorzilla/myportfolio$ investorzilla
investorzilla: command not found
felipe@template:~/investorzilla/myportfolio$ cd
felipe@template:~$ ls
investorzilla
felipe@template:~$ rm -r investorzilla/
rm: remove write-protected regular file 'investorzilla/.git/objects/pack/pack-5ba46a1ec0a910979626a70639a39c9a59ac6d0d.idx'? n
rm: remove write-protected regular file 'investorzilla/.git/objects/pack/pack-5ba46a1ec0a910979626a70639a39c9a59ac6d0d.pack'? ^C
felipe@template:~$ rm -r investorzilla
rm: remove write-protected regular file 'investorzilla/.git/objects/pack/pack-5ba46a1ec0a910979626a70639a39c9a59ac6d0d.idx'? ^C
felipe@template:~$ sudo rm -r investorzilla
felipe@template:~$ sudo apt install python3.10-venv
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
python3.10-venv is already the newest version (3.10.12-1~22.04.3).
The following packages were automatically installed and are no longer required:
libflashrom1 libftdi1-2
Use 'sudo apt autoremove' to remove them.
0 upgraded, 0 newly installed, 0 to remove and 2 not upgraded.
felipe@template:~$ y
y: command not found
felipe@template:~$ sudo apt install python3.10-venv
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
python3.10-venv is already the newest version (3.10.12-1~22.04.3).
The following packages were automatically installed and are no longer required:
libflashrom1 libftdi1-2
Use 'sudo apt autoremove' to remove them.
0 upgraded, 0 newly installed, 0 to remove and 2 not upgraded.
felipe@template:~$ git clone https://github.com/avibrazil/investorzilla
Cloning into 'investorzilla'...
remote: Enumerating objects: 704, done.
remote: Counting objects: 100% (704/704), done.
remote: Compressing objects: 100% (337/337), done.
remote: Total 704 (delta 467), reused 577 (delta 344), pack-reused 0
Receiving objects: 100% (704/704), 3.22 MiB | 6.04 MiB/s, done.
Resolving deltas: 100% (467/467), done.
felipe@template:~$ cd investorzilla/
felipe@template:~/investorzilla$ python3 -m venv env
felipe@template:~/investorzilla$ source env/bin/activate
(env) felipe@template:~/investorzilla$ pip3 install investorzilla --user
ERROR: Can not perform a '--user' install. User site-packages are not visible in this virtualenv.
(env) felipe@template:~/investorzilla$ pip3 install investorzilla
Collecting investorzilla
Using cached investorzilla-2.4.1-py3-none-any.whl (72 kB)
Collecting certifi
Downloading certifi-2023.11.17-py3-none-any.whl (162 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 162.5/162.5 KB 1.6 MB/s eta 0:00:00
Collecting google-api-python-client
Using cached google_api_python_client-2.110.0-py2.py3-none-any.whl (12.9 MB)
Collecting pandas-datareader
Using cached pandas_datareader-0.10.0-py3-none-any.whl (109 kB)
Collecting pandas>=2
Downloading pandas-2.1.4-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (12.3 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 12.3/12.3 MB 21.3 MB/s eta 0:00:00
Collecting matplotlib
Using cached matplotlib-3.8.2-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (11.6 MB)
Collecting sqlalchemy
Using cached SQLAlchemy-2.0.23-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (3.0 MB)
Collecting google-auth-oauthlib
Using cached google_auth_oauthlib-1.1.0-py2.py3-none-any.whl (19 kB)
Collecting streamlit
Downloading streamlit-1.29.0-py2.py3-none-any.whl (8.4 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 8.4/8.4 MB 18.2 MB/s eta 0:00:00
Collecting google-auth-httplib2
Using cached google_auth_httplib2-0.1.1-py2.py3-none-any.whl (9.3 kB)
Collecting pyaml
Using cached pyaml-23.9.7-py3-none-any.whl (23 kB)
Collecting pytz>=2020.1
Downloading pytz-2023.3.post1-py2.py3-none-any.whl (502 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 502.5/502.5 KB 22.1 MB/s eta 0:00:00
Collecting numpy<2,>=1.22.4
Downloading numpy-1.26.2-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (18.2 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 18.2/18.2 MB 11.6 MB/s eta 0:00:00
Collecting python-dateutil>=2.8.2
Downloading python_dateutil-2.8.2-py2.py3-none-any.whl (247 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 247.7/247.7 KB 19.5 MB/s eta 0:00:00
Collecting tzdata>=2022.1
Downloading tzdata-2023.3-py2.py3-none-any.whl (341 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 341.8/341.8 KB 19.7 MB/s eta 0:00:00
Collecting httplib2<1.dev0,>=0.15.0
Downloading httplib2-0.22.0-py3-none-any.whl (96 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 96.9/96.9 KB 20.3 MB/s eta 0:00:00
Collecting google-api-core!=2.0.*,!=2.1.*,!=2.2.*,!=2.3.0,<3.0.0.dev0,>=1.31.5
Using cached google_api_core-2.15.0-py3-none-any.whl (121 kB)
Collecting uritemplate<5,>=3.0.1
Using cached uritemplate-4.1.1-py2.py3-none-any.whl (10 kB)
Collecting google-auth<3.0.0.dev0,>=1.19.0
Using cached google_auth-2.25.2-py2.py3-none-any.whl (184 kB)
Collecting requests-oauthlib>=0.7.0
Using cached requests_oauthlib-1.3.1-py2.py3-none-any.whl (23 kB)
Collecting contourpy>=1.0.1
Using cached contourpy-1.2.0-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (310 kB)
Collecting fonttools>=4.22.0
Using cached fonttools-4.46.0-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (4.6 MB)
Collecting cycler>=0.10
Using cached cycler-0.12.1-py3-none-any.whl (8.3 kB)
Collecting packaging>=20.0
Downloading packaging-23.2-py3-none-any.whl (53 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 53.0/53.0 KB 12.6 MB/s eta 0:00:00
Collecting pillow>=8
Downloading Pillow-10.1.0-cp310-cp310-manylinux_2_28_x86_64.whl (3.6 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 3.6/3.6 MB 13.2 MB/s eta 0:00:00
Collecting kiwisolver>=1.3.1
Using cached kiwisolver-1.4.5-cp310-cp310-manylinux_2_12_x86_64.manylinux2010_x86_64.whl (1.6 MB)
Collecting pyparsing>=2.3.1
Downloading pyparsing-3.1.1-py3-none-any.whl (103 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 103.1/103.1 KB 19.0 MB/s eta 0:00:00
Collecting lxml
Using cached lxml-4.9.3-cp310-cp310-manylinux_2_28_x86_64.whl (7.9 MB)
Collecting requests>=2.19.0
Downloading requests-2.31.0-py3-none-any.whl (62 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 62.6/62.6 KB 8.0 MB/s eta 0:00:00
Collecting PyYAML
Downloading PyYAML-6.0.1-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (705 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 705.5/705.5 KB 8.4 MB/s eta 0:00:00
Collecting typing-extensions>=4.2.0
Downloading typing_extensions-4.9.0-py3-none-any.whl (32 kB)
Collecting greenlet!=0.4.17
Using cached greenlet-3.0.2-cp310-cp310-manylinux_2_24_x86_64.manylinux_2_28_x86_64.whl (613 kB)
Collecting tenacity<9,>=8.1.0
Downloading tenacity-8.2.3-py3-none-any.whl (24 kB)
Collecting tornado<7,>=6.0.3
Downloading tornado-6.4-cp38-abi3-manylinux_2_5_x86_64.manylinux1_x86_64.manylinux_2_17_x86_64.manylinux2014_x86_64.whl (435 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 435.4/435.4 KB 9.8 MB/s eta 0:00:00
Collecting gitpython!=3.1.19,<4,>=3.0.7
Downloading GitPython-3.1.40-py3-none-any.whl (190 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 190.6/190.6 KB 17.4 MB/s eta 0:00:00
Collecting rich<14,>=10.14.0
Downloading rich-13.7.0-py3-none-any.whl (240 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 240.6/240.6 KB 24.1 MB/s eta 0:00:00
Collecting cachetools<6,>=4.0
Downloading cachetools-5.3.2-py3-none-any.whl (9.3 kB)
Collecting blinker<2,>=1.0.0
Downloading blinker-1.7.0-py3-none-any.whl (13 kB)
Collecting watchdog>=2.1.5
Downloading watchdog-3.0.0-py3-none-manylinux2014_x86_64.whl (82 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 82.1/82.1 KB 8.5 MB/s eta 0:00:00
Collecting altair<6,>=4.0
Downloading altair-5.2.0-py3-none-any.whl (996 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 996.9/996.9 KB 11.1 MB/s eta 0:00:00
Collecting importlib-metadata<7,>=1.4
Downloading importlib_metadata-6.11.0-py3-none-any.whl (23 kB)
Collecting validators<1,>=0.2
Downloading validators-0.22.0-py3-none-any.whl (26 kB)
Collecting toml<2,>=0.10.1
Downloading toml-0.10.2-py2.py3-none-any.whl (16 kB)
Collecting pydeck<1,>=0.8.0b4
Downloading pydeck-0.8.1b0-py2.py3-none-any.whl (4.8 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 4.8/4.8 MB 10.8 MB/s eta 0:00:00
Collecting protobuf<5,>=3.20
Downloading protobuf-4.25.1-cp37-abi3-manylinux2014_x86_64.whl (294 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 294.6/294.6 KB 16.7 MB/s eta 0:00:00
Collecting click<9,>=7.0
Downloading click-8.1.7-py3-none-any.whl (97 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 97.9/97.9 KB 14.4 MB/s eta 0:00:00
Collecting tzlocal<6,>=1.1
Downloading tzlocal-5.2-py3-none-any.whl (17 kB)
Collecting pyarrow>=6.0
Downloading pyarrow-14.0.1-cp310-cp310-manylinux_2_28_x86_64.whl (38.0 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 38.0/38.0 MB 10.3 MB/s eta 0:00:00
Collecting jsonschema>=3.0
Downloading jsonschema-4.20.0-py3-none-any.whl (84 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 84.7/84.7 KB 14.8 MB/s eta 0:00:00
Collecting jinja2
Downloading Jinja2-3.1.2-py3-none-any.whl (133 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 133.1/133.1 KB 14.5 MB/s eta 0:00:00
Collecting toolz
Downloading toolz-0.12.0-py3-none-any.whl (55 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 55.8/55.8 KB 13.6 MB/s eta 0:00:00
Collecting gitdb<5,>=4.0.1
Downloading gitdb-4.0.11-py3-none-any.whl (62 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 62.7/62.7 KB 8.5 MB/s eta 0:00:00
Collecting googleapis-common-protos<2.0.dev0,>=1.56.2
Using cached googleapis_common_protos-1.62.0-py2.py3-none-any.whl (228 kB)
Collecting pyasn1-modules>=0.2.1
Downloading pyasn1_modules-0.3.0-py2.py3-none-any.whl (181 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 181.3/181.3 KB 15.4 MB/s eta 0:00:00
Collecting rsa<5,>=3.1.4
Using cached rsa-4.9-py3-none-any.whl (34 kB)
Collecting zipp>=0.5
Downloading zipp-3.17.0-py3-none-any.whl (7.4 kB)
Collecting six>=1.5
Downloading six-1.16.0-py2.py3-none-any.whl (11 kB)
Collecting idna<4,>=2.5
Downloading idna-3.6-py3-none-any.whl (61 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 61.6/61.6 KB 16.1 MB/s eta 0:00:00
Collecting charset-normalizer<4,>=2
Downloading charset_normalizer-3.3.2-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (142 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 142.1/142.1 KB 15.0 MB/s eta 0:00:00
Collecting urllib3<3,>=1.21.1
Downloading urllib3-2.1.0-py3-none-any.whl (104 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 104.6/104.6 KB 15.5 MB/s eta 0:00:00
Collecting oauthlib>=3.0.0
Downloading oauthlib-3.2.2-py3-none-any.whl (151 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 151.7/151.7 KB 11.8 MB/s eta 0:00:00
Collecting pygments<3.0.0,>=2.13.0
Downloading pygments-2.17.2-py3-none-any.whl (1.2 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 1.2/1.2 MB 13.1 MB/s eta 0:00:00
Collecting markdown-it-py>=2.2.0
Downloading markdown_it_py-3.0.0-py3-none-any.whl (87 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 87.5/87.5 KB 12.9 MB/s eta 0:00:00
Collecting smmap<6,>=3.0.1
Downloading smmap-5.0.1-py3-none-any.whl (24 kB)
Collecting MarkupSafe>=2.0
Downloading MarkupSafe-2.1.3-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (25 kB)
Collecting rpds-py>=0.7.1
Downloading rpds_py-0.13.2-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (1.2 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 1.2/1.2 MB 13.6 MB/s eta 0:00:00
Collecting jsonschema-specifications>=2023.03.6
Downloading jsonschema_specifications-2023.11.2-py3-none-any.whl (17 kB)
Collecting referencing>=0.28.4
Downloading referencing-0.32.0-py3-none-any.whl (26 kB)
Collecting attrs>=22.2.0
Downloading attrs-23.1.0-py3-none-any.whl (61 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 61.2/61.2 KB 13.0 MB/s eta 0:00:00
Collecting mdurl~=0.1
Downloading mdurl-0.1.2-py3-none-any.whl (10.0 kB)
Collecting pyasn1<0.6.0,>=0.4.6
Downloading pyasn1-0.5.1-py2.py3-none-any.whl (84 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 84.9/84.9 KB 11.3 MB/s eta 0:00:00
Installing collected packages: pytz, zipp, watchdog, validators, urllib3, uritemplate, tzlocal, tzdata, typing-extensions, tornado, toolz, toml, tenacity, smmap, six, rpds-py, PyYAML, pyparsing, pygments, pyasn1, protobuf, pillow, packaging, oauthlib, numpy, mdurl, MarkupSafe, lxml, kiwisolver, idna, greenlet, fonttools, cycler, click, charset-normalizer, certifi, cachetools, blinker, attrs, sqlalchemy, rsa, requests, referencing, python-dateutil, pyasn1-modules, pyarrow, pyaml, markdown-it-py, jinja2, importlib-metadata, httplib2, googleapis-common-protos, gitdb, contourpy, rich, requests-oauthlib, pydeck, pandas, matplotlib, jsonschema-specifications, google-auth, gitpython, pandas-datareader, jsonschema, google-auth-oauthlib, google-auth-httplib2, google-api-core, google-api-python-client, altair, streamlit, investorzilla
Successfully installed MarkupSafe-2.1.3 PyYAML-6.0.1 altair-5.2.0 attrs-23.1.0 blinker-1.7.0 cachetools-5.3.2 certifi-2023.11.17 charset-normalizer-3.3.2 click-8.1.7 contourpy-1.2.0 cycler-0.12.1 fonttools-4.46.0 gitdb-4.0.11 gitpython-3.1.40 google-api-core-2.15.0 google-api-python-client-2.110.0 google-auth-2.25.2 google-auth-httplib2-0.1.1 google-auth-oauthlib-1.1.0 googleapis-common-protos-1.62.0 greenlet-3.0.2 httplib2-0.22.0 idna-3.6 importlib-metadata-6.11.0 investorzilla-2.4.1 jinja2-3.1.2 jsonschema-4.20.0 jsonschema-specifications-2023.11.2 kiwisolver-1.4.5 lxml-4.9.3 markdown-it-py-3.0.0 matplotlib-3.8.2 mdurl-0.1.2 numpy-1.26.2 oauthlib-3.2.2 packaging-23.2 pandas-2.1.4 pandas-datareader-0.10.0 pillow-10.1.0 protobuf-4.25.1 pyaml-23.9.7 pyarrow-14.0.1 pyasn1-0.5.1 pyasn1-modules-0.3.0 pydeck-0.8.1b0 pygments-2.17.2 pyparsing-3.1.1 python-dateutil-2.8.2 pytz-2023.3.post1 referencing-0.32.0 requests-2.31.0 requests-oauthlib-1.3.1 rich-13.7.0 rpds-py-0.13.2 rsa-4.9 six-1.16.0 smmap-5.0.1 sqlalchemy-2.0.23 streamlit-1.29.0 tenacity-8.2.3 toml-0.10.2 toolz-0.12.0 tornado-6.4 typing-extensions-4.9.0 tzdata-2023.3 tzlocal-5.2 uritemplate-4.1.1 urllib3-2.1.0 validators-0.22.0 watchdog-3.0.0 zipp-3.17.0
(env) felipe@template:~/investorzilla$ mkdir myportfolio
(env) felipe@template:~/investorzilla$ cp /home/felipe/investorzilla/config_examples/investorzilla.yaml /home/felipe/investorzilla/myportfolio/investorzilla.yaml
(env) felipe@template:~/investorzilla$ cd myportfolio
(env) felipe@template:~/investorzilla/myportfolio$ ls
investorzilla.yaml
(env) felipe@template:~/investorzilla/myportfolio$ investorzilla
Collecting usage statistics. To deactivate, set browser.gatherUsageStats to False.
You can now view your Streamlit app in your browser.
Network URL: http://192.168.20.14:8501
External URL: http://181.51.32.154:8501
2023-12-12 14:08:30,038|INFO|investorzilla.datacache.DataCache|No cache for kind=BCBCurrencyConverter and id=USD
2023-12-12 14:08:30,039|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__BCBCurrencyConverter
[SQL:
SELECT *
FROM DataCache__BCBCurrencyConverter
WHERE
__DataCache_id = 'USD' AND
__DataCache_time =
(
SELECT DISTINCT __DataCache_time
FROM DataCache__BCBCurrencyConverter
WHERE __DataCache_id = 'USD'
ORDER BY __DataCache_time DESC
LIMIT 1
)
]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-12 14:08:30,041|INFO|investorzilla.datacache.DataCache|No cache for kind=BCBCurrencyConverter and id=EUR
2023-12-12 14:08:30,048|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__BCBCurrencyConverter
[SQL:
SELECT *
FROM DataCache__BCBCurrencyConverter
WHERE
__DataCache_id = 'EUR' AND
__DataCache_time =
(
SELECT DISTINCT __DataCache_time
FROM DataCache__BCBCurrencyConverter
WHERE __DataCache_id = 'EUR'
ORDER BY __DataCache_time DESC
LIMIT 1
)
]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-12 14:08:30,043|INFO|investorzilla.datacache.DataCache|No cache for kind=uri•portfolio_ledger__ledger and id=https://docs.google.com/spreadsheets/d/e/2PACX-1vQKyVROH752oeB0s8codNps5jdZu-ngdam2Lc8SkTlLqPbbiGdn9_O1Q8y6H02kOSp9dBW_v_kPmNdc/pub?gid=476533794&single=true&output=tsv
2023-12-12 14:08:30,051|INFO|investorzilla.datacache.DataCache|No cache for kind=uri•portfolio_balance__ledger and id=https://docs.google.com/spreadsheets/d/e/2PACX-1vQKyVROH752oeB0s8codNps5jdZu-ngdam2Lc8SkTlLqPbbiGdn9_O1Q8y6H02kOSp9dBW_v_kPmNdc/pub?gid=985882980&single=true&output=tsv
2023-12-12 14:08:30,051|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__uri•portfolio_ledger__ledger
[SQL:
SELECT *
FROM DataCache__uri•portfolio_ledger__ledger
WHERE
__DataCache_id = 'https://docs.google.com/spreadsheets/d/e/2PACX-1vQKyVROH752oeB0s8codNps5jdZu-ngdam2Lc8SkTlLqPbbiGdn9_O1Q8y6H02kOSp9dBW_v_kPmNdc/pub?gid=476533794&single=true&output=tsv' AND
__DataCache_time =
(
SELECT DISTINCT __DataCache_time
FROM DataCache__uri•portfolio_ledger__ledger
WHERE __DataCache_id = 'https://docs.google.com/spreadsheets/d/e/2PACX-1vQKyVROH752oeB0s8codNps5jdZu-ngdam2Lc8SkTlLqPbbiGdn9_O1Q8y6H02kOSp9dBW_v_kPmNdc/pub?gid=476533794&single=true&output=tsv'
ORDER BY __DataCache_time DESC
LIMIT 1
)
]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-12 14:08:30,052|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__uri•portfolio_balance__ledger
[SQL:
SELECT *
FROM DataCache__uri•portfolio_balance__ledger
WHERE
__DataCache_id = 'https://docs.google.com/spreadsheets/d/e/2PACX-1vQKyVROH752oeB0s8codNps5jdZu-ngdam2Lc8SkTlLqPbbiGdn9_O1Q8y6H02kOSp9dBW_v_kPmNdc/pub?gid=985882980&single=true&output=tsv' AND
__DataCache_time =
(
SELECT DISTINCT __DataCache_time
FROM DataCache__uri•portfolio_balance__ledger
WHERE __DataCache_id = 'https://docs.google.com/spreadsheets/d/e/2PACX-1vQKyVROH752oeB0s8codNps5jdZu-ngdam2Lc8SkTlLqPbbiGdn9_O1Q8y6H02kOSp9dBW_v_kPmNdc/pub?gid=985882980&single=true&output=tsv'
ORDER BY __DataCache_time DESC
LIMIT 1
)
]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-12 14:08:30,053|INFO|investorzilla.datacache.DataCache|No cache for kind=BCBMarketIndex and id=IPCA
2023-12-12 14:08:30,054|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__BCBMarketIndex
[SQL:
SELECT *
FROM DataCache__BCBMarketIndex
WHERE
__DataCache_id = 'IPCA' AND
__DataCache_time =
(
SELECT DISTINCT __DataCache_time
FROM DataCache__BCBMarketIndex
WHERE __DataCache_id = 'IPCA'
ORDER BY __DataCache_time DESC
LIMIT 1
)
]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-12 14:08:30,057|INFO|investorzilla.datacache.DataCache|No cache for kind=uri•portfolio_balance__balance and id=https://docs.google.com/spreadsheets/d/e/2PACX-1vQKyVROH752oeB0s8codNps5jdZu-ngdam2Lc8SkTlLqPbbiGdn9_O1Q8y6H02kOSp9dBW_v_kPmNdc/pub?gid=985882980&single=true&output=tsv
2023-12-12 14:08:30,057|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__uri•portfolio_balance__balance
[SQL:
SELECT *
FROM DataCache__uri•portfolio_balance__balance
WHERE
__DataCache_id = 'https://docs.google.com/spreadsheets/d/e/2PACX-1vQKyVROH752oeB0s8codNps5jdZu-ngdam2Lc8SkTlLqPbbiGdn9_O1Q8y6H02kOSp9dBW_v_kPmNdc/pub?gid=985882980&single=true&output=tsv' AND
__DataCache_time =
(
SELECT DISTINCT __DataCache_time
FROM DataCache__uri•portfolio_balance__balance
WHERE __DataCache_id = 'https://docs.google.com/spreadsheets/d/e/2PACX-1vQKyVROH752oeB0s8codNps5jdZu-ngdam2Lc8SkTlLqPbbiGdn9_O1Q8y6H02kOSp9dBW_v_kPmNdc/pub?gid=985882980&single=true&output=tsv'
ORDER BY __DataCache_time DESC
LIMIT 1
)
]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-12 14:08:30,061|INFO|investorzilla.datacache.DataCache|No cache for kind=BCBMarketIndex and id=SELIC
2023-12-12 14:08:30,062|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__BCBMarketIndex
[SQL:
SELECT *
FROM DataCache__BCBMarketIndex
WHERE
__DataCache_id = 'SELIC' AND
__DataCache_time =
(
SELECT DISTINCT __DataCache_time
FROM DataCache__BCBMarketIndex
WHERE __DataCache_id = 'SELIC'
ORDER BY __DataCache_time DESC
LIMIT 1
)
]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-12 14:08:30,062|INFO|investorzilla.datacache.DataCache|No cache for kind=BCBMarketIndex and id=IGPM
2023-12-12 14:08:30,064|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__BCBMarketIndex
[SQL:
SELECT *
FROM DataCache__BCBMarketIndex
WHERE
__DataCache_id = 'IGPM' AND
__DataCache_time =
(
SELECT DISTINCT __DataCache_time
FROM DataCache__BCBMarketIndex
WHERE __DataCache_id = 'IGPM'
ORDER BY __DataCache_time DESC
LIMIT 1
)
]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-12 14:08:30,067|INFO|investorzilla.datacache.DataCache|No cache for kind=uri•portfolio_ledger__balance and id=https://docs.google.com/spreadsheets/d/e/2PACX-1vQKyVROH752oeB0s8codNps5jdZu-ngdam2Lc8SkTlLqPbbiGdn9_O1Q8y6H02kOSp9dBW_v_kPmNdc/pub?gid=476533794&single=true&output=tsv
2023-12-12 14:08:30,067|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__uri•portfolio_ledger__balance
[SQL:
SELECT *
FROM DataCache__uri•portfolio_ledger__balance
WHERE
__DataCache_id = 'https://docs.google.com/spreadsheets/d/e/2PACX-1vQKyVROH752oeB0s8codNps5jdZu-ngdam2Lc8SkTlLqPbbiGdn9_O1Q8y6H02kOSp9dBW_v_kPmNdc/pub?gid=476533794&single=true&output=tsv' AND
__DataCache_time =
(
SELECT DISTINCT __DataCache_time
FROM DataCache__uri•portfolio_ledger__balance
WHERE __DataCache_id = 'https://docs.google.com/spreadsheets/d/e/2PACX-1vQKyVROH752oeB0s8codNps5jdZu-ngdam2Lc8SkTlLqPbbiGdn9_O1Q8y6H02kOSp9dBW_v_kPmNdc/pub?gid=476533794&single=true&output=tsv'
ORDER BY __DataCache_time DESC
LIMIT 1
)
]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-12 14:08:30,068|INFO|investorzilla.datacache.DataCache|No cache for kind=BCBMarketIndex and id=CDI
2023-12-12 14:08:30,069|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__BCBMarketIndex
[SQL:
SELECT *
FROM DataCache__BCBMarketIndex
WHERE
__DataCache_id = 'CDI' AND
__DataCache_time =
(
SELECT DISTINCT __DataCache_time
FROM DataCache__BCBMarketIndex
WHERE __DataCache_id = 'CDI'
ORDER BY __DataCache_time DESC
LIMIT 1
)
]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-12 14:08:30,198|INFO|investorzilla.datacache.DataCache|No cache for kind=BCBCurrencyConverter and id=USD
2023-12-12 14:08:30,199|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__BCBCurrencyConverter
[SQL:
SELECT *
FROM DataCache__BCBCurrencyConverter
WHERE
__DataCache_id = 'USD' AND
__DataCache_time =
(
SELECT DISTINCT __DataCache_time
FROM DataCache__BCBCurrencyConverter
WHERE __DataCache_id = 'USD'
ORDER BY __DataCache_time DESC
LIMIT 1
)
]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-12 14:08:30,201|INFO|investorzilla.datacache.DataCache|No cache for kind=BCBCurrencyConverter and id=EUR
2023-12-12 14:08:30,202|INFO|investorzilla.datacache.DataCache|No cache for kind=uri•portfolio_ledger__ledger and id=https://docs.google.com/spreadsheets/d/e/2PACX-1vQKyVROH752oeB0s8codNps5jdZu-ngdam2Lc8SkTlLqPbbiGdn9_O1Q8y6H02kOSp9dBW_v_kPmNdc/pub?gid=476533794&single=true&output=tsv
2023-12-12 14:08:30,203|INFO|investorzilla.datacache.DataCache|No cache for kind=uri•portfolio_balance__ledger and id=https://docs.google.com/spreadsheets/d/e/2PACX-1vQKyVROH752oeB0s8codNps5jdZu-ngdam2Lc8SkTlLqPbbiGdn9_O1Q8y6H02kOSp9dBW_v_kPmNdc/pub?gid=985882980&single=true&output=tsv
2023-12-12 14:08:30,206|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__uri•portfolio_balance__ledger
[SQL:
SELECT *
FROM DataCache__uri•portfolio_balance__ledger
WHERE
__DataCache_id = 'https://docs.google.com/spreadsheets/d/e/2PACX-1vQKyVROH752oeB0s8codNps5jdZu-ngdam2Lc8SkTlLqPbbiGdn9_O1Q8y6H02kOSp9dBW_v_kPmNdc/pub?gid=985882980&single=true&output=tsv' AND
__DataCache_time =
(
SELECT DISTINCT __DataCache_time
FROM DataCache__uri•portfolio_balance__ledger
WHERE __DataCache_id = 'https://docs.google.com/spreadsheets/d/e/2PACX-1vQKyVROH752oeB0s8codNps5jdZu-ngdam2Lc8SkTlLqPbbiGdn9_O1Q8y6H02kOSp9dBW_v_kPmNdc/pub?gid=985882980&single=true&output=tsv'
ORDER BY __DataCache_time DESC
LIMIT 1
)
]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-12 14:08:30,206|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__uri•portfolio_ledger__ledger
[SQL:
SELECT *
FROM DataCache__uri•portfolio_ledger__ledger
WHERE
__DataCache_id = 'https://docs.google.com/spreadsheets/d/e/2PACX-1vQKyVROH752oeB0s8codNps5jdZu-ngdam2Lc8SkTlLqPbbiGdn9_O1Q8y6H02kOSp9dBW_v_kPmNdc/pub?gid=476533794&single=true&output=tsv' AND
__DataCache_time =
(
SELECT DISTINCT __DataCache_time
FROM DataCache__uri•portfolio_ledger__ledger
WHERE __DataCache_id = 'https://docs.google.com/spreadsheets/d/e/2PACX-1vQKyVROH752oeB0s8codNps5jdZu-ngdam2Lc8SkTlLqPbbiGdn9_O1Q8y6H02kOSp9dBW_v_kPmNdc/pub?gid=476533794&single=true&output=tsv'
ORDER BY __DataCache_time DESC
LIMIT 1
)
]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-12 14:08:30,206|INFO|investorzilla.datacache.DataCache|No cache for kind=BCBMarketIndex and id=IPCA
2023-12-12 14:08:30,204|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__BCBCurrencyConverter
[SQL:
SELECT *
FROM DataCache__BCBCurrencyConverter
WHERE
__DataCache_id = 'EUR' AND
__DataCache_time =
(
SELECT DISTINCT __DataCache_time
FROM DataCache__BCBCurrencyConverter
WHERE __DataCache_id = 'EUR'
ORDER BY __DataCache_time DESC
LIMIT 1
)
]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-12 14:08:30,209|INFO|investorzilla.datacache.DataCache|No cache for kind=BCBMarketIndex and id=SELIC
2023-12-12 14:08:30,215|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__BCBMarketIndex
[SQL:
SELECT *
FROM DataCache__BCBMarketIndex
WHERE
__DataCache_id = 'SELIC' AND
__DataCache_time =
(
SELECT DISTINCT __DataCache_time
FROM DataCache__BCBMarketIndex
WHERE __DataCache_id = 'SELIC'
ORDER BY __DataCache_time DESC
LIMIT 1
)
]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-12 14:08:30,211|INFO|investorzilla.datacache.DataCache|No cache for kind=BCBMarketIndex and id=CDI
2023-12-12 14:08:30,216|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__BCBMarketIndex
[SQL:
SELECT *
FROM DataCache__BCBMarketIndex
WHERE
__DataCache_id = 'CDI' AND
__DataCache_time =
(
SELECT DISTINCT __DataCache_time
FROM DataCache__BCBMarketIndex
WHERE __DataCache_id = 'CDI'
ORDER BY __DataCache_time DESC
LIMIT 1
)
]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-12 14:08:30,212|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__BCBMarketIndex
[SQL:
SELECT *
FROM DataCache__BCBMarketIndex
WHERE
__DataCache_id = 'IPCA' AND
__DataCache_time =
(
SELECT DISTINCT __DataCache_time
FROM DataCache__BCBMarketIndex
WHERE __DataCache_id = 'IPCA'
ORDER BY __DataCache_time DESC
LIMIT 1
)
]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-12 14:08:30,210|INFO|investorzilla.datacache.DataCache|No cache for kind=uri•portfolio_balance__balance and id=https://docs.google.com/spreadsheets/d/e/2PACX-1vQKyVROH752oeB0s8codNps5jdZu-ngdam2Lc8SkTlLqPbbiGdn9_O1Q8y6H02kOSp9dBW_v_kPmNdc/pub?gid=985882980&single=true&output=tsv
2023-12-12 14:08:30,213|INFO|investorzilla.datacache.DataCache|No cache for kind=BCBMarketIndex and id=IGPM
2023-12-12 14:08:30,218|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__uri•portfolio_balance__balance
[SQL:
SELECT *
FROM DataCache__uri•portfolio_balance__balance
WHERE
__DataCache_id = 'https://docs.google.com/spreadsheets/d/e/2PACX-1vQKyVROH752oeB0s8codNps5jdZu-ngdam2Lc8SkTlLqPbbiGdn9_O1Q8y6H02kOSp9dBW_v_kPmNdc/pub?gid=985882980&single=true&output=tsv' AND
__DataCache_time =
(
SELECT DISTINCT __DataCache_time
FROM DataCache__uri•portfolio_balance__balance
WHERE __DataCache_id = 'https://docs.google.com/spreadsheets/d/e/2PACX-1vQKyVROH752oeB0s8codNps5jdZu-ngdam2Lc8SkTlLqPbbiGdn9_O1Q8y6H02kOSp9dBW_v_kPmNdc/pub?gid=985882980&single=true&output=tsv'
ORDER BY __DataCache_time DESC
LIMIT 1
)
]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-12 14:08:30,220|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__BCBMarketIndex
[SQL:
SELECT *
FROM DataCache__BCBMarketIndex
WHERE
__DataCache_id = 'IGPM' AND
__DataCache_time =
(
SELECT DISTINCT __DataCache_time
FROM DataCache__BCBMarketIndex
WHERE __DataCache_id = 'IGPM'
ORDER BY __DataCache_time DESC
LIMIT 1
)
]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-12 14:08:30,220|INFO|investorzilla.datacache.DataCache|No cache for kind=uri•portfolio_ledger__balance and id=https://docs.google.com/spreadsheets/d/e/2PACX-1vQKyVROH752oeB0s8codNps5jdZu-ngdam2Lc8SkTlLqPbbiGdn9_O1Q8y6H02kOSp9dBW_v_kPmNdc/pub?gid=476533794&single=true&output=tsv
2023-12-12 14:08:30,222|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__uri•portfolio_ledger__balance
[SQL:
SELECT *
FROM DataCache__uri•portfolio_ledger__balance
WHERE
__DataCache_id = 'https://docs.google.com/spreadsheets/d/e/2PACX-1vQKyVROH752oeB0s8codNps5jdZu-ngdam2Lc8SkTlLqPbbiGdn9_O1Q8y6H02kOSp9dBW_v_kPmNdc/pub?gid=476533794&single=true&output=tsv' AND
__DataCache_time =
(
SELECT DISTINCT __DataCache_time
FROM DataCache__uri•portfolio_ledger__balance
WHERE __DataCache_id = 'https://docs.google.com/spreadsheets/d/e/2PACX-1vQKyVROH752oeB0s8codNps5jdZu-ngdam2Lc8SkTlLqPbbiGdn9_O1Q8y6H02kOSp9dBW_v_kPmNdc/pub?gid=476533794&single=true&output=tsv'
ORDER BY __DataCache_time DESC
LIMIT 1
)
]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-12 14:08:31,560|INFO|investorzilla.datacache.DataCache|Set cache to kind=BCBMarketIndex, id=IPCA, time=2023-12-12 14:08:31.559810+00:00
2023-12-12 14:08:31,628|INFO|investorzilla.datacache.DataCache|Set cache to kind=uri•portfolio_ledger__ledger, id=https://docs.google.com/spreadsheets/d/e/2PACX-1vQKyVROH752oeB0s8codNps5jdZu-ngdam2Lc8SkTlLqPbbiGdn9_O1Q8y6H02kOSp9dBW_v_kPmNdc/pub?gid=476533794&single=true&output=tsv, time=2023-12-12 14:08:31.628472+00:00
2023-12-12 14:08:31,704|INFO|investorzilla.datacache.DataCache|Set cache to kind=BCBMarketIndex, id=IGPM, time=2023-12-12 14:08:31.703599+00:00
2023-12-12 14:08:31,705|INFO|investorzilla.datacache.DataCache|Set cache to kind=BCBMarketIndex, id=IGPM, time=2023-12-12 14:08:31.704460+00:00
2023-12-12 14:08:31,731|INFO|investorzilla.datacache.DataCache|Set cache to kind=uri•portfolio_ledger__ledger, id=https://docs.google.com/spreadsheets/d/e/2PACX-1vQKyVROH752oeB0s8codNps5jdZu-ngdam2Lc8SkTlLqPbbiGdn9_O1Q8y6H02kOSp9dBW_v_kPmNdc/pub?gid=476533794&single=true&output=tsv, time=2023-12-12 14:08:31.727502+00:00
2023-12-12 14:08:31,750|INFO|investorzilla.datacache.DataCache|Set cache to kind=uri•portfolio_balance__balance, id=https://docs.google.com/spreadsheets/d/e/2PACX-1vQKyVROH752oeB0s8codNps5jdZu-ngdam2Lc8SkTlLqPbbiGdn9_O1Q8y6H02kOSp9dBW_v_kPmNdc/pub?gid=985882980&single=true&output=tsv, time=2023-12-12 14:08:31.749646+00:00
2023-12-12 14:08:31,807|INFO|investorzilla.datacache.DataCache|Set cache to kind=BCBMarketIndex, id=IPCA, time=2023-12-12 14:08:31.806717+00:00
2023-12-12 14:08:31,873|INFO|investorzilla.datacache.DataCache|Cache empty for kind=BCBMarketIndex and id=INPC
2023-12-12 14:08:32,123|INFO|investorzilla.datacache.DataCache|No cache for kind=YahooMarketIndex and id=^BVSP
2023-12-12 14:08:32,128|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__YahooMarketIndex
[SQL:
SELECT *
FROM DataCache__YahooMarketIndex
WHERE
__DataCache_id = '^BVSP' AND
__DataCache_time =
(
SELECT DISTINCT __DataCache_time
FROM DataCache__YahooMarketIndex
WHERE __DataCache_id = '^BVSP'
ORDER BY __DataCache_time DESC
LIMIT 1
)
]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-12 14:08:32,179|INFO|investorzilla.datacache.DataCache|No cache for kind=YahooMarketIndex and id=SPY
2023-12-12 14:08:32,190|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__YahooMarketIndex
[SQL:
SELECT *
FROM DataCache__YahooMarketIndex
WHERE
__DataCache_id = 'SPY' AND
__DataCache_time =
(
SELECT DISTINCT __DataCache_time
FROM DataCache__YahooMarketIndex
WHERE __DataCache_id = 'SPY'
ORDER BY __DataCache_time DESC
LIMIT 1
)
]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-12 14:08:32,479|INFO|investorzilla.datacache.DataCache|Set cache to kind=uri•portfolio_balance__balance, id=https://docs.google.com/spreadsheets/d/e/2PACX-1vQKyVROH752oeB0s8codNps5jdZu-ngdam2Lc8SkTlLqPbbiGdn9_O1Q8y6H02kOSp9dBW_v_kPmNdc/pub?gid=985882980&single=true&output=tsv, time=2023-12-12 14:08:32.479003+00:00
2023-12-12 14:08:32,535|INFO|investorzilla.datacache.DataCache|No cache for kind=YahooMarketIndex and id=^BVSP
2023-12-12 14:08:32,535|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__YahooMarketIndex
[SQL:
SELECT *
FROM DataCache__YahooMarketIndex
WHERE
__DataCache_id = '^BVSP' AND
__DataCache_time =
(
SELECT DISTINCT __DataCache_time
FROM DataCache__YahooMarketIndex
WHERE __DataCache_id = '^BVSP'
ORDER BY __DataCache_time DESC
LIMIT 1
)
]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-12 14:08:32,541|INFO|investorzilla.datacache.DataCache|No cache for kind=YahooMarketIndex and id=SPY
2023-12-12 14:08:32,541|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__YahooMarketIndex
[SQL:
SELECT *
FROM DataCache__YahooMarketIndex
WHERE
__DataCache_id = 'SPY' AND
__DataCache_time =
(
SELECT DISTINCT __DataCache_time
FROM DataCache__YahooMarketIndex
WHERE __DataCache_id = 'SPY'
ORDER BY __DataCache_time DESC
LIMIT 1
)
]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-12 14:08:32,564|INFO|investorzilla.datacache.DataCache|Cache empty for kind=BCBMarketIndex and id=INPC
2023-12-12 14:08:32,625|INFO|investorzilla.datacache.DataCache|No cache for kind=YahooMarketIndex and id=IVV
2023-12-12 14:08:32,637|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__YahooMarketIndex
[SQL:
SELECT *
FROM DataCache__YahooMarketIndex
WHERE
__DataCache_id = 'IVV' AND
__DataCache_time =
(
SELECT DISTINCT __DataCache_time
FROM DataCache__YahooMarketIndex
WHERE __DataCache_id = 'IVV'
ORDER BY __DataCache_time DESC
LIMIT 1
)
]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-12 14:08:32,859|INFO|investorzilla.datacache.DataCache|No cache for kind=YahooMarketIndex and id=IVV
2023-12-12 14:08:32,859|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__YahooMarketIndex
[SQL:
SELECT *
FROM DataCache__YahooMarketIndex
WHERE
__DataCache_id = 'IVV' AND
__DataCache_time =
(
SELECT DISTINCT __DataCache_time
FROM DataCache__YahooMarketIndex
WHERE __DataCache_id = 'IVV'
ORDER BY __DataCache_time DESC
LIMIT 1
)
]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-12 14:08:33,042|INFO|investorzilla.datacache.DataCache|Set cache to kind=BCBMarketIndex, id=SELIC, time=2023-12-12 14:08:33.040912+00:00
2023-12-12 14:08:33,132|INFO|investorzilla.datacache.DataCache|Set cache to kind=BCBMarketIndex, id=INPC, time=2023-12-12 14:08:33.130785+00:00
2023-12-12 14:08:33,293|INFO|investorzilla.datacache.DataCache|Set cache to kind=BCBMarketIndex, id=CDI, time=2023-12-12 14:08:33.293231+00:00
2023-12-12 14:08:33,645|INFO|investorzilla.datacache.DataCache|Set cache to kind=BCBMarketIndex, id=SELIC, time=2023-12-12 14:08:33.638705+00:00
2023-12-12 14:08:33,685|INFO|investorzilla.datacache.DataCache|Set cache to kind=BCBMarketIndex, id=INPC, time=2023-12-12 14:08:33.684689+00:00
2023-12-12 14:08:33,896|INFO|investorzilla.datacache.DataCache|Set cache to kind=BCBMarketIndex, id=CDI, time=2023-12-12 14:08:33.895640+00:00
2023-12-12 14:08:35,494|INFO|investorzilla.datacache.DataCache|No cache for kind=YahooMarketIndex and id=VOO
2023-12-12 14:08:35,505|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__YahooMarketIndex
[SQL:
SELECT *
FROM DataCache__YahooMarketIndex
WHERE
__DataCache_id = 'VOO' AND
__DataCache_time =
(
SELECT DISTINCT __DataCache_time
FROM DataCache__YahooMarketIndex
WHERE __DataCache_id = 'VOO'
ORDER BY __DataCache_time DESC
LIMIT 1
)
]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-12 14:08:36,707|INFO|investorzilla.datacache.DataCache|No cache for kind=YahooMarketIndex and id=VOO
2023-12-12 14:08:36,712|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__YahooMarketIndex
[SQL:
SELECT *
FROM DataCache__YahooMarketIndex
WHERE
__DataCache_id = 'VOO' AND
__DataCache_time =
(
SELECT DISTINCT __DataCache_time
FROM DataCache__YahooMarketIndex
WHERE __DataCache_id = 'VOO'
ORDER BY __DataCache_time DESC
LIMIT 1
)
]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-12 14:08:36,909|INFO|investorzilla.datacache.DataCache|No cache for kind=YahooMarketIndex and id=^GSPC
2023-12-12 14:08:36,909|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__YahooMarketIndex
[SQL:
SELECT *
FROM DataCache__YahooMarketIndex
WHERE
__DataCache_id = '^GSPC' AND
__DataCache_time =
(
SELECT DISTINCT __DataCache_time
FROM DataCache__YahooMarketIndex
WHERE __DataCache_id = '^GSPC'
ORDER BY __DataCache_time DESC
LIMIT 1
)
]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-12 14:08:36,974|INFO|investorzilla.datacache.DataCache|No cache for kind=YahooMarketIndex and id=^DJI
2023-12-12 14:08:36,974|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__YahooMarketIndex
[SQL:
SELECT *
FROM DataCache__YahooMarketIndex
WHERE
__DataCache_id = '^DJI' AND
__DataCache_time =
(
SELECT DISTINCT __DataCache_time
FROM DataCache__YahooMarketIndex
WHERE __DataCache_id = '^DJI'
ORDER BY __DataCache_time DESC
LIMIT 1
)
]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-12 14:08:38,164|INFO|investorzilla.datacache.DataCache|No cache for kind=YahooMarketIndex and id=^GSPC
2023-12-12 14:08:38,164|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__YahooMarketIndex
[SQL:
SELECT *
FROM DataCache__YahooMarketIndex
WHERE
__DataCache_id = '^GSPC' AND
__DataCache_time =
(
SELECT DISTINCT __DataCache_time
FROM DataCache__YahooMarketIndex
WHERE __DataCache_id = '^GSPC'
ORDER BY __DataCache_time DESC
LIMIT 1
)
]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-12 14:08:38,629|INFO|investorzilla.datacache.DataCache|No cache for kind=YahooMarketIndex and id=^DJI
2023-12-12 14:08:38,629|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__YahooMarketIndex
[SQL:
SELECT *
FROM DataCache__YahooMarketIndex
WHERE
__DataCache_id = '^DJI' AND
__DataCache_time =
(
SELECT DISTINCT __DataCache_time
FROM DataCache__YahooMarketIndex
WHERE __DataCache_id = '^DJI'
ORDER BY __DataCache_time DESC
LIMIT 1
)
]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-12 14:08:46,952|INFO|investorzilla.datacache.DataCache|Set cache to kind=BCBCurrencyConverter, id=USD, time=2023-12-12 14:08:46.951849+00:00
2023-12-12 14:08:47,876|INFO|investorzilla.datacache.DataCache|Set cache to kind=BCBCurrencyConverter, id=USD, time=2023-12-12 14:08:47.870044+00:00
2023-12-12 14:08:49,942|INFO|investorzilla.datacache.DataCache|Set cache to kind=BCBCurrencyConverter, id=EUR, time=2023-12-12 14:08:49.942229+00:00
2023-12-12 14:08:52,298|INFO|investorzilla.datacache.DataCache|Set cache to kind=BCBCurrencyConverter, id=EUR, time=2023-12-12 14:08:52.297374+00:00
2023-12-12 14:08:53,765|INFO|investorzilla.datacache.DataCache|No cache for kind=YahooMarketIndex and id=^IXIC
2023-12-12 14:08:53,765|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__YahooMarketIndex
[SQL:
SELECT *
FROM DataCache__YahooMarketIndex
WHERE
__DataCache_id = '^IXIC' AND
__DataCache_time =
(
SELECT DISTINCT __DataCache_time
FROM DataCache__YahooMarketIndex
WHERE __DataCache_id = '^IXIC'
ORDER BY __DataCache_time DESC
LIMIT 1
)
]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-12 14:08:59,248|INFO|investorzilla.datacache.DataCache|No cache for kind=YahooMarketIndex and id=QQQM
2023-12-12 14:08:59,248|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__YahooMarketIndex
[SQL:
SELECT *
FROM DataCache__YahooMarketIndex
WHERE
__DataCache_id = 'QQQM' AND
__DataCache_time =
(
SELECT DISTINCT __DataCache_time
FROM DataCache__YahooMarketIndex
WHERE __DataCache_id = 'QQQM'
ORDER BY __DataCache_time DESC
LIMIT 1
)
]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-12 14:08:59,255|INFO|investorzilla.datacache.DataCache|No cache for kind=YahooMarketIndex and id=^IXIC
2023-12-12 14:08:59,256|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__YahooMarketIndex
[SQL:
SELECT *
FROM DataCache__YahooMarketIndex
WHERE
__DataCache_id = '^IXIC' AND
__DataCache_time =
(
SELECT DISTINCT __DataCache_time
FROM DataCache__YahooMarketIndex
WHERE __DataCache_id = '^IXIC'
ORDER BY __DataCache_time DESC
LIMIT 1
)
]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-12 14:08:59,306|INFO|investorzilla.datacache.DataCache|No cache for kind=YahooMarketIndex and id=QQQM
2023-12-12 14:08:59,306|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__YahooMarketIndex
[SQL:
SELECT *
FROM DataCache__YahooMarketIndex
WHERE
__DataCache_id = 'QQQM' AND
__DataCache_time =
(
SELECT DISTINCT __DataCache_time
FROM DataCache__YahooMarketIndex
WHERE __DataCache_id = 'QQQM'
ORDER BY __DataCache_time DESC
LIMIT 1
)
]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-12 14:12:54,847|INFO|investorzilla.datacache.DataCache|Set cache to kind=YahooMarketIndex, id=IVV, time=2023-12-12 14:12:54.846531+00:00
2023-12-12 14:12:54,850|INFO|investorzilla.datacache.DataCache|Set cache to kind=YahooMarketIndex, id=^BVSP, time=2023-12-12 14:12:54.850253+00:00
2023-12-12 14:12:54,889|INFO|investorzilla.datacache.DataCache|Set cache to kind=YahooMarketIndex, id=IVV, time=2023-12-12 14:12:54.876924+00:00
2023-12-12 14:12:54,891|INFO|investorzilla.datacache.DataCache|Set cache to kind=YahooMarketIndex, id=^BVSP, time=2023-12-12 14:12:54.891104+00:00
2023-12-12 14:12:55,144|INFO|investorzilla.datacache.DataCache|Set cache to kind=YahooMarketIndex, id=SPY, time=2023-12-12 14:12:55.144149+00:00
2023-12-12 14:12:55,876|INFO|investorzilla.datacache.DataCache|Set cache to kind=YahooMarketIndex, id=SPY, time=2023-12-12 14:12:55.876105+00:00
2023-12-12 14:12:57,316|INFO|investorzilla.datacache.DataCache|Set cache to kind=YahooMarketIndex, id=VOO, time=2023-12-12 14:12:57.315540+00:00
2023-12-12 14:12:59,002|INFO|investorzilla.datacache.DataCache|Set cache to kind=YahooMarketIndex, id=VOO, time=2023-12-12 14:12:59.001543+00:00
2023-12-12 14:12:59,268|INFO|investorzilla.datacache.DataCache|Set cache to kind=YahooMarketIndex, id=^DJI, time=2023-12-12 14:12:59.268199+00:00
2023-12-12 14:13:01,183|INFO|investorzilla.datacache.DataCache|Set cache to kind=YahooMarketIndex, id=^GSPC, time=2023-12-12 14:13:01.176619+00:00
2023-12-12 14:13:01,463|INFO|investorzilla.datacache.DataCache|Cache empty for kind=YahooMarketIndex and id=QQQ
2023-12-12 14:13:01,607|INFO|investorzilla.datacache.DataCache|Set cache to kind=YahooMarketIndex, id=^DJI, time=2023-12-12 14:13:01.606530+00:00
2023-12-12 14:13:03,432|INFO|investorzilla.datacache.DataCache|Set cache to kind=YahooMarketIndex, id=^GSPC, time=2023-12-12 14:13:03.425745+00:00
2023-12-12 14:13:16,016|INFO|investorzilla.datacache.DataCache|Cache empty for kind=YahooMarketIndex and id=QQQ
2023-12-12 14:13:16,046|INFO|investorzilla.datacache.DataCache|Set cache to kind=YahooMarketIndex, id=^IXIC, time=2023-12-12 14:13:16.045876+00:00
2023-12-12 14:13:21,007|INFO|investorzilla.datacache.DataCache|Set cache to kind=YahooMarketIndex, id=QQQM, time=2023-12-12 14:13:21.006440+00:00
2023-12-12 14:13:21,164|INFO|investorzilla.datacache.DataCache|Set cache to kind=YahooMarketIndex, id=QQQM, time=2023-12-12 14:13:21.162976+00:00
2023-12-12 14:13:21,615|INFO|investorzilla.datacache.DataCache|Set cache to kind=YahooMarketIndex, id=^IXIC, time=2023-12-12 14:13:21.615241+00:00
2023-12-12 14:17:23,119|INFO|investorzilla.datacache.DataCache|Set cache to kind=YahooMarketIndex, id=QQQ, time=2023-12-12 14:17:23.119067+00:00
2023-12-12 14:17:24.220 Uncaught app exception
Traceback (most recent call last):
File "/home/felipe/investorzilla/env/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1969, in _exec_single_context
self.dialect.do_execute(
File "/home/felipe/investorzilla/env/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 922, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: database is locked
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/home/felipe/investorzilla/env/lib/python3.10/site-packages/streamlit/runtime/scriptrunner/script_runner.py", line 534, in _run_script
exec(code, module.__dict__)
File "/home/felipe/investorzilla/env/lib/python3.10/site-packages/investorzilla/streamlit_ui.py", line 511, in <module>
StreamlitInvestorzillaApp(refresh=False)
File "/home/felipe/investorzilla/env/lib/python3.10/site-packages/investorzilla/streamlit_ui.py", line 76, in __init__
streamlit.session_state.investor=investorzilla.Investor(
File "/home/felipe/investorzilla/env/lib/python3.10/site-packages/investorzilla/investor.py", line 49, in __init__
self.loadDomains(refresh)
File "/home/felipe/investorzilla/env/lib/python3.10/site-packages/investorzilla/investor.py", line 125, in loadDomains
part['obj']=task.result()
File "/usr/lib/python3.10/concurrent/futures/_base.py", line 451, in result
return self.__get_result()
File "/usr/lib/python3.10/concurrent/futures/_base.py", line 403, in __get_result
raise self._exception
File "/usr/lib/python3.10/concurrent/futures/thread.py", line 58, in run
result = self.fn(*self.args, **self.kwargs)
File "/home/felipe/investorzilla/env/lib/python3.10/site-packages/investorzilla/currency/brasil_banco_central.py", line 21, in __init__
super().__init__(
File "/home/felipe/investorzilla/env/lib/python3.10/site-packages/investorzilla/monetary_time_series.py", line 131, in __init__
super().__init__(kind, id, cache, refresh)
File "/home/felipe/investorzilla/env/lib/python3.10/site-packages/investorzilla/monetary_time_series.py", line 28, in __init__
self.getData()
File "/home/felipe/investorzilla/env/lib/python3.10/site-packages/investorzilla/monetary_time_series.py", line 80, in getData
self.cacheUpdate(self.kind,self.id,self.cache)
File "/home/felipe/investorzilla/env/lib/python3.10/site-packages/investorzilla/monetary_time_series.py", line 61, in cacheUpdate
cache.set(kind=kind, id=id, data=self.data)
File "/home/felipe/investorzilla/env/lib/python3.10/site-packages/investorzilla/datacache.py", line 387, in set
d[[self.idCol,self.timeCol] + columns].to_sql(
File "/home/felipe/investorzilla/env/lib/python3.10/site-packages/pandas/util/_decorators.py", line 333, in wrapper
return func(*args, **kwargs)
File "/home/felipe/investorzilla/env/lib/python3.10/site-packages/pandas/core/generic.py", line 3008, in to_sql
return sql.to_sql(
File "/home/felipe/investorzilla/env/lib/python3.10/site-packages/pandas/io/sql.py", line 788, in to_sql
return pandas_sql.to_sql(
File "/home/felipe/investorzilla/env/lib/python3.10/site-packages/pandas/io/sql.py", line 1958, in to_sql
total_inserted = sql_engine.insert_records(
File "/home/felipe/investorzilla/env/lib/python3.10/site-packages/pandas/io/sql.py", line 1507, in insert_records
raise err
File "/home/felipe/investorzilla/env/lib/python3.10/site-packages/pandas/io/sql.py", line 1498, in insert_records
return table.insert(chunksize=chunksize, method=method)
File "/home/felipe/investorzilla/env/lib/python3.10/site-packages/pandas/io/sql.py", line 1059, in insert
num_inserted = exec_insert(conn, keys, chunk_iter)
File "/home/felipe/investorzilla/env/lib/python3.10/site-packages/pandas/io/sql.py", line 967, in _execute_insert_multi
result = conn.execute(stmt)
File "/home/felipe/investorzilla/env/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1416, in execute
return meth(
File "/home/felipe/investorzilla/env/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 516, in _execute_on_connection
return connection._execute_clauseelement(
File "/home/felipe/investorzilla/env/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1639, in _execute_clauseelement
ret = self._execute_context(
File "/home/felipe/investorzilla/env/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1848, in _execute_context
return self._exec_single_context(
File "/home/felipe/investorzilla/env/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1988, in _exec_single_context
self._handle_dbapi_exception(
File "/home/felipe/investorzilla/env/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2343, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/home/felipe/investorzilla/env/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1969, in _exec_single_context
self.dialect.do_execute(
File "/home/felipe/investorzilla/env/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 922, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked
[SQL: INSERT INTO "DataCache__BCBCurrencyConverter" ("__DataCache_id", "__DataCache_time", "cotacaoCompra", "cotacaoVenda", time) VALUES (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?), (?, ?, ?, ?, ?)]
[parameters: ('USD', '2023-12-12 14:08:47.870044', 0.9, 1.0, '1994-07-01 17:46:00.0', 'USD', '2023-12-12 14:08:47.870044', 0.9, 1.0, '1994-07-01 18:29:00.0', 'USD', '2023-12-12 14:08:47.870044', 0.93, 0.94, '1994-07-04 10:52:00.0', 'USD', '2023-12-12 14:08:47.870044', 0.95, 0.96, '1994-07-04 11:03:00.0', 'USD', '2023-12-12 14:08:47.870044', 0.93, 0.94, '1994-07-04 14:07:00.0', 'USD', '2023-12-12 14:08:47.870044', 0.935, 0.94, '1994-07-04 16:14:00.0', 'USD', '2023-12-12 14:08:47.870044', 0.935, 0.94, '1994-07-05 10:08:00.0', 'USD', '2023-12-12 14:08:47.870044', 0.93, 0.935, '1994-07-05 10:38:00.0', 'USD', '2023-12-12 14:08:47.870044', 0.925, 0.93, '1994-07-05 11:58:00.0', 'USD', '2023-12-12 14:08:47.870044', 0.91, 0.915, '1994-07-05 16:03:00.0' ... 4895 parameters truncated ... 'USD', '2023-12-12 14:08:47.870044', 0.907, 0.909, '1995-03-24 18:09:00.0', 'USD', '2023-12-12 14:08:47.870044', 0.909, 0.911, '1995-03-27 09:36:00.0', 'USD', '2023-12-12 14:08:47.870044', 0.907, 0.909, '1995-03-27 10:27:00.0', 'USD', '2023-12-12 14:08:47.870044', 0.907, 0.909, '1995-03-27 12:53:00.0', 'USD', '2023-12-12 14:08:47.870044', 0.908, 0.91, '1995-03-27 18:24:00.0', 'USD', '2023-12-12 14:08:47.870044', 0.91, 0.912, '1995-03-28 09:35:00.0', 'USD', '2023-12-12 14:08:47.870044', 0.912, 0.914, '1995-03-28 10:13:00.0', 'USD', '2023-12-12 14:08:47.870044', 0.911, 0.913, '1995-03-28 11:06:00.0', 'USD', '2023-12-12 14:08:47.870044', 0.911, 0.913, '1995-03-28 13:50:00.0', 'USD', '2023-12-12 14:08:47.870044', 0.909, 0.911, '1995-03-28 14:33:00.0')]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-12 14:17:37,422|INFO|investorzilla.datacache.DataCache|Set cache to kind=YahooMarketIndex, id=QQQ, time=2023-12-12 14:17:37.422276+00:00
2023-12-12 14:17:40.883 `label` got an empty value. This is discouraged for accessibility reasons and may be disallowed in the future by raising an exception. Please provide a non-empty label and hide it with label_visibility if needed.
2023-12-12 14:17:41.337 `label` got an empty value. This is discouraged for accessibility reasons and may be disallowed in the future by raising an exception. Please provide a non-empty label and hide it with label_visibility if needed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment