2025-02-02 12:20:34,381 - INFO - Database connection established
2025-02-02 12:20:34,429 - INFO - Database tables verified successfully
2025-02-02 12:20:34,430 - INFO - Loaded 30 unique commodities
2025-02-02 12:20:34,430 - INFO - Initialized CommodityCollector with 30 unique commodities
2025-02-02 12:20:34,432 - INFO - Attempting to initialize 30 new commodities
2025-02-02 12:20:34,452 - INFO - Total active commodities in database: 30
2025-02-02 12:20:34,455 - INFO - Initial statistics: {'total_commodities': 30, 'total_prices': 30, 'earliest_date': None, 'latest_date': None, 'commodities_with_prices': 0}
2025-02-02 12:20:34,456 - INFO - Found 30 active commodities to update
2025-02-02 12:20:35,525 - INFO - Retrieved 26 historical prices for ALIUSD
2025-02-02 12:20:35,536 - INFO - Updated 26 records for ALIUSD
2025-02-02 12:20:35,538 - INFO - Successfully updated 26 complete day records for ALIUSD
2025-02-02 12:20:36,602 - INFO - Retrieved 26 historical prices for BZUSD
2025-02-02 12:20:36,618 - INFO - Updated 26 records for BZUSD
2025-02-02 12:20:36,620 - INFO - Successfully updated 26 complete day records for BZUSD
2025-02-02 12:20:38,585 - INFO - Retrieved 22 historical prices for CCUSD
2025-02-02 12:20:38,601 - INFO - Updated 22 records for CCUSD
2025-02-02 12:20:38,603 - INFO - Successfully updated 22 complete day records for CCUSD
2025-02-02 12:20:39,681 - INFO - Retrieved 26 historical prices for CLUSD
2025-02-02 12:20:39,705 - INFO - Updated 26 records for CLUSD
2025-02-02 12:20:39,710 - INFO - Successfully updated 26 complete day records for CLUSD
2025-02-02 12:20:40,788 - INFO - Retrieved 25 historical prices for CTUSX
2025-02-02 12:20:40,813 - INFO - Updated 25 records for CTUSX
2025-02-02 12:20:40,818 - INFO - Successfully updated 25 complete day records for CTUSX
2025-02-02 12:20:41,892 - INFO - Retrieved 25 historical prices for DCUSD
2025-02-02 12:20:41,916 - INFO - Updated 25 records for DCUSD
2025-02-02 12:20:41,920 - INFO - Successfully updated 25 complete day records for DCUSD
2025-02-02 12:20:42,996 - INFO - Retrieved 26 historical prices for GCUSD
2025-02-02 12:20:43,020 - INFO - Updated 26 records for GCUSD
2025-02-02 12:20:43,024 - INFO - Successfully updated 26 complete day records for GCUSD
2025-02-02 12:20:44,100 - INFO - Retrieved 21 historical prices for GFUSX
2025-02-02 12:20:44,112 - INFO - Updated 21 records for GFUSX
2025-02-02 12:20:44,116 - INFO - Successfully updated 21 complete day records for GFUSX
2025-02-02 12:20:45,375 - INFO - Retrieved 21 historical prices for HEUSX
2025-02-02 12:20:45,397 - INFO - Updated 21 records for HEUSX
2025-02-02 12:20:45,401 - INFO - Successfully updated 21 complete day records for HEUSX
2025-02-02 12:20:46,476 - INFO - Retrieved 26 historical prices for HGUSD
2025-02-02 12:20:46,500 - INFO - Updated 26 records for HGUSD
2025-02-02 12:20:46,504 - INFO - Successfully updated 26 complete day records for HGUSD
2025-02-02 12:20:47,582 - INFO - Retrieved 26 historical prices for HOUSD
2025-02-02 12:20:47,606 - INFO - Updated 26 records for HOUSD
2025-02-02 12:20:47,610 - INFO - Successfully updated 26 complete day records for HOUSD
2025-02-02 12:20:48,766 - INFO - Retrieved 22 historical prices for KCUSX
2025-02-02 12:20:48,788 - INFO - Updated 22 records for KCUSX
2025-02-02 12:20:48,793 - INFO - Successfully updated 22 complete day records for KCUSX
2025-02-02 12:20:49,913 - INFO - Retrieved 25 historical prices for KEUSX
2025-02-02 12:20:49,927 - INFO - Updated 25 records for KEUSX
2025-02-02 12:20:49,931 - INFO - Successfully updated 25 complete day records for KEUSX
2025-02-02 12:20:51,006 - INFO - Retrieved 21 historical prices for LBUSD
2025-02-02 12:20:51,028 - INFO - Updated 21 records for LBUSD
2025-02-02 12:20:51,031 - INFO - Successfully updated 21 complete day records for LBUSD
2025-02-02 12:20:52,107 - INFO - Retrieved 21 historical prices for LEUSX
2025-02-02 12:20:52,127 - INFO - Updated 21 records for LEUSX
2025-02-02 12:20:52,130 - INFO - Successfully updated 21 complete day records for LEUSX
2025-02-02 12:20:53,210 - INFO - Retrieved 26 historical prices for MGCUSD
2025-02-02 12:20:53,232 - INFO - Updated 26 records for MGCUSD
2025-02-02 12:20:53,236 - INFO - Successfully updated 26 complete day records for MGCUSD
2025-02-02 12:20:54,317 - INFO - Retrieved 26 historical prices for NGUSD
2025-02-02 12:20:54,332 - INFO - Updated 26 records for NGUSD
2025-02-02 12:20:54,336 - INFO - Successfully updated 26 complete day records for NGUSD
2025-02-02 12:20:55,413 - INFO - Retrieved 22 historical prices for OJUSX
2025-02-02 12:20:55,426 - INFO - Updated 22 records for OJUSX
2025-02-02 12:20:55,430 - INFO - Successfully updated 22 complete day records for OJUSX
2025-02-02 12:20:56,914 - INFO - Retrieved 26 historical prices for PAUSD
2025-02-02 12:20:56,939 - INFO - Updated 26 records for PAUSD
2025-02-02 12:20:56,943 - INFO - Successfully updated 26 complete day records for PAUSD
2025-02-02 12:20:58,114 - INFO - Retrieved 26 historical prices for PLUSD
2025-02-02 12:20:58,138 - INFO - Updated 26 records for PLUSD
2025-02-02 12:20:58,142 - INFO - Successfully updated 26 complete day records for PLUSD
2025-02-02 12:20:59,219 - INFO - Retrieved 26 historical prices for RBUSD
2025-02-02 12:20:59,244 - INFO - Updated 26 records for RBUSD
2025-02-02 12:20:59,249 - INFO - Successfully updated 26 complete day records for RBUSD
2025-02-02 12:21:00,327 - INFO - Retrieved 22 historical prices for SBUSX
2025-02-02 12:21:00,350 - INFO - Updated 22 records for SBUSX
2025-02-02 12:21:00,355 - INFO - Successfully updated 22 complete day records for SBUSX
2025-02-02 12:21:01,433 - INFO - Retrieved 26 historical prices for SILUSD
2025-02-02 12:21:01,447 - INFO - Updated 26 records for SILUSD
2025-02-02 12:21:01,452 - INFO - Successfully updated 26 complete day records for SILUSD
2025-02-02 12:21:02,541 - INFO - Retrieved 26 historical prices for SIUSD
2025-02-02 12:21:02,565 - INFO - Updated 26 records for SIUSD
2025-02-02 12:21:02,570 - INFO - Successfully updated 26 complete day records for SIUSD
2025-02-02 12:21:03,647 - INFO - Retrieved 25 historical prices for ZCUSX
2025-02-02 12:21:03,672 - INFO - Updated 25 records for ZCUSX
2025-02-02 12:21:03,676 - INFO - Successfully updated 25 complete day records for ZCUSX
2025-02-02 12:21:04,754 - INFO - Retrieved 25 historical prices for ZLUSX
2025-02-02 12:21:04,778 - INFO - Updated 25 records for ZLUSX
2025-02-02 12:21:04,782 - INFO - Successfully updated 25 complete day records for ZLUSX
2025-02-02 12:21:05,856 - INFO - Retrieved 25 historical prices for ZMUSD
2025-02-02 12:21:05,880 - INFO - Updated 25 records for ZMUSD
2025-02-02 12:21:05,885 - INFO - Successfully updated 25 complete day records for ZMUSD
2025-02-02 12:21:06,962 - INFO - Retrieved 25 historical prices for ZOUSX
2025-02-02 12:21:06,976 - INFO - Updated 25 records for ZOUSX
2025-02-02 12:21:06,980 - INFO - Successfully updated 25 complete day records for ZOUSX
2025-02-02 12:21:08,056 - INFO - Retrieved 25 historical prices for ZRUSD
2025-02-02 12:21:08,080 - INFO - Updated 25 records for ZRUSD
2025-02-02 12:21:08,084 - INFO - Successfully updated 25 complete day records for ZRUSD
2025-02-02 12:21:09,690 - INFO - Retrieved 25 historical prices for ZSUSX
2025-02-02 12:21:09,715 - INFO - Updated 25 records for ZSUSX
2025-02-02 12:21:09,719 - INFO - Successfully updated 25 complete day records for ZSUSX
2025-02-02 12:21:09,725 - INFO - Final statistics: {'total_commodities': 30, 'total_prices': 735, 'earliest_date': datetime.date(2025, 1, 2), 'latest_date': datetime.date(2025, 1, 31), 'commodities_with_prices': 30}
2025-02-02 12:21:09,726 - INFO - Database update completed successfully