=========================================================================
2025-09-01 17:50:26 Mon START TASK.01 IOOppi_data update_data
=========================================================================
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-09-01 17:50:28,426 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3409 2025-08-28 3246.0
3410 2025-08-29 3226.0
3411 2025-08-30 3226.0
3412 2025-08-31 3226.0
3413 2025-09-01 3180.0
2025-09-01 17:50:28,507 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3411 2025-08-30 3226.0 ... 2025-09-01 17:50:28.499165 2025-09-01 17:50:28.499596
3412 2025-08-31 3226.0 ... 2025-09-01 17:50:28.499165 2025-09-01 17:50:28.499596
3413 2025-09-01 3180.0 ... 2025-09-01 17:50:28.499165 2025-09-01 17:50:28.499596
[3 rows x 5 columns]
2025-09-01 17:50:28,528 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-09-01 17:50:28,534 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3409 2025-08-28 3246.0
3410 2025-08-29 3226.0
3411 2025-08-30 3226.0
3412 2025-08-31 3226.0
3413 2025-09-01 3180.0
2025-09-01 17:50:28,603 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3414 2025-08-30 3226.0 ... 2025-09-01 17:50:28.595420 2025-09-01 17:50:28.595847
3415 2025-08-31 3226.0 ... 2025-09-01 17:50:28.595420 2025-09-01 17:50:28.595847
3416 2025-09-01 3180.0 ... 2025-09-01 17:50:28.595420 2025-09-01 17:50:28.595847
[3 rows x 5 columns]
2025-09-01 17:50:28,621 - 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-09-01 17:50:29,204 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3630 2025-08-28 2245.83
3631 2025-08-29 2241.67
3632 2025-08-30 2233.33
3633 2025-08-31 2233.33
3634 2025-09-01 2253.33
2025-09-01 17:50:29,284 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3632 2025-08-30 2233.33 ... 2025-09-01 17:50:29.276487 2025-09-01 17:50:29.276938
3633 2025-08-31 2233.33 ... 2025-09-01 17:50:29.276487 2025-09-01 17:50:29.276938
3634 2025-09-01 2253.33 ... 2025-09-01 17:50:29.276487 2025-09-01 17:50:29.276938
[3 rows x 5 columns]
2025-09-01 17:50:29,303 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-09-01 17:50:29,309 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3630 2025-08-28 2245.83
3631 2025-08-29 2241.67
3632 2025-08-30 2233.33
3633 2025-08-31 2233.33
3634 2025-09-01 2253.33
2025-09-01 17:50:29,380 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3636 2025-08-30 2233.33 ... 2025-09-01 17:50:29.373316 2025-09-01 17:50:29.373726
3637 2025-08-31 2233.33 ... 2025-09-01 17:50:29.373316 2025-09-01 17:50:29.373726
3638 2025-09-01 2253.33 ... 2025-09-01 17:50:29.373316 2025-09-01 17:50:29.373726
[3 rows x 5 columns]
2025-09-01 17:50:29,398 - 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-09-01 17:50:30,013 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
970 2025-08-28 4910.00
971 2025-08-29 4891.25
972 2025-08-30 4891.25
973 2025-08-31 4891.25
974 2025-09-01 4755.50
2025-09-01 17:50:30,058 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
972 2025-08-30 4891.25 ... 2025-09-01 17:50:30.048128 2025-09-01 17:50:30.048689
973 2025-08-31 4891.25 ... 2025-09-01 17:50:30.048128 2025-09-01 17:50:30.048689
974 2025-09-01 4755.50 ... 2025-09-01 17:50:30.048128 2025-09-01 17:50:30.048689
[3 rows x 5 columns]
2025-09-01 17:50:30,077 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-09-01 17:50:30,082 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
970 2025-08-28 4910.00
971 2025-08-29 4891.25
972 2025-08-30 4891.25
973 2025-08-31 4891.25
974 2025-09-01 4755.50
2025-09-01 17:50:30,118 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
972 2025-08-30 4891.25 ... 2025-09-01 17:50:30.111312 2025-09-01 17:50:30.111716
973 2025-08-31 4891.25 ... 2025-09-01 17:50:30.111312 2025-09-01 17:50:30.111716
974 2025-09-01 4755.50 ... 2025-09-01 17:50:30.111312 2025-09-01 17:50:30.111716
[3 rows x 5 columns]
2025-09-01 17:50:30,136 - 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-09-01 17:50:30,800 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3849 2025-08-28 15016.67
3850 2025-08-29 14966.67
3851 2025-08-30 14966.67
3852 2025-08-31 14966.67
3853 2025-09-01 14958.33
2025-09-01 17:50:30,875 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3851 2025-08-30 ... 2025-09-01 17:50:30.868328
3852 2025-08-31 ... 2025-09-01 17:50:30.868328
3853 2025-09-01 ... 2025-09-01 17:50:30.868328
[3 rows x 5 columns]
2025-09-01 17:50:30,894 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-09-01 17:50:30,900 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3849 2025-08-28 15016.67
3850 2025-08-29 14966.67
3851 2025-08-30 14966.67
3852 2025-08-31 14966.67
3853 2025-09-01 14958.33
2025-09-01 17:50:30,974 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3854 2025-08-30 ... 2025-09-01 17:50:30.967515
3855 2025-08-31 ... 2025-09-01 17:50:30.967515
3856 2025-09-01 ... 2025-09-01 17:50:30.967515
[3 rows x 5 columns]
2025-09-01 17:50:30,993 - 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-09-01 17:50:31,643 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3181 2025-08-28 786.00
3182 2025-08-29 794.00
3183 2025-08-30 794.00
3184 2025-08-31 794.00
3185 2025-09-01 780.78
2025-09-01 17:50:31,705 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3183 2025-08-30 794.00 ... 2025-09-01 17:50:31.698550 2025-09-01 17:50:31.698963
3184 2025-08-31 794.00 ... 2025-09-01 17:50:31.698550 2025-09-01 17:50:31.698963
3185 2025-09-01 780.78 ... 2025-09-01 17:50:31.698550 2025-09-01 17:50:31.698963
[3 rows x 5 columns]
2025-09-01 17:50:31,724 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-09-01 17:50:31,730 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3181 2025-08-28 786.00
3182 2025-08-29 794.00
3183 2025-08-30 794.00
3184 2025-08-31 794.00
3185 2025-09-01 780.78
2025-09-01 17:50:31,794 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3186 2025-08-30 794.00 ... 2025-09-01 17:50:31.787347 2025-09-01 17:50:31.787764
3187 2025-08-31 794.00 ... 2025-09-01 17:50:31.787347 2025-09-01 17:50:31.787764
3188 2025-09-01 780.78 ... 2025-09-01 17:50:31.787347 2025-09-01 17:50:31.787764
[3 rows x 5 columns]
2025-09-01 17:50:31,812 - 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-09-01 17:50:32,460 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3384 2025-08-28 1110.4
3385 2025-08-29 1110.4
3386 2025-08-30 1110.4
3387 2025-08-31 1110.4
3388 2025-09-01 1110.4
2025-09-01 17:50:32,526 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3386 2025-08-30 1110.4 ... 2025-09-01 17:50:32.518640 2025-09-01 17:50:32.519029
3387 2025-08-31 1110.4 ... 2025-09-01 17:50:32.518640 2025-09-01 17:50:32.519029
3388 2025-09-01 1110.4 ... 2025-09-01 17:50:32.518640 2025-09-01 17:50:32.519029
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-09-01 17:50:35,508 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-09-01 17:50:35.500710
21 2013-01-04 ... 2025-09-01 17:50:35.500710
54 2013-02-27 ... 2025-09-01 17:50:35.500710
60 2013-03-07 ... 2025-09-01 17:50:35.500710
61 2013-03-08 ... 2025-09-01 17:50:35.500710
[5 rows x 6 columns]
2025-09-01 17:50:35,708 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3384 2025-08-28 1110.4
3385 2025-08-29 1110.4
3386 2025-08-30 1110.4
3387 2025-08-31 1110.4
3388 2025-09-01 1110.4
2025-09-01 17:50:35,779 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3390 2025-08-30 1110.4 ... 2025-09-01 17:50:35.770353 2025-09-01 17:50:35.771061
3391 2025-08-31 1110.4 ... 2025-09-01 17:50:35.770353 2025-09-01 17:50:35.771061
3392 2025-09-01 1110.4 ... 2025-09-01 17:50:35.770353 2025-09-01 17:50:35.771061
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-09-01 17:50:38,280 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-09-01 17:50:38.272881
21 2013-01-04 ... 2025-09-01 17:50:38.272881
54 2013-02-27 ... 2025-09-01 17:50:38.272881
60 2013-03-07 ... 2025-09-01 17:50:38.272881
61 2013-03-08 ... 2025-09-01 17:50:38.272881
[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-09-01 17:50:39,034 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1729 2025-08-28 7570.0
1730 2025-08-29 7550.0
1731 2025-08-30 7550.0
1732 2025-08-31 7550.0
1733 2025-09-01 7510.0
2025-09-01 17:50:39,083 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1731 2025-08-30 7550.0 ... 2025-09-01 17:50:39.075719 2025-09-01 17:50:39.076120
1732 2025-08-31 7550.0 ... 2025-09-01 17:50:39.075719 2025-09-01 17:50:39.076120
1733 2025-09-01 7510.0 ... 2025-09-01 17:50:39.075719 2025-09-01 17:50:39.076120
[3 rows x 5 columns]
2025-09-01 17:50:39,103 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-09-01 17:50:39,109 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1729 2025-08-28 7570.0
1730 2025-08-29 7550.0
1731 2025-08-30 7550.0
1732 2025-08-31 7550.0
1733 2025-09-01 7510.0
2025-09-01 17:50:39,158 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1734 2025-08-30 7550.0 ... 2025-09-01 17:50:39.150590 2025-09-01 17:50:39.151004
1735 2025-08-31 7550.0 ... 2025-09-01 17:50:39.150590 2025-09-01 17:50:39.151004
1736 2025-09-01 7510.0 ... 2025-09-01 17:50:39.150590 2025-09-01 17:50:39.151004
[3 rows x 5 columns]
2025-09-01 17:50:39,177 - 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-09-01 17:50:40,035 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3840 2025-08-28 5953.33
3841 2025-08-29 5943.33
3842 2025-08-30 5943.33
3843 2025-08-31 5943.33
3844 2025-09-01 5943.33
2025-09-01 17:50:40,112 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3842 2025-08-30 5943.33 ... 2025-09-01 17:50:40.104467 2025-09-01 17:50:40.104906
3843 2025-08-31 5943.33 ... 2025-09-01 17:50:40.104467 2025-09-01 17:50:40.104906
3844 2025-09-01 5943.33 ... 2025-09-01 17:50:40.104467 2025-09-01 17:50:40.104906
[3 rows x 5 columns]
2025-09-01 17:50:40,131 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-09-01 17:50:40,138 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3840 2025-08-28 5953.33
3841 2025-08-29 5943.33
3842 2025-08-30 5943.33
3843 2025-08-31 5943.33
3844 2025-09-01 5943.33
2025-09-01 17:50:40,218 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3846 2025-08-30 5943.33 ... 2025-09-01 17:50:40.210039 2025-09-01 17:50:40.210442
3847 2025-08-31 5943.33 ... 2025-09-01 17:50:40.210039 2025-09-01 17:50:40.210442
3848 2025-09-01 5943.33 ... 2025-09-01 17:50:40.210039 2025-09-01 17:50:40.210442
[3 rows x 5 columns]
2025-09-01 17:50:40,237 - 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-09-01 17:50:40,900 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1730 2025-08-28 13075.0
1731 2025-08-29 13075.0
1732 2025-08-30 13075.0
1733 2025-08-31 13075.0
1734 2025-09-01 13080.0
2025-09-01 17:50:40,950 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1732 2025-08-30 13075.0 ... 2025-09-01 17:50:40.942377 2025-09-01 17:50:40.942805
1733 2025-08-31 13075.0 ... 2025-09-01 17:50:40.942377 2025-09-01 17:50:40.942805
1734 2025-09-01 13080.0 ... 2025-09-01 17:50:40.942377 2025-09-01 17:50:40.942805
[3 rows x 5 columns]
2025-09-01 17:50:40,968 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-09-01 17:50:40,974 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1730 2025-08-28 13075.0
1731 2025-08-29 13075.0
1732 2025-08-30 13075.0
1733 2025-08-31 13075.0
1734 2025-09-01 13080.0
2025-09-01 17:50:41,021 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1735 2025-08-30 13075.0 ... 2025-09-01 17:50:41.013228 2025-09-01 17:50:41.013613
1736 2025-08-31 13075.0 ... 2025-09-01 17:50:41.013228 2025-09-01 17:50:41.013613
1737 2025-09-01 13080.0 ... 2025-09-01 17:50:41.013228 2025-09-01 17:50:41.013613
[3 rows x 5 columns]
2025-09-01 17:50:41,040 - 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-09-01 17:50:41,672 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3240 2025-08-28 9926.67
3241 2025-08-29 9900.00
3242 2025-08-30 9900.00
3243 2025-08-31 9900.00
3244 2025-09-01 9910.00
2025-09-01 17:50:41,737 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date value ... created_at updated_at
3242 2025-08-30 9900.0 ... 2025-09-01 17:50:41.729374 2025-09-01 17:50:41.729778
3243 2025-08-31 9900.0 ... 2025-09-01 17:50:41.729374 2025-09-01 17:50:41.729778
3244 2025-09-01 9910.0 ... 2025-09-01 17:50:41.729374 2025-09-01 17:50:41.729778
[3 rows x 5 columns]
2025-09-01 17:50:41,755 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-09-01 17:50:41,761 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3240 2025-08-28 9926.67
3241 2025-08-29 9900.00
3242 2025-08-30 9900.00
3243 2025-08-31 9900.00
3244 2025-09-01 9910.00
2025-09-01 17:50:41,828 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date value ... created_at updated_at
3246 2025-08-30 9900.0 ... 2025-09-01 17:50:41.820658 2025-09-01 17:50:41.821042
3247 2025-08-31 9900.0 ... 2025-09-01 17:50:41.820658 2025-09-01 17:50:41.821042
3248 2025-09-01 9910.0 ... 2025-09-01 17:50:41.820658 2025-09-01 17:50:41.821042
[3 rows x 5 columns]
2025-09-01 17:50:41,846 - 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-09-01 17:50:42,443 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3363 2025-08-28 2543.33
3364 2025-08-29 2601.67
3365 2025-08-30 2601.67
3366 2025-08-31 2601.67
3367 2025-09-01 2623.33
2025-09-01 17:50:42,511 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3365 2025-08-30 2601.67 ... 2025-09-01 17:50:42.504180 2025-09-01 17:50:42.504606
3366 2025-08-31 2601.67 ... 2025-09-01 17:50:42.504180 2025-09-01 17:50:42.504606
3367 2025-09-01 2623.33 ... 2025-09-01 17:50:42.504180 2025-09-01 17:50:42.504606
[3 rows x 5 columns]
2025-09-01 17:50:42,531 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-09-01 17:50:42,536 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3363 2025-08-28 2543.33
3364 2025-08-29 2601.67
3365 2025-08-30 2601.67
3366 2025-08-31 2601.67
3367 2025-09-01 2623.33
2025-09-01 17:50:42,611 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3369 2025-08-30 2601.67 ... 2025-09-01 17:50:42.603709 2025-09-01 17:50:42.604099
3370 2025-08-31 2601.67 ... 2025-09-01 17:50:42.603709 2025-09-01 17:50:42.604099
3371 2025-09-01 2623.33 ... 2025-09-01 17:50:42.603709 2025-09-01 17:50:42.604099
[3 rows x 5 columns]
2025-09-01 17:50:42,630 - 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-09-01 17:50:43,334 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1567 2025-08-28 1290.0
1568 2025-08-29 1290.0
1569 2025-08-30 1290.0
1570 2025-08-31 1290.0
1571 2025-09-01 1290.0
2025-09-01 17:50:43,380 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1569 2025-08-30 1290.0 ... 2025-09-01 17:50:43.372688 2025-09-01 17:50:43.373107
1570 2025-08-31 1290.0 ... 2025-09-01 17:50:43.372688 2025-09-01 17:50:43.373107
1571 2025-09-01 1290.0 ... 2025-09-01 17:50:43.372688 2025-09-01 17:50:43.373107
[3 rows x 5 columns]
2025-09-01 17:50:43,399 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-09-01 17:50:43,404 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1567 2025-08-28 1290.0
1568 2025-08-29 1290.0
1569 2025-08-30 1290.0
1570 2025-08-31 1290.0
1571 2025-09-01 1290.0
2025-09-01 17:50:43,449 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1573 2025-08-30 1290.0 ... 2025-09-01 17:50:43.441952 2025-09-01 17:50:43.442339
1574 2025-08-31 1290.0 ... 2025-09-01 17:50:43.441952 2025-09-01 17:50:43.442339
1575 2025-09-01 1290.0 ... 2025-09-01 17:50:43.441952 2025-09-01 17:50:43.442339
[3 rows x 5 columns]
2025-09-01 17:50:43,468 - 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-09-01 17:50:44,088 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1480 2025-08-28 6567.54
1481 2025-08-29 6536.71
1482 2025-08-30 6536.71
1483 2025-08-31 6536.71
1484 2025-09-01 6535.12
2025-09-01 17:50:44,131 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1482 2025-08-30 6536.71 ... 2025-09-01 17:50:44.123887 2025-09-01 17:50:44.124271
1483 2025-08-31 6536.71 ... 2025-09-01 17:50:44.123887 2025-09-01 17:50:44.124271
1484 2025-09-01 6535.12 ... 2025-09-01 17:50:44.123887 2025-09-01 17:50:44.124271
[3 rows x 5 columns]
2025-09-01 17:50:44,149 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-09-01 17:50:44,155 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1480 2025-08-28 6567.54
1481 2025-08-29 6536.71
1482 2025-08-30 6536.71
1483 2025-08-31 6536.71
1484 2025-09-01 6535.12
2025-09-01 17:50:44,198 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1486 2025-08-30 6536.71 ... 2025-09-01 17:50:44.190803 2025-09-01 17:50:44.191185
1487 2025-08-31 6536.71 ... 2025-09-01 17:50:44.190803 2025-09-01 17:50:44.191185
1488 2025-09-01 6535.12 ... 2025-09-01 17:50:44.190803 2025-09-01 17:50:44.191185
[3 rows x 5 columns]
2025-09-01 17:50:44,216 - 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-09-01 17:50:44,832 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3853 2025-08-28 3102.0
3854 2025-08-29 3102.0
3855 2025-08-30 3102.0
3856 2025-08-31 3102.0
3857 2025-09-01 3106.0
2025-09-01 17:50:44,903 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3855 2025-08-30 3102.0 ... 2025-09-01 17:50:44.896121 2025-09-01 17:50:44.896502
3856 2025-08-31 3102.0 ... 2025-09-01 17:50:44.896121 2025-09-01 17:50:44.896502
3857 2025-09-01 3106.0 ... 2025-09-01 17:50:44.896121 2025-09-01 17:50:44.896502
[3 rows x 5 columns]
2025-09-01 17:50:44,921 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-09-01 17:50:44,927 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3853 2025-08-28 3102.0
3854 2025-08-29 3102.0
3855 2025-08-30 3102.0
3856 2025-08-31 3102.0
3857 2025-09-01 3106.0
2025-09-01 17:50:44,999 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3858 2025-08-30 3102.0 ... 2025-09-01 17:50:44.992034 2025-09-01 17:50:44.992409
3859 2025-08-31 3102.0 ... 2025-09-01 17:50:44.992034 2025-09-01 17:50:44.992409
3860 2025-09-01 3106.0 ... 2025-09-01 17:50:44.992034 2025-09-01 17:50:44.992409
[3 rows x 5 columns]
2025-09-01 17:50:45,017 - 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-09-01 17:50:45,631 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3623 2025-08-28 8448.0
3624 2025-08-29 8428.0
3625 2025-08-30 8428.0
3626 2025-08-31 8428.0
3627 2025-09-01 8420.0
2025-09-01 17:50:45,702 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3625 2025-08-30 8428.0 ... 2025-09-01 17:50:45.694587 2025-09-01 17:50:45.695062
3626 2025-08-31 8428.0 ... 2025-09-01 17:50:45.694587 2025-09-01 17:50:45.695062
3627 2025-09-01 8420.0 ... 2025-09-01 17:50:45.694587 2025-09-01 17:50:45.695062
[3 rows x 5 columns]
2025-09-01 17:50:45,721 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-09-01 17:50:45,727 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3623 2025-08-28 8448.0
3624 2025-08-29 8428.0
3625 2025-08-30 8428.0
3626 2025-08-31 8428.0
3627 2025-09-01 8420.0
2025-09-01 17:50:45,800 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3628 2025-08-30 8428.0 ... 2025-09-01 17:50:45.792472 2025-09-01 17:50:45.792885
3629 2025-08-31 8428.0 ... 2025-09-01 17:50:45.792472 2025-09-01 17:50:45.792885
3630 2025-09-01 8420.0 ... 2025-09-01 17:50:45.792472 2025-09-01 17:50:45.792885
[3 rows x 5 columns]
2025-09-01 17:50:45,819 - 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-09-01 17:50:46,432 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3589 2025-08-28 4300.0
3590 2025-08-29 4305.0
3591 2025-08-30 4305.0
3592 2025-08-31 4305.0
3593 2025-09-01 4305.0
2025-09-01 17:50:46,504 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3591 2025-08-30 4305.0 ... 2025-09-01 17:50:46.496688 2025-09-01 17:50:46.497077
3592 2025-08-31 4305.0 ... 2025-09-01 17:50:46.496688 2025-09-01 17:50:46.497077
3593 2025-09-01 4305.0 ... 2025-09-01 17:50:46.496688 2025-09-01 17:50:46.497077
[3 rows x 5 columns]
2025-09-01 17:50:46,523 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-09-01 17:50:46,529 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3589 2025-08-28 4300.0
3590 2025-08-29 4305.0
3591 2025-08-30 4305.0
3592 2025-08-31 4305.0
3593 2025-09-01 4305.0
2025-09-01 17:50:46,603 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3594 2025-08-30 4305.0 ... 2025-09-01 17:50:46.593910 2025-09-01 17:50:46.594372
3595 2025-08-31 4305.0 ... 2025-09-01 17:50:46.593910 2025-09-01 17:50:46.594372
3596 2025-09-01 4305.0 ... 2025-09-01 17:50:46.593910 2025-09-01 17:50:46.594372
[3 rows x 5 columns]
2025-09-01 17:50:46,622 - 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-09-01 17:50:47,257 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2966 2025-08-28 5310.00
2967 2025-08-29 5310.00
2968 2025-08-30 5310.00
2969 2025-08-31 5310.00
2970 2025-09-01 5207.14
2025-09-01 17:50:47,318 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2968 2025-08-30 5310.00 ... 2025-09-01 17:50:47.311123 2025-09-01 17:50:47.311510
2969 2025-08-31 5310.00 ... 2025-09-01 17:50:47.311123 2025-09-01 17:50:47.311510
2970 2025-09-01 5207.14 ... 2025-09-01 17:50:47.311123 2025-09-01 17:50:47.311510
[3 rows x 5 columns]
2025-09-01 17:50:47,337 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-09-01 17:50:47,344 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2966 2025-08-28 5310.00
2967 2025-08-29 5310.00
2968 2025-08-30 5310.00
2969 2025-08-31 5310.00
2970 2025-09-01 5207.14
2025-09-01 17:50:47,414 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2972 2025-08-30 5310.00 ... 2025-09-01 17:50:47.407011 2025-09-01 17:50:47.407398
2973 2025-08-31 5310.00 ... 2025-09-01 17:50:47.407011 2025-09-01 17:50:47.407398
2974 2025-09-01 5207.14 ... 2025-09-01 17:50:47.407011 2025-09-01 17:50:47.407398
[3 rows x 5 columns]
2025-09-01 17:50:47,433 - 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-09-01 17:50:47,989 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3166 2025-08-28 3265.0
3167 2025-08-29 3235.0
3168 2025-08-30 3235.0
3169 2025-08-31 3235.0
3170 2025-09-01 3225.0
2025-09-01 17:50:48,053 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3168 2025-08-30 3235.0 ... 2025-09-01 17:50:48.045851 2025-09-01 17:50:48.046234
3169 2025-08-31 3235.0 ... 2025-09-01 17:50:48.045851 2025-09-01 17:50:48.046234
3170 2025-09-01 3225.0 ... 2025-09-01 17:50:48.045851 2025-09-01 17:50:48.046234
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-09-01 17:50:48,198 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-09-01 17:50:48.190259
458 2015-09-21 ... 2025-09-01 17:50:48.190259
549 2016-02-03 ... 2025-09-01 17:50:48.190259
693 2016-09-05 ... 2025-09-01 17:50:48.190259
696 2016-09-08 ... 2025-09-01 17:50:48.190259
[5 rows x 6 columns]
2025-09-01 17:50:48,234 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3166 2025-08-28 3265.0
3167 2025-08-29 3235.0
3168 2025-08-30 3235.0
3169 2025-08-31 3235.0
3170 2025-09-01 3225.0
2025-09-01 17:50:48,299 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3171 2025-08-30 3235.0 ... 2025-09-01 17:50:48.292331 2025-09-01 17:50:48.292742
3172 2025-08-31 3235.0 ... 2025-09-01 17:50:48.292331 2025-09-01 17:50:48.292742
3173 2025-09-01 3225.0 ... 2025-09-01 17:50:48.292331 2025-09-01 17:50:48.292742
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-09-01 17:50:48,446 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-09-01 17:50:48.438736
458 2015-09-21 ... 2025-09-01 17:50:48.438736
549 2016-02-03 ... 2025-09-01 17:50:48.438736
693 2016-09-05 ... 2025-09-01 17:50:48.438736
696 2016-09-08 ... 2025-09-01 17:50:48.438736
[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-09-01 17:50:49,234 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
970 2025-08-28 9540.0
971 2025-08-29 9360.0
972 2025-08-30 9360.0
973 2025-08-31 9360.0
974 2025-09-01 9360.0
2025-09-01 17:50:49,273 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
972 2025-08-30 9360.0 ... 2025-09-01 17:50:49.265838 2025-09-01 17:50:49.266227
973 2025-08-31 9360.0 ... 2025-09-01 17:50:49.265838 2025-09-01 17:50:49.266227
974 2025-09-01 9360.0 ... 2025-09-01 17:50:49.265838 2025-09-01 17:50:49.266227
[3 rows x 5 columns]
2025-09-01 17:50:49,293 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-09-01 17:50:49,299 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
970 2025-08-28 9540.0
971 2025-08-29 9360.0
972 2025-08-30 9360.0
973 2025-08-31 9360.0
974 2025-09-01 9360.0
2025-09-01 17:50:49,338 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
972 2025-08-30 9360.0 ... 2025-09-01 17:50:49.330337 2025-09-01 17:50:49.330818
973 2025-08-31 9360.0 ... 2025-09-01 17:50:49.330337 2025-09-01 17:50:49.330818
974 2025-09-01 9360.0 ... 2025-09-01 17:50:49.330337 2025-09-01 17:50:49.330818
[3 rows x 5 columns]
2025-09-01 17:50:49,360 - 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-09-01 17:50:49,947 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3849 2025-08-28 7445.00
3850 2025-08-29 7445.00
3851 2025-08-30 7445.00
3852 2025-08-31 7445.00
3853 2025-09-01 7428.33
2025-09-01 17:50:50,020 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3851 2025-08-30 7445.00 ... 2025-09-01 17:50:50.013271 2025-09-01 17:50:50.013683
3852 2025-08-31 7445.00 ... 2025-09-01 17:50:50.013271 2025-09-01 17:50:50.013683
3853 2025-09-01 7428.33 ... 2025-09-01 17:50:50.013271 2025-09-01 17:50:50.013683
[3 rows x 5 columns]
2025-09-01 17:50:50,039 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-09-01 17:50:50,045 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3849 2025-08-28 7445.00
3850 2025-08-29 7445.00
3851 2025-08-30 7445.00
3852 2025-08-31 7445.00
3853 2025-09-01 7428.33
2025-09-01 17:50:50,120 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3854 2025-08-30 7445.00 ... 2025-09-01 17:50:50.113476 2025-09-01 17:50:50.113891
3855 2025-08-31 7445.00 ... 2025-09-01 17:50:50.113476 2025-09-01 17:50:50.113891
3856 2025-09-01 7428.33 ... 2025-09-01 17:50:50.113476 2025-09-01 17:50:50.113891
[3 rows x 5 columns]
2025-09-01 17:50:50,140 - 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-09-01 17:50:50,726 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3187 2025-08-28 3680.0
3188 2025-08-29 3680.0
3189 2025-08-30 3660.0
3190 2025-08-31 3660.0
3191 2025-09-01 3680.0
2025-09-01 17:50:50,791 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3190 2025-08-30 3660.0 ... 2025-09-01 17:50:50.783931 2025-09-01 17:50:50.784313
3191 2025-08-31 3660.0 ... 2025-09-01 17:50:50.783931 2025-09-01 17:50:50.784313
3192 2025-09-01 3680.0 ... 2025-09-01 17:50:50.783931 2025-09-01 17:50:50.784313
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-09-01 17:50:50,827 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-09-01 17:50:50.819005
[1 rows x 6 columns]
2025-09-01 17:50:50,853 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3187 2025-08-28 3680.0
3188 2025-08-29 3680.0
3189 2025-08-30 3660.0
3190 2025-08-31 3660.0
3191 2025-09-01 3680.0
2025-09-01 17:50:50,923 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3192 2025-08-30 3660.0 ... 2025-09-01 17:50:50.915060 2025-09-01 17:50:50.915448
3193 2025-08-31 3660.0 ... 2025-09-01 17:50:50.915060 2025-09-01 17:50:50.915448
3194 2025-09-01 3680.0 ... 2025-09-01 17:50:50.915060 2025-09-01 17:50:50.915448
[3 rows x 5 columns]
2025-09-01 17:50:50,941 - 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-09-01 17:50:51,577 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3852 2025-08-28 20790.00
3853 2025-08-29 20746.67
3854 2025-08-30 20746.67
3855 2025-08-31 20746.67
3856 2025-09-01 20746.67
2025-09-01 17:50:51,652 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date ... updated_at
3854 2025-08-30 ... 2025-09-01 17:50:51.646548
3855 2025-08-31 ... 2025-09-01 17:50:51.646548
3856 2025-09-01 ... 2025-09-01 17:50:51.646548
[3 rows x 5 columns]
2025-09-01 17:50:51,671 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-09-01 17:50:51,677 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3852 2025-08-28 20790.00
3853 2025-08-29 20746.67
3854 2025-08-30 20746.67
3855 2025-08-31 20746.67
3856 2025-09-01 20746.67
2025-09-01 17:50:51,751 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date ... updated_at
3857 2025-08-30 ... 2025-09-01 17:50:51.745121
3858 2025-08-31 ... 2025-09-01 17:50:51.745121
3859 2025-09-01 ... 2025-09-01 17:50:51.745121
[3 rows x 5 columns]
2025-09-01 17:50:51,772 - 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-09-01 17:50:52,388 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2966 2025-08-28 5704.0
2967 2025-08-29 5676.0
2968 2025-08-30 5676.0
2969 2025-08-31 5676.0
2970 2025-09-01 5638.0
2025-09-01 17:50:52,454 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2968 2025-08-30 5676.0 ... 2025-09-01 17:50:52.447182 2025-09-01 17:50:52.447581
2969 2025-08-31 5676.0 ... 2025-09-01 17:50:52.447182 2025-09-01 17:50:52.447581
2970 2025-09-01 5638.0 ... 2025-09-01 17:50:52.447182 2025-09-01 17:50:52.447581
[3 rows x 5 columns]
2025-09-01 17:50:52,473 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-09-01 17:50:52,478 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2966 2025-08-28 5704.0
2967 2025-08-29 5676.0
2968 2025-08-30 5676.0
2969 2025-08-31 5676.0
2970 2025-09-01 5638.0
2025-09-01 17:50:52,611 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2972 2025-08-30 5676.0 ... 2025-09-01 17:50:52.604111 2025-09-01 17:50:52.604490
2973 2025-08-31 5676.0 ... 2025-09-01 17:50:52.604111 2025-09-01 17:50:52.604490
2974 2025-09-01 5638.0 ... 2025-09-01 17:50:52.604111 2025-09-01 17:50:52.604490
[3 rows x 5 columns]
2025-09-01 17:50:52,630 - 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-09-01 17:50:53,213 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2241 2025-08-28 23550.0
2242 2025-08-29 23550.0
2243 2025-08-30 23550.0
2244 2025-08-31 23550.0
2245 2025-09-01 23550.0
2025-09-01 17:50:53,286 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2243 2025-08-30 23550.0 ... 2025-09-01 17:50:53.278853 2025-09-01 17:50:53.279259
2244 2025-08-31 23550.0 ... 2025-09-01 17:50:53.278853 2025-09-01 17:50:53.279259
2245 2025-09-01 23550.0 ... 2025-09-01 17:50:53.278853 2025-09-01 17:50:53.279259
[3 rows x 5 columns]
2025-09-01 17:50:53,305 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-09-01 17:50:53,310 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2241 2025-08-28 23550.0
2242 2025-08-29 23550.0
2243 2025-08-30 23550.0
2244 2025-08-31 23550.0
2245 2025-09-01 23550.0
2025-09-01 17:50:53,376 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2247 2025-08-30 23550.0 ... 2025-09-01 17:50:53.368417 2025-09-01 17:50:53.368841
2248 2025-08-31 23550.0 ... 2025-09-01 17:50:53.368417 2025-09-01 17:50:53.368841
2249 2025-09-01 23550.0 ... 2025-09-01 17:50:53.368417 2025-09-01 17:50:53.368841
[3 rows x 5 columns]
2025-09-01 17:50:53,394 - 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-09-01 17:50:53,958 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1756 2025-08-28 1717.5
1757 2025-08-29 1712.5
1758 2025-08-30 1712.5
1759 2025-08-31 1712.5
1760 2025-09-01 1707.5
2025-09-01 17:50:54,005 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1758 2025-08-30 1712.5 ... 2025-09-01 17:50:53.997936 2025-09-01 17:50:53.998322
1759 2025-08-31 1712.5 ... 2025-09-01 17:50:53.997936 2025-09-01 17:50:53.998322
1760 2025-09-01 1707.5 ... 2025-09-01 17:50:53.997936 2025-09-01 17:50:53.998322
[3 rows x 5 columns]
2025-09-01 17:50:54,023 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-09-01 17:50:54,029 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1756 2025-08-28 1717.5
1757 2025-08-29 1712.5
1758 2025-08-30 1712.5
1759 2025-08-31 1712.5
1760 2025-09-01 1707.5
2025-09-01 17:50:54,076 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1762 2025-08-30 1712.5 ... 2025-09-01 17:50:54.069080 2025-09-01 17:50:54.069465
1763 2025-08-31 1712.5 ... 2025-09-01 17:50:54.069080 2025-09-01 17:50:54.069465
1764 2025-09-01 1707.5 ... 2025-09-01 17:50:54.069080 2025-09-01 17:50:54.069465
[3 rows x 5 columns]
2025-09-01 17:50:54,095 - 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-09-01 17:50:54,874 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2828 2025-08-28 121966.67
2829 2025-08-29 122516.67
2830 2025-08-30 122516.67
2831 2025-08-31 122516.67
2832 2025-09-01 124566.67
2025-09-01 17:50:54,935 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2830 2025-08-30 ... 2025-09-01 17:50:54.928811
2831 2025-08-31 ... 2025-09-01 17:50:54.928811
2832 2025-09-01 ... 2025-09-01 17:50:54.928811
[3 rows x 5 columns]
2025-09-01 17:50:54,954 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-09-01 17:50:54,959 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2828 2025-08-28 121966.67
2829 2025-08-29 122516.67
2830 2025-08-30 122516.67
2831 2025-08-31 122516.67
2832 2025-09-01 124566.67
2025-09-01 17:50:55,018 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2833 2025-08-30 ... 2025-09-01 17:50:55.011925
2834 2025-08-31 ... 2025-09-01 17:50:55.011925
2835 2025-09-01 ... 2025-09-01 17:50:55.011925
[3 rows x 5 columns]
2025-09-01 17:50:55,036 - 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-09-01 17:50:55,658 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3853 2025-08-28 4678.0
3854 2025-08-29 4676.0
3855 2025-08-30 4676.0
3856 2025-08-31 4676.0
3857 2025-09-01 4643.0
2025-09-01 17:50:55,730 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3855 2025-08-30 4676.0 ... 2025-09-01 17:50:55.723021 2025-09-01 17:50:55.723404
3856 2025-08-31 4676.0 ... 2025-09-01 17:50:55.723021 2025-09-01 17:50:55.723404
3857 2025-09-01 4643.0 ... 2025-09-01 17:50:55.723021 2025-09-01 17:50:55.723404
[3 rows x 5 columns]
2025-09-01 17:50:55,749 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-09-01 17:50:55,754 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3853 2025-08-28 4678.0
3854 2025-08-29 4676.0
3855 2025-08-30 4676.0
3856 2025-08-31 4676.0
3857 2025-09-01 4643.0
2025-09-01 17:50:55,828 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3858 2025-08-30 4676.0 ... 2025-09-01 17:50:55.821294 2025-09-01 17:50:55.821707
3859 2025-08-31 4676.0 ... 2025-09-01 17:50:55.821294 2025-09-01 17:50:55.821707
3860 2025-09-01 4643.0 ... 2025-09-01 17:50:55.821294 2025-09-01 17:50:55.821707
[3 rows x 5 columns]
2025-09-01 17:50:55,847 - 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-09-01 17:50:56,439 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
3092 2025-08-28 7215.00
3093 2025-08-29 7206.67
3094 2025-08-30 7206.67
3095 2025-08-31 7206.67
3096 2025-09-01 7180.00
2025-09-01 17:50:56,504 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
3094 2025-08-30 7206.67 ... 2025-09-01 17:50:56.496503 2025-09-01 17:50:56.496965
3095 2025-08-31 7206.67 ... 2025-09-01 17:50:56.496503 2025-09-01 17:50:56.496965
3096 2025-09-01 7180.00 ... 2025-09-01 17:50:56.496503 2025-09-01 17:50:56.496965
[3 rows x 5 columns]
2025-09-01 17:50:56,522 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-09-01 17:50:56,528 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
3092 2025-08-28 7215.00
3093 2025-08-29 7206.67
3094 2025-08-30 7206.67
3095 2025-08-31 7206.67
3096 2025-09-01 7180.00
2025-09-01 17:50:56,591 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
3097 2025-08-30 7206.67 ... 2025-09-01 17:50:56.583986 2025-09-01 17:50:56.584387
3098 2025-08-31 7206.67 ... 2025-09-01 17:50:56.583986 2025-09-01 17:50:56.584387
3099 2025-09-01 7180.00 ... 2025-09-01 17:50:56.583986 2025-09-01 17:50:56.584387
[3 rows x 5 columns]
2025-09-01 17:50:56,609 - 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-09-01 17:50:57,242 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3854 2025-08-28 15331.83
3855 2025-08-29 15327.67
3856 2025-08-30 15327.67
3857 2025-08-31 15327.67
3858 2025-09-01 15478.67
2025-09-01 17:50:57,314 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date ... updated_at
3856 2025-08-30 ... 2025-09-01 17:50:57.308204
3857 2025-08-31 ... 2025-09-01 17:50:57.308204
3858 2025-09-01 ... 2025-09-01 17:50:57.308204
[3 rows x 5 columns]
2025-09-01 17:50:57,333 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-09-01 17:50:57,342 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3854 2025-08-28 15331.83
3855 2025-08-29 15327.67
3856 2025-08-30 15327.67
3857 2025-08-31 15327.67
3858 2025-09-01 15478.67
2025-09-01 17:50:57,415 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date ... updated_at
3860 2025-08-30 ... 2025-09-01 17:50:57.408899
3861 2025-08-31 ... 2025-09-01 17:50:57.408899
3862 2025-09-01 ... 2025-09-01 17:50:57.408899
[3 rows x 5 columns]
2025-09-01 17:50:57,433 - 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-09-01 17:50:58,069 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3799 2025-08-28 16837.5
3800 2025-08-29 16800.0
3801 2025-08-30 16800.0
3802 2025-08-31 16800.0
3803 2025-09-01 16800.0
2025-09-01 17:50:58,141 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date value ... created_at updated_at
3801 2025-08-30 16800.0 ... 2025-09-01 17:50:58.133914 2025-09-01 17:50:58.134297
3802 2025-08-31 16800.0 ... 2025-09-01 17:50:58.133914 2025-09-01 17:50:58.134297
3803 2025-09-01 16800.0 ... 2025-09-01 17:50:58.133914 2025-09-01 17:50:58.134297
[3 rows x 5 columns]
2025-09-01 17:50:58,160 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-09-01 17:50:58,165 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3799 2025-08-28 16837.5
3800 2025-08-29 16800.0
3801 2025-08-30 16800.0
3802 2025-08-31 16800.0
3803 2025-09-01 16800.0
2025-09-01 17:50:58,236 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date value ... created_at updated_at
3804 2025-08-30 16800.0 ... 2025-09-01 17:50:58.229781 2025-09-01 17:50:58.230157
3805 2025-08-31 16800.0 ... 2025-09-01 17:50:58.229781 2025-09-01 17:50:58.230157
3806 2025-09-01 16800.0 ... 2025-09-01 17:50:58.229781 2025-09-01 17:50:58.230157
[3 rows x 5 columns]
2025-09-01 17:50:58,255 - 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-09-01 17:50:58,979 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
3074 2025-08-28 3403.33
3075 2025-08-29 3413.33
3076 2025-08-30 3413.33
3077 2025-08-31 3413.33
3078 2025-09-01 3383.33
2025-09-01 17:50:59,045 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
3076 2025-08-30 3413.33 ... 2025-09-01 17:50:59.037982 2025-09-01 17:50:59.038378
3077 2025-08-31 3413.33 ... 2025-09-01 17:50:59.037982 2025-09-01 17:50:59.038378
3078 2025-09-01 3383.33 ... 2025-09-01 17:50:59.037982 2025-09-01 17:50:59.038378
[3 rows x 5 columns]
2025-09-01 17:50:59,063 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-09-01 17:50:59,069 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
3074 2025-08-28 3403.33
3075 2025-08-29 3413.33
3076 2025-08-30 3413.33
3077 2025-08-31 3413.33
3078 2025-09-01 3383.33
2025-09-01 17:50:59,132 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
3079 2025-08-30 3413.33 ... 2025-09-01 17:50:59.124990 2025-09-01 17:50:59.125365
3080 2025-08-31 3413.33 ... 2025-09-01 17:50:59.124990 2025-09-01 17:50:59.125365
3081 2025-09-01 3383.33 ... 2025-09-01 17:50:59.124990 2025-09-01 17:50:59.125365
[3 rows x 5 columns]
2025-09-01 17:50:59,150 - 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-09-01 17:50:59,994 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3354 2025-08-28 5350.0
3355 2025-08-29 5387.5
3356 2025-08-30 5387.5
3357 2025-08-31 5387.5
3358 2025-09-01 5387.5
2025-09-01 17:51:00,060 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3356 2025-08-30 5387.5 ... 2025-09-01 17:51:00.052863 2025-09-01 17:51:00.053252
3357 2025-08-31 5387.5 ... 2025-09-01 17:51:00.052863 2025-09-01 17:51:00.053252
3358 2025-09-01 5387.5 ... 2025-09-01 17:51:00.052863 2025-09-01 17:51:00.053252
[3 rows x 5 columns]
2025-09-01 17:51:00,080 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-09-01 17:51:00,086 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3354 2025-08-28 5350.0
3355 2025-08-29 5387.5
3356 2025-08-30 5387.5
3357 2025-08-31 5387.5
3358 2025-09-01 5387.5
2025-09-01 17:51:00,159 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3843 2025-08-30 5387.5 ... 2025-09-01 17:51:00.152242 2025-09-01 17:51:00.152648
3844 2025-08-31 5387.5 ... 2025-09-01 17:51:00.152242 2025-09-01 17:51:00.152648
3845 2025-09-01 5387.5 ... 2025-09-01 17:51:00.152242 2025-09-01 17:51:00.152648
[3 rows x 5 columns]
2025-09-01 17:51:00,178 - 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-09-01 17:51:00,780 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1418 2025-08-28 13780.0
1419 2025-08-29 13780.0
1420 2025-08-30 13780.0
1421 2025-08-31 13780.0
1422 2025-09-01 13870.0
2025-09-01 17:51:00,824 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1420 2025-08-30 13780.0 ... 2025-09-01 17:51:00.816459 2025-09-01 17:51:00.816911
1421 2025-08-31 13780.0 ... 2025-09-01 17:51:00.816459 2025-09-01 17:51:00.816911
1422 2025-09-01 13870.0 ... 2025-09-01 17:51:00.816459 2025-09-01 17:51:00.816911
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-09-01 17:51:01,062 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-09-01 17:51:01.053615
117 2021-07-06 ... 2025-09-01 17:51:01.053615
121 2021-07-12 ... 2025-09-01 17:51:01.053615
122 2021-07-13 ... 2025-09-01 17:51:01.053615
194 2021-11-01 ... 2025-09-01 17:51:01.053615
[5 rows x 6 columns]
2025-09-01 17:51:01,101 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1418 2025-08-28 13780.0
1419 2025-08-29 13780.0
1420 2025-08-30 13780.0
1421 2025-08-31 13780.0
1422 2025-09-01 13870.0
2025-09-01 17:51:01,152 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1423 2025-08-30 13780.0 ... 2025-09-01 17:51:01.144287 2025-09-01 17:51:01.144745
1424 2025-08-31 13780.0 ... 2025-09-01 17:51:01.144287 2025-09-01 17:51:01.144745
1425 2025-09-01 13870.0 ... 2025-09-01 17:51:01.144287 2025-09-01 17:51:01.144745
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-09-01 17:51:01,388 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-09-01 17:51:01.380718
117 2021-07-06 ... 2025-09-01 17:51:01.380718
121 2021-07-12 ... 2025-09-01 17:51:01.380718
122 2021-07-13 ... 2025-09-01 17:51:01.380718
194 2021-11-01 ... 2025-09-01 17:51:01.380718
[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-09-01 17:51:02,091 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3850 2025-08-28 79183.33
3851 2025-08-29 79401.67
3852 2025-08-30 79401.67
3853 2025-08-31 79401.67
3854 2025-09-01 79993.33
2025-09-01 17:51:02,166 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date ... updated_at
3852 2025-08-30 ... 2025-09-01 17:51:02.159637
3853 2025-08-31 ... 2025-09-01 17:51:02.159637
3854 2025-09-01 ... 2025-09-01 17:51:02.159637
[3 rows x 5 columns]
2025-09-01 17:51:02,186 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-09-01 17:51:02,192 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3850 2025-08-28 79183.33
3851 2025-08-29 79401.67
3852 2025-08-30 79401.67
3853 2025-08-31 79401.67
3854 2025-09-01 79993.33
2025-09-01 17:51:02,267 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date ... updated_at
3855 2025-08-30 ... 2025-09-01 17:51:02.260665
3856 2025-08-31 ... 2025-09-01 17:51:02.260665
3857 2025-09-01 ... 2025-09-01 17:51:02.260665
[3 rows x 5 columns]
2025-09-01 17:51:02,286 - 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-09-01 17:51:02,823 - 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-09-01 17:51:02,875 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-09-01 17:51:02,875 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-09-01 17:51:02,880 - 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-09-01 17:51:02,939 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-09-01 17:51:02,939 - 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-09-01 17:51:03,667 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2828 2025-08-28 272287.5
2829 2025-08-29 273212.5
2830 2025-08-30 273212.5
2831 2025-08-31 273212.5
2832 2025-09-01 272675.0
2025-09-01 17:51:03,730 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2830 2025-08-30 ... 2025-09-01 17:51:03.723325
2831 2025-08-31 ... 2025-09-01 17:51:03.723325
2832 2025-09-01 ... 2025-09-01 17:51:03.723325
[3 rows x 5 columns]
2025-09-01 17:51:03,749 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-09-01 17:51:03,755 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2828 2025-08-28 272287.5
2829 2025-08-29 273212.5
2830 2025-08-30 273212.5
2831 2025-08-31 273212.5
2832 2025-09-01 272675.0
2025-09-01 17:51:03,817 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2833 2025-08-30 ... 2025-09-01 17:51:03.811256
2834 2025-08-31 ... 2025-09-01 17:51:03.811256
2835 2025-09-01 ... 2025-09-01 17:51:03.811256
[3 rows x 5 columns]
2025-09-01 17:51:03,836 - 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-09-01 17:51:04,503 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3849 2025-08-28 22106.0
3850 2025-08-29 22002.0
3851 2025-08-30 22002.0
3852 2025-08-31 22002.0
3853 2025-09-01 22076.0
2025-09-01 17:51:04,579 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3851 2025-08-30 22002.0 ... 2025-09-01 17:51:04.571732 2025-09-01 17:51:04.572122
3852 2025-08-31 22002.0 ... 2025-09-01 17:51:04.571732 2025-09-01 17:51:04.572122
3853 2025-09-01 22076.0 ... 2025-09-01 17:51:04.571732 2025-09-01 17:51:04.572122
[3 rows x 5 columns]
2025-09-01 17:51:04,598 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-09-01 17:51:04,606 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3849 2025-08-28 22106.0
3850 2025-08-29 22002.0
3851 2025-08-30 22002.0
3852 2025-08-31 22002.0
3853 2025-09-01 22076.0
2025-09-01 17:51:04,679 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3854 2025-08-30 22002.0 ... 2025-09-01 17:51:04.672454 2025-09-01 17:51:04.672866
3855 2025-08-31 22002.0 ... 2025-09-01 17:51:04.672454 2025-09-01 17:51:04.672866
3856 2025-09-01 22076.0 ... 2025-09-01 17:51:04.672454 2025-09-01 17:51:04.672866
[3 rows x 5 columns]
2025-09-01 17:51:04,701 - 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-09-01 17:51:05,495 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3812 2025-08-28 3390.0
3813 2025-08-29 3377.5
3814 2025-08-30 3377.5
3815 2025-08-31 3377.5
3816 2025-09-01 3377.5
2025-09-01 17:51:05,566 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3814 2025-08-30 3377.5 ... 2025-09-01 17:51:05.559524 2025-09-01 17:51:05.559937
3815 2025-08-31 3377.5 ... 2025-09-01 17:51:05.559524 2025-09-01 17:51:05.559937
3816 2025-09-01 3377.5 ... 2025-09-01 17:51:05.559524 2025-09-01 17:51:05.559937
[3 rows x 5 columns]
2025-09-01 17:51:05,588 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-09-01 17:51:05,594 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3812 2025-08-28 3390.0
3813 2025-08-29 3377.5
3814 2025-08-30 3377.5
3815 2025-08-31 3377.5
3816 2025-09-01 3377.5
2025-09-01 17:51:05,665 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3817 2025-08-30 3377.5 ... 2025-09-01 17:51:05.658260 2025-09-01 17:51:05.658665
3818 2025-08-31 3377.5 ... 2025-09-01 17:51:05.658260 2025-09-01 17:51:05.658665
3819 2025-09-01 3377.5 ... 2025-09-01 17:51:05.658260 2025-09-01 17:51:05.658665
[3 rows x 5 columns]
2025-09-01 17:51:05,683 - 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-09-01 17:51:06,265 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1609 2025-08-28 4790.0
1610 2025-08-29 4782.5
1611 2025-08-30 4782.5
1612 2025-08-31 4782.5
1613 2025-09-01 4782.5
2025-09-01 17:51:06,311 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1611 2025-08-30 4782.5 ... 2025-09-01 17:51:06.304019 2025-09-01 17:51:06.304399
1612 2025-08-31 4782.5 ... 2025-09-01 17:51:06.304019 2025-09-01 17:51:06.304399
1613 2025-09-01 4782.5 ... 2025-09-01 17:51:06.304019 2025-09-01 17:51:06.304399
[3 rows x 5 columns]
2025-09-01 17:51:06,332 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-09-01 17:51:06,338 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1609 2025-08-28 4790.0
1610 2025-08-29 4782.5
1611 2025-08-30 4782.5
1612 2025-08-31 4782.5
1613 2025-09-01 4782.5
2025-09-01 17:51:06,383 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1614 2025-08-30 4782.5 ... 2025-09-01 17:51:06.376356 2025-09-01 17:51:06.376766
1615 2025-08-31 4782.5 ... 2025-09-01 17:51:06.376356 2025-09-01 17:51:06.376766
1616 2025-09-01 4782.5 ... 2025-09-01 17:51:06.376356 2025-09-01 17:51:06.376766
[3 rows x 5 columns]
2025-09-01 17:51:06,402 - 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-09-01 17:51:06,992 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2883 2025-08-28 2301.43
2884 2025-08-29 2301.43
2885 2025-08-30 2301.43
2886 2025-08-31 2301.43
2887 2025-09-01 2301.43
2025-09-01 17:51:07,056 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2885 2025-08-30 2301.43 ... 2025-09-01 17:51:07.048912 2025-09-01 17:51:07.049292
2886 2025-08-31 2301.43 ... 2025-09-01 17:51:07.048912 2025-09-01 17:51:07.049292
2887 2025-09-01 2301.43 ... 2025-09-01 17:51:07.048912 2025-09-01 17:51:07.049292
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-09-01 17:51:07,097 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2884 2025-08-29 ... 2025-09-01 17:51:07.090831
[1 rows x 6 columns]
2025-09-01 17:51:07,120 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2883 2025-08-28 2301.43
2884 2025-08-29 2301.43
2885 2025-08-30 2301.43
2886 2025-08-31 2301.43
2887 2025-09-01 2301.43
2025-09-01 17:51:07,182 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2888 2025-08-30 2301.43 ... 2025-09-01 17:51:07.175249 2025-09-01 17:51:07.175642
2889 2025-08-31 2301.43 ... 2025-09-01 17:51:07.175249 2025-09-01 17:51:07.175642
2890 2025-09-01 2301.43 ... 2025-09-01 17:51:07.175249 2025-09-01 17:51:07.175642
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-09-01 17:51:07,223 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2887 2025-08-29 ... 2025-09-01 17:51:07.216715
[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-09-01 17:51:07,828 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2883 2025-08-28 2301.43
2884 2025-08-29 2301.43
2885 2025-08-30 2301.43
2886 2025-08-31 2301.43
2887 2025-09-01 2872.00
2025-09-01 17:51:07,879 - 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-09-01 17:51:07,902 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2887 2025-09-01 ... 2025-09-01 17:51:07.894676
[1 rows x 6 columns]
2025-09-01 17:51:07,925 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2883 2025-08-28 2301.43
2884 2025-08-29 2301.43
2885 2025-08-30 2301.43
2886 2025-08-31 2301.43
2887 2025-09-01 2872.00
2025-09-01 17:51:07,977 - 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-09-01 17:51:08,003 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2890 2025-09-01 ... 2025-09-01 17:51:07.996144
[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-09-01 17:51:08,649 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3240 2025-08-28 9926.67
3241 2025-08-29 9900.00
3242 2025-08-30 9900.00
3243 2025-08-31 9900.00
3244 2025-09-01 9910.00
2025-09-01 17:51:08,705 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-09-01 17:51:08,705 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-09-01 17:51:08,710 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3240 2025-08-28 9926.67
3241 2025-08-29 9900.00
3242 2025-08-30 9900.00
3243 2025-08-31 9900.00
3244 2025-09-01 9910.00
2025-09-01 17:51:08,767 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-09-01 17:51:08,767 - 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-09-01 17:51:09,341 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1924 2025-08-28 4498.33
1925 2025-08-29 4496.67
1926 2025-08-30 4496.67
1927 2025-08-31 4496.67
1928 2025-09-01 4496.67
2025-09-01 17:51:09,389 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1926 2025-08-30 4496.67 ... 2025-09-01 17:51:09.382036 2025-09-01 17:51:09.382418
1927 2025-08-31 4496.67 ... 2025-09-01 17:51:09.382036 2025-09-01 17:51:09.382418
1928 2025-09-01 4496.67 ... 2025-09-01 17:51:09.382036 2025-09-01 17:51:09.382418
[3 rows x 5 columns]
2025-09-01 17:51:09,408 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-09-01 17:51:09,413 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1924 2025-08-28 4498.33
1925 2025-08-29 4496.67
1926 2025-08-30 4496.67
1927 2025-08-31 4496.67
1928 2025-09-01 4496.67
2025-09-01 17:51:09,461 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1929 2025-08-30 4496.67 ... 2025-09-01 17:51:09.454391 2025-09-01 17:51:09.454792
1930 2025-08-31 4496.67 ... 2025-09-01 17:51:09.454391 2025-09-01 17:51:09.454792
1931 2025-09-01 4496.67 ... 2025-09-01 17:51:09.454391 2025-09-01 17:51:09.454792
[3 rows x 5 columns]
2025-09-01 17:51:09,479 - 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-09-01 17:51:10,095 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1933 2025-08-28 5750.00
1934 2025-08-29 5733.33
1935 2025-08-30 5733.33
1936 2025-08-31 5733.33
1937 2025-09-01 5733.33
2025-09-01 17:51:10,143 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1935 2025-08-30 5733.33 ... 2025-09-01 17:51:10.136413 2025-09-01 17:51:10.136833
1936 2025-08-31 5733.33 ... 2025-09-01 17:51:10.136413 2025-09-01 17:51:10.136833
1937 2025-09-01 5733.33 ... 2025-09-01 17:51:10.136413 2025-09-01 17:51:10.136833
[3 rows x 5 columns]
2025-09-01 17:51:10,162 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-09-01 17:51:10,167 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1933 2025-08-28 5750.00
1934 2025-08-29 5733.33
1935 2025-08-30 5733.33
1936 2025-08-31 5733.33
1937 2025-09-01 5733.33
2025-09-01 17:51:10,216 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1938 2025-08-30 5733.33 ... 2025-09-01 17:51:10.209066 2025-09-01 17:51:10.209430
1939 2025-08-31 5733.33 ... 2025-09-01 17:51:10.209066 2025-09-01 17:51:10.209430
1940 2025-09-01 5733.33 ... 2025-09-01 17:51:10.209066 2025-09-01 17:51:10.209430
[3 rows x 5 columns]
2025-09-01 17:51:10,236 - 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-09-01 17:51:10,910 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3601 2025-08-28 9532.0
3602 2025-08-29 9532.0
3603 2025-08-30 9532.0
3604 2025-08-31 9532.0
3605 2025-09-01 9404.0
2025-09-01 17:51:10,982 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3603 2025-08-30 9532.0 ... 2025-09-01 17:51:10.975060 2025-09-01 17:51:10.975467
3604 2025-08-31 9532.0 ... 2025-09-01 17:51:10.975060 2025-09-01 17:51:10.975467
3605 2025-09-01 9404.0 ... 2025-09-01 17:51:10.975060 2025-09-01 17:51:10.975467
[3 rows x 5 columns]
2025-09-01 17:51:11,001 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-09-01 17:51:11,007 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3601 2025-08-28 9532.0
3602 2025-08-29 9532.0
3603 2025-08-30 9532.0
3604 2025-08-31 9532.0
3605 2025-09-01 9404.0
2025-09-01 17:51:11,080 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3606 2025-08-30 9532.0 ... 2025-09-01 17:51:11.072503 2025-09-01 17:51:11.072944
3607 2025-08-31 9532.0 ... 2025-09-01 17:51:11.072503 2025-09-01 17:51:11.072944
3608 2025-09-01 9404.0 ... 2025-09-01 17:51:11.072503 2025-09-01 17:51:11.072944
[3 rows x 5 columns]
2025-09-01 17:51:11,098 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data