Skip to content

Instantly share code, notes, and snippets.

@johnfelipe

johnfelipe/investorzilla.sh

Created December 12, 2023 22:09
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/5dcaa4fa5656f205788e551fd3e3102c to your computer and use it in GitHub Desktop.
Save johnfelipe/5dcaa4fa5656f205788e551fd3e3102c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
investorzilla.sh
Using cached GitPython-3.1.40-py3-none-any.whl (190 kB)
Collecting cachetools<6,>=4.0
Using cached cachetools-5.3.2-py3-none-any.whl (9.3 kB)
Collecting altair<6,>=4.0
Using cached altair-5.2.0-py3-none-any.whl (996 kB)
Collecting protobuf<5,>=3.20
Using cached protobuf-4.25.1-cp37-abi3-manylinux2014_x86_64.whl (294 kB)
Collecting click<9,>=7.0
Using cached click-8.1.7-py3-none-any.whl (97 kB)
Collecting toml<2,>=0.10.1
Using cached toml-0.10.2-py2.py3-none-any.whl (16 kB)
Collecting pydeck<1,>=0.8.0b4
Using cached pydeck-0.8.1b0-py2.py3-none-any.whl (4.8 MB)
Collecting jinja2
Using cached Jinja2-3.1.2-py3-none-any.whl (133 kB)
Collecting jsonschema>=3.0
Using cached jsonschema-4.20.0-py3-none-any.whl (84 kB)
Collecting toolz
Using cached toolz-0.12.0-py3-none-any.whl (55 kB)
Collecting gitdb<5,>=4.0.1
Using cached gitdb-4.0.11-py3-none-any.whl (62 kB)
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 rsa<5,>=3.1.4
Using cached rsa-4.9-py3-none-any.whl (34 kB)
Collecting pyasn1-modules>=0.2.1
Using cached pyasn1_modules-0.3.0-py2.py3-none-any.whl (181 kB)
Collecting zipp>=0.5
Using cached zipp-3.17.0-py3-none-any.whl (7.4 kB)
Collecting six>=1.5
Using cached six-1.16.0-py2.py3-none-any.whl (11 kB)
Collecting idna<4,>=2.5
Using cached idna-3.6-py3-none-any.whl (61 kB)
Collecting urllib3<3,>=1.21.1
Using cached urllib3-2.1.0-py3-none-any.whl (104 kB)
Collecting charset-normalizer<4,>=2
Using cached charset_normalizer-3.3.2-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (142 kB)
Collecting oauthlib>=3.0.0
Using cached oauthlib-3.2.2-py3-none-any.whl (151 kB)
Collecting markdown-it-py>=2.2.0
Using cached markdown_it_py-3.0.0-py3-none-any.whl (87 kB)
Collecting pygments<3.0.0,>=2.13.0
Using cached pygments-2.17.2-py3-none-any.whl (1.2 MB)
Collecting smmap<6,>=3.0.1
Using cached smmap-5.0.1-py3-none-any.whl (24 kB)
Collecting MarkupSafe>=2.0
Using cached MarkupSafe-2.1.3-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (25 kB)
Collecting rpds-py>=0.7.1
Using cached rpds_py-0.13.2-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (1.2 MB)
Collecting jsonschema-specifications>=2023.03.6
Using cached jsonschema_specifications-2023.11.2-py3-none-any.whl (17 kB)
Collecting referencing>=0.28.4
Using cached referencing-0.32.0-py3-none-any.whl (26 kB)
Collecting attrs>=22.2.0
Using cached attrs-23.1.0-py3-none-any.whl (61 kB)
Collecting mdurl~=0.1
Using cached mdurl-0.1.2-py3-none-any.whl (10.0 kB)
Collecting pyasn1<0.6.0,>=0.4.6
Using cached pyasn1-0.5.1-py2.py3-none-any.whl (84 kB)
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.111.0 google-auth-2.25.2 google-auth-httplib2-0.2.0 google-auth-oauthlib-1.2.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.2 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) root@template:~/investorzilla# mkdir myportfolio
(env) root@template:~/investorzilla# cp /root/investorzilla/config_examples/investorzilla.yaml /root/investorzilla/myportfolio/investorzilla.yaml
(env) root@template:~/investorzilla# 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 21:35:50.694 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
exec(code, module.__dict__)
File "/root/investorzilla/env/lib/python3.10/site-packages/investorzilla/streamlit_ui.py", line 511, in <module>
StreamlitInvestorzillaApp(refresh=False)
File "/root/investorzilla/env/lib/python3.10/site-packages/investorzilla/streamlit_ui.py", line 76, in __init__
streamlit.session_state.investor=investorzilla.Investor(
File "/root/investorzilla/investorzilla/investor.py", line 35, in __init__
with open(file, 'r', encoding="utf8") as f:
FileNotFoundError: [Errno 2] No such file or directory: 'investorzilla.yaml'
^C Stopping...
Traceback (most recent call last):
File "/root/investorzilla/env/bin/investorzilla", line 5, in <module>
from investorzilla.__main__ import main
File "/root/investorzilla/env/lib/python3.10/site-packages/investorzilla/__main__.py", line 49, in <module>
main()
File "/root/investorzilla/env/lib/python3.10/site-packages/investorzilla/__main__.py", line 45, in main
proc.wait()
File "/usr/lib/python3.10/subprocess.py", line 1209, in wait
return self._wait(timeout=timeout)
File "/usr/lib/python3.10/subprocess.py", line 1959, in _wait
(pid, sts) = self._try_wait(0)
File "/usr/lib/python3.10/subprocess.py", line 1917, in _try_wait
(pid, sts) = os.waitpid(self.pid, wait_flags)
KeyboardInterrupt
(env) root@template:~/investorzilla# cd myportfolio
(env) root@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 21:36:10,440|INFO|investorzilla.datacache.DataCache|No cache for kind=BCBMarketIndex and id=IPCA
2023-12-12 21:36:10,441|INFO|investorzilla.datacache.DataCache|No cache for kind=BCBMarketIndex and id=CDI
2023-12-12 21:36:10,442|INFO|investorzilla.datacache.DataCache|No cache for kind=BCBMarketIndex and id=SELIC
2023-12-12 21:36:10,445|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 21:36:10,443|INFO|investorzilla.datacache.DataCache|No cache for kind=BCBMarketIndex and id=INPC
2023-12-12 21:36:10,444|INFO|investorzilla.datacache.DataCache|No cache for kind=YahooMarketIndex and id=^BVSP
2023-12-12 21:36:10,446|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 21:36:10,444|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 21:36:10,442|INFO|investorzilla.datacache.DataCache|No cache for kind=BCBMarketIndex and id=IGPM
2023-12-12 21:36:10,447|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 21:36:10,446|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__BCBMarketIndex
[SQL:
SELECT *
FROM DataCache__BCBMarketIndex
WHERE
__DataCache_id = 'INPC' AND
__DataCache_time =
(
SELECT DISTINCT __DataCache_time
FROM DataCache__BCBMarketIndex
WHERE __DataCache_id = 'INPC'
ORDER BY __DataCache_time DESC
LIMIT 1
)
]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-12 21:36:10,444|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 21:36:10,445|INFO|investorzilla.datacache.DataCache|No cache for kind=YahooMarketIndex and id=SPY
2023-12-12 21:36:10,453|INFO|investorzilla.datacache.DataCache|No cache for kind=YahooMarketIndex and id=IVV
2023-12-12 21:36:10,454|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 21:36:10,454|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 21:36:11,835|INFO|investorzilla.datacache.DataCache|Set cache to kind=BCBMarketIndex, id=IGPM, time=2023-12-12 21:36:11.833531+00:00
2023-12-12 21:36:11,945|INFO|investorzilla.datacache.DataCache|No cache for kind=YahooMarketIndex and id=VOO
2023-12-12 21:36:11,945|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 21:36:11,998|INFO|investorzilla.datacache.DataCache|Set cache to kind=BCBMarketIndex, id=IPCA, time=2023-12-12 21:36:11.997548+00:00
2023-12-12 21:36:12,042|INFO|investorzilla.datacache.DataCache|Set cache to kind=BCBMarketIndex, id=INPC, time=2023-12-12 21:36:12.041378+00:00
2023-12-12 21:36:12,168|INFO|investorzilla.datacache.DataCache|No cache for kind=YahooMarketIndex and id=^GSPC
2023-12-12 21:36:12,168|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 21:36:12,203|INFO|investorzilla.datacache.DataCache|No cache for kind=YahooMarketIndex and id=^DJI
2023-12-12 21:36:12,203|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 21:36:13,675|INFO|investorzilla.datacache.DataCache|Set cache to kind=BCBMarketIndex, id=CDI, time=2023-12-12 21:36:13.674671+00:00
2023-12-12 21:36:14,016|INFO|investorzilla.datacache.DataCache|Set cache to kind=BCBMarketIndex, id=SELIC, time=2023-12-12 21:36:14.015730+00:00
2023-12-12 21:36:15,663|INFO|investorzilla.datacache.DataCache|No cache for kind=YahooMarketIndex and id=^IXIC
2023-12-12 21:36:15,669|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 21:36:16,100|INFO|investorzilla.datacache.DataCache|No cache for kind=YahooMarketIndex and id=QQQM
2023-12-12 21:36:16,100|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)
^C Stopping...
Traceback (most recent call last):
File "/root/investorzilla/env/bin/investorzilla", line 5, in <module>
from investorzilla.__main__ import main
File "/root/investorzilla/env/lib/python3.10/site-packages/investorzilla/__main__.py", line 49, in <module>
main()
File "/root/investorzilla/env/lib/python3.10/site-packages/investorzilla/__main__.py", line 45, in main
proc.wait()
File "/usr/lib/python3.10/subprocess.py", line 1209, in wait
return self._wait(timeout=timeout)
File "/usr/lib/python3.10/subprocess.py", line 1959, in _wait
(pid, sts) = self._try_wait(0)
File "/usr/lib/python3.10/subprocess.py", line 1917, in _try_wait
(pid, sts) = os.waitpid(self.pid, wait_flags)
KeyboardInterrupt
(env) root@template:~/investorzilla/myportfolio# deactivate
root@template:~/investorzilla/myportfolio# 2023-12-12 21:40:32,283|INFO|investorzilla.datacache.DataCache|Set cache to kind=YahooMarketIndex, id=^BVSP, time=2023-12-12 21:40:32.282077+00:00
2023-12-12 21:40:32,290|INFO|investorzilla.datacache.DataCache|Set cache to kind=YahooMarketIndex, id=IVV, time=2023-12-12 21:40:32.289174+00:00
2023-12-12 21:40:32,640|INFO|investorzilla.datacache.DataCache|Set cache to kind=YahooMarketIndex, id=SPY, time=2023-12-12 21:40:32.640008+00:00
2023-12-12 21:40:34,822|INFO|investorzilla.datacache.DataCache|Set cache to kind=YahooMarketIndex, id=VOO, time=2023-12-12 21:40:34.821292+00:00
2023-12-12 21:40:35,214|INFO|investorzilla.datacache.DataCache|Cache empty for kind=YahooMarketIndex and id=QQQ
2023-12-12 21:40:35,555|INFO|investorzilla.datacache.DataCache|Set cache to kind=YahooMarketIndex, id=^DJI, time=2023-12-12 21:40:35.554753+00:00
2023-12-12 21:40:35,852|INFO|investorzilla.datacache.DataCache|No cache for kind=BCBCurrencyConverter and id=EUR
2023-12-12 21:40:35,854|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 21:40:35,857|INFO|investorzilla.datacache.DataCache|No cache for kind=BCBCurrencyConverter and id=USD
2023-12-12 21:40:35,871|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 21:40:36,513|INFO|investorzilla.datacache.DataCache|Set cache to kind=YahooMarketIndex, id=^GSPC, time=2023-12-12 21:40:36.512564+00:00
2023-12-12 21:40:38,186|INFO|investorzilla.datacache.DataCache|Set cache to kind=YahooMarketIndex, id=QQQM, time=2023-12-12 21:40:38.185575+00:00
2023-12-12 21:40:41,434|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 21:40:41,436|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 21:40:41,535|INFO|investorzilla.datacache.DataCache|Set cache to kind=YahooMarketIndex, id=^IXIC, time=2023-12-12 21:40:41.534454+00:00
2023-12-12 21:40:41,616|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 21:40:41,617|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 21:40:41,619|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 21:40:41,617|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 21:40:43,315|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 21:40:43.314890+00:00
2023-12-12 21:40:44,029|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 21:40:44,029|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 21:40:45,630|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 21:40:45.630241+00:00
2023-12-12 21:40:55,174|INFO|investorzilla.datacache.DataCache|Set cache to kind=BCBCurrencyConverter, id=EUR, time=2023-12-12 21:40:55.173869+00:00
2023-12-12 21:40:55,447|INFO|investorzilla.datacache.DataCache|Set cache to kind=BCBCurrencyConverter, id=USD, time=2023-12-12 21:40:55.446577+00:00
^C
root@template:~/investorzilla/myportfolio# cd
root@template:~# rm -r investorzilla
root@template:~# sudo apt update
Hit:1 http://co.archive.ubuntu.com/ubuntu jammy InRelease
Get:2 http://co.archive.ubuntu.com/ubuntu jammy-updates InRelease [119 kB]
Hit:3 http://co.archive.ubuntu.com/ubuntu jammy-backports InRelease
Get:4 http://co.archive.ubuntu.com/ubuntu jammy-security InRelease [110 kB]
Get:5 http://co.archive.ubuntu.com/ubuntu jammy-updates/main amd64 Packages [1,246 kB]
Get:6 http://co.archive.ubuntu.com/ubuntu jammy-updates/main Translation-en [257 kB]
Get:7 http://co.archive.ubuntu.com/ubuntu jammy-updates/universe amd64 Packages [1,018 kB]
Get:8 http://co.archive.ubuntu.com/ubuntu jammy-security/main amd64 Packages [1,037 kB]
Get:9 http://co.archive.ubuntu.com/ubuntu jammy-security/main Translation-en [197 kB]
Get:10 http://co.archive.ubuntu.com/ubuntu jammy-security/restricted amd64 Packages [1,205 kB]
Get:11 http://co.archive.ubuntu.com/ubuntu jammy-security/restricted Translation-en [195 kB]
Get:12 http://co.archive.ubuntu.com/ubuntu jammy-security/universe amd64 Packages [815 kB]
Fetched 6,200 kB in 2s (3,043 kB/s)
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
8 packages can be upgraded. Run 'apt list --upgradable' to see them.
root@template:~# python
Command 'python' not found, did you mean:
command 'python3' from deb python3
command 'python' from deb python-is-python3
root@template:~# python3
Python 3.10.12 (main, Nov 20 2023, 15:14:05) [GCC 11.4.0] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>>
KeyboardInterrupt
>>>
root@template:~# sudo apt update
Hit:1 http://co.archive.ubuntu.com/ubuntu jammy InRelease
Hit:2 http://co.archive.ubuntu.com/ubuntu jammy-updates InRelease
Hit:3 http://co.archive.ubuntu.com/ubuntu jammy-backports InRelease
Hit:4 http://co.archive.ubuntu.com/ubuntu jammy-security InRelease
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
8 packages can be upgraded. Run 'apt list --upgradable' to see them.
root@template:~# sudo add-apt-repository ppa:deadsnakes/ppa
Repository: 'deb https://ppa.launchpadcontent.net/deadsnakes/ppa/ubuntu/ jammy main'
Description:
This PPA contains more recent Python versions packaged for Ubuntu.
Disclaimer: there's no guarantee of timely updates in case of security problems or other issues. If you want to use them in a security-or-otherwise-critical environment (say, on a production server), you do so at your own risk.
Update Note
===========
Please use this repository instead of ppa:fkrull/deadsnakes.
Reporting Issues
================
Issues can be reported in the master issue tracker at:
https://github.com/deadsnakes/issues/issues
Supported Ubuntu and Python Versions
====================================
- Ubuntu 20.04 (focal) Python3.5 - Python3.7, Python3.9 - Python3.13
- Ubuntu 22.04 (jammy) Python3.7 - Python3.9, Python3.11 - Python3.13
- Note: Python2.7 (all), Python 3.8 (focal), Python 3.10 (jammy) are not provided by deadsnakes as upstream ubuntu provides those packages.
Why some packages aren't built:
- Note: for focal, older python versions require libssl<1.1 so they are not currently built
- Note: for jammy, older python versions requre libssl<3 so they are not currently built
- If you need these, reach out to asottile to set up a private ppa
The packages may also work on other versions of Ubuntu or Debian, but that is not tested or supported.
Packages
========
The packages provided here are loosely based on the debian upstream packages with some modifications to make them more usable as non-default pythons and on ubuntu. As such, the packages follow debian's patterns and often do not include a full python distribution with just `apt install python#.#`. Here is a list of packages that may be useful along with the default install:
- `python#.#-dev`: includes development headers for building C extensions
- `python#.#-venv`: provides the standard library `venv` module
- `python#.#-distutils`: provides the standard library `distutils` module
- `python#.#-lib2to3`: provides the `2to3-#.#` utility as well as the standard library `lib2to3` module
- `python#.#-gdbm`: provides the standard library `dbm.gnu` module
- `python#.#-tk`: provides the standard library `tkinter` module
Third-Party Python Modules
==========================
Python modules in the official Ubuntu repositories are packaged to work with the Python interpreters from the official repositories. Accordingly, they generally won't work with the Python interpreters from this PPA. As an exception, pure-Python modules for Python 3 will work, but any compiled extension modules won't.
To install 3rd-party Python modules, you should use the common Python packaging tools. For an introduction into the Python packaging ecosystem and its tools, refer to the Python Packaging User Guide:
https://packaging.python.org/installing/
Sources
=======
The package sources are available at:
https://github.com/deadsnakes/
Nightly Builds
==============
For nightly builds, see ppa:deadsnakes/nightly https://launchpad.net/~deadsnakes/+archive/ubuntu/nightly
More info: https://launchpad.net/~deadsnakes/+archive/ubuntu/ppa
Adding repository.
Press [ENTER] to continue or Ctrl-c to cancel.
Adding deb entry to /etc/apt/sources.list.d/deadsnakes-ubuntu-ppa-jammy.list
Adding disabled deb-src entry to /etc/apt/sources.list.d/deadsnakes-ubuntu-ppa-jammy.list
Adding key to /etc/apt/trusted.gpg.d/deadsnakes-ubuntu-ppa.gpg with fingerprint F23C5A6CF475977595C89F51BA6932366A755776
Hit:1 http://co.archive.ubuntu.com/ubuntu jammy InRelease
Hit:2 http://co.archive.ubuntu.com/ubuntu jammy-updates InRelease
Hit:3 http://co.archive.ubuntu.com/ubuntu jammy-backports InRelease
Hit:4 http://co.archive.ubuntu.com/ubuntu jammy-security InRelease
Get:5 https://ppa.launchpadcontent.net/deadsnakes/ppa/ubuntu jammy InRelease [18.1 kB]
Get:6 https://ppa.launchpadcontent.net/deadsnakes/ppa/ubuntu jammy/main amd64 Packages [24.1 kB]
Get:7 https://ppa.launchpadcontent.net/deadsnakes/ppa/ubuntu jammy/main Translation-en [4,800 B]
Fetched 46.9 kB in 2s (22.2 kB/s)
Reading package lists... Done
root@template:~# sudo apt install python3.9 -y
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
The following packages were automatically installed and are no longer required:
libflashrom1 libftdi1-2
Use 'sudo apt autoremove' to remove them.
The following additional packages will be installed:
libpython3.9-minimal libpython3.9-stdlib mailcap mime-support
python3.9-minimal
Suggested packages:
python3.9-venv binfmt-support
The following NEW packages will be installed:
libpython3.9-minimal libpython3.9-stdlib mailcap mime-support python3.9
python3.9-minimal
0 upgraded, 6 newly installed, 0 to remove and 8 not upgraded.
Need to get 5,279 kB of archives.
After this operation, 19.4 MB of additional disk space will be used.
Get:1 http://co.archive.ubuntu.com/ubuntu jammy/main amd64 mailcap all 3.70+nmu1ubuntu1 [23.8 kB]
Get:2 http://co.archive.ubuntu.com/ubuntu jammy/main amd64 mime-support all 3.66 [3,696 B]
Get:3 https://ppa.launchpadcontent.net/deadsnakes/ppa/ubuntu jammy/main amd64 libpython3.9-minimal amd64 3.9.18-1+jammy1 [835 kB]
Get:4 https://ppa.launchpadcontent.net/deadsnakes/ppa/ubuntu jammy/main amd64 python3.9-minimal amd64 3.9.18-1+jammy1 [2,079 kB]
Get:5 https://ppa.launchpadcontent.net/deadsnakes/ppa/ubuntu jammy/main amd64 libpython3.9-stdlib amd64 3.9.18-1+jammy1 [1,841 kB]
Get:6 https://ppa.launchpadcontent.net/deadsnakes/ppa/ubuntu jammy/main amd64 python3.9 amd64 3.9.18-1+jammy1 [496 kB]
Fetched 5,279 kB in 16s (336 kB/s)
Selecting previously unselected package libpython3.9-minimal:amd64.
(Reading database ... 116606 files and directories currently installed.)
Preparing to unpack .../0-libpython3.9-minimal_3.9.18-1+jammy1_amd64.deb ...
Unpacking libpython3.9-minimal:amd64 (3.9.18-1+jammy1) ...
Selecting previously unselected package python3.9-minimal.
Preparing to unpack .../1-python3.9-minimal_3.9.18-1+jammy1_amd64.deb ...
Unpacking python3.9-minimal (3.9.18-1+jammy1) ...
Selecting previously unselected package mailcap.
Preparing to unpack .../2-mailcap_3.70+nmu1ubuntu1_all.deb ...
Unpacking mailcap (3.70+nmu1ubuntu1) ...
Selecting previously unselected package mime-support.
Preparing to unpack .../3-mime-support_3.66_all.deb ...
Unpacking mime-support (3.66) ...
Selecting previously unselected package libpython3.9-stdlib:amd64.
Preparing to unpack .../4-libpython3.9-stdlib_3.9.18-1+jammy1_amd64.deb ...
Unpacking libpython3.9-stdlib:amd64 (3.9.18-1+jammy1) ...
Selecting previously unselected package python3.9.
Preparing to unpack .../5-python3.9_3.9.18-1+jammy1_amd64.deb ...
Unpacking python3.9 (3.9.18-1+jammy1) ...
Setting up libpython3.9-minimal:amd64 (3.9.18-1+jammy1) ...
Setting up python3.9-minimal (3.9.18-1+jammy1) ...
Setting up mailcap (3.70+nmu1ubuntu1) ...
Setting up mime-support (3.66) ...
Setting up libpython3.9-stdlib:amd64 (3.9.18-1+jammy1) ...
Setting up python3.9 (3.9.18-1+jammy1) ...
Processing triggers for man-db (2.10.2-1) ...
Scanning processes...
Scanning candidates...
Scanning linux images...
Running kernel seems to be up-to-date.
No services need to be restarted.
No containers need to be restarted.
No user sessions are running outdated binaries.
No VM guests are running outdated hypervisor (qemu) binaries on this host.
root@template:~# python3.9 --version
Python 3.9.18
root@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 | 2.48 MiB/s, done.
Resolving deltas: 100% (467/467), done.
root@template:~# sudo apt install python3.9-venv
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
The following packages were automatically installed and are no longer required:
libflashrom1 libftdi1-2
Use 'sudo apt autoremove' to remove them.
The following additional packages will be installed:
python3.9-distutils python3.9-lib2to3
The following NEW packages will be installed:
python3.9-distutils python3.9-lib2to3 python3.9-venv
0 upgraded, 3 newly installed, 0 to remove and 8 not upgraded.
Need to get 2,969 kB of archives.
After this operation, 4,133 kB of additional disk space will be used.
Do you want to continue? [Y/n] y
Get:1 https://ppa.launchpadcontent.net/deadsnakes/ppa/ubuntu jammy/main amd64 python3.9-lib2to3 all 3.9.18-1+jammy1 [127 kB]
Get:2 https://ppa.launchpadcontent.net/deadsnakes/ppa/ubuntu jammy/main amd64 python3.9-distutils all 3.9.18-1+jammy1 [193 kB]
Get:3 https://ppa.launchpadcontent.net/deadsnakes/ppa/ubuntu jammy/main amd64 python3.9-venv amd64 3.9.18-1+jammy1 [2,650 kB]
Fetched 2,969 kB in 7s (418 kB/s)
Selecting previously unselected package python3.9-lib2to3.
(Reading database ... 117271 files and directories currently installed.)
Preparing to unpack .../python3.9-lib2to3_3.9.18-1+jammy1_all.deb ...
Unpacking python3.9-lib2to3 (3.9.18-1+jammy1) ...
Selecting previously unselected package python3.9-distutils.
Preparing to unpack .../python3.9-distutils_3.9.18-1+jammy1_all.deb ...
Unpacking python3.9-distutils (3.9.18-1+jammy1) ...
Selecting previously unselected package python3.9-venv.
Preparing to unpack .../python3.9-venv_3.9.18-1+jammy1_amd64.deb ...
Unpacking python3.9-venv (3.9.18-1+jammy1) ...
Setting up python3.9-lib2to3 (3.9.18-1+jammy1) ...
Setting up python3.9-distutils (3.9.18-1+jammy1) ...
Setting up python3.9-venv (3.9.18-1+jammy1) ...
Scanning processes...
Scanning candidates...
Scanning linux images...
Running kernel seems to be up-to-date.
No services need to be restarted.
No containers need to be restarted.
No user sessions are running outdated binaries.
No VM guests are running outdated hypervisor (qemu) binaries on this host.
root@template:~# cd investorzilla/2023-12-12 21:44:57,177|INFO|investorzilla.datacache.DataCache|Set cache to kind=YahooMarketIndex, id=QQQ, time=2023-12-12 21:44:57.176411+00:00 cd investorzilla/
root@template:~/investorzilla# 2023-12-12 21:44:57.366 Uncaught app exception
Traceback (most recent call last):
File "/root/investorzilla/env/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1969, in _exec_single_context
File "/root/investorzilla/env/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 922, in do_execute
sqlite3.OperationalError: attempt to write a readonly database
The above exception was the direct cause of the following 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/yahoo_finance.py", line 19, 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 80, in getData
File "/root/investorzilla/env/lib/python3.10/site-packages/investorzilla/monetary_time_series.py", line 61, in cacheUpdate
File "/root/investorzilla/env/lib/python3.10/site-packages/investorzilla/datacache.py", line 387, in set
File "/root/investorzilla/env/lib/python3.10/site-packages/pandas/util/_decorators.py", line 333, in wrapper
File "/root/investorzilla/env/lib/python3.10/site-packages/pandas/core/generic.py", line 3008, in to_sql
File "/root/investorzilla/env/lib/python3.10/site-packages/pandas/io/sql.py", line 788, in to_sql
File "/root/investorzilla/env/lib/python3.10/site-packages/pandas/io/sql.py", line 1958, in to_sql
File "/root/investorzilla/env/lib/python3.10/site-packages/pandas/io/sql.py", line 1507, in insert_records
File "/root/investorzilla/env/lib/python3.10/site-packages/pandas/io/sql.py", line 1498, in insert_records
File "/root/investorzilla/env/lib/python3.10/site-packages/pandas/io/sql.py", line 1059, in insert
File "/root/investorzilla/env/lib/python3.10/site-packages/pandas/io/sql.py", line 967, in _execute_insert_multi
File "/root/investorzilla/env/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1416, in execute
File "/root/investorzilla/env/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 516, in _execute_on_connection
File "/root/investorzilla/env/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1639, in _execute_clauseelement
File "/root/investorzilla/env/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1848, in _execute_context
File "/root/investorzilla/env/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1988, in _exec_single_context
File "/root/investorzilla/env/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2343, in _handle_dbapi_exception
File "/root/investorzilla/env/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1969, in _exec_single_context
File "/root/investorzilla/env/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 922, in do_execute
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) attempt to write a readonly database
[SQL: INSERT INTO "DataCache__YahooMarketIndex" ("__DataCache_id", "__DataCache_time", "Date", "Open", "High", "Low", "Close", "Adj Close", "Volume") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?)]
[parameters: ('QQQ', '2023-12-12 21:44:57.176411', '1999-03-10', 51.125, 51.15625, 50.28125, 51.0625, 43.715057, 5232000, 'QQQ', '2023-12-12 21:44:57.176411', '1999-03-11', 51.4375, 51.734375, 50.3125, 51.3125, 43.929089, 9688600, 'QQQ', '2023-12-12 21:44:57.176411', '1999-03-12', 51.125, 51.15625, 49.65625, 50.0625, 42.858955, 8743600, 'QQQ', '2023-12-12 21:44:57.176411', '1999-03-15', 50.4375, 51.5625, 49.90625, 51.5, 44.089626, 6369000, 'QQQ', '2023-12-12 21:44:57.176411', '1999-03-16', 51.71875, 52.15625, 51.15625, 51.9375, 44.464153, 4905800, 'QQQ', '2023-12-12 21:44:57.176411', '1999-03-17', 51.9375, 52.0 ... 8891 parameters truncated ... 25.370001, 24.51, 25.17, 21.548262, 70228500, 'QQQ', '2023-12-12 21:44:57.176411', '2003-02-24', 25.129999, 25.209999, 24.709999, 24.74, 21.180136, 56646600, 'QQQ', '2023-12-12 21:44:57.176411', '2003-02-25', 24.450001, 24.950001, 24.08, 24.77, 21.205814, 74440700, 'QQQ', '2023-12-12 21:44:57.176411', '2003-02-26', 24.68, 24.940001, 24.200001, 24.219999, 20.734955, 60005600, 'QQQ', '2023-12-12 21:44:57.176411', '2003-02-27', 24.42, 24.92, 24.27, 24.77, 21.205814, 66424000, 'QQQ', '2023-12-12 21:44:57.176411', '2003-02-28', 24.809999, 25.219999, 24.719999, 25.16, 21.539703, 50185800)]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
^C
root@template:~/investorzilla# python3.9 -m venv env
root@template:~/investorzilla# source env/bin/activate
(env) root@template:~/investorzilla# pip3.9 install investorzilla
Collecting investorzilla
Using cached investorzilla-2.4.2-py3-none-any.whl (72 kB)
Collecting sqlalchemy
Downloading SQLAlchemy-2.0.23-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (3.1 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 3.1/3.1 MB 11.0 MB/s eta 0:00:00
Collecting google-auth-oauthlib
Using cached google_auth_oauthlib-1.2.0-py2.py3-none-any.whl (24 kB)
Collecting google-api-python-client
Using cached google_api_python_client-2.111.0-py2.py3-none-any.whl (13.0 MB)
Collecting pyaml
Using cached pyaml-23.9.7-py3-none-any.whl (23 kB)
Collecting streamlit
Using cached streamlit-1.29.0-py2.py3-none-any.whl (8.4 MB)
Collecting certifi
Using cached certifi-2023.11.17-py3-none-any.whl (162 kB)
Collecting pandas>=2
Downloading pandas-2.1.4-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (12.3 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 12.3/12.3 MB 15.3 MB/s eta 0:00:00
Collecting pandas-datareader
Using cached pandas_datareader-0.10.0-py3-none-any.whl (109 kB)
Collecting google-auth-httplib2
Using cached google_auth_httplib2-0.2.0-py2.py3-none-any.whl (9.3 kB)
Collecting matplotlib
Downloading matplotlib-3.8.2-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (11.6 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 11.6/11.6 MB 13.8 MB/s eta 0:00:00
Collecting tzdata>=2022.1
Using cached tzdata-2023.3-py2.py3-none-any.whl (341 kB)
Collecting pytz>=2020.1
Using cached pytz-2023.3.post1-py2.py3-none-any.whl (502 kB)
Collecting python-dateutil>=2.8.2
Using cached python_dateutil-2.8.2-py2.py3-none-any.whl (247 kB)
Collecting numpy<2,>=1.22.4
Downloading numpy-1.26.2-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (18.2 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 18.2/18.2 MB 13.5 MB/s eta 0:00:00
Collecting uritemplate<5,>=3.0.1
Using cached uritemplate-4.1.1-py2.py3-none-any.whl (10 kB)
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 httplib2<1.dev0,>=0.15.0
Using cached httplib2-0.22.0-py3-none-any.whl (96 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 pillow>=8
Downloading Pillow-10.1.0-cp39-cp39-manylinux_2_28_x86_64.whl (3.6 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 3.6/3.6 MB 15.9 MB/s eta 0:00:00
Collecting pyparsing>=2.3.1
Using cached pyparsing-3.1.1-py3-none-any.whl (103 kB)
Collecting fonttools>=4.22.0
Downloading fonttools-4.46.0-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (4.6 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 4.6/4.6 MB 17.2 MB/s eta 0:00:00
Collecting importlib-resources>=3.2.0
Downloading importlib_resources-6.1.1-py3-none-any.whl (33 kB)
Collecting contourpy>=1.0.1
Downloading contourpy-1.2.0-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (310 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 311.0/311.0 kB 17.4 MB/s eta 0:00:00
Collecting packaging>=20.0
Using cached packaging-23.2-py3-none-any.whl (53 kB)
Collecting kiwisolver>=1.3.1
Downloading kiwisolver-1.4.5-cp39-cp39-manylinux_2_12_x86_64.manylinux2010_x86_64.whl (1.6 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 1.6/1.6 MB 13.5 MB/s eta 0:00:00
Collecting cycler>=0.10
Using cached cycler-0.12.1-py3-none-any.whl (8.3 kB)
Collecting lxml
Downloading lxml-4.9.3-cp39-cp39-manylinux_2_28_x86_64.whl (8.0 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 8.0/8.0 MB 16.0 MB/s eta 0:00:00
Collecting requests>=2.19.0
Using cached requests-2.31.0-py3-none-any.whl (62 kB)
Collecting PyYAML
Downloading PyYAML-6.0.1-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (738 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 738.9/738.9 kB 16.0 MB/s eta 0:00:00
Collecting greenlet!=0.4.17
Downloading greenlet-3.0.2-cp39-cp39-manylinux_2_24_x86_64.manylinux_2_28_x86_64.whl (610 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 610.9/610.9 kB 17.6 MB/s eta 0:00:00
Collecting typing-extensions>=4.2.0
Using cached typing_extensions-4.9.0-py3-none-any.whl (32 kB)
Collecting validators<1,>=0.2
Using cached validators-0.22.0-py3-none-any.whl (26 kB)
Collecting protobuf<5,>=3.20
Using cached protobuf-4.25.1-cp37-abi3-manylinux2014_x86_64.whl (294 kB)
Collecting click<9,>=7.0
Using cached click-8.1.7-py3-none-any.whl (97 kB)
Collecting gitpython!=3.1.19,<4,>=3.0.7
Using cached GitPython-3.1.40-py3-none-any.whl (190 kB)
Collecting rich<14,>=10.14.0
Using cached rich-13.7.0-py3-none-any.whl (240 kB)
Collecting altair<6,>=4.0
Using cached altair-5.2.0-py3-none-any.whl (996 kB)
Collecting importlib-metadata<7,>=1.4
Using cached importlib_metadata-6.11.0-py3-none-any.whl (23 kB)
Collecting pydeck<1,>=0.8.0b4
Using cached pydeck-0.8.1b0-py2.py3-none-any.whl (4.8 MB)
Collecting toml<2,>=0.10.1
Using cached toml-0.10.2-py2.py3-none-any.whl (16 kB)
Collecting watchdog>=2.1.5
Using cached watchdog-3.0.0-py3-none-manylinux2014_x86_64.whl (82 kB)
Collecting tzlocal<6,>=1.1
Using cached tzlocal-5.2-py3-none-any.whl (17 kB)
Collecting blinker<2,>=1.0.0
Using cached blinker-1.7.0-py3-none-any.whl (13 kB)
Collecting tenacity<9,>=8.1.0
Using cached tenacity-8.2.3-py3-none-any.whl (24 kB)
Collecting tornado<7,>=6.0.3
Using cached tornado-6.4-cp38-abi3-manylinux_2_5_x86_64.manylinux1_x86_64.manylinux_2_17_x86_64.manylinux2014_x86_64.whl (435 kB)
Collecting pyarrow>=6.0
Downloading pyarrow-14.0.1-cp39-cp39-manylinux_2_28_x86_64.whl (38.0 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 38.0/38.0 MB 10.8 MB/s eta 0:00:00
Collecting cachetools<6,>=4.0
Using cached cachetools-5.3.2-py3-none-any.whl (9.3 kB)
Collecting jsonschema>=3.0
Using cached jsonschema-4.20.0-py3-none-any.whl (84 kB)
Collecting jinja2
Using cached Jinja2-3.1.2-py3-none-any.whl (133 kB)
Collecting toolz
Using cached toolz-0.12.0-py3-none-any.whl (55 kB)
Collecting gitdb<5,>=4.0.1
Using cached gitdb-4.0.11-py3-none-any.whl (62 kB)
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
Using cached pyasn1_modules-0.3.0-py2.py3-none-any.whl (181 kB)
Collecting rsa<5,>=3.1.4
Using cached rsa-4.9-py3-none-any.whl (34 kB)
Collecting zipp>=0.5
Using cached zipp-3.17.0-py3-none-any.whl (7.4 kB)
Collecting six>=1.5
Using cached six-1.16.0-py2.py3-none-any.whl (11 kB)
Collecting charset-normalizer<4,>=2
Downloading charset_normalizer-3.3.2-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (142 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 142.3/142.3 kB 15.3 MB/s eta 0:00:00
Collecting urllib3<3,>=1.21.1
Using cached urllib3-2.1.0-py3-none-any.whl (104 kB)
Collecting idna<4,>=2.5
Using cached idna-3.6-py3-none-any.whl (61 kB)
Collecting oauthlib>=3.0.0
Using cached oauthlib-3.2.2-py3-none-any.whl (151 kB)
Collecting pygments<3.0.0,>=2.13.0
Using cached pygments-2.17.2-py3-none-any.whl (1.2 MB)
Collecting markdown-it-py>=2.2.0
Using cached markdown_it_py-3.0.0-py3-none-any.whl (87 kB)
Collecting smmap<6,>=3.0.1
Using cached smmap-5.0.1-py3-none-any.whl (24 kB)
Collecting MarkupSafe>=2.0
Downloading MarkupSafe-2.1.3-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (25 kB)
Collecting referencing>=0.28.4
Using cached referencing-0.32.0-py3-none-any.whl (26 kB)
Collecting rpds-py>=0.7.1
Downloading rpds_py-0.13.2-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (1.2 MB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 1.2/1.2 MB 12.2 MB/s eta 0:00:00
Collecting jsonschema-specifications>=2023.03.6
Using cached jsonschema_specifications-2023.11.2-py3-none-any.whl (17 kB)
Collecting attrs>=22.2.0
Using cached attrs-23.1.0-py3-none-any.whl (61 kB)
Collecting mdurl~=0.1
Using cached mdurl-0.1.2-py3-none-any.whl (10.0 kB)
Collecting pyasn1<0.6.0,>=0.4.6
Using cached pyasn1-0.5.1-py2.py3-none-any.whl (84 kB)
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-resources, 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.111.0 google-auth-2.25.2 google-auth-httplib2-0.2.0 google-auth-oauthlib-1.2.0 googleapis-common-protos-1.62.0 greenlet-3.0.2 httplib2-0.22.0 idna-3.6 importlib-metadata-6.11.0 importlib-resources-6.1.1 investorzilla-2.4.2 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
[notice] A new release of pip is available: 23.0.1 -> 23.3.1
[notice] To update, run: pip install --upgrade pip
(env) root@template:~/investorzilla# mkdir myportfolio
(env) root@template:~/investorzilla# cp /root/investorzilla/config_examples/investorzilla.yaml /root/investorzilla/myportfolio/investorzilla.yaml
(env) root@template:~/investorzilla# cd myportfolio
(env) root@template:~/investorzilla/myportfolio# ls
investorzilla.yaml
(env) root@template:~/investorzilla/myportfolio# nano investorzilla.yaml
(env) root@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 21:46:55,863|INFO|investorzilla.datacache.DataCache|No cache for kind=BCBCurrencyConverter and id=USD
2023-12-12 21:46:55,864|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 21:46:55,869|INFO|investorzilla.datacache.DataCache|No cache for kind=BCBMarketIndex and id=IGPM
2023-12-12 21:46:55,870|INFO|investorzilla.datacache.DataCache|No cache for kind=BCBMarketIndex and id=IPCA
2023-12-12 21:46:55,872|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 21:46:55,872|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 21:46:55,874|INFO|investorzilla.datacache.DataCache|No cache for kind=BCBMarketIndex and id=CDI
2023-12-12 21:46:55,877|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 21:46:55,879|INFO|investorzilla.datacache.DataCache|No cache for kind=BCBMarketIndex and id=SELIC
2023-12-12 21:46:55,880|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 21:46:55,882|INFO|investorzilla.datacache.DataCache|No cache for kind=BCBCurrencyConverter and id=EUR
2023-12-12 21:46:55,882|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 21:46:55,886|INFO|investorzilla.datacache.DataCache|No cache for kind=BCBMarketIndex and id=INPC
2023-12-12 21:46:55,886|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__BCBMarketIndex
[SQL:
SELECT *
FROM DataCache__BCBMarketIndex
WHERE
__DataCache_id = 'INPC' AND
__DataCache_time =
(
SELECT DISTINCT __DataCache_time
FROM DataCache__BCBMarketIndex
WHERE __DataCache_id = 'INPC'
ORDER BY __DataCache_time DESC
LIMIT 1
)
]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-12 21:46:55,887|INFO|investorzilla.datacache.DataCache|No cache for kind=YahooMarketIndex and id=^BVSP
2023-12-12 21:46:55,887|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 21:46:57,114|INFO|investorzilla.datacache.DataCache|Set cache to kind=BCBMarketIndex, id=IGPM, time=2023-12-12 21:46:57.112723+00:00
2023-12-12 21:46:57,142|INFO|investorzilla.datacache.DataCache|Set cache to kind=BCBMarketIndex, id=IPCA, time=2023-12-12 21:46:57.138204+00:00
2023-12-12 21:46:57,156|INFO|investorzilla.datacache.DataCache|Set cache to kind=BCBMarketIndex, id=INPC, time=2023-12-12 21:46:57.154943+00:00
2023-12-12 21:46:57,467|INFO|investorzilla.datacache.DataCache|No cache for kind=YahooMarketIndex and id=SPY
2023-12-12 21:46:57,467|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 21:46:57,494|INFO|investorzilla.datacache.DataCache|No cache for kind=YahooMarketIndex and id=IVV
2023-12-12 21:46:57,494|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 21:46:57,495|INFO|investorzilla.datacache.DataCache|No cache for kind=YahooMarketIndex and id=VOO
2023-12-12 21:46:57,495|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 21:46:57,980|INFO|investorzilla.datacache.DataCache|Set cache to kind=BCBMarketIndex, id=SELIC, time=2023-12-12 21:46:57.979598+00:00
2023-12-12 21:46:58,717|INFO|investorzilla.datacache.DataCache|Set cache to kind=BCBMarketIndex, id=CDI, time=2023-12-12 21:46:58.716679+00:00
2023-12-12 21:46:59,947|INFO|investorzilla.datacache.DataCache|No cache for kind=YahooMarketIndex and id=^GSPC
2023-12-12 21:46:59,953|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 21:47:00,367|INFO|investorzilla.datacache.DataCache|No cache for kind=YahooMarketIndex and id=^DJI
2023-12-12 21:47:00,368|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 21:47:14,838|INFO|investorzilla.datacache.DataCache|Set cache to kind=BCBCurrencyConverter, id=USD, time=2023-12-12 21:47:14.837826+00:00
2023-12-12 21:47:19,906|INFO|investorzilla.datacache.DataCache|Set cache to kind=BCBCurrencyConverter, id=EUR, time=2023-12-12 21:47:19.906264+00:00
2023-12-12 21:47:26,213|INFO|investorzilla.datacache.DataCache|No cache for kind=YahooMarketIndex and id=^IXIC
2023-12-12 21:47:26,214|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 21:47:26,266|INFO|investorzilla.datacache.DataCache|No cache for kind=YahooMarketIndex and id=QQQM
2023-12-12 21:47:26,266|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 21:51:18,029|INFO|investorzilla.datacache.DataCache|Set cache to kind=YahooMarketIndex, id=^BVSP, time=2023-12-12 21:51:18.028830+00:00
2023-12-12 21:51:19,447|INFO|investorzilla.datacache.DataCache|Cache empty for kind=YahooMarketIndex and id=QQQ
2023-12-12 21:51:20,092|INFO|investorzilla.datacache.DataCache|Set cache to kind=YahooMarketIndex, id=VOO, time=2023-12-12 21:51:20.091986+00:00
2023-12-12 21:51:20,821|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 21:51:20,821|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 21:51:20,822|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 21:51:20,822|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 21:51:20,827|INFO|investorzilla.datacache.DataCache|Set cache to kind=YahooMarketIndex, id=IVV, time=2023-12-12 21:51:20.827017+00:00
2023-12-12 21:51:20,828|INFO|investorzilla.datacache.DataCache|Set cache to kind=YahooMarketIndex, id=SPY, time=2023-12-12 21:51:20.828275+00:00
2023-12-12 21:51:22,498|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 21:51:22.498073+00:00
2023-12-12 21:51:23,503|INFO|investorzilla.datacache.DataCache|Set cache to kind=YahooMarketIndex, id=^DJI, time=2023-12-12 21:51:23.503373+00:00
2023-12-12 21:51:23,690|INFO|investorzilla.datacache.DataCache|Set cache to kind=YahooMarketIndex, id=^GSPC, time=2023-12-12 21:51:23.689632+00:00
2023-12-12 21:51:29,280|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 21:51:29,282|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 21:51:29,286|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 21:51:29,287|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 21:51:30,608|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 21:51:30.606983+00:00
2023-12-12 21:51:48,202|INFO|investorzilla.datacache.DataCache|Set cache to kind=YahooMarketIndex, id=QQQM, time=2023-12-12 21:51:48.201201+00:00
2023-12-12 21:51:48,931|INFO|investorzilla.datacache.DataCache|Set cache to kind=YahooMarketIndex, id=^IXIC, time=2023-12-12 21:51:48.930594+00:00
2023-12-12 21:55:41,600|INFO|investorzilla.datacache.DataCache|Set cache to kind=YahooMarketIndex, id=QQQ, time=2023-12-12 21:55:41.599539+00:00
2023-12-12 21:55:44.677 `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 21:55:45.174 `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