=========================================================================
2025-07-09 17:50:26 Wed 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-07-09 17:50:28,930 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3355 2025-07-05 3113.0
3356 2025-07-06 3113.0
3357 2025-07-07 3104.0
3358 2025-07-08 3106.5
3359 2025-07-09 3112.5
2025-07-09 17:50:29,010 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3359 2025-07-09 3112.5 ... 2025-07-09 17:50:29.002586 2025-07-09 17:50:29.003022
[1 rows x 5 columns]
2025-07-09 17:50:29,032 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-07-09 17:50:29,038 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3355 2025-07-05 3113.0
3356 2025-07-06 3113.0
3357 2025-07-07 3104.0
3358 2025-07-08 3106.5
3359 2025-07-09 3112.5
2025-07-09 17:50:29,111 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3362 2025-07-09 3112.5 ... 2025-07-09 17:50:29.104659 2025-07-09 17:50:29.105067
[1 rows x 5 columns]
2025-07-09 17:50:29,130 - 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-07-09 17:50:29,882 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3576 2025-07-05 2447.50
3577 2025-07-06 2447.50
3578 2025-07-07 2423.33
3579 2025-07-08 2410.00
3580 2025-07-09 2390.33
2025-07-09 17:50:29,956 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3580 2025-07-09 2390.33 ... 2025-07-09 17:50:29.948923 2025-07-09 17:50:29.949323
[1 rows x 5 columns]
2025-07-09 17:50:29,975 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-07-09 17:50:29,981 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3576 2025-07-05 2447.50
3577 2025-07-06 2447.50
3578 2025-07-07 2423.33
3579 2025-07-08 2410.00
3580 2025-07-09 2390.33
2025-07-09 17:50:30,058 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3584 2025-07-09 2390.33 ... 2025-07-09 17:50:30.051081 2025-07-09 17:50:30.051469
[1 rows x 5 columns]
2025-07-09 17:50:30,077 - 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-07-09 17:50:30,635 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
916 2025-07-05 5031.25
917 2025-07-06 5031.25
918 2025-07-07 4977.50
919 2025-07-08 4930.84
920 2025-07-09 4852.50
2025-07-09 17:50:30,676 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
920 2025-07-09 4852.5 ... 2025-07-09 17:50:30.668339 2025-07-09 17:50:30.668926
[1 rows x 5 columns]
2025-07-09 17:50:30,695 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-07-09 17:50:30,700 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
916 2025-07-05 5031.25
917 2025-07-06 5031.25
918 2025-07-07 4977.50
919 2025-07-08 4930.84
920 2025-07-09 4852.50
2025-07-09 17:50:30,740 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
920 2025-07-09 4852.5 ... 2025-07-09 17:50:30.733163 2025-07-09 17:50:30.733539
[1 rows x 5 columns]
2025-07-09 17:50:30,758 - 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-07-09 17:50:31,372 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3795 2025-07-05 13958.33
3796 2025-07-06 13958.33
3797 2025-07-07 13878.33
3798 2025-07-08 13858.33
3799 2025-07-09 13908.33
2025-07-09 17:50:31,450 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3799 2025-07-09 ... 2025-07-09 17:50:31.444431
[1 rows x 5 columns]
2025-07-09 17:50:31,469 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-07-09 17:50:31,475 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3795 2025-07-05 13958.33
3796 2025-07-06 13958.33
3797 2025-07-07 13878.33
3798 2025-07-08 13858.33
3799 2025-07-09 13908.33
2025-07-09 17:50:31,548 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3802 2025-07-09 ... 2025-07-09 17:50:31.542137
[1 rows x 5 columns]
2025-07-09 17:50:31,567 - 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-07-09 17:50:32,114 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3127 2025-07-05 737.33
3128 2025-07-06 737.33
3129 2025-07-07 737.33
3130 2025-07-08 734.67
3131 2025-07-09 739.00
2025-07-09 17:50:32,182 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3131 2025-07-09 739.0 ... 2025-07-09 17:50:32.174541 2025-07-09 17:50:32.174972
[1 rows x 5 columns]
2025-07-09 17:50:32,201 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-07-09 17:50:32,207 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3127 2025-07-05 737.33
3128 2025-07-06 737.33
3129 2025-07-07 737.33
3130 2025-07-08 734.67
3131 2025-07-09 739.00
2025-07-09 17:50:32,275 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3134 2025-07-09 739.0 ... 2025-07-09 17:50:32.267673 2025-07-09 17:50:32.268108
[1 rows x 5 columns]
2025-07-09 17:50:32,293 - 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-07-09 17:50:32,810 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3330 2025-07-05 1122.4
3331 2025-07-06 1122.4
3332 2025-07-07 1122.4
3333 2025-07-08 1122.4
3334 2025-07-09 1122.4
2025-07-09 17:50:32,882 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3334 2025-07-09 1122.4 ... 2025-07-09 17:50:32.874517 2025-07-09 17:50:32.874965
[1 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-07-09 17:50:34,938 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-07-09 17:50:34.930188
21 2013-01-04 ... 2025-07-09 17:50:34.930188
54 2013-02-27 ... 2025-07-09 17:50:34.930188
60 2013-03-07 ... 2025-07-09 17:50:34.930188
61 2013-03-08 ... 2025-07-09 17:50:34.930188
[5 rows x 6 columns]
2025-07-09 17:50:35,141 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3330 2025-07-05 1122.4
3331 2025-07-06 1122.4
3332 2025-07-07 1122.4
3333 2025-07-08 1122.4
3334 2025-07-09 1122.4
2025-07-09 17:50:35,211 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3338 2025-07-09 1122.4 ... 2025-07-09 17:50:35.204147 2025-07-09 17:50:35.204535
[1 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-07-09 17:50:37,192 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-07-09 17:50:37.184461
21 2013-01-04 ... 2025-07-09 17:50:37.184461
54 2013-02-27 ... 2025-07-09 17:50:37.184461
60 2013-03-07 ... 2025-07-09 17:50:37.184461
61 2013-03-08 ... 2025-07-09 17:50:37.184461
[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-07-09 17:50:38,043 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1675 2025-07-05 7904.0
1676 2025-07-06 7904.0
1677 2025-07-07 7914.0
1678 2025-07-08 7914.0
1679 2025-07-09 7908.0
2025-07-09 17:50:38,090 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1679 2025-07-09 7908.0 ... 2025-07-09 17:50:38.083576 2025-07-09 17:50:38.083987
[1 rows x 5 columns]
2025-07-09 17:50:38,110 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-07-09 17:50:38,115 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1675 2025-07-05 7904.0
1676 2025-07-06 7904.0
1677 2025-07-07 7914.0
1678 2025-07-08 7914.0
1679 2025-07-09 7908.0
2025-07-09 17:50:38,163 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1682 2025-07-09 7908.0 ... 2025-07-09 17:50:38.155858 2025-07-09 17:50:38.156245
[1 rows x 5 columns]
2025-07-09 17:50:38,182 - 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-07-09 17:50:38,757 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3786 2025-07-05 6053.33
3787 2025-07-06 6053.33
3788 2025-07-07 6043.33
3789 2025-07-08 6040.00
3790 2025-07-09 6050.00
2025-07-09 17:50:38,830 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3790 2025-07-09 6050.0 ... 2025-07-09 17:50:38.823500 2025-07-09 17:50:38.823902
[1 rows x 5 columns]
2025-07-09 17:50:38,849 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-07-09 17:50:38,855 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3786 2025-07-05 6053.33
3787 2025-07-06 6053.33
3788 2025-07-07 6043.33
3789 2025-07-08 6040.00
3790 2025-07-09 6050.00
2025-07-09 17:50:38,926 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3794 2025-07-09 6050.0 ... 2025-07-09 17:50:38.919705 2025-07-09 17:50:38.920115
[1 rows x 5 columns]
2025-07-09 17:50:38,945 - 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-07-09 17:50:39,631 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1676 2025-07-05 12887.5
1677 2025-07-06 12887.5
1678 2025-07-07 12887.5
1679 2025-07-08 12887.5
1680 2025-07-09 12887.5
2025-07-09 17:50:39,678 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1680 2025-07-09 12887.5 ... 2025-07-09 17:50:39.671187 2025-07-09 17:50:39.671567
[1 rows x 5 columns]
2025-07-09 17:50:39,697 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-07-09 17:50:39,702 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1676 2025-07-05 12887.5
1677 2025-07-06 12887.5
1678 2025-07-07 12887.5
1679 2025-07-08 12887.5
1680 2025-07-09 12887.5
2025-07-09 17:50:39,748 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1683 2025-07-09 12887.5 ... 2025-07-09 17:50:39.741492 2025-07-09 17:50:39.741895
[1 rows x 5 columns]
2025-07-09 17:50:39,767 - 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-07-09 17:50:40,341 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3186 2025-07-05 9755.00
3187 2025-07-06 9755.00
3188 2025-07-07 9703.33
3189 2025-07-08 9745.00
3190 2025-07-09 9675.00
2025-07-09 17:50:40,411 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date value ... created_at updated_at
3190 2025-07-09 9675.0 ... 2025-07-09 17:50:40.403573 2025-07-09 17:50:40.404010
[1 rows x 5 columns]
2025-07-09 17:50:40,429 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-07-09 17:50:40,435 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3186 2025-07-05 9755.00
3187 2025-07-06 9755.00
3188 2025-07-07 9703.33
3189 2025-07-08 9745.00
3190 2025-07-09 9675.00
2025-07-09 17:50:40,500 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date value ... created_at updated_at
3194 2025-07-09 9675.0 ... 2025-07-09 17:50:40.493273 2025-07-09 17:50:40.493654
[1 rows x 5 columns]
2025-07-09 17:50:40,519 - 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-07-09 17:50:41,245 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3309 2025-07-05 2535.0
3310 2025-07-06 2535.0
3311 2025-07-07 2525.0
3312 2025-07-08 2505.0
3313 2025-07-09 2505.0
2025-07-09 17:50:41,311 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3313 2025-07-09 2505.0 ... 2025-07-09 17:50:41.304314 2025-07-09 17:50:41.304719
[1 rows x 5 columns]
2025-07-09 17:50:41,331 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-07-09 17:50:41,338 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3309 2025-07-05 2535.0
3310 2025-07-06 2535.0
3311 2025-07-07 2525.0
3312 2025-07-08 2505.0
3313 2025-07-09 2505.0
2025-07-09 17:50:41,404 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3317 2025-07-09 2505.0 ... 2025-07-09 17:50:41.397299 2025-07-09 17:50:41.397677
[1 rows x 5 columns]
2025-07-09 17:50:41,423 - 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-07-09 17:50:42,047 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1513 2025-07-05 1252.5
1514 2025-07-06 1252.5
1515 2025-07-07 1252.5
1516 2025-07-08 1252.5
1517 2025-07-09 1247.5
2025-07-09 17:50:42,096 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1517 2025-07-09 1247.5 ... 2025-07-09 17:50:42.089008 2025-07-09 17:50:42.089410
[1 rows x 5 columns]
2025-07-09 17:50:42,115 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-07-09 17:50:42,120 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1513 2025-07-05 1252.5
1514 2025-07-06 1252.5
1515 2025-07-07 1252.5
1516 2025-07-08 1252.5
1517 2025-07-09 1247.5
2025-07-09 17:50:42,165 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1521 2025-07-09 1247.5 ... 2025-07-09 17:50:42.157997 2025-07-09 17:50:42.158386
[1 rows x 5 columns]
2025-07-09 17:50:42,184 - 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-07-09 17:50:42,754 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1426 2025-07-05 6739.58
1427 2025-07-06 6739.58
1428 2025-07-07 6712.92
1429 2025-07-08 6704.58
1430 2025-07-09 6702.71
2025-07-09 17:50:42,797 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1430 2025-07-09 6702.71 ... 2025-07-09 17:50:42.790088 2025-07-09 17:50:42.790485
[1 rows x 5 columns]
2025-07-09 17:50:42,817 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-07-09 17:50:42,822 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1426 2025-07-05 6739.58
1427 2025-07-06 6739.58
1428 2025-07-07 6712.92
1429 2025-07-08 6704.58
1430 2025-07-09 6702.71
2025-07-09 17:50:42,866 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1434 2025-07-09 6702.71 ... 2025-07-09 17:50:42.858940 2025-07-09 17:50:42.859326
[1 rows x 5 columns]
2025-07-09 17:50:42,885 - 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-07-09 17:50:43,484 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3799 2025-07-05 2928.0
3800 2025-07-06 2928.0
3801 2025-07-07 2898.0
3802 2025-07-08 2880.0
3803 2025-07-09 2882.0
2025-07-09 17:50:43,559 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3803 2025-07-09 2882.0 ... 2025-07-09 17:50:43.552300 2025-07-09 17:50:43.552679
[1 rows x 5 columns]
2025-07-09 17:50:43,578 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-07-09 17:50:43,584 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3799 2025-07-05 2928.0
3800 2025-07-06 2928.0
3801 2025-07-07 2898.0
3802 2025-07-08 2880.0
3803 2025-07-09 2882.0
2025-07-09 17:50:43,659 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3806 2025-07-09 2882.0 ... 2025-07-09 17:50:43.652774 2025-07-09 17:50:43.653170
[1 rows x 5 columns]
2025-07-09 17:50:43,678 - 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-07-09 17:50:44,237 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3569 2025-07-05 8214.0
3570 2025-07-06 8214.0
3571 2025-07-07 8154.0
3572 2025-07-08 8194.0
3573 2025-07-09 8182.0
2025-07-09 17:50:44,310 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3573 2025-07-09 8182.0 ... 2025-07-09 17:50:44.303701 2025-07-09 17:50:44.304144
[1 rows x 5 columns]
2025-07-09 17:50:44,330 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-07-09 17:50:44,336 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3569 2025-07-05 8214.0
3570 2025-07-06 8214.0
3571 2025-07-07 8154.0
3572 2025-07-08 8194.0
3573 2025-07-09 8182.0
2025-07-09 17:50:44,410 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3576 2025-07-09 8182.0 ... 2025-07-09 17:50:44.403027 2025-07-09 17:50:44.403423
[1 rows x 5 columns]
2025-07-09 17:50:44,429 - 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-07-09 17:50:45,225 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3535 2025-07-05 4295.0
3536 2025-07-06 4295.0
3537 2025-07-07 4295.0
3538 2025-07-08 4295.0
3539 2025-07-09 4295.0
2025-07-09 17:50:45,292 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3539 2025-07-09 4295.0 ... 2025-07-09 17:50:45.285659 2025-07-09 17:50:45.286071
[1 rows x 5 columns]
2025-07-09 17:50:45,311 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-07-09 17:50:45,316 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3535 2025-07-05 4295.0
3536 2025-07-06 4295.0
3537 2025-07-07 4295.0
3538 2025-07-08 4295.0
3539 2025-07-09 4295.0
2025-07-09 17:50:45,384 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3542 2025-07-09 4295.0 ... 2025-07-09 17:50:45.377926 2025-07-09 17:50:45.378313
[1 rows x 5 columns]
2025-07-09 17:50:45,405 - 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-07-09 17:50:45,991 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2912 2025-07-05 5152.86
2913 2025-07-06 5152.86
2914 2025-07-07 5138.57
2915 2025-07-08 5138.57
2916 2025-07-09 5138.57
2025-07-09 17:50:46,053 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2916 2025-07-09 5138.57 ... 2025-07-09 17:50:46.046376 2025-07-09 17:50:46.046780
[1 rows x 5 columns]
2025-07-09 17:50:46,072 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-07-09 17:50:46,077 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2912 2025-07-05 5152.86
2913 2025-07-06 5152.86
2914 2025-07-07 5138.57
2915 2025-07-08 5138.57
2916 2025-07-09 5138.57
2025-07-09 17:50:46,138 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2920 2025-07-09 5138.57 ... 2025-07-09 17:50:46.131320 2025-07-09 17:50:46.131702
[1 rows x 5 columns]
2025-07-09 17:50:46,159 - 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-07-09 17:50:46,655 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3112 2025-07-05 2790.0
3113 2025-07-06 2790.0
3114 2025-07-07 2775.0
3115 2025-07-08 2750.0
3116 2025-07-09 2750.0
2025-07-09 17:50:46,718 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3116 2025-07-09 2750.0 ... 2025-07-09 17:50:46.711152 2025-07-09 17:50:46.711539
[1 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-07-09 17:50:46,869 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-07-09 17:50:46.861449
458 2015-09-21 ... 2025-07-09 17:50:46.861449
549 2016-02-03 ... 2025-07-09 17:50:46.861449
693 2016-09-05 ... 2025-07-09 17:50:46.861449
696 2016-09-08 ... 2025-07-09 17:50:46.861449
[5 rows x 6 columns]
2025-07-09 17:50:46,901 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3112 2025-07-05 2790.0
3113 2025-07-06 2790.0
3114 2025-07-07 2775.0
3115 2025-07-08 2750.0
3116 2025-07-09 2750.0
2025-07-09 17:50:46,968 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3119 2025-07-09 2750.0 ... 2025-07-09 17:50:46.960979 2025-07-09 17:50:46.961363
[1 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-07-09 17:50:47,121 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-07-09 17:50:47.113554
458 2015-09-21 ... 2025-07-09 17:50:47.113554
549 2016-02-03 ... 2025-07-09 17:50:47.113554
693 2016-09-05 ... 2025-07-09 17:50:47.113554
696 2016-09-08 ... 2025-07-09 17:50:47.113554
[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-07-09 17:50:47,718 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
916 2025-07-05 8910.0
917 2025-07-06 8910.0
918 2025-07-07 8910.0
919 2025-07-08 8910.0
920 2025-07-09 8910.0
2025-07-09 17:50:47,754 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
920 2025-07-09 8910.0 ... 2025-07-09 17:50:47.747570 2025-07-09 17:50:47.747977
[1 rows x 5 columns]
2025-07-09 17:50:47,773 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-07-09 17:50:47,778 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
916 2025-07-05 8910.0
917 2025-07-06 8910.0
918 2025-07-07 8910.0
919 2025-07-08 8910.0
920 2025-07-09 8910.0
2025-07-09 17:50:47,814 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
920 2025-07-09 8910.0 ... 2025-07-09 17:50:47.806977 2025-07-09 17:50:47.807357
[1 rows x 5 columns]
2025-07-09 17:50:47,833 - 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-07-09 17:50:48,430 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3795 2025-07-05 7445.00
3796 2025-07-06 7445.00
3797 2025-07-07 7433.33
3798 2025-07-08 7416.67
3799 2025-07-09 7411.67
2025-07-09 17:50:48,502 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3799 2025-07-09 7411.67 ... 2025-07-09 17:50:48.495303 2025-07-09 17:50:48.495687
[1 rows x 5 columns]
2025-07-09 17:50:48,521 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-07-09 17:50:48,528 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3795 2025-07-05 7445.00
3796 2025-07-06 7445.00
3797 2025-07-07 7433.33
3798 2025-07-08 7416.67
3799 2025-07-09 7411.67
2025-07-09 17:50:48,599 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3802 2025-07-09 7411.67 ... 2025-07-09 17:50:48.592807 2025-07-09 17:50:48.593200
[1 rows x 5 columns]
2025-07-09 17:50:48,618 - 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-07-09 17:50:49,193 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3133 2025-07-05 3713.33
3134 2025-07-06 3713.33
3135 2025-07-07 3690.00
3136 2025-07-08 3690.00
3137 2025-07-09 3696.67
2025-07-09 17:50:49,258 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3138 2025-07-09 3696.67 ... 2025-07-09 17:50:49.250893 2025-07-09 17:50:49.251281
[1 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-07-09 17:50:49,293 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-07-09 17:50:49.286180
[1 rows x 6 columns]
2025-07-09 17:50:49,316 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3133 2025-07-05 3713.33
3134 2025-07-06 3713.33
3135 2025-07-07 3690.00
3136 2025-07-08 3690.00
3137 2025-07-09 3696.67
2025-07-09 17:50:49,381 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3140 2025-07-09 3696.67 ... 2025-07-09 17:50:49.374605 2025-07-09 17:50:49.375032
[1 rows x 5 columns]
2025-07-09 17:50:49,401 - 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-07-09 17:50:49,959 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3798 2025-07-05 20780.00
3799 2025-07-06 20780.00
3800 2025-07-07 20780.00
3801 2025-07-08 20653.33
3802 2025-07-09 20680.00
2025-07-09 17:50:50,035 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date value ... created_at updated_at
3802 2025-07-09 20680.0 ... 2025-07-09 17:50:50.028535 2025-07-09 17:50:50.028987
[1 rows x 5 columns]
2025-07-09 17:50:50,055 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-07-09 17:50:50,062 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3798 2025-07-05 20780.00
3799 2025-07-06 20780.00
3800 2025-07-07 20780.00
3801 2025-07-08 20653.33
3802 2025-07-09 20680.00
2025-07-09 17:50:50,135 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date value ... created_at updated_at
3805 2025-07-09 20680.0 ... 2025-07-09 17:50:50.128615 2025-07-09 17:50:50.129022
[1 rows x 5 columns]
2025-07-09 17:50:50,155 - 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-07-09 17:50:50,992 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2912 2025-07-05 5576.0
2913 2025-07-06 5576.0
2914 2025-07-07 5556.0
2915 2025-07-08 5536.0
2916 2025-07-09 5546.0
2025-07-09 17:50:51,055 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2916 2025-07-09 5546.0 ... 2025-07-09 17:50:51.047855 2025-07-09 17:50:51.048325
[1 rows x 5 columns]
2025-07-09 17:50:51,074 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-07-09 17:50:51,080 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2912 2025-07-05 5576.0
2913 2025-07-06 5576.0
2914 2025-07-07 5556.0
2915 2025-07-08 5536.0
2916 2025-07-09 5546.0
2025-07-09 17:50:51,147 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2920 2025-07-09 5546.0 ... 2025-07-09 17:50:51.140447 2025-07-09 17:50:51.140852
[1 rows x 5 columns]
2025-07-09 17:50:51,166 - 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-07-09 17:50:51,774 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2187 2025-07-05 23200.0
2188 2025-07-06 23200.0
2189 2025-07-07 23200.0
2190 2025-07-08 23200.0
2191 2025-07-09 23200.0
2025-07-09 17:50:51,827 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2191 2025-07-09 23200.0 ... 2025-07-09 17:50:51.820605 2025-07-09 17:50:51.821048
[1 rows x 5 columns]
2025-07-09 17:50:51,848 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-07-09 17:50:51,853 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2187 2025-07-05 23200.0
2188 2025-07-06 23200.0
2189 2025-07-07 23200.0
2190 2025-07-08 23200.0
2191 2025-07-09 23200.0
2025-07-09 17:50:51,905 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2195 2025-07-09 23200.0 ... 2025-07-09 17:50:51.898527 2025-07-09 17:50:51.898930
[1 rows x 5 columns]
2025-07-09 17:50:51,923 - 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-07-09 17:50:52,450 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1702 2025-07-05 1829.0
1703 2025-07-06 1829.0
1704 2025-07-07 1827.0
1705 2025-07-08 1831.0
1706 2025-07-09 1843.0
2025-07-09 17:50:52,496 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1706 2025-07-09 1843.0 ... 2025-07-09 17:50:52.489720 2025-07-09 17:50:52.490134
[1 rows x 5 columns]
2025-07-09 17:50:52,515 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-07-09 17:50:52,521 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1702 2025-07-05 1829.0
1703 2025-07-06 1829.0
1704 2025-07-07 1827.0
1705 2025-07-08 1831.0
1706 2025-07-09 1843.0
2025-07-09 17:50:52,566 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1710 2025-07-09 1843.0 ... 2025-07-09 17:50:52.559834 2025-07-09 17:50:52.560217
[1 rows x 5 columns]
2025-07-09 17:50:52,585 - 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-07-09 17:50:53,128 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2774 2025-07-05 123783.33
2775 2025-07-06 123783.33
2776 2025-07-07 122383.33
2777 2025-07-08 121450.00
2778 2025-07-09 120516.67
2025-07-09 17:50:53,187 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2778 2025-07-09 ... 2025-07-09 17:50:53.180940
[1 rows x 5 columns]
2025-07-09 17:50:53,207 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-07-09 17:50:53,213 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2774 2025-07-05 123783.33
2775 2025-07-06 123783.33
2776 2025-07-07 122383.33
2777 2025-07-08 121450.00
2778 2025-07-09 120516.67
2025-07-09 17:50:53,273 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2781 2025-07-09 ... 2025-07-09 17:50:53.267304
[1 rows x 5 columns]
2025-07-09 17:50:53,292 - 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-07-09 17:50:53,869 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3799 2025-07-05 4678.0
3800 2025-07-06 4678.0
3801 2025-07-07 4651.0
3802 2025-07-08 4648.0
3803 2025-07-09 4688.0
2025-07-09 17:50:53,945 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3803 2025-07-09 4688.0 ... 2025-07-09 17:50:53.938678 2025-07-09 17:50:53.939101
[1 rows x 5 columns]
2025-07-09 17:50:53,964 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-07-09 17:50:53,971 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3799 2025-07-05 4678.0
3800 2025-07-06 4678.0
3801 2025-07-07 4651.0
3802 2025-07-08 4648.0
3803 2025-07-09 4688.0
2025-07-09 17:50:54,119 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3806 2025-07-09 4688.0 ... 2025-07-09 17:50:54.111567 2025-07-09 17:50:54.111985
[1 rows x 5 columns]
2025-07-09 17:50:54,138 - 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-07-09 17:50:54,672 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
3038 2025-07-05 7406.67
3039 2025-07-06 7406.67
3040 2025-07-07 7390.00
3041 2025-07-08 7376.67
3042 2025-07-09 7376.67
2025-07-09 17:50:54,736 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
3042 2025-07-09 7376.67 ... 2025-07-09 17:50:54.729144 2025-07-09 17:50:54.729531
[1 rows x 5 columns]
2025-07-09 17:50:54,755 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-07-09 17:50:54,761 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
3038 2025-07-05 7406.67
3039 2025-07-06 7406.67
3040 2025-07-07 7390.00
3041 2025-07-08 7376.67
3042 2025-07-09 7376.67
2025-07-09 17:50:54,824 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
3045 2025-07-09 7376.67 ... 2025-07-09 17:50:54.817055 2025-07-09 17:50:54.817442
[1 rows x 5 columns]
2025-07-09 17:50:54,842 - 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-07-09 17:50:55,382 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3800 2025-07-05 15198.33
3801 2025-07-06 15198.33
3802 2025-07-07 15202.17
3803 2025-07-08 15202.17
3804 2025-07-09 15188.83
2025-07-09 17:50:55,454 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date ... updated_at
3804 2025-07-09 ... 2025-07-09 17:50:55.448399
[1 rows x 5 columns]
2025-07-09 17:50:55,473 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-07-09 17:50:55,479 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3800 2025-07-05 15198.33
3801 2025-07-06 15198.33
3802 2025-07-07 15202.17
3803 2025-07-08 15202.17
3804 2025-07-09 15188.83
2025-07-09 17:50:55,551 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date ... updated_at
3808 2025-07-09 ... 2025-07-09 17:50:55.544923
[1 rows x 5 columns]
2025-07-09 17:50:55,569 - 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-07-09 17:50:56,169 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3745 2025-07-05 17112.50
3746 2025-07-06 17112.50
3747 2025-07-07 17050.00
3748 2025-07-08 16968.75
3749 2025-07-09 17087.50
2025-07-09 17:50:56,241 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date value ... created_at updated_at
3749 2025-07-09 17087.5 ... 2025-07-09 17:50:56.234636 2025-07-09 17:50:56.235051
[1 rows x 5 columns]
2025-07-09 17:50:56,260 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-07-09 17:50:56,266 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3745 2025-07-05 17112.50
3746 2025-07-06 17112.50
3747 2025-07-07 17050.00
3748 2025-07-08 16968.75
3749 2025-07-09 17087.50
2025-07-09 17:50:56,339 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date value ... created_at updated_at
3752 2025-07-09 17087.5 ... 2025-07-09 17:50:56.332141 2025-07-09 17:50:56.332527
[1 rows x 5 columns]
2025-07-09 17:50:56,359 - 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-07-09 17:50:56,897 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
3020 2025-07-05 3273.33
3021 2025-07-06 3273.33
3022 2025-07-07 3276.67
3023 2025-07-08 3276.67
3024 2025-07-09 3276.67
2025-07-09 17:50:56,961 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
3024 2025-07-09 3276.67 ... 2025-07-09 17:50:56.953959 2025-07-09 17:50:56.954346
[1 rows x 5 columns]
2025-07-09 17:50:56,979 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-07-09 17:50:56,985 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
3020 2025-07-05 3273.33
3021 2025-07-06 3273.33
3022 2025-07-07 3276.67
3023 2025-07-08 3276.67
3024 2025-07-09 3276.67
2025-07-09 17:50:57,049 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
3027 2025-07-09 3276.67 ... 2025-07-09 17:50:57.042138 2025-07-09 17:50:57.042513
[1 rows x 5 columns]
2025-07-09 17:50:57,067 - 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-07-09 17:50:57,613 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3300 2025-07-05 5425.0
3301 2025-07-06 5425.0
3302 2025-07-07 5425.0
3303 2025-07-08 5425.0
3304 2025-07-09 5412.5
2025-07-09 17:50:57,679 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3304 2025-07-09 5412.5 ... 2025-07-09 17:50:57.672535 2025-07-09 17:50:57.672942
[1 rows x 5 columns]
2025-07-09 17:50:57,698 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-07-09 17:50:57,704 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3300 2025-07-05 5425.0
3301 2025-07-06 5425.0
3302 2025-07-07 5425.0
3303 2025-07-08 5425.0
3304 2025-07-09 5412.5
2025-07-09 17:50:57,776 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3791 2025-07-09 5412.5 ... 2025-07-09 17:50:57.769325 2025-07-09 17:50:57.769720
[1 rows x 5 columns]
2025-07-09 17:50:57,796 - 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-07-09 17:50:58,353 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1364 2025-07-05 15020.0
1365 2025-07-06 15020.0
1366 2025-07-07 15000.0
1367 2025-07-08 14980.0
1368 2025-07-09 14900.0
2025-07-09 17:50:58,396 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1368 2025-07-09 14900.0 ... 2025-07-09 17:50:58.389002 2025-07-09 17:50:58.389397
[1 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-07-09 17:50:58,638 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-07-09 17:50:58.630355
117 2021-07-06 ... 2025-07-09 17:50:58.630355
121 2021-07-12 ... 2025-07-09 17:50:58.630355
122 2021-07-13 ... 2025-07-09 17:50:58.630355
194 2021-11-01 ... 2025-07-09 17:50:58.630355
[5 rows x 6 columns]
2025-07-09 17:50:58,675 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1364 2025-07-05 15020.0
1365 2025-07-06 15020.0
1366 2025-07-07 15000.0
1367 2025-07-08 14980.0
1368 2025-07-09 14900.0
2025-07-09 17:50:58,716 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1371 2025-07-09 14900.0 ... 2025-07-09 17:50:58.709576 2025-07-09 17:50:58.709973
[1 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-07-09 17:50:58,953 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-07-09 17:50:58.945925
117 2021-07-06 ... 2025-07-09 17:50:58.945925
121 2021-07-12 ... 2025-07-09 17:50:58.945925
122 2021-07-13 ... 2025-07-09 17:50:58.945925
194 2021-11-01 ... 2025-07-09 17:50:58.945925
[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-07-09 17:50:59,548 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3796 2025-07-05 80533.33
3797 2025-07-06 80533.33
3798 2025-07-07 79921.67
3799 2025-07-08 79826.67
3800 2025-07-09 79245.00
2025-07-09 17:50:59,620 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date value ... created_at updated_at
3800 2025-07-09 79245.0 ... 2025-07-09 17:50:59.613023 2025-07-09 17:50:59.613411
[1 rows x 5 columns]
2025-07-09 17:50:59,639 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-07-09 17:50:59,644 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3796 2025-07-05 80533.33
3797 2025-07-06 80533.33
3798 2025-07-07 79921.67
3799 2025-07-08 79826.67
3800 2025-07-09 79245.00
2025-07-09 17:50:59,716 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date value ... created_at updated_at
3803 2025-07-09 79245.0 ... 2025-07-09 17:50:59.709923 2025-07-09 17:50:59.710309
[1 rows x 5 columns]
2025-07-09 17:50:59,735 - 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-07-09 17:51:00,197 - 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-07-09 17:51:00,251 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-07-09 17:51:00,251 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-07-09 17:51:00,257 - 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-07-09 17:51:00,316 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-07-09 17:51:00,316 - 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-07-09 17:51:00,879 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2774 2025-07-05 267600.0
2775 2025-07-06 267600.0
2776 2025-07-07 266850.0
2777 2025-07-08 264862.5
2778 2025-07-09 265262.5
2025-07-09 17:51:00,939 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2778 2025-07-09 ... 2025-07-09 17:51:00.932888
[1 rows x 5 columns]
2025-07-09 17:51:00,957 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-07-09 17:51:00,963 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2774 2025-07-05 267600.0
2775 2025-07-06 267600.0
2776 2025-07-07 266850.0
2777 2025-07-08 264862.5
2778 2025-07-09 265262.5
2025-07-09 17:51:01,024 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2781 2025-07-09 ... 2025-07-09 17:51:01.017726
[1 rows x 5 columns]
2025-07-09 17:51:01,043 - 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-07-09 17:51:01,908 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3795 2025-07-05 22394.0
3796 2025-07-06 22394.0
3797 2025-07-07 22242.0
3798 2025-07-08 22010.0
3799 2025-07-09 22144.0
2025-07-09 17:51:01,980 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3799 2025-07-09 22144.0 ... 2025-07-09 17:51:01.973479 2025-07-09 17:51:01.973897
[1 rows x 5 columns]
2025-07-09 17:51:02,000 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-07-09 17:51:02,007 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3795 2025-07-05 22394.0
3796 2025-07-06 22394.0
3797 2025-07-07 22242.0
3798 2025-07-08 22010.0
3799 2025-07-09 22144.0
2025-07-09 17:51:02,080 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3802 2025-07-09 22144.0 ... 2025-07-09 17:51:02.073376 2025-07-09 17:51:02.073780
[1 rows x 5 columns]
2025-07-09 17:51:02,103 - 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-07-09 17:51:02,761 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3758 2025-07-05 3312.5
3759 2025-07-06 3312.5
3760 2025-07-07 3302.5
3761 2025-07-08 3302.5
3762 2025-07-09 3300.0
2025-07-09 17:51:02,834 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3762 2025-07-09 3300.0 ... 2025-07-09 17:51:02.826853 2025-07-09 17:51:02.827251
[1 rows x 5 columns]
2025-07-09 17:51:02,852 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-07-09 17:51:02,858 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3758 2025-07-05 3312.5
3759 2025-07-06 3312.5
3760 2025-07-07 3302.5
3761 2025-07-08 3302.5
3762 2025-07-09 3300.0
2025-07-09 17:51:02,930 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3765 2025-07-09 3300.0 ... 2025-07-09 17:51:02.923338 2025-07-09 17:51:02.923716
[1 rows x 5 columns]
2025-07-09 17:51:02,950 - 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-07-09 17:51:03,503 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1555 2025-07-05 4972.5
1556 2025-07-06 4972.5
1557 2025-07-07 4935.0
1558 2025-07-08 4885.0
1559 2025-07-09 4870.0
2025-07-09 17:51:03,547 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1559 2025-07-09 4870.0 ... 2025-07-09 17:51:03.540855 2025-07-09 17:51:03.541250
[1 rows x 5 columns]
2025-07-09 17:51:03,567 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-07-09 17:51:03,572 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1555 2025-07-05 4972.5
1556 2025-07-06 4972.5
1557 2025-07-07 4935.0
1558 2025-07-08 4885.0
1559 2025-07-09 4870.0
2025-07-09 17:51:03,619 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1562 2025-07-09 4870.0 ... 2025-07-09 17:51:03.611973 2025-07-09 17:51:03.612374
[1 rows x 5 columns]
2025-07-09 17:51:03,640 - 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-07-09 17:51:04,382 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2829 2025-07-05 2367.14
2830 2025-07-06 2367.14
2831 2025-07-07 2364.29
2832 2025-07-08 2360.00
2833 2025-07-09 2357.14
2025-07-09 17:51:04,446 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2833 2025-07-09 2357.14 ... 2025-07-09 17:51:04.438985 2025-07-09 17:51:04.439382
[1 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-07-09 17:51:04,486 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2832 2025-07-08 ... 2025-07-09 17:51:04.479850
[1 rows x 6 columns]
2025-07-09 17:51:04,511 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2829 2025-07-05 2367.14
2830 2025-07-06 2367.14
2831 2025-07-07 2364.29
2832 2025-07-08 2360.00
2833 2025-07-09 2357.14
2025-07-09 17:51:04,570 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2836 2025-07-09 2357.14 ... 2025-07-09 17:51:04.563769 2025-07-09 17:51:04.564154
[1 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-07-09 17:51:04,611 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2835 2025-07-08 ... 2025-07-09 17:51:04.604592
[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-07-09 17:51:05,159 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2829 2025-07-05 2367.14
2830 2025-07-06 2367.14
2831 2025-07-07 2364.29
2832 2025-07-08 2360.00
2833 2025-07-09 2944.00
2025-07-09 17:51:05,210 - 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-07-09 17:51:05,234 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2833 2025-07-09 ... 2025-07-09 17:51:05.226493
[1 rows x 6 columns]
2025-07-09 17:51:05,259 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2829 2025-07-05 2367.14
2830 2025-07-06 2367.14
2831 2025-07-07 2364.29
2832 2025-07-08 2360.00
2833 2025-07-09 2944.00
2025-07-09 17:51:05,314 - 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-07-09 17:51:05,338 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2836 2025-07-09 ... 2025-07-09 17:51:05.330712
[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-07-09 17:51:05,866 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3186 2025-07-05 9755.00
3187 2025-07-06 9755.00
3188 2025-07-07 9703.33
3189 2025-07-08 9745.00
3190 2025-07-09 9675.00
2025-07-09 17:51:05,922 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-07-09 17:51:05,922 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-07-09 17:51:05,928 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3186 2025-07-05 9755.00
3187 2025-07-06 9755.00
3188 2025-07-07 9703.33
3189 2025-07-08 9745.00
3190 2025-07-09 9675.00
2025-07-09 17:51:05,985 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-07-09 17:51:05,985 - 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-07-09 17:51:06,611 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1870 2025-07-05 4405.00
1871 2025-07-06 4405.00
1872 2025-07-07 4405.00
1873 2025-07-08 4400.00
1874 2025-07-09 4393.33
2025-07-09 17:51:06,658 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1874 2025-07-09 4393.33 ... 2025-07-09 17:51:06.651506 2025-07-09 17:51:06.651926
[1 rows x 5 columns]
2025-07-09 17:51:06,677 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-07-09 17:51:06,682 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1870 2025-07-05 4405.00
1871 2025-07-06 4405.00
1872 2025-07-07 4405.00
1873 2025-07-08 4400.00
1874 2025-07-09 4393.33
2025-07-09 17:51:06,730 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1877 2025-07-09 4393.33 ... 2025-07-09 17:51:06.723624 2025-07-09 17:51:06.724029
[1 rows x 5 columns]
2025-07-09 17:51:06,749 - 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-07-09 17:51:07,259 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1879 2025-07-05 5950.00
1880 2025-07-06 5950.00
1881 2025-07-07 5950.00
1882 2025-07-08 5916.67
1883 2025-07-09 5900.00
2025-07-09 17:51:07,307 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1883 2025-07-09 5900.0 ... 2025-07-09 17:51:07.300064 2025-07-09 17:51:07.300456
[1 rows x 5 columns]
2025-07-09 17:51:07,326 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-07-09 17:51:07,334 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1879 2025-07-05 5950.00
1880 2025-07-06 5950.00
1881 2025-07-07 5950.00
1882 2025-07-08 5916.67
1883 2025-07-09 5900.00
2025-07-09 17:51:07,395 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1886 2025-07-09 5900.0 ... 2025-07-09 17:51:07.388040 2025-07-09 17:51:07.388437
[1 rows x 5 columns]
2025-07-09 17:51:07,414 - 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-07-09 17:51:07,959 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3547 2025-07-05 8710.0
3548 2025-07-06 8710.0
3549 2025-07-07 8668.0
3550 2025-07-08 8828.0
3551 2025-07-09 8874.0
2025-07-09 17:51:08,029 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3551 2025-07-09 8874.0 ... 2025-07-09 17:51:08.021892 2025-07-09 17:51:08.022343
[1 rows x 5 columns]
2025-07-09 17:51:08,048 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-07-09 17:51:08,055 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3547 2025-07-05 8710.0
3548 2025-07-06 8710.0
3549 2025-07-07 8668.0
3550 2025-07-08 8828.0
3551 2025-07-09 8874.0
2025-07-09 17:51:08,125 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3554 2025-07-09 8874.0 ... 2025-07-09 17:51:08.117824 2025-07-09 17:51:08.118220
[1 rows x 5 columns]
2025-07-09 17:51:08,143 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data