Incorrect symbol lookup for missing symbol loader

[dbrowne]

[00:04:56] ################------------------------ 306/780 Processing XRAY 2025-11-19T00:29:08.540716Z INFO company_overview:get{params={"symbol": "XRAY"} function=OVERVIEW}: av_client::transport: Successfully parsed response for function: Overview
2025-11-19T00:29:08.553680Z INFO av::commands::load::missing_symbols: Symbol XRAY already exists with SID: -6917529027641068054
2025-11-19T00:29:08.569546Z INFO av::commands::load::missing_symbols: ✓ Found and loaded: XRAY (SID: -6917529027641068054)

Need to ensure this is not a cryptocurrency

[00:04:59] ################------------------------ 309/780 Processing LHX 2025-11-19T00:29:11.293322Z INFO company_overview:get{params={"symbol": "LHX"} function=OVERVIEW}: av_client::transport: Successfully parsed response for function: Overview
2025-11-19T00:29:11.315294Z INFO av::commands::load::missing_symbols: Inserted new symbol: LHX with SID: 374 (type: Common Stock, asset_type: Common Stock)
2025-11-19T00:29:11.328410Z INFO av::commands::load::missing_symbols: ✓ Found and loaded: LHX (SID: 374)
[00:04:59] ################------------------------ 310/780 Processing NOW 2025-11-19T00:29:12.225901Z INFO company_overview:get{params={"symbol": "NOW"} function=OVERVIEW}: av_client::transport: Successfully parsed response for function: Overview
2025-11-19T00:29:12.238486Z INFO av::commands::load::missing_symbols: Symbol NOW already exists with SID: -6917529027641078295
2025-11-19T00:29:12.254100Z INFO av::commands::load::missing_symbols: ✓ Found and loaded: NOW (SID: -6917529027641078295)

[dbrowne]

Need to add checks to the db lookup.
XRAY is both a crypotcurrency and and equity

{
"bestMatches": [
{
"1. symbol": "XRAY",
"2. name": "DENTSPLY Sirona Inc",
"3. type": "Equity",
"4. region": "United States",
"5. marketOpen": "09:30",
"6. marketClose": "16:00",
"7. timezone": "UTC-04",
"8. currency": "USD",
"9. matchScore": "1.0000"
},
{
"1. symbol": "XRAY34.SAO",
"2. name": "DENTSPLY SIRONA Inc.",
"3. type": "Equity",
"4. region": "Brazil/Sao Paolo",
"5. marketOpen": "10:00",
"6. marketClose": "17:30",
"7. timezone": "UTC-03",
"8. currency": "BRL",
"9. matchScore": "0.6154"
}
]
}
sid | symbol | priority | name | sec_type | region | currency | overview | intraday | summary | c_time | m_time
----------------------+--------+----------+-------------+----------------+--------+----------+----------+----------+---------+-------------------------------+-------------------------------
-6917529027641068054 | XRAY | 9999999 | Ray Network | Cryptocurrency | Global | USD | f | f | f | 2025-11-17 21:47:41.240266+00 | 2025-11-17 21:47:41.240266+00
(1 row)

Xray was found without a check for the sec_type