=========================================================================
2025-07-28 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-07-28 17:50:28,939 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3374 2025-07-24 3349.5
3375 2025-07-25 3369.0
3376 2025-07-26 3369.0
3377 2025-07-27 3369.0
3378 2025-07-28 3352.0
2025-07-28 17:50:29,015 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3376 2025-07-26 3369.0 ... 2025-07-28 17:50:29.007043 2025-07-28 17:50:29.007476
3377 2025-07-27 3369.0 ... 2025-07-28 17:50:29.007043 2025-07-28 17:50:29.007476
3378 2025-07-28 3352.0 ... 2025-07-28 17:50:29.007043 2025-07-28 17:50:29.007476
[3 rows x 5 columns]
2025-07-28 17:50:29,034 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-07-28 17:50:29,041 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3374 2025-07-24 3349.5
3375 2025-07-25 3369.0
3376 2025-07-26 3369.0
3377 2025-07-27 3369.0
3378 2025-07-28 3352.0
2025-07-28 17:50:29,114 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3379 2025-07-26 3369.0 ... 2025-07-28 17:50:29.107308 2025-07-28 17:50:29.107689
3380 2025-07-27 3369.0 ... 2025-07-28 17:50:29.107308 2025-07-28 17:50:29.107689
3381 2025-07-28 3352.0 ... 2025-07-28 17:50:29.107308 2025-07-28 17:50:29.107689
[3 rows x 5 columns]
2025-07-28 17:50:29,132 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-28 17:50:29,780 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3595 2025-07-24 2459.17
3596 2025-07-25 2481.67
3597 2025-07-26 2481.67
3598 2025-07-27 2481.67
3599 2025-07-28 2392.50
2025-07-28 17:50:29,856 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3597 2025-07-26 2481.67 ... 2025-07-28 17:50:29.848824 2025-07-28 17:50:29.849228
3598 2025-07-27 2481.67 ... 2025-07-28 17:50:29.848824 2025-07-28 17:50:29.849228
3599 2025-07-28 2392.50 ... 2025-07-28 17:50:29.848824 2025-07-28 17:50:29.849228
[3 rows x 5 columns]
2025-07-28 17:50:29,876 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-07-28 17:50:29,882 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3595 2025-07-24 2459.17
3596 2025-07-25 2481.67
3597 2025-07-26 2481.67
3598 2025-07-27 2481.67
3599 2025-07-28 2392.50
2025-07-28 17:50:29,954 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3601 2025-07-26 2481.67 ... 2025-07-28 17:50:29.946642 2025-07-28 17:50:29.947069
3602 2025-07-27 2481.67 ... 2025-07-28 17:50:29.946642 2025-07-28 17:50:29.947069
3603 2025-07-28 2392.50 ... 2025-07-28 17:50:29.946642 2025-07-28 17:50:29.947069
[3 rows x 5 columns]
2025-07-28 17:50:29,973 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-28 17:50:30,607 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
935 2025-07-24 4831.34
936 2025-07-25 4874.84
937 2025-07-26 4874.84
938 2025-07-27 4874.84
939 2025-07-28 4862.50
2025-07-28 17:50:30,648 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
937 2025-07-26 4874.84 ... 2025-07-28 17:50:30.641550 2025-07-28 17:50:30.641961
938 2025-07-27 4874.84 ... 2025-07-28 17:50:30.641550 2025-07-28 17:50:30.641961
939 2025-07-28 4862.50 ... 2025-07-28 17:50:30.641550 2025-07-28 17:50:30.641961
[3 rows x 5 columns]
2025-07-28 17:50:30,667 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-07-28 17:50:30,673 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
935 2025-07-24 4831.34
936 2025-07-25 4874.84
937 2025-07-26 4874.84
938 2025-07-27 4874.84
939 2025-07-28 4862.50
2025-07-28 17:50:30,711 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
937 2025-07-26 4874.84 ... 2025-07-28 17:50:30.704057 2025-07-28 17:50:30.704442
938 2025-07-27 4874.84 ... 2025-07-28 17:50:30.704057 2025-07-28 17:50:30.704442
939 2025-07-28 4862.50 ... 2025-07-28 17:50:30.704057 2025-07-28 17:50:30.704442
[3 rows x 5 columns]
2025-07-28 17:50:30,730 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-28 17:50:31,389 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3814 2025-07-24 15291.67
3815 2025-07-25 15633.33
3816 2025-07-26 15633.33
3817 2025-07-27 15633.33
3818 2025-07-28 15125.00
2025-07-28 17:50:31,463 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3816 2025-07-26 ... 2025-07-28 17:50:31.456711
3817 2025-07-27 ... 2025-07-28 17:50:31.456711
3818 2025-07-28 ... 2025-07-28 17:50:31.456711
[3 rows x 5 columns]
2025-07-28 17:50:31,482 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-07-28 17:50:31,488 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3814 2025-07-24 15291.67
3815 2025-07-25 15633.33
3816 2025-07-26 15633.33
3817 2025-07-27 15633.33
3818 2025-07-28 15125.00
2025-07-28 17:50:31,563 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3819 2025-07-26 ... 2025-07-28 17:50:31.556318
3820 2025-07-27 ... 2025-07-28 17:50:31.556318
3821 2025-07-28 ... 2025-07-28 17:50:31.556318
[3 rows x 5 columns]
2025-07-28 17:50:31,582 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-28 17:50:32,220 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3146 2025-07-24 800.44
3147 2025-07-25 800.44
3148 2025-07-26 795.67
3149 2025-07-27 795.67
3150 2025-07-28 789.67
2025-07-28 17:50:32,284 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3148 2025-07-26 795.67 ... 2025-07-28 17:50:32.276698 2025-07-28 17:50:32.277118
3149 2025-07-27 795.67 ... 2025-07-28 17:50:32.276698 2025-07-28 17:50:32.277118
3150 2025-07-28 789.67 ... 2025-07-28 17:50:32.276698 2025-07-28 17:50:32.277118
[3 rows x 5 columns]
2025-07-28 17:50:32,303 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-07-28 17:50:32,310 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3146 2025-07-24 800.44
3147 2025-07-25 800.44
3148 2025-07-26 795.67
3149 2025-07-27 795.67
3150 2025-07-28 789.67
2025-07-28 17:50:32,376 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3151 2025-07-26 795.67 ... 2025-07-28 17:50:32.369090 2025-07-28 17:50:32.369475
3152 2025-07-27 795.67 ... 2025-07-28 17:50:32.369090 2025-07-28 17:50:32.369475
3153 2025-07-28 789.67 ... 2025-07-28 17:50:32.369090 2025-07-28 17:50:32.369475
[3 rows x 5 columns]
2025-07-28 17:50:32,397 - IOOppi_data - INFO : save diff data to db: IOOppi_i_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-28 17:50:32,981 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3349 2025-07-24 1216.0
3350 2025-07-25 1256.0
3351 2025-07-26 1256.0
3352 2025-07-27 1256.0
3353 2025-07-28 1256.0
2025-07-28 17:50:33,050 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3351 2025-07-26 1256.0 ... 2025-07-28 17:50:33.043039 2025-07-28 17:50:33.043569
3352 2025-07-27 1256.0 ... 2025-07-28 17:50:33.043039 2025-07-28 17:50:33.043569
3353 2025-07-28 1256.0 ... 2025-07-28 17:50:33.043039 2025-07-28 17:50:33.043569
[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-07-28 17:50:35,039 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-07-28 17:50:35.032070
21 2013-01-04 ... 2025-07-28 17:50:35.032070
54 2013-02-27 ... 2025-07-28 17:50:35.032070
60 2013-03-07 ... 2025-07-28 17:50:35.032070
61 2013-03-08 ... 2025-07-28 17:50:35.032070
[5 rows x 6 columns]
2025-07-28 17:50:35,206 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3349 2025-07-24 1216.0
3350 2025-07-25 1256.0
3351 2025-07-26 1256.0
3352 2025-07-27 1256.0
3353 2025-07-28 1256.0
2025-07-28 17:50:35,276 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3355 2025-07-26 1256.0 ... 2025-07-28 17:50:35.268592 2025-07-28 17:50:35.269036
3356 2025-07-27 1256.0 ... 2025-07-28 17:50:35.268592 2025-07-28 17:50:35.269036
3357 2025-07-28 1256.0 ... 2025-07-28 17:50:35.268592 2025-07-28 17:50:35.269036
[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-07-28 17:50:37,243 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-07-28 17:50:37.233483
21 2013-01-04 ... 2025-07-28 17:50:37.233483
54 2013-02-27 ... 2025-07-28 17:50:37.233483
60 2013-03-07 ... 2025-07-28 17:50:37.233483
61 2013-03-08 ... 2025-07-28 17:50:37.233483
[5 rows x 6 columns]
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-28 17:50:38,015 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1694 2025-07-24 7744.0
1695 2025-07-25 7736.0
1696 2025-07-26 7736.0
1697 2025-07-27 7736.0
1698 2025-07-28 7720.0
2025-07-28 17:50:38,062 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1696 2025-07-26 7736.0 ... 2025-07-28 17:50:38.054992 2025-07-28 17:50:38.055412
1697 2025-07-27 7736.0 ... 2025-07-28 17:50:38.054992 2025-07-28 17:50:38.055412
1698 2025-07-28 7720.0 ... 2025-07-28 17:50:38.054992 2025-07-28 17:50:38.055412
[3 rows x 5 columns]
2025-07-28 17:50:38,082 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-07-28 17:50:38,089 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1694 2025-07-24 7744.0
1695 2025-07-25 7736.0
1696 2025-07-26 7736.0
1697 2025-07-27 7736.0
1698 2025-07-28 7720.0
2025-07-28 17:50:38,139 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1699 2025-07-26 7736.0 ... 2025-07-28 17:50:38.131709 2025-07-28 17:50:38.132129
1700 2025-07-27 7736.0 ... 2025-07-28 17:50:38.131709 2025-07-28 17:50:38.132129
1701 2025-07-28 7720.0 ... 2025-07-28 17:50:38.131709 2025-07-28 17:50:38.132129
[3 rows x 5 columns]
2025-07-28 17:50:38,157 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-28 17:50:38,826 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3805 2025-07-24 6043.33
3806 2025-07-25 6046.67
3807 2025-07-26 6046.67
3808 2025-07-27 6046.67
3809 2025-07-28 6043.33
2025-07-28 17:50:38,899 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3807 2025-07-26 6046.67 ... 2025-07-28 17:50:38.891454 2025-07-28 17:50:38.891873
3808 2025-07-27 6046.67 ... 2025-07-28 17:50:38.891454 2025-07-28 17:50:38.891873
3809 2025-07-28 6043.33 ... 2025-07-28 17:50:38.891454 2025-07-28 17:50:38.891873
[3 rows x 5 columns]
2025-07-28 17:50:38,919 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-07-28 17:50:38,928 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3805 2025-07-24 6043.33
3806 2025-07-25 6046.67
3807 2025-07-26 6046.67
3808 2025-07-27 6046.67
3809 2025-07-28 6043.33
2025-07-28 17:50:39,018 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3811 2025-07-26 6046.67 ... 2025-07-28 17:50:39.010842 2025-07-28 17:50:39.011242
3812 2025-07-27 6046.67 ... 2025-07-28 17:50:39.010842 2025-07-28 17:50:39.011242
3813 2025-07-28 6043.33 ... 2025-07-28 17:50:39.010842 2025-07-28 17:50:39.011242
[3 rows x 5 columns]
2025-07-28 17:50:39,037 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-28 17:50:39,902 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1695 2025-07-24 13030.0
1696 2025-07-25 13030.0
1697 2025-07-26 13030.0
1698 2025-07-27 13030.0
1699 2025-07-28 13017.5
2025-07-28 17:50:39,957 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1697 2025-07-26 13030.0 ... 2025-07-28 17:50:39.949602 2025-07-28 17:50:39.950042
1698 2025-07-27 13030.0 ... 2025-07-28 17:50:39.949602 2025-07-28 17:50:39.950042
1699 2025-07-28 13017.5 ... 2025-07-28 17:50:39.949602 2025-07-28 17:50:39.950042
[3 rows x 5 columns]
2025-07-28 17:50:39,976 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-07-28 17:50:39,981 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1695 2025-07-24 13030.0
1696 2025-07-25 13030.0
1697 2025-07-26 13030.0
1698 2025-07-27 13030.0
1699 2025-07-28 13017.5
2025-07-28 17:50:40,029 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1700 2025-07-26 13030.0 ... 2025-07-28 17:50:40.021062 2025-07-28 17:50:40.021446
1701 2025-07-27 13030.0 ... 2025-07-28 17:50:40.021062 2025-07-28 17:50:40.021446
1702 2025-07-28 13017.5 ... 2025-07-28 17:50:40.021062 2025-07-28 17:50:40.021446
[3 rows x 5 columns]
2025-07-28 17:50:40,050 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-28 17:50:40,764 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3205 2025-07-24 9590.00
3206 2025-07-25 9590.00
3207 2025-07-26 9561.67
3208 2025-07-27 9561.67
3209 2025-07-28 9521.67
2025-07-28 17:50:40,833 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date value ... created_at updated_at
3207 2025-07-26 9561.67 ... 2025-07-28 17:50:40.825574 2025-07-28 17:50:40.826013
3208 2025-07-27 9561.67 ... 2025-07-28 17:50:40.825574 2025-07-28 17:50:40.826013
3209 2025-07-28 9521.67 ... 2025-07-28 17:50:40.825574 2025-07-28 17:50:40.826013
[3 rows x 5 columns]
2025-07-28 17:50:40,852 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-07-28 17:50:40,858 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3205 2025-07-24 9590.00
3206 2025-07-25 9590.00
3207 2025-07-26 9561.67
3208 2025-07-27 9561.67
3209 2025-07-28 9521.67
2025-07-28 17:50:40,924 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date value ... created_at updated_at
3211 2025-07-26 9561.67 ... 2025-07-28 17:50:40.917276 2025-07-28 17:50:40.917656
3212 2025-07-27 9561.67 ... 2025-07-28 17:50:40.917276 2025-07-28 17:50:40.917656
3213 2025-07-28 9521.67 ... 2025-07-28 17:50:40.917276 2025-07-28 17:50:40.917656
[3 rows x 5 columns]
2025-07-28 17:50:40,942 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-28 17:50:41,527 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3328 2025-07-24 2630.00
3329 2025-07-25 2630.00
3330 2025-07-26 2630.00
3331 2025-07-27 2630.00
3332 2025-07-28 2621.67
2025-07-28 17:50:41,596 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3330 2025-07-26 2630.00 ... 2025-07-28 17:50:41.588618 2025-07-28 17:50:41.589041
3331 2025-07-27 2630.00 ... 2025-07-28 17:50:41.588618 2025-07-28 17:50:41.589041
3332 2025-07-28 2621.67 ... 2025-07-28 17:50:41.588618 2025-07-28 17:50:41.589041
[3 rows x 5 columns]
2025-07-28 17:50:41,617 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-07-28 17:50:41,623 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3328 2025-07-24 2630.00
3329 2025-07-25 2630.00
3330 2025-07-26 2630.00
3331 2025-07-27 2630.00
3332 2025-07-28 2621.67
2025-07-28 17:50:41,693 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3334 2025-07-26 2630.00 ... 2025-07-28 17:50:41.686285 2025-07-28 17:50:41.686676
3335 2025-07-27 2630.00 ... 2025-07-28 17:50:41.686285 2025-07-28 17:50:41.686676
3336 2025-07-28 2621.67 ... 2025-07-28 17:50:41.686285 2025-07-28 17:50:41.686676
[3 rows x 5 columns]
2025-07-28 17:50:41,712 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-28 17:50:42,328 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1532 2025-07-24 1272.5
1533 2025-07-25 1315.0
1534 2025-07-26 1315.0
1535 2025-07-27 1315.0
1536 2025-07-28 1315.0
2025-07-28 17:50:42,381 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1534 2025-07-26 1315.0 ... 2025-07-28 17:50:42.370827 2025-07-28 17:50:42.371504
1535 2025-07-27 1315.0 ... 2025-07-28 17:50:42.370827 2025-07-28 17:50:42.371504
1536 2025-07-28 1315.0 ... 2025-07-28 17:50:42.370827 2025-07-28 17:50:42.371504
[3 rows x 5 columns]
2025-07-28 17:50:42,401 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-07-28 17:50:42,407 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1532 2025-07-24 1272.5
1533 2025-07-25 1315.0
1534 2025-07-26 1315.0
1535 2025-07-27 1315.0
1536 2025-07-28 1315.0
2025-07-28 17:50:42,454 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1538 2025-07-26 1315.0 ... 2025-07-28 17:50:42.446609 2025-07-28 17:50:42.447035
1539 2025-07-27 1315.0 ... 2025-07-28 17:50:42.446609 2025-07-28 17:50:42.447035
1540 2025-07-28 1315.0 ... 2025-07-28 17:50:42.446609 2025-07-28 17:50:42.447035
[3 rows x 5 columns]
2025-07-28 17:50:42,473 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-28 17:50:43,104 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1445 2025-07-24 6599.17
1446 2025-07-25 6637.08
1447 2025-07-26 6637.08
1448 2025-07-27 6637.08
1449 2025-07-28 6605.67
2025-07-28 17:50:43,149 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1447 2025-07-26 6637.08 ... 2025-07-28 17:50:43.141380 2025-07-28 17:50:43.141801
1448 2025-07-27 6637.08 ... 2025-07-28 17:50:43.141380 2025-07-28 17:50:43.141801
1449 2025-07-28 6605.67 ... 2025-07-28 17:50:43.141380 2025-07-28 17:50:43.141801
[3 rows x 5 columns]
2025-07-28 17:50:43,168 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-07-28 17:50:43,179 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1445 2025-07-24 6599.17
1446 2025-07-25 6637.08
1447 2025-07-26 6637.08
1448 2025-07-27 6637.08
1449 2025-07-28 6605.67
2025-07-28 17:50:43,234 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1451 2025-07-26 6637.08 ... 2025-07-28 17:50:43.226054 2025-07-28 17:50:43.226693
1452 2025-07-27 6637.08 ... 2025-07-28 17:50:43.226054 2025-07-28 17:50:43.226693
1453 2025-07-28 6605.67 ... 2025-07-28 17:50:43.226054 2025-07-28 17:50:43.226693
[3 rows x 5 columns]
2025-07-28 17:50:43,254 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-28 17:50:43,870 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3818 2025-07-24 2980.0
3819 2025-07-25 2964.0
3820 2025-07-26 2964.0
3821 2025-07-27 2964.0
3822 2025-07-28 2954.0
2025-07-28 17:50:43,944 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3820 2025-07-26 2964.0 ... 2025-07-28 17:50:43.936855 2025-07-28 17:50:43.937248
3821 2025-07-27 2964.0 ... 2025-07-28 17:50:43.936855 2025-07-28 17:50:43.937248
3822 2025-07-28 2954.0 ... 2025-07-28 17:50:43.936855 2025-07-28 17:50:43.937248
[3 rows x 5 columns]
2025-07-28 17:50:43,963 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-07-28 17:50:43,969 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3818 2025-07-24 2980.0
3819 2025-07-25 2964.0
3820 2025-07-26 2964.0
3821 2025-07-27 2964.0
3822 2025-07-28 2954.0
2025-07-28 17:50:44,045 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3823 2025-07-26 2964.0 ... 2025-07-28 17:50:44.037719 2025-07-28 17:50:44.038139
3824 2025-07-27 2964.0 ... 2025-07-28 17:50:44.037719 2025-07-28 17:50:44.038139
3825 2025-07-28 2954.0 ... 2025-07-28 17:50:44.037719 2025-07-28 17:50:44.038139
[3 rows x 5 columns]
2025-07-28 17:50:44,064 - IOOppi_data - INFO : save diff data to db: IOOppi_m_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-28 17:50:44,728 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3588 2025-07-24 8414.0
3589 2025-07-25 8414.0
3590 2025-07-26 8404.0
3591 2025-07-27 8404.0
3592 2025-07-28 8384.0
2025-07-28 17:50:44,805 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3590 2025-07-26 8404.0 ... 2025-07-28 17:50:44.797788 2025-07-28 17:50:44.798190
3591 2025-07-27 8404.0 ... 2025-07-28 17:50:44.797788 2025-07-28 17:50:44.798190
3592 2025-07-28 8384.0 ... 2025-07-28 17:50:44.797788 2025-07-28 17:50:44.798190
[3 rows x 5 columns]
2025-07-28 17:50:44,824 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-07-28 17:50:44,831 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3588 2025-07-24 8414.0
3589 2025-07-25 8414.0
3590 2025-07-26 8404.0
3591 2025-07-27 8404.0
3592 2025-07-28 8384.0
2025-07-28 17:50:44,903 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3593 2025-07-26 8404.0 ... 2025-07-28 17:50:44.896093 2025-07-28 17:50:44.896486
3594 2025-07-27 8404.0 ... 2025-07-28 17:50:44.896093 2025-07-28 17:50:44.896486
3595 2025-07-28 8384.0 ... 2025-07-28 17:50:44.896093 2025-07-28 17:50:44.896486
[3 rows x 5 columns]
2025-07-28 17:50:44,922 - IOOppi_data - INFO : save diff data to db: IOOppi_y_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-28 17:50:45,533 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3554 2025-07-24 4295.0
3555 2025-07-25 4295.0
3556 2025-07-26 4295.0
3557 2025-07-27 4295.0
3558 2025-07-28 4295.0
2025-07-28 17:50:45,602 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3556 2025-07-26 4295.0 ... 2025-07-28 17:50:45.594904 2025-07-28 17:50:45.595342
3557 2025-07-27 4295.0 ... 2025-07-28 17:50:45.594904 2025-07-28 17:50:45.595342
3558 2025-07-28 4295.0 ... 2025-07-28 17:50:45.594904 2025-07-28 17:50:45.595342
[3 rows x 5 columns]
2025-07-28 17:50:45,620 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-07-28 17:50:45,626 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3554 2025-07-24 4295.0
3555 2025-07-25 4295.0
3556 2025-07-26 4295.0
3557 2025-07-27 4295.0
3558 2025-07-28 4295.0
2025-07-28 17:50:45,701 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3559 2025-07-26 4295.0 ... 2025-07-28 17:50:45.693924 2025-07-28 17:50:45.694363
3560 2025-07-27 4295.0 ... 2025-07-28 17:50:45.693924 2025-07-28 17:50:45.694363
3561 2025-07-28 4295.0 ... 2025-07-28 17:50:45.693924 2025-07-28 17:50:45.694363
[3 rows x 5 columns]
2025-07-28 17:50:45,720 - IOOppi_data - INFO : save diff data to db: IOOppi_a_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-28 17:50:46,311 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2931 2025-07-24 5452.86
2932 2025-07-25 5511.43
2933 2025-07-26 5557.14
2934 2025-07-27 5557.14
2935 2025-07-28 5561.43
2025-07-28 17:50:46,375 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2933 2025-07-26 5557.14 ... 2025-07-28 17:50:46.367094 2025-07-28 17:50:46.367486
2934 2025-07-27 5557.14 ... 2025-07-28 17:50:46.367094 2025-07-28 17:50:46.367486
2935 2025-07-28 5561.43 ... 2025-07-28 17:50:46.367094 2025-07-28 17:50:46.367486
[3 rows x 5 columns]
2025-07-28 17:50:46,398 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-07-28 17:50:46,405 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2931 2025-07-24 5452.86
2932 2025-07-25 5511.43
2933 2025-07-26 5557.14
2934 2025-07-27 5557.14
2935 2025-07-28 5561.43
2025-07-28 17:50:46,472 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2937 2025-07-26 5557.14 ... 2025-07-28 17:50:46.465145 2025-07-28 17:50:46.465531
2938 2025-07-27 5557.14 ... 2025-07-28 17:50:46.465145 2025-07-28 17:50:46.465531
2939 2025-07-28 5561.43 ... 2025-07-28 17:50:46.465145 2025-07-28 17:50:46.465531
[3 rows x 5 columns]
2025-07-28 17:50:46,491 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-28 17:50:47,027 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3131 2025-07-24 3440.0
3132 2025-07-25 3440.0
3133 2025-07-26 3440.0
3134 2025-07-27 3440.0
3135 2025-07-28 3400.0
2025-07-28 17:50:47,093 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3133 2025-07-26 3440.0 ... 2025-07-28 17:50:47.085536 2025-07-28 17:50:47.085959
3134 2025-07-27 3440.0 ... 2025-07-28 17:50:47.085536 2025-07-28 17:50:47.085959
3135 2025-07-28 3400.0 ... 2025-07-28 17:50:47.085536 2025-07-28 17:50:47.085959
[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-07-28 17:50:47,251 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-07-28 17:50:47.243931
458 2015-09-21 ... 2025-07-28 17:50:47.243931
549 2016-02-03 ... 2025-07-28 17:50:47.243931
693 2016-09-05 ... 2025-07-28 17:50:47.243931
696 2016-09-08 ... 2025-07-28 17:50:47.243931
[5 rows x 6 columns]
2025-07-28 17:50:47,284 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3131 2025-07-24 3440.0
3132 2025-07-25 3440.0
3133 2025-07-26 3440.0
3134 2025-07-27 3440.0
3135 2025-07-28 3400.0
2025-07-28 17:50:47,348 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3136 2025-07-26 3440.0 ... 2025-07-28 17:50:47.341258 2025-07-28 17:50:47.341645
3137 2025-07-27 3440.0 ... 2025-07-28 17:50:47.341258 2025-07-28 17:50:47.341645
3138 2025-07-28 3400.0 ... 2025-07-28 17:50:47.341258 2025-07-28 17:50:47.341645
[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-07-28 17:50:47,497 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-07-28 17:50:47.489489
458 2015-09-21 ... 2025-07-28 17:50:47.489489
549 2016-02-03 ... 2025-07-28 17:50:47.489489
693 2016-09-05 ... 2025-07-28 17:50:47.489489
696 2016-09-08 ... 2025-07-28 17:50:47.489489
[5 rows x 6 columns]
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-28 17:50:48,185 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
935 2025-07-24 10180.0
936 2025-07-25 10180.0
937 2025-07-26 10180.0
938 2025-07-27 10180.0
939 2025-07-28 10130.0
2025-07-28 17:50:48,223 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
937 2025-07-26 10180.0 ... 2025-07-28 17:50:48.215435 2025-07-28 17:50:48.215852
938 2025-07-27 10180.0 ... 2025-07-28 17:50:48.215435 2025-07-28 17:50:48.215852
939 2025-07-28 10130.0 ... 2025-07-28 17:50:48.215435 2025-07-28 17:50:48.215852
[3 rows x 5 columns]
2025-07-28 17:50:48,242 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-07-28 17:50:48,248 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
935 2025-07-24 10180.0
936 2025-07-25 10180.0
937 2025-07-26 10180.0
938 2025-07-27 10180.0
939 2025-07-28 10130.0
2025-07-28 17:50:48,289 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
937 2025-07-26 10180.0 ... 2025-07-28 17:50:48.281410 2025-07-28 17:50:48.281839
938 2025-07-27 10180.0 ... 2025-07-28 17:50:48.281410 2025-07-28 17:50:48.281839
939 2025-07-28 10130.0 ... 2025-07-28 17:50:48.281410 2025-07-28 17:50:48.281839
[3 rows x 5 columns]
2025-07-28 17:50:48,308 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-28 17:50:48,875 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3814 2025-07-24 7401.67
3815 2025-07-25 7450.00
3816 2025-07-26 7450.00
3817 2025-07-27 7450.00
3818 2025-07-28 7453.33
2025-07-28 17:50:48,953 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3816 2025-07-26 7450.00 ... 2025-07-28 17:50:48.944142 2025-07-28 17:50:48.944558
3817 2025-07-27 7450.00 ... 2025-07-28 17:50:48.944142 2025-07-28 17:50:48.944558
3818 2025-07-28 7453.33 ... 2025-07-28 17:50:48.944142 2025-07-28 17:50:48.944558
[3 rows x 5 columns]
2025-07-28 17:50:48,973 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-07-28 17:50:48,982 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3814 2025-07-24 7401.67
3815 2025-07-25 7450.00
3816 2025-07-26 7450.00
3817 2025-07-27 7450.00
3818 2025-07-28 7453.33
2025-07-28 17:50:49,068 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3819 2025-07-26 7450.00 ... 2025-07-28 17:50:49.057941 2025-07-28 17:50:49.058439
3820 2025-07-27 7450.00 ... 2025-07-28 17:50:49.057941 2025-07-28 17:50:49.058439
3821 2025-07-28 7453.33 ... 2025-07-28 17:50:49.057941 2025-07-28 17:50:49.058439
[3 rows x 5 columns]
2025-07-28 17:50:49,086 - IOOppi_data - INFO : save diff data to db: IOOppi_l_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-28 17:50:49,773 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3152 2025-07-24 3700.0
3153 2025-07-25 3700.0
3154 2025-07-26 3700.0
3155 2025-07-27 3700.0
3156 2025-07-28 3700.0
2025-07-28 17:50:49,845 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3155 2025-07-26 3700.0 ... 2025-07-28 17:50:49.838001 2025-07-28 17:50:49.838417
3156 2025-07-27 3700.0 ... 2025-07-28 17:50:49.838001 2025-07-28 17:50:49.838417
3157 2025-07-28 3700.0 ... 2025-07-28 17:50:49.838001 2025-07-28 17:50:49.838417
[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-07-28 17:50:49,881 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-07-28 17:50:49.873980
[1 rows x 6 columns]
2025-07-28 17:50:49,906 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3152 2025-07-24 3700.0
3153 2025-07-25 3700.0
3154 2025-07-26 3700.0
3155 2025-07-27 3700.0
3156 2025-07-28 3700.0
2025-07-28 17:50:49,972 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3157 2025-07-26 3700.0 ... 2025-07-28 17:50:49.964359 2025-07-28 17:50:49.964799
3158 2025-07-27 3700.0 ... 2025-07-28 17:50:49.964359 2025-07-28 17:50:49.964799
3159 2025-07-28 3700.0 ... 2025-07-28 17:50:49.964359 2025-07-28 17:50:49.964799
[3 rows x 5 columns]
2025-07-28 17:50:49,990 - IOOppi_data - INFO : save diff data to db: IOOppi_bu_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-28 17:50:50,619 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3817 2025-07-24 20856.67
3818 2025-07-25 20730.00
3819 2025-07-26 20796.67
3820 2025-07-27 20796.67
3821 2025-07-28 20676.67
2025-07-28 17:50:50,734 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date ... updated_at
3819 2025-07-26 ... 2025-07-28 17:50:50.727459
3820 2025-07-27 ... 2025-07-28 17:50:50.727459
3821 2025-07-28 ... 2025-07-28 17:50:50.727459
[3 rows x 5 columns]
2025-07-28 17:50:50,752 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-07-28 17:50:50,758 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3817 2025-07-24 20856.67
3818 2025-07-25 20730.00
3819 2025-07-26 20796.67
3820 2025-07-27 20796.67
3821 2025-07-28 20676.67
2025-07-28 17:50:50,830 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date ... updated_at
3822 2025-07-26 ... 2025-07-28 17:50:50.824093
3823 2025-07-27 ... 2025-07-28 17:50:50.824093
3824 2025-07-28 ... 2025-07-28 17:50:50.824093
[3 rows x 5 columns]
2025-07-28 17:50:50,849 - IOOppi_data - INFO : save diff data to db: IOOppi_al_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-28 17:50:51,463 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2931 2025-07-24 5710.0
2932 2025-07-25 5850.0
2933 2025-07-26 5850.0
2934 2025-07-27 5850.0
2935 2025-07-28 5802.0
2025-07-28 17:50:51,526 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2933 2025-07-26 5850.0 ... 2025-07-28 17:50:51.518817 2025-07-28 17:50:51.519251
2934 2025-07-27 5850.0 ... 2025-07-28 17:50:51.518817 2025-07-28 17:50:51.519251
2935 2025-07-28 5802.0 ... 2025-07-28 17:50:51.518817 2025-07-28 17:50:51.519251
[3 rows x 5 columns]
2025-07-28 17:50:51,549 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-07-28 17:50:51,556 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2931 2025-07-24 5710.0
2932 2025-07-25 5850.0
2933 2025-07-26 5850.0
2934 2025-07-27 5850.0
2935 2025-07-28 5802.0
2025-07-28 17:50:51,618 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2937 2025-07-26 5850.0 ... 2025-07-28 17:50:51.611071 2025-07-28 17:50:51.611474
2938 2025-07-27 5850.0 ... 2025-07-28 17:50:51.611071 2025-07-28 17:50:51.611474
2939 2025-07-28 5802.0 ... 2025-07-28 17:50:51.611071 2025-07-28 17:50:51.611474
[3 rows x 5 columns]
2025-07-28 17:50:51,637 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-28 17:50:52,254 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2206 2025-07-24 23450.0
2207 2025-07-25 23450.0
2208 2025-07-26 23450.0
2209 2025-07-27 23450.0
2210 2025-07-28 23450.0
2025-07-28 17:50:52,312 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2208 2025-07-26 23450.0 ... 2025-07-28 17:50:52.304581 2025-07-28 17:50:52.305019
2209 2025-07-27 23450.0 ... 2025-07-28 17:50:52.304581 2025-07-28 17:50:52.305019
2210 2025-07-28 23450.0 ... 2025-07-28 17:50:52.304581 2025-07-28 17:50:52.305019
[3 rows x 5 columns]
2025-07-28 17:50:52,331 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-07-28 17:50:52,337 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2206 2025-07-24 23450.0
2207 2025-07-25 23450.0
2208 2025-07-26 23450.0
2209 2025-07-27 23450.0
2210 2025-07-28 23450.0
2025-07-28 17:50:52,392 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2212 2025-07-26 23450.0 ... 2025-07-28 17:50:52.384301 2025-07-28 17:50:52.384719
2213 2025-07-27 23450.0 ... 2025-07-28 17:50:52.384301 2025-07-28 17:50:52.384719
2214 2025-07-28 23450.0 ... 2025-07-28 17:50:52.384301 2025-07-28 17:50:52.384719
[3 rows x 5 columns]
2025-07-28 17:50:52,411 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-28 17:50:52,997 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1721 2025-07-24 1832.5
1722 2025-07-25 1825.0
1723 2025-07-26 1825.0
1724 2025-07-27 1825.0
1725 2025-07-28 1822.5
2025-07-28 17:50:53,045 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1723 2025-07-26 1825.0 ... 2025-07-28 17:50:53.037091 2025-07-28 17:50:53.037482
1724 2025-07-27 1825.0 ... 2025-07-28 17:50:53.037091 2025-07-28 17:50:53.037482
1725 2025-07-28 1822.5 ... 2025-07-28 17:50:53.037091 2025-07-28 17:50:53.037482
[3 rows x 5 columns]
2025-07-28 17:50:53,064 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-07-28 17:50:53,071 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1721 2025-07-24 1832.5
1722 2025-07-25 1825.0
1723 2025-07-26 1825.0
1724 2025-07-27 1825.0
1725 2025-07-28 1822.5
2025-07-28 17:50:53,120 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1727 2025-07-26 1825.0 ... 2025-07-28 17:50:53.112335 2025-07-28 17:50:53.112820
1728 2025-07-27 1825.0 ... 2025-07-28 17:50:53.112335 2025-07-28 17:50:53.112820
1729 2025-07-28 1822.5 ... 2025-07-28 17:50:53.112335 2025-07-28 17:50:53.112820
[3 rows x 5 columns]
2025-07-28 17:50:53,143 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-28 17:50:53,766 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2793 2025-07-24 125000.00
2794 2025-07-25 124916.67
2795 2025-07-26 124916.67
2796 2025-07-27 124916.67
2797 2025-07-28 123566.67
2025-07-28 17:50:53,838 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2795 2025-07-26 ... 2025-07-28 17:50:53.828024
2796 2025-07-27 ... 2025-07-28 17:50:53.828024
2797 2025-07-28 ... 2025-07-28 17:50:53.828024
[3 rows x 5 columns]
2025-07-28 17:50:53,858 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-07-28 17:50:53,864 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2793 2025-07-24 125000.00
2794 2025-07-25 124916.67
2795 2025-07-26 124916.67
2796 2025-07-27 124916.67
2797 2025-07-28 123566.67
2025-07-28 17:50:53,926 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2798 2025-07-26 ... 2025-07-28 17:50:53.920168
2799 2025-07-27 ... 2025-07-28 17:50:53.920168
2800 2025-07-28 ... 2025-07-28 17:50:53.920168
[3 rows x 5 columns]
2025-07-28 17:50:53,945 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-28 17:50:54,563 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3818 2025-07-24 4918.0
3819 2025-07-25 5024.0
3820 2025-07-26 5024.0
3821 2025-07-27 5024.0
3822 2025-07-28 4925.0
2025-07-28 17:50:54,641 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3820 2025-07-26 5024.0 ... 2025-07-28 17:50:54.632885 2025-07-28 17:50:54.633489
3821 2025-07-27 5024.0 ... 2025-07-28 17:50:54.632885 2025-07-28 17:50:54.633489
3822 2025-07-28 4925.0 ... 2025-07-28 17:50:54.632885 2025-07-28 17:50:54.633489
[3 rows x 5 columns]
2025-07-28 17:50:54,659 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-07-28 17:50:54,665 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3818 2025-07-24 4918.0
3819 2025-07-25 5024.0
3820 2025-07-26 5024.0
3821 2025-07-27 5024.0
3822 2025-07-28 4925.0
2025-07-28 17:50:54,739 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3823 2025-07-26 5024.0 ... 2025-07-28 17:50:54.732223 2025-07-28 17:50:54.732614
3824 2025-07-27 5024.0 ... 2025-07-28 17:50:54.732223 2025-07-28 17:50:54.732614
3825 2025-07-28 4925.0 ... 2025-07-28 17:50:54.732223 2025-07-28 17:50:54.732614
[3 rows x 5 columns]
2025-07-28 17:50:54,757 - IOOppi_data - INFO : save diff data to db: IOOppi_v_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-28 17:50:55,335 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
3057 2025-07-24 7295.0
3058 2025-07-25 7295.0
3059 2025-07-26 7295.0
3060 2025-07-27 7295.0
3061 2025-07-28 7295.0
2025-07-28 17:50:55,405 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
3059 2025-07-26 7295.0 ... 2025-07-28 17:50:55.397549 2025-07-28 17:50:55.398156
3060 2025-07-27 7295.0 ... 2025-07-28 17:50:55.397549 2025-07-28 17:50:55.398156
3061 2025-07-28 7295.0 ... 2025-07-28 17:50:55.397549 2025-07-28 17:50:55.398156
[3 rows x 5 columns]
2025-07-28 17:50:55,424 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-07-28 17:50:55,430 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
3057 2025-07-24 7295.0
3058 2025-07-25 7295.0
3059 2025-07-26 7295.0
3060 2025-07-27 7295.0
3061 2025-07-28 7295.0
2025-07-28 17:50:55,494 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
3062 2025-07-26 7295.0 ... 2025-07-28 17:50:55.487180 2025-07-28 17:50:55.487635
3063 2025-07-27 7295.0 ... 2025-07-28 17:50:55.487180 2025-07-28 17:50:55.487635
3064 2025-07-28 7295.0 ... 2025-07-28 17:50:55.487180 2025-07-28 17:50:55.487635
[3 rows x 5 columns]
2025-07-28 17:50:55,513 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-28 17:50:56,135 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3819 2025-07-24 15573.5
3820 2025-07-25 15557.5
3821 2025-07-26 15557.5
3822 2025-07-27 15557.5
3823 2025-07-28 15557.5
2025-07-28 17:50:56,211 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date value ... created_at updated_at
3821 2025-07-26 15557.5 ... 2025-07-28 17:50:56.202062 2025-07-28 17:50:56.202622
3822 2025-07-27 15557.5 ... 2025-07-28 17:50:56.202062 2025-07-28 17:50:56.202622
3823 2025-07-28 15557.5 ... 2025-07-28 17:50:56.202062 2025-07-28 17:50:56.202622
[3 rows x 5 columns]
2025-07-28 17:50:56,229 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-07-28 17:50:56,236 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3819 2025-07-24 15573.5
3820 2025-07-25 15557.5
3821 2025-07-26 15557.5
3822 2025-07-27 15557.5
3823 2025-07-28 15557.5
2025-07-28 17:50:56,320 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date value ... created_at updated_at
3825 2025-07-26 15557.5 ... 2025-07-28 17:50:56.308122 2025-07-28 17:50:56.308833
3826 2025-07-27 15557.5 ... 2025-07-28 17:50:56.308122 2025-07-28 17:50:56.308833
3827 2025-07-28 15557.5 ... 2025-07-28 17:50:56.308122 2025-07-28 17:50:56.308833
[3 rows x 5 columns]
2025-07-28 17:50:56,342 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-28 17:50:57,023 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3764 2025-07-24 16768.75
3765 2025-07-25 16818.75
3766 2025-07-26 16818.75
3767 2025-07-27 16818.75
3768 2025-07-28 16843.75
2025-07-28 17:50:57,140 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date ... updated_at
3766 2025-07-26 ... 2025-07-28 17:50:57.128884
3767 2025-07-27 ... 2025-07-28 17:50:57.128884
3768 2025-07-28 ... 2025-07-28 17:50:57.128884
[3 rows x 5 columns]
2025-07-28 17:50:57,161 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-07-28 17:50:57,167 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3764 2025-07-24 16768.75
3765 2025-07-25 16818.75
3766 2025-07-26 16818.75
3767 2025-07-27 16818.75
3768 2025-07-28 16843.75
2025-07-28 17:50:57,240 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date ... updated_at
3769 2025-07-26 ... 2025-07-28 17:50:57.233733
3770 2025-07-27 ... 2025-07-28 17:50:57.233733
3771 2025-07-28 ... 2025-07-28 17:50:57.233733
[3 rows x 5 columns]
2025-07-28 17:50:57,258 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-28 17:50:57,859 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
3039 2025-07-24 3476.67
3040 2025-07-25 3476.67
3041 2025-07-26 3510.00
3042 2025-07-27 3510.00
3043 2025-07-28 3493.33
2025-07-28 17:50:57,926 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
3041 2025-07-26 3510.00 ... 2025-07-28 17:50:57.918543 2025-07-28 17:50:57.918987
3042 2025-07-27 3510.00 ... 2025-07-28 17:50:57.918543 2025-07-28 17:50:57.918987
3043 2025-07-28 3493.33 ... 2025-07-28 17:50:57.918543 2025-07-28 17:50:57.918987
[3 rows x 5 columns]
2025-07-28 17:50:57,944 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-07-28 17:50:57,950 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
3039 2025-07-24 3476.67
3040 2025-07-25 3476.67
3041 2025-07-26 3510.00
3042 2025-07-27 3510.00
3043 2025-07-28 3493.33
2025-07-28 17:50:58,018 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
3044 2025-07-26 3510.00 ... 2025-07-28 17:50:58.010592 2025-07-28 17:50:58.011014
3045 2025-07-27 3510.00 ... 2025-07-28 17:50:58.010592 2025-07-28 17:50:58.011014
3046 2025-07-28 3493.33 ... 2025-07-28 17:50:58.010592 2025-07-28 17:50:58.011014
[3 rows x 5 columns]
2025-07-28 17:50:58,036 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-28 17:50:58,612 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3319 2025-07-24 5275.0
3320 2025-07-25 5275.0
3321 2025-07-26 5275.0
3322 2025-07-27 5275.0
3323 2025-07-28 5275.0
2025-07-28 17:50:58,772 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3321 2025-07-26 5275.0 ... 2025-07-28 17:50:58.765032 2025-07-28 17:50:58.765427
3322 2025-07-27 5275.0 ... 2025-07-28 17:50:58.765032 2025-07-28 17:50:58.765427
3323 2025-07-28 5275.0 ... 2025-07-28 17:50:58.765032 2025-07-28 17:50:58.765427
[3 rows x 5 columns]
2025-07-28 17:50:58,791 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-07-28 17:50:58,797 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3319 2025-07-24 5275.0
3320 2025-07-25 5275.0
3321 2025-07-26 5275.0
3322 2025-07-27 5275.0
3323 2025-07-28 5275.0
2025-07-28 17:50:58,871 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3808 2025-07-26 5275.0 ... 2025-07-28 17:50:58.863379 2025-07-28 17:50:58.863804
3809 2025-07-27 5275.0 ... 2025-07-28 17:50:58.863379 2025-07-28 17:50:58.863804
3810 2025-07-28 5275.0 ... 2025-07-28 17:50:58.863379 2025-07-28 17:50:58.863804
[3 rows x 5 columns]
2025-07-28 17:50:58,889 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-28 17:50:59,429 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1383 2025-07-24 14380.0
1384 2025-07-25 14370.0
1385 2025-07-26 14370.0
1386 2025-07-27 14370.0
1387 2025-07-28 14280.0
2025-07-28 17:50:59,471 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1385 2025-07-26 14370.0 ... 2025-07-28 17:50:59.463840 2025-07-28 17:50:59.464231
1386 2025-07-27 14370.0 ... 2025-07-28 17:50:59.463840 2025-07-28 17:50:59.464231
1387 2025-07-28 14280.0 ... 2025-07-28 17:50:59.463840 2025-07-28 17:50:59.464231
[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-07-28 17:50:59,714 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-07-28 17:50:59.706793
117 2021-07-06 ... 2025-07-28 17:50:59.706793
121 2021-07-12 ... 2025-07-28 17:50:59.706793
122 2021-07-13 ... 2025-07-28 17:50:59.706793
194 2021-11-01 ... 2025-07-28 17:50:59.706793
[5 rows x 6 columns]
2025-07-28 17:50:59,753 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1383 2025-07-24 14380.0
1384 2025-07-25 14370.0
1385 2025-07-26 14370.0
1386 2025-07-27 14370.0
1387 2025-07-28 14280.0
2025-07-28 17:50:59,800 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1388 2025-07-26 14370.0 ... 2025-07-28 17:50:59.792359 2025-07-28 17:50:59.792742
1389 2025-07-27 14370.0 ... 2025-07-28 17:50:59.792359 2025-07-28 17:50:59.792742
1390 2025-07-28 14280.0 ... 2025-07-28 17:50:59.792359 2025-07-28 17:50:59.792742
[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-07-28 17:51:00,045 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-07-28 17:51:00.036986
117 2021-07-06 ... 2025-07-28 17:51:00.036986
121 2021-07-12 ... 2025-07-28 17:51:00.036986
122 2021-07-13 ... 2025-07-28 17:51:00.036986
194 2021-11-01 ... 2025-07-28 17:51:00.036986
[5 rows x 6 columns]
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-28 17:51:00,709 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3815 2025-07-24 79820.00
3816 2025-07-25 79538.33
3817 2025-07-26 79538.33
3818 2025-07-27 79538.33
3819 2025-07-28 79148.33
2025-07-28 17:51:00,782 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date ... updated_at
3817 2025-07-26 ... 2025-07-28 17:51:00.775989
3818 2025-07-27 ... 2025-07-28 17:51:00.775989
3819 2025-07-28 ... 2025-07-28 17:51:00.775989
[3 rows x 5 columns]
2025-07-28 17:51:00,800 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-07-28 17:51:00,807 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3815 2025-07-24 79820.00
3816 2025-07-25 79538.33
3817 2025-07-26 79538.33
3818 2025-07-27 79538.33
3819 2025-07-28 79148.33
2025-07-28 17:51:00,879 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date ... updated_at
3820 2025-07-26 ... 2025-07-28 17:51:00.873334
3821 2025-07-27 ... 2025-07-28 17:51:00.873334
3822 2025-07-28 ... 2025-07-28 17:51:00.873334
[3 rows x 5 columns]
2025-07-28 17:51:00,897 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-28 17:51:01,424 - IOOppi_data - INFO : save data to db IOOppi_PM_t data:
date value
2947 2024-06-26 2440.0
2948 2024-06-27 2460.0
2949 2024-06-28 2460.0
2950 2024-06-29 2460.0
2951 2024-06-30 2460.0
2025-07-28 17:51:01,504 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-07-28 17:51:01,504 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-07-28 17:51:01,512 - IOOppi_data - INFO : save data to db IOOppi_PM_g data:
date value
2947 2024-06-26 2440.0
2948 2024-06-27 2460.0
2949 2024-06-28 2460.0
2950 2024-06-29 2460.0
2951 2024-06-30 2460.0
2025-07-28 17:51:01,580 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-07-28 17:51:01,580 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-28 17:51:02,280 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2793 2025-07-24 273025.0
2794 2025-07-25 271437.5
2795 2025-07-26 271437.5
2796 2025-07-27 271437.5
2797 2025-07-28 268850.0
2025-07-28 17:51:02,342 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2795 2025-07-26 ... 2025-07-28 17:51:02.335555
2796 2025-07-27 ... 2025-07-28 17:51:02.335555
2797 2025-07-28 ... 2025-07-28 17:51:02.335555
[3 rows x 5 columns]
2025-07-28 17:51:02,362 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-07-28 17:51:02,369 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2793 2025-07-24 273025.0
2794 2025-07-25 271437.5
2795 2025-07-26 271437.5
2796 2025-07-27 271437.5
2797 2025-07-28 268850.0
2025-07-28 17:51:02,432 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2798 2025-07-26 ... 2025-07-28 17:51:02.425503
2799 2025-07-27 ... 2025-07-28 17:51:02.425503
2800 2025-07-28 ... 2025-07-28 17:51:02.425503
[3 rows x 5 columns]
2025-07-28 17:51:02,450 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-28 17:51:03,148 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3814 2025-07-24 22852.0
3815 2025-07-25 22756.0
3816 2025-07-26 22756.0
3817 2025-07-27 22756.0
3818 2025-07-28 22628.0
2025-07-28 17:51:03,229 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3816 2025-07-26 22756.0 ... 2025-07-28 17:51:03.220263 2025-07-28 17:51:03.220683
3817 2025-07-27 22756.0 ... 2025-07-28 17:51:03.220263 2025-07-28 17:51:03.220683
3818 2025-07-28 22628.0 ... 2025-07-28 17:51:03.220263 2025-07-28 17:51:03.220683
[3 rows x 5 columns]
2025-07-28 17:51:03,248 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-07-28 17:51:03,256 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3814 2025-07-24 22852.0
3815 2025-07-25 22756.0
3816 2025-07-26 22756.0
3817 2025-07-27 22756.0
3818 2025-07-28 22628.0
2025-07-28 17:51:03,336 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3819 2025-07-26 22756.0 ... 2025-07-28 17:51:03.326265 2025-07-28 17:51:03.326835
3820 2025-07-27 22756.0 ... 2025-07-28 17:51:03.326265 2025-07-28 17:51:03.326835
3821 2025-07-28 22628.0 ... 2025-07-28 17:51:03.326265 2025-07-28 17:51:03.326835
[3 rows x 5 columns]
2025-07-28 17:51:03,357 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-28 17:51:04,066 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3777 2025-07-24 3497.5
3778 2025-07-25 3497.5
3779 2025-07-26 3497.5
3780 2025-07-27 3497.5
3781 2025-07-28 3497.5
2025-07-28 17:51:04,141 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3779 2025-07-26 3497.5 ... 2025-07-28 17:51:04.134143 2025-07-28 17:51:04.134540
3780 2025-07-27 3497.5 ... 2025-07-28 17:51:04.134143 2025-07-28 17:51:04.134540
3781 2025-07-28 3497.5 ... 2025-07-28 17:51:04.134143 2025-07-28 17:51:04.134540
[3 rows x 5 columns]
2025-07-28 17:51:04,160 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-07-28 17:51:04,166 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3777 2025-07-24 3497.5
3778 2025-07-25 3497.5
3779 2025-07-26 3497.5
3780 2025-07-27 3497.5
3781 2025-07-28 3497.5
2025-07-28 17:51:04,242 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3782 2025-07-26 3497.5 ... 2025-07-28 17:51:04.234824 2025-07-28 17:51:04.235229
3783 2025-07-27 3497.5 ... 2025-07-28 17:51:04.234824 2025-07-28 17:51:04.235229
3784 2025-07-28 3497.5 ... 2025-07-28 17:51:04.234824 2025-07-28 17:51:04.235229
[3 rows x 5 columns]
2025-07-28 17:51:04,260 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-28 17:51:04,882 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1574 2025-07-24 4750.0
1575 2025-07-25 4762.5
1576 2025-07-26 4762.5
1577 2025-07-27 4762.5
1578 2025-07-28 4750.0
2025-07-28 17:51:04,927 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1576 2025-07-26 4762.5 ... 2025-07-28 17:51:04.920248 2025-07-28 17:51:04.920663
1577 2025-07-27 4762.5 ... 2025-07-28 17:51:04.920248 2025-07-28 17:51:04.920663
1578 2025-07-28 4750.0 ... 2025-07-28 17:51:04.920248 2025-07-28 17:51:04.920663
[3 rows x 5 columns]
2025-07-28 17:51:04,946 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-07-28 17:51:04,951 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1574 2025-07-24 4750.0
1575 2025-07-25 4762.5
1576 2025-07-26 4762.5
1577 2025-07-27 4762.5
1578 2025-07-28 4750.0
2025-07-28 17:51:04,998 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1579 2025-07-26 4762.5 ... 2025-07-28 17:51:04.991289 2025-07-28 17:51:04.991671
1580 2025-07-27 4762.5 ... 2025-07-28 17:51:04.991289 2025-07-28 17:51:04.991671
1581 2025-07-28 4750.0 ... 2025-07-28 17:51:04.991289 2025-07-28 17:51:04.991671
[3 rows x 5 columns]
2025-07-28 17:51:05,017 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-28 17:51:05,589 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2848 2025-07-24 2340.00
2849 2025-07-25 2332.86
2850 2025-07-26 2332.86
2851 2025-07-27 2332.86
2852 2025-07-28 2332.86
2025-07-28 17:51:05,651 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2850 2025-07-26 2332.86 ... 2025-07-28 17:51:05.643060 2025-07-28 17:51:05.643441
2851 2025-07-27 2332.86 ... 2025-07-28 17:51:05.643060 2025-07-28 17:51:05.643441
2852 2025-07-28 2332.86 ... 2025-07-28 17:51:05.643060 2025-07-28 17:51:05.643441
[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-07-28 17:51:05,694 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2849 2025-07-25 ... 2025-07-28 17:51:05.686859
[1 rows x 6 columns]
2025-07-28 17:51:05,716 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2848 2025-07-24 2340.00
2849 2025-07-25 2332.86
2850 2025-07-26 2332.86
2851 2025-07-27 2332.86
2852 2025-07-28 2332.86
2025-07-28 17:51:05,778 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2853 2025-07-26 2332.86 ... 2025-07-28 17:51:05.770741 2025-07-28 17:51:05.771152
2854 2025-07-27 2332.86 ... 2025-07-28 17:51:05.770741 2025-07-28 17:51:05.771152
2855 2025-07-28 2332.86 ... 2025-07-28 17:51:05.770741 2025-07-28 17:51:05.771152
[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-07-28 17:51:05,820 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2852 2025-07-25 ... 2025-07-28 17:51:05.812717
[1 rows x 6 columns]
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-28 17:51:06,389 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2848 2025-07-24 2340.00
2849 2025-07-25 2332.86
2850 2025-07-26 2332.86
2851 2025-07-27 2332.86
2852 2025-07-28 2930.00
2025-07-28 17:51:06,445 - IOOppi_data - INFO : save new data to db: IOOppi_cs_t: no new data
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-07-28 17:51:06,471 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2852 2025-07-28 ... 2025-07-28 17:51:06.460033
[1 rows x 6 columns]
2025-07-28 17:51:06,497 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2848 2025-07-24 2340.00
2849 2025-07-25 2332.86
2850 2025-07-26 2332.86
2851 2025-07-27 2332.86
2852 2025-07-28 2930.00
2025-07-28 17:51:06,551 - IOOppi_data - INFO : save new data to db: IOOppi_cs_g: no new data
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-07-28 17:51:06,579 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2855 2025-07-28 ... 2025-07-28 17:51:06.572032
[1 rows x 6 columns]
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-28 17:51:07,096 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3205 2025-07-24 9590.00
3206 2025-07-25 9590.00
3207 2025-07-26 9561.67
3208 2025-07-27 9561.67
3209 2025-07-28 9521.67
2025-07-28 17:51:07,153 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-07-28 17:51:07,153 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-07-28 17:51:07,158 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3205 2025-07-24 9590.00
3206 2025-07-25 9590.00
3207 2025-07-26 9561.67
3208 2025-07-27 9561.67
3209 2025-07-28 9521.67
2025-07-28 17:51:07,217 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-07-28 17:51:07,217 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-28 17:51:07,794 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1889 2025-07-24 4443.33
1890 2025-07-25 4448.33
1891 2025-07-26 4463.33
1892 2025-07-27 4463.33
1893 2025-07-28 4441.67
2025-07-28 17:51:07,843 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1891 2025-07-26 4463.33 ... 2025-07-28 17:51:07.835837 2025-07-28 17:51:07.836234
1892 2025-07-27 4463.33 ... 2025-07-28 17:51:07.835837 2025-07-28 17:51:07.836234
1893 2025-07-28 4441.67 ... 2025-07-28 17:51:07.835837 2025-07-28 17:51:07.836234
[3 rows x 5 columns]
2025-07-28 17:51:07,861 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-07-28 17:51:07,866 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1889 2025-07-24 4443.33
1890 2025-07-25 4448.33
1891 2025-07-26 4463.33
1892 2025-07-27 4463.33
1893 2025-07-28 4441.67
2025-07-28 17:51:07,916 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1894 2025-07-26 4463.33 ... 2025-07-28 17:51:07.908625 2025-07-28 17:51:07.909050
1895 2025-07-27 4463.33 ... 2025-07-28 17:51:07.908625 2025-07-28 17:51:07.909050
1896 2025-07-28 4441.67 ... 2025-07-28 17:51:07.908625 2025-07-28 17:51:07.909050
[3 rows x 5 columns]
2025-07-28 17:51:07,934 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-28 17:51:08,496 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1898 2025-07-24 5966.67
1899 2025-07-25 5966.67
1900 2025-07-26 5966.67
1901 2025-07-27 5966.67
1902 2025-07-28 5966.67
2025-07-28 17:51:08,555 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1900 2025-07-26 5966.67 ... 2025-07-28 17:51:08.545298 2025-07-28 17:51:08.545827
1901 2025-07-27 5966.67 ... 2025-07-28 17:51:08.545298 2025-07-28 17:51:08.545827
1902 2025-07-28 5966.67 ... 2025-07-28 17:51:08.545298 2025-07-28 17:51:08.545827
[3 rows x 5 columns]
2025-07-28 17:51:08,574 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-07-28 17:51:08,582 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1898 2025-07-24 5966.67
1899 2025-07-25 5966.67
1900 2025-07-26 5966.67
1901 2025-07-27 5966.67
1902 2025-07-28 5966.67
2025-07-28 17:51:08,632 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1903 2025-07-26 5966.67 ... 2025-07-28 17:51:08.625179 2025-07-28 17:51:08.625557
1904 2025-07-27 5966.67 ... 2025-07-28 17:51:08.625179 2025-07-28 17:51:08.625557
1905 2025-07-28 5966.67 ... 2025-07-28 17:51:08.625179 2025-07-28 17:51:08.625557
[3 rows x 5 columns]
2025-07-28 17:51:08,651 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-07-28 17:51:09,293 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3566 2025-07-24 9172.0
3567 2025-07-25 9016.0
3568 2025-07-26 9016.0
3569 2025-07-27 9016.0
3570 2025-07-28 8996.0
2025-07-28 17:51:09,367 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3568 2025-07-26 9016.0 ... 2025-07-28 17:51:09.359540 2025-07-28 17:51:09.359959
3569 2025-07-27 9016.0 ... 2025-07-28 17:51:09.359540 2025-07-28 17:51:09.359959
3570 2025-07-28 8996.0 ... 2025-07-28 17:51:09.359540 2025-07-28 17:51:09.359959
[3 rows x 5 columns]
2025-07-28 17:51:09,385 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-07-28 17:51:09,392 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3566 2025-07-24 9172.0
3567 2025-07-25 9016.0
3568 2025-07-26 9016.0
3569 2025-07-27 9016.0
3570 2025-07-28 8996.0
2025-07-28 17:51:09,464 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3571 2025-07-26 9016.0 ... 2025-07-28 17:51:09.456568 2025-07-28 17:51:09.456996
3572 2025-07-27 9016.0 ... 2025-07-28 17:51:09.456568 2025-07-28 17:51:09.456996
3573 2025-07-28 8996.0 ... 2025-07-28 17:51:09.456568 2025-07-28 17:51:09.456996
[3 rows x 5 columns]
2025-07-28 17:51:09,482 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data