=========================================================================
2025-07-31 17:50:26 Thu 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-31 17:50:28,469 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3377 2025-07-27 3369.00
3378 2025-07-28 3352.00
3379 2025-07-29 3371.00
3380 2025-07-30 3392.34
3381 2025-07-31 3345.00
2025-07-31 17:50:28,558 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3379 2025-07-29 3371.00 ... 2025-07-31 17:50:28.550568 2025-07-31 17:50:28.551006
3380 2025-07-30 3392.34 ... 2025-07-31 17:50:28.550568 2025-07-31 17:50:28.551006
3381 2025-07-31 3345.00 ... 2025-07-31 17:50:28.550568 2025-07-31 17:50:28.551006
[3 rows x 5 columns]
2025-07-31 17:50:28,579 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-07-31 17:50:28,585 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3377 2025-07-27 3369.00
3378 2025-07-28 3352.00
3379 2025-07-29 3371.00
3380 2025-07-30 3392.34
3381 2025-07-31 3345.00
2025-07-31 17:50:28,659 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3382 2025-07-29 3371.00 ... 2025-07-31 17:50:28.651464 2025-07-31 17:50:28.651865
3383 2025-07-30 3392.34 ... 2025-07-31 17:50:28.651464 2025-07-31 17:50:28.651865
3384 2025-07-31 3345.00 ... 2025-07-31 17:50:28.651464 2025-07-31 17:50:28.651865
[3 rows x 5 columns]
2025-07-31 17:50:28,678 - 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-31 17:50:29,452 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3598 2025-07-27 2481.67
3599 2025-07-28 2392.50
3600 2025-07-29 2405.00
3601 2025-07-30 2416.67
3602 2025-07-31 2393.33
2025-07-31 17:50:29,528 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3600 2025-07-29 2405.00 ... 2025-07-31 17:50:29.521195 2025-07-31 17:50:29.521579
3601 2025-07-30 2416.67 ... 2025-07-31 17:50:29.521195 2025-07-31 17:50:29.521579
3602 2025-07-31 2393.33 ... 2025-07-31 17:50:29.521195 2025-07-31 17:50:29.521579
[3 rows x 5 columns]
2025-07-31 17:50:29,548 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-07-31 17:50:29,554 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3598 2025-07-27 2481.67
3599 2025-07-28 2392.50
3600 2025-07-29 2405.00
3601 2025-07-30 2416.67
3602 2025-07-31 2393.33
2025-07-31 17:50:29,628 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3604 2025-07-29 2405.00 ... 2025-07-31 17:50:29.620732 2025-07-31 17:50:29.621172
3605 2025-07-30 2416.67 ... 2025-07-31 17:50:29.620732 2025-07-31 17:50:29.621172
3606 2025-07-31 2393.33 ... 2025-07-31 17:50:29.620732 2025-07-31 17:50:29.621172
[3 rows x 5 columns]
2025-07-31 17:50:29,649 - 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-31 17:50:30,266 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
938 2025-07-27 4874.84
939 2025-07-28 4862.50
940 2025-07-29 4863.34
941 2025-07-30 4889.16
942 2025-07-31 4859.59
2025-07-31 17:50:30,306 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
940 2025-07-29 4863.34 ... 2025-07-31 17:50:30.298429 2025-07-31 17:50:30.298843
941 2025-07-30 4889.16 ... 2025-07-31 17:50:30.298429 2025-07-31 17:50:30.298843
942 2025-07-31 4859.59 ... 2025-07-31 17:50:30.298429 2025-07-31 17:50:30.298843
[3 rows x 5 columns]
2025-07-31 17:50:30,328 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-07-31 17:50:30,334 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
938 2025-07-27 4874.84
939 2025-07-28 4862.50
940 2025-07-29 4863.34
941 2025-07-30 4889.16
942 2025-07-31 4859.59
2025-07-31 17:50:30,376 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
940 2025-07-29 4863.34 ... 2025-07-31 17:50:30.369011 2025-07-31 17:50:30.369407
941 2025-07-30 4889.16 ... 2025-07-31 17:50:30.369011 2025-07-31 17:50:30.369407
942 2025-07-31 4859.59 ... 2025-07-31 17:50:30.369011 2025-07-31 17:50:30.369407
[3 rows x 5 columns]
2025-07-31 17:50:30,396 - 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-31 17:50:31,100 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3817 2025-07-27 15633.33
3818 2025-07-28 15125.00
3819 2025-07-29 15066.67
3820 2025-07-30 15008.33
3821 2025-07-31 14700.00
2025-07-31 17:50:31,180 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3819 2025-07-29 ... 2025-07-31 17:50:31.173618
3820 2025-07-30 ... 2025-07-31 17:50:31.173618
3821 2025-07-31 ... 2025-07-31 17:50:31.173618
[3 rows x 5 columns]
2025-07-31 17:50:31,200 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-07-31 17:50:31,206 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3817 2025-07-27 15633.33
3818 2025-07-28 15125.00
3819 2025-07-29 15066.67
3820 2025-07-30 15008.33
3821 2025-07-31 14700.00
2025-07-31 17:50:31,282 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3822 2025-07-29 ... 2025-07-31 17:50:31.275723
3823 2025-07-30 ... 2025-07-31 17:50:31.275723
3824 2025-07-31 ... 2025-07-31 17:50:31.275723
[3 rows x 5 columns]
2025-07-31 17:50:31,302 - 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-31 17:50:32,010 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3149 2025-07-27 795.67
3150 2025-07-28 789.67
3151 2025-07-29 789.11
3152 2025-07-30 799.11
3153 2025-07-31 786.22
2025-07-31 17:50:32,077 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3151 2025-07-29 789.11 ... 2025-07-31 17:50:32.070162 2025-07-31 17:50:32.070548
3152 2025-07-30 799.11 ... 2025-07-31 17:50:32.070162 2025-07-31 17:50:32.070548
3153 2025-07-31 786.22 ... 2025-07-31 17:50:32.070162 2025-07-31 17:50:32.070548
[3 rows x 5 columns]
2025-07-31 17:50:32,097 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-07-31 17:50:32,102 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3149 2025-07-27 795.67
3150 2025-07-28 789.67
3151 2025-07-29 789.11
3152 2025-07-30 799.11
3153 2025-07-31 786.22
2025-07-31 17:50:32,169 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3154 2025-07-29 789.11 ... 2025-07-31 17:50:32.161975 2025-07-31 17:50:32.162361
3155 2025-07-30 799.11 ... 2025-07-31 17:50:32.161975 2025-07-31 17:50:32.162361
3156 2025-07-31 786.22 ... 2025-07-31 17:50:32.161975 2025-07-31 17:50:32.162361
[3 rows x 5 columns]
2025-07-31 17:50:32,188 - 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-31 17:50:32,867 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3352 2025-07-27 1256.0
3353 2025-07-28 1256.0
3354 2025-07-29 1284.0
3355 2025-07-30 1284.0
3356 2025-07-31 1284.0
2025-07-31 17:50:32,959 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3354 2025-07-29 1284.0 ... 2025-07-31 17:50:32.952121 2025-07-31 17:50:32.952506
3355 2025-07-30 1284.0 ... 2025-07-31 17:50:32.952121 2025-07-31 17:50:32.952506
3356 2025-07-31 1284.0 ... 2025-07-31 17:50:32.952121 2025-07-31 17:50:32.952506
[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-31 17:50:35,121 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-07-31 17:50:35.113236
21 2013-01-04 ... 2025-07-31 17:50:35.113236
54 2013-02-27 ... 2025-07-31 17:50:35.113236
60 2013-03-07 ... 2025-07-31 17:50:35.113236
61 2013-03-08 ... 2025-07-31 17:50:35.113236
[5 rows x 6 columns]
2025-07-31 17:50:35,298 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3352 2025-07-27 1256.0
3353 2025-07-28 1256.0
3354 2025-07-29 1284.0
3355 2025-07-30 1284.0
3356 2025-07-31 1284.0
2025-07-31 17:50:35,368 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3358 2025-07-29 1284.0 ... 2025-07-31 17:50:35.361058 2025-07-31 17:50:35.361452
3359 2025-07-30 1284.0 ... 2025-07-31 17:50:35.361058 2025-07-31 17:50:35.361452
3360 2025-07-31 1284.0 ... 2025-07-31 17:50:35.361058 2025-07-31 17:50:35.361452
[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-31 17:50:37,435 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-07-31 17:50:37.427503
21 2013-01-04 ... 2025-07-31 17:50:37.427503
54 2013-02-27 ... 2025-07-31 17:50:37.427503
60 2013-03-07 ... 2025-07-31 17:50:37.427503
61 2013-03-08 ... 2025-07-31 17:50:37.427503
[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-31 17:50:38,212 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1697 2025-07-27 7736.0
1698 2025-07-28 7720.0
1699 2025-07-29 7720.0
1700 2025-07-30 7720.0
1701 2025-07-31 7694.0
2025-07-31 17:50:38,262 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1699 2025-07-29 7720.0 ... 2025-07-31 17:50:38.255395 2025-07-31 17:50:38.255812
1700 2025-07-30 7720.0 ... 2025-07-31 17:50:38.255395 2025-07-31 17:50:38.255812
1701 2025-07-31 7694.0 ... 2025-07-31 17:50:38.255395 2025-07-31 17:50:38.255812
[3 rows x 5 columns]
2025-07-31 17:50:38,283 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-07-31 17:50:38,288 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1697 2025-07-27 7736.0
1698 2025-07-28 7720.0
1699 2025-07-29 7720.0
1700 2025-07-30 7720.0
1701 2025-07-31 7694.0
2025-07-31 17:50:38,337 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1702 2025-07-29 7720.0 ... 2025-07-31 17:50:38.329637 2025-07-31 17:50:38.330050
1703 2025-07-30 7720.0 ... 2025-07-31 17:50:38.329637 2025-07-31 17:50:38.330050
1704 2025-07-31 7694.0 ... 2025-07-31 17:50:38.329637 2025-07-31 17:50:38.330050
[3 rows x 5 columns]
2025-07-31 17:50:38,356 - 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-31 17:50:38,918 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3808 2025-07-27 6046.67
3809 2025-07-28 6043.33
3810 2025-07-29 6043.33
3811 2025-07-30 6040.00
3812 2025-07-31 6036.67
2025-07-31 17:50:38,993 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3810 2025-07-29 6043.33 ... 2025-07-31 17:50:38.985495 2025-07-31 17:50:38.985914
3811 2025-07-30 6040.00 ... 2025-07-31 17:50:38.985495 2025-07-31 17:50:38.985914
3812 2025-07-31 6036.67 ... 2025-07-31 17:50:38.985495 2025-07-31 17:50:38.985914
[3 rows x 5 columns]
2025-07-31 17:50:39,013 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-07-31 17:50:39,020 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3808 2025-07-27 6046.67
3809 2025-07-28 6043.33
3810 2025-07-29 6043.33
3811 2025-07-30 6040.00
3812 2025-07-31 6036.67
2025-07-31 17:50:39,096 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3814 2025-07-29 6043.33 ... 2025-07-31 17:50:39.088554 2025-07-31 17:50:39.088970
3815 2025-07-30 6040.00 ... 2025-07-31 17:50:39.088554 2025-07-31 17:50:39.088970
3816 2025-07-31 6036.67 ... 2025-07-31 17:50:39.088554 2025-07-31 17:50:39.088970
[3 rows x 5 columns]
2025-07-31 17:50:39,118 - 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-31 17:50:39,864 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1698 2025-07-27 13030.0
1699 2025-07-28 13017.5
1700 2025-07-29 13017.5
1701 2025-07-30 13080.0
1702 2025-07-31 13080.0
2025-07-31 17:50:39,912 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1700 2025-07-29 13017.5 ... 2025-07-31 17:50:39.905075 2025-07-31 17:50:39.905475
1701 2025-07-30 13080.0 ... 2025-07-31 17:50:39.905075 2025-07-31 17:50:39.905475
1702 2025-07-31 13080.0 ... 2025-07-31 17:50:39.905075 2025-07-31 17:50:39.905475
[3 rows x 5 columns]
2025-07-31 17:50:39,932 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-07-31 17:50:39,937 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1698 2025-07-27 13030.0
1699 2025-07-28 13017.5
1700 2025-07-29 13017.5
1701 2025-07-30 13080.0
1702 2025-07-31 13080.0
2025-07-31 17:50:39,986 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1703 2025-07-29 13017.5 ... 2025-07-31 17:50:39.978899 2025-07-31 17:50:39.979329
1704 2025-07-30 13080.0 ... 2025-07-31 17:50:39.978899 2025-07-31 17:50:39.979329
1705 2025-07-31 13080.0 ... 2025-07-31 17:50:39.978899 2025-07-31 17:50:39.979329
[3 rows x 5 columns]
2025-07-31 17:50:40,006 - 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-31 17:50:40,610 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3208 2025-07-27 9561.67
3209 2025-07-28 9521.67
3210 2025-07-29 9600.00
3211 2025-07-30 9600.00
3212 2025-07-31 9621.67
2025-07-31 17:50:40,679 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date value ... created_at updated_at
3210 2025-07-29 9600.00 ... 2025-07-31 17:50:40.671992 2025-07-31 17:50:40.672383
3211 2025-07-30 9600.00 ... 2025-07-31 17:50:40.671992 2025-07-31 17:50:40.672383
3212 2025-07-31 9621.67 ... 2025-07-31 17:50:40.671992 2025-07-31 17:50:40.672383
[3 rows x 5 columns]
2025-07-31 17:50:40,698 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-07-31 17:50:40,704 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3208 2025-07-27 9561.67
3209 2025-07-28 9521.67
3210 2025-07-29 9600.00
3211 2025-07-30 9600.00
3212 2025-07-31 9621.67
2025-07-31 17:50:40,769 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date value ... created_at updated_at
3214 2025-07-29 9600.00 ... 2025-07-31 17:50:40.762305 2025-07-31 17:50:40.762680
3215 2025-07-30 9600.00 ... 2025-07-31 17:50:40.762305 2025-07-31 17:50:40.762680
3216 2025-07-31 9621.67 ... 2025-07-31 17:50:40.762305 2025-07-31 17:50:40.762680
[3 rows x 5 columns]
2025-07-31 17:50:40,788 - 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-31 17:50:41,362 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3331 2025-07-27 2630.00
3332 2025-07-28 2621.67
3333 2025-07-29 2586.67
3334 2025-07-30 2590.00
3335 2025-07-31 2656.67
2025-07-31 17:50:41,431 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3333 2025-07-29 2586.67 ... 2025-07-31 17:50:41.424314 2025-07-31 17:50:41.424767
3334 2025-07-30 2590.00 ... 2025-07-31 17:50:41.424314 2025-07-31 17:50:41.424767
3335 2025-07-31 2656.67 ... 2025-07-31 17:50:41.424314 2025-07-31 17:50:41.424767
[3 rows x 5 columns]
2025-07-31 17:50:41,451 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-07-31 17:50:41,458 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3331 2025-07-27 2630.00
3332 2025-07-28 2621.67
3333 2025-07-29 2586.67
3334 2025-07-30 2590.00
3335 2025-07-31 2656.67
2025-07-31 17:50:41,530 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3337 2025-07-29 2586.67 ... 2025-07-31 17:50:41.522874 2025-07-31 17:50:41.523276
3338 2025-07-30 2590.00 ... 2025-07-31 17:50:41.522874 2025-07-31 17:50:41.523276
3339 2025-07-31 2656.67 ... 2025-07-31 17:50:41.522874 2025-07-31 17:50:41.523276
[3 rows x 5 columns]
2025-07-31 17:50:41,550 - 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-31 17:50:42,188 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1535 2025-07-27 1315.0
1536 2025-07-28 1315.0
1537 2025-07-29 1315.0
1538 2025-07-30 1315.0
1539 2025-07-31 1315.0
2025-07-31 17:50:42,233 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1537 2025-07-29 1315.0 ... 2025-07-31 17:50:42.226078 2025-07-31 17:50:42.226467
1538 2025-07-30 1315.0 ... 2025-07-31 17:50:42.226078 2025-07-31 17:50:42.226467
1539 2025-07-31 1315.0 ... 2025-07-31 17:50:42.226078 2025-07-31 17:50:42.226467
[3 rows x 5 columns]
2025-07-31 17:50:42,254 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-07-31 17:50:42,259 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1535 2025-07-27 1315.0
1536 2025-07-28 1315.0
1537 2025-07-29 1315.0
1538 2025-07-30 1315.0
1539 2025-07-31 1315.0
2025-07-31 17:50:42,304 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1541 2025-07-29 1315.0 ... 2025-07-31 17:50:42.297472 2025-07-31 17:50:42.297874
1542 2025-07-30 1315.0 ... 2025-07-31 17:50:42.297472 2025-07-31 17:50:42.297874
1543 2025-07-31 1315.0 ... 2025-07-31 17:50:42.297472 2025-07-31 17:50:42.297874
[3 rows x 5 columns]
2025-07-31 17:50:42,324 - 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-31 17:50:42,946 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1448 2025-07-27 6637.08
1449 2025-07-28 6605.67
1450 2025-07-29 6595.50
1451 2025-07-30 6613.00
1452 2025-07-31 6600.00
2025-07-31 17:50:42,991 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1450 2025-07-29 6595.5 ... 2025-07-31 17:50:42.983638 2025-07-31 17:50:42.984056
1451 2025-07-30 6613.0 ... 2025-07-31 17:50:42.983638 2025-07-31 17:50:42.984056
1452 2025-07-31 6600.0 ... 2025-07-31 17:50:42.983638 2025-07-31 17:50:42.984056
[3 rows x 5 columns]
2025-07-31 17:50:43,011 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-07-31 17:50:43,017 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1448 2025-07-27 6637.08
1449 2025-07-28 6605.67
1450 2025-07-29 6595.50
1451 2025-07-30 6613.00
1452 2025-07-31 6600.00
2025-07-31 17:50:43,068 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1454 2025-07-29 6595.5 ... 2025-07-31 17:50:43.058803 2025-07-31 17:50:43.059434
1455 2025-07-30 6613.0 ... 2025-07-31 17:50:43.058803 2025-07-31 17:50:43.059434
1456 2025-07-31 6600.0 ... 2025-07-31 17:50:43.058803 2025-07-31 17:50:43.059434
[3 rows x 5 columns]
2025-07-31 17:50:43,087 - 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-31 17:50:43,840 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3821 2025-07-27 2964.0
3822 2025-07-28 2954.0
3823 2025-07-29 2938.0
3824 2025-07-30 2964.0
3825 2025-07-31 2984.0
2025-07-31 17:50:43,918 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3823 2025-07-29 2938.0 ... 2025-07-31 17:50:43.910993 2025-07-31 17:50:43.911386
3824 2025-07-30 2964.0 ... 2025-07-31 17:50:43.910993 2025-07-31 17:50:43.911386
3825 2025-07-31 2984.0 ... 2025-07-31 17:50:43.910993 2025-07-31 17:50:43.911386
[3 rows x 5 columns]
2025-07-31 17:50:43,937 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-07-31 17:50:43,943 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3821 2025-07-27 2964.0
3822 2025-07-28 2954.0
3823 2025-07-29 2938.0
3824 2025-07-30 2964.0
3825 2025-07-31 2984.0
2025-07-31 17:50:44,020 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3826 2025-07-29 2938.0 ... 2025-07-31 17:50:44.012423 2025-07-31 17:50:44.012833
3827 2025-07-30 2964.0 ... 2025-07-31 17:50:44.012423 2025-07-31 17:50:44.012833
3828 2025-07-31 2984.0 ... 2025-07-31 17:50:44.012423 2025-07-31 17:50:44.012833
[3 rows x 5 columns]
2025-07-31 17:50:44,039 - 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-31 17:50:44,710 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3591 2025-07-27 8404.0
3592 2025-07-28 8384.0
3593 2025-07-29 8484.0
3594 2025-07-30 8484.0
3595 2025-07-31 8454.0
2025-07-31 17:50:44,793 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3593 2025-07-29 8484.0 ... 2025-07-31 17:50:44.785046 2025-07-31 17:50:44.785496
3594 2025-07-30 8484.0 ... 2025-07-31 17:50:44.785046 2025-07-31 17:50:44.785496
3595 2025-07-31 8454.0 ... 2025-07-31 17:50:44.785046 2025-07-31 17:50:44.785496
[3 rows x 5 columns]
2025-07-31 17:50:44,814 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-07-31 17:50:44,820 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3591 2025-07-27 8404.0
3592 2025-07-28 8384.0
3593 2025-07-29 8484.0
3594 2025-07-30 8484.0
3595 2025-07-31 8454.0
2025-07-31 17:50:44,898 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3596 2025-07-29 8484.0 ... 2025-07-31 17:50:44.890127 2025-07-31 17:50:44.890539
3597 2025-07-30 8484.0 ... 2025-07-31 17:50:44.890127 2025-07-31 17:50:44.890539
3598 2025-07-31 8454.0 ... 2025-07-31 17:50:44.890127 2025-07-31 17:50:44.890539
[3 rows x 5 columns]
2025-07-31 17:50:44,918 - 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-31 17:50:45,556 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3557 2025-07-27 4295.0
3558 2025-07-28 4295.0
3559 2025-07-29 4295.0
3560 2025-07-30 4295.0
3561 2025-07-31 4295.0
2025-07-31 17:50:45,626 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3559 2025-07-29 4295.0 ... 2025-07-31 17:50:45.618624 2025-07-31 17:50:45.619037
3560 2025-07-30 4295.0 ... 2025-07-31 17:50:45.618624 2025-07-31 17:50:45.619037
3561 2025-07-31 4295.0 ... 2025-07-31 17:50:45.618624 2025-07-31 17:50:45.619037
[3 rows x 5 columns]
2025-07-31 17:50:45,645 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-07-31 17:50:45,651 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3557 2025-07-27 4295.0
3558 2025-07-28 4295.0
3559 2025-07-29 4295.0
3560 2025-07-30 4295.0
3561 2025-07-31 4295.0
2025-07-31 17:50:45,723 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3562 2025-07-29 4295.0 ... 2025-07-31 17:50:45.716011 2025-07-31 17:50:45.716394
3563 2025-07-30 4295.0 ... 2025-07-31 17:50:45.716011 2025-07-31 17:50:45.716394
3564 2025-07-31 4295.0 ... 2025-07-31 17:50:45.716011 2025-07-31 17:50:45.716394
[3 rows x 5 columns]
2025-07-31 17:50:45,745 - 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-31 17:50:46,367 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2934 2025-07-27 5557.14
2935 2025-07-28 5561.43
2936 2025-07-29 5561.43
2937 2025-07-30 5590.00
2938 2025-07-31 5528.57
2025-07-31 17:50:46,431 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2936 2025-07-29 5561.43 ... 2025-07-31 17:50:46.424327 2025-07-31 17:50:46.424711
2937 2025-07-30 5590.00 ... 2025-07-31 17:50:46.424327 2025-07-31 17:50:46.424711
2938 2025-07-31 5528.57 ... 2025-07-31 17:50:46.424327 2025-07-31 17:50:46.424711
[3 rows x 5 columns]
2025-07-31 17:50:46,452 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-07-31 17:50:46,457 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2934 2025-07-27 5557.14
2935 2025-07-28 5561.43
2936 2025-07-29 5561.43
2937 2025-07-30 5590.00
2938 2025-07-31 5528.57
2025-07-31 17:50:46,527 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2940 2025-07-29 5561.43 ... 2025-07-31 17:50:46.519635 2025-07-31 17:50:46.520054
2941 2025-07-30 5590.00 ... 2025-07-31 17:50:46.519635 2025-07-31 17:50:46.520054
2942 2025-07-31 5528.57 ... 2025-07-31 17:50:46.519635 2025-07-31 17:50:46.520054
[3 rows x 5 columns]
2025-07-31 17:50:46,546 - 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-31 17:50:47,182 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3134 2025-07-27 3440.0
3135 2025-07-28 3400.0
3136 2025-07-29 3400.0
3137 2025-07-30 3400.0
3138 2025-07-31 3335.0
2025-07-31 17:50:47,248 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3136 2025-07-29 3400.0 ... 2025-07-31 17:50:47.240927 2025-07-31 17:50:47.241331
3137 2025-07-30 3400.0 ... 2025-07-31 17:50:47.240927 2025-07-31 17:50:47.241331
3138 2025-07-31 3335.0 ... 2025-07-31 17:50:47.240927 2025-07-31 17:50:47.241331
[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-31 17:50:47,405 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-07-31 17:50:47.397680
458 2015-09-21 ... 2025-07-31 17:50:47.397680
549 2016-02-03 ... 2025-07-31 17:50:47.397680
693 2016-09-05 ... 2025-07-31 17:50:47.397680
696 2016-09-08 ... 2025-07-31 17:50:47.397680
[5 rows x 6 columns]
2025-07-31 17:50:47,438 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3134 2025-07-27 3440.0
3135 2025-07-28 3400.0
3136 2025-07-29 3400.0
3137 2025-07-30 3400.0
3138 2025-07-31 3335.0
2025-07-31 17:50:47,504 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3139 2025-07-29 3400.0 ... 2025-07-31 17:50:47.497462 2025-07-31 17:50:47.497874
3140 2025-07-30 3400.0 ... 2025-07-31 17:50:47.497462 2025-07-31 17:50:47.497874
3141 2025-07-31 3335.0 ... 2025-07-31 17:50:47.497462 2025-07-31 17:50:47.497874
[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-31 17:50:47,657 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-07-31 17:50:47.649388
458 2015-09-21 ... 2025-07-31 17:50:47.649388
549 2016-02-03 ... 2025-07-31 17:50:47.649388
693 2016-09-05 ... 2025-07-31 17:50:47.649388
696 2016-09-08 ... 2025-07-31 17:50:47.649388
[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-31 17:50:48,288 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
938 2025-07-27 10180.0
939 2025-07-28 10130.0
940 2025-07-29 9970.0
941 2025-07-30 10110.0
942 2025-07-31 10000.0
2025-07-31 17:50:48,326 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
940 2025-07-29 9970.0 ... 2025-07-31 17:50:48.319168 2025-07-31 17:50:48.319563
941 2025-07-30 10110.0 ... 2025-07-31 17:50:48.319168 2025-07-31 17:50:48.319563
942 2025-07-31 10000.0 ... 2025-07-31 17:50:48.319168 2025-07-31 17:50:48.319563
[3 rows x 5 columns]
2025-07-31 17:50:48,347 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-07-31 17:50:48,352 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
938 2025-07-27 10180.0
939 2025-07-28 10130.0
940 2025-07-29 9970.0
941 2025-07-30 10110.0
942 2025-07-31 10000.0
2025-07-31 17:50:48,388 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
940 2025-07-29 9970.0 ... 2025-07-31 17:50:48.381253 2025-07-31 17:50:48.381627
941 2025-07-30 10110.0 ... 2025-07-31 17:50:48.381253 2025-07-31 17:50:48.381627
942 2025-07-31 10000.0 ... 2025-07-31 17:50:48.381253 2025-07-31 17:50:48.381627
[3 rows x 5 columns]
2025-07-31 17:50:48,408 - 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-31 17:50:48,968 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3817 2025-07-27 7450.00
3818 2025-07-28 7453.33
3819 2025-07-29 7461.67
3820 2025-07-30 7466.67
3821 2025-07-31 7466.67
2025-07-31 17:50:49,045 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3819 2025-07-29 7461.67 ... 2025-07-31 17:50:49.037535 2025-07-31 17:50:49.037946
3820 2025-07-30 7466.67 ... 2025-07-31 17:50:49.037535 2025-07-31 17:50:49.037946
3821 2025-07-31 7466.67 ... 2025-07-31 17:50:49.037535 2025-07-31 17:50:49.037946
[3 rows x 5 columns]
2025-07-31 17:50:49,065 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-07-31 17:50:49,071 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3817 2025-07-27 7450.00
3818 2025-07-28 7453.33
3819 2025-07-29 7461.67
3820 2025-07-30 7466.67
3821 2025-07-31 7466.67
2025-07-31 17:50:49,148 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3822 2025-07-29 7461.67 ... 2025-07-31 17:50:49.141306 2025-07-31 17:50:49.141687
3823 2025-07-30 7466.67 ... 2025-07-31 17:50:49.141306 2025-07-31 17:50:49.141687
3824 2025-07-31 7466.67 ... 2025-07-31 17:50:49.141306 2025-07-31 17:50:49.141687
[3 rows x 5 columns]
2025-07-31 17:50:49,168 - 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-31 17:50:49,766 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3155 2025-07-27 3700.00
3156 2025-07-28 3700.00
3157 2025-07-29 3700.00
3158 2025-07-30 3726.67
3159 2025-07-31 3726.67
2025-07-31 17:50:49,832 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3158 2025-07-29 3700.00 ... 2025-07-31 17:50:49.824884 2025-07-31 17:50:49.825278
3159 2025-07-30 3726.67 ... 2025-07-31 17:50:49.824884 2025-07-31 17:50:49.825278
3160 2025-07-31 3726.67 ... 2025-07-31 17:50:49.824884 2025-07-31 17:50:49.825278
[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-31 17:50:49,868 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-07-31 17:50:49.861567
[1 rows x 6 columns]
2025-07-31 17:50:49,892 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3155 2025-07-27 3700.00
3156 2025-07-28 3700.00
3157 2025-07-29 3700.00
3158 2025-07-30 3726.67
3159 2025-07-31 3726.67
2025-07-31 17:50:49,958 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3160 2025-07-29 3700.00 ... 2025-07-31 17:50:49.951060 2025-07-31 17:50:49.951437
3161 2025-07-30 3726.67 ... 2025-07-31 17:50:49.951060 2025-07-31 17:50:49.951437
3162 2025-07-31 3726.67 ... 2025-07-31 17:50:49.951060 2025-07-31 17:50:49.951437
[3 rows x 5 columns]
2025-07-31 17:50:49,981 - 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-31 17:50:50,597 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3820 2025-07-27 20796.67
3821 2025-07-28 20676.67
3822 2025-07-29 20676.67
3823 2025-07-30 20676.67
3824 2025-07-31 20596.67
2025-07-31 17:50:50,673 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date ... updated_at
3822 2025-07-29 ... 2025-07-31 17:50:50.666624
3823 2025-07-30 ... 2025-07-31 17:50:50.666624
3824 2025-07-31 ... 2025-07-31 17:50:50.666624
[3 rows x 5 columns]
2025-07-31 17:50:50,693 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-07-31 17:50:50,699 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3820 2025-07-27 20796.67
3821 2025-07-28 20676.67
3822 2025-07-29 20676.67
3823 2025-07-30 20676.67
3824 2025-07-31 20596.67
2025-07-31 17:50:50,775 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date ... updated_at
3825 2025-07-29 ... 2025-07-31 17:50:50.768847
3826 2025-07-30 ... 2025-07-31 17:50:50.768847
3827 2025-07-31 ... 2025-07-31 17:50:50.768847
[3 rows x 5 columns]
2025-07-31 17:50:50,795 - 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-31 17:50:51,414 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2934 2025-07-27 5850.0
2935 2025-07-28 5802.0
2936 2025-07-29 5920.0
2937 2025-07-30 5920.0
2938 2025-07-31 5876.0
2025-07-31 17:50:51,480 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2936 2025-07-29 5920.0 ... 2025-07-31 17:50:51.470655 2025-07-31 17:50:51.471078
2937 2025-07-30 5920.0 ... 2025-07-31 17:50:51.470655 2025-07-31 17:50:51.471078
2938 2025-07-31 5876.0 ... 2025-07-31 17:50:51.470655 2025-07-31 17:50:51.471078
[3 rows x 5 columns]
2025-07-31 17:50:51,499 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-07-31 17:50:51,505 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2934 2025-07-27 5850.0
2935 2025-07-28 5802.0
2936 2025-07-29 5920.0
2937 2025-07-30 5920.0
2938 2025-07-31 5876.0
2025-07-31 17:50:51,569 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2940 2025-07-29 5920.0 ... 2025-07-31 17:50:51.561843 2025-07-31 17:50:51.562245
2941 2025-07-30 5920.0 ... 2025-07-31 17:50:51.561843 2025-07-31 17:50:51.562245
2942 2025-07-31 5876.0 ... 2025-07-31 17:50:51.561843 2025-07-31 17:50:51.562245
[3 rows x 5 columns]
2025-07-31 17:50:51,589 - 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-31 17:50:52,161 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2209 2025-07-27 23450.0
2210 2025-07-28 23450.0
2211 2025-07-29 23600.0
2212 2025-07-30 23600.0
2213 2025-07-31 23600.0
2025-07-31 17:50:52,215 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2211 2025-07-29 23600.0 ... 2025-07-31 17:50:52.208013 2025-07-31 17:50:52.208404
2212 2025-07-30 23600.0 ... 2025-07-31 17:50:52.208013 2025-07-31 17:50:52.208404
2213 2025-07-31 23600.0 ... 2025-07-31 17:50:52.208013 2025-07-31 17:50:52.208404
[3 rows x 5 columns]
2025-07-31 17:50:52,234 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-07-31 17:50:52,240 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2209 2025-07-27 23450.0
2210 2025-07-28 23450.0
2211 2025-07-29 23600.0
2212 2025-07-30 23600.0
2213 2025-07-31 23600.0
2025-07-31 17:50:52,293 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2215 2025-07-29 23600.0 ... 2025-07-31 17:50:52.286012 2025-07-31 17:50:52.286394
2216 2025-07-30 23600.0 ... 2025-07-31 17:50:52.286012 2025-07-31 17:50:52.286394
2217 2025-07-31 23600.0 ... 2025-07-31 17:50:52.286012 2025-07-31 17:50:52.286394
[3 rows x 5 columns]
2025-07-31 17:50:52,313 - 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-31 17:50:52,865 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1724 2025-07-27 1825.0
1725 2025-07-28 1822.5
1726 2025-07-29 1817.5
1727 2025-07-30 1817.5
1728 2025-07-31 1812.5
2025-07-31 17:50:52,916 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1726 2025-07-29 1817.5 ... 2025-07-31 17:50:52.907645 2025-07-31 17:50:52.908434
1727 2025-07-30 1817.5 ... 2025-07-31 17:50:52.907645 2025-07-31 17:50:52.908434
1728 2025-07-31 1812.5 ... 2025-07-31 17:50:52.907645 2025-07-31 17:50:52.908434
[3 rows x 5 columns]
2025-07-31 17:50:52,935 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-07-31 17:50:52,941 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1724 2025-07-27 1825.0
1725 2025-07-28 1822.5
1726 2025-07-29 1817.5
1727 2025-07-30 1817.5
1728 2025-07-31 1812.5
2025-07-31 17:50:52,990 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1730 2025-07-29 1817.5 ... 2025-07-31 17:50:52.983128 2025-07-31 17:50:52.983515
1731 2025-07-30 1817.5 ... 2025-07-31 17:50:52.983128 2025-07-31 17:50:52.983515
1732 2025-07-31 1812.5 ... 2025-07-31 17:50:52.983128 2025-07-31 17:50:52.983515
[3 rows x 5 columns]
2025-07-31 17:50:53,011 - 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-31 17:50:53,627 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2796 2025-07-27 124916.67
2797 2025-07-28 123566.67
2798 2025-07-29 122683.33
2799 2025-07-30 123400.00
2800 2025-07-31 121466.67
2025-07-31 17:50:53,688 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2798 2025-07-29 ... 2025-07-31 17:50:53.681598
2799 2025-07-30 ... 2025-07-31 17:50:53.681598
2800 2025-07-31 ... 2025-07-31 17:50:53.681598
[3 rows x 5 columns]
2025-07-31 17:50:53,707 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-07-31 17:50:53,713 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2796 2025-07-27 124916.67
2797 2025-07-28 123566.67
2798 2025-07-29 122683.33
2799 2025-07-30 123400.00
2800 2025-07-31 121466.67
2025-07-31 17:50:53,775 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2801 2025-07-29 ... 2025-07-31 17:50:53.769097
2802 2025-07-30 ... 2025-07-31 17:50:53.769097
2803 2025-07-31 ... 2025-07-31 17:50:53.769097
[3 rows x 5 columns]
2025-07-31 17:50:53,794 - 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-31 17:50:54,360 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3821 2025-07-27 5024.0
3822 2025-07-28 4925.0
3823 2025-07-29 4909.0
3824 2025-07-30 4997.0
3825 2025-07-31 4869.0
2025-07-31 17:50:54,437 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3823 2025-07-29 4909.0 ... 2025-07-31 17:50:54.430416 2025-07-31 17:50:54.430826
3824 2025-07-30 4997.0 ... 2025-07-31 17:50:54.430416 2025-07-31 17:50:54.430826
3825 2025-07-31 4869.0 ... 2025-07-31 17:50:54.430416 2025-07-31 17:50:54.430826
[3 rows x 5 columns]
2025-07-31 17:50:54,457 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-07-31 17:50:54,463 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3821 2025-07-27 5024.0
3822 2025-07-28 4925.0
3823 2025-07-29 4909.0
3824 2025-07-30 4997.0
3825 2025-07-31 4869.0
2025-07-31 17:50:54,539 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3826 2025-07-29 4909.0 ... 2025-07-31 17:50:54.532562 2025-07-31 17:50:54.532978
3827 2025-07-30 4997.0 ... 2025-07-31 17:50:54.532562 2025-07-31 17:50:54.532978
3828 2025-07-31 4869.0 ... 2025-07-31 17:50:54.532562 2025-07-31 17:50:54.532978
[3 rows x 5 columns]
2025-07-31 17:50:54,559 - 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-31 17:50:55,390 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
3060 2025-07-27 7295.00
3061 2025-07-28 7295.00
3062 2025-07-29 7278.33
3063 2025-07-30 7278.33
3064 2025-07-31 7278.33
2025-07-31 17:50:55,457 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
3062 2025-07-29 7278.33 ... 2025-07-31 17:50:55.450131 2025-07-31 17:50:55.450517
3063 2025-07-30 7278.33 ... 2025-07-31 17:50:55.450131 2025-07-31 17:50:55.450517
3064 2025-07-31 7278.33 ... 2025-07-31 17:50:55.450131 2025-07-31 17:50:55.450517
[3 rows x 5 columns]
2025-07-31 17:50:55,477 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-07-31 17:50:55,483 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
3060 2025-07-27 7295.00
3061 2025-07-28 7295.00
3062 2025-07-29 7278.33
3063 2025-07-30 7278.33
3064 2025-07-31 7278.33
2025-07-31 17:50:55,547 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
3065 2025-07-29 7278.33 ... 2025-07-31 17:50:55.540234 2025-07-31 17:50:55.540604
3066 2025-07-30 7278.33 ... 2025-07-31 17:50:55.540234 2025-07-31 17:50:55.540604
3067 2025-07-31 7278.33 ... 2025-07-31 17:50:55.540234 2025-07-31 17:50:55.540604
[3 rows x 5 columns]
2025-07-31 17:50:55,567 - 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-31 17:50:56,210 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3822 2025-07-27 15557.5
3823 2025-07-28 15557.5
3824 2025-07-29 15557.5
3825 2025-07-30 15557.5
3826 2025-07-31 15557.5
2025-07-31 17:50:56,282 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date value ... created_at updated_at
3824 2025-07-29 15557.5 ... 2025-07-31 17:50:56.275649 2025-07-31 17:50:56.276063
3825 2025-07-30 15557.5 ... 2025-07-31 17:50:56.275649 2025-07-31 17:50:56.276063
3826 2025-07-31 15557.5 ... 2025-07-31 17:50:56.275649 2025-07-31 17:50:56.276063
[3 rows x 5 columns]
2025-07-31 17:50:56,302 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-07-31 17:50:56,307 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3822 2025-07-27 15557.5
3823 2025-07-28 15557.5
3824 2025-07-29 15557.5
3825 2025-07-30 15557.5
3826 2025-07-31 15557.5
2025-07-31 17:50:56,381 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date value ... created_at updated_at
3828 2025-07-29 15557.5 ... 2025-07-31 17:50:56.373997 2025-07-31 17:50:56.374376
3829 2025-07-30 15557.5 ... 2025-07-31 17:50:56.373997 2025-07-31 17:50:56.374376
3830 2025-07-31 15557.5 ... 2025-07-31 17:50:56.373997 2025-07-31 17:50:56.374376
[3 rows x 5 columns]
2025-07-31 17:50:56,400 - 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-31 17:50:57,034 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3767 2025-07-27 16818.75
3768 2025-07-28 16843.75
3769 2025-07-29 16850.00
3770 2025-07-30 16818.75
3771 2025-07-31 16743.75
2025-07-31 17:50:57,108 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date ... updated_at
3769 2025-07-29 ... 2025-07-31 17:50:57.102095
3770 2025-07-30 ... 2025-07-31 17:50:57.102095
3771 2025-07-31 ... 2025-07-31 17:50:57.102095
[3 rows x 5 columns]
2025-07-31 17:50:57,128 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-07-31 17:50:57,134 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3767 2025-07-27 16818.75
3768 2025-07-28 16843.75
3769 2025-07-29 16850.00
3770 2025-07-30 16818.75
3771 2025-07-31 16743.75
2025-07-31 17:50:57,209 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date ... updated_at
3772 2025-07-29 ... 2025-07-31 17:50:57.202408
3773 2025-07-30 ... 2025-07-31 17:50:57.202408
3774 2025-07-31 ... 2025-07-31 17:50:57.202408
[3 rows x 5 columns]
2025-07-31 17:50:57,230 - 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-31 17:50:57,888 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
3042 2025-07-27 3510.00
3043 2025-07-28 3493.33
3044 2025-07-29 3470.00
3045 2025-07-30 3570.00
3046 2025-07-31 3510.00
2025-07-31 17:50:58,029 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
3044 2025-07-29 3470.0 ... 2025-07-31 17:50:58.021489 2025-07-31 17:50:58.021911
3045 2025-07-30 3570.0 ... 2025-07-31 17:50:58.021489 2025-07-31 17:50:58.021911
3046 2025-07-31 3510.0 ... 2025-07-31 17:50:58.021489 2025-07-31 17:50:58.021911
[3 rows x 5 columns]
2025-07-31 17:50:58,049 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-07-31 17:50:58,055 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
3042 2025-07-27 3510.00
3043 2025-07-28 3493.33
3044 2025-07-29 3470.00
3045 2025-07-30 3570.00
3046 2025-07-31 3510.00
2025-07-31 17:50:58,122 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
3047 2025-07-29 3470.0 ... 2025-07-31 17:50:58.114558 2025-07-31 17:50:58.115023
3048 2025-07-30 3570.0 ... 2025-07-31 17:50:58.114558 2025-07-31 17:50:58.115023
3049 2025-07-31 3510.0 ... 2025-07-31 17:50:58.114558 2025-07-31 17:50:58.115023
[3 rows x 5 columns]
2025-07-31 17:50:58,142 - 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-31 17:50:58,732 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3322 2025-07-27 5275.0
3323 2025-07-28 5275.0
3324 2025-07-29 5300.0
3325 2025-07-30 5312.5
3326 2025-07-31 5312.5
2025-07-31 17:50:58,805 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3324 2025-07-29 5300.0 ... 2025-07-31 17:50:58.797704 2025-07-31 17:50:58.798128
3325 2025-07-30 5312.5 ... 2025-07-31 17:50:58.797704 2025-07-31 17:50:58.798128
3326 2025-07-31 5312.5 ... 2025-07-31 17:50:58.797704 2025-07-31 17:50:58.798128
[3 rows x 5 columns]
2025-07-31 17:50:58,825 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-07-31 17:50:58,831 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3322 2025-07-27 5275.0
3323 2025-07-28 5275.0
3324 2025-07-29 5300.0
3325 2025-07-30 5312.5
3326 2025-07-31 5312.5
2025-07-31 17:50:58,908 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3811 2025-07-29 5300.0 ... 2025-07-31 17:50:58.900582 2025-07-31 17:50:58.901027
3812 2025-07-30 5312.5 ... 2025-07-31 17:50:58.900582 2025-07-31 17:50:58.901027
3813 2025-07-31 5312.5 ... 2025-07-31 17:50:58.900582 2025-07-31 17:50:58.901027
[3 rows x 5 columns]
2025-07-31 17:50:58,927 - 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-31 17:50:59,516 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1386 2025-07-27 14370.0
1387 2025-07-28 14280.0
1388 2025-07-29 14250.0
1389 2025-07-30 14220.0
1390 2025-07-31 14180.0
2025-07-31 17:50:59,561 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1388 2025-07-29 14250.0 ... 2025-07-31 17:50:59.553535 2025-07-31 17:50:59.553960
1389 2025-07-30 14220.0 ... 2025-07-31 17:50:59.553535 2025-07-31 17:50:59.553960
1390 2025-07-31 14180.0 ... 2025-07-31 17:50:59.553535 2025-07-31 17:50:59.553960
[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-31 17:50:59,814 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-07-31 17:50:59.805928
117 2021-07-06 ... 2025-07-31 17:50:59.805928
121 2021-07-12 ... 2025-07-31 17:50:59.805928
122 2021-07-13 ... 2025-07-31 17:50:59.805928
194 2021-11-01 ... 2025-07-31 17:50:59.805928
[5 rows x 6 columns]
2025-07-31 17:50:59,854 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1386 2025-07-27 14370.0
1387 2025-07-28 14280.0
1388 2025-07-29 14250.0
1389 2025-07-30 14220.0
1390 2025-07-31 14180.0
2025-07-31 17:50:59,899 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1391 2025-07-29 14250.0 ... 2025-07-31 17:50:59.891479 2025-07-31 17:50:59.891894
1392 2025-07-30 14220.0 ... 2025-07-31 17:50:59.891479 2025-07-31 17:50:59.891894
1393 2025-07-31 14180.0 ... 2025-07-31 17:50:59.891479 2025-07-31 17:50:59.891894
[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-31 17:51:00,145 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-07-31 17:51:00.137245
117 2021-07-06 ... 2025-07-31 17:51:00.137245
121 2021-07-12 ... 2025-07-31 17:51:00.137245
122 2021-07-13 ... 2025-07-31 17:51:00.137245
194 2021-11-01 ... 2025-07-31 17:51:00.137245
[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-31 17:51:01,095 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3818 2025-07-27 79538.33
3819 2025-07-28 79148.33
3820 2025-07-29 79043.33
3821 2025-07-30 79323.33
3822 2025-07-31 78590.00
2025-07-31 17:51:01,170 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date ... updated_at
3820 2025-07-29 ... 2025-07-31 17:51:01.164286
3821 2025-07-30 ... 2025-07-31 17:51:01.164286
3822 2025-07-31 ... 2025-07-31 17:51:01.164286
[3 rows x 5 columns]
2025-07-31 17:51:01,190 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-07-31 17:51:01,197 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3818 2025-07-27 79538.33
3819 2025-07-28 79148.33
3820 2025-07-29 79043.33
3821 2025-07-30 79323.33
3822 2025-07-31 78590.00
2025-07-31 17:51:01,271 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date ... updated_at
3823 2025-07-29 ... 2025-07-31 17:51:01.264704
3824 2025-07-30 ... 2025-07-31 17:51:01.264704
3825 2025-07-31 ... 2025-07-31 17:51:01.264704
[3 rows x 5 columns]
2025-07-31 17:51:01,291 - 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-31 17:51:01,843 - 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-31 17:51:01,903 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-07-31 17:51:01,903 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-07-31 17:51:01,910 - 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-31 17:51:01,975 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-07-31 17:51:01,975 - 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-31 17:51:02,681 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2796 2025-07-27 271437.5
2797 2025-07-28 268850.0
2798 2025-07-29 266250.0
2799 2025-07-30 268062.5
2800 2025-07-31 265575.0
2025-07-31 17:51:02,743 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2798 2025-07-29 ... 2025-07-31 17:51:02.736881
2799 2025-07-30 ... 2025-07-31 17:51:02.736881
2800 2025-07-31 ... 2025-07-31 17:51:02.736881
[3 rows x 5 columns]
2025-07-31 17:51:02,763 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-07-31 17:51:02,769 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2796 2025-07-27 271437.5
2797 2025-07-28 268850.0
2798 2025-07-29 266250.0
2799 2025-07-30 268062.5
2800 2025-07-31 265575.0
2025-07-31 17:51:02,831 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2801 2025-07-29 ... 2025-07-31 17:51:02.824662
2802 2025-07-30 ... 2025-07-31 17:51:02.824662
2803 2025-07-31 ... 2025-07-31 17:51:02.824662
[3 rows x 5 columns]
2025-07-31 17:51:02,852 - 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-31 17:51:03,488 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3817 2025-07-27 22756.0
3818 2025-07-28 22628.0
3819 2025-07-29 22562.0
3820 2025-07-30 22676.0
3821 2025-07-31 22296.0
2025-07-31 17:51:03,565 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3819 2025-07-29 22562.0 ... 2025-07-31 17:51:03.557536 2025-07-31 17:51:03.557971
3820 2025-07-30 22676.0 ... 2025-07-31 17:51:03.557536 2025-07-31 17:51:03.557971
3821 2025-07-31 22296.0 ... 2025-07-31 17:51:03.557536 2025-07-31 17:51:03.557971
[3 rows x 5 columns]
2025-07-31 17:51:03,585 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-07-31 17:51:03,591 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3817 2025-07-27 22756.0
3818 2025-07-28 22628.0
3819 2025-07-29 22562.0
3820 2025-07-30 22676.0
3821 2025-07-31 22296.0
2025-07-31 17:51:03,670 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3822 2025-07-29 22562.0 ... 2025-07-31 17:51:03.662787 2025-07-31 17:51:03.663218
3823 2025-07-30 22676.0 ... 2025-07-31 17:51:03.662787 2025-07-31 17:51:03.663218
3824 2025-07-31 22296.0 ... 2025-07-31 17:51:03.662787 2025-07-31 17:51:03.663218
[3 rows x 5 columns]
2025-07-31 17:51:03,690 - 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-31 17:51:04,296 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3780 2025-07-27 3497.5
3781 2025-07-28 3497.5
3782 2025-07-29 3555.0
3783 2025-07-30 3590.0
3784 2025-07-31 3537.5
2025-07-31 17:51:04,372 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3782 2025-07-29 3555.0 ... 2025-07-31 17:51:04.364814 2025-07-31 17:51:04.365237
3783 2025-07-30 3590.0 ... 2025-07-31 17:51:04.364814 2025-07-31 17:51:04.365237
3784 2025-07-31 3537.5 ... 2025-07-31 17:51:04.364814 2025-07-31 17:51:04.365237
[3 rows x 5 columns]
2025-07-31 17:51:04,391 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-07-31 17:51:04,398 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3780 2025-07-27 3497.5
3781 2025-07-28 3497.5
3782 2025-07-29 3555.0
3783 2025-07-30 3590.0
3784 2025-07-31 3537.5
2025-07-31 17:51:04,474 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3785 2025-07-29 3555.0 ... 2025-07-31 17:51:04.466536 2025-07-31 17:51:04.466989
3786 2025-07-30 3590.0 ... 2025-07-31 17:51:04.466536 2025-07-31 17:51:04.466989
3787 2025-07-31 3537.5 ... 2025-07-31 17:51:04.466536 2025-07-31 17:51:04.466989
[3 rows x 5 columns]
2025-07-31 17:51:04,494 - 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-31 17:51:05,068 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1577 2025-07-27 4762.5
1578 2025-07-28 4750.0
1579 2025-07-29 4737.5
1580 2025-07-30 4737.5
1581 2025-07-31 4762.5
2025-07-31 17:51:05,114 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1579 2025-07-29 4737.5 ... 2025-07-31 17:51:05.106957 2025-07-31 17:51:05.107348
1580 2025-07-30 4737.5 ... 2025-07-31 17:51:05.106957 2025-07-31 17:51:05.107348
1581 2025-07-31 4762.5 ... 2025-07-31 17:51:05.106957 2025-07-31 17:51:05.107348
[3 rows x 5 columns]
2025-07-31 17:51:05,134 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-07-31 17:51:05,140 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1577 2025-07-27 4762.5
1578 2025-07-28 4750.0
1579 2025-07-29 4737.5
1580 2025-07-30 4737.5
1581 2025-07-31 4762.5
2025-07-31 17:51:05,187 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1582 2025-07-29 4737.5 ... 2025-07-31 17:51:05.179741 2025-07-31 17:51:05.180176
1583 2025-07-30 4737.5 ... 2025-07-31 17:51:05.179741 2025-07-31 17:51:05.180176
1584 2025-07-31 4762.5 ... 2025-07-31 17:51:05.179741 2025-07-31 17:51:05.180176
[3 rows x 5 columns]
2025-07-31 17:51:05,207 - 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-31 17:51:05,875 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2851 2025-07-27 2332.86
2852 2025-07-28 2332.86
2853 2025-07-29 2332.86
2854 2025-07-30 2332.86
2855 2025-07-31 2332.86
2025-07-31 17:51:05,936 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2853 2025-07-29 2332.86 ... 2025-07-31 17:51:05.929030 2025-07-31 17:51:05.929410
2854 2025-07-30 2332.86 ... 2025-07-31 17:51:05.929030 2025-07-31 17:51:05.929410
2855 2025-07-31 2332.86 ... 2025-07-31 17:51:05.929030 2025-07-31 17:51:05.929410
[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-31 17:51:05,979 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2852 2025-07-28 ... 2025-07-31 17:51:05.972337
[1 rows x 6 columns]
2025-07-31 17:51:06,004 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2851 2025-07-27 2332.86
2852 2025-07-28 2332.86
2853 2025-07-29 2332.86
2854 2025-07-30 2332.86
2855 2025-07-31 2332.86
2025-07-31 17:51:06,066 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2856 2025-07-29 2332.86 ... 2025-07-31 17:51:06.059046 2025-07-31 17:51:06.059462
2857 2025-07-30 2332.86 ... 2025-07-31 17:51:06.059046 2025-07-31 17:51:06.059462
2858 2025-07-31 2332.86 ... 2025-07-31 17:51:06.059046 2025-07-31 17:51:06.059462
[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-31 17:51:06,108 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2855 2025-07-28 ... 2025-07-31 17:51:06.101515
[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-31 17:51:06,717 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2851 2025-07-27 2332.86
2852 2025-07-28 2332.86
2853 2025-07-29 2332.86
2854 2025-07-30 2332.86
2855 2025-07-31 2934.00
2025-07-31 17:51:06,771 - 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-31 17:51:06,793 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2855 2025-07-31 ... 2025-07-31 17:51:06.786537
[1 rows x 6 columns]
2025-07-31 17:51:06,818 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2851 2025-07-27 2332.86
2852 2025-07-28 2332.86
2853 2025-07-29 2332.86
2854 2025-07-30 2332.86
2855 2025-07-31 2934.00
2025-07-31 17:51:06,872 - 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-31 17:51:06,895 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2858 2025-07-31 ... 2025-07-31 17:51:06.888230
[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-31 17:51:07,408 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3208 2025-07-27 9561.67
3209 2025-07-28 9521.67
3210 2025-07-29 9600.00
3211 2025-07-30 9600.00
3212 2025-07-31 9621.67
2025-07-31 17:51:07,466 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-07-31 17:51:07,467 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-07-31 17:51:07,472 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3208 2025-07-27 9561.67
3209 2025-07-28 9521.67
3210 2025-07-29 9600.00
3211 2025-07-30 9600.00
3212 2025-07-31 9621.67
2025-07-31 17:51:07,532 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-07-31 17:51:07,532 - 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-31 17:51:08,111 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1892 2025-07-27 4463.33
1893 2025-07-28 4441.67
1894 2025-07-29 4441.67
1895 2025-07-30 4441.67
1896 2025-07-31 4436.67
2025-07-31 17:51:08,160 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1894 2025-07-29 4441.67 ... 2025-07-31 17:51:08.153059 2025-07-31 17:51:08.153437
1895 2025-07-30 4441.67 ... 2025-07-31 17:51:08.153059 2025-07-31 17:51:08.153437
1896 2025-07-31 4436.67 ... 2025-07-31 17:51:08.153059 2025-07-31 17:51:08.153437
[3 rows x 5 columns]
2025-07-31 17:51:08,181 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-07-31 17:51:08,187 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1892 2025-07-27 4463.33
1893 2025-07-28 4441.67
1894 2025-07-29 4441.67
1895 2025-07-30 4441.67
1896 2025-07-31 4436.67
2025-07-31 17:51:08,236 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1897 2025-07-29 4441.67 ... 2025-07-31 17:51:08.229433 2025-07-31 17:51:08.229837
1898 2025-07-30 4441.67 ... 2025-07-31 17:51:08.229433 2025-07-31 17:51:08.229837
1899 2025-07-31 4436.67 ... 2025-07-31 17:51:08.229433 2025-07-31 17:51:08.229837
[3 rows x 5 columns]
2025-07-31 17:51:08,257 - 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-31 17:51:08,886 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1901 2025-07-27 5966.67
1902 2025-07-28 5966.67
1903 2025-07-29 5950.00
1904 2025-07-30 5950.00
1905 2025-07-31 5900.00
2025-07-31 17:51:08,940 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1903 2025-07-29 5950.0 ... 2025-07-31 17:51:08.933054 2025-07-31 17:51:08.933443
1904 2025-07-30 5950.0 ... 2025-07-31 17:51:08.933054 2025-07-31 17:51:08.933443
1905 2025-07-31 5900.0 ... 2025-07-31 17:51:08.933054 2025-07-31 17:51:08.933443
[3 rows x 5 columns]
2025-07-31 17:51:08,960 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-07-31 17:51:08,966 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1901 2025-07-27 5966.67
1902 2025-07-28 5966.67
1903 2025-07-29 5950.00
1904 2025-07-30 5950.00
1905 2025-07-31 5900.00
2025-07-31 17:51:09,016 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1906 2025-07-29 5950.0 ... 2025-07-31 17:51:09.009381 2025-07-31 17:51:09.009787
1907 2025-07-30 5950.0 ... 2025-07-31 17:51:09.009381 2025-07-31 17:51:09.009787
1908 2025-07-31 5900.0 ... 2025-07-31 17:51:09.009381 2025-07-31 17:51:09.009787
[3 rows x 5 columns]
2025-07-31 17:51:09,036 - 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-31 17:51:09,614 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3569 2025-07-27 9016.0
3570 2025-07-28 8996.0
3571 2025-07-29 9032.0
3572 2025-07-30 9044.0
3573 2025-07-31 9012.0
2025-07-31 17:51:09,685 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3571 2025-07-29 9032.0 ... 2025-07-31 17:51:09.677919 2025-07-31 17:51:09.678318
3572 2025-07-30 9044.0 ... 2025-07-31 17:51:09.677919 2025-07-31 17:51:09.678318
3573 2025-07-31 9012.0 ... 2025-07-31 17:51:09.677919 2025-07-31 17:51:09.678318
[3 rows x 5 columns]
2025-07-31 17:51:09,704 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-07-31 17:51:09,710 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3569 2025-07-27 9016.0
3570 2025-07-28 8996.0
3571 2025-07-29 9032.0
3572 2025-07-30 9044.0
3573 2025-07-31 9012.0
2025-07-31 17:51:09,784 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3574 2025-07-29 9032.0 ... 2025-07-31 17:51:09.776470 2025-07-31 17:51:09.776901
3575 2025-07-30 9044.0 ... 2025-07-31 17:51:09.776470 2025-07-31 17:51:09.776901
3576 2025-07-31 9012.0 ... 2025-07-31 17:51:09.776470 2025-07-31 17:51:09.776901
[3 rows x 5 columns]
2025-07-31 17:51:09,803 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data