=========================================================================
2025-09-08 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-08 17:50:28,568 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3416 2025-09-04 3157.5
3417 2025-09-05 3154.5
3418 2025-09-06 3154.5
3419 2025-09-07 3154.5
3420 2025-09-08 3149.5
2025-09-08 17:50:28,648 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3418 2025-09-06 3154.5 ... 2025-09-08 17:50:28.641035 2025-09-08 17:50:28.641439
3419 2025-09-07 3154.5 ... 2025-09-08 17:50:28.641035 2025-09-08 17:50:28.641439
3420 2025-09-08 3149.5 ... 2025-09-08 17:50:28.641035 2025-09-08 17:50:28.641439
[3 rows x 5 columns]
2025-09-08 17:50:28,669 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-09-08 17:50:28,675 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3416 2025-09-04 3157.5
3417 2025-09-05 3154.5
3418 2025-09-06 3154.5
3419 2025-09-07 3154.5
3420 2025-09-08 3149.5
2025-09-08 17:50:28,748 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3421 2025-09-06 3154.5 ... 2025-09-08 17:50:28.740944 2025-09-08 17:50:28.741330
3422 2025-09-07 3154.5 ... 2025-09-08 17:50:28.740944 2025-09-08 17:50:28.741330
3423 2025-09-08 3149.5 ... 2025-09-08 17:50:28.740944 2025-09-08 17:50:28.741330
[3 rows x 5 columns]
2025-09-08 17:50:28,767 - 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-08 17:50:29,332 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3637 2025-09-04 2245.83
3638 2025-09-05 2271.67
3639 2025-09-06 2271.67
3640 2025-09-07 2271.67
3641 2025-09-08 2271.67
2025-09-08 17:50:29,408 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3639 2025-09-06 2271.67 ... 2025-09-08 17:50:29.400806 2025-09-08 17:50:29.401210
3640 2025-09-07 2271.67 ... 2025-09-08 17:50:29.400806 2025-09-08 17:50:29.401210
3641 2025-09-08 2271.67 ... 2025-09-08 17:50:29.400806 2025-09-08 17:50:29.401210
[3 rows x 5 columns]
2025-09-08 17:50:29,427 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-09-08 17:50:29,433 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3637 2025-09-04 2245.83
3638 2025-09-05 2271.67
3639 2025-09-06 2271.67
3640 2025-09-07 2271.67
3641 2025-09-08 2271.67
2025-09-08 17:50:29,507 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3643 2025-09-06 2271.67 ... 2025-09-08 17:50:29.500218 2025-09-08 17:50:29.500674
3644 2025-09-07 2271.67 ... 2025-09-08 17:50:29.500218 2025-09-08 17:50:29.500674
3645 2025-09-08 2271.67 ... 2025-09-08 17:50:29.500218 2025-09-08 17:50:29.500674
[3 rows x 5 columns]
2025-09-08 17:50:29,526 - 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-08 17:50:30,199 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
977 2025-09-04 4740.5
978 2025-09-05 4739.5
979 2025-09-06 4739.5
980 2025-09-07 4739.5
981 2025-09-08 4720.0
2025-09-08 17:50:30,238 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
979 2025-09-06 4739.5 ... 2025-09-08 17:50:30.231303 2025-09-08 17:50:30.231751
980 2025-09-07 4739.5 ... 2025-09-08 17:50:30.231303 2025-09-08 17:50:30.231751
981 2025-09-08 4720.0 ... 2025-09-08 17:50:30.231303 2025-09-08 17:50:30.231751
[3 rows x 5 columns]
2025-09-08 17:50:30,258 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-09-08 17:50:30,263 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
977 2025-09-04 4740.5
978 2025-09-05 4739.5
979 2025-09-06 4739.5
980 2025-09-07 4739.5
981 2025-09-08 4720.0
2025-09-08 17:50:30,303 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
979 2025-09-06 4739.5 ... 2025-09-08 17:50:30.295840 2025-09-08 17:50:30.296231
980 2025-09-07 4739.5 ... 2025-09-08 17:50:30.295840 2025-09-08 17:50:30.296231
981 2025-09-08 4720.0 ... 2025-09-08 17:50:30.295840 2025-09-08 17:50:30.296231
[3 rows x 5 columns]
2025-09-08 17:50:30,322 - 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-08 17:50:30,994 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3856 2025-09-04 15058.33
3857 2025-09-05 15325.00
3858 2025-09-06 15325.00
3859 2025-09-07 15325.00
3860 2025-09-08 15416.67
2025-09-08 17:50:31,069 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3858 2025-09-06 ... 2025-09-08 17:50:31.063399
3859 2025-09-07 ... 2025-09-08 17:50:31.063399
3860 2025-09-08 ... 2025-09-08 17:50:31.063399
[3 rows x 5 columns]
2025-09-08 17:50:31,088 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-09-08 17:50:31,093 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3856 2025-09-04 15058.33
3857 2025-09-05 15325.00
3858 2025-09-06 15325.00
3859 2025-09-07 15325.00
3860 2025-09-08 15416.67
2025-09-08 17:50:31,167 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3861 2025-09-06 ... 2025-09-08 17:50:31.161214
3862 2025-09-07 ... 2025-09-08 17:50:31.161214
3863 2025-09-08 ... 2025-09-08 17:50:31.161214
[3 rows x 5 columns]
2025-09-08 17:50:31,186 - 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-08 17:50:31,757 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3188 2025-09-04 788.89
3189 2025-09-05 797.78
3190 2025-09-06 797.44
3191 2025-09-07 797.44
3192 2025-09-08 795.44
2025-09-08 17:50:31,825 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3190 2025-09-06 797.44 ... 2025-09-08 17:50:31.817494 2025-09-08 17:50:31.817913
3191 2025-09-07 797.44 ... 2025-09-08 17:50:31.817494 2025-09-08 17:50:31.817913
3192 2025-09-08 795.44 ... 2025-09-08 17:50:31.817494 2025-09-08 17:50:31.817913
[3 rows x 5 columns]
2025-09-08 17:50:31,844 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-09-08 17:50:31,849 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3188 2025-09-04 788.89
3189 2025-09-05 797.78
3190 2025-09-06 797.44
3191 2025-09-07 797.44
3192 2025-09-08 795.44
2025-09-08 17:50:31,918 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3193 2025-09-06 797.44 ... 2025-09-08 17:50:31.911223 2025-09-08 17:50:31.911617
3194 2025-09-07 797.44 ... 2025-09-08 17:50:31.911223 2025-09-08 17:50:31.911617
3195 2025-09-08 795.44 ... 2025-09-08 17:50:31.911223 2025-09-08 17:50:31.911617
[3 rows x 5 columns]
2025-09-08 17:50:31,937 - 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-08 17:50:32,467 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3391 2025-09-04 1110.4
3392 2025-09-05 1110.4
3393 2025-09-06 1110.4
3394 2025-09-07 1110.4
3395 2025-09-08 1120.0
2025-09-08 17:50:32,536 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3393 2025-09-06 1110.4 ... 2025-09-08 17:50:32.529220 2025-09-08 17:50:32.529636
3394 2025-09-07 1110.4 ... 2025-09-08 17:50:32.529220 2025-09-08 17:50:32.529636
3395 2025-09-08 1120.0 ... 2025-09-08 17:50:32.529220 2025-09-08 17:50:32.529636
[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-08 17:50:34,585 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-09-08 17:50:34.577532
21 2013-01-04 ... 2025-09-08 17:50:34.577532
54 2013-02-27 ... 2025-09-08 17:50:34.577532
60 2013-03-07 ... 2025-09-08 17:50:34.577532
61 2013-03-08 ... 2025-09-08 17:50:34.577532
[5 rows x 6 columns]
2025-09-08 17:50:34,751 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3391 2025-09-04 1110.4
3392 2025-09-05 1110.4
3393 2025-09-06 1110.4
3394 2025-09-07 1110.4
3395 2025-09-08 1120.0
2025-09-08 17:50:34,822 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3397 2025-09-06 1110.4 ... 2025-09-08 17:50:34.814969 2025-09-08 17:50:34.815355
3398 2025-09-07 1110.4 ... 2025-09-08 17:50:34.814969 2025-09-08 17:50:34.815355
3399 2025-09-08 1120.0 ... 2025-09-08 17:50:34.814969 2025-09-08 17:50:34.815355
[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-08 17:50:36,783 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-09-08 17:50:36.775954
21 2013-01-04 ... 2025-09-08 17:50:36.775954
54 2013-02-27 ... 2025-09-08 17:50:36.775954
60 2013-03-07 ... 2025-09-08 17:50:36.775954
61 2013-03-08 ... 2025-09-08 17:50:36.775954
[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-08 17:50:37,654 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1736 2025-09-04 7500.0
1737 2025-09-05 7486.0
1738 2025-09-06 7486.0
1739 2025-09-07 7486.0
1740 2025-09-08 7400.0
2025-09-08 17:50:37,707 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1738 2025-09-06 7486.0 ... 2025-09-08 17:50:37.699374 2025-09-08 17:50:37.699854
1739 2025-09-07 7486.0 ... 2025-09-08 17:50:37.699374 2025-09-08 17:50:37.699854
1740 2025-09-08 7400.0 ... 2025-09-08 17:50:37.699374 2025-09-08 17:50:37.699854
[3 rows x 5 columns]
2025-09-08 17:50:37,728 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-09-08 17:50:37,734 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1736 2025-09-04 7500.0
1737 2025-09-05 7486.0
1738 2025-09-06 7486.0
1739 2025-09-07 7486.0
1740 2025-09-08 7400.0
2025-09-08 17:50:37,783 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1741 2025-09-06 7486.0 ... 2025-09-08 17:50:37.775957 2025-09-08 17:50:37.776332
1742 2025-09-07 7486.0 ... 2025-09-08 17:50:37.775957 2025-09-08 17:50:37.776332
1743 2025-09-08 7400.0 ... 2025-09-08 17:50:37.775957 2025-09-08 17:50:37.776332
[3 rows x 5 columns]
2025-09-08 17:50:37,803 - 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-08 17:50:38,388 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3847 2025-09-04 5913.33
3848 2025-09-05 5921.67
3849 2025-09-06 5921.67
3850 2025-09-07 5921.67
3851 2025-09-08 5905.00
2025-09-08 17:50:38,463 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3849 2025-09-06 5921.67 ... 2025-09-08 17:50:38.456157 2025-09-08 17:50:38.456597
3850 2025-09-07 5921.67 ... 2025-09-08 17:50:38.456157 2025-09-08 17:50:38.456597
3851 2025-09-08 5905.00 ... 2025-09-08 17:50:38.456157 2025-09-08 17:50:38.456597
[3 rows x 5 columns]
2025-09-08 17:50:38,482 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-09-08 17:50:38,488 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3847 2025-09-04 5913.33
3848 2025-09-05 5921.67
3849 2025-09-06 5921.67
3850 2025-09-07 5921.67
3851 2025-09-08 5905.00
2025-09-08 17:50:38,563 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3853 2025-09-06 5921.67 ... 2025-09-08 17:50:38.555313 2025-09-08 17:50:38.555740
3854 2025-09-07 5921.67 ... 2025-09-08 17:50:38.555313 2025-09-08 17:50:38.555740
3855 2025-09-08 5905.00 ... 2025-09-08 17:50:38.555313 2025-09-08 17:50:38.555740
[3 rows x 5 columns]
2025-09-08 17:50:38,582 - 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-08 17:50:39,296 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1737 2025-09-04 13130.0
1738 2025-09-05 13080.0
1739 2025-09-06 13080.0
1740 2025-09-07 13080.0
1741 2025-09-08 13080.0
2025-09-08 17:50:39,346 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1739 2025-09-06 13080.0 ... 2025-09-08 17:50:39.338710 2025-09-08 17:50:39.339115
1740 2025-09-07 13080.0 ... 2025-09-08 17:50:39.338710 2025-09-08 17:50:39.339115
1741 2025-09-08 13080.0 ... 2025-09-08 17:50:39.338710 2025-09-08 17:50:39.339115
[3 rows x 5 columns]
2025-09-08 17:50:39,365 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-09-08 17:50:39,371 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1737 2025-09-04 13130.0
1738 2025-09-05 13080.0
1739 2025-09-06 13080.0
1740 2025-09-07 13080.0
1741 2025-09-08 13080.0
2025-09-08 17:50:39,417 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1742 2025-09-06 13080.0 ... 2025-09-08 17:50:39.410175 2025-09-08 17:50:39.410556
1743 2025-09-07 13080.0 ... 2025-09-08 17:50:39.410175 2025-09-08 17:50:39.410556
1744 2025-09-08 13080.0 ... 2025-09-08 17:50:39.410175 2025-09-08 17:50:39.410556
[3 rows x 5 columns]
2025-09-08 17:50:39,436 - 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-08 17:50:40,090 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3247 2025-09-04 9858.33
3248 2025-09-05 9921.67
3249 2025-09-06 9921.67
3250 2025-09-07 9921.67
3251 2025-09-08 9941.67
2025-09-08 17:50:40,157 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date value ... created_at updated_at
3249 2025-09-06 9921.67 ... 2025-09-08 17:50:40.150316 2025-09-08 17:50:40.150730
3250 2025-09-07 9921.67 ... 2025-09-08 17:50:40.150316 2025-09-08 17:50:40.150730
3251 2025-09-08 9941.67 ... 2025-09-08 17:50:40.150316 2025-09-08 17:50:40.150730
[3 rows x 5 columns]
2025-09-08 17:50:40,176 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-09-08 17:50:40,182 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3247 2025-09-04 9858.33
3248 2025-09-05 9921.67
3249 2025-09-06 9921.67
3250 2025-09-07 9921.67
3251 2025-09-08 9941.67
2025-09-08 17:50:40,248 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date value ... created_at updated_at
3253 2025-09-06 9921.67 ... 2025-09-08 17:50:40.240337 2025-09-08 17:50:40.240746
3254 2025-09-07 9921.67 ... 2025-09-08 17:50:40.240337 2025-09-08 17:50:40.240746
3255 2025-09-08 9941.67 ... 2025-09-08 17:50:40.240337 2025-09-08 17:50:40.240746
[3 rows x 5 columns]
2025-09-08 17:50:40,266 - 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-08 17:50:40,864 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3370 2025-09-04 2631.67
3371 2025-09-05 2638.33
3372 2025-09-06 2638.33
3373 2025-09-07 2638.33
3374 2025-09-08 2650.00
2025-09-08 17:50:40,932 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3372 2025-09-06 2638.33 ... 2025-09-08 17:50:40.925043 2025-09-08 17:50:40.925426
3373 2025-09-07 2638.33 ... 2025-09-08 17:50:40.925043 2025-09-08 17:50:40.925426
3374 2025-09-08 2650.00 ... 2025-09-08 17:50:40.925043 2025-09-08 17:50:40.925426
[3 rows x 5 columns]
2025-09-08 17:50:40,951 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-09-08 17:50:40,956 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3370 2025-09-04 2631.67
3371 2025-09-05 2638.33
3372 2025-09-06 2638.33
3373 2025-09-07 2638.33
3374 2025-09-08 2650.00
2025-09-08 17:50:41,022 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3376 2025-09-06 2638.33 ... 2025-09-08 17:50:41.014868 2025-09-08 17:50:41.015244
3377 2025-09-07 2638.33 ... 2025-09-08 17:50:41.014868 2025-09-08 17:50:41.015244
3378 2025-09-08 2650.00 ... 2025-09-08 17:50:41.014868 2025-09-08 17:50:41.015244
[3 rows x 5 columns]
2025-09-08 17:50:41,041 - 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-08 17:50:41,781 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1574 2025-09-04 1262.5
1575 2025-09-05 1262.5
1576 2025-09-06 1262.5
1577 2025-09-07 1262.5
1578 2025-09-08 1262.5
2025-09-08 17:50:41,826 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1576 2025-09-06 1262.5 ... 2025-09-08 17:50:41.818928 2025-09-08 17:50:41.819303
1577 2025-09-07 1262.5 ... 2025-09-08 17:50:41.818928 2025-09-08 17:50:41.819303
1578 2025-09-08 1262.5 ... 2025-09-08 17:50:41.818928 2025-09-08 17:50:41.819303
[3 rows x 5 columns]
2025-09-08 17:50:41,845 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-09-08 17:50:41,850 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1574 2025-09-04 1262.5
1575 2025-09-05 1262.5
1576 2025-09-06 1262.5
1577 2025-09-07 1262.5
1578 2025-09-08 1262.5
2025-09-08 17:50:41,893 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1580 2025-09-06 1262.5 ... 2025-09-08 17:50:41.886320 2025-09-08 17:50:41.886699
1581 2025-09-07 1262.5 ... 2025-09-08 17:50:41.886320 2025-09-08 17:50:41.886699
1582 2025-09-08 1262.5 ... 2025-09-08 17:50:41.886320 2025-09-08 17:50:41.886699
[3 rows x 5 columns]
2025-09-08 17:50:41,911 - 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-08 17:50:42,527 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1487 2025-09-04 6487.08
1488 2025-09-05 6445.00
1489 2025-09-06 6445.00
1490 2025-09-07 6445.00
1491 2025-09-08 6448.33
2025-09-08 17:50:42,571 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1489 2025-09-06 6445.00 ... 2025-09-08 17:50:42.563761 2025-09-08 17:50:42.564147
1490 2025-09-07 6445.00 ... 2025-09-08 17:50:42.563761 2025-09-08 17:50:42.564147
1491 2025-09-08 6448.33 ... 2025-09-08 17:50:42.563761 2025-09-08 17:50:42.564147
[3 rows x 5 columns]
2025-09-08 17:50:42,590 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-09-08 17:50:42,595 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1487 2025-09-04 6487.08
1488 2025-09-05 6445.00
1489 2025-09-06 6445.00
1490 2025-09-07 6445.00
1491 2025-09-08 6448.33
2025-09-08 17:50:42,640 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1493 2025-09-06 6445.00 ... 2025-09-08 17:50:42.632380 2025-09-08 17:50:42.632832
1494 2025-09-07 6445.00 ... 2025-09-08 17:50:42.632380 2025-09-08 17:50:42.632832
1495 2025-09-08 6448.33 ... 2025-09-08 17:50:42.632380 2025-09-08 17:50:42.632832
[3 rows x 5 columns]
2025-09-08 17:50:42,659 - 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-08 17:50:43,317 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3860 2025-09-04 3084.0
3861 2025-09-05 3084.0
3862 2025-09-06 3084.0
3863 2025-09-07 3084.0
3864 2025-09-08 3084.0
2025-09-08 17:50:43,392 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3862 2025-09-06 3084.0 ... 2025-09-08 17:50:43.384886 2025-09-08 17:50:43.385271
3863 2025-09-07 3084.0 ... 2025-09-08 17:50:43.384886 2025-09-08 17:50:43.385271
3864 2025-09-08 3084.0 ... 2025-09-08 17:50:43.384886 2025-09-08 17:50:43.385271
[3 rows x 5 columns]
2025-09-08 17:50:43,411 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-09-08 17:50:43,417 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3860 2025-09-04 3084.0
3861 2025-09-05 3084.0
3862 2025-09-06 3084.0
3863 2025-09-07 3084.0
3864 2025-09-08 3084.0
2025-09-08 17:50:43,492 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3865 2025-09-06 3084.0 ... 2025-09-08 17:50:43.484998 2025-09-08 17:50:43.485375
3866 2025-09-07 3084.0 ... 2025-09-08 17:50:43.484998 2025-09-08 17:50:43.485375
3867 2025-09-08 3084.0 ... 2025-09-08 17:50:43.484998 2025-09-08 17:50:43.485375
[3 rows x 5 columns]
2025-09-08 17:50:43,510 - 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-08 17:50:44,138 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3630 2025-09-04 8428.0
3631 2025-09-05 8528.0
3632 2025-09-06 8528.0
3633 2025-09-07 8528.0
3634 2025-09-08 8488.0
2025-09-08 17:50:44,211 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3632 2025-09-06 8528.0 ... 2025-09-08 17:50:44.204018 2025-09-08 17:50:44.204397
3633 2025-09-07 8528.0 ... 2025-09-08 17:50:44.204018 2025-09-08 17:50:44.204397
3634 2025-09-08 8488.0 ... 2025-09-08 17:50:44.204018 2025-09-08 17:50:44.204397
[3 rows x 5 columns]
2025-09-08 17:50:44,230 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-09-08 17:50:44,236 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3630 2025-09-04 8428.0
3631 2025-09-05 8528.0
3632 2025-09-06 8528.0
3633 2025-09-07 8528.0
3634 2025-09-08 8488.0
2025-09-08 17:50:44,307 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3635 2025-09-06 8528.0 ... 2025-09-08 17:50:44.300511 2025-09-08 17:50:44.300920
3636 2025-09-07 8528.0 ... 2025-09-08 17:50:44.300511 2025-09-08 17:50:44.300920
3637 2025-09-08 8488.0 ... 2025-09-08 17:50:44.300511 2025-09-08 17:50:44.300920
[3 rows x 5 columns]
2025-09-08 17:50:44,326 - 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-08 17:50:44,921 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3596 2025-09-04 4305.0
3597 2025-09-05 4305.0
3598 2025-09-06 4305.0
3599 2025-09-07 4305.0
3600 2025-09-08 4305.0
2025-09-08 17:50:44,992 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3598 2025-09-06 4305.0 ... 2025-09-08 17:50:44.984904 2025-09-08 17:50:44.985283
3599 2025-09-07 4305.0 ... 2025-09-08 17:50:44.984904 2025-09-08 17:50:44.985283
3600 2025-09-08 4305.0 ... 2025-09-08 17:50:44.984904 2025-09-08 17:50:44.985283
[3 rows x 5 columns]
2025-09-08 17:50:45,010 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-09-08 17:50:45,016 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3596 2025-09-04 4305.0
3597 2025-09-05 4305.0
3598 2025-09-06 4305.0
3599 2025-09-07 4305.0
3600 2025-09-08 4305.0
2025-09-08 17:50:45,084 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3601 2025-09-06 4305.0 ... 2025-09-08 17:50:45.077005 2025-09-08 17:50:45.077384
3602 2025-09-07 4305.0 ... 2025-09-08 17:50:45.077005 2025-09-08 17:50:45.077384
3603 2025-09-08 4305.0 ... 2025-09-08 17:50:45.077005 2025-09-08 17:50:45.077384
[3 rows x 5 columns]
2025-09-08 17:50:45,103 - 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-08 17:50:45,763 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2973 2025-09-04 5207.14
2974 2025-09-05 5214.29
2975 2025-09-06 5214.29
2976 2025-09-07 5214.29
2977 2025-09-08 5214.29
2025-09-08 17:50:45,824 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2975 2025-09-06 5214.29 ... 2025-09-08 17:50:45.816904 2025-09-08 17:50:45.817293
2976 2025-09-07 5214.29 ... 2025-09-08 17:50:45.816904 2025-09-08 17:50:45.817293
2977 2025-09-08 5214.29 ... 2025-09-08 17:50:45.816904 2025-09-08 17:50:45.817293
[3 rows x 5 columns]
2025-09-08 17:50:45,844 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-09-08 17:50:45,849 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2973 2025-09-04 5207.14
2974 2025-09-05 5214.29
2975 2025-09-06 5214.29
2976 2025-09-07 5214.29
2977 2025-09-08 5214.29
2025-09-08 17:50:45,910 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2979 2025-09-06 5214.29 ... 2025-09-08 17:50:45.903196 2025-09-08 17:50:45.903590
2980 2025-09-07 5214.29 ... 2025-09-08 17:50:45.903196 2025-09-08 17:50:45.903590
2981 2025-09-08 5214.29 ... 2025-09-08 17:50:45.903196 2025-09-08 17:50:45.903590
[3 rows x 5 columns]
2025-09-08 17:50:45,930 - 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-08 17:50:46,515 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3173 2025-09-04 3290.0
3174 2025-09-05 3340.0
3175 2025-09-06 3340.0
3176 2025-09-07 3340.0
3177 2025-09-08 3450.0
2025-09-08 17:50:46,581 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3175 2025-09-06 3340.0 ... 2025-09-08 17:50:46.573214 2025-09-08 17:50:46.573646
3176 2025-09-07 3340.0 ... 2025-09-08 17:50:46.573214 2025-09-08 17:50:46.573646
3177 2025-09-08 3450.0 ... 2025-09-08 17:50:46.573214 2025-09-08 17:50:46.573646
[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-08 17:50:46,732 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-09-08 17:50:46.724834
458 2015-09-21 ... 2025-09-08 17:50:46.724834
549 2016-02-03 ... 2025-09-08 17:50:46.724834
693 2016-09-05 ... 2025-09-08 17:50:46.724834
696 2016-09-08 ... 2025-09-08 17:50:46.724834
[5 rows x 6 columns]
2025-09-08 17:50:46,763 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3173 2025-09-04 3290.0
3174 2025-09-05 3340.0
3175 2025-09-06 3340.0
3176 2025-09-07 3340.0
3177 2025-09-08 3450.0
2025-09-08 17:50:46,827 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3178 2025-09-06 3340.0 ... 2025-09-08 17:50:46.819950 2025-09-08 17:50:46.820326
3179 2025-09-07 3340.0 ... 2025-09-08 17:50:46.819950 2025-09-08 17:50:46.820326
3180 2025-09-08 3450.0 ... 2025-09-08 17:50:46.819950 2025-09-08 17:50:46.820326
[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-08 17:50:46,975 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-09-08 17:50:46.967847
458 2015-09-21 ... 2025-09-08 17:50:46.967847
549 2016-02-03 ... 2025-09-08 17:50:46.967847
693 2016-09-05 ... 2025-09-08 17:50:46.967847
696 2016-09-08 ... 2025-09-08 17:50:46.967847
[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-08 17:50:47,682 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
977 2025-09-04 9390.0
978 2025-09-05 9390.0
979 2025-09-06 9390.0
980 2025-09-07 9390.0
981 2025-09-08 9390.0
2025-09-08 17:50:47,721 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
979 2025-09-06 9390.0 ... 2025-09-08 17:50:47.713414 2025-09-08 17:50:47.713839
980 2025-09-07 9390.0 ... 2025-09-08 17:50:47.713414 2025-09-08 17:50:47.713839
981 2025-09-08 9390.0 ... 2025-09-08 17:50:47.713414 2025-09-08 17:50:47.713839
[3 rows x 5 columns]
2025-09-08 17:50:47,741 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-09-08 17:50:47,746 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
977 2025-09-04 9390.0
978 2025-09-05 9390.0
979 2025-09-06 9390.0
980 2025-09-07 9390.0
981 2025-09-08 9390.0
2025-09-08 17:50:47,783 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
979 2025-09-06 9390.0 ... 2025-09-08 17:50:47.775824 2025-09-08 17:50:47.776287
980 2025-09-07 9390.0 ... 2025-09-08 17:50:47.775824 2025-09-08 17:50:47.776287
981 2025-09-08 9390.0 ... 2025-09-08 17:50:47.775824 2025-09-08 17:50:47.776287
[3 rows x 5 columns]
2025-09-08 17:50:47,802 - 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-08 17:50:48,417 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3856 2025-09-04 7391.67
3857 2025-09-05 7383.33
3858 2025-09-06 7383.33
3859 2025-09-07 7383.33
3860 2025-09-08 7385.00
2025-09-08 17:50:48,490 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3858 2025-09-06 7383.33 ... 2025-09-08 17:50:48.482453 2025-09-08 17:50:48.482894
3859 2025-09-07 7383.33 ... 2025-09-08 17:50:48.482453 2025-09-08 17:50:48.482894
3860 2025-09-08 7385.00 ... 2025-09-08 17:50:48.482453 2025-09-08 17:50:48.482894
[3 rows x 5 columns]
2025-09-08 17:50:48,509 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-09-08 17:50:48,515 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3856 2025-09-04 7391.67
3857 2025-09-05 7383.33
3858 2025-09-06 7383.33
3859 2025-09-07 7383.33
3860 2025-09-08 7385.00
2025-09-08 17:50:48,588 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3861 2025-09-06 7383.33 ... 2025-09-08 17:50:48.580863 2025-09-08 17:50:48.581250
3862 2025-09-07 7383.33 ... 2025-09-08 17:50:48.580863 2025-09-08 17:50:48.581250
3863 2025-09-08 7385.00 ... 2025-09-08 17:50:48.580863 2025-09-08 17:50:48.581250
[3 rows x 5 columns]
2025-09-08 17:50:48,607 - 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-08 17:50:49,229 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3194 2025-09-04 3666.67
3195 2025-09-05 3670.00
3196 2025-09-06 3670.00
3197 2025-09-07 3670.00
3198 2025-09-08 3656.67
2025-09-08 17:50:49,293 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3197 2025-09-06 3670.00 ... 2025-09-08 17:50:49.286548 2025-09-08 17:50:49.286966
3198 2025-09-07 3670.00 ... 2025-09-08 17:50:49.286548 2025-09-08 17:50:49.286966
3199 2025-09-08 3656.67 ... 2025-09-08 17:50:49.286548 2025-09-08 17:50:49.286966
[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-08 17:50:49,331 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-09-08 17:50:49.323161
[1 rows x 6 columns]
2025-09-08 17:50:49,356 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3194 2025-09-04 3666.67
3195 2025-09-05 3670.00
3196 2025-09-06 3670.00
3197 2025-09-07 3670.00
3198 2025-09-08 3656.67
2025-09-08 17:50:49,421 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3199 2025-09-06 3670.00 ... 2025-09-08 17:50:49.414229 2025-09-08 17:50:49.414633
3200 2025-09-07 3670.00 ... 2025-09-08 17:50:49.414229 2025-09-08 17:50:49.414633
3201 2025-09-08 3656.67 ... 2025-09-08 17:50:49.414229 2025-09-08 17:50:49.414633
[3 rows x 5 columns]
2025-09-08 17:50:49,440 - 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-08 17:50:50,061 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3859 2025-09-04 20743.33
3860 2025-09-05 20676.67
3861 2025-09-06 20676.67
3862 2025-09-07 20676.67
3863 2025-09-08 20676.67
2025-09-08 17:50:50,132 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date ... updated_at
3861 2025-09-06 ... 2025-09-08 17:50:50.125489
3862 2025-09-07 ... 2025-09-08 17:50:50.125489
3863 2025-09-08 ... 2025-09-08 17:50:50.125489
[3 rows x 5 columns]
2025-09-08 17:50:50,151 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-09-08 17:50:50,157 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3859 2025-09-04 20743.33
3860 2025-09-05 20676.67
3861 2025-09-06 20676.67
3862 2025-09-07 20676.67
3863 2025-09-08 20676.67
2025-09-08 17:50:50,229 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date ... updated_at
3864 2025-09-06 ... 2025-09-08 17:50:50.223163
3865 2025-09-07 ... 2025-09-08 17:50:50.223163
3866 2025-09-08 ... 2025-09-08 17:50:50.223163
[3 rows x 5 columns]
2025-09-08 17:50:50,248 - 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-08 17:50:50,892 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2973 2025-09-04 5636.0
2974 2025-09-05 5676.0
2975 2025-09-06 5676.0
2976 2025-09-07 5676.0
2977 2025-09-08 5688.0
2025-09-08 17:50:50,954 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2975 2025-09-06 5676.0 ... 2025-09-08 17:50:50.946895 2025-09-08 17:50:50.947282
2976 2025-09-07 5676.0 ... 2025-09-08 17:50:50.946895 2025-09-08 17:50:50.947282
2977 2025-09-08 5688.0 ... 2025-09-08 17:50:50.946895 2025-09-08 17:50:50.947282
[3 rows x 5 columns]
2025-09-08 17:50:50,973 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-09-08 17:50:50,979 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2973 2025-09-04 5636.0
2974 2025-09-05 5676.0
2975 2025-09-06 5676.0
2976 2025-09-07 5676.0
2977 2025-09-08 5688.0
2025-09-08 17:50:51,115 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2979 2025-09-06 5676.0 ... 2025-09-08 17:50:51.107074 2025-09-08 17:50:51.107478
2980 2025-09-07 5676.0 ... 2025-09-08 17:50:51.107074 2025-09-08 17:50:51.107478
2981 2025-09-08 5688.0 ... 2025-09-08 17:50:51.107074 2025-09-08 17:50:51.107478
[3 rows x 5 columns]
2025-09-08 17:50:51,134 - 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-08 17:50:51,742 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2248 2025-09-04 23550.0
2249 2025-09-05 23550.0
2250 2025-09-06 23550.0
2251 2025-09-07 23550.0
2252 2025-09-08 23550.0
2025-09-08 17:50:51,796 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2250 2025-09-06 23550.0 ... 2025-09-08 17:50:51.789474 2025-09-08 17:50:51.789888
2251 2025-09-07 23550.0 ... 2025-09-08 17:50:51.789474 2025-09-08 17:50:51.789888
2252 2025-09-08 23550.0 ... 2025-09-08 17:50:51.789474 2025-09-08 17:50:51.789888
[3 rows x 5 columns]
2025-09-08 17:50:51,816 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-09-08 17:50:51,821 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2248 2025-09-04 23550.0
2249 2025-09-05 23550.0
2250 2025-09-06 23550.0
2251 2025-09-07 23550.0
2252 2025-09-08 23550.0
2025-09-08 17:50:51,874 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2254 2025-09-06 23550.0 ... 2025-09-08 17:50:51.867106 2025-09-08 17:50:51.867480
2255 2025-09-07 23550.0 ... 2025-09-08 17:50:51.867106 2025-09-08 17:50:51.867480
2256 2025-09-08 23550.0 ... 2025-09-08 17:50:51.867106 2025-09-08 17:50:51.867480
[3 rows x 5 columns]
2025-09-08 17:50:51,893 - 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-08 17:50:52,611 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1763 2025-09-04 1712.50
1764 2025-09-05 1703.75
1765 2025-09-06 1703.75
1766 2025-09-07 1703.75
1767 2025-09-08 1703.75
2025-09-08 17:50:52,661 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1765 2025-09-06 1703.75 ... 2025-09-08 17:50:52.653843 2025-09-08 17:50:52.654239
1766 2025-09-07 1703.75 ... 2025-09-08 17:50:52.653843 2025-09-08 17:50:52.654239
1767 2025-09-08 1703.75 ... 2025-09-08 17:50:52.653843 2025-09-08 17:50:52.654239
[3 rows x 5 columns]
2025-09-08 17:50:52,679 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-09-08 17:50:52,685 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1763 2025-09-04 1712.50
1764 2025-09-05 1703.75
1765 2025-09-06 1703.75
1766 2025-09-07 1703.75
1767 2025-09-08 1703.75
2025-09-08 17:50:52,738 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1769 2025-09-06 1703.75 ... 2025-09-08 17:50:52.729403 2025-09-08 17:50:52.729849
1770 2025-09-07 1703.75 ... 2025-09-08 17:50:52.729403 2025-09-08 17:50:52.729849
1771 2025-09-08 1703.75 ... 2025-09-08 17:50:52.729403 2025-09-08 17:50:52.729849
[3 rows x 5 columns]
2025-09-08 17:50:52,756 - 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-08 17:50:53,503 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2835 2025-09-04 122133.33
2836 2025-09-05 121950.00
2837 2025-09-06 121950.00
2838 2025-09-07 121950.00
2839 2025-09-08 121950.00
2025-09-08 17:50:53,562 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2837 2025-09-06 ... 2025-09-08 17:50:53.556126
2838 2025-09-07 ... 2025-09-08 17:50:53.556126
2839 2025-09-08 ... 2025-09-08 17:50:53.556126
[3 rows x 5 columns]
2025-09-08 17:50:53,581 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-09-08 17:50:53,587 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2835 2025-09-04 122133.33
2836 2025-09-05 121950.00
2837 2025-09-06 121950.00
2838 2025-09-07 121950.00
2839 2025-09-08 121950.00
2025-09-08 17:50:53,649 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2840 2025-09-06 ... 2025-09-08 17:50:53.642120
2841 2025-09-07 ... 2025-09-08 17:50:53.642120
2842 2025-09-08 ... 2025-09-08 17:50:53.642120
[3 rows x 5 columns]
2025-09-08 17:50:53,667 - 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-08 17:50:54,361 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3860 2025-09-04 4665.0
3861 2025-09-05 4674.0
3862 2025-09-06 4674.0
3863 2025-09-07 4674.0
3864 2025-09-08 4654.0
2025-09-08 17:50:54,440 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3862 2025-09-06 4674.0 ... 2025-09-08 17:50:54.432166 2025-09-08 17:50:54.432629
3863 2025-09-07 4674.0 ... 2025-09-08 17:50:54.432166 2025-09-08 17:50:54.432629
3864 2025-09-08 4654.0 ... 2025-09-08 17:50:54.432166 2025-09-08 17:50:54.432629
[3 rows x 5 columns]
2025-09-08 17:50:54,459 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-09-08 17:50:54,465 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3860 2025-09-04 4665.0
3861 2025-09-05 4674.0
3862 2025-09-06 4674.0
3863 2025-09-07 4674.0
3864 2025-09-08 4654.0
2025-09-08 17:50:54,541 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3865 2025-09-06 4674.0 ... 2025-09-08 17:50:54.534198 2025-09-08 17:50:54.534603
3866 2025-09-07 4674.0 ... 2025-09-08 17:50:54.534198 2025-09-08 17:50:54.534603
3867 2025-09-08 4654.0 ... 2025-09-08 17:50:54.534198 2025-09-08 17:50:54.534603
[3 rows x 5 columns]
2025-09-08 17:50:54,560 - 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-08 17:50:55,177 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
3099 2025-09-04 7121.67
3100 2025-09-05 7113.33
3101 2025-09-06 7113.33
3102 2025-09-07 7113.33
3103 2025-09-08 7113.33
2025-09-08 17:50:55,240 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
3101 2025-09-06 7113.33 ... 2025-09-08 17:50:55.233082 2025-09-08 17:50:55.233468
3102 2025-09-07 7113.33 ... 2025-09-08 17:50:55.233082 2025-09-08 17:50:55.233468
3103 2025-09-08 7113.33 ... 2025-09-08 17:50:55.233082 2025-09-08 17:50:55.233468
[3 rows x 5 columns]
2025-09-08 17:50:55,259 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-09-08 17:50:55,265 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
3099 2025-09-04 7121.67
3100 2025-09-05 7113.33
3101 2025-09-06 7113.33
3102 2025-09-07 7113.33
3103 2025-09-08 7113.33
2025-09-08 17:50:55,328 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
3104 2025-09-06 7113.33 ... 2025-09-08 17:50:55.321160 2025-09-08 17:50:55.321543
3105 2025-09-07 7113.33 ... 2025-09-08 17:50:55.321160 2025-09-08 17:50:55.321543
3106 2025-09-08 7113.33 ... 2025-09-08 17:50:55.321160 2025-09-08 17:50:55.321543
[3 rows x 5 columns]
2025-09-08 17:50:55,347 - 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-08 17:50:56,000 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3861 2025-09-04 15445.17
3862 2025-09-05 15442.33
3863 2025-09-06 15442.33
3864 2025-09-07 15442.33
3865 2025-09-08 15417.17
2025-09-08 17:50:56,074 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date ... updated_at
3863 2025-09-06 ... 2025-09-08 17:50:56.067690
3864 2025-09-07 ... 2025-09-08 17:50:56.067690
3865 2025-09-08 ... 2025-09-08 17:50:56.067690
[3 rows x 5 columns]
2025-09-08 17:50:56,094 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-09-08 17:50:56,099 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3861 2025-09-04 15445.17
3862 2025-09-05 15442.33
3863 2025-09-06 15442.33
3864 2025-09-07 15442.33
3865 2025-09-08 15417.17
2025-09-08 17:50:56,173 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date ... updated_at
3867 2025-09-06 ... 2025-09-08 17:50:56.167088
3868 2025-09-07 ... 2025-09-08 17:50:56.167088
3869 2025-09-08 ... 2025-09-08 17:50:56.167088
[3 rows x 5 columns]
2025-09-08 17:50:56,193 - 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-08 17:50:56,865 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3806 2025-09-04 16800.00
3807 2025-09-05 16793.75
3808 2025-09-06 16793.75
3809 2025-09-07 16793.75
3810 2025-09-08 16825.00
2025-09-08 17:50:56,935 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date ... updated_at
3808 2025-09-06 ... 2025-09-08 17:50:56.928894
3809 2025-09-07 ... 2025-09-08 17:50:56.928894
3810 2025-09-08 ... 2025-09-08 17:50:56.928894
[3 rows x 5 columns]
2025-09-08 17:50:56,954 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-09-08 17:50:56,960 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3806 2025-09-04 16800.00
3807 2025-09-05 16793.75
3808 2025-09-06 16793.75
3809 2025-09-07 16793.75
3810 2025-09-08 16825.00
2025-09-08 17:50:57,030 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date ... updated_at
3811 2025-09-06 ... 2025-09-08 17:50:57.024387
3812 2025-09-07 ... 2025-09-08 17:50:57.024387
3813 2025-09-08 ... 2025-09-08 17:50:57.024387
[3 rows x 5 columns]
2025-09-08 17:50:57,049 - 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-08 17:50:57,788 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
3081 2025-09-04 3383.33
3082 2025-09-05 3393.33
3083 2025-09-06 3393.33
3084 2025-09-07 3393.33
3085 2025-09-08 3393.33
2025-09-08 17:50:57,857 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
3083 2025-09-06 3393.33 ... 2025-09-08 17:50:57.848707 2025-09-08 17:50:57.849124
3084 2025-09-07 3393.33 ... 2025-09-08 17:50:57.848707 2025-09-08 17:50:57.849124
3085 2025-09-08 3393.33 ... 2025-09-08 17:50:57.848707 2025-09-08 17:50:57.849124
[3 rows x 5 columns]
2025-09-08 17:50:57,876 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-09-08 17:50:57,882 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
3081 2025-09-04 3383.33
3082 2025-09-05 3393.33
3083 2025-09-06 3393.33
3084 2025-09-07 3393.33
3085 2025-09-08 3393.33
2025-09-08 17:50:57,946 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
3086 2025-09-06 3393.33 ... 2025-09-08 17:50:57.938858 2025-09-08 17:50:57.939234
3087 2025-09-07 3393.33 ... 2025-09-08 17:50:57.938858 2025-09-08 17:50:57.939234
3088 2025-09-08 3393.33 ... 2025-09-08 17:50:57.938858 2025-09-08 17:50:57.939234
[3 rows x 5 columns]
2025-09-08 17:50:57,967 - 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-08 17:50:58,567 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3361 2025-09-04 5387.5
3362 2025-09-05 5375.0
3363 2025-09-06 5375.0
3364 2025-09-07 5375.0
3365 2025-09-08 5375.0
2025-09-08 17:50:58,634 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3363 2025-09-06 5375.0 ... 2025-09-08 17:50:58.626534 2025-09-08 17:50:58.626957
3364 2025-09-07 5375.0 ... 2025-09-08 17:50:58.626534 2025-09-08 17:50:58.626957
3365 2025-09-08 5375.0 ... 2025-09-08 17:50:58.626534 2025-09-08 17:50:58.626957
[3 rows x 5 columns]
2025-09-08 17:50:58,653 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-09-08 17:50:58,658 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3361 2025-09-04 5387.5
3362 2025-09-05 5375.0
3363 2025-09-06 5375.0
3364 2025-09-07 5375.0
3365 2025-09-08 5375.0
2025-09-08 17:50:58,731 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3850 2025-09-06 5375.0 ... 2025-09-08 17:50:58.723275 2025-09-08 17:50:58.723699
3851 2025-09-07 5375.0 ... 2025-09-08 17:50:58.723275 2025-09-08 17:50:58.723699
3852 2025-09-08 5375.0 ... 2025-09-08 17:50:58.723275 2025-09-08 17:50:58.723699
[3 rows x 5 columns]
2025-09-08 17:50:58,749 - 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-08 17:50:59,315 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1425 2025-09-04 13820.0
1426 2025-09-05 13820.0
1427 2025-09-06 13820.0
1428 2025-09-07 13820.0
1429 2025-09-08 13730.0
2025-09-08 17:50:59,357 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1427 2025-09-06 13820.0 ... 2025-09-08 17:50:59.350594 2025-09-08 17:50:59.350990
1428 2025-09-07 13820.0 ... 2025-09-08 17:50:59.350594 2025-09-08 17:50:59.350990
1429 2025-09-08 13730.0 ... 2025-09-08 17:50:59.350594 2025-09-08 17:50:59.350990
[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-08 17:50:59,603 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-09-08 17:50:59.596142
117 2021-07-06 ... 2025-09-08 17:50:59.596142
121 2021-07-12 ... 2025-09-08 17:50:59.596142
122 2021-07-13 ... 2025-09-08 17:50:59.596142
194 2021-11-01 ... 2025-09-08 17:50:59.596142
[5 rows x 6 columns]
2025-09-08 17:50:59,644 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1425 2025-09-04 13820.0
1426 2025-09-05 13820.0
1427 2025-09-06 13820.0
1428 2025-09-07 13820.0
1429 2025-09-08 13730.0
2025-09-08 17:50:59,688 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1430 2025-09-06 13820.0 ... 2025-09-08 17:50:59.680729 2025-09-08 17:50:59.681148
1431 2025-09-07 13820.0 ... 2025-09-08 17:50:59.680729 2025-09-08 17:50:59.681148
1432 2025-09-08 13730.0 ... 2025-09-08 17:50:59.680729 2025-09-08 17:50:59.681148
[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-08 17:50:59,928 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-09-08 17:50:59.919824
117 2021-07-06 ... 2025-09-08 17:50:59.919824
121 2021-07-12 ... 2025-09-08 17:50:59.919824
122 2021-07-13 ... 2025-09-08 17:50:59.919824
194 2021-11-01 ... 2025-09-08 17:50:59.919824
[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-08 17:51:00,653 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3857 2025-09-04 80181.67
3858 2025-09-05 80035.00
3859 2025-09-06 80035.00
3860 2025-09-07 80035.00
3861 2025-09-08 79893.33
2025-09-08 17:51:00,727 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date ... updated_at
3859 2025-09-06 ... 2025-09-08 17:51:00.720666
3860 2025-09-07 ... 2025-09-08 17:51:00.720666
3861 2025-09-08 ... 2025-09-08 17:51:00.720666
[3 rows x 5 columns]
2025-09-08 17:51:00,746 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-09-08 17:51:00,752 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3857 2025-09-04 80181.67
3858 2025-09-05 80035.00
3859 2025-09-06 80035.00
3860 2025-09-07 80035.00
3861 2025-09-08 79893.33
2025-09-08 17:51:00,828 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date ... updated_at
3862 2025-09-06 ... 2025-09-08 17:51:00.821301
3863 2025-09-07 ... 2025-09-08 17:51:00.821301
3864 2025-09-08 ... 2025-09-08 17:51:00.821301
[3 rows x 5 columns]
2025-09-08 17:51:00,847 - 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-08 17:51:01,412 - 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-08 17:51:01,465 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-09-08 17:51:01,465 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-09-08 17:51:01,471 - 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-08 17:51:01,530 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-09-08 17:51:01,530 - 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-08 17:51:02,265 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2835 2025-09-04 272237.5
2836 2025-09-05 271737.5
2837 2025-09-06 271737.5
2838 2025-09-07 271737.5
2839 2025-09-08 269575.0
2025-09-08 17:51:02,325 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2837 2025-09-06 ... 2025-09-08 17:51:02.319085
2838 2025-09-07 ... 2025-09-08 17:51:02.319085
2839 2025-09-08 ... 2025-09-08 17:51:02.319085
[3 rows x 5 columns]
2025-09-08 17:51:02,345 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-09-08 17:51:02,350 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2835 2025-09-04 272237.5
2836 2025-09-05 271737.5
2837 2025-09-06 271737.5
2838 2025-09-07 271737.5
2839 2025-09-08 269575.0
2025-09-08 17:51:02,411 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2840 2025-09-06 ... 2025-09-08 17:51:02.404547
2841 2025-09-07 ... 2025-09-08 17:51:02.404547
2842 2025-09-08 ... 2025-09-08 17:51:02.404547
[3 rows x 5 columns]
2025-09-08 17:51:02,430 - 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-08 17:51:03,144 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3856 2025-09-04 21968.0
3857 2025-09-05 22008.0
3858 2025-09-06 22008.0
3859 2025-09-07 22008.0
3860 2025-09-08 22128.0
2025-09-08 17:51:03,214 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3858 2025-09-06 22008.0 ... 2025-09-08 17:51:03.207291 2025-09-08 17:51:03.207750
3859 2025-09-07 22008.0 ... 2025-09-08 17:51:03.207291 2025-09-08 17:51:03.207750
3860 2025-09-08 22128.0 ... 2025-09-08 17:51:03.207291 2025-09-08 17:51:03.207750
[3 rows x 5 columns]
2025-09-08 17:51:03,234 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-09-08 17:51:03,239 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3856 2025-09-04 21968.0
3857 2025-09-05 22008.0
3858 2025-09-06 22008.0
3859 2025-09-07 22008.0
3860 2025-09-08 22128.0
2025-09-08 17:51:03,311 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3861 2025-09-06 22008.0 ... 2025-09-08 17:51:03.303888 2025-09-08 17:51:03.304268
3862 2025-09-07 22008.0 ... 2025-09-08 17:51:03.303888 2025-09-08 17:51:03.304268
3863 2025-09-08 22128.0 ... 2025-09-08 17:51:03.303888 2025-09-08 17:51:03.304268
[3 rows x 5 columns]
2025-09-08 17:51:03,330 - 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-08 17:51:03,969 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3819 2025-09-04 3315.0
3820 2025-09-05 3315.0
3821 2025-09-06 3310.0
3822 2025-09-07 3310.0
3823 2025-09-08 3312.5
2025-09-08 17:51:04,042 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3821 2025-09-06 3310.0 ... 2025-09-08 17:51:04.034829 2025-09-08 17:51:04.035216
3822 2025-09-07 3310.0 ... 2025-09-08 17:51:04.034829 2025-09-08 17:51:04.035216
3823 2025-09-08 3312.5 ... 2025-09-08 17:51:04.034829 2025-09-08 17:51:04.035216
[3 rows x 5 columns]
2025-09-08 17:51:04,061 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-09-08 17:51:04,067 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3819 2025-09-04 3315.0
3820 2025-09-05 3315.0
3821 2025-09-06 3310.0
3822 2025-09-07 3310.0
3823 2025-09-08 3312.5
2025-09-08 17:51:04,146 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3824 2025-09-06 3310.0 ... 2025-09-08 17:51:04.138296 2025-09-08 17:51:04.138730
3825 2025-09-07 3310.0 ... 2025-09-08 17:51:04.138296 2025-09-08 17:51:04.138730
3826 2025-09-08 3312.5 ... 2025-09-08 17:51:04.138296 2025-09-08 17:51:04.138730
[3 rows x 5 columns]
2025-09-08 17:51:04,164 - 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-08 17:51:04,885 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1616 2025-09-04 4735.0
1617 2025-09-05 4735.0
1618 2025-09-06 4735.0
1619 2025-09-07 4735.0
1620 2025-09-08 4692.5
2025-09-08 17:51:04,929 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1618 2025-09-06 4735.0 ... 2025-09-08 17:51:04.922492 2025-09-08 17:51:04.922905
1619 2025-09-07 4735.0 ... 2025-09-08 17:51:04.922492 2025-09-08 17:51:04.922905
1620 2025-09-08 4692.5 ... 2025-09-08 17:51:04.922492 2025-09-08 17:51:04.922905
[3 rows x 5 columns]
2025-09-08 17:51:04,948 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-09-08 17:51:04,953 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1616 2025-09-04 4735.0
1617 2025-09-05 4735.0
1618 2025-09-06 4735.0
1619 2025-09-07 4735.0
1620 2025-09-08 4692.5
2025-09-08 17:51:04,997 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1621 2025-09-06 4735.0 ... 2025-09-08 17:51:04.990773 2025-09-08 17:51:04.991133
1622 2025-09-07 4735.0 ... 2025-09-08 17:51:04.990773 2025-09-08 17:51:04.991133
1623 2025-09-08 4692.5 ... 2025-09-08 17:51:04.990773 2025-09-08 17:51:04.991133
[3 rows x 5 columns]
2025-09-08 17:51:05,016 - 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-08 17:51:05,630 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2890 2025-09-04 2302.86
2891 2025-09-05 2301.43
2892 2025-09-06 2301.43
2893 2025-09-07 2301.43
2894 2025-09-08 2307.14
2025-09-08 17:51:05,691 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2892 2025-09-06 2301.43 ... 2025-09-08 17:51:05.684185 2025-09-08 17:51:05.684629
2893 2025-09-07 2301.43 ... 2025-09-08 17:51:05.684185 2025-09-08 17:51:05.684629
2894 2025-09-08 2307.14 ... 2025-09-08 17:51:05.684185 2025-09-08 17:51:05.684629
[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-08 17:51:05,733 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2891 2025-09-05 ... 2025-09-08 17:51:05.726049
[1 rows x 6 columns]
2025-09-08 17:51:05,757 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2890 2025-09-04 2302.86
2891 2025-09-05 2301.43
2892 2025-09-06 2301.43
2893 2025-09-07 2301.43
2894 2025-09-08 2307.14
2025-09-08 17:51:05,817 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2895 2025-09-06 2301.43 ... 2025-09-08 17:51:05.810319 2025-09-08 17:51:05.810733
2896 2025-09-07 2301.43 ... 2025-09-08 17:51:05.810319 2025-09-08 17:51:05.810733
2897 2025-09-08 2307.14 ... 2025-09-08 17:51:05.810319 2025-09-08 17:51:05.810733
[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-08 17:51:05,857 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2894 2025-09-05 ... 2025-09-08 17:51:05.850419
[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-08 17:51:06,462 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2890 2025-09-04 2302.86
2891 2025-09-05 2301.43
2892 2025-09-06 2301.43
2893 2025-09-07 2301.43
2894 2025-09-08 2868.00
2025-09-08 17:51:06,517 - 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-08 17:51:06,541 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2894 2025-09-08 ... 2025-09-08 17:51:06.533534
[1 rows x 6 columns]
2025-09-08 17:51:06,566 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2890 2025-09-04 2302.86
2891 2025-09-05 2301.43
2892 2025-09-06 2301.43
2893 2025-09-07 2301.43
2894 2025-09-08 2868.00
2025-09-08 17:51:06,624 - 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-08 17:51:06,647 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2897 2025-09-08 ... 2025-09-08 17:51:06.639440
[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-08 17:51:07,206 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3247 2025-09-04 9858.33
3248 2025-09-05 9921.67
3249 2025-09-06 9921.67
3250 2025-09-07 9921.67
3251 2025-09-08 9941.67
2025-09-08 17:51:07,263 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-09-08 17:51:07,263 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-09-08 17:51:07,268 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3247 2025-09-04 9858.33
3248 2025-09-05 9921.67
3249 2025-09-06 9921.67
3250 2025-09-07 9921.67
3251 2025-09-08 9941.67
2025-09-08 17:51:07,327 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-09-08 17:51:07,327 - 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-08 17:51:07,970 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1931 2025-09-04 4465.00
1932 2025-09-05 4465.00
1933 2025-09-06 4486.67
1934 2025-09-07 4486.67
1935 2025-09-08 4486.67
2025-09-08 17:51:08,019 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1933 2025-09-06 4486.67 ... 2025-09-08 17:51:08.011756 2025-09-08 17:51:08.012144
1934 2025-09-07 4486.67 ... 2025-09-08 17:51:08.011756 2025-09-08 17:51:08.012144
1935 2025-09-08 4486.67 ... 2025-09-08 17:51:08.011756 2025-09-08 17:51:08.012144
[3 rows x 5 columns]
2025-09-08 17:51:08,038 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-09-08 17:51:08,043 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1931 2025-09-04 4465.00
1932 2025-09-05 4465.00
1933 2025-09-06 4486.67
1934 2025-09-07 4486.67
1935 2025-09-08 4486.67
2025-09-08 17:51:08,091 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1936 2025-09-06 4486.67 ... 2025-09-08 17:51:08.084246 2025-09-08 17:51:08.084640
1937 2025-09-07 4486.67 ... 2025-09-08 17:51:08.084246 2025-09-08 17:51:08.084640
1938 2025-09-08 4486.67 ... 2025-09-08 17:51:08.084246 2025-09-08 17:51:08.084640
[3 rows x 5 columns]
2025-09-08 17:51:08,110 - 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-08 17:51:08,817 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1940 2025-09-04 5733.33
1941 2025-09-05 5733.33
1942 2025-09-06 5733.33
1943 2025-09-07 5733.33
1944 2025-09-08 5716.67
2025-09-08 17:51:08,869 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1942 2025-09-06 5733.33 ... 2025-09-08 17:51:08.861459 2025-09-08 17:51:08.861892
1943 2025-09-07 5733.33 ... 2025-09-08 17:51:08.861459 2025-09-08 17:51:08.861892
1944 2025-09-08 5716.67 ... 2025-09-08 17:51:08.861459 2025-09-08 17:51:08.861892
[3 rows x 5 columns]
2025-09-08 17:51:08,888 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-09-08 17:51:08,894 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1940 2025-09-04 5733.33
1941 2025-09-05 5733.33
1942 2025-09-06 5733.33
1943 2025-09-07 5733.33
1944 2025-09-08 5716.67
2025-09-08 17:51:08,943 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1945 2025-09-06 5733.33 ... 2025-09-08 17:51:08.936078 2025-09-08 17:51:08.936460
1946 2025-09-07 5733.33 ... 2025-09-08 17:51:08.936078 2025-09-08 17:51:08.936460
1947 2025-09-08 5716.67 ... 2025-09-08 17:51:08.936078 2025-09-08 17:51:08.936460
[3 rows x 5 columns]
2025-09-08 17:51:08,965 - 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-08 17:51:09,667 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3608 2025-09-04 9400.0
3609 2025-09-05 9550.0
3610 2025-09-06 9550.0
3611 2025-09-07 9550.0
3612 2025-09-08 9454.0
2025-09-08 17:51:09,736 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3610 2025-09-06 9550.0 ... 2025-09-08 17:51:09.728493 2025-09-08 17:51:09.728924
3611 2025-09-07 9550.0 ... 2025-09-08 17:51:09.728493 2025-09-08 17:51:09.728924
3612 2025-09-08 9454.0 ... 2025-09-08 17:51:09.728493 2025-09-08 17:51:09.728924
[3 rows x 5 columns]
2025-09-08 17:51:09,755 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-09-08 17:51:09,762 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3608 2025-09-04 9400.0
3609 2025-09-05 9550.0
3610 2025-09-06 9550.0
3611 2025-09-07 9550.0
3612 2025-09-08 9454.0
2025-09-08 17:51:09,832 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3613 2025-09-06 9550.0 ... 2025-09-08 17:51:09.825074 2025-09-08 17:51:09.825451
3614 2025-09-07 9550.0 ... 2025-09-08 17:51:09.825074 2025-09-08 17:51:09.825451
3615 2025-09-08 9454.0 ... 2025-09-08 17:51:09.825074 2025-09-08 17:51:09.825451
[3 rows x 5 columns]
2025-09-08 17:51:09,851 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data