=========================================================================
2025-05-05 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-05-05 17:50:29,237 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3290 2025-05-01 3183.22
3291 2025-05-02 3183.22
3292 2025-05-03 3183.22
3293 2025-05-04 3183.22
3294 2025-05-05 3183.22
2025-05-05 17:50:29,306 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3292 2025-05-03 3183.22 ... 2025-05-05 17:50:29.298634 2025-05-05 17:50:29.299045
3293 2025-05-04 3183.22 ... 2025-05-05 17:50:29.298634 2025-05-05 17:50:29.299045
3294 2025-05-05 3183.22 ... 2025-05-05 17:50:29.298634 2025-05-05 17:50:29.299045
[3 rows x 5 columns]
2025-05-05 17:50:29,325 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-05-05 17:50:29,331 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3290 2025-05-01 3183.22
3291 2025-05-02 3183.22
3292 2025-05-03 3183.22
3293 2025-05-04 3183.22
3294 2025-05-05 3183.22
2025-05-05 17:50:29,409 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3295 2025-05-03 3183.22 ... 2025-05-05 17:50:29.402001 2025-05-05 17:50:29.402411
3296 2025-05-04 3183.22 ... 2025-05-05 17:50:29.402001 2025-05-05 17:50:29.402411
3297 2025-05-05 3183.22 ... 2025-05-05 17:50:29.402001 2025-05-05 17:50:29.402411
[3 rows x 5 columns]
2025-05-05 17:50:29,430 - 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-05-05 17:50:30,145 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3511 2025-05-01 2440.0
3512 2025-05-02 2440.0
3513 2025-05-03 2440.0
3514 2025-05-04 2440.0
3515 2025-05-05 2440.0
2025-05-05 17:50:30,214 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3513 2025-05-03 2440.0 ... 2025-05-05 17:50:30.206645 2025-05-05 17:50:30.207064
3514 2025-05-04 2440.0 ... 2025-05-05 17:50:30.206645 2025-05-05 17:50:30.207064
3515 2025-05-05 2440.0 ... 2025-05-05 17:50:30.206645 2025-05-05 17:50:30.207064
[3 rows x 5 columns]
2025-05-05 17:50:30,234 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-05-05 17:50:30,240 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3511 2025-05-01 2440.0
3512 2025-05-02 2440.0
3513 2025-05-03 2440.0
3514 2025-05-04 2440.0
3515 2025-05-05 2440.0
2025-05-05 17:50:30,310 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3517 2025-05-03 2440.0 ... 2025-05-05 17:50:30.301949 2025-05-05 17:50:30.302573
3518 2025-05-04 2440.0 ... 2025-05-05 17:50:30.301949 2025-05-05 17:50:30.302573
3519 2025-05-05 2440.0 ... 2025-05-05 17:50:30.301949 2025-05-05 17:50:30.302573
[3 rows x 5 columns]
2025-05-05 17:50:30,329 - 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-05-05 17:50:30,890 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
851 2025-05-01 4584.38
852 2025-05-02 4584.38
853 2025-05-03 4584.38
854 2025-05-04 4584.38
855 2025-05-05 4582.50
2025-05-05 17:50:30,929 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
853 2025-05-03 4584.38 ... 2025-05-05 17:50:30.920696 2025-05-05 17:50:30.921079
854 2025-05-04 4584.38 ... 2025-05-05 17:50:30.920696 2025-05-05 17:50:30.921079
855 2025-05-05 4582.50 ... 2025-05-05 17:50:30.920696 2025-05-05 17:50:30.921079
[3 rows x 5 columns]
2025-05-05 17:50:30,947 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-05-05 17:50:30,952 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
851 2025-05-01 4584.38
852 2025-05-02 4584.38
853 2025-05-03 4584.38
854 2025-05-04 4584.38
855 2025-05-05 4582.50
2025-05-05 17:50:30,987 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
853 2025-05-03 4584.38 ... 2025-05-05 17:50:30.980485 2025-05-05 17:50:30.980860
854 2025-05-04 4584.38 ... 2025-05-05 17:50:30.980485 2025-05-05 17:50:30.980860
855 2025-05-05 4582.50 ... 2025-05-05 17:50:30.980485 2025-05-05 17:50:30.980860
[3 rows x 5 columns]
2025-05-05 17:50:31,006 - 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-05-05 17:50:31,672 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3730 2025-05-01 14308.33
3731 2025-05-02 14308.33
3732 2025-05-03 14308.33
3733 2025-05-04 14308.33
3734 2025-05-05 14308.33
2025-05-05 17:50:31,742 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3732 2025-05-03 ... 2025-05-05 17:50:31.736442
3733 2025-05-04 ... 2025-05-05 17:50:31.736442
3734 2025-05-05 ... 2025-05-05 17:50:31.736442
[3 rows x 5 columns]
2025-05-05 17:50:31,762 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-05-05 17:50:31,768 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3730 2025-05-01 14308.33
3731 2025-05-02 14308.33
3732 2025-05-03 14308.33
3733 2025-05-04 14308.33
3734 2025-05-05 14308.33
2025-05-05 17:50:31,839 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3735 2025-05-03 ... 2025-05-05 17:50:31.832904
3736 2025-05-04 ... 2025-05-05 17:50:31.832904
3737 2025-05-05 ... 2025-05-05 17:50:31.832904
[3 rows x 5 columns]
2025-05-05 17:50:31,857 - 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-05-05 17:50:32,384 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3062 2025-05-01 778.11
3063 2025-05-02 778.11
3064 2025-05-03 778.11
3065 2025-05-04 778.11
3066 2025-05-05 778.11
2025-05-05 17:50:32,447 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3064 2025-05-03 778.11 ... 2025-05-05 17:50:32.440393 2025-05-05 17:50:32.440782
3065 2025-05-04 778.11 ... 2025-05-05 17:50:32.440393 2025-05-05 17:50:32.440782
3066 2025-05-05 778.11 ... 2025-05-05 17:50:32.440393 2025-05-05 17:50:32.440782
[3 rows x 5 columns]
2025-05-05 17:50:32,466 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-05-05 17:50:32,472 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3062 2025-05-01 778.11
3063 2025-05-02 778.11
3064 2025-05-03 778.11
3065 2025-05-04 778.11
3066 2025-05-05 778.11
2025-05-05 17:50:32,535 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3067 2025-05-03 778.11 ... 2025-05-05 17:50:32.528060 2025-05-05 17:50:32.528469
3068 2025-05-04 778.11 ... 2025-05-05 17:50:32.528060 2025-05-05 17:50:32.528469
3069 2025-05-05 778.11 ... 2025-05-05 17:50:32.528060 2025-05-05 17:50:32.528469
[3 rows x 5 columns]
2025-05-05 17:50:32,554 - 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-05-05 17:50:33,104 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3265 2025-05-01 1246.4
3266 2025-05-02 1246.4
3267 2025-05-03 1246.4
3268 2025-05-04 1246.4
3269 2025-05-05 1246.4
2025-05-05 17:50:33,170 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3267 2025-05-03 1246.4 ... 2025-05-05 17:50:33.162745 2025-05-05 17:50:33.163128
3268 2025-05-04 1246.4 ... 2025-05-05 17:50:33.162745 2025-05-05 17:50:33.163128
3269 2025-05-05 1246.4 ... 2025-05-05 17:50:33.162745 2025-05-05 17:50:33.163128
[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-05-05 17:50:35,106 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-05-05 17:50:35.097579
21 2013-01-04 ... 2025-05-05 17:50:35.097579
54 2013-02-27 ... 2025-05-05 17:50:35.097579
60 2013-03-07 ... 2025-05-05 17:50:35.097579
61 2013-03-08 ... 2025-05-05 17:50:35.097579
[5 rows x 6 columns]
2025-05-05 17:50:35,261 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3265 2025-05-01 1246.4
3266 2025-05-02 1246.4
3267 2025-05-03 1246.4
3268 2025-05-04 1246.4
3269 2025-05-05 1246.4
2025-05-05 17:50:35,329 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3271 2025-05-03 1246.4 ... 2025-05-05 17:50:35.321527 2025-05-05 17:50:35.321915
3272 2025-05-04 1246.4 ... 2025-05-05 17:50:35.321527 2025-05-05 17:50:35.321915
3273 2025-05-05 1246.4 ... 2025-05-05 17:50:35.321527 2025-05-05 17:50:35.321915
[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-05-05 17:50:37,253 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-05-05 17:50:37.245099
21 2013-01-04 ... 2025-05-05 17:50:37.245099
54 2013-02-27 ... 2025-05-05 17:50:37.245099
60 2013-03-07 ... 2025-05-05 17:50:37.245099
61 2013-03-08 ... 2025-05-05 17:50:37.245099
[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-05-05 17:50:38,186 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1610 2025-05-01 7680.0
1611 2025-05-02 7680.0
1612 2025-05-03 7680.0
1613 2025-05-04 7680.0
1614 2025-05-05 7680.0
2025-05-05 17:50:38,232 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1612 2025-05-03 7680.0 ... 2025-05-05 17:50:38.224745 2025-05-05 17:50:38.225137
1613 2025-05-04 7680.0 ... 2025-05-05 17:50:38.224745 2025-05-05 17:50:38.225137
1614 2025-05-05 7680.0 ... 2025-05-05 17:50:38.224745 2025-05-05 17:50:38.225137
[3 rows x 5 columns]
2025-05-05 17:50:38,252 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-05-05 17:50:38,258 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1610 2025-05-01 7680.0
1611 2025-05-02 7680.0
1612 2025-05-03 7680.0
1613 2025-05-04 7680.0
1614 2025-05-05 7680.0
2025-05-05 17:50:38,305 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1615 2025-05-03 7680.0 ... 2025-05-05 17:50:38.298336 2025-05-05 17:50:38.298736
1616 2025-05-04 7680.0 ... 2025-05-05 17:50:38.298336 2025-05-05 17:50:38.298736
1617 2025-05-05 7680.0 ... 2025-05-05 17:50:38.298336 2025-05-05 17:50:38.298736
[3 rows x 5 columns]
2025-05-05 17:50:38,324 - 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-05-05 17:50:38,902 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3721 2025-05-01 6160.0
3722 2025-05-02 6160.0
3723 2025-05-03 6160.0
3724 2025-05-04 6160.0
3725 2025-05-05 6160.0
2025-05-05 17:50:38,978 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3723 2025-05-03 6160.0 ... 2025-05-05 17:50:38.970112 2025-05-05 17:50:38.970610
3724 2025-05-04 6160.0 ... 2025-05-05 17:50:38.970112 2025-05-05 17:50:38.970610
3725 2025-05-05 6160.0 ... 2025-05-05 17:50:38.970112 2025-05-05 17:50:38.970610
[3 rows x 5 columns]
2025-05-05 17:50:38,998 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-05-05 17:50:39,004 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3721 2025-05-01 6160.0
3722 2025-05-02 6160.0
3723 2025-05-03 6160.0
3724 2025-05-04 6160.0
3725 2025-05-05 6160.0
2025-05-05 17:50:39,079 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3727 2025-05-03 6160.0 ... 2025-05-05 17:50:39.071486 2025-05-05 17:50:39.071894
3728 2025-05-04 6160.0 ... 2025-05-05 17:50:39.071486 2025-05-05 17:50:39.071894
3729 2025-05-05 6160.0 ... 2025-05-05 17:50:39.071486 2025-05-05 17:50:39.071894
[3 rows x 5 columns]
2025-05-05 17:50:39,098 - 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-05-05 17:50:40,508 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1611 2025-05-01 13050.0
1612 2025-05-02 13050.0
1613 2025-05-03 13050.0
1614 2025-05-04 13050.0
1615 2025-05-05 13050.0
2025-05-05 17:50:40,554 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1613 2025-05-03 13050.0 ... 2025-05-05 17:50:40.546949 2025-05-05 17:50:40.547368
1614 2025-05-04 13050.0 ... 2025-05-05 17:50:40.546949 2025-05-05 17:50:40.547368
1615 2025-05-05 13050.0 ... 2025-05-05 17:50:40.546949 2025-05-05 17:50:40.547368
[3 rows x 5 columns]
2025-05-05 17:50:40,573 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-05-05 17:50:40,578 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1611 2025-05-01 13050.0
1612 2025-05-02 13050.0
1613 2025-05-03 13050.0
1614 2025-05-04 13050.0
1615 2025-05-05 13050.0
2025-05-05 17:50:40,625 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1616 2025-05-03 13050.0 ... 2025-05-05 17:50:40.618127 2025-05-05 17:50:40.618543
1617 2025-05-04 13050.0 ... 2025-05-05 17:50:40.618127 2025-05-05 17:50:40.618543
1618 2025-05-05 13050.0 ... 2025-05-05 17:50:40.618127 2025-05-05 17:50:40.618543
[3 rows x 5 columns]
2025-05-05 17:50:40,645 - 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-05-05 17:50:41,847 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3121 2025-05-01 9378.33
3122 2025-05-02 9378.33
3123 2025-05-03 9378.33
3124 2025-05-04 9378.33
3125 2025-05-05 9378.33
2025-05-05 17:50:41,913 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date value ... created_at updated_at
3123 2025-05-03 9378.33 ... 2025-05-05 17:50:41.905392 2025-05-05 17:50:41.905785
3124 2025-05-04 9378.33 ... 2025-05-05 17:50:41.905392 2025-05-05 17:50:41.905785
3125 2025-05-05 9378.33 ... 2025-05-05 17:50:41.905392 2025-05-05 17:50:41.905785
[3 rows x 5 columns]
2025-05-05 17:50:41,932 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-05-05 17:50:41,938 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3121 2025-05-01 9378.33
3122 2025-05-02 9378.33
3123 2025-05-03 9378.33
3124 2025-05-04 9378.33
3125 2025-05-05 9378.33
2025-05-05 17:50:42,003 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date value ... created_at updated_at
3127 2025-05-03 9378.33 ... 2025-05-05 17:50:41.996294 2025-05-05 17:50:41.996692
3128 2025-05-04 9378.33 ... 2025-05-05 17:50:41.996294 2025-05-05 17:50:41.996692
3129 2025-05-05 9378.33 ... 2025-05-05 17:50:41.996294 2025-05-05 17:50:41.996692
[3 rows x 5 columns]
2025-05-05 17:50:42,022 - 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-05-05 17:50:42,640 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3244 2025-05-01 2531.67
3245 2025-05-02 2531.67
3246 2025-05-03 2531.67
3247 2025-05-04 2531.67
3248 2025-05-05 2531.67
2025-05-05 17:50:42,707 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3246 2025-05-03 2531.67 ... 2025-05-05 17:50:42.699999 2025-05-05 17:50:42.700417
3247 2025-05-04 2531.67 ... 2025-05-05 17:50:42.699999 2025-05-05 17:50:42.700417
3248 2025-05-05 2531.67 ... 2025-05-05 17:50:42.699999 2025-05-05 17:50:42.700417
[3 rows x 5 columns]
2025-05-05 17:50:42,727 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-05-05 17:50:42,733 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3244 2025-05-01 2531.67
3245 2025-05-02 2531.67
3246 2025-05-03 2531.67
3247 2025-05-04 2531.67
3248 2025-05-05 2531.67
2025-05-05 17:50:42,799 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3250 2025-05-03 2531.67 ... 2025-05-05 17:50:42.791998 2025-05-05 17:50:42.792412
3251 2025-05-04 2531.67 ... 2025-05-05 17:50:42.791998 2025-05-05 17:50:42.792412
3252 2025-05-05 2531.67 ... 2025-05-05 17:50:42.791998 2025-05-05 17:50:42.792412
[3 rows x 5 columns]
2025-05-05 17:50:42,819 - 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-05-05 17:50:43,546 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1448 2025-05-01 1502.5
1449 2025-05-02 1502.5
1450 2025-05-03 1502.5
1451 2025-05-04 1502.5
1452 2025-05-05 1502.5
2025-05-05 17:50:43,590 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1450 2025-05-03 1502.5 ... 2025-05-05 17:50:43.582714 2025-05-05 17:50:43.583104
1451 2025-05-04 1502.5 ... 2025-05-05 17:50:43.582714 2025-05-05 17:50:43.583104
1452 2025-05-05 1502.5 ... 2025-05-05 17:50:43.582714 2025-05-05 17:50:43.583104
[3 rows x 5 columns]
2025-05-05 17:50:43,611 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-05-05 17:50:43,616 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1448 2025-05-01 1502.5
1449 2025-05-02 1502.5
1450 2025-05-03 1502.5
1451 2025-05-04 1502.5
1452 2025-05-05 1502.5
2025-05-05 17:50:43,660 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1454 2025-05-03 1502.5 ... 2025-05-05 17:50:43.653304 2025-05-05 17:50:43.653705
1455 2025-05-04 1502.5 ... 2025-05-05 17:50:43.653304 2025-05-05 17:50:43.653705
1456 2025-05-05 1502.5 ... 2025-05-05 17:50:43.653304 2025-05-05 17:50:43.653705
[3 rows x 5 columns]
2025-05-05 17:50:43,679 - 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-05-05 17:50:44,268 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1361 2025-05-01 6351.46
1362 2025-05-02 6351.46
1363 2025-05-03 6351.46
1364 2025-05-04 6351.46
1365 2025-05-05 6351.67
2025-05-05 17:50:44,312 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1363 2025-05-03 6351.46 ... 2025-05-05 17:50:44.305004 2025-05-05 17:50:44.305419
1364 2025-05-04 6351.46 ... 2025-05-05 17:50:44.305004 2025-05-05 17:50:44.305419
1365 2025-05-05 6351.67 ... 2025-05-05 17:50:44.305004 2025-05-05 17:50:44.305419
[3 rows x 5 columns]
2025-05-05 17:50:44,331 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-05-05 17:50:44,337 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1361 2025-05-01 6351.46
1362 2025-05-02 6351.46
1363 2025-05-03 6351.46
1364 2025-05-04 6351.46
1365 2025-05-05 6351.67
2025-05-05 17:50:44,380 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1367 2025-05-03 6351.46 ... 2025-05-05 17:50:44.373241 2025-05-05 17:50:44.373638
1368 2025-05-04 6351.46 ... 2025-05-05 17:50:44.373241 2025-05-05 17:50:44.373638
1369 2025-05-05 6351.67 ... 2025-05-05 17:50:44.373241 2025-05-05 17:50:44.373638
[3 rows x 5 columns]
2025-05-05 17:50:44,399 - 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-05-05 17:50:46,636 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3734 2025-05-01 3476.67
3735 2025-05-02 3476.67
3736 2025-05-03 3476.67
3737 2025-05-04 3476.67
3738 2025-05-05 3476.67
2025-05-05 17:50:46,735 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3736 2025-05-03 3476.67 ... 2025-05-05 17:50:46.723416 2025-05-05 17:50:46.724024
3737 2025-05-04 3476.67 ... 2025-05-05 17:50:46.723416 2025-05-05 17:50:46.724024
3738 2025-05-05 3476.67 ... 2025-05-05 17:50:46.723416 2025-05-05 17:50:46.724024
[3 rows x 5 columns]
2025-05-05 17:50:46,756 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-05-05 17:50:46,762 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3734 2025-05-01 3476.67
3735 2025-05-02 3476.67
3736 2025-05-03 3476.67
3737 2025-05-04 3476.67
3738 2025-05-05 3476.67
2025-05-05 17:50:46,836 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3739 2025-05-03 3476.67 ... 2025-05-05 17:50:46.828334 2025-05-05 17:50:46.828752
3740 2025-05-04 3476.67 ... 2025-05-05 17:50:46.828334 2025-05-05 17:50:46.828752
3741 2025-05-05 3476.67 ... 2025-05-05 17:50:46.828334 2025-05-05 17:50:46.828752
[3 rows x 5 columns]
2025-05-05 17:50:46,854 - 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-05-05 17:50:47,439 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3504 2025-05-01 8126.0
3505 2025-05-02 8126.0
3506 2025-05-03 8126.0
3507 2025-05-04 8126.0
3508 2025-05-05 8126.0
2025-05-05 17:50:47,508 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3506 2025-05-03 8126.0 ... 2025-05-05 17:50:47.501348 2025-05-05 17:50:47.501743
3507 2025-05-04 8126.0 ... 2025-05-05 17:50:47.501348 2025-05-05 17:50:47.501743
3508 2025-05-05 8126.0 ... 2025-05-05 17:50:47.501348 2025-05-05 17:50:47.501743
[3 rows x 5 columns]
2025-05-05 17:50:47,528 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-05-05 17:50:47,535 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3504 2025-05-01 8126.0
3505 2025-05-02 8126.0
3506 2025-05-03 8126.0
3507 2025-05-04 8126.0
3508 2025-05-05 8126.0
2025-05-05 17:50:47,605 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3509 2025-05-03 8126.0 ... 2025-05-05 17:50:47.597765 2025-05-05 17:50:47.598149
3510 2025-05-04 8126.0 ... 2025-05-05 17:50:47.597765 2025-05-05 17:50:47.598149
3511 2025-05-05 8126.0 ... 2025-05-05 17:50:47.597765 2025-05-05 17:50:47.598149
[3 rows x 5 columns]
2025-05-05 17:50:47,624 - 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-05-05 17:50:48,171 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3470 2025-05-01 4245.0
3471 2025-05-02 4245.0
3472 2025-05-03 4245.0
3473 2025-05-04 4245.0
3474 2025-05-05 4245.0
2025-05-05 17:50:48,240 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3472 2025-05-03 4245.0 ... 2025-05-05 17:50:48.232621 2025-05-05 17:50:48.233012
3473 2025-05-04 4245.0 ... 2025-05-05 17:50:48.232621 2025-05-05 17:50:48.233012
3474 2025-05-05 4245.0 ... 2025-05-05 17:50:48.232621 2025-05-05 17:50:48.233012
[3 rows x 5 columns]
2025-05-05 17:50:48,259 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-05-05 17:50:48,265 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3470 2025-05-01 4245.0
3471 2025-05-02 4245.0
3472 2025-05-03 4245.0
3473 2025-05-04 4245.0
3474 2025-05-05 4245.0
2025-05-05 17:50:48,335 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3475 2025-05-03 4245.0 ... 2025-05-05 17:50:48.328106 2025-05-05 17:50:48.328518
3476 2025-05-04 4245.0 ... 2025-05-05 17:50:48.328106 2025-05-05 17:50:48.328518
3477 2025-05-05 4245.0 ... 2025-05-05 17:50:48.328106 2025-05-05 17:50:48.328518
[3 rows x 5 columns]
2025-05-05 17:50:48,354 - 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-05-05 17:50:48,928 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2847 2025-05-01 5548.57
2848 2025-05-02 5548.57
2849 2025-05-03 5548.57
2850 2025-05-04 5548.57
2851 2025-05-05 5548.57
2025-05-05 17:50:48,989 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2849 2025-05-03 5548.57 ... 2025-05-05 17:50:48.981865 2025-05-05 17:50:48.982269
2850 2025-05-04 5548.57 ... 2025-05-05 17:50:48.981865 2025-05-05 17:50:48.982269
2851 2025-05-05 5548.57 ... 2025-05-05 17:50:48.981865 2025-05-05 17:50:48.982269
[3 rows x 5 columns]
2025-05-05 17:50:49,008 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-05-05 17:50:49,013 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2847 2025-05-01 5548.57
2848 2025-05-02 5548.57
2849 2025-05-03 5548.57
2850 2025-05-04 5548.57
2851 2025-05-05 5548.57
2025-05-05 17:50:49,075 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2853 2025-05-03 5548.57 ... 2025-05-05 17:50:49.068313 2025-05-05 17:50:49.068704
2854 2025-05-04 5548.57 ... 2025-05-05 17:50:49.068313 2025-05-05 17:50:49.068704
2855 2025-05-05 5548.57 ... 2025-05-05 17:50:49.068313 2025-05-05 17:50:49.068704
[3 rows x 5 columns]
2025-05-05 17:50:49,102 - 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-05-05 17:50:49,626 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3047 2025-05-01 3375.0
3048 2025-05-02 3375.0
3049 2025-05-03 3375.0
3050 2025-05-04 3375.0
3051 2025-05-05 3375.0
2025-05-05 17:50:49,690 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3049 2025-05-03 3375.0 ... 2025-05-05 17:50:49.683115 2025-05-05 17:50:49.683532
3050 2025-05-04 3375.0 ... 2025-05-05 17:50:49.683115 2025-05-05 17:50:49.683532
3051 2025-05-05 3375.0 ... 2025-05-05 17:50:49.683115 2025-05-05 17:50:49.683532
[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-05-05 17:50:49,838 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-05-05 17:50:49.830080
458 2015-09-21 ... 2025-05-05 17:50:49.830080
549 2016-02-03 ... 2025-05-05 17:50:49.830080
693 2016-09-05 ... 2025-05-05 17:50:49.830080
696 2016-09-08 ... 2025-05-05 17:50:49.830080
[5 rows x 6 columns]
2025-05-05 17:50:49,867 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3047 2025-05-01 3375.0
3048 2025-05-02 3375.0
3049 2025-05-03 3375.0
3050 2025-05-04 3375.0
3051 2025-05-05 3375.0
2025-05-05 17:50:49,931 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3052 2025-05-03 3375.0 ... 2025-05-05 17:50:49.924386 2025-05-05 17:50:49.924777
3053 2025-05-04 3375.0 ... 2025-05-05 17:50:49.924386 2025-05-05 17:50:49.924777
3054 2025-05-05 3375.0 ... 2025-05-05 17:50:49.924386 2025-05-05 17:50:49.924777
[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-05-05 17:50:50,079 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-05-05 17:50:50.071362
458 2015-09-21 ... 2025-05-05 17:50:50.071362
549 2016-02-03 ... 2025-05-05 17:50:50.071362
693 2016-09-05 ... 2025-05-05 17:50:50.071362
696 2016-09-08 ... 2025-05-05 17:50:50.071362
[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-05-05 17:50:50,692 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
851 2025-05-01 9880.0
852 2025-05-02 9880.0
853 2025-05-03 9880.0
854 2025-05-04 9880.0
855 2025-05-05 9880.0
2025-05-05 17:50:50,729 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
853 2025-05-03 9880.0 ... 2025-05-05 17:50:50.721534 2025-05-05 17:50:50.721924
854 2025-05-04 9880.0 ... 2025-05-05 17:50:50.721534 2025-05-05 17:50:50.721924
855 2025-05-05 9880.0 ... 2025-05-05 17:50:50.721534 2025-05-05 17:50:50.721924
[3 rows x 5 columns]
2025-05-05 17:50:50,749 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-05-05 17:50:50,755 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
851 2025-05-01 9880.0
852 2025-05-02 9880.0
853 2025-05-03 9880.0
854 2025-05-04 9880.0
855 2025-05-05 9880.0
2025-05-05 17:50:50,792 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
853 2025-05-03 9880.0 ... 2025-05-05 17:50:50.784338 2025-05-05 17:50:50.784730
854 2025-05-04 9880.0 ... 2025-05-05 17:50:50.784338 2025-05-05 17:50:50.784730
855 2025-05-05 9880.0 ... 2025-05-05 17:50:50.784338 2025-05-05 17:50:50.784730
[3 rows x 5 columns]
2025-05-05 17:50:50,812 - 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-05-05 17:50:51,353 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3730 2025-05-01 7553.33
3731 2025-05-02 7553.33
3732 2025-05-03 7553.33
3733 2025-05-04 7553.33
3734 2025-05-05 7553.33
2025-05-05 17:50:51,424 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3732 2025-05-03 7553.33 ... 2025-05-05 17:50:51.417429 2025-05-05 17:50:51.417822
3733 2025-05-04 7553.33 ... 2025-05-05 17:50:51.417429 2025-05-05 17:50:51.417822
3734 2025-05-05 7553.33 ... 2025-05-05 17:50:51.417429 2025-05-05 17:50:51.417822
[3 rows x 5 columns]
2025-05-05 17:50:51,444 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-05-05 17:50:51,450 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3730 2025-05-01 7553.33
3731 2025-05-02 7553.33
3732 2025-05-03 7553.33
3733 2025-05-04 7553.33
3734 2025-05-05 7553.33
2025-05-05 17:50:51,523 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3735 2025-05-03 7553.33 ... 2025-05-05 17:50:51.515823 2025-05-05 17:50:51.516232
3736 2025-05-04 7553.33 ... 2025-05-05 17:50:51.515823 2025-05-05 17:50:51.516232
3737 2025-05-05 7553.33 ... 2025-05-05 17:50:51.515823 2025-05-05 17:50:51.516232
[3 rows x 5 columns]
2025-05-05 17:50:51,542 - 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-05-05 17:50:52,119 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3068 2025-05-01 3647.5
3069 2025-05-02 3647.5
3070 2025-05-03 3647.5
3071 2025-05-04 3647.5
3072 2025-05-05 3647.5
2025-05-05 17:50:52,184 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3071 2025-05-03 3647.5 ... 2025-05-05 17:50:52.176534 2025-05-05 17:50:52.176963
3072 2025-05-04 3647.5 ... 2025-05-05 17:50:52.176534 2025-05-05 17:50:52.176963
3073 2025-05-05 3647.5 ... 2025-05-05 17:50:52.176534 2025-05-05 17:50:52.176963
[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-05-05 17:50:52,220 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-05-05 17:50:52.212856
[1 rows x 6 columns]
2025-05-05 17:50:52,245 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3068 2025-05-01 3647.5
3069 2025-05-02 3647.5
3070 2025-05-03 3647.5
3071 2025-05-04 3647.5
3072 2025-05-05 3647.5
2025-05-05 17:50:52,309 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3073 2025-05-03 3647.5 ... 2025-05-05 17:50:52.302492 2025-05-05 17:50:52.302883
3074 2025-05-04 3647.5 ... 2025-05-05 17:50:52.302492 2025-05-05 17:50:52.302883
3075 2025-05-05 3647.5 ... 2025-05-05 17:50:52.302492 2025-05-05 17:50:52.302883
[3 rows x 5 columns]
2025-05-05 17:50:52,328 - 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-05-05 17:50:52,969 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3733 2025-05-01 20073.33
3734 2025-05-02 20073.33
3735 2025-05-03 20073.33
3736 2025-05-04 20073.33
3737 2025-05-05 20073.33
2025-05-05 17:50:53,041 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date ... updated_at
3735 2025-05-03 ... 2025-05-05 17:50:53.034019
3736 2025-05-04 ... 2025-05-05 17:50:53.034019
3737 2025-05-05 ... 2025-05-05 17:50:53.034019
[3 rows x 5 columns]
2025-05-05 17:50:53,060 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-05-05 17:50:53,066 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3733 2025-05-01 20073.33
3734 2025-05-02 20073.33
3735 2025-05-03 20073.33
3736 2025-05-04 20073.33
3737 2025-05-05 20073.33
2025-05-05 17:50:53,139 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date ... updated_at
3738 2025-05-03 ... 2025-05-05 17:50:53.133328
3739 2025-05-04 ... 2025-05-05 17:50:53.133328
3740 2025-05-05 ... 2025-05-05 17:50:53.133328
[3 rows x 5 columns]
2025-05-05 17:50:53,158 - 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-05-05 17:50:53,959 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2847 2025-05-01 5640.0
2848 2025-05-02 5640.0
2849 2025-05-03 5640.0
2850 2025-05-04 5640.0
2851 2025-05-05 5640.0
2025-05-05 17:50:54,023 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2849 2025-05-03 5640.0 ... 2025-05-05 17:50:54.015373 2025-05-05 17:50:54.015776
2850 2025-05-04 5640.0 ... 2025-05-05 17:50:54.015373 2025-05-05 17:50:54.015776
2851 2025-05-05 5640.0 ... 2025-05-05 17:50:54.015373 2025-05-05 17:50:54.015776
[3 rows x 5 columns]
2025-05-05 17:50:54,043 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-05-05 17:50:54,049 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2847 2025-05-01 5640.0
2848 2025-05-02 5640.0
2849 2025-05-03 5640.0
2850 2025-05-04 5640.0
2851 2025-05-05 5640.0
2025-05-05 17:50:54,112 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2853 2025-05-03 5640.0 ... 2025-05-05 17:50:54.104780 2025-05-05 17:50:54.105169
2854 2025-05-04 5640.0 ... 2025-05-05 17:50:54.104780 2025-05-05 17:50:54.105169
2855 2025-05-05 5640.0 ... 2025-05-05 17:50:54.104780 2025-05-05 17:50:54.105169
[3 rows x 5 columns]
2025-05-05 17:50:54,131 - 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-05-05 17:50:54,807 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2122 2025-05-01 23775.0
2123 2025-05-02 23775.0
2124 2025-05-03 23775.0
2125 2025-05-04 23775.0
2126 2025-05-05 23775.0
2025-05-05 17:50:54,859 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2124 2025-05-03 23775.0 ... 2025-05-05 17:50:54.851988 2025-05-05 17:50:54.852390
2125 2025-05-04 23775.0 ... 2025-05-05 17:50:54.851988 2025-05-05 17:50:54.852390
2126 2025-05-05 23775.0 ... 2025-05-05 17:50:54.851988 2025-05-05 17:50:54.852390
[3 rows x 5 columns]
2025-05-05 17:50:54,878 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-05-05 17:50:54,884 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2122 2025-05-01 23775.0
2123 2025-05-02 23775.0
2124 2025-05-03 23775.0
2125 2025-05-04 23775.0
2126 2025-05-05 23775.0
2025-05-05 17:50:54,937 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2128 2025-05-03 23775.0 ... 2025-05-05 17:50:54.929963 2025-05-05 17:50:54.930398
2129 2025-05-04 23775.0 ... 2025-05-05 17:50:54.929963 2025-05-05 17:50:54.930398
2130 2025-05-05 23775.0 ... 2025-05-05 17:50:54.929963 2025-05-05 17:50:54.930398
[3 rows x 5 columns]
2025-05-05 17:50:54,956 - 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-05-05 17:50:55,576 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1637 2025-05-01 1875.0
1638 2025-05-02 1875.0
1639 2025-05-03 1875.0
1640 2025-05-04 1875.0
1641 2025-05-05 1875.0
2025-05-05 17:50:55,622 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1639 2025-05-03 1875.0 ... 2025-05-05 17:50:55.615181 2025-05-05 17:50:55.615601
1640 2025-05-04 1875.0 ... 2025-05-05 17:50:55.615181 2025-05-05 17:50:55.615601
1641 2025-05-05 1875.0 ... 2025-05-05 17:50:55.615181 2025-05-05 17:50:55.615601
[3 rows x 5 columns]
2025-05-05 17:50:55,642 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-05-05 17:50:55,648 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1637 2025-05-01 1875.0
1638 2025-05-02 1875.0
1639 2025-05-03 1875.0
1640 2025-05-04 1875.0
1641 2025-05-05 1875.0
2025-05-05 17:50:55,694 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1643 2025-05-03 1875.0 ... 2025-05-05 17:50:55.687198 2025-05-05 17:50:55.687608
1644 2025-05-04 1875.0 ... 2025-05-05 17:50:55.687198 2025-05-05 17:50:55.687608
1645 2025-05-05 1875.0 ... 2025-05-05 17:50:55.687198 2025-05-05 17:50:55.687608
[3 rows x 5 columns]
2025-05-05 17:50:55,714 - 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-05-05 17:50:56,932 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2709 2025-05-01 125175.0
2710 2025-05-02 125175.0
2711 2025-05-03 125175.0
2712 2025-05-04 125175.0
2713 2025-05-05 125175.0
2025-05-05 17:50:56,991 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2711 2025-05-03 ... 2025-05-05 17:50:56.984714
2712 2025-05-04 ... 2025-05-05 17:50:56.984714
2713 2025-05-05 ... 2025-05-05 17:50:56.984714
[3 rows x 5 columns]
2025-05-05 17:50:57,011 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-05-05 17:50:57,016 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2709 2025-05-01 125175.0
2710 2025-05-02 125175.0
2711 2025-05-03 125175.0
2712 2025-05-04 125175.0
2713 2025-05-05 125175.0
2025-05-05 17:50:57,077 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2714 2025-05-03 ... 2025-05-05 17:50:57.070775
2715 2025-05-04 ... 2025-05-05 17:50:57.070775
2716 2025-05-05 ... 2025-05-05 17:50:57.070775
[3 rows x 5 columns]
2025-05-05 17:50:57,096 - 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-05-05 17:50:57,678 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3734 2025-05-01 4679.0
3735 2025-05-02 4679.0
3736 2025-05-03 4679.0
3737 2025-05-04 4679.0
3738 2025-05-05 4679.0
2025-05-05 17:50:57,752 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3736 2025-05-03 4679.0 ... 2025-05-05 17:50:57.744230 2025-05-05 17:50:57.744635
3737 2025-05-04 4679.0 ... 2025-05-05 17:50:57.744230 2025-05-05 17:50:57.744635
3738 2025-05-05 4679.0 ... 2025-05-05 17:50:57.744230 2025-05-05 17:50:57.744635
[3 rows x 5 columns]
2025-05-05 17:50:57,770 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-05-05 17:50:57,777 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3734 2025-05-01 4679.0
3735 2025-05-02 4679.0
3736 2025-05-03 4679.0
3737 2025-05-04 4679.0
3738 2025-05-05 4679.0
2025-05-05 17:50:57,851 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3739 2025-05-03 4679.0 ... 2025-05-05 17:50:57.843621 2025-05-05 17:50:57.844015
3740 2025-05-04 4679.0 ... 2025-05-05 17:50:57.843621 2025-05-05 17:50:57.844015
3741 2025-05-05 4679.0 ... 2025-05-05 17:50:57.843621 2025-05-05 17:50:57.844015
[3 rows x 5 columns]
2025-05-05 17:50:57,870 - 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-05-05 17:50:58,715 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
2973 2025-05-01 7481.67
2974 2025-05-02 7481.67
2975 2025-05-03 7481.67
2976 2025-05-04 7481.67
2977 2025-05-05 7481.67
2025-05-05 17:50:58,785 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
2975 2025-05-03 7481.67 ... 2025-05-05 17:50:58.778250 2025-05-05 17:50:58.778691
2976 2025-05-04 7481.67 ... 2025-05-05 17:50:58.778250 2025-05-05 17:50:58.778691
2977 2025-05-05 7481.67 ... 2025-05-05 17:50:58.778250 2025-05-05 17:50:58.778691
[3 rows x 5 columns]
2025-05-05 17:50:58,805 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-05-05 17:50:58,811 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
2973 2025-05-01 7481.67
2974 2025-05-02 7481.67
2975 2025-05-03 7481.67
2976 2025-05-04 7481.67
2977 2025-05-05 7481.67
2025-05-05 17:50:58,886 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
2978 2025-05-03 7481.67 ... 2025-05-05 17:50:58.878188 2025-05-05 17:50:58.878672
2979 2025-05-04 7481.67 ... 2025-05-05 17:50:58.878188 2025-05-05 17:50:58.878672
2980 2025-05-05 7481.67 ... 2025-05-05 17:50:58.878188 2025-05-05 17:50:58.878672
[3 rows x 5 columns]
2025-05-05 17:50:58,905 - 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-05-05 17:50:59,519 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3735 2025-05-01 14208.83
3736 2025-05-02 14208.83
3737 2025-05-03 14208.83
3738 2025-05-04 14208.83
3739 2025-05-05 14208.83
2025-05-05 17:50:59,591 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date ... updated_at
3737 2025-05-03 ... 2025-05-05 17:50:59.584601
3738 2025-05-04 ... 2025-05-05 17:50:59.584601
3739 2025-05-05 ... 2025-05-05 17:50:59.584601
[3 rows x 5 columns]
2025-05-05 17:50:59,611 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-05-05 17:50:59,617 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3735 2025-05-01 14208.83
3736 2025-05-02 14208.83
3737 2025-05-03 14208.83
3738 2025-05-04 14208.83
3739 2025-05-05 14208.83
2025-05-05 17:50:59,691 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date ... updated_at
3741 2025-05-03 ... 2025-05-05 17:50:59.684781
3742 2025-05-04 ... 2025-05-05 17:50:59.684781
3743 2025-05-05 ... 2025-05-05 17:50:59.684781
[3 rows x 5 columns]
2025-05-05 17:50:59,710 - 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-05-05 17:51:00,272 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3680 2025-05-01 16812.5
3681 2025-05-02 16812.5
3682 2025-05-03 16812.5
3683 2025-05-04 16812.5
3684 2025-05-05 16812.5
2025-05-05 17:51:00,345 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date value ... created_at updated_at
3682 2025-05-03 16812.5 ... 2025-05-05 17:51:00.337521 2025-05-05 17:51:00.337912
3683 2025-05-04 16812.5 ... 2025-05-05 17:51:00.337521 2025-05-05 17:51:00.337912
3684 2025-05-05 16812.5 ... 2025-05-05 17:51:00.337521 2025-05-05 17:51:00.337912
[3 rows x 5 columns]
2025-05-05 17:51:00,364 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-05-05 17:51:00,370 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3680 2025-05-01 16812.5
3681 2025-05-02 16812.5
3682 2025-05-03 16812.5
3683 2025-05-04 16812.5
3684 2025-05-05 16812.5
2025-05-05 17:51:00,520 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date value ... created_at updated_at
3685 2025-05-03 16812.5 ... 2025-05-05 17:51:00.512587 2025-05-05 17:51:00.512985
3686 2025-05-04 16812.5 ... 2025-05-05 17:51:00.512587 2025-05-05 17:51:00.512985
3687 2025-05-05 16812.5 ... 2025-05-05 17:51:00.512587 2025-05-05 17:51:00.512985
[3 rows x 5 columns]
2025-05-05 17:51:00,538 - 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-05-05 17:51:01,171 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
2955 2025-05-01 3276.67
2956 2025-05-02 3276.67
2957 2025-05-03 3276.67
2958 2025-05-04 3276.67
2959 2025-05-05 3276.67
2025-05-05 17:51:01,234 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
2957 2025-05-03 3276.67 ... 2025-05-05 17:51:01.226977 2025-05-05 17:51:01.227395
2958 2025-05-04 3276.67 ... 2025-05-05 17:51:01.226977 2025-05-05 17:51:01.227395
2959 2025-05-05 3276.67 ... 2025-05-05 17:51:01.226977 2025-05-05 17:51:01.227395
[3 rows x 5 columns]
2025-05-05 17:51:01,255 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-05-05 17:51:01,261 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
2955 2025-05-01 3276.67
2956 2025-05-02 3276.67
2957 2025-05-03 3276.67
2958 2025-05-04 3276.67
2959 2025-05-05 3276.67
2025-05-05 17:51:01,326 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
2960 2025-05-03 3276.67 ... 2025-05-05 17:51:01.318465 2025-05-05 17:51:01.318989
2961 2025-05-04 3276.67 ... 2025-05-05 17:51:01.318465 2025-05-05 17:51:01.318989
2962 2025-05-05 3276.67 ... 2025-05-05 17:51:01.318465 2025-05-05 17:51:01.318989
[3 rows x 5 columns]
2025-05-05 17:51:01,348 - 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-05-05 17:51:02,041 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3235 2025-05-01 5462.5
3236 2025-05-02 5462.5
3237 2025-05-03 5462.5
3238 2025-05-04 5462.5
3239 2025-05-05 5462.5
2025-05-05 17:51:02,108 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3237 2025-05-03 5462.5 ... 2025-05-05 17:51:02.100478 2025-05-05 17:51:02.100869
3238 2025-05-04 5462.5 ... 2025-05-05 17:51:02.100478 2025-05-05 17:51:02.100869
3239 2025-05-05 5462.5 ... 2025-05-05 17:51:02.100478 2025-05-05 17:51:02.100869
[3 rows x 5 columns]
2025-05-05 17:51:02,129 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-05-05 17:51:02,136 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3235 2025-05-01 5462.5
3236 2025-05-02 5462.5
3237 2025-05-03 5462.5
3238 2025-05-04 5462.5
3239 2025-05-05 5462.5
2025-05-05 17:51:02,210 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3724 2025-05-03 5462.5 ... 2025-05-05 17:51:02.202763 2025-05-05 17:51:02.203147
3725 2025-05-04 5462.5 ... 2025-05-05 17:51:02.202763 2025-05-05 17:51:02.203147
3726 2025-05-05 5462.5 ... 2025-05-05 17:51:02.202763 2025-05-05 17:51:02.203147
[3 rows x 5 columns]
2025-05-05 17:51:02,229 - 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-05-05 17:51:02,756 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1299 2025-05-01 14830.0
1300 2025-05-02 14830.0
1301 2025-05-03 14830.0
1302 2025-05-04 14830.0
1303 2025-05-05 14830.0
2025-05-05 17:51:02,798 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1301 2025-05-03 14830.0 ... 2025-05-05 17:51:02.790570 2025-05-05 17:51:02.790957
1302 2025-05-04 14830.0 ... 2025-05-05 17:51:02.790570 2025-05-05 17:51:02.790957
1303 2025-05-05 14830.0 ... 2025-05-05 17:51:02.790570 2025-05-05 17:51:02.790957
[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-05-05 17:51:03,039 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-05-05 17:51:03.031296
117 2021-07-06 ... 2025-05-05 17:51:03.031296
121 2021-07-12 ... 2025-05-05 17:51:03.031296
122 2021-07-13 ... 2025-05-05 17:51:03.031296
194 2021-11-01 ... 2025-05-05 17:51:03.031296
[5 rows x 6 columns]
2025-05-05 17:51:03,077 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1299 2025-05-01 14830.0
1300 2025-05-02 14830.0
1301 2025-05-03 14830.0
1302 2025-05-04 14830.0
1303 2025-05-05 14830.0
2025-05-05 17:51:03,120 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1304 2025-05-03 14830.0 ... 2025-05-05 17:51:03.112850 2025-05-05 17:51:03.113328
1305 2025-05-04 14830.0 ... 2025-05-05 17:51:03.112850 2025-05-05 17:51:03.113328
1306 2025-05-05 14830.0 ... 2025-05-05 17:51:03.112850 2025-05-05 17:51:03.113328
[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-05-05 17:51:03,361 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-05-05 17:51:03.353434
117 2021-07-06 ... 2025-05-05 17:51:03.353434
121 2021-07-12 ... 2025-05-05 17:51:03.353434
122 2021-07-13 ... 2025-05-05 17:51:03.353434
194 2021-11-01 ... 2025-05-05 17:51:03.353434
[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-05-05 17:51:06,944 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3731 2025-05-01 77996.67
3732 2025-05-02 77996.67
3733 2025-05-03 77996.67
3734 2025-05-04 77996.67
3735 2025-05-05 77996.67
2025-05-05 17:51:07,019 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date ... updated_at
3733 2025-05-03 ... 2025-05-05 17:51:07.012433
3734 2025-05-04 ... 2025-05-05 17:51:07.012433
3735 2025-05-05 ... 2025-05-05 17:51:07.012433
[3 rows x 5 columns]
2025-05-05 17:51:07,039 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-05-05 17:51:07,045 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3731 2025-05-01 77996.67
3732 2025-05-02 77996.67
3733 2025-05-03 77996.67
3734 2025-05-04 77996.67
3735 2025-05-05 77996.67
2025-05-05 17:51:07,129 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date ... updated_at
3736 2025-05-03 ... 2025-05-05 17:51:07.122747
3737 2025-05-04 ... 2025-05-05 17:51:07.122747
3738 2025-05-05 ... 2025-05-05 17:51:07.122747
[3 rows x 5 columns]
2025-05-05 17:51:07,148 - 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-05-05 17:51:07,695 - 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-05-05 17:51:07,751 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-05-05 17:51:07,752 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-05-05 17:51:07,758 - 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-05-05 17:51:07,823 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-05-05 17:51:07,823 - 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-05-05 17:51:08,471 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2709 2025-05-01 261175.0
2710 2025-05-02 261175.0
2711 2025-05-03 261175.0
2712 2025-05-04 261175.0
2713 2025-05-05 261175.0
2025-05-05 17:51:08,531 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2711 2025-05-03 ... 2025-05-05 17:51:08.524764
2712 2025-05-04 ... 2025-05-05 17:51:08.524764
2713 2025-05-05 ... 2025-05-05 17:51:08.524764
[3 rows x 5 columns]
2025-05-05 17:51:08,550 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-05-05 17:51:08,556 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2709 2025-05-01 261175.0
2710 2025-05-02 261175.0
2711 2025-05-03 261175.0
2712 2025-05-04 261175.0
2713 2025-05-05 261175.0
2025-05-05 17:51:08,616 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2714 2025-05-03 ... 2025-05-05 17:51:08.610122
2715 2025-05-04 ... 2025-05-05 17:51:08.610122
2716 2025-05-05 ... 2025-05-05 17:51:08.610122
[3 rows x 5 columns]
2025-05-05 17:51:08,636 - 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-05-05 17:51:09,256 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3730 2025-05-01 22904.0
3731 2025-05-02 22904.0
3732 2025-05-03 22904.0
3733 2025-05-04 22904.0
3734 2025-05-05 22904.0
2025-05-05 17:51:09,329 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3732 2025-05-03 22904.0 ... 2025-05-05 17:51:09.321636 2025-05-05 17:51:09.322019
3733 2025-05-04 22904.0 ... 2025-05-05 17:51:09.321636 2025-05-05 17:51:09.322019
3734 2025-05-05 22904.0 ... 2025-05-05 17:51:09.321636 2025-05-05 17:51:09.322019
[3 rows x 5 columns]
2025-05-05 17:51:09,348 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-05-05 17:51:09,354 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3730 2025-05-01 22904.0
3731 2025-05-02 22904.0
3732 2025-05-03 22904.0
3733 2025-05-04 22904.0
3734 2025-05-05 22904.0
2025-05-05 17:51:09,428 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3735 2025-05-03 22904.0 ... 2025-05-05 17:51:09.421361 2025-05-05 17:51:09.421757
3736 2025-05-04 22904.0 ... 2025-05-05 17:51:09.421361 2025-05-05 17:51:09.421757
3737 2025-05-05 22904.0 ... 2025-05-05 17:51:09.421361 2025-05-05 17:51:09.421757
[3 rows x 5 columns]
2025-05-05 17:51:09,448 - 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-05-05 17:51:10,342 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3693 2025-05-01 3377.5
3694 2025-05-02 3377.5
3695 2025-05-03 3377.5
3696 2025-05-04 3377.5
3697 2025-05-05 3377.5
2025-05-05 17:51:10,414 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3695 2025-05-03 3377.5 ... 2025-05-05 17:51:10.406970 2025-05-05 17:51:10.407402
3696 2025-05-04 3377.5 ... 2025-05-05 17:51:10.406970 2025-05-05 17:51:10.407402
3697 2025-05-05 3377.5 ... 2025-05-05 17:51:10.406970 2025-05-05 17:51:10.407402
[3 rows x 5 columns]
2025-05-05 17:51:10,434 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-05-05 17:51:10,440 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3693 2025-05-01 3377.5
3694 2025-05-02 3377.5
3695 2025-05-03 3377.5
3696 2025-05-04 3377.5
3697 2025-05-05 3377.5
2025-05-05 17:51:10,512 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3698 2025-05-03 3377.5 ... 2025-05-05 17:51:10.505062 2025-05-05 17:51:10.505548
3699 2025-05-04 3377.5 ... 2025-05-05 17:51:10.505062 2025-05-05 17:51:10.505548
3700 2025-05-05 3377.5 ... 2025-05-05 17:51:10.505062 2025-05-05 17:51:10.505548
[3 rows x 5 columns]
2025-05-05 17:51:10,534 - 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-05-05 17:51:11,208 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1490 2025-05-01 4980.0
1491 2025-05-02 4980.0
1492 2025-05-03 4980.0
1493 2025-05-04 4980.0
1494 2025-05-05 4980.0
2025-05-05 17:51:11,252 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1492 2025-05-03 4980.0 ... 2025-05-05 17:51:11.244928 2025-05-05 17:51:11.245332
1493 2025-05-04 4980.0 ... 2025-05-05 17:51:11.244928 2025-05-05 17:51:11.245332
1494 2025-05-05 4980.0 ... 2025-05-05 17:51:11.244928 2025-05-05 17:51:11.245332
[3 rows x 5 columns]
2025-05-05 17:51:11,271 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-05-05 17:51:11,276 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1490 2025-05-01 4980.0
1491 2025-05-02 4980.0
1492 2025-05-03 4980.0
1493 2025-05-04 4980.0
1494 2025-05-05 4980.0
2025-05-05 17:51:11,320 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1495 2025-05-03 4980.0 ... 2025-05-05 17:51:11.312782 2025-05-05 17:51:11.313160
1496 2025-05-04 4980.0 ... 2025-05-05 17:51:11.312782 2025-05-05 17:51:11.313160
1497 2025-05-05 4980.0 ... 2025-05-05 17:51:11.312782 2025-05-05 17:51:11.313160
[3 rows x 5 columns]
2025-05-05 17:51:11,339 - 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-05-05 17:51:11,962 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2764 2025-05-01 2252.86
2765 2025-05-02 2252.86
2766 2025-05-03 2252.86
2767 2025-05-04 2252.86
2768 2025-05-05 2252.86
2025-05-05 17:51:12,023 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2766 2025-05-03 2252.86 ... 2025-05-05 17:51:12.015590 2025-05-05 17:51:12.015980
2767 2025-05-04 2252.86 ... 2025-05-05 17:51:12.015590 2025-05-05 17:51:12.015980
2768 2025-05-05 2252.86 ... 2025-05-05 17:51:12.015590 2025-05-05 17:51:12.015980
[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-05-05 17:51:12,065 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2765 2025-05-02 ... 2025-05-05 17:51:12.057981
[1 rows x 6 columns]
2025-05-05 17:51:12,090 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2764 2025-05-01 2252.86
2765 2025-05-02 2252.86
2766 2025-05-03 2252.86
2767 2025-05-04 2252.86
2768 2025-05-05 2252.86
2025-05-05 17:51:12,151 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2769 2025-05-03 2252.86 ... 2025-05-05 17:51:12.144533 2025-05-05 17:51:12.144918
2770 2025-05-04 2252.86 ... 2025-05-05 17:51:12.144533 2025-05-05 17:51:12.144918
2771 2025-05-05 2252.86 ... 2025-05-05 17:51:12.144533 2025-05-05 17:51:12.144918
[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-05-05 17:51:12,195 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2768 2025-05-02 ... 2025-05-05 17:51:12.187902
[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-05-05 17:51:12,752 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2764 2025-05-01 2252.86
2765 2025-05-02 2252.86
2766 2025-05-03 2252.86
2767 2025-05-04 2252.86
2768 2025-05-05 2846.00
2025-05-05 17:51:12,806 - 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-05-05 17:51:12,831 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2768 2025-05-05 ... 2025-05-05 17:51:12.823944
[1 rows x 6 columns]
2025-05-05 17:51:12,856 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2764 2025-05-01 2252.86
2765 2025-05-02 2252.86
2766 2025-05-03 2252.86
2767 2025-05-04 2252.86
2768 2025-05-05 2846.00
2025-05-05 17:51:12,909 - 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-05-05 17:51:12,934 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2771 2025-05-05 ... 2025-05-05 17:51:12.926711
[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-05-05 17:51:13,474 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3121 2025-05-01 9378.33
3122 2025-05-02 9378.33
3123 2025-05-03 9378.33
3124 2025-05-04 9378.33
3125 2025-05-05 9378.33
2025-05-05 17:51:13,531 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-05-05 17:51:13,531 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-05-05 17:51:13,537 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3121 2025-05-01 9378.33
3122 2025-05-02 9378.33
3123 2025-05-03 9378.33
3124 2025-05-04 9378.33
3125 2025-05-05 9378.33
2025-05-05 17:51:13,593 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-05-05 17:51:13,593 - 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-05-05 17:51:14,155 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1805 2025-05-01 4331.67
1806 2025-05-02 4331.67
1807 2025-05-03 4331.67
1808 2025-05-04 4331.67
1809 2025-05-05 4331.67
2025-05-05 17:51:14,204 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1807 2025-05-03 4331.67 ... 2025-05-05 17:51:14.196619 2025-05-05 17:51:14.197002
1808 2025-05-04 4331.67 ... 2025-05-05 17:51:14.196619 2025-05-05 17:51:14.197002
1809 2025-05-05 4331.67 ... 2025-05-05 17:51:14.196619 2025-05-05 17:51:14.197002
[3 rows x 5 columns]
2025-05-05 17:51:14,223 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-05-05 17:51:14,229 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1805 2025-05-01 4331.67
1806 2025-05-02 4331.67
1807 2025-05-03 4331.67
1808 2025-05-04 4331.67
1809 2025-05-05 4331.67
2025-05-05 17:51:14,277 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1810 2025-05-03 4331.67 ... 2025-05-05 17:51:14.270107 2025-05-05 17:51:14.270510
1811 2025-05-04 4331.67 ... 2025-05-05 17:51:14.270107 2025-05-05 17:51:14.270510
1812 2025-05-05 4331.67 ... 2025-05-05 17:51:14.270107 2025-05-05 17:51:14.270510
[3 rows x 5 columns]
2025-05-05 17:51:14,296 - 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-05-05 17:51:14,853 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1814 2025-05-01 6250.0
1815 2025-05-02 6250.0
1816 2025-05-03 6250.0
1817 2025-05-04 6250.0
1818 2025-05-05 6250.0
2025-05-05 17:51:14,904 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1816 2025-05-03 6250.0 ... 2025-05-05 17:51:14.896882 2025-05-05 17:51:14.897303
1817 2025-05-04 6250.0 ... 2025-05-05 17:51:14.896882 2025-05-05 17:51:14.897303
1818 2025-05-05 6250.0 ... 2025-05-05 17:51:14.896882 2025-05-05 17:51:14.897303
[3 rows x 5 columns]
2025-05-05 17:51:14,924 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-05-05 17:51:14,931 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1814 2025-05-01 6250.0
1815 2025-05-02 6250.0
1816 2025-05-03 6250.0
1817 2025-05-04 6250.0
1818 2025-05-05 6250.0
2025-05-05 17:51:14,984 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1819 2025-05-03 6250.0 ... 2025-05-05 17:51:14.976429 2025-05-05 17:51:14.976817
1820 2025-05-04 6250.0 ... 2025-05-05 17:51:14.976429 2025-05-05 17:51:14.976817
1821 2025-05-05 6250.0 ... 2025-05-05 17:51:14.976429 2025-05-05 17:51:14.976817
[3 rows x 5 columns]
2025-05-05 17:51:15,003 - 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-05-05 17:51:15,596 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3482 2025-05-01 8760.0
3483 2025-05-02 8760.0
3484 2025-05-03 8760.0
3485 2025-05-04 8760.0
3486 2025-05-05 8760.0
2025-05-05 17:51:15,666 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3484 2025-05-03 8760.0 ... 2025-05-05 17:51:15.658858 2025-05-05 17:51:15.659309
3485 2025-05-04 8760.0 ... 2025-05-05 17:51:15.658858 2025-05-05 17:51:15.659309
3486 2025-05-05 8760.0 ... 2025-05-05 17:51:15.658858 2025-05-05 17:51:15.659309
[3 rows x 5 columns]
2025-05-05 17:51:15,686 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-05-05 17:51:15,692 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3482 2025-05-01 8760.0
3483 2025-05-02 8760.0
3484 2025-05-03 8760.0
3485 2025-05-04 8760.0
3486 2025-05-05 8760.0
2025-05-05 17:51:15,765 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3487 2025-05-03 8760.0 ... 2025-05-05 17:51:15.757773 2025-05-05 17:51:15.758160
3488 2025-05-04 8760.0 ... 2025-05-05 17:51:15.757773 2025-05-05 17:51:15.758160
3489 2025-05-05 8760.0 ... 2025-05-05 17:51:15.757773 2025-05-05 17:51:15.758160
[3 rows x 5 columns]
2025-05-05 17:51:15,786 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data