=========================================================================
2025-05-07 17:50:26 Wed 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-07 17:50:28,525 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3292 2025-05-03 3183.22
3293 2025-05-04 3183.22
3294 2025-05-05 3183.22
3295 2025-05-06 3176.33
3296 2025-05-07 3177.22
2025-05-07 17:50:28,596 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3295 2025-05-06 3176.33 ... 2025-05-07 17:50:28.588528 2025-05-07 17:50:28.588974
3296 2025-05-07 3177.22 ... 2025-05-07 17:50:28.588528 2025-05-07 17:50:28.588974
[2 rows x 5 columns]
2025-05-07 17:50:28,619 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-05-07 17:50:28,626 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3292 2025-05-03 3183.22
3293 2025-05-04 3183.22
3294 2025-05-05 3183.22
3295 2025-05-06 3176.33
3296 2025-05-07 3177.22
2025-05-07 17:50:28,693 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3298 2025-05-06 3176.33 ... 2025-05-07 17:50:28.685820 2025-05-07 17:50:28.686218
3299 2025-05-07 3177.22 ... 2025-05-07 17:50:28.685820 2025-05-07 17:50:28.686218
[2 rows x 5 columns]
2025-05-07 17:50:28,713 - 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-07 17:50:29,324 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3513 2025-05-03 2440.00
3514 2025-05-04 2440.00
3515 2025-05-05 2440.00
3516 2025-05-06 2428.75
3517 2025-05-07 2410.00
2025-05-07 17:50:29,393 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3516 2025-05-06 2428.75 ... 2025-05-07 17:50:29.386331 2025-05-07 17:50:29.386720
3517 2025-05-07 2410.00 ... 2025-05-07 17:50:29.386331 2025-05-07 17:50:29.386720
[2 rows x 5 columns]
2025-05-07 17:50:29,412 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-05-07 17:50:29,418 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3513 2025-05-03 2440.00
3514 2025-05-04 2440.00
3515 2025-05-05 2440.00
3516 2025-05-06 2428.75
3517 2025-05-07 2410.00
2025-05-07 17:50:29,486 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3520 2025-05-06 2428.75 ... 2025-05-07 17:50:29.478904 2025-05-07 17:50:29.479293
3521 2025-05-07 2410.00 ... 2025-05-07 17:50:29.478904 2025-05-07 17:50:29.479293
[2 rows x 5 columns]
2025-05-07 17:50:29,504 - 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-07 17:50:30,077 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
853 2025-05-03 4584.38
854 2025-05-04 4584.38
855 2025-05-05 4582.50
856 2025-05-06 4529.17
857 2025-05-07 4555.84
2025-05-07 17:50:30,114 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
856 2025-05-06 4529.17 ... 2025-05-07 17:50:30.106414 2025-05-07 17:50:30.106839
857 2025-05-07 4555.84 ... 2025-05-07 17:50:30.106414 2025-05-07 17:50:30.106839
[2 rows x 5 columns]
2025-05-07 17:50:30,133 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-05-07 17:50:30,139 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
853 2025-05-03 4584.38
854 2025-05-04 4584.38
855 2025-05-05 4582.50
856 2025-05-06 4529.17
857 2025-05-07 4555.84
2025-05-07 17:50:30,175 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
856 2025-05-06 4529.17 ... 2025-05-07 17:50:30.167935 2025-05-07 17:50:30.168323
857 2025-05-07 4555.84 ... 2025-05-07 17:50:30.167935 2025-05-07 17:50:30.168323
[2 rows x 5 columns]
2025-05-07 17:50:30,193 - 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-07 17:50:30,812 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3732 2025-05-03 14308.33
3733 2025-05-04 14308.33
3734 2025-05-05 14308.33
3735 2025-05-06 14593.33
3736 2025-05-07 14578.33
2025-05-07 17:50:30,882 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3735 2025-05-06 ... 2025-05-07 17:50:30.875936
3736 2025-05-07 ... 2025-05-07 17:50:30.875936
[2 rows x 5 columns]
2025-05-07 17:50:30,904 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-05-07 17:50:30,910 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3732 2025-05-03 14308.33
3733 2025-05-04 14308.33
3734 2025-05-05 14308.33
3735 2025-05-06 14593.33
3736 2025-05-07 14578.33
2025-05-07 17:50:30,983 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3738 2025-05-06 ... 2025-05-07 17:50:30.977207
3739 2025-05-07 ... 2025-05-07 17:50:30.977207
[2 rows x 5 columns]
2025-05-07 17:50:31,003 - 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-07 17:50:31,577 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3064 2025-05-03 778.11
3065 2025-05-04 778.11
3066 2025-05-05 778.11
3067 2025-05-06 781.44
3068 2025-05-07 789.44
2025-05-07 17:50:31,643 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3067 2025-05-06 781.44 ... 2025-05-07 17:50:31.635273 2025-05-07 17:50:31.635672
3068 2025-05-07 789.44 ... 2025-05-07 17:50:31.635273 2025-05-07 17:50:31.635672
[2 rows x 5 columns]
2025-05-07 17:50:31,662 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-05-07 17:50:31,668 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3064 2025-05-03 778.11
3065 2025-05-04 778.11
3066 2025-05-05 778.11
3067 2025-05-06 781.44
3068 2025-05-07 789.44
2025-05-07 17:50:31,734 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3070 2025-05-06 781.44 ... 2025-05-07 17:50:31.726692 2025-05-07 17:50:31.727127
3071 2025-05-07 789.44 ... 2025-05-07 17:50:31.726692 2025-05-07 17:50:31.727127
[2 rows x 5 columns]
2025-05-07 17:50:31,753 - 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-07 17:50:32,347 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3267 2025-05-03 1246.4
3268 2025-05-04 1246.4
3269 2025-05-05 1246.4
3270 2025-05-06 1246.4
3271 2025-05-07 1214.4
2025-05-07 17:50:32,412 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3270 2025-05-06 1246.4 ... 2025-05-07 17:50:32.404715 2025-05-07 17:50:32.405132
3271 2025-05-07 1214.4 ... 2025-05-07 17:50:32.404715 2025-05-07 17:50:32.405132
[2 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-07 17:50:34,307 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-05-07 17:50:34.299723
21 2013-01-04 ... 2025-05-07 17:50:34.299723
54 2013-02-27 ... 2025-05-07 17:50:34.299723
60 2013-03-07 ... 2025-05-07 17:50:34.299723
61 2013-03-08 ... 2025-05-07 17:50:34.299723
[5 rows x 6 columns]
2025-05-07 17:50:34,466 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3267 2025-05-03 1246.4
3268 2025-05-04 1246.4
3269 2025-05-05 1246.4
3270 2025-05-06 1246.4
3271 2025-05-07 1214.4
2025-05-07 17:50:34,532 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3274 2025-05-06 1246.4 ... 2025-05-07 17:50:34.524701 2025-05-07 17:50:34.525117
3275 2025-05-07 1214.4 ... 2025-05-07 17:50:34.524701 2025-05-07 17:50:34.525117
[2 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-07 17:50:36,415 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-05-07 17:50:36.404006
21 2013-01-04 ... 2025-05-07 17:50:36.404006
54 2013-02-27 ... 2025-05-07 17:50:36.404006
60 2013-03-07 ... 2025-05-07 17:50:36.404006
61 2013-03-08 ... 2025-05-07 17:50:36.404006
[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-07 17:50:37,170 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1612 2025-05-03 7680.0
1613 2025-05-04 7680.0
1614 2025-05-05 7680.0
1615 2025-05-06 7650.0
1616 2025-05-07 7650.0
2025-05-07 17:50:37,218 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1615 2025-05-06 7650.0 ... 2025-05-07 17:50:37.209834 2025-05-07 17:50:37.210276
1616 2025-05-07 7650.0 ... 2025-05-07 17:50:37.209834 2025-05-07 17:50:37.210276
[2 rows x 5 columns]
2025-05-07 17:50:37,237 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-05-07 17:50:37,243 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1612 2025-05-03 7680.0
1613 2025-05-04 7680.0
1614 2025-05-05 7680.0
1615 2025-05-06 7650.0
1616 2025-05-07 7650.0
2025-05-07 17:50:37,288 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1618 2025-05-06 7650.0 ... 2025-05-07 17:50:37.281018 2025-05-07 17:50:37.281399
1619 2025-05-07 7650.0 ... 2025-05-07 17:50:37.281018 2025-05-07 17:50:37.281399
[2 rows x 5 columns]
2025-05-07 17:50:37,307 - 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-07 17:50:37,835 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3723 2025-05-03 6160.00
3724 2025-05-04 6160.00
3725 2025-05-05 6160.00
3726 2025-05-06 6156.67
3727 2025-05-07 6156.67
2025-05-07 17:50:37,907 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3726 2025-05-06 6156.67 ... 2025-05-07 17:50:37.899849 2025-05-07 17:50:37.900275
3727 2025-05-07 6156.67 ... 2025-05-07 17:50:37.899849 2025-05-07 17:50:37.900275
[2 rows x 5 columns]
2025-05-07 17:50:37,925 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-05-07 17:50:37,931 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3723 2025-05-03 6160.00
3724 2025-05-04 6160.00
3725 2025-05-05 6160.00
3726 2025-05-06 6156.67
3727 2025-05-07 6156.67
2025-05-07 17:50:38,003 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3730 2025-05-06 6156.67 ... 2025-05-07 17:50:37.995943 2025-05-07 17:50:37.996327
3731 2025-05-07 6156.67 ... 2025-05-07 17:50:37.995943 2025-05-07 17:50:37.996327
[2 rows x 5 columns]
2025-05-07 17:50:38,021 - 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-07 17:50:38,554 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1613 2025-05-03 13050.0
1614 2025-05-04 13050.0
1615 2025-05-05 13050.0
1616 2025-05-06 13062.5
1617 2025-05-07 13062.5
2025-05-07 17:50:38,599 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1616 2025-05-06 13062.5 ... 2025-05-07 17:50:38.592594 2025-05-07 17:50:38.593036
1617 2025-05-07 13062.5 ... 2025-05-07 17:50:38.592594 2025-05-07 17:50:38.593036
[2 rows x 5 columns]
2025-05-07 17:50:38,618 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-05-07 17:50:38,624 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1613 2025-05-03 13050.0
1614 2025-05-04 13050.0
1615 2025-05-05 13050.0
1616 2025-05-06 13062.5
1617 2025-05-07 13062.5
2025-05-07 17:50:38,670 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1619 2025-05-06 13062.5 ... 2025-05-07 17:50:38.662497 2025-05-07 17:50:38.662911
1620 2025-05-07 13062.5 ... 2025-05-07 17:50:38.662497 2025-05-07 17:50:38.662911
[2 rows x 5 columns]
2025-05-07 17:50:38,688 - 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-07 17:50:39,427 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3123 2025-05-03 9378.33
3124 2025-05-04 9378.33
3125 2025-05-05 9378.33
3126 2025-05-06 9330.00
3127 2025-05-07 9430.00
2025-05-07 17:50:39,492 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date value ... created_at updated_at
3126 2025-05-06 9330.0 ... 2025-05-07 17:50:39.484696 2025-05-07 17:50:39.485113
3127 2025-05-07 9430.0 ... 2025-05-07 17:50:39.484696 2025-05-07 17:50:39.485113
[2 rows x 5 columns]
2025-05-07 17:50:39,511 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-05-07 17:50:39,517 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3123 2025-05-03 9378.33
3124 2025-05-04 9378.33
3125 2025-05-05 9378.33
3126 2025-05-06 9330.00
3127 2025-05-07 9430.00
2025-05-07 17:50:39,582 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date value ... created_at updated_at
3130 2025-05-06 9330.0 ... 2025-05-07 17:50:39.575082 2025-05-07 17:50:39.575481
3131 2025-05-07 9430.0 ... 2025-05-07 17:50:39.575082 2025-05-07 17:50:39.575481
[2 rows x 5 columns]
2025-05-07 17:50:39,601 - 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-07 17:50:40,182 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3246 2025-05-03 2531.67
3247 2025-05-04 2531.67
3248 2025-05-05 2531.67
3249 2025-05-06 2511.67
3250 2025-05-07 2511.67
2025-05-07 17:50:40,250 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3249 2025-05-06 2511.67 ... 2025-05-07 17:50:40.243030 2025-05-07 17:50:40.243436
3250 2025-05-07 2511.67 ... 2025-05-07 17:50:40.243030 2025-05-07 17:50:40.243436
[2 rows x 5 columns]
2025-05-07 17:50:40,268 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-05-07 17:50:40,274 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3246 2025-05-03 2531.67
3247 2025-05-04 2531.67
3248 2025-05-05 2531.67
3249 2025-05-06 2511.67
3250 2025-05-07 2511.67
2025-05-07 17:50:40,339 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3253 2025-05-06 2511.67 ... 2025-05-07 17:50:40.332514 2025-05-07 17:50:40.332922
3254 2025-05-07 2511.67 ... 2025-05-07 17:50:40.332514 2025-05-07 17:50:40.332922
[2 rows x 5 columns]
2025-05-07 17:50:40,358 - 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-07 17:50:40,851 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1450 2025-05-03 1502.5
1451 2025-05-04 1502.5
1452 2025-05-05 1502.5
1453 2025-05-06 1502.5
1454 2025-05-07 1462.5
2025-05-07 17:50:40,897 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1453 2025-05-06 1502.5 ... 2025-05-07 17:50:40.888242 2025-05-07 17:50:40.888705
1454 2025-05-07 1462.5 ... 2025-05-07 17:50:40.888242 2025-05-07 17:50:40.888705
[2 rows x 5 columns]
2025-05-07 17:50:40,916 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-05-07 17:50:40,921 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1450 2025-05-03 1502.5
1451 2025-05-04 1502.5
1452 2025-05-05 1502.5
1453 2025-05-06 1502.5
1454 2025-05-07 1462.5
2025-05-07 17:50:40,967 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1457 2025-05-06 1502.5 ... 2025-05-07 17:50:40.960466 2025-05-07 17:50:40.960873
1458 2025-05-07 1462.5 ... 2025-05-07 17:50:40.960466 2025-05-07 17:50:40.960873
[2 rows x 5 columns]
2025-05-07 17:50:40,986 - 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-07 17:50:41,669 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1363 2025-05-03 6351.46
1364 2025-05-04 6351.46
1365 2025-05-05 6351.67
1366 2025-05-06 6313.75
1367 2025-05-07 6377.50
2025-05-07 17:50:41,712 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1366 2025-05-06 6313.75 ... 2025-05-07 17:50:41.704604 2025-05-07 17:50:41.705034
1367 2025-05-07 6377.50 ... 2025-05-07 17:50:41.704604 2025-05-07 17:50:41.705034
[2 rows x 5 columns]
2025-05-07 17:50:41,731 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-05-07 17:50:41,736 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1363 2025-05-03 6351.46
1364 2025-05-04 6351.46
1365 2025-05-05 6351.67
1366 2025-05-06 6313.75
1367 2025-05-07 6377.50
2025-05-07 17:50:41,780 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1370 2025-05-06 6313.75 ... 2025-05-07 17:50:41.772596 2025-05-07 17:50:41.773015
1371 2025-05-07 6377.50 ... 2025-05-07 17:50:41.772596 2025-05-07 17:50:41.773015
[2 rows x 5 columns]
2025-05-07 17:50:41,798 - 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-07 17:50:42,348 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3736 2025-05-03 3476.67
3737 2025-05-04 3476.67
3738 2025-05-05 3476.67
3739 2025-05-06 3270.00
3740 2025-05-07 3302.00
2025-05-07 17:50:42,421 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3739 2025-05-06 3270.0 ... 2025-05-07 17:50:42.413699 2025-05-07 17:50:42.414123
3740 2025-05-07 3302.0 ... 2025-05-07 17:50:42.413699 2025-05-07 17:50:42.414123
[2 rows x 5 columns]
2025-05-07 17:50:42,439 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-05-07 17:50:42,446 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3736 2025-05-03 3476.67
3737 2025-05-04 3476.67
3738 2025-05-05 3476.67
3739 2025-05-06 3270.00
3740 2025-05-07 3302.00
2025-05-07 17:50:42,518 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3742 2025-05-06 3270.0 ... 2025-05-07 17:50:42.511003 2025-05-07 17:50:42.511392
3743 2025-05-07 3302.0 ... 2025-05-07 17:50:42.511003 2025-05-07 17:50:42.511392
[2 rows x 5 columns]
2025-05-07 17:50:42,537 - 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-07 17:50:43,136 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3506 2025-05-03 8126.0
3507 2025-05-04 8126.0
3508 2025-05-05 8126.0
3509 2025-05-06 8056.0
3510 2025-05-07 8076.0
2025-05-07 17:50:43,207 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3509 2025-05-06 8056.0 ... 2025-05-07 17:50:43.199944 2025-05-07 17:50:43.200340
3510 2025-05-07 8076.0 ... 2025-05-07 17:50:43.199944 2025-05-07 17:50:43.200340
[2 rows x 5 columns]
2025-05-07 17:50:43,227 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-05-07 17:50:43,237 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3506 2025-05-03 8126.0
3507 2025-05-04 8126.0
3508 2025-05-05 8126.0
3509 2025-05-06 8056.0
3510 2025-05-07 8076.0
2025-05-07 17:50:43,306 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3512 2025-05-06 8056.0 ... 2025-05-07 17:50:43.298656 2025-05-07 17:50:43.299071
3513 2025-05-07 8076.0 ... 2025-05-07 17:50:43.298656 2025-05-07 17:50:43.299071
[2 rows x 5 columns]
2025-05-07 17:50:43,324 - 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-07 17:50:43,874 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3472 2025-05-03 4245.0
3473 2025-05-04 4245.0
3474 2025-05-05 4245.0
3475 2025-05-06 4230.0
3476 2025-05-07 4230.0
2025-05-07 17:50:43,945 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3475 2025-05-06 4230.0 ... 2025-05-07 17:50:43.937345 2025-05-07 17:50:43.937782
3476 2025-05-07 4230.0 ... 2025-05-07 17:50:43.937345 2025-05-07 17:50:43.937782
[2 rows x 5 columns]
2025-05-07 17:50:43,964 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-05-07 17:50:43,970 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3472 2025-05-03 4245.0
3473 2025-05-04 4245.0
3474 2025-05-05 4245.0
3475 2025-05-06 4230.0
3476 2025-05-07 4230.0
2025-05-07 17:50:44,042 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3478 2025-05-06 4230.0 ... 2025-05-07 17:50:44.034926 2025-05-07 17:50:44.035323
3479 2025-05-07 4230.0 ... 2025-05-07 17:50:44.034926 2025-05-07 17:50:44.035323
[2 rows x 5 columns]
2025-05-07 17:50:44,062 - 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-07 17:50:44,702 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2849 2025-05-03 5548.57
2850 2025-05-04 5548.57
2851 2025-05-05 5548.57
2852 2025-05-06 5548.57
2853 2025-05-07 5402.86
2025-05-07 17:50:44,764 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2852 2025-05-06 5548.57 ... 2025-05-07 17:50:44.756609 2025-05-07 17:50:44.757028
2853 2025-05-07 5402.86 ... 2025-05-07 17:50:44.756609 2025-05-07 17:50:44.757028
[2 rows x 5 columns]
2025-05-07 17:50:44,782 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-05-07 17:50:44,789 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2849 2025-05-03 5548.57
2850 2025-05-04 5548.57
2851 2025-05-05 5548.57
2852 2025-05-06 5548.57
2853 2025-05-07 5402.86
2025-05-07 17:50:44,849 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2856 2025-05-06 5548.57 ... 2025-05-07 17:50:44.842069 2025-05-07 17:50:44.842452
2857 2025-05-07 5402.86 ... 2025-05-07 17:50:44.842069 2025-05-07 17:50:44.842452
[2 rows x 5 columns]
2025-05-07 17:50:44,867 - 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-07 17:50:45,390 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3049 2025-05-03 3375.0
3050 2025-05-04 3375.0
3051 2025-05-05 3375.0
3052 2025-05-06 3375.0
3053 2025-05-07 3300.0
2025-05-07 17:50:45,453 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3052 2025-05-06 3375.0 ... 2025-05-07 17:50:45.445826 2025-05-07 17:50:45.446228
3053 2025-05-07 3300.0 ... 2025-05-07 17:50:45.445826 2025-05-07 17:50:45.446228
[2 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-07 17:50:45,597 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-05-07 17:50:45.588992
458 2015-09-21 ... 2025-05-07 17:50:45.588992
549 2016-02-03 ... 2025-05-07 17:50:45.588992
693 2016-09-05 ... 2025-05-07 17:50:45.588992
696 2016-09-08 ... 2025-05-07 17:50:45.588992
[5 rows x 6 columns]
2025-05-07 17:50:45,626 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3049 2025-05-03 3375.0
3050 2025-05-04 3375.0
3051 2025-05-05 3375.0
3052 2025-05-06 3375.0
3053 2025-05-07 3300.0
2025-05-07 17:50:45,690 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3055 2025-05-06 3375.0 ... 2025-05-07 17:50:45.682601 2025-05-07 17:50:45.683021
3056 2025-05-07 3300.0 ... 2025-05-07 17:50:45.682601 2025-05-07 17:50:45.683021
[2 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-07 17:50:45,832 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-05-07 17:50:45.824746
458 2015-09-21 ... 2025-05-07 17:50:45.824746
549 2016-02-03 ... 2025-05-07 17:50:45.824746
693 2016-09-05 ... 2025-05-07 17:50:45.824746
696 2016-09-08 ... 2025-05-07 17:50:45.824746
[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-07 17:50:46,413 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
853 2025-05-03 9880.0
854 2025-05-04 9880.0
855 2025-05-05 9880.0
856 2025-05-06 9780.0
857 2025-05-07 9690.0
2025-05-07 17:50:46,449 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
856 2025-05-06 9780.0 ... 2025-05-07 17:50:46.441934 2025-05-07 17:50:46.442346
857 2025-05-07 9690.0 ... 2025-05-07 17:50:46.441934 2025-05-07 17:50:46.442346
[2 rows x 5 columns]
2025-05-07 17:50:46,468 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-05-07 17:50:46,473 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
853 2025-05-03 9880.0
854 2025-05-04 9880.0
855 2025-05-05 9880.0
856 2025-05-06 9780.0
857 2025-05-07 9690.0
2025-05-07 17:50:46,508 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
856 2025-05-06 9780.0 ... 2025-05-07 17:50:46.501098 2025-05-07 17:50:46.501468
857 2025-05-07 9690.0 ... 2025-05-07 17:50:46.501098 2025-05-07 17:50:46.501468
[2 rows x 5 columns]
2025-05-07 17:50:46,526 - 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-07 17:50:47,176 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3732 2025-05-03 7553.33
3733 2025-05-04 7553.33
3734 2025-05-05 7553.33
3735 2025-05-06 7500.00
3736 2025-05-07 7491.67
2025-05-07 17:50:47,248 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3735 2025-05-06 7500.00 ... 2025-05-07 17:50:47.240844 2025-05-07 17:50:47.241237
3736 2025-05-07 7491.67 ... 2025-05-07 17:50:47.240844 2025-05-07 17:50:47.241237
[2 rows x 5 columns]
2025-05-07 17:50:47,266 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-05-07 17:50:47,272 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3732 2025-05-03 7553.33
3733 2025-05-04 7553.33
3734 2025-05-05 7553.33
3735 2025-05-06 7500.00
3736 2025-05-07 7491.67
2025-05-07 17:50:47,346 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3738 2025-05-06 7500.00 ... 2025-05-07 17:50:47.337660 2025-05-07 17:50:47.338164
3739 2025-05-07 7491.67 ... 2025-05-07 17:50:47.337660 2025-05-07 17:50:47.338164
[2 rows x 5 columns]
2025-05-07 17:50:47,365 - 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-07 17:50:47,908 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3070 2025-05-03 3647.5
3071 2025-05-04 3647.5
3072 2025-05-05 3647.5
3073 2025-05-06 3590.0
3074 2025-05-07 3590.0
2025-05-07 17:50:47,972 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3074 2025-05-06 3590.0 ... 2025-05-07 17:50:47.964947 2025-05-07 17:50:47.965346
3075 2025-05-07 3590.0 ... 2025-05-07 17:50:47.964947 2025-05-07 17:50:47.965346
[2 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-07 17:50:48,008 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-05-07 17:50:48.000781
[1 rows x 6 columns]
2025-05-07 17:50:48,033 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3070 2025-05-03 3647.5
3071 2025-05-04 3647.5
3072 2025-05-05 3647.5
3073 2025-05-06 3590.0
3074 2025-05-07 3590.0
2025-05-07 17:50:48,097 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3076 2025-05-06 3590.0 ... 2025-05-07 17:50:48.089747 2025-05-07 17:50:48.090171
3077 2025-05-07 3590.0 ... 2025-05-07 17:50:48.089747 2025-05-07 17:50:48.090171
[2 rows x 5 columns]
2025-05-07 17:50:48,115 - 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-07 17:50:48,733 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3735 2025-05-03 20073.33
3736 2025-05-04 20073.33
3737 2025-05-05 20073.33
3738 2025-05-06 20073.33
3739 2025-05-07 19630.00
2025-05-07 17:50:48,805 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date ... updated_at
3738 2025-05-06 ... 2025-05-07 17:50:48.798929
3739 2025-05-07 ... 2025-05-07 17:50:48.798929
[2 rows x 5 columns]
2025-05-07 17:50:48,824 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-05-07 17:50:48,831 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3735 2025-05-03 20073.33
3736 2025-05-04 20073.33
3737 2025-05-05 20073.33
3738 2025-05-06 20073.33
3739 2025-05-07 19630.00
2025-05-07 17:50:48,902 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date ... updated_at
3741 2025-05-06 ... 2025-05-07 17:50:48.896148
3742 2025-05-07 ... 2025-05-07 17:50:48.896148
[2 rows x 5 columns]
2025-05-07 17:50:48,920 - 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-07 17:50:49,452 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2849 2025-05-03 5640.0
2850 2025-05-04 5640.0
2851 2025-05-05 5640.0
2852 2025-05-06 5610.0
2853 2025-05-07 5586.0
2025-05-07 17:50:49,514 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2852 2025-05-06 5610.0 ... 2025-05-07 17:50:49.506691 2025-05-07 17:50:49.507146
2853 2025-05-07 5586.0 ... 2025-05-07 17:50:49.506691 2025-05-07 17:50:49.507146
[2 rows x 5 columns]
2025-05-07 17:50:49,533 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-05-07 17:50:49,539 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2849 2025-05-03 5640.0
2850 2025-05-04 5640.0
2851 2025-05-05 5640.0
2852 2025-05-06 5610.0
2853 2025-05-07 5586.0
2025-05-07 17:50:49,601 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2856 2025-05-06 5610.0 ... 2025-05-07 17:50:49.594159 2025-05-07 17:50:49.594544
2857 2025-05-07 5586.0 ... 2025-05-07 17:50:49.594159 2025-05-07 17:50:49.594544
[2 rows x 5 columns]
2025-05-07 17:50:49,620 - 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-07 17:50:50,217 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2124 2025-05-03 23775.0
2125 2025-05-04 23775.0
2126 2025-05-05 23775.0
2127 2025-05-06 23775.0
2128 2025-05-07 23775.0
2025-05-07 17:50:50,270 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2127 2025-05-06 23775.0 ... 2025-05-07 17:50:50.262642 2025-05-07 17:50:50.263066
2128 2025-05-07 23775.0 ... 2025-05-07 17:50:50.262642 2025-05-07 17:50:50.263066
[2 rows x 5 columns]
2025-05-07 17:50:50,288 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-05-07 17:50:50,294 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2124 2025-05-03 23775.0
2125 2025-05-04 23775.0
2126 2025-05-05 23775.0
2127 2025-05-06 23775.0
2128 2025-05-07 23775.0
2025-05-07 17:50:50,345 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2131 2025-05-06 23775.0 ... 2025-05-07 17:50:50.338311 2025-05-07 17:50:50.338698
2132 2025-05-07 23775.0 ... 2025-05-07 17:50:50.338311 2025-05-07 17:50:50.338698
[2 rows x 5 columns]
2025-05-07 17:50:50,363 - 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-07 17:50:50,874 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1639 2025-05-03 1875.00
1640 2025-05-04 1875.00
1641 2025-05-05 1875.00
1642 2025-05-06 1893.33
1643 2025-05-07 1906.67
2025-05-07 17:50:50,920 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1642 2025-05-06 1893.33 ... 2025-05-07 17:50:50.912695 2025-05-07 17:50:50.913103
1643 2025-05-07 1906.67 ... 2025-05-07 17:50:50.912695 2025-05-07 17:50:50.913103
[2 rows x 5 columns]
2025-05-07 17:50:50,938 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-05-07 17:50:50,944 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1639 2025-05-03 1875.00
1640 2025-05-04 1875.00
1641 2025-05-05 1875.00
1642 2025-05-06 1893.33
1643 2025-05-07 1906.67
2025-05-07 17:50:50,989 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1646 2025-05-06 1893.33 ... 2025-05-07 17:50:50.982446 2025-05-07 17:50:50.982851
1647 2025-05-07 1906.67 ... 2025-05-07 17:50:50.982446 2025-05-07 17:50:50.982851
[2 rows x 5 columns]
2025-05-07 17:50:51,007 - 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-07 17:50:51,608 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2711 2025-05-03 125175.00
2712 2025-05-04 125175.00
2713 2025-05-05 125175.00
2714 2025-05-06 125775.00
2715 2025-05-07 125683.33
2025-05-07 17:50:51,667 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2714 2025-05-06 ... 2025-05-07 17:50:51.660526
2715 2025-05-07 ... 2025-05-07 17:50:51.660526
[2 rows x 5 columns]
2025-05-07 17:50:51,685 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-05-07 17:50:51,691 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2711 2025-05-03 125175.00
2712 2025-05-04 125175.00
2713 2025-05-05 125175.00
2714 2025-05-06 125775.00
2715 2025-05-07 125683.33
2025-05-07 17:50:51,751 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2717 2025-05-06 ... 2025-05-07 17:50:51.745409
2718 2025-05-07 ... 2025-05-07 17:50:51.745409
[2 rows x 5 columns]
2025-05-07 17:50:51,770 - 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-07 17:50:52,326 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3736 2025-05-03 4679.0
3737 2025-05-04 4679.0
3738 2025-05-05 4679.0
3739 2025-05-06 4653.0
3740 2025-05-07 4665.0
2025-05-07 17:50:52,398 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3739 2025-05-06 4653.0 ... 2025-05-07 17:50:52.391102 2025-05-07 17:50:52.391486
3740 2025-05-07 4665.0 ... 2025-05-07 17:50:52.391102 2025-05-07 17:50:52.391486
[2 rows x 5 columns]
2025-05-07 17:50:52,417 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-05-07 17:50:52,423 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3736 2025-05-03 4679.0
3737 2025-05-04 4679.0
3738 2025-05-05 4679.0
3739 2025-05-06 4653.0
3740 2025-05-07 4665.0
2025-05-07 17:50:52,496 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3742 2025-05-06 4653.0 ... 2025-05-07 17:50:52.489571 2025-05-07 17:50:52.489982
3743 2025-05-07 4665.0 ... 2025-05-07 17:50:52.489571 2025-05-07 17:50:52.489982
[2 rows x 5 columns]
2025-05-07 17:50:52,515 - 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-07 17:50:53,149 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
2975 2025-05-03 7481.67
2976 2025-05-04 7481.67
2977 2025-05-05 7481.67
2978 2025-05-06 7481.67
2979 2025-05-07 7481.67
2025-05-07 17:50:53,216 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
2978 2025-05-06 7481.67 ... 2025-05-07 17:50:53.208969 2025-05-07 17:50:53.209365
2979 2025-05-07 7481.67 ... 2025-05-07 17:50:53.208969 2025-05-07 17:50:53.209365
[2 rows x 5 columns]
2025-05-07 17:50:53,236 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-05-07 17:50:53,242 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
2975 2025-05-03 7481.67
2976 2025-05-04 7481.67
2977 2025-05-05 7481.67
2978 2025-05-06 7481.67
2979 2025-05-07 7481.67
2025-05-07 17:50:53,315 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
2981 2025-05-06 7481.67 ... 2025-05-07 17:50:53.308307 2025-05-07 17:50:53.308689
2982 2025-05-07 7481.67 ... 2025-05-07 17:50:53.308307 2025-05-07 17:50:53.308689
[2 rows x 5 columns]
2025-05-07 17:50:53,335 - 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-07 17:50:53,923 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3737 2025-05-03 14208.83
3738 2025-05-04 14208.83
3739 2025-05-05 14208.83
3740 2025-05-06 14138.67
3741 2025-05-07 14124.33
2025-05-07 17:50:53,993 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date ... updated_at
3740 2025-05-06 ... 2025-05-07 17:50:53.987511
3741 2025-05-07 ... 2025-05-07 17:50:53.987511
[2 rows x 5 columns]
2025-05-07 17:50:54,012 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-05-07 17:50:54,018 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3737 2025-05-03 14208.83
3738 2025-05-04 14208.83
3739 2025-05-05 14208.83
3740 2025-05-06 14138.67
3741 2025-05-07 14124.33
2025-05-07 17:50:54,089 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date ... updated_at
3744 2025-05-06 ... 2025-05-07 17:50:54.083394
3745 2025-05-07 ... 2025-05-07 17:50:54.083394
[2 rows x 5 columns]
2025-05-07 17:50:54,109 - 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-07 17:50:54,667 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3682 2025-05-03 16812.50
3683 2025-05-04 16812.50
3684 2025-05-05 16812.50
3685 2025-05-06 16706.25
3686 2025-05-07 16637.50
2025-05-07 17:50:54,738 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date ... updated_at
3685 2025-05-06 ... 2025-05-07 17:50:54.731691
3686 2025-05-07 ... 2025-05-07 17:50:54.731691
[2 rows x 5 columns]
2025-05-07 17:50:54,757 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-05-07 17:50:54,764 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3682 2025-05-03 16812.50
3683 2025-05-04 16812.50
3684 2025-05-05 16812.50
3685 2025-05-06 16706.25
3686 2025-05-07 16637.50
2025-05-07 17:50:54,911 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date ... updated_at
3688 2025-05-06 ... 2025-05-07 17:50:54.905472
3689 2025-05-07 ... 2025-05-07 17:50:54.905472
[2 rows x 5 columns]
2025-05-07 17:50:54,930 - 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-07 17:50:55,724 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
2957 2025-05-03 3276.67
2958 2025-05-04 3276.67
2959 2025-05-05 3276.67
2960 2025-05-06 3263.33
2961 2025-05-07 3283.33
2025-05-07 17:50:55,785 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
2960 2025-05-06 3263.33 ... 2025-05-07 17:50:55.778280 2025-05-07 17:50:55.778664
2961 2025-05-07 3283.33 ... 2025-05-07 17:50:55.778280 2025-05-07 17:50:55.778664
[2 rows x 5 columns]
2025-05-07 17:50:55,804 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-05-07 17:50:55,810 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
2957 2025-05-03 3276.67
2958 2025-05-04 3276.67
2959 2025-05-05 3276.67
2960 2025-05-06 3263.33
2961 2025-05-07 3283.33
2025-05-07 17:50:55,872 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
2963 2025-05-06 3263.33 ... 2025-05-07 17:50:55.864954 2025-05-07 17:50:55.865346
2964 2025-05-07 3283.33 ... 2025-05-07 17:50:55.864954 2025-05-07 17:50:55.865346
[2 rows x 5 columns]
2025-05-07 17:50:55,890 - 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-07 17:50:56,484 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3237 2025-05-03 5462.5
3238 2025-05-04 5462.5
3239 2025-05-05 5462.5
3240 2025-05-06 5425.0
3241 2025-05-07 5425.0
2025-05-07 17:50:56,549 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3240 2025-05-06 5425.0 ... 2025-05-07 17:50:56.541788 2025-05-07 17:50:56.542190
3241 2025-05-07 5425.0 ... 2025-05-07 17:50:56.541788 2025-05-07 17:50:56.542190
[2 rows x 5 columns]
2025-05-07 17:50:56,567 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-05-07 17:50:56,573 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3237 2025-05-03 5462.5
3238 2025-05-04 5462.5
3239 2025-05-05 5462.5
3240 2025-05-06 5425.0
3241 2025-05-07 5425.0
2025-05-07 17:50:56,645 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3727 2025-05-06 5425.0 ... 2025-05-07 17:50:56.638176 2025-05-07 17:50:56.638562
3728 2025-05-07 5425.0 ... 2025-05-07 17:50:56.638176 2025-05-07 17:50:56.638562
[2 rows x 5 columns]
2025-05-07 17:50:56,664 - 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-07 17:50:57,167 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1301 2025-05-03 14830.0
1302 2025-05-04 14830.0
1303 2025-05-05 14830.0
1304 2025-05-06 14820.0
1305 2025-05-07 14830.0
2025-05-07 17:50:57,209 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1304 2025-05-06 14820.0 ... 2025-05-07 17:50:57.201678 2025-05-07 17:50:57.202097
1305 2025-05-07 14830.0 ... 2025-05-07 17:50:57.201678 2025-05-07 17:50:57.202097
[2 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-07 17:50:57,439 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-05-07 17:50:57.431305
117 2021-07-06 ... 2025-05-07 17:50:57.431305
121 2021-07-12 ... 2025-05-07 17:50:57.431305
122 2021-07-13 ... 2025-05-07 17:50:57.431305
194 2021-11-01 ... 2025-05-07 17:50:57.431305
[5 rows x 6 columns]
2025-05-07 17:50:57,474 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1301 2025-05-03 14830.0
1302 2025-05-04 14830.0
1303 2025-05-05 14830.0
1304 2025-05-06 14820.0
1305 2025-05-07 14830.0
2025-05-07 17:50:57,517 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1307 2025-05-06 14820.0 ... 2025-05-07 17:50:57.509027 2025-05-07 17:50:57.509407
1308 2025-05-07 14830.0 ... 2025-05-07 17:50:57.509027 2025-05-07 17:50:57.509407
[2 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-07 17:50:57,747 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-05-07 17:50:57.739189
117 2021-07-06 ... 2025-05-07 17:50:57.739189
121 2021-07-12 ... 2025-05-07 17:50:57.739189
122 2021-07-13 ... 2025-05-07 17:50:57.739189
194 2021-11-01 ... 2025-05-07 17:50:57.739189
[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-07 17:50:58,554 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3733 2025-05-03 77996.67
3734 2025-05-04 77996.67
3735 2025-05-05 77996.67
3736 2025-05-06 78233.33
3737 2025-05-07 78520.00
2025-05-07 17:50:58,625 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date ... updated_at
3736 2025-05-06 ... 2025-05-07 17:50:58.618814
3737 2025-05-07 ... 2025-05-07 17:50:58.618814
[2 rows x 5 columns]
2025-05-07 17:50:58,644 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-05-07 17:50:58,650 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3733 2025-05-03 77996.67
3734 2025-05-04 77996.67
3735 2025-05-05 77996.67
3736 2025-05-06 78233.33
3737 2025-05-07 78520.00
2025-05-07 17:50:58,722 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date ... updated_at
3739 2025-05-06 ... 2025-05-07 17:50:58.715988
3740 2025-05-07 ... 2025-05-07 17:50:58.715988
[2 rows x 5 columns]
2025-05-07 17:50:58,741 - 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-07 17:50:59,286 - 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-07 17:50:59,339 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-05-07 17:50:59,339 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-05-07 17:50:59,345 - 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-07 17:50:59,406 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-05-07 17:50:59,406 - 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-07 17:50:59,966 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2711 2025-05-03 261175.0
2712 2025-05-04 261175.0
2713 2025-05-05 261175.0
2714 2025-05-06 260362.5
2715 2025-05-07 261137.5
2025-05-07 17:51:00,026 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2714 2025-05-06 ... 2025-05-07 17:51:00.019398
2715 2025-05-07 ... 2025-05-07 17:51:00.019398
[2 rows x 5 columns]
2025-05-07 17:51:00,044 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-05-07 17:51:00,051 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2711 2025-05-03 261175.0
2712 2025-05-04 261175.0
2713 2025-05-05 261175.0
2714 2025-05-06 260362.5
2715 2025-05-07 261137.5
2025-05-07 17:51:00,110 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2717 2025-05-06 ... 2025-05-07 17:51:00.104019
2718 2025-05-07 ... 2025-05-07 17:51:00.104019
[2 rows x 5 columns]
2025-05-07 17:51:00,128 - 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-07 17:51:00,737 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3732 2025-05-03 22904.0
3733 2025-05-04 22904.0
3734 2025-05-05 22904.0
3735 2025-05-06 22864.0
3736 2025-05-07 22758.0
2025-05-07 17:51:00,808 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3735 2025-05-06 22864.0 ... 2025-05-07 17:51:00.801065 2025-05-07 17:51:00.801452
3736 2025-05-07 22758.0 ... 2025-05-07 17:51:00.801065 2025-05-07 17:51:00.801452
[2 rows x 5 columns]
2025-05-07 17:51:00,826 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-05-07 17:51:00,832 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3732 2025-05-03 22904.0
3733 2025-05-04 22904.0
3734 2025-05-05 22904.0
3735 2025-05-06 22864.0
3736 2025-05-07 22758.0
2025-05-07 17:51:00,904 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3738 2025-05-06 22864.0 ... 2025-05-07 17:51:00.897479 2025-05-07 17:51:00.897889
3739 2025-05-07 22758.0 ... 2025-05-07 17:51:00.897479 2025-05-07 17:51:00.897889
[2 rows x 5 columns]
2025-05-07 17:51:00,923 - 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-07 17:51:01,463 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3695 2025-05-03 3377.5
3696 2025-05-04 3377.5
3697 2025-05-05 3377.5
3698 2025-05-06 3377.5
3699 2025-05-07 3377.5
2025-05-07 17:51:01,536 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3698 2025-05-06 3377.5 ... 2025-05-07 17:51:01.528875 2025-05-07 17:51:01.529274
3699 2025-05-07 3377.5 ... 2025-05-07 17:51:01.528875 2025-05-07 17:51:01.529274
[2 rows x 5 columns]
2025-05-07 17:51:01,555 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-05-07 17:51:01,561 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3695 2025-05-03 3377.5
3696 2025-05-04 3377.5
3697 2025-05-05 3377.5
3698 2025-05-06 3377.5
3699 2025-05-07 3377.5
2025-05-07 17:51:01,634 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3701 2025-05-06 3377.5 ... 2025-05-07 17:51:01.627025 2025-05-07 17:51:01.627415
3702 2025-05-07 3377.5 ... 2025-05-07 17:51:01.627025 2025-05-07 17:51:01.627415
[2 rows x 5 columns]
2025-05-07 17:51:01,653 - 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-07 17:51:02,210 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1492 2025-05-03 4980.0
1493 2025-05-04 4980.0
1494 2025-05-05 4980.0
1495 2025-05-06 4967.5
1496 2025-05-07 4930.0
2025-05-07 17:51:02,254 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1495 2025-05-06 4967.5 ... 2025-05-07 17:51:02.246789 2025-05-07 17:51:02.247184
1496 2025-05-07 4930.0 ... 2025-05-07 17:51:02.246789 2025-05-07 17:51:02.247184
[2 rows x 5 columns]
2025-05-07 17:51:02,273 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-05-07 17:51:02,278 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1492 2025-05-03 4980.0
1493 2025-05-04 4980.0
1494 2025-05-05 4980.0
1495 2025-05-06 4967.5
1496 2025-05-07 4930.0
2025-05-07 17:51:02,324 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1498 2025-05-06 4967.5 ... 2025-05-07 17:51:02.316907 2025-05-07 17:51:02.317291
1499 2025-05-07 4930.0 ... 2025-05-07 17:51:02.316907 2025-05-07 17:51:02.317291
[2 rows x 5 columns]
2025-05-07 17:51:02,343 - 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-07 17:51:02,869 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2766 2025-05-03 2252.86
2767 2025-05-04 2252.86
2768 2025-05-05 2252.86
2769 2025-05-06 2272.86
2770 2025-05-07 2282.86
2025-05-07 17:51:02,929 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2769 2025-05-06 2272.86 ... 2025-05-07 17:51:02.921739 2025-05-07 17:51:02.922159
2770 2025-05-07 2282.86 ... 2025-05-07 17:51:02.921739 2025-05-07 17:51:02.922159
[2 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-07 17:51:02,971 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2768 2025-05-05 ... 2025-05-07 17:51:02.964105
[1 rows x 6 columns]
2025-05-07 17:51:02,995 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2766 2025-05-03 2252.86
2767 2025-05-04 2252.86
2768 2025-05-05 2252.86
2769 2025-05-06 2272.86
2770 2025-05-07 2282.86
2025-05-07 17:51:03,056 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2772 2025-05-06 2272.86 ... 2025-05-07 17:51:03.048679 2025-05-07 17:51:03.049089
2773 2025-05-07 2282.86 ... 2025-05-07 17:51:03.048679 2025-05-07 17:51:03.049089
[2 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-07 17:51:03,096 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2771 2025-05-05 ... 2025-05-07 17:51:03.089262
[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-07 17:51:03,709 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2766 2025-05-03 2252.86
2767 2025-05-04 2252.86
2768 2025-05-05 2252.86
2769 2025-05-06 2272.86
2770 2025-05-07 2904.00
2025-05-07 17:51:03,760 - 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-07 17:51:03,783 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2770 2025-05-07 ... 2025-05-07 17:51:03.776247
[1 rows x 6 columns]
2025-05-07 17:51:03,807 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2766 2025-05-03 2252.86
2767 2025-05-04 2252.86
2768 2025-05-05 2252.86
2769 2025-05-06 2272.86
2770 2025-05-07 2904.00
2025-05-07 17:51:03,859 - 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-07 17:51:03,881 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2773 2025-05-07 ... 2025-05-07 17:51:03.874178
[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-07 17:51:04,418 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3123 2025-05-03 9378.33
3124 2025-05-04 9378.33
3125 2025-05-05 9378.33
3126 2025-05-06 9330.00
3127 2025-05-07 9430.00
2025-05-07 17:51:04,476 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-05-07 17:51:04,476 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-05-07 17:51:04,482 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3123 2025-05-03 9378.33
3124 2025-05-04 9378.33
3125 2025-05-05 9378.33
3126 2025-05-06 9330.00
3127 2025-05-07 9430.00
2025-05-07 17:51:04,542 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-05-07 17:51:04,542 - 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-07 17:51:05,130 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1807 2025-05-03 4331.67
1808 2025-05-04 4331.67
1809 2025-05-05 4331.67
1810 2025-05-06 4331.67
1811 2025-05-07 4340.00
2025-05-07 17:51:05,178 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1810 2025-05-06 4331.67 ... 2025-05-07 17:51:05.170792 2025-05-07 17:51:05.171183
1811 2025-05-07 4340.00 ... 2025-05-07 17:51:05.170792 2025-05-07 17:51:05.171183
[2 rows x 5 columns]
2025-05-07 17:51:05,197 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-05-07 17:51:05,203 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1807 2025-05-03 4331.67
1808 2025-05-04 4331.67
1809 2025-05-05 4331.67
1810 2025-05-06 4331.67
1811 2025-05-07 4340.00
2025-05-07 17:51:05,254 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1813 2025-05-06 4331.67 ... 2025-05-07 17:51:05.245581 2025-05-07 17:51:05.246075
1814 2025-05-07 4340.00 ... 2025-05-07 17:51:05.245581 2025-05-07 17:51:05.246075
[2 rows x 5 columns]
2025-05-07 17:51:05,273 - 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-07 17:51:05,819 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1816 2025-05-03 6250.0
1817 2025-05-04 6250.0
1818 2025-05-05 6250.0
1819 2025-05-06 6250.0
1820 2025-05-07 6200.0
2025-05-07 17:51:05,866 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1819 2025-05-06 6250.0 ... 2025-05-07 17:51:05.859488 2025-05-07 17:51:05.859893
1820 2025-05-07 6200.0 ... 2025-05-07 17:51:05.859488 2025-05-07 17:51:05.859893
[2 rows x 5 columns]
2025-05-07 17:51:05,887 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-05-07 17:51:05,893 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1816 2025-05-03 6250.0
1817 2025-05-04 6250.0
1818 2025-05-05 6250.0
1819 2025-05-06 6250.0
1820 2025-05-07 6200.0
2025-05-07 17:51:05,939 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1822 2025-05-06 6250.0 ... 2025-05-07 17:51:05.932855 2025-05-07 17:51:05.933234
1823 2025-05-07 6200.0 ... 2025-05-07 17:51:05.932855 2025-05-07 17:51:05.933234
[2 rows x 5 columns]
2025-05-07 17:51:05,958 - 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-07 17:51:06,527 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3484 2025-05-03 8760.0
3485 2025-05-04 8760.0
3486 2025-05-05 8760.0
3487 2025-05-06 8678.0
3488 2025-05-07 8584.0
2025-05-07 17:51:06,595 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3487 2025-05-06 8678.0 ... 2025-05-07 17:51:06.588398 2025-05-07 17:51:06.588806
3488 2025-05-07 8584.0 ... 2025-05-07 17:51:06.588398 2025-05-07 17:51:06.588806
[2 rows x 5 columns]
2025-05-07 17:51:06,614 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-05-07 17:51:06,620 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3484 2025-05-03 8760.0
3485 2025-05-04 8760.0
3486 2025-05-05 8760.0
3487 2025-05-06 8678.0
3488 2025-05-07 8584.0
2025-05-07 17:51:06,688 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3490 2025-05-06 8678.0 ... 2025-05-07 17:51:06.681700 2025-05-07 17:51:06.682108
3491 2025-05-07 8584.0 ... 2025-05-07 17:51:06.681700 2025-05-07 17:51:06.682108
[2 rows x 5 columns]
2025-05-07 17:51:06,706 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data