=========================================================================
2025-07-01 17:50:26 Tue 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-01 17:50:28,968 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3347 2025-06-27 3072.0
3348 2025-06-28 3072.0
3349 2025-06-29 3072.0
3350 2025-06-30 3072.0
3351 2025-07-01 3069.0
2025-07-01 17:50:29,039 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3351 2025-07-01 3069.0 ... 2025-07-01 17:50:29.031947 2025-07-01 17:50:29.032402
[1 rows x 5 columns]
2025-07-01 17:50:29,062 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-07-01 17:50:29,069 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3347 2025-06-27 3072.0
3348 2025-06-28 3072.0
3349 2025-06-29 3072.0
3350 2025-06-30 3072.0
3351 2025-07-01 3069.0
2025-07-01 17:50:29,138 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3354 2025-07-01 3069.0 ... 2025-07-01 17:50:29.130820 2025-07-01 17:50:29.131223
[1 rows x 5 columns]
2025-07-01 17:50:29,157 - 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-01 17:50:29,770 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3568 2025-06-27 2785.83
3569 2025-06-28 2785.83
3570 2025-06-29 2785.83
3571 2025-06-30 2805.00
3572 2025-07-01 2530.00
2025-07-01 17:50:29,840 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3572 2025-07-01 2530.0 ... 2025-07-01 17:50:29.833487 2025-07-01 17:50:29.833917
[1 rows x 5 columns]
2025-07-01 17:50:29,861 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-07-01 17:50:29,867 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3568 2025-06-27 2785.83
3569 2025-06-28 2785.83
3570 2025-06-29 2785.83
3571 2025-06-30 2805.00
3572 2025-07-01 2530.00
2025-07-01 17:50:29,939 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3576 2025-07-01 2530.0 ... 2025-07-01 17:50:29.932420 2025-07-01 17:50:29.932831
[1 rows x 5 columns]
2025-07-01 17:50:29,959 - 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-01 17:50:30,548 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
908 2025-06-27 5084.75
909 2025-06-28 5084.75
910 2025-06-29 5084.75
911 2025-06-30 5104.75
912 2025-07-01 5081.66
2025-07-01 17:50:30,584 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
912 2025-07-01 5081.66 ... 2025-07-01 17:50:30.577571 2025-07-01 17:50:30.577987
[1 rows x 5 columns]
2025-07-01 17:50:30,603 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-07-01 17:50:30,608 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
908 2025-06-27 5084.75
909 2025-06-28 5084.75
910 2025-06-29 5084.75
911 2025-06-30 5104.75
912 2025-07-01 5081.66
2025-07-01 17:50:30,645 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
912 2025-07-01 5081.66 ... 2025-07-01 17:50:30.638201 2025-07-01 17:50:30.638577
[1 rows x 5 columns]
2025-07-01 17:50:30,663 - 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-01 17:50:31,239 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3787 2025-06-27 13878.33
3788 2025-06-28 13878.33
3789 2025-06-29 13878.33
3790 2025-06-30 13858.33
3791 2025-07-01 13928.33
2025-07-01 17:50:31,311 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3791 2025-07-01 ... 2025-07-01 17:50:31.304926
[1 rows x 5 columns]
2025-07-01 17:50:31,330 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-07-01 17:50:31,335 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3787 2025-06-27 13878.33
3788 2025-06-28 13878.33
3789 2025-06-29 13878.33
3790 2025-06-30 13858.33
3791 2025-07-01 13928.33
2025-07-01 17:50:31,408 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3794 2025-07-01 ... 2025-07-01 17:50:31.402045
[1 rows x 5 columns]
2025-07-01 17:50:31,427 - 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-01 17:50:32,005 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3119 2025-06-27 725.44
3120 2025-06-28 725.44
3121 2025-06-29 725.44
3122 2025-06-30 726.56
3123 2025-07-01 723.44
2025-07-01 17:50:32,071 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3123 2025-07-01 723.44 ... 2025-07-01 17:50:32.064092 2025-07-01 17:50:32.064490
[1 rows x 5 columns]
2025-07-01 17:50:32,090 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-07-01 17:50:32,096 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3119 2025-06-27 725.44
3120 2025-06-28 725.44
3121 2025-06-29 725.44
3122 2025-06-30 726.56
3123 2025-07-01 723.44
2025-07-01 17:50:32,161 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3126 2025-07-01 723.44 ... 2025-07-01 17:50:32.153688 2025-07-01 17:50:32.154103
[1 rows x 5 columns]
2025-07-01 17:50:32,179 - 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-01 17:50:32,700 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3322 2025-06-27 1105.6
3323 2025-06-28 1105.6
3324 2025-06-29 1105.6
3325 2025-06-30 1105.6
3326 2025-07-01 1108.0
2025-07-01 17:50:32,769 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3326 2025-07-01 1108.0 ... 2025-07-01 17:50:32.761523 2025-07-01 17:50:32.761983
[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-01 17:50:34,705 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-07-01 17:50:34.697196
21 2013-01-04 ... 2025-07-01 17:50:34.697196
54 2013-02-27 ... 2025-07-01 17:50:34.697196
60 2013-03-07 ... 2025-07-01 17:50:34.697196
61 2013-03-08 ... 2025-07-01 17:50:34.697196
[5 rows x 6 columns]
2025-07-01 17:50:34,861 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3322 2025-06-27 1105.6
3323 2025-06-28 1105.6
3324 2025-06-29 1105.6
3325 2025-06-30 1105.6
3326 2025-07-01 1108.0
2025-07-01 17:50:34,931 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3330 2025-07-01 1108.0 ... 2025-07-01 17:50:34.923773 2025-07-01 17:50:34.924209
[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-01 17:50:36,871 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-07-01 17:50:36.861366
21 2013-01-04 ... 2025-07-01 17:50:36.861366
54 2013-02-27 ... 2025-07-01 17:50:36.861366
60 2013-03-07 ... 2025-07-01 17:50:36.861366
61 2013-03-08 ... 2025-07-01 17:50:36.861366
[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-01 17:50:38,824 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1667 2025-06-27 8084.0
1668 2025-06-28 8084.0
1669 2025-06-29 8084.0
1670 2025-06-30 8050.0
1671 2025-07-01 8036.0
2025-07-01 17:50:38,872 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1671 2025-07-01 8036.0 ... 2025-07-01 17:50:38.865096 2025-07-01 17:50:38.865499
[1 rows x 5 columns]
2025-07-01 17:50:38,891 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-07-01 17:50:38,898 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1667 2025-06-27 8084.0
1668 2025-06-28 8084.0
1669 2025-06-29 8084.0
1670 2025-06-30 8050.0
1671 2025-07-01 8036.0
2025-07-01 17:50:38,946 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1674 2025-07-01 8036.0 ... 2025-07-01 17:50:38.939086 2025-07-01 17:50:38.939482
[1 rows x 5 columns]
2025-07-01 17:50:38,965 - 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-01 17:50:39,559 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3778 2025-06-27 6056.67
3779 2025-06-28 6056.67
3780 2025-06-29 6056.67
3781 2025-06-30 6053.33
3782 2025-07-01 6060.00
2025-07-01 17:50:39,631 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3782 2025-07-01 6060.0 ... 2025-07-01 17:50:39.624543 2025-07-01 17:50:39.624953
[1 rows x 5 columns]
2025-07-01 17:50:39,650 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-07-01 17:50:39,656 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3778 2025-06-27 6056.67
3779 2025-06-28 6056.67
3780 2025-06-29 6056.67
3781 2025-06-30 6053.33
3782 2025-07-01 6060.00
2025-07-01 17:50:39,729 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3786 2025-07-01 6060.0 ... 2025-07-01 17:50:39.722297 2025-07-01 17:50:39.722677
[1 rows x 5 columns]
2025-07-01 17:50:39,748 - 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-01 17:50:40,268 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1668 2025-06-27 12762.5
1669 2025-06-28 12762.5
1670 2025-06-29 12762.5
1671 2025-06-30 12775.0
1672 2025-07-01 12775.0
2025-07-01 17:50:40,314 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1672 2025-07-01 12775.0 ... 2025-07-01 17:50:40.307186 2025-07-01 17:50:40.307562
[1 rows x 5 columns]
2025-07-01 17:50:40,333 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-07-01 17:50:40,338 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1668 2025-06-27 12762.5
1669 2025-06-28 12762.5
1670 2025-06-29 12762.5
1671 2025-06-30 12775.0
1672 2025-07-01 12775.0
2025-07-01 17:50:40,385 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1675 2025-07-01 12775.0 ... 2025-07-01 17:50:40.378322 2025-07-01 17:50:40.378700
[1 rows x 5 columns]
2025-07-01 17:50:40,403 - 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-01 17:50:40,936 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3178 2025-06-27 9631.67
3179 2025-06-28 9631.67
3180 2025-06-29 9631.67
3181 2025-06-30 9581.67
3182 2025-07-01 9625.00
2025-07-01 17:50:41,005 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date value ... created_at updated_at
3182 2025-07-01 9625.0 ... 2025-07-01 17:50:40.998055 2025-07-01 17:50:40.998474
[1 rows x 5 columns]
2025-07-01 17:50:41,024 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-07-01 17:50:41,031 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3178 2025-06-27 9631.67
3179 2025-06-28 9631.67
3180 2025-06-29 9631.67
3181 2025-06-30 9581.67
3182 2025-07-01 9625.00
2025-07-01 17:50:41,104 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date value ... created_at updated_at
3186 2025-07-01 9625.0 ... 2025-07-01 17:50:41.096870 2025-07-01 17:50:41.097305
[1 rows x 5 columns]
2025-07-01 17:50:41,123 - 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-01 17:50:41,745 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3301 2025-06-27 2475.00
3302 2025-06-28 2475.00
3303 2025-06-29 2475.00
3304 2025-06-30 2500.00
3305 2025-07-01 2516.67
2025-07-01 17:50:41,812 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3305 2025-07-01 2516.67 ... 2025-07-01 17:50:41.804730 2025-07-01 17:50:41.805153
[1 rows x 5 columns]
2025-07-01 17:50:41,830 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-07-01 17:50:41,836 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3301 2025-06-27 2475.00
3302 2025-06-28 2475.00
3303 2025-06-29 2475.00
3304 2025-06-30 2500.00
3305 2025-07-01 2516.67
2025-07-01 17:50:41,904 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3309 2025-07-01 2516.67 ... 2025-07-01 17:50:41.897150 2025-07-01 17:50:41.897533
[1 rows x 5 columns]
2025-07-01 17:50:41,922 - 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-01 17:50:42,403 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1505 2025-06-27 1337.5
1506 2025-06-28 1337.5
1507 2025-06-29 1337.5
1508 2025-06-30 1325.0
1509 2025-07-01 1325.0
2025-07-01 17:50:42,448 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1509 2025-07-01 1325.0 ... 2025-07-01 17:50:42.440964 2025-07-01 17:50:42.441352
[1 rows x 5 columns]
2025-07-01 17:50:42,467 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-07-01 17:50:42,472 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1505 2025-06-27 1337.5
1506 2025-06-28 1337.5
1507 2025-06-29 1337.5
1508 2025-06-30 1325.0
1509 2025-07-01 1325.0
2025-07-01 17:50:42,517 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1513 2025-07-01 1325.0 ... 2025-07-01 17:50:42.510017 2025-07-01 17:50:42.510399
[1 rows x 5 columns]
2025-07-01 17:50:42,536 - 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-01 17:50:43,111 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1418 2025-06-27 6736.04
1419 2025-06-28 6736.04
1420 2025-06-29 6736.04
1421 2025-06-30 6727.92
1422 2025-07-01 6735.00
2025-07-01 17:50:43,154 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1422 2025-07-01 6735.0 ... 2025-07-01 17:50:43.146999 2025-07-01 17:50:43.147396
[1 rows x 5 columns]
2025-07-01 17:50:43,172 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-07-01 17:50:43,178 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1418 2025-06-27 6736.04
1419 2025-06-28 6736.04
1420 2025-06-29 6736.04
1421 2025-06-30 6727.92
1422 2025-07-01 6735.00
2025-07-01 17:50:43,221 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1426 2025-07-01 6735.0 ... 2025-07-01 17:50:43.214482 2025-07-01 17:50:43.214891
[1 rows x 5 columns]
2025-07-01 17:50:43,239 - 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-01 17:50:43,878 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3791 2025-06-27 2906.0
3792 2025-06-28 2906.0
3793 2025-06-29 2906.0
3794 2025-06-30 2906.0
3795 2025-07-01 2930.0
2025-07-01 17:50:43,950 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3795 2025-07-01 2930.0 ... 2025-07-01 17:50:43.943293 2025-07-01 17:50:43.943685
[1 rows x 5 columns]
2025-07-01 17:50:43,969 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-07-01 17:50:43,976 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3791 2025-06-27 2906.0
3792 2025-06-28 2906.0
3793 2025-06-29 2906.0
3794 2025-06-30 2906.0
3795 2025-07-01 2930.0
2025-07-01 17:50:44,052 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3798 2025-07-01 2930.0 ... 2025-07-01 17:50:44.044948 2025-07-01 17:50:44.045347
[1 rows x 5 columns]
2025-07-01 17:50:44,070 - 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-01 17:50:44,619 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3561 2025-06-27 8254.0
3562 2025-06-28 8254.0
3563 2025-06-29 8254.0
3564 2025-06-30 8234.0
3565 2025-07-01 8224.0
2025-07-01 17:50:44,693 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3565 2025-07-01 8224.0 ... 2025-07-01 17:50:44.685861 2025-07-01 17:50:44.686293
[1 rows x 5 columns]
2025-07-01 17:50:44,712 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-07-01 17:50:44,718 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3561 2025-06-27 8254.0
3562 2025-06-28 8254.0
3563 2025-06-29 8254.0
3564 2025-06-30 8234.0
3565 2025-07-01 8224.0
2025-07-01 17:50:44,791 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3568 2025-07-01 8224.0 ... 2025-07-01 17:50:44.783472 2025-07-01 17:50:44.783900
[1 rows x 5 columns]
2025-07-01 17:50:44,810 - 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-01 17:50:45,444 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3527 2025-06-27 4295.0
3528 2025-06-28 4295.0
3529 2025-06-29 4295.0
3530 2025-06-30 4295.0
3531 2025-07-01 4295.0
2025-07-01 17:50:45,514 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3531 2025-07-01 4295.0 ... 2025-07-01 17:50:45.506966 2025-07-01 17:50:45.507365
[1 rows x 5 columns]
2025-07-01 17:50:45,533 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-07-01 17:50:45,539 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3527 2025-06-27 4295.0
3528 2025-06-28 4295.0
3529 2025-06-29 4295.0
3530 2025-06-30 4295.0
3531 2025-07-01 4295.0
2025-07-01 17:50:45,609 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3534 2025-07-01 4295.0 ... 2025-07-01 17:50:45.601798 2025-07-01 17:50:45.602190
[1 rows x 5 columns]
2025-07-01 17:50:45,628 - 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-01 17:50:46,191 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2904 2025-06-27 5158.57
2905 2025-06-28 5158.57
2906 2025-06-29 5158.57
2907 2025-06-30 5158.57
2908 2025-07-01 5158.57
2025-07-01 17:50:46,252 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2908 2025-07-01 5158.57 ... 2025-07-01 17:50:46.245623 2025-07-01 17:50:46.246043
[1 rows x 5 columns]
2025-07-01 17:50:46,271 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-07-01 17:50:46,277 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2904 2025-06-27 5158.57
2905 2025-06-28 5158.57
2906 2025-06-29 5158.57
2907 2025-06-30 5158.57
2908 2025-07-01 5158.57
2025-07-01 17:50:46,342 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2912 2025-07-01 5158.57 ... 2025-07-01 17:50:46.335028 2025-07-01 17:50:46.335422
[1 rows x 5 columns]
2025-07-01 17:50:46,360 - 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-01 17:50:46,926 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3104 2025-06-27 2890.0
3105 2025-06-28 2890.0
3106 2025-06-29 2890.0
3107 2025-06-30 2810.0
3108 2025-07-01 2790.0
2025-07-01 17:50:46,990 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3108 2025-07-01 2790.0 ... 2025-07-01 17:50:46.983341 2025-07-01 17:50:46.983724
[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-01 17:50:47,134 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-07-01 17:50:47.126668
458 2015-09-21 ... 2025-07-01 17:50:47.126668
549 2016-02-03 ... 2025-07-01 17:50:47.126668
693 2016-09-05 ... 2025-07-01 17:50:47.126668
696 2016-09-08 ... 2025-07-01 17:50:47.126668
[5 rows x 6 columns]
2025-07-01 17:50:47,164 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3104 2025-06-27 2890.0
3105 2025-06-28 2890.0
3106 2025-06-29 2890.0
3107 2025-06-30 2810.0
3108 2025-07-01 2790.0
2025-07-01 17:50:47,232 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3111 2025-07-01 2790.0 ... 2025-07-01 17:50:47.224931 2025-07-01 17:50:47.225379
[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-01 17:50:47,377 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-07-01 17:50:47.369329
458 2015-09-21 ... 2025-07-01 17:50:47.369329
549 2016-02-03 ... 2025-07-01 17:50:47.369329
693 2016-09-05 ... 2025-07-01 17:50:47.369329
696 2016-09-08 ... 2025-07-01 17:50:47.369329
[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-01 17:50:47,949 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
908 2025-06-27 8620.0
909 2025-06-28 8640.0
910 2025-06-29 8640.0
911 2025-06-30 8730.0
912 2025-07-01 8730.0
2025-07-01 17:50:47,986 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
912 2025-07-01 8730.0 ... 2025-07-01 17:50:47.979069 2025-07-01 17:50:47.979453
[1 rows x 5 columns]
2025-07-01 17:50:48,004 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-07-01 17:50:48,010 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
908 2025-06-27 8620.0
909 2025-06-28 8640.0
910 2025-06-29 8640.0
911 2025-06-30 8730.0
912 2025-07-01 8730.0
2025-07-01 17:50:48,045 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
912 2025-07-01 8730.0 ... 2025-07-01 17:50:48.038742 2025-07-01 17:50:48.039169
[1 rows x 5 columns]
2025-07-01 17:50:48,067 - 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-01 17:50:48,634 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3787 2025-06-27 7511.67
3788 2025-06-28 7511.67
3789 2025-06-29 7511.67
3790 2025-06-30 7503.33
3791 2025-07-01 7486.67
2025-07-01 17:50:48,709 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3791 2025-07-01 7486.67 ... 2025-07-01 17:50:48.701578 2025-07-01 17:50:48.702029
[1 rows x 5 columns]
2025-07-01 17:50:48,728 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-07-01 17:50:48,734 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3787 2025-06-27 7511.67
3788 2025-06-28 7511.67
3789 2025-06-29 7511.67
3790 2025-06-30 7503.33
3791 2025-07-01 7486.67
2025-07-01 17:50:48,809 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3794 2025-07-01 7486.67 ... 2025-07-01 17:50:48.801499 2025-07-01 17:50:48.801916
[1 rows x 5 columns]
2025-07-01 17:50:48,827 - 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-01 17:50:49,406 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3125 2025-06-27 3700.00
3126 2025-06-28 3700.00
3127 2025-06-29 3700.00
3128 2025-06-30 3673.33
3129 2025-07-01 3670.00
2025-07-01 17:50:49,472 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3130 2025-07-01 3670.0 ... 2025-07-01 17:50:49.464798 2025-07-01 17:50:49.465227
[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-01 17:50:49,507 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-07-01 17:50:49.499571
[1 rows x 6 columns]
2025-07-01 17:50:49,530 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3125 2025-06-27 3700.00
3126 2025-06-28 3700.00
3127 2025-06-29 3700.00
3128 2025-06-30 3673.33
3129 2025-07-01 3670.00
2025-07-01 17:50:49,595 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3132 2025-07-01 3670.0 ... 2025-07-01 17:50:49.588775 2025-07-01 17:50:49.589169
[1 rows x 5 columns]
2025-07-01 17:50:49,614 - 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-01 17:50:50,217 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3790 2025-06-27 20903.33
3791 2025-06-28 20903.33
3792 2025-06-29 20903.33
3793 2025-06-30 20786.67
3794 2025-07-01 20786.67
2025-07-01 17:50:50,289 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date ... updated_at
3794 2025-07-01 ... 2025-07-01 17:50:50.282980
[1 rows x 5 columns]
2025-07-01 17:50:50,307 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-07-01 17:50:50,313 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3790 2025-06-27 20903.33
3791 2025-06-28 20903.33
3792 2025-06-29 20903.33
3793 2025-06-30 20786.67
3794 2025-07-01 20786.67
2025-07-01 17:50:50,461 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date ... updated_at
3797 2025-07-01 ... 2025-07-01 17:50:50.454985
[1 rows x 5 columns]
2025-07-01 17:50:50,479 - 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-01 17:50:51,058 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2904 2025-06-27 5572.0
2905 2025-06-28 5572.0
2906 2025-06-29 5572.0
2907 2025-06-30 5564.0
2908 2025-07-01 5536.0
2025-07-01 17:50:51,121 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2908 2025-07-01 5536.0 ... 2025-07-01 17:50:51.113635 2025-07-01 17:50:51.114091
[1 rows x 5 columns]
2025-07-01 17:50:51,141 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-07-01 17:50:51,147 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2904 2025-06-27 5572.0
2905 2025-06-28 5572.0
2906 2025-06-29 5572.0
2907 2025-06-30 5564.0
2908 2025-07-01 5536.0
2025-07-01 17:50:51,208 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2912 2025-07-01 5536.0 ... 2025-07-01 17:50:51.201628 2025-07-01 17:50:51.202049
[1 rows x 5 columns]
2025-07-01 17:50:51,227 - 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-01 17:50:51,818 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2179 2025-06-27 23200.0
2180 2025-06-28 23200.0
2181 2025-06-29 23200.0
2182 2025-06-30 23200.0
2183 2025-07-01 23200.0
2025-07-01 17:50:51,871 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2183 2025-07-01 23200.0 ... 2025-07-01 17:50:51.863846 2025-07-01 17:50:51.864305
[1 rows x 5 columns]
2025-07-01 17:50:51,889 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-07-01 17:50:51,894 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2179 2025-06-27 23200.0
2180 2025-06-28 23200.0
2181 2025-06-29 23200.0
2182 2025-06-30 23200.0
2183 2025-07-01 23200.0
2025-07-01 17:50:51,949 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2187 2025-07-01 23200.0 ... 2025-07-01 17:50:51.941975 2025-07-01 17:50:51.942366
[1 rows x 5 columns]
2025-07-01 17:50:51,968 - 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-01 17:50:52,586 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1694 2025-06-27 1827.0
1695 2025-06-28 1827.0
1696 2025-06-29 1827.0
1697 2025-06-30 1823.0
1698 2025-07-01 1829.0
2025-07-01 17:50:52,633 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1698 2025-07-01 1829.0 ... 2025-07-01 17:50:52.625659 2025-07-01 17:50:52.626094
[1 rows x 5 columns]
2025-07-01 17:50:52,651 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-07-01 17:50:52,657 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1694 2025-06-27 1827.0
1695 2025-06-28 1827.0
1696 2025-06-29 1827.0
1697 2025-06-30 1823.0
1698 2025-07-01 1829.0
2025-07-01 17:50:52,705 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1702 2025-07-01 1829.0 ... 2025-07-01 17:50:52.697643 2025-07-01 17:50:52.698087
[1 rows x 5 columns]
2025-07-01 17:50:52,722 - 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-01 17:50:53,373 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2766 2025-06-27 122433.33
2767 2025-06-28 122433.33
2768 2025-06-29 122433.33
2769 2025-06-30 122400.00
2770 2025-07-01 121700.00
2025-07-01 17:50:53,435 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2770 2025-07-01 ... 2025-07-01 17:50:53.428480
[1 rows x 5 columns]
2025-07-01 17:50:53,453 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-07-01 17:50:53,460 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2766 2025-06-27 122433.33
2767 2025-06-28 122433.33
2768 2025-06-29 122433.33
2769 2025-06-30 122400.00
2770 2025-07-01 121700.00
2025-07-01 17:50:53,522 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2773 2025-07-01 ... 2025-07-01 17:50:53.515504
[1 rows x 5 columns]
2025-07-01 17:50:53,545 - 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-01 17:50:54,115 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3791 2025-06-27 4673.0
3792 2025-06-28 4673.0
3793 2025-06-29 4673.0
3794 2025-06-30 4658.0
3795 2025-07-01 4597.0
2025-07-01 17:50:54,188 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3795 2025-07-01 4597.0 ... 2025-07-01 17:50:54.181192 2025-07-01 17:50:54.181589
[1 rows x 5 columns]
2025-07-01 17:50:54,207 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-07-01 17:50:54,213 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3791 2025-06-27 4673.0
3792 2025-06-28 4673.0
3793 2025-06-29 4673.0
3794 2025-06-30 4658.0
3795 2025-07-01 4597.0
2025-07-01 17:50:54,287 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3798 2025-07-01 4597.0 ... 2025-07-01 17:50:54.280580 2025-07-01 17:50:54.280997
[1 rows x 5 columns]
2025-07-01 17:50:54,306 - 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-01 17:50:54,871 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
3030 2025-06-27 7483.33
3031 2025-06-28 7483.33
3032 2025-06-29 7483.33
3033 2025-06-30 7466.67
3034 2025-07-01 7458.33
2025-07-01 17:50:54,935 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
3034 2025-07-01 7458.33 ... 2025-07-01 17:50:54.927660 2025-07-01 17:50:54.928077
[1 rows x 5 columns]
2025-07-01 17:50:54,953 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-07-01 17:50:54,960 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
3030 2025-06-27 7483.33
3031 2025-06-28 7483.33
3032 2025-06-29 7483.33
3033 2025-06-30 7466.67
3034 2025-07-01 7458.33
2025-07-01 17:50:55,024 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
3037 2025-07-01 7458.33 ... 2025-07-01 17:50:55.016550 2025-07-01 17:50:55.016989
[1 rows x 5 columns]
2025-07-01 17:50:55,042 - 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-01 17:50:55,607 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3792 2025-06-27 15105.67
3793 2025-06-28 15105.67
3794 2025-06-29 15105.67
3795 2025-06-30 15159.83
3796 2025-07-01 15210.00
2025-07-01 17:50:55,680 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date value ... created_at updated_at
3796 2025-07-01 15210.0 ... 2025-07-01 17:50:55.672943 2025-07-01 17:50:55.673336
[1 rows x 5 columns]
2025-07-01 17:50:55,701 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-07-01 17:50:55,707 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3792 2025-06-27 15105.67
3793 2025-06-28 15105.67
3794 2025-06-29 15105.67
3795 2025-06-30 15159.83
3796 2025-07-01 15210.00
2025-07-01 17:50:55,780 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date value ... created_at updated_at
3800 2025-07-01 15210.0 ... 2025-07-01 17:50:55.772802 2025-07-01 17:50:55.773201
[1 rows x 5 columns]
2025-07-01 17:50:55,798 - 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-01 17:50:56,390 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3737 2025-06-27 17072.50
3738 2025-06-28 17072.50
3739 2025-06-29 17072.50
3740 2025-06-30 17043.75
3741 2025-07-01 17018.75
2025-07-01 17:50:56,462 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date ... updated_at
3741 2025-07-01 ... 2025-07-01 17:50:56.455728
[1 rows x 5 columns]
2025-07-01 17:50:56,481 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-07-01 17:50:56,488 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3737 2025-06-27 17072.50
3738 2025-06-28 17072.50
3739 2025-06-29 17072.50
3740 2025-06-30 17043.75
3741 2025-07-01 17018.75
2025-07-01 17:50:56,559 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date ... updated_at
3744 2025-07-01 ... 2025-07-01 17:50:56.553692
[1 rows x 5 columns]
2025-07-01 17:50:56,578 - 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-01 17:50:57,141 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
3012 2025-06-27 3206.67
3013 2025-06-28 3206.67
3014 2025-06-29 3206.67
3015 2025-06-30 3210.00
3016 2025-07-01 3206.67
2025-07-01 17:50:57,204 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
3016 2025-07-01 3206.67 ... 2025-07-01 17:50:57.197160 2025-07-01 17:50:57.197542
[1 rows x 5 columns]
2025-07-01 17:50:57,223 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-07-01 17:50:57,228 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
3012 2025-06-27 3206.67
3013 2025-06-28 3206.67
3014 2025-06-29 3206.67
3015 2025-06-30 3210.00
3016 2025-07-01 3206.67
2025-07-01 17:50:57,291 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
3019 2025-07-01 3206.67 ... 2025-07-01 17:50:57.284623 2025-07-01 17:50:57.285041
[1 rows x 5 columns]
2025-07-01 17:50:57,310 - 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-01 17:50:57,956 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3292 2025-06-27 5525.0
3293 2025-06-28 5512.5
3294 2025-06-29 5512.5
3295 2025-06-30 5462.5
3296 2025-07-01 5437.5
2025-07-01 17:50:58,023 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3296 2025-07-01 5437.5 ... 2025-07-01 17:50:58.015995 2025-07-01 17:50:58.016381
[1 rows x 5 columns]
2025-07-01 17:50:58,043 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-07-01 17:50:58,049 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3292 2025-06-27 5525.0
3293 2025-06-28 5512.5
3294 2025-06-29 5512.5
3295 2025-06-30 5462.5
3296 2025-07-01 5437.5
2025-07-01 17:50:58,122 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3783 2025-07-01 5437.5 ... 2025-07-01 17:50:58.115140 2025-07-01 17:50:58.115527
[1 rows x 5 columns]
2025-07-01 17:50:58,142 - 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-01 17:50:58,660 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1356 2025-06-27 14420.0
1357 2025-06-28 14420.0
1358 2025-06-29 14420.0
1359 2025-06-30 14480.0
1360 2025-07-01 14620.0
2025-07-01 17:50:58,702 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1360 2025-07-01 14620.0 ... 2025-07-01 17:50:58.695508 2025-07-01 17:50:58.695920
[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-01 17:50:58,934 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-07-01 17:50:58.926313
117 2021-07-06 ... 2025-07-01 17:50:58.926313
121 2021-07-12 ... 2025-07-01 17:50:58.926313
122 2021-07-13 ... 2025-07-01 17:50:58.926313
194 2021-11-01 ... 2025-07-01 17:50:58.926313
[5 rows x 6 columns]
2025-07-01 17:50:58,970 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1356 2025-06-27 14420.0
1357 2025-06-28 14420.0
1358 2025-06-29 14420.0
1359 2025-06-30 14480.0
1360 2025-07-01 14620.0
2025-07-01 17:50:59,012 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1363 2025-07-01 14620.0 ... 2025-07-01 17:50:59.005442 2025-07-01 17:50:59.005851
[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-01 17:50:59,244 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-07-01 17:50:59.235564
117 2021-07-06 ... 2025-07-01 17:50:59.235564
121 2021-07-12 ... 2025-07-01 17:50:59.235564
122 2021-07-13 ... 2025-07-01 17:50:59.235564
194 2021-11-01 ... 2025-07-01 17:50:59.235564
[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-01 17:50:59,859 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3788 2025-06-27 80195.00
3789 2025-06-28 80195.00
3790 2025-06-29 80195.00
3791 2025-06-30 80001.67
3792 2025-07-01 80235.00
2025-07-01 17:50:59,933 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date value ... created_at updated_at
3792 2025-07-01 80235.0 ... 2025-07-01 17:50:59.925744 2025-07-01 17:50:59.926270
[1 rows x 5 columns]
2025-07-01 17:50:59,952 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-07-01 17:50:59,958 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3788 2025-06-27 80195.00
3789 2025-06-28 80195.00
3790 2025-06-29 80195.00
3791 2025-06-30 80001.67
3792 2025-07-01 80235.00
2025-07-01 17:51:00,036 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date value ... created_at updated_at
3795 2025-07-01 80235.0 ... 2025-07-01 17:51:00.029345 2025-07-01 17:51:00.029731
[1 rows x 5 columns]
2025-07-01 17:51:00,056 - 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-01 17:51:00,523 - 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-01 17:51:00,577 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-07-01 17:51:00,577 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-07-01 17:51:00,583 - 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-01 17:51:00,643 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-07-01 17:51:00,643 - 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-01 17:51:01,245 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2766 2025-06-27 269425.0
2767 2025-06-28 269425.0
2768 2025-06-29 269425.0
2769 2025-06-30 267487.5
2770 2025-07-01 266637.5
2025-07-01 17:51:01,308 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2770 2025-07-01 ... 2025-07-01 17:51:01.301136
[1 rows x 5 columns]
2025-07-01 17:51:01,328 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-07-01 17:51:01,335 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2766 2025-06-27 269425.0
2767 2025-06-28 269425.0
2768 2025-06-29 269425.0
2769 2025-06-30 267487.5
2770 2025-07-01 266637.5
2025-07-01 17:51:01,397 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2773 2025-07-01 ... 2025-07-01 17:51:01.391338
[1 rows x 5 columns]
2025-07-01 17:51:01,417 - 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-01 17:51:02,015 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3787 2025-06-27 22568.0
3788 2025-06-28 22568.0
3789 2025-06-29 22568.0
3790 2025-06-30 22486.0
3791 2025-07-01 22258.0
2025-07-01 17:51:02,090 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3791 2025-07-01 22258.0 ... 2025-07-01 17:51:02.082706 2025-07-01 17:51:02.083175
[1 rows x 5 columns]
2025-07-01 17:51:02,110 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-07-01 17:51:02,116 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3787 2025-06-27 22568.0
3788 2025-06-28 22568.0
3789 2025-06-29 22568.0
3790 2025-06-30 22486.0
3791 2025-07-01 22258.0
2025-07-01 17:51:02,191 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3794 2025-07-01 22258.0 ... 2025-07-01 17:51:02.184300 2025-07-01 17:51:02.184736
[1 rows x 5 columns]
2025-07-01 17:51:02,212 - 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-01 17:51:02,792 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3750 2025-06-27 3252.5
3751 2025-06-28 3252.5
3752 2025-06-29 3252.5
3753 2025-06-30 3260.0
3754 2025-07-01 3252.5
2025-07-01 17:51:02,867 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3754 2025-07-01 3252.5 ... 2025-07-01 17:51:02.860 2025-07-01 17:51:02.860408
[1 rows x 5 columns]
2025-07-01 17:51:02,886 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-07-01 17:51:02,893 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3750 2025-06-27 3252.5
3751 2025-06-28 3252.5
3752 2025-06-29 3252.5
3753 2025-06-30 3260.0
3754 2025-07-01 3252.5
2025-07-01 17:51:02,970 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3757 2025-07-01 3252.5 ... 2025-07-01 17:51:02.962200 2025-07-01 17:51:02.962623
[1 rows x 5 columns]
2025-07-01 17:51:02,989 - 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-01 17:51:03,558 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1547 2025-06-27 4967.5
1548 2025-06-28 4967.5
1549 2025-06-29 4967.5
1550 2025-06-30 4922.5
1551 2025-07-01 4922.5
2025-07-01 17:51:03,602 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1551 2025-07-01 4922.5 ... 2025-07-01 17:51:03.595511 2025-07-01 17:51:03.595922
[1 rows x 5 columns]
2025-07-01 17:51:03,622 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-07-01 17:51:03,627 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1547 2025-06-27 4967.5
1548 2025-06-28 4967.5
1549 2025-06-29 4967.5
1550 2025-06-30 4922.5
1551 2025-07-01 4922.5
2025-07-01 17:51:03,673 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1554 2025-07-01 4922.5 ... 2025-07-01 17:51:03.665657 2025-07-01 17:51:03.666067
[1 rows x 5 columns]
2025-07-01 17:51:03,691 - 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-01 17:51:04,295 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2821 2025-06-27 2352.86
2822 2025-06-28 2352.86
2823 2025-06-29 2352.86
2824 2025-06-30 2357.14
2825 2025-07-01 2365.71
2025-07-01 17:51:04,359 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2825 2025-07-01 2365.71 ... 2025-07-01 17:51:04.351777 2025-07-01 17:51:04.352181
[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-01 17:51:04,401 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2824 2025-06-30 ... 2025-07-01 17:51:04.394216
[1 rows x 6 columns]
2025-07-01 17:51:04,426 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2821 2025-06-27 2352.86
2822 2025-06-28 2352.86
2823 2025-06-29 2352.86
2824 2025-06-30 2357.14
2825 2025-07-01 2365.71
2025-07-01 17:51:04,490 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2828 2025-07-01 2365.71 ... 2025-07-01 17:51:04.482790 2025-07-01 17:51:04.483227
[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-01 17:51:04,532 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2827 2025-06-30 ... 2025-07-01 17:51:04.524800
[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-01 17:51:05,092 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2821 2025-06-27 2352.86
2822 2025-06-28 2352.86
2823 2025-06-29 2352.86
2824 2025-06-30 2357.14
2825 2025-07-01 2944.00
2025-07-01 17:51:05,144 - 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-01 17:51:05,166 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2825 2025-07-01 ... 2025-07-01 17:51:05.159401
[1 rows x 6 columns]
2025-07-01 17:51:05,191 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2821 2025-06-27 2352.86
2822 2025-06-28 2352.86
2823 2025-06-29 2352.86
2824 2025-06-30 2357.14
2825 2025-07-01 2944.00
2025-07-01 17:51:05,244 - 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-01 17:51:05,266 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2828 2025-07-01 ... 2025-07-01 17:51:05.259067
[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-01 17:51:05,799 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3178 2025-06-27 9631.67
3179 2025-06-28 9631.67
3180 2025-06-29 9631.67
3181 2025-06-30 9581.67
3182 2025-07-01 9625.00
2025-07-01 17:51:05,856 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-07-01 17:51:05,856 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-07-01 17:51:05,861 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3178 2025-06-27 9631.67
3179 2025-06-28 9631.67
3180 2025-06-29 9631.67
3181 2025-06-30 9581.67
3182 2025-07-01 9625.00
2025-07-01 17:51:05,919 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-07-01 17:51:05,919 - 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-01 17:51:06,578 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1862 2025-06-27 4416.67
1863 2025-06-28 4416.67
1864 2025-06-29 4416.67
1865 2025-06-30 4413.33
1866 2025-07-01 4396.67
2025-07-01 17:51:06,626 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1866 2025-07-01 4396.67 ... 2025-07-01 17:51:06.619440 2025-07-01 17:51:06.619844
[1 rows x 5 columns]
2025-07-01 17:51:06,644 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-07-01 17:51:06,650 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1862 2025-06-27 4416.67
1863 2025-06-28 4416.67
1864 2025-06-29 4416.67
1865 2025-06-30 4413.33
1866 2025-07-01 4396.67
2025-07-01 17:51:06,701 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1869 2025-07-01 4396.67 ... 2025-07-01 17:51:06.693628 2025-07-01 17:51:06.694041
[1 rows x 5 columns]
2025-07-01 17:51:06,719 - 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-01 17:51:07,315 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1871 2025-06-27 5983.33
1872 2025-06-28 5983.33
1873 2025-06-29 5983.33
1874 2025-06-30 5950.00
1875 2025-07-01 5950.00
2025-07-01 17:51:07,364 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1875 2025-07-01 5950.0 ... 2025-07-01 17:51:07.357023 2025-07-01 17:51:07.357407
[1 rows x 5 columns]
2025-07-01 17:51:07,383 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-07-01 17:51:07,388 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1871 2025-06-27 5983.33
1872 2025-06-28 5983.33
1873 2025-06-29 5983.33
1874 2025-06-30 5950.00
1875 2025-07-01 5950.00
2025-07-01 17:51:07,439 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1878 2025-07-01 5950.0 ... 2025-07-01 17:51:07.431958 2025-07-01 17:51:07.432349
[1 rows x 5 columns]
2025-07-01 17:51:07,457 - 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-01 17:51:08,174 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3539 2025-06-27 8586.0
3540 2025-06-28 8586.0
3541 2025-06-29 8586.0
3542 2025-06-30 8570.0
3543 2025-07-01 8600.0
2025-07-01 17:51:08,243 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3543 2025-07-01 8600.0 ... 2025-07-01 17:51:08.236201 2025-07-01 17:51:08.236578
[1 rows x 5 columns]
2025-07-01 17:51:08,262 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-07-01 17:51:08,268 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3539 2025-06-27 8586.0
3540 2025-06-28 8586.0
3541 2025-06-29 8586.0
3542 2025-06-30 8570.0
3543 2025-07-01 8600.0
2025-07-01 17:51:08,337 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3546 2025-07-01 8600.0 ... 2025-07-01 17:51:08.330575 2025-07-01 17:51:08.330991
[1 rows x 5 columns]
2025-07-01 17:51:08,356 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data