=========================================================================
2025-05-19 17:50:26 Mon START TASK.01 IOOppi_data update_data
=========================================================================
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-19 17:50:28,611 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3304 2025-05-15 3189.89
3305 2025-05-16 3184.22
3306 2025-05-17 3184.22
3307 2025-05-18 3184.22
3308 2025-05-19 3158.22
2025-05-19 17:50:28,699 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3306 2025-05-17 3184.22 ... 2025-05-19 17:50:28.691633 2025-05-19 17:50:28.692064
3307 2025-05-18 3184.22 ... 2025-05-19 17:50:28.691633 2025-05-19 17:50:28.692064
3308 2025-05-19 3158.22 ... 2025-05-19 17:50:28.691633 2025-05-19 17:50:28.692064
[3 rows x 5 columns]
2025-05-19 17:50:28,722 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-05-19 17:50:28,727 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3304 2025-05-15 3189.89
3305 2025-05-16 3184.22
3306 2025-05-17 3184.22
3307 2025-05-18 3184.22
3308 2025-05-19 3158.22
2025-05-19 17:50:28,793 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3309 2025-05-17 3184.22 ... 2025-05-19 17:50:28.785826 2025-05-19 17:50:28.786208
3310 2025-05-18 3184.22 ... 2025-05-19 17:50:28.785826 2025-05-19 17:50:28.786208
3311 2025-05-19 3158.22 ... 2025-05-19 17:50:28.785826 2025-05-19 17:50:28.786208
[3 rows x 5 columns]
2025-05-19 17:50:28,813 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-19 17:50:29,443 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3525 2025-05-15 2426.25
3526 2025-05-16 2426.25
3527 2025-05-17 2426.25
3528 2025-05-18 2426.25
3529 2025-05-19 2362.50
2025-05-19 17:50:29,513 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3527 2025-05-17 2426.25 ... 2025-05-19 17:50:29.505960 2025-05-19 17:50:29.506346
3528 2025-05-18 2426.25 ... 2025-05-19 17:50:29.505960 2025-05-19 17:50:29.506346
3529 2025-05-19 2362.50 ... 2025-05-19 17:50:29.505960 2025-05-19 17:50:29.506346
[3 rows x 5 columns]
2025-05-19 17:50:29,533 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-05-19 17:50:29,538 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3525 2025-05-15 2426.25
3526 2025-05-16 2426.25
3527 2025-05-17 2426.25
3528 2025-05-18 2426.25
3529 2025-05-19 2362.50
2025-05-19 17:50:29,608 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3531 2025-05-17 2426.25 ... 2025-05-19 17:50:29.600754 2025-05-19 17:50:29.601165
3532 2025-05-18 2426.25 ... 2025-05-19 17:50:29.600754 2025-05-19 17:50:29.601165
3533 2025-05-19 2362.50 ... 2025-05-19 17:50:29.600754 2025-05-19 17:50:29.601165
[3 rows x 5 columns]
2025-05-19 17:50:29,628 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-19 17:50:30,204 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
865 2025-05-15 4991.66
866 2025-05-16 5007.50
867 2025-05-17 5007.50
868 2025-05-18 5007.50
869 2025-05-19 4993.75
2025-05-19 17:50:30,240 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
867 2025-05-17 5007.50 ... 2025-05-19 17:50:30.233285 2025-05-19 17:50:30.233663
868 2025-05-18 5007.50 ... 2025-05-19 17:50:30.233285 2025-05-19 17:50:30.233663
869 2025-05-19 4993.75 ... 2025-05-19 17:50:30.233285 2025-05-19 17:50:30.233663
[3 rows x 5 columns]
2025-05-19 17:50:30,260 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-05-19 17:50:30,265 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
865 2025-05-15 4991.66
866 2025-05-16 5007.50
867 2025-05-17 5007.50
868 2025-05-18 5007.50
869 2025-05-19 4993.75
2025-05-19 17:50:30,300 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
867 2025-05-17 5007.50 ... 2025-05-19 17:50:30.293210 2025-05-19 17:50:30.293568
868 2025-05-18 5007.50 ... 2025-05-19 17:50:30.293210 2025-05-19 17:50:30.293568
869 2025-05-19 4993.75 ... 2025-05-19 17:50:30.293210 2025-05-19 17:50:30.293568
[3 rows x 5 columns]
2025-05-19 17:50:30,320 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-19 17:50:30,854 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3744 2025-05-15 14838.33
3745 2025-05-16 14658.33
3746 2025-05-17 14658.33
3747 2025-05-18 14658.33
3748 2025-05-19 14758.33
2025-05-19 17:50:30,926 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3746 2025-05-17 ... 2025-05-19 17:50:30.919849
3747 2025-05-18 ... 2025-05-19 17:50:30.919849
3748 2025-05-19 ... 2025-05-19 17:50:30.919849
[3 rows x 5 columns]
2025-05-19 17:50:30,945 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-05-19 17:50:30,951 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3744 2025-05-15 14838.33
3745 2025-05-16 14658.33
3746 2025-05-17 14658.33
3747 2025-05-18 14658.33
3748 2025-05-19 14758.33
2025-05-19 17:50:31,022 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3749 2025-05-17 ... 2025-05-19 17:50:31.016327
3750 2025-05-18 ... 2025-05-19 17:50:31.016327
3751 2025-05-19 ... 2025-05-19 17:50:31.016327
[3 rows x 5 columns]
2025-05-19 17:50:31,041 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-19 17:50:31,686 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3076 2025-05-15 794.44
3077 2025-05-16 787.33
3078 2025-05-17 784.44
3079 2025-05-18 784.44
3080 2025-05-19 779.44
2025-05-19 17:50:31,753 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3078 2025-05-17 784.44 ... 2025-05-19 17:50:31.746498 2025-05-19 17:50:31.746943
3079 2025-05-18 784.44 ... 2025-05-19 17:50:31.746498 2025-05-19 17:50:31.746943
3080 2025-05-19 779.44 ... 2025-05-19 17:50:31.746498 2025-05-19 17:50:31.746943
[3 rows x 5 columns]
2025-05-19 17:50:31,773 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-05-19 17:50:31,779 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3076 2025-05-15 794.44
3077 2025-05-16 787.33
3078 2025-05-17 784.44
3079 2025-05-18 784.44
3080 2025-05-19 779.44
2025-05-19 17:50:31,844 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3081 2025-05-17 784.44 ... 2025-05-19 17:50:31.836574 2025-05-19 17:50:31.837007
3082 2025-05-18 784.44 ... 2025-05-19 17:50:31.836574 2025-05-19 17:50:31.837007
3083 2025-05-19 779.44 ... 2025-05-19 17:50:31.836574 2025-05-19 17:50:31.837007
[3 rows x 5 columns]
2025-05-19 17:50:31,864 - IOOppi_data - INFO : save diff data to db: IOOppi_i_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-19 17:50:32,399 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3279 2025-05-15 1188.0
3280 2025-05-16 1168.0
3281 2025-05-17 1168.0
3282 2025-05-18 1168.0
3283 2025-05-19 1168.0
2025-05-19 17:50:32,467 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3281 2025-05-17 1168.0 ... 2025-05-19 17:50:32.459437 2025-05-19 17:50:32.459842
3282 2025-05-18 1168.0 ... 2025-05-19 17:50:32.459437 2025-05-19 17:50:32.459842
3283 2025-05-19 1168.0 ... 2025-05-19 17:50:32.459437 2025-05-19 17:50:32.459842
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-19 17:50:34,481 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-05-19 17:50:34.473928
21 2013-01-04 ... 2025-05-19 17:50:34.473928
54 2013-02-27 ... 2025-05-19 17:50:34.473928
60 2013-03-07 ... 2025-05-19 17:50:34.473928
61 2013-03-08 ... 2025-05-19 17:50:34.473928
[5 rows x 6 columns]
2025-05-19 17:50:34,641 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3279 2025-05-15 1188.0
3280 2025-05-16 1168.0
3281 2025-05-17 1168.0
3282 2025-05-18 1168.0
3283 2025-05-19 1168.0
2025-05-19 17:50:34,708 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3285 2025-05-17 1168.0 ... 2025-05-19 17:50:34.700072 2025-05-19 17:50:34.700454
3286 2025-05-18 1168.0 ... 2025-05-19 17:50:34.700072 2025-05-19 17:50:34.700454
3287 2025-05-19 1168.0 ... 2025-05-19 17:50:34.700072 2025-05-19 17:50:34.700454
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-19 17:50:36,710 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-05-19 17:50:36.702584
21 2013-01-04 ... 2025-05-19 17:50:36.702584
54 2013-02-27 ... 2025-05-19 17:50:36.702584
60 2013-03-07 ... 2025-05-19 17:50:36.702584
61 2013-03-08 ... 2025-05-19 17:50:36.702584
[5 rows x 6 columns]
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-19 17:50:37,589 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1624 2025-05-15 8270.0
1625 2025-05-16 8270.0
1626 2025-05-17 8270.0
1627 2025-05-18 8270.0
1628 2025-05-19 8224.0
2025-05-19 17:50:37,635 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1626 2025-05-17 8270.0 ... 2025-05-19 17:50:37.628391 2025-05-19 17:50:37.628795
1627 2025-05-18 8270.0 ... 2025-05-19 17:50:37.628391 2025-05-19 17:50:37.628795
1628 2025-05-19 8224.0 ... 2025-05-19 17:50:37.628391 2025-05-19 17:50:37.628795
[3 rows x 5 columns]
2025-05-19 17:50:37,655 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-05-19 17:50:37,660 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1624 2025-05-15 8270.0
1625 2025-05-16 8270.0
1626 2025-05-17 8270.0
1627 2025-05-18 8270.0
1628 2025-05-19 8224.0
2025-05-19 17:50:37,706 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1629 2025-05-17 8270.0 ... 2025-05-19 17:50:37.699085 2025-05-19 17:50:37.699444
1630 2025-05-18 8270.0 ... 2025-05-19 17:50:37.699085 2025-05-19 17:50:37.699444
1631 2025-05-19 8224.0 ... 2025-05-19 17:50:37.699085 2025-05-19 17:50:37.699444
[3 rows x 5 columns]
2025-05-19 17:50:37,726 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-19 17:50:38,285 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3735 2025-05-15 6145.0
3736 2025-05-16 6145.0
3737 2025-05-17 6145.0
3738 2025-05-18 6145.0
3739 2025-05-19 6145.0
2025-05-19 17:50:38,359 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3737 2025-05-17 6145.0 ... 2025-05-19 17:50:38.351798 2025-05-19 17:50:38.352190
3738 2025-05-18 6145.0 ... 2025-05-19 17:50:38.351798 2025-05-19 17:50:38.352190
3739 2025-05-19 6145.0 ... 2025-05-19 17:50:38.351798 2025-05-19 17:50:38.352190
[3 rows x 5 columns]
2025-05-19 17:50:38,378 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-05-19 17:50:38,384 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3735 2025-05-15 6145.0
3736 2025-05-16 6145.0
3737 2025-05-17 6145.0
3738 2025-05-18 6145.0
3739 2025-05-19 6145.0
2025-05-19 17:50:38,455 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3741 2025-05-17 6145.0 ... 2025-05-19 17:50:38.448107 2025-05-19 17:50:38.448476
3742 2025-05-18 6145.0 ... 2025-05-19 17:50:38.448107 2025-05-19 17:50:38.448476
3743 2025-05-19 6145.0 ... 2025-05-19 17:50:38.448107 2025-05-19 17:50:38.448476
[3 rows x 5 columns]
2025-05-19 17:50:38,474 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-19 17:50:39,002 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1625 2025-05-15 13255.0
1626 2025-05-16 13300.0
1627 2025-05-17 13300.0
1628 2025-05-18 13300.0
1629 2025-05-19 13287.5
2025-05-19 17:50:39,048 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1627 2025-05-17 13300.0 ... 2025-05-19 17:50:39.041206 2025-05-19 17:50:39.041584
1628 2025-05-18 13300.0 ... 2025-05-19 17:50:39.041206 2025-05-19 17:50:39.041584
1629 2025-05-19 13287.5 ... 2025-05-19 17:50:39.041206 2025-05-19 17:50:39.041584
[3 rows x 5 columns]
2025-05-19 17:50:39,067 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-05-19 17:50:39,072 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1625 2025-05-15 13255.0
1626 2025-05-16 13300.0
1627 2025-05-17 13300.0
1628 2025-05-18 13300.0
1629 2025-05-19 13287.5
2025-05-19 17:50:39,118 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1630 2025-05-17 13300.0 ... 2025-05-19 17:50:39.111529 2025-05-19 17:50:39.111917
1631 2025-05-18 13300.0 ... 2025-05-19 17:50:39.111529 2025-05-19 17:50:39.111917
1632 2025-05-19 13287.5 ... 2025-05-19 17:50:39.111529 2025-05-19 17:50:39.111917
[3 rows x 5 columns]
2025-05-19 17:50:39,139 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-19 17:50:39,690 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3135 2025-05-15 9395.00
3136 2025-05-16 9378.33
3137 2025-05-17 9378.33
3138 2025-05-18 9378.33
3139 2025-05-19 9475.00
2025-05-19 17:50:39,753 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date value ... created_at updated_at
3137 2025-05-17 9378.33 ... 2025-05-19 17:50:39.746215 2025-05-19 17:50:39.746592
3138 2025-05-18 9378.33 ... 2025-05-19 17:50:39.746215 2025-05-19 17:50:39.746592
3139 2025-05-19 9475.00 ... 2025-05-19 17:50:39.746215 2025-05-19 17:50:39.746592
[3 rows x 5 columns]
2025-05-19 17:50:39,772 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-05-19 17:50:39,777 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3135 2025-05-15 9395.00
3136 2025-05-16 9378.33
3137 2025-05-17 9378.33
3138 2025-05-18 9378.33
3139 2025-05-19 9475.00
2025-05-19 17:50:39,842 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date value ... created_at updated_at
3141 2025-05-17 9378.33 ... 2025-05-19 17:50:39.835252 2025-05-19 17:50:39.835628
3142 2025-05-18 9378.33 ... 2025-05-19 17:50:39.835252 2025-05-19 17:50:39.835628
3143 2025-05-19 9475.00 ... 2025-05-19 17:50:39.835252 2025-05-19 17:50:39.835628
[3 rows x 5 columns]
2025-05-19 17:50:39,861 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-19 17:50:40,466 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3258 2025-05-15 2476.67
3259 2025-05-16 2476.67
3260 2025-05-17 2476.67
3261 2025-05-18 2476.67
3262 2025-05-19 2471.67
2025-05-19 17:50:40,532 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3260 2025-05-17 2476.67 ... 2025-05-19 17:50:40.524969 2025-05-19 17:50:40.525346
3261 2025-05-18 2476.67 ... 2025-05-19 17:50:40.524969 2025-05-19 17:50:40.525346
3262 2025-05-19 2471.67 ... 2025-05-19 17:50:40.524969 2025-05-19 17:50:40.525346
[3 rows x 5 columns]
2025-05-19 17:50:40,551 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-05-19 17:50:40,557 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3258 2025-05-15 2476.67
3259 2025-05-16 2476.67
3260 2025-05-17 2476.67
3261 2025-05-18 2476.67
3262 2025-05-19 2471.67
2025-05-19 17:50:40,621 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3264 2025-05-17 2476.67 ... 2025-05-19 17:50:40.614455 2025-05-19 17:50:40.614837
3265 2025-05-18 2476.67 ... 2025-05-19 17:50:40.614455 2025-05-19 17:50:40.614837
3266 2025-05-19 2471.67 ... 2025-05-19 17:50:40.614455 2025-05-19 17:50:40.614837
[3 rows x 5 columns]
2025-05-19 17:50:40,640 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-19 17:50:41,126 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1462 2025-05-15 1462.5
1463 2025-05-16 1462.5
1464 2025-05-17 1462.5
1465 2025-05-18 1462.5
1466 2025-05-19 1462.5
2025-05-19 17:50:41,170 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1464 2025-05-17 1462.5 ... 2025-05-19 17:50:41.163447 2025-05-19 17:50:41.163849
1465 2025-05-18 1462.5 ... 2025-05-19 17:50:41.163447 2025-05-19 17:50:41.163849
1466 2025-05-19 1462.5 ... 2025-05-19 17:50:41.163447 2025-05-19 17:50:41.163849
[3 rows x 5 columns]
2025-05-19 17:50:41,189 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-05-19 17:50:41,194 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1462 2025-05-15 1462.5
1463 2025-05-16 1462.5
1464 2025-05-17 1462.5
1465 2025-05-18 1462.5
1466 2025-05-19 1462.5
2025-05-19 17:50:41,238 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1468 2025-05-17 1462.5 ... 2025-05-19 17:50:41.231569 2025-05-19 17:50:41.231963
1469 2025-05-18 1462.5 ... 2025-05-19 17:50:41.231569 2025-05-19 17:50:41.231963
1470 2025-05-19 1462.5 ... 2025-05-19 17:50:41.231569 2025-05-19 17:50:41.231963
[3 rows x 5 columns]
2025-05-19 17:50:41,257 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-19 17:50:41,810 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1375 2025-05-15 6688.96
1376 2025-05-16 6727.50
1377 2025-05-17 6727.50
1378 2025-05-18 6727.50
1379 2025-05-19 6701.04
2025-05-19 17:50:41,853 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1377 2025-05-17 6727.50 ... 2025-05-19 17:50:41.845579 2025-05-19 17:50:41.845981
1378 2025-05-18 6727.50 ... 2025-05-19 17:50:41.845579 2025-05-19 17:50:41.845981
1379 2025-05-19 6701.04 ... 2025-05-19 17:50:41.845579 2025-05-19 17:50:41.845981
[3 rows x 5 columns]
2025-05-19 17:50:41,872 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-05-19 17:50:41,877 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1375 2025-05-15 6688.96
1376 2025-05-16 6727.50
1377 2025-05-17 6727.50
1378 2025-05-18 6727.50
1379 2025-05-19 6701.04
2025-05-19 17:50:41,921 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1381 2025-05-17 6727.50 ... 2025-05-19 17:50:41.913962 2025-05-19 17:50:41.914327
1382 2025-05-18 6727.50 ... 2025-05-19 17:50:41.913962 2025-05-19 17:50:41.914327
1383 2025-05-19 6701.04 ... 2025-05-19 17:50:41.913962 2025-05-19 17:50:41.914327
[3 rows x 5 columns]
2025-05-19 17:50:41,940 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-19 17:50:42,668 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3748 2025-05-15 3074.0
3749 2025-05-16 2988.0
3750 2025-05-17 2988.0
3751 2025-05-18 2988.0
3752 2025-05-19 2972.0
2025-05-19 17:50:42,740 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3750 2025-05-17 2988.0 ... 2025-05-19 17:50:42.732868 2025-05-19 17:50:42.733255
3751 2025-05-18 2988.0 ... 2025-05-19 17:50:42.732868 2025-05-19 17:50:42.733255
3752 2025-05-19 2972.0 ... 2025-05-19 17:50:42.732868 2025-05-19 17:50:42.733255
[3 rows x 5 columns]
2025-05-19 17:50:42,760 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-05-19 17:50:42,766 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3748 2025-05-15 3074.0
3749 2025-05-16 2988.0
3750 2025-05-17 2988.0
3751 2025-05-18 2988.0
3752 2025-05-19 2972.0
2025-05-19 17:50:42,839 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3753 2025-05-17 2988.0 ... 2025-05-19 17:50:42.831110 2025-05-19 17:50:42.831489
3754 2025-05-18 2988.0 ... 2025-05-19 17:50:42.831110 2025-05-19 17:50:42.831489
3755 2025-05-19 2972.0 ... 2025-05-19 17:50:42.831110 2025-05-19 17:50:42.831489
[3 rows x 5 columns]
2025-05-19 17:50:42,858 - IOOppi_data - INFO : save diff data to db: IOOppi_m_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-19 17:50:43,523 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3518 2025-05-15 8054.0
3519 2025-05-16 8024.0
3520 2025-05-17 8024.0
3521 2025-05-18 8024.0
3522 2025-05-19 8044.0
2025-05-19 17:50:43,593 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3520 2025-05-17 8024.0 ... 2025-05-19 17:50:43.585862 2025-05-19 17:50:43.586249
3521 2025-05-18 8024.0 ... 2025-05-19 17:50:43.585862 2025-05-19 17:50:43.586249
3522 2025-05-19 8044.0 ... 2025-05-19 17:50:43.585862 2025-05-19 17:50:43.586249
[3 rows x 5 columns]
2025-05-19 17:50:43,612 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-05-19 17:50:43,618 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3518 2025-05-15 8054.0
3519 2025-05-16 8024.0
3520 2025-05-17 8024.0
3521 2025-05-18 8024.0
3522 2025-05-19 8044.0
2025-05-19 17:50:43,690 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3523 2025-05-17 8024.0 ... 2025-05-19 17:50:43.683108 2025-05-19 17:50:43.683494
3524 2025-05-18 8024.0 ... 2025-05-19 17:50:43.683108 2025-05-19 17:50:43.683494
3525 2025-05-19 8044.0 ... 2025-05-19 17:50:43.683108 2025-05-19 17:50:43.683494
[3 rows x 5 columns]
2025-05-19 17:50:43,711 - IOOppi_data - INFO : save diff data to db: IOOppi_y_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-19 17:50:44,280 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3484 2025-05-15 4255.0
3485 2025-05-16 4255.0
3486 2025-05-17 4255.0
3487 2025-05-18 4255.0
3488 2025-05-19 4255.0
2025-05-19 17:50:44,355 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3486 2025-05-17 4255.0 ... 2025-05-19 17:50:44.347835 2025-05-19 17:50:44.348226
3487 2025-05-18 4255.0 ... 2025-05-19 17:50:44.347835 2025-05-19 17:50:44.348226
3488 2025-05-19 4255.0 ... 2025-05-19 17:50:44.347835 2025-05-19 17:50:44.348226
[3 rows x 5 columns]
2025-05-19 17:50:44,375 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-05-19 17:50:44,382 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3484 2025-05-15 4255.0
3485 2025-05-16 4255.0
3486 2025-05-17 4255.0
3487 2025-05-18 4255.0
3488 2025-05-19 4255.0
2025-05-19 17:50:44,453 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3489 2025-05-17 4255.0 ... 2025-05-19 17:50:44.445561 2025-05-19 17:50:44.445980
3490 2025-05-18 4255.0 ... 2025-05-19 17:50:44.445561 2025-05-19 17:50:44.445980
3491 2025-05-19 4255.0 ... 2025-05-19 17:50:44.445561 2025-05-19 17:50:44.445980
[3 rows x 5 columns]
2025-05-19 17:50:44,472 - IOOppi_data - INFO : save diff data to db: IOOppi_a_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-19 17:50:45,072 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2861 2025-05-15 5424.29
2862 2025-05-16 5440.00
2863 2025-05-17 5440.00
2864 2025-05-18 5440.00
2865 2025-05-19 5435.71
2025-05-19 17:50:45,133 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2863 2025-05-17 5440.00 ... 2025-05-19 17:50:45.125941 2025-05-19 17:50:45.126324
2864 2025-05-18 5440.00 ... 2025-05-19 17:50:45.125941 2025-05-19 17:50:45.126324
2865 2025-05-19 5435.71 ... 2025-05-19 17:50:45.125941 2025-05-19 17:50:45.126324
[3 rows x 5 columns]
2025-05-19 17:50:45,152 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-05-19 17:50:45,157 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2861 2025-05-15 5424.29
2862 2025-05-16 5440.00
2863 2025-05-17 5440.00
2864 2025-05-18 5440.00
2865 2025-05-19 5435.71
2025-05-19 17:50:45,218 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2867 2025-05-17 5440.00 ... 2025-05-19 17:50:45.211464 2025-05-19 17:50:45.211863
2868 2025-05-18 5440.00 ... 2025-05-19 17:50:45.211464 2025-05-19 17:50:45.211863
2869 2025-05-19 5435.71 ... 2025-05-19 17:50:45.211464 2025-05-19 17:50:45.211863
[3 rows x 5 columns]
2025-05-19 17:50:45,238 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-19 17:50:45,734 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3061 2025-05-15 3375.0
3062 2025-05-16 3375.0
3063 2025-05-17 3375.0
3064 2025-05-18 3375.0
3065 2025-05-19 3290.0
2025-05-19 17:50:45,798 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3063 2025-05-17 3375.0 ... 2025-05-19 17:50:45.791005 2025-05-19 17:50:45.791380
3064 2025-05-18 3375.0 ... 2025-05-19 17:50:45.791005 2025-05-19 17:50:45.791380
3065 2025-05-19 3290.0 ... 2025-05-19 17:50:45.791005 2025-05-19 17:50:45.791380
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-19 17:50:45,949 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-05-19 17:50:45.941357
458 2015-09-21 ... 2025-05-19 17:50:45.941357
549 2016-02-03 ... 2025-05-19 17:50:45.941357
693 2016-09-05 ... 2025-05-19 17:50:45.941357
696 2016-09-08 ... 2025-05-19 17:50:45.941357
[5 rows x 6 columns]
2025-05-19 17:50:45,979 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3061 2025-05-15 3375.0
3062 2025-05-16 3375.0
3063 2025-05-17 3375.0
3064 2025-05-18 3375.0
3065 2025-05-19 3290.0
2025-05-19 17:50:46,043 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3066 2025-05-17 3375.0 ... 2025-05-19 17:50:46.035847 2025-05-19 17:50:46.036291
3067 2025-05-18 3375.0 ... 2025-05-19 17:50:46.035847 2025-05-19 17:50:46.036291
3068 2025-05-19 3290.0 ... 2025-05-19 17:50:46.035847 2025-05-19 17:50:46.036291
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-19 17:50:46,195 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-05-19 17:50:46.187286
458 2015-09-21 ... 2025-05-19 17:50:46.187286
549 2016-02-03 ... 2025-05-19 17:50:46.187286
693 2016-09-05 ... 2025-05-19 17:50:46.187286
696 2016-09-08 ... 2025-05-19 17:50:46.187286
[5 rows x 6 columns]
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-19 17:50:46,797 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
865 2025-05-15 9520.0
866 2025-05-16 9480.0
867 2025-05-17 9480.0
868 2025-05-18 9480.0
869 2025-05-19 9390.0
2025-05-19 17:50:46,832 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
867 2025-05-17 9480.0 ... 2025-05-19 17:50:46.825395 2025-05-19 17:50:46.825809
868 2025-05-18 9480.0 ... 2025-05-19 17:50:46.825395 2025-05-19 17:50:46.825809
869 2025-05-19 9390.0 ... 2025-05-19 17:50:46.825395 2025-05-19 17:50:46.825809
[3 rows x 5 columns]
2025-05-19 17:50:46,852 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-05-19 17:50:46,857 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
865 2025-05-15 9520.0
866 2025-05-16 9480.0
867 2025-05-17 9480.0
868 2025-05-18 9480.0
869 2025-05-19 9390.0
2025-05-19 17:50:46,893 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
867 2025-05-17 9480.0 ... 2025-05-19 17:50:46.886214 2025-05-19 17:50:46.886592
868 2025-05-18 9480.0 ... 2025-05-19 17:50:46.886214 2025-05-19 17:50:46.886592
869 2025-05-19 9390.0 ... 2025-05-19 17:50:46.886214 2025-05-19 17:50:46.886592
[3 rows x 5 columns]
2025-05-19 17:50:46,913 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-19 17:50:47,585 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3744 2025-05-15 7558.33
3745 2025-05-16 7566.67
3746 2025-05-17 7566.67
3747 2025-05-18 7566.67
3748 2025-05-19 7583.33
2025-05-19 17:50:47,659 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3746 2025-05-17 7566.67 ... 2025-05-19 17:50:47.651747 2025-05-19 17:50:47.652164
3747 2025-05-18 7566.67 ... 2025-05-19 17:50:47.651747 2025-05-19 17:50:47.652164
3748 2025-05-19 7583.33 ... 2025-05-19 17:50:47.651747 2025-05-19 17:50:47.652164
[3 rows x 5 columns]
2025-05-19 17:50:47,678 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-05-19 17:50:47,683 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3744 2025-05-15 7558.33
3745 2025-05-16 7566.67
3746 2025-05-17 7566.67
3747 2025-05-18 7566.67
3748 2025-05-19 7583.33
2025-05-19 17:50:47,756 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3749 2025-05-17 7566.67 ... 2025-05-19 17:50:47.749152 2025-05-19 17:50:47.749531
3750 2025-05-18 7566.67 ... 2025-05-19 17:50:47.749152 2025-05-19 17:50:47.749531
3751 2025-05-19 7583.33 ... 2025-05-19 17:50:47.749152 2025-05-19 17:50:47.749531
[3 rows x 5 columns]
2025-05-19 17:50:47,776 - IOOppi_data - INFO : save diff data to db: IOOppi_l_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-19 17:50:48,316 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3082 2025-05-15 3602.5
3083 2025-05-16 3600.0
3084 2025-05-17 3600.0
3085 2025-05-18 3600.0
3086 2025-05-19 3582.5
2025-05-19 17:50:48,380 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3085 2025-05-17 3600.0 ... 2025-05-19 17:50:48.372882 2025-05-19 17:50:48.373264
3086 2025-05-18 3600.0 ... 2025-05-19 17:50:48.372882 2025-05-19 17:50:48.373264
3087 2025-05-19 3582.5 ... 2025-05-19 17:50:48.372882 2025-05-19 17:50:48.373264
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-19 17:50:48,416 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-05-19 17:50:48.409380
[1 rows x 6 columns]
2025-05-19 17:50:48,440 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3082 2025-05-15 3602.5
3083 2025-05-16 3600.0
3084 2025-05-17 3600.0
3085 2025-05-18 3600.0
3086 2025-05-19 3582.5
2025-05-19 17:50:48,503 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3087 2025-05-17 3600.0 ... 2025-05-19 17:50:48.496024 2025-05-19 17:50:48.496387
3088 2025-05-18 3600.0 ... 2025-05-19 17:50:48.496024 2025-05-19 17:50:48.496387
3089 2025-05-19 3582.5 ... 2025-05-19 17:50:48.496024 2025-05-19 17:50:48.496387
[3 rows x 5 columns]
2025-05-19 17:50:48,522 - IOOppi_data - INFO : save diff data to db: IOOppi_bu_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-19 17:50:49,079 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3747 2025-05-15 20226.67
3748 2025-05-16 20290.00
3749 2025-05-17 20290.00
3750 2025-05-18 20290.00
3751 2025-05-19 20290.00
2025-05-19 17:50:49,151 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date value ... created_at updated_at
3749 2025-05-17 20290.0 ... 2025-05-19 17:50:49.143945 2025-05-19 17:50:49.144323
3750 2025-05-18 20290.0 ... 2025-05-19 17:50:49.143945 2025-05-19 17:50:49.144323
3751 2025-05-19 20290.0 ... 2025-05-19 17:50:49.143945 2025-05-19 17:50:49.144323
[3 rows x 5 columns]
2025-05-19 17:50:49,170 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-05-19 17:50:49,177 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3747 2025-05-15 20226.67
3748 2025-05-16 20290.00
3749 2025-05-17 20290.00
3750 2025-05-18 20290.00
3751 2025-05-19 20290.00
2025-05-19 17:50:49,250 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date value ... created_at updated_at
3752 2025-05-17 20290.0 ... 2025-05-19 17:50:49.242980 2025-05-19 17:50:49.243367
3753 2025-05-18 20290.0 ... 2025-05-19 17:50:49.242980 2025-05-19 17:50:49.243367
3754 2025-05-19 20290.0 ... 2025-05-19 17:50:49.242980 2025-05-19 17:50:49.243367
[3 rows x 5 columns]
2025-05-19 17:50:49,269 - IOOppi_data - INFO : save diff data to db: IOOppi_al_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-19 17:50:49,847 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2861 2025-05-15 5706.0
2862 2025-05-16 5698.0
2863 2025-05-17 5698.0
2864 2025-05-18 5698.0
2865 2025-05-19 5664.0
2025-05-19 17:50:49,908 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2863 2025-05-17 5698.0 ... 2025-05-19 17:50:49.900765 2025-05-19 17:50:49.901159
2864 2025-05-18 5698.0 ... 2025-05-19 17:50:49.900765 2025-05-19 17:50:49.901159
2865 2025-05-19 5664.0 ... 2025-05-19 17:50:49.900765 2025-05-19 17:50:49.901159
[3 rows x 5 columns]
2025-05-19 17:50:49,928 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-05-19 17:50:49,934 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2861 2025-05-15 5706.0
2862 2025-05-16 5698.0
2863 2025-05-17 5698.0
2864 2025-05-18 5698.0
2865 2025-05-19 5664.0
2025-05-19 17:50:49,995 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2867 2025-05-17 5698.0 ... 2025-05-19 17:50:49.987900 2025-05-19 17:50:49.988279
2868 2025-05-18 5698.0 ... 2025-05-19 17:50:49.987900 2025-05-19 17:50:49.988279
2869 2025-05-19 5664.0 ... 2025-05-19 17:50:49.987900 2025-05-19 17:50:49.988279
[3 rows x 5 columns]
2025-05-19 17:50:50,014 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-19 17:50:50,606 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2136 2025-05-15 23775.0
2137 2025-05-16 23775.0
2138 2025-05-17 23775.0
2139 2025-05-18 23775.0
2140 2025-05-19 23775.0
2025-05-19 17:50:50,657 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2138 2025-05-17 23775.0 ... 2025-05-19 17:50:50.650235 2025-05-19 17:50:50.650645
2139 2025-05-18 23775.0 ... 2025-05-19 17:50:50.650235 2025-05-19 17:50:50.650645
2140 2025-05-19 23775.0 ... 2025-05-19 17:50:50.650235 2025-05-19 17:50:50.650645
[3 rows x 5 columns]
2025-05-19 17:50:50,676 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-05-19 17:50:50,682 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2136 2025-05-15 23775.0
2137 2025-05-16 23775.0
2138 2025-05-17 23775.0
2139 2025-05-18 23775.0
2140 2025-05-19 23775.0
2025-05-19 17:50:50,733 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2142 2025-05-17 23775.0 ... 2025-05-19 17:50:50.726341 2025-05-19 17:50:50.726713
2143 2025-05-18 23775.0 ... 2025-05-19 17:50:50.726341 2025-05-19 17:50:50.726713
2144 2025-05-19 23775.0 ... 2025-05-19 17:50:50.726341 2025-05-19 17:50:50.726713
[3 rows x 5 columns]
2025-05-19 17:50:50,752 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-19 17:50:51,280 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1651 2025-05-15 1946.67
1652 2025-05-16 1946.67
1653 2025-05-17 1946.67
1654 2025-05-18 1946.67
1655 2025-05-19 1945.00
2025-05-19 17:50:51,326 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1653 2025-05-17 1946.67 ... 2025-05-19 17:50:51.319263 2025-05-19 17:50:51.319640
1654 2025-05-18 1946.67 ... 2025-05-19 17:50:51.319263 2025-05-19 17:50:51.319640
1655 2025-05-19 1945.00 ... 2025-05-19 17:50:51.319263 2025-05-19 17:50:51.319640
[3 rows x 5 columns]
2025-05-19 17:50:51,346 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-05-19 17:50:51,351 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1651 2025-05-15 1946.67
1652 2025-05-16 1946.67
1653 2025-05-17 1946.67
1654 2025-05-18 1946.67
1655 2025-05-19 1945.00
2025-05-19 17:50:51,397 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1657 2025-05-17 1946.67 ... 2025-05-19 17:50:51.389814 2025-05-19 17:50:51.390203
1658 2025-05-18 1946.67 ... 2025-05-19 17:50:51.389814 2025-05-19 17:50:51.390203
1659 2025-05-19 1945.00 ... 2025-05-19 17:50:51.389814 2025-05-19 17:50:51.390203
[3 rows x 5 columns]
2025-05-19 17:50:51,416 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-19 17:50:52,039 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2723 2025-05-15 126525.00
2724 2025-05-16 126258.33
2725 2025-05-17 126258.33
2726 2025-05-18 126258.33
2727 2025-05-19 125083.33
2025-05-19 17:50:52,097 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2725 2025-05-17 ... 2025-05-19 17:50:52.091633
2726 2025-05-18 ... 2025-05-19 17:50:52.091633
2727 2025-05-19 ... 2025-05-19 17:50:52.091633
[3 rows x 5 columns]
2025-05-19 17:50:52,116 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-05-19 17:50:52,122 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2723 2025-05-15 126525.00
2724 2025-05-16 126258.33
2725 2025-05-17 126258.33
2726 2025-05-18 126258.33
2727 2025-05-19 125083.33
2025-05-19 17:50:52,182 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2728 2025-05-17 ... 2025-05-19 17:50:52.175020
2729 2025-05-18 ... 2025-05-19 17:50:52.175020
2730 2025-05-19 ... 2025-05-19 17:50:52.175020
[3 rows x 5 columns]
2025-05-19 17:50:52,201 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-19 17:50:52,792 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3748 2025-05-15 4756.0
3749 2025-05-16 4782.0
3750 2025-05-17 4782.0
3751 2025-05-18 4782.0
3752 2025-05-19 4726.0
2025-05-19 17:50:52,863 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3750 2025-05-17 4782.0 ... 2025-05-19 17:50:52.856426 2025-05-19 17:50:52.856833
3751 2025-05-18 4782.0 ... 2025-05-19 17:50:52.856426 2025-05-19 17:50:52.856833
3752 2025-05-19 4726.0 ... 2025-05-19 17:50:52.856426 2025-05-19 17:50:52.856833
[3 rows x 5 columns]
2025-05-19 17:50:52,882 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-05-19 17:50:52,888 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3748 2025-05-15 4756.0
3749 2025-05-16 4782.0
3750 2025-05-17 4782.0
3751 2025-05-18 4782.0
3752 2025-05-19 4726.0
2025-05-19 17:50:52,962 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3753 2025-05-17 4782.0 ... 2025-05-19 17:50:52.953173 2025-05-19 17:50:52.953619
3754 2025-05-18 4782.0 ... 2025-05-19 17:50:52.953173 2025-05-19 17:50:52.953619
3755 2025-05-19 4726.0 ... 2025-05-19 17:50:52.953173 2025-05-19 17:50:52.953619
[3 rows x 5 columns]
2025-05-19 17:50:52,981 - IOOppi_data - INFO : save diff data to db: IOOppi_v_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-19 17:50:53,566 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
2987 2025-05-15 7440.0
2988 2025-05-16 7440.0
2989 2025-05-17 7440.0
2990 2025-05-18 7440.0
2991 2025-05-19 7440.0
2025-05-19 17:50:53,627 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
2989 2025-05-17 7440.0 ... 2025-05-19 17:50:53.620712 2025-05-19 17:50:53.621115
2990 2025-05-18 7440.0 ... 2025-05-19 17:50:53.620712 2025-05-19 17:50:53.621115
2991 2025-05-19 7440.0 ... 2025-05-19 17:50:53.620712 2025-05-19 17:50:53.621115
[3 rows x 5 columns]
2025-05-19 17:50:53,647 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-05-19 17:50:53,652 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
2987 2025-05-15 7440.0
2988 2025-05-16 7440.0
2989 2025-05-17 7440.0
2990 2025-05-18 7440.0
2991 2025-05-19 7440.0
2025-05-19 17:50:53,715 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
2992 2025-05-17 7440.0 ... 2025-05-19 17:50:53.707694 2025-05-19 17:50:53.708111
2993 2025-05-18 7440.0 ... 2025-05-19 17:50:53.707694 2025-05-19 17:50:53.708111
2994 2025-05-19 7440.0 ... 2025-05-19 17:50:53.707694 2025-05-19 17:50:53.708111
[3 rows x 5 columns]
2025-05-19 17:50:53,734 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-19 17:50:54,304 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3749 2025-05-15 14512.33
3750 2025-05-16 14558.17
3751 2025-05-17 14558.17
3752 2025-05-18 14558.17
3753 2025-05-19 14551.17
2025-05-19 17:50:54,375 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date ... updated_at
3751 2025-05-17 ... 2025-05-19 17:50:54.369364
3752 2025-05-18 ... 2025-05-19 17:50:54.369364
3753 2025-05-19 ... 2025-05-19 17:50:54.369364
[3 rows x 5 columns]
2025-05-19 17:50:54,394 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-05-19 17:50:54,400 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3749 2025-05-15 14512.33
3750 2025-05-16 14558.17
3751 2025-05-17 14558.17
3752 2025-05-18 14558.17
3753 2025-05-19 14551.17
2025-05-19 17:50:54,471 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date ... updated_at
3755 2025-05-17 ... 2025-05-19 17:50:54.465551
3756 2025-05-18 ... 2025-05-19 17:50:54.465551
3757 2025-05-19 ... 2025-05-19 17:50:54.465551
[3 rows x 5 columns]
2025-05-19 17:50:54,490 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-19 17:50:55,068 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3694 2025-05-15 16906.25
3695 2025-05-16 16847.50
3696 2025-05-17 16847.50
3697 2025-05-18 16847.50
3698 2025-05-19 16825.00
2025-05-19 17:50:55,139 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date value ... created_at updated_at
3696 2025-05-17 16847.5 ... 2025-05-19 17:50:55.131790 2025-05-19 17:50:55.132184
3697 2025-05-18 16847.5 ... 2025-05-19 17:50:55.131790 2025-05-19 17:50:55.132184
3698 2025-05-19 16825.0 ... 2025-05-19 17:50:55.131790 2025-05-19 17:50:55.132184
[3 rows x 5 columns]
2025-05-19 17:50:55,159 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-05-19 17:50:55,165 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3694 2025-05-15 16906.25
3695 2025-05-16 16847.50
3696 2025-05-17 16847.50
3697 2025-05-18 16847.50
3698 2025-05-19 16825.00
2025-05-19 17:50:55,237 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date value ... created_at updated_at
3699 2025-05-17 16847.5 ... 2025-05-19 17:50:55.230189 2025-05-19 17:50:55.230561
3700 2025-05-18 16847.5 ... 2025-05-19 17:50:55.230189 2025-05-19 17:50:55.230561
3701 2025-05-19 16825.0 ... 2025-05-19 17:50:55.230189 2025-05-19 17:50:55.230561
[3 rows x 5 columns]
2025-05-19 17:50:55,257 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-19 17:50:55,812 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
2969 2025-05-15 3313.33
2970 2025-05-16 3310.00
2971 2025-05-17 3310.00
2972 2025-05-18 3310.00
2973 2025-05-19 3290.00
2025-05-19 17:50:55,948 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
2971 2025-05-17 3310.0 ... 2025-05-19 17:50:55.941136 2025-05-19 17:50:55.941515
2972 2025-05-18 3310.0 ... 2025-05-19 17:50:55.941136 2025-05-19 17:50:55.941515
2973 2025-05-19 3290.0 ... 2025-05-19 17:50:55.941136 2025-05-19 17:50:55.941515
[3 rows x 5 columns]
2025-05-19 17:50:55,968 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-05-19 17:50:55,973 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
2969 2025-05-15 3313.33
2970 2025-05-16 3310.00
2971 2025-05-17 3310.00
2972 2025-05-18 3310.00
2973 2025-05-19 3290.00
2025-05-19 17:50:56,036 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
2974 2025-05-17 3310.0 ... 2025-05-19 17:50:56.029340 2025-05-19 17:50:56.029713
2975 2025-05-18 3310.0 ... 2025-05-19 17:50:56.029340 2025-05-19 17:50:56.029713
2976 2025-05-19 3290.0 ... 2025-05-19 17:50:56.029340 2025-05-19 17:50:56.029713
[3 rows x 5 columns]
2025-05-19 17:50:56,056 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-19 17:50:56,625 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3249 2025-05-15 5445.0
3250 2025-05-16 5445.0
3251 2025-05-17 5445.0
3252 2025-05-18 5445.0
3253 2025-05-19 5462.5
2025-05-19 17:50:56,690 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3251 2025-05-17 5445.0 ... 2025-05-19 17:50:56.683047 2025-05-19 17:50:56.683425
3252 2025-05-18 5445.0 ... 2025-05-19 17:50:56.683047 2025-05-19 17:50:56.683425
3253 2025-05-19 5462.5 ... 2025-05-19 17:50:56.683047 2025-05-19 17:50:56.683425
[3 rows x 5 columns]
2025-05-19 17:50:56,709 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-05-19 17:50:56,715 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3249 2025-05-15 5445.0
3250 2025-05-16 5445.0
3251 2025-05-17 5445.0
3252 2025-05-18 5445.0
3253 2025-05-19 5462.5
2025-05-19 17:50:56,789 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3738 2025-05-17 5445.0 ... 2025-05-19 17:50:56.781887 2025-05-19 17:50:56.782314
3739 2025-05-18 5445.0 ... 2025-05-19 17:50:56.781887 2025-05-19 17:50:56.782314
3740 2025-05-19 5462.5 ... 2025-05-19 17:50:56.781887 2025-05-19 17:50:56.782314
[3 rows x 5 columns]
2025-05-19 17:50:56,809 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-19 17:50:57,348 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1313 2025-05-15 14680.0
1314 2025-05-16 14650.0
1315 2025-05-17 14650.0
1316 2025-05-18 14650.0
1317 2025-05-19 14620.0
2025-05-19 17:50:57,390 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1315 2025-05-17 14650.0 ... 2025-05-19 17:50:57.382937 2025-05-19 17:50:57.383318
1316 2025-05-18 14650.0 ... 2025-05-19 17:50:57.382937 2025-05-19 17:50:57.383318
1317 2025-05-19 14620.0 ... 2025-05-19 17:50:57.382937 2025-05-19 17:50:57.383318
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-19 17:50:57,639 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-05-19 17:50:57.632105
117 2021-07-06 ... 2025-05-19 17:50:57.632105
121 2021-07-12 ... 2025-05-19 17:50:57.632105
122 2021-07-13 ... 2025-05-19 17:50:57.632105
194 2021-11-01 ... 2025-05-19 17:50:57.632105
[5 rows x 6 columns]
2025-05-19 17:50:57,676 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1313 2025-05-15 14680.0
1314 2025-05-16 14650.0
1315 2025-05-17 14650.0
1316 2025-05-18 14650.0
1317 2025-05-19 14620.0
2025-05-19 17:50:57,718 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1318 2025-05-17 14650.0 ... 2025-05-19 17:50:57.711071 2025-05-19 17:50:57.711460
1319 2025-05-18 14650.0 ... 2025-05-19 17:50:57.711071 2025-05-19 17:50:57.711460
1320 2025-05-19 14620.0 ... 2025-05-19 17:50:57.711071 2025-05-19 17:50:57.711460
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-19 17:50:57,959 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-05-19 17:50:57.951434
117 2021-07-06 ... 2025-05-19 17:50:57.951434
121 2021-07-12 ... 2025-05-19 17:50:57.951434
122 2021-07-13 ... 2025-05-19 17:50:57.951434
194 2021-11-01 ... 2025-05-19 17:50:57.951434
[5 rows x 6 columns]
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-19 17:50:58,625 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3745 2025-05-15 78938.33
3746 2025-05-16 78818.33
3747 2025-05-17 78818.33
3748 2025-05-18 78818.33
3749 2025-05-19 78113.33
2025-05-19 17:50:58,696 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date ... updated_at
3747 2025-05-17 ... 2025-05-19 17:50:58.689986
3748 2025-05-18 ... 2025-05-19 17:50:58.689986
3749 2025-05-19 ... 2025-05-19 17:50:58.689986
[3 rows x 5 columns]
2025-05-19 17:50:58,716 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-05-19 17:50:58,722 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3745 2025-05-15 78938.33
3746 2025-05-16 78818.33
3747 2025-05-17 78818.33
3748 2025-05-18 78818.33
3749 2025-05-19 78113.33
2025-05-19 17:50:58,792 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date ... updated_at
3750 2025-05-17 ... 2025-05-19 17:50:58.786449
3751 2025-05-18 ... 2025-05-19 17:50:58.786449
3752 2025-05-19 ... 2025-05-19 17:50:58.786449
[3 rows x 5 columns]
2025-05-19 17:50:58,812 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-19 17:50:59,291 - IOOppi_data - INFO : save data to db IOOppi_PM_t data:
date value
2947 2024-06-26 2440.0
2948 2024-06-27 2460.0
2949 2024-06-28 2460.0
2950 2024-06-29 2460.0
2951 2024-06-30 2460.0
2025-05-19 17:50:59,344 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-05-19 17:50:59,344 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-05-19 17:50:59,350 - IOOppi_data - INFO : save data to db IOOppi_PM_g data:
date value
2947 2024-06-26 2440.0
2948 2024-06-27 2460.0
2949 2024-06-28 2460.0
2950 2024-06-29 2460.0
2951 2024-06-30 2460.0
2025-05-19 17:50:59,410 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-05-19 17:50:59,410 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-19 17:51:00,023 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2723 2025-05-15 266125.0
2724 2025-05-16 265487.5
2725 2025-05-17 265487.5
2726 2025-05-18 265487.5
2727 2025-05-19 265187.5
2025-05-19 17:51:00,081 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2725 2025-05-17 ... 2025-05-19 17:51:00.075420
2726 2025-05-18 ... 2025-05-19 17:51:00.075420
2727 2025-05-19 ... 2025-05-19 17:51:00.075420
[3 rows x 5 columns]
2025-05-19 17:51:00,101 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-05-19 17:51:00,108 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2723 2025-05-15 266125.0
2724 2025-05-16 265487.5
2725 2025-05-17 265487.5
2726 2025-05-18 265487.5
2727 2025-05-19 265187.5
2025-05-19 17:51:00,168 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2728 2025-05-17 ... 2025-05-19 17:51:00.162127
2729 2025-05-18 ... 2025-05-19 17:51:00.162127
2730 2025-05-19 ... 2025-05-19 17:51:00.162127
[3 rows x 5 columns]
2025-05-19 17:51:00,189 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-19 17:51:00,882 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3744 2025-05-15 22880.0
3745 2025-05-16 22746.0
3746 2025-05-17 22746.0
3747 2025-05-18 22746.0
3748 2025-05-19 22590.0
2025-05-19 17:51:00,954 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3746 2025-05-17 22746.0 ... 2025-05-19 17:51:00.947102 2025-05-19 17:51:00.947480
3747 2025-05-18 22746.0 ... 2025-05-19 17:51:00.947102 2025-05-19 17:51:00.947480
3748 2025-05-19 22590.0 ... 2025-05-19 17:51:00.947102 2025-05-19 17:51:00.947480
[3 rows x 5 columns]
2025-05-19 17:51:00,974 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-05-19 17:51:00,979 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3744 2025-05-15 22880.0
3745 2025-05-16 22746.0
3746 2025-05-17 22746.0
3747 2025-05-18 22746.0
3748 2025-05-19 22590.0
2025-05-19 17:51:01,054 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3749 2025-05-17 22746.0 ... 2025-05-19 17:51:01.046663 2025-05-19 17:51:01.047095
3750 2025-05-18 22746.0 ... 2025-05-19 17:51:01.046663 2025-05-19 17:51:01.047095
3751 2025-05-19 22590.0 ... 2025-05-19 17:51:01.046663 2025-05-19 17:51:01.047095
[3 rows x 5 columns]
2025-05-19 17:51:01,074 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-19 17:51:01,657 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3707 2025-05-15 3377.5
3708 2025-05-16 3372.5
3709 2025-05-17 3372.5
3710 2025-05-18 3372.5
3711 2025-05-19 3347.5
2025-05-19 17:51:01,729 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3709 2025-05-17 3372.5 ... 2025-05-19 17:51:01.721772 2025-05-19 17:51:01.722161
3710 2025-05-18 3372.5 ... 2025-05-19 17:51:01.721772 2025-05-19 17:51:01.722161
3711 2025-05-19 3347.5 ... 2025-05-19 17:51:01.721772 2025-05-19 17:51:01.722161
[3 rows x 5 columns]
2025-05-19 17:51:01,748 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-05-19 17:51:01,754 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3707 2025-05-15 3377.5
3708 2025-05-16 3372.5
3709 2025-05-17 3372.5
3710 2025-05-18 3372.5
3711 2025-05-19 3347.5
2025-05-19 17:51:01,826 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3712 2025-05-17 3372.5 ... 2025-05-19 17:51:01.819133 2025-05-19 17:51:01.819511
3713 2025-05-18 3372.5 ... 2025-05-19 17:51:01.819133 2025-05-19 17:51:01.819511
3714 2025-05-19 3347.5 ... 2025-05-19 17:51:01.819133 2025-05-19 17:51:01.819511
[3 rows x 5 columns]
2025-05-19 17:51:01,845 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-19 17:51:02,414 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1504 2025-05-15 4847.5
1505 2025-05-16 4780.0
1506 2025-05-17 4780.0
1507 2025-05-18 4780.0
1508 2025-05-19 4740.0
2025-05-19 17:51:02,459 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1506 2025-05-17 4780.0 ... 2025-05-19 17:51:02.451881 2025-05-19 17:51:02.452296
1507 2025-05-18 4780.0 ... 2025-05-19 17:51:02.451881 2025-05-19 17:51:02.452296
1508 2025-05-19 4740.0 ... 2025-05-19 17:51:02.451881 2025-05-19 17:51:02.452296
[3 rows x 5 columns]
2025-05-19 17:51:02,479 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-05-19 17:51:02,484 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1504 2025-05-15 4847.5
1505 2025-05-16 4780.0
1506 2025-05-17 4780.0
1507 2025-05-18 4780.0
1508 2025-05-19 4740.0
2025-05-19 17:51:02,529 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1509 2025-05-17 4780.0 ... 2025-05-19 17:51:02.521638 2025-05-19 17:51:02.522053
1510 2025-05-18 4780.0 ... 2025-05-19 17:51:02.521638 2025-05-19 17:51:02.522053
1511 2025-05-19 4740.0 ... 2025-05-19 17:51:02.521638 2025-05-19 17:51:02.522053
[3 rows x 5 columns]
2025-05-19 17:51:02,548 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-19 17:51:03,108 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2778 2025-05-15 2304.29
2779 2025-05-16 2304.29
2780 2025-05-17 2304.29
2781 2025-05-18 2304.29
2782 2025-05-19 2301.43
2025-05-19 17:51:03,169 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2780 2025-05-17 2304.29 ... 2025-05-19 17:51:03.161673 2025-05-19 17:51:03.162090
2781 2025-05-18 2304.29 ... 2025-05-19 17:51:03.161673 2025-05-19 17:51:03.162090
2782 2025-05-19 2301.43 ... 2025-05-19 17:51:03.161673 2025-05-19 17:51:03.162090
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-19 17:51:03,211 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2779 2025-05-16 ... 2025-05-19 17:51:03.204198
[1 rows x 6 columns]
2025-05-19 17:51:03,236 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2778 2025-05-15 2304.29
2779 2025-05-16 2304.29
2780 2025-05-17 2304.29
2781 2025-05-18 2304.29
2782 2025-05-19 2301.43
2025-05-19 17:51:03,297 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2783 2025-05-17 2304.29 ... 2025-05-19 17:51:03.290078 2025-05-19 17:51:03.290476
2784 2025-05-18 2304.29 ... 2025-05-19 17:51:03.290078 2025-05-19 17:51:03.290476
2785 2025-05-19 2301.43 ... 2025-05-19 17:51:03.290078 2025-05-19 17:51:03.290476
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-19 17:51:03,340 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2782 2025-05-16 ... 2025-05-19 17:51:03.333012
[1 rows x 6 columns]
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-19 17:51:03,903 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2778 2025-05-15 2304.29
2779 2025-05-16 2304.29
2780 2025-05-17 2304.29
2781 2025-05-18 2304.29
2782 2025-05-19 2922.00
2025-05-19 17:51:03,956 - IOOppi_data - INFO : save new data to db: IOOppi_cs_t: no new data
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-19 17:51:03,982 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2782 2025-05-19 ... 2025-05-19 17:51:03.973340
[1 rows x 6 columns]
2025-05-19 17:51:04,007 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2778 2025-05-15 2304.29
2779 2025-05-16 2304.29
2780 2025-05-17 2304.29
2781 2025-05-18 2304.29
2782 2025-05-19 2922.00
2025-05-19 17:51:04,060 - IOOppi_data - INFO : save new data to db: IOOppi_cs_g: no new data
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-19 17:51:04,085 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2785 2025-05-19 ... 2025-05-19 17:51:04.078258
[1 rows x 6 columns]
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-19 17:51:04,646 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3135 2025-05-15 9395.00
3136 2025-05-16 9378.33
3137 2025-05-17 9378.33
3138 2025-05-18 9378.33
3139 2025-05-19 9475.00
2025-05-19 17:51:04,702 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-05-19 17:51:04,702 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-05-19 17:51:04,708 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3135 2025-05-15 9395.00
3136 2025-05-16 9378.33
3137 2025-05-17 9378.33
3138 2025-05-18 9378.33
3139 2025-05-19 9475.00
2025-05-19 17:51:04,766 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-05-19 17:51:04,766 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-19 17:51:05,301 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1819 2025-05-15 4536.67
1820 2025-05-16 4551.67
1821 2025-05-17 4551.67
1822 2025-05-18 4551.67
1823 2025-05-19 4560.00
2025-05-19 17:51:05,351 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1821 2025-05-17 4551.67 ... 2025-05-19 17:51:05.343439 2025-05-19 17:51:05.343851
1822 2025-05-18 4551.67 ... 2025-05-19 17:51:05.343439 2025-05-19 17:51:05.343851
1823 2025-05-19 4560.00 ... 2025-05-19 17:51:05.343439 2025-05-19 17:51:05.343851
[3 rows x 5 columns]
2025-05-19 17:51:05,371 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-05-19 17:51:05,376 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1819 2025-05-15 4536.67
1820 2025-05-16 4551.67
1821 2025-05-17 4551.67
1822 2025-05-18 4551.67
1823 2025-05-19 4560.00
2025-05-19 17:51:05,426 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1824 2025-05-17 4551.67 ... 2025-05-19 17:51:05.419063 2025-05-19 17:51:05.419454
1825 2025-05-18 4551.67 ... 2025-05-19 17:51:05.419063 2025-05-19 17:51:05.419454
1826 2025-05-19 4560.00 ... 2025-05-19 17:51:05.419063 2025-05-19 17:51:05.419454
[3 rows x 5 columns]
2025-05-19 17:51:05,447 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-19 17:51:05,976 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1828 2025-05-15 6300.0
1829 2025-05-16 6300.0
1830 2025-05-17 6300.0
1831 2025-05-18 6300.0
1832 2025-05-19 6300.0
2025-05-19 17:51:06,030 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1830 2025-05-17 6300.0 ... 2025-05-19 17:51:06.022980 2025-05-19 17:51:06.023507
1831 2025-05-18 6300.0 ... 2025-05-19 17:51:06.022980 2025-05-19 17:51:06.023507
1832 2025-05-19 6300.0 ... 2025-05-19 17:51:06.022980 2025-05-19 17:51:06.023507
[3 rows x 5 columns]
2025-05-19 17:51:06,051 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-05-19 17:51:06,057 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1828 2025-05-15 6300.0
1829 2025-05-16 6300.0
1830 2025-05-17 6300.0
1831 2025-05-18 6300.0
1832 2025-05-19 6300.0
2025-05-19 17:51:06,107 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1833 2025-05-17 6300.0 ... 2025-05-19 17:51:06.099580 2025-05-19 17:51:06.099981
1834 2025-05-18 6300.0 ... 2025-05-19 17:51:06.099580 2025-05-19 17:51:06.099981
1835 2025-05-19 6300.0 ... 2025-05-19 17:51:06.099580 2025-05-19 17:51:06.099981
[3 rows x 5 columns]
2025-05-19 17:51:06,128 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-19 17:51:06,692 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3496 2025-05-15 8680.0
3497 2025-05-16 8492.0
3498 2025-05-17 8492.0
3499 2025-05-18 8492.0
3500 2025-05-19 8542.0
2025-05-19 17:51:06,763 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3498 2025-05-17 8492.0 ... 2025-05-19 17:51:06.755813 2025-05-19 17:51:06.756232
3499 2025-05-18 8492.0 ... 2025-05-19 17:51:06.755813 2025-05-19 17:51:06.756232
3500 2025-05-19 8542.0 ... 2025-05-19 17:51:06.755813 2025-05-19 17:51:06.756232
[3 rows x 5 columns]
2025-05-19 17:51:06,783 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-05-19 17:51:06,790 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3496 2025-05-15 8680.0
3497 2025-05-16 8492.0
3498 2025-05-17 8492.0
3499 2025-05-18 8492.0
3500 2025-05-19 8542.0
2025-05-19 17:51:06,861 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3501 2025-05-17 8492.0 ... 2025-05-19 17:51:06.853561 2025-05-19 17:51:06.853980
3502 2025-05-18 8492.0 ... 2025-05-19 17:51:06.853561 2025-05-19 17:51:06.853980
3503 2025-05-19 8542.0 ... 2025-05-19 17:51:06.853561 2025-05-19 17:51:06.853980
[3 rows x 5 columns]
2025-05-19 17:51:06,880 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data