=========================================================================
2025-05-09 17:50:26 Fri 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-09 17:50:28,976 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3294 2025-05-05 3183.22
3295 2025-05-06 3176.33
3296 2025-05-07 3177.22
3297 2025-05-08 3162.78
3298 2025-05-09 3141.44
2025-05-09 17:50:29,052 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3298 2025-05-09 3141.44 ... 2025-05-09 17:50:29.044417 2025-05-09 17:50:29.044862
[1 rows x 5 columns]
2025-05-09 17:50:29,074 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-05-09 17:50:29,081 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3294 2025-05-05 3183.22
3295 2025-05-06 3176.33
3296 2025-05-07 3177.22
3297 2025-05-08 3162.78
3298 2025-05-09 3141.44
2025-05-09 17:50:29,150 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3301 2025-05-09 3141.44 ... 2025-05-09 17:50:29.142158 2025-05-09 17:50:29.142544
[1 rows x 5 columns]
2025-05-09 17:50:29,170 - 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-09 17:50:29,706 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3515 2025-05-05 2440.00
3516 2025-05-06 2428.75
3517 2025-05-07 2410.00
3518 2025-05-08 2390.00
3519 2025-05-09 2402.50
2025-05-09 17:50:29,786 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3519 2025-05-09 2402.5 ... 2025-05-09 17:50:29.775619 2025-05-09 17:50:29.776219
[1 rows x 5 columns]
2025-05-09 17:50:29,806 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-05-09 17:50:29,812 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3515 2025-05-05 2440.00
3516 2025-05-06 2428.75
3517 2025-05-07 2410.00
3518 2025-05-08 2390.00
3519 2025-05-09 2402.50
2025-05-09 17:50:29,883 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3523 2025-05-09 2402.5 ... 2025-05-09 17:50:29.875841 2025-05-09 17:50:29.876259
[1 rows x 5 columns]
2025-05-09 17:50:29,902 - 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-09 17:50:30,510 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
855 2025-05-05 4582.50
856 2025-05-06 4529.17
857 2025-05-07 4555.84
858 2025-05-08 4688.34
859 2025-05-09 4750.84
2025-05-09 17:50:30,546 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
859 2025-05-09 4750.84 ... 2025-05-09 17:50:30.539178 2025-05-09 17:50:30.539562
[1 rows x 5 columns]
2025-05-09 17:50:30,565 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-05-09 17:50:30,571 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
855 2025-05-05 4582.50
856 2025-05-06 4529.17
857 2025-05-07 4555.84
858 2025-05-08 4688.34
859 2025-05-09 4750.84
2025-05-09 17:50:30,605 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
859 2025-05-09 4750.84 ... 2025-05-09 17:50:30.598895 2025-05-09 17:50:30.599279
[1 rows x 5 columns]
2025-05-09 17:50:30,624 - 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-09 17:50:31,249 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3734 2025-05-05 14308.33
3735 2025-05-06 14593.33
3736 2025-05-07 14578.33
3737 2025-05-08 14458.33
3738 2025-05-09 14408.33
2025-05-09 17:50:31,323 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3738 2025-05-09 ... 2025-05-09 17:50:31.316153
[1 rows x 5 columns]
2025-05-09 17:50:31,343 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-05-09 17:50:31,349 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3734 2025-05-05 14308.33
3735 2025-05-06 14593.33
3736 2025-05-07 14578.33
3737 2025-05-08 14458.33
3738 2025-05-09 14408.33
2025-05-09 17:50:31,424 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3741 2025-05-09 ... 2025-05-09 17:50:31.417095
[1 rows x 5 columns]
2025-05-09 17:50:31,443 - 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-09 17:50:32,001 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3066 2025-05-05 778.11
3067 2025-05-06 781.44
3068 2025-05-07 789.44
3069 2025-05-08 776.22
3070 2025-05-09 770.89
2025-05-09 17:50:32,069 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3070 2025-05-09 770.89 ... 2025-05-09 17:50:32.061549 2025-05-09 17:50:32.061997
[1 rows x 5 columns]
2025-05-09 17:50:32,088 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-05-09 17:50:32,094 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3066 2025-05-05 778.11
3067 2025-05-06 781.44
3068 2025-05-07 789.44
3069 2025-05-08 776.22
3070 2025-05-09 770.89
2025-05-09 17:50:32,158 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3073 2025-05-09 770.89 ... 2025-05-09 17:50:32.150984 2025-05-09 17:50:32.151392
[1 rows x 5 columns]
2025-05-09 17:50:32,177 - 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-09 17:50:32,748 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3269 2025-05-05 1246.4
3270 2025-05-06 1246.4
3271 2025-05-07 1214.4
3272 2025-05-08 1214.4
3273 2025-05-09 1214.4
2025-05-09 17:50:32,815 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3273 2025-05-09 1214.4 ... 2025-05-09 17:50:32.808096 2025-05-09 17:50:32.808486
[1 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-09 17:50:34,828 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-05-09 17:50:34.819617
21 2013-01-04 ... 2025-05-09 17:50:34.819617
54 2013-02-27 ... 2025-05-09 17:50:34.819617
60 2013-03-07 ... 2025-05-09 17:50:34.819617
61 2013-03-08 ... 2025-05-09 17:50:34.819617
[5 rows x 6 columns]
2025-05-09 17:50:34,988 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3269 2025-05-05 1246.4
3270 2025-05-06 1246.4
3271 2025-05-07 1214.4
3272 2025-05-08 1214.4
3273 2025-05-09 1214.4
2025-05-09 17:50:35,055 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3277 2025-05-09 1214.4 ... 2025-05-09 17:50:35.047958 2025-05-09 17:50:35.048354
[1 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-09 17:50:37,067 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-05-09 17:50:37.058957
21 2013-01-04 ... 2025-05-09 17:50:37.058957
54 2013-02-27 ... 2025-05-09 17:50:37.058957
60 2013-03-07 ... 2025-05-09 17:50:37.058957
61 2013-03-08 ... 2025-05-09 17:50:37.058957
[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-09 17:50:37,863 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1614 2025-05-05 7680.0
1615 2025-05-06 7650.0
1616 2025-05-07 7650.0
1617 2025-05-08 7686.0
1618 2025-05-09 7680.0
2025-05-09 17:50:37,909 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1618 2025-05-09 7680.0 ... 2025-05-09 17:50:37.902142 2025-05-09 17:50:37.902538
[1 rows x 5 columns]
2025-05-09 17:50:37,928 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-05-09 17:50:37,934 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1614 2025-05-05 7680.0
1615 2025-05-06 7650.0
1616 2025-05-07 7650.0
1617 2025-05-08 7686.0
1618 2025-05-09 7680.0
2025-05-09 17:50:37,980 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1621 2025-05-09 7680.0 ... 2025-05-09 17:50:37.973036 2025-05-09 17:50:37.973425
[1 rows x 5 columns]
2025-05-09 17:50:37,999 - 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-09 17:50:38,834 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3725 2025-05-05 6160.00
3726 2025-05-06 6156.67
3727 2025-05-07 6156.67
3728 2025-05-08 6156.67
3729 2025-05-09 6146.67
2025-05-09 17:50:38,906 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3729 2025-05-09 6146.67 ... 2025-05-09 17:50:38.899379 2025-05-09 17:50:38.899797
[1 rows x 5 columns]
2025-05-09 17:50:38,926 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-05-09 17:50:38,932 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3725 2025-05-05 6160.00
3726 2025-05-06 6156.67
3727 2025-05-07 6156.67
3728 2025-05-08 6156.67
3729 2025-05-09 6146.67
2025-05-09 17:50:39,005 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3733 2025-05-09 6146.67 ... 2025-05-09 17:50:38.998021 2025-05-09 17:50:38.998414
[1 rows x 5 columns]
2025-05-09 17:50:39,024 - 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-09 17:50:39,729 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1615 2025-05-05 13050.0
1616 2025-05-06 13062.5
1617 2025-05-07 13062.5
1618 2025-05-08 13042.5
1619 2025-05-09 13042.5
2025-05-09 17:50:39,784 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1619 2025-05-09 13042.5 ... 2025-05-09 17:50:39.773206 2025-05-09 17:50:39.773659
[1 rows x 5 columns]
2025-05-09 17:50:39,804 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-05-09 17:50:39,810 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1615 2025-05-05 13050.0
1616 2025-05-06 13062.5
1617 2025-05-07 13062.5
1618 2025-05-08 13042.5
1619 2025-05-09 13042.5
2025-05-09 17:50:39,857 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1622 2025-05-09 13042.5 ... 2025-05-09 17:50:39.849532 2025-05-09 17:50:39.849938
[1 rows x 5 columns]
2025-05-09 17:50:39,876 - 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-09 17:50:40,468 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3125 2025-05-05 9378.33
3126 2025-05-06 9330.00
3127 2025-05-07 9430.00
3128 2025-05-08 9471.67
3129 2025-05-09 9463.33
2025-05-09 17:50:40,532 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date value ... created_at updated_at
3129 2025-05-09 9463.33 ... 2025-05-09 17:50:40.524982 2025-05-09 17:50:40.525375
[1 rows x 5 columns]
2025-05-09 17:50:40,552 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-05-09 17:50:40,558 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3125 2025-05-05 9378.33
3126 2025-05-06 9330.00
3127 2025-05-07 9430.00
3128 2025-05-08 9471.67
3129 2025-05-09 9463.33
2025-05-09 17:50:40,622 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date value ... created_at updated_at
3133 2025-05-09 9463.33 ... 2025-05-09 17:50:40.615431 2025-05-09 17:50:40.615838
[1 rows x 5 columns]
2025-05-09 17:50:40,641 - 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-09 17:50:41,231 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3248 2025-05-05 2531.67
3249 2025-05-06 2511.67
3250 2025-05-07 2511.67
3251 2025-05-08 2550.00
3252 2025-05-09 2506.67
2025-05-09 17:50:41,297 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3252 2025-05-09 2506.67 ... 2025-05-09 17:50:41.290535 2025-05-09 17:50:41.290950
[1 rows x 5 columns]
2025-05-09 17:50:41,317 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-05-09 17:50:41,323 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3248 2025-05-05 2531.67
3249 2025-05-06 2511.67
3250 2025-05-07 2511.67
3251 2025-05-08 2550.00
3252 2025-05-09 2506.67
2025-05-09 17:50:41,390 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3256 2025-05-09 2506.67 ... 2025-05-09 17:50:41.382639 2025-05-09 17:50:41.383056
[1 rows x 5 columns]
2025-05-09 17:50:41,411 - 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-09 17:50:41,882 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1452 2025-05-05 1502.5
1453 2025-05-06 1502.5
1454 2025-05-07 1462.5
1455 2025-05-08 1462.5
1456 2025-05-09 1462.5
2025-05-09 17:50:41,925 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1456 2025-05-09 1462.5 ... 2025-05-09 17:50:41.918512 2025-05-09 17:50:41.918971
[1 rows x 5 columns]
2025-05-09 17:50:41,944 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-05-09 17:50:41,950 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1452 2025-05-05 1502.5
1453 2025-05-06 1502.5
1454 2025-05-07 1462.5
1455 2025-05-08 1462.5
1456 2025-05-09 1462.5
2025-05-09 17:50:41,993 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1460 2025-05-09 1462.5 ... 2025-05-09 17:50:41.986601 2025-05-09 17:50:41.987019
[1 rows x 5 columns]
2025-05-09 17:50:42,013 - 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-09 17:50:42,572 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1365 2025-05-05 6351.67
1366 2025-05-06 6313.75
1367 2025-05-07 6377.50
1368 2025-05-08 6364.79
1369 2025-05-09 6377.92
2025-05-09 17:50:42,614 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1369 2025-05-09 6377.92 ... 2025-05-09 17:50:42.606983 2025-05-09 17:50:42.607434
[1 rows x 5 columns]
2025-05-09 17:50:42,634 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-05-09 17:50:42,639 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1365 2025-05-05 6351.67
1366 2025-05-06 6313.75
1367 2025-05-07 6377.50
1368 2025-05-08 6364.79
1369 2025-05-09 6377.92
2025-05-09 17:50:42,682 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1373 2025-05-09 6377.92 ... 2025-05-09 17:50:42.674830 2025-05-09 17:50:42.675279
[1 rows x 5 columns]
2025-05-09 17:50:42,702 - 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-09 17:50:43,304 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3738 2025-05-05 3476.67
3739 2025-05-06 3270.00
3740 2025-05-07 3302.00
3741 2025-05-08 3300.00
3742 2025-05-09 3300.00
2025-05-09 17:50:43,376 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3742 2025-05-09 3300.0 ... 2025-05-09 17:50:43.368940 2025-05-09 17:50:43.369334
[1 rows x 5 columns]
2025-05-09 17:50:43,396 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-05-09 17:50:43,402 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3738 2025-05-05 3476.67
3739 2025-05-06 3270.00
3740 2025-05-07 3302.00
3741 2025-05-08 3300.00
3742 2025-05-09 3300.00
2025-05-09 17:50:43,475 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3745 2025-05-09 3300.0 ... 2025-05-09 17:50:43.467338 2025-05-09 17:50:43.467729
[1 rows x 5 columns]
2025-05-09 17:50:43,495 - 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-09 17:50:44,067 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3508 2025-05-05 8126.0
3509 2025-05-06 8056.0
3510 2025-05-07 8076.0
3511 2025-05-08 8056.0
3512 2025-05-09 8076.0
2025-05-09 17:50:44,137 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3512 2025-05-09 8076.0 ... 2025-05-09 17:50:44.130254 2025-05-09 17:50:44.130653
[1 rows x 5 columns]
2025-05-09 17:50:44,157 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-05-09 17:50:44,163 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3508 2025-05-05 8126.0
3509 2025-05-06 8056.0
3510 2025-05-07 8076.0
3511 2025-05-08 8056.0
3512 2025-05-09 8076.0
2025-05-09 17:50:44,235 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3515 2025-05-09 8076.0 ... 2025-05-09 17:50:44.227297 2025-05-09 17:50:44.227718
[1 rows x 5 columns]
2025-05-09 17:50:44,254 - 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-09 17:50:45,023 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3474 2025-05-05 4245.0
3475 2025-05-06 4230.0
3476 2025-05-07 4230.0
3477 2025-05-08 4230.0
3478 2025-05-09 4245.0
2025-05-09 17:50:45,091 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3478 2025-05-09 4245.0 ... 2025-05-09 17:50:45.083860 2025-05-09 17:50:45.084260
[1 rows x 5 columns]
2025-05-09 17:50:45,110 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-05-09 17:50:45,116 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3474 2025-05-05 4245.0
3475 2025-05-06 4230.0
3476 2025-05-07 4230.0
3477 2025-05-08 4230.0
3478 2025-05-09 4245.0
2025-05-09 17:50:45,186 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3481 2025-05-09 4245.0 ... 2025-05-09 17:50:45.178692 2025-05-09 17:50:45.179139
[1 rows x 5 columns]
2025-05-09 17:50:45,205 - 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-09 17:50:45,798 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2851 2025-05-05 5548.57
2852 2025-05-06 5548.57
2853 2025-05-07 5402.86
2854 2025-05-08 5402.86
2855 2025-05-09 5402.86
2025-05-09 17:50:45,858 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2855 2025-05-09 5402.86 ... 2025-05-09 17:50:45.851472 2025-05-09 17:50:45.851885
[1 rows x 5 columns]
2025-05-09 17:50:45,877 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-05-09 17:50:45,883 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2851 2025-05-05 5548.57
2852 2025-05-06 5548.57
2853 2025-05-07 5402.86
2854 2025-05-08 5402.86
2855 2025-05-09 5402.86
2025-05-09 17:50:45,944 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2859 2025-05-09 5402.86 ... 2025-05-09 17:50:45.936895 2025-05-09 17:50:45.937285
[1 rows x 5 columns]
2025-05-09 17:50:45,963 - 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-09 17:50:46,567 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3051 2025-05-05 3375.0
3052 2025-05-06 3375.0
3053 2025-05-07 3300.0
3054 2025-05-08 3225.0
3055 2025-05-09 3225.0
2025-05-09 17:50:46,632 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3055 2025-05-09 3225.0 ... 2025-05-09 17:50:46.624608 2025-05-09 17:50:46.625026
[1 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-09 17:50:46,785 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-05-09 17:50:46.777288
458 2015-09-21 ... 2025-05-09 17:50:46.777288
549 2016-02-03 ... 2025-05-09 17:50:46.777288
693 2016-09-05 ... 2025-05-09 17:50:46.777288
696 2016-09-08 ... 2025-05-09 17:50:46.777288
[5 rows x 6 columns]
2025-05-09 17:50:46,816 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3051 2025-05-05 3375.0
3052 2025-05-06 3375.0
3053 2025-05-07 3300.0
3054 2025-05-08 3225.0
3055 2025-05-09 3225.0
2025-05-09 17:50:46,881 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3058 2025-05-09 3225.0 ... 2025-05-09 17:50:46.873439 2025-05-09 17:50:46.873847
[1 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-09 17:50:47,034 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-05-09 17:50:47.026509
458 2015-09-21 ... 2025-05-09 17:50:47.026509
549 2016-02-03 ... 2025-05-09 17:50:47.026509
693 2016-09-05 ... 2025-05-09 17:50:47.026509
696 2016-09-08 ... 2025-05-09 17:50:47.026509
[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-09 17:50:47,908 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
855 2025-05-05 9880.0
856 2025-05-06 9780.0
857 2025-05-07 9690.0
858 2025-05-08 9640.0
859 2025-05-09 9640.0
2025-05-09 17:50:47,945 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
859 2025-05-09 9640.0 ... 2025-05-09 17:50:47.937590 2025-05-09 17:50:47.938016
[1 rows x 5 columns]
2025-05-09 17:50:47,964 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-05-09 17:50:47,970 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
855 2025-05-05 9880.0
856 2025-05-06 9780.0
857 2025-05-07 9690.0
858 2025-05-08 9640.0
859 2025-05-09 9640.0
2025-05-09 17:50:48,005 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
859 2025-05-09 9640.0 ... 2025-05-09 17:50:47.998406 2025-05-09 17:50:47.998813
[1 rows x 5 columns]
2025-05-09 17:50:48,025 - 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-09 17:50:48,649 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3734 2025-05-05 7553.33
3735 2025-05-06 7500.00
3736 2025-05-07 7491.67
3737 2025-05-08 7465.00
3738 2025-05-09 7458.33
2025-05-09 17:50:48,725 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3738 2025-05-09 7458.33 ... 2025-05-09 17:50:48.715573 2025-05-09 17:50:48.716084
[1 rows x 5 columns]
2025-05-09 17:50:48,745 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-05-09 17:50:48,751 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3734 2025-05-05 7553.33
3735 2025-05-06 7500.00
3736 2025-05-07 7491.67
3737 2025-05-08 7465.00
3738 2025-05-09 7458.33
2025-05-09 17:50:48,826 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3741 2025-05-09 7458.33 ... 2025-05-09 17:50:48.818714 2025-05-09 17:50:48.819339
[1 rows x 5 columns]
2025-05-09 17:50:48,845 - 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-09 17:50:49,510 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3072 2025-05-05 3647.5
3073 2025-05-06 3590.0
3074 2025-05-07 3590.0
3075 2025-05-08 3582.5
3076 2025-05-09 3585.0
2025-05-09 17:50:49,575 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3077 2025-05-09 3585.0 ... 2025-05-09 17:50:49.568008 2025-05-09 17:50:49.568445
[1 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-09 17:50:49,611 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-05-09 17:50:49.604003
[1 rows x 6 columns]
2025-05-09 17:50:49,637 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3072 2025-05-05 3647.5
3073 2025-05-06 3590.0
3074 2025-05-07 3590.0
3075 2025-05-08 3582.5
3076 2025-05-09 3585.0
2025-05-09 17:50:49,702 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3079 2025-05-09 3585.0 ... 2025-05-09 17:50:49.695313 2025-05-09 17:50:49.695702
[1 rows x 5 columns]
2025-05-09 17:50:49,721 - 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-09 17:50:50,610 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3737 2025-05-05 20073.33
3738 2025-05-06 20073.33
3739 2025-05-07 19630.00
3740 2025-05-08 19630.00
3741 2025-05-09 19630.00
2025-05-09 17:50:50,683 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date value ... created_at updated_at
3741 2025-05-09 19630.0 ... 2025-05-09 17:50:50.676156 2025-05-09 17:50:50.676586
[1 rows x 5 columns]
2025-05-09 17:50:50,703 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-05-09 17:50:50,708 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3737 2025-05-05 20073.33
3738 2025-05-06 20073.33
3739 2025-05-07 19630.00
3740 2025-05-08 19630.00
3741 2025-05-09 19630.00
2025-05-09 17:50:50,783 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date value ... created_at updated_at
3744 2025-05-09 19630.0 ... 2025-05-09 17:50:50.776543 2025-05-09 17:50:50.776952
[1 rows x 5 columns]
2025-05-09 17:50:50,803 - 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-09 17:50:51,375 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2851 2025-05-05 5640.0
2852 2025-05-06 5610.0
2853 2025-05-07 5586.0
2854 2025-05-08 5590.0
2855 2025-05-09 5634.0
2025-05-09 17:50:51,436 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2855 2025-05-09 5634.0 ... 2025-05-09 17:50:51.428818 2025-05-09 17:50:51.429225
[1 rows x 5 columns]
2025-05-09 17:50:51,454 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-05-09 17:50:51,460 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2851 2025-05-05 5640.0
2852 2025-05-06 5610.0
2853 2025-05-07 5586.0
2854 2025-05-08 5590.0
2855 2025-05-09 5634.0
2025-05-09 17:50:51,520 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2859 2025-05-09 5634.0 ... 2025-05-09 17:50:51.513170 2025-05-09 17:50:51.513554
[1 rows x 5 columns]
2025-05-09 17:50:51,539 - 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-09 17:50:52,475 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2126 2025-05-05 23775.0
2127 2025-05-06 23775.0
2128 2025-05-07 23775.0
2129 2025-05-08 23775.0
2130 2025-05-09 23775.0
2025-05-09 17:50:52,527 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2130 2025-05-09 23775.0 ... 2025-05-09 17:50:52.519866 2025-05-09 17:50:52.520258
[1 rows x 5 columns]
2025-05-09 17:50:52,546 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-05-09 17:50:52,552 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2126 2025-05-05 23775.0
2127 2025-05-06 23775.0
2128 2025-05-07 23775.0
2129 2025-05-08 23775.0
2130 2025-05-09 23775.0
2025-05-09 17:50:52,604 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2134 2025-05-09 23775.0 ... 2025-05-09 17:50:52.596863 2025-05-09 17:50:52.597260
[1 rows x 5 columns]
2025-05-09 17:50:52,623 - 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-09 17:50:53,160 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1641 2025-05-05 1875.00
1642 2025-05-06 1893.33
1643 2025-05-07 1906.67
1644 2025-05-08 1911.67
1645 2025-05-09 1921.67
2025-05-09 17:50:53,206 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1645 2025-05-09 1921.67 ... 2025-05-09 17:50:53.198919 2025-05-09 17:50:53.199316
[1 rows x 5 columns]
2025-05-09 17:50:53,225 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-05-09 17:50:53,230 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1641 2025-05-05 1875.00
1642 2025-05-06 1893.33
1643 2025-05-07 1906.67
1644 2025-05-08 1911.67
1645 2025-05-09 1921.67
2025-05-09 17:50:53,276 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1649 2025-05-09 1921.67 ... 2025-05-09 17:50:53.269606 2025-05-09 17:50:53.270026
[1 rows x 5 columns]
2025-05-09 17:50:53,295 - 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-09 17:50:54,171 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2713 2025-05-05 125175.00
2714 2025-05-06 125775.00
2715 2025-05-07 125683.33
2716 2025-05-08 125050.00
2717 2025-05-09 124758.33
2025-05-09 17:50:54,229 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2717 2025-05-09 ... 2025-05-09 17:50:54.222869
[1 rows x 5 columns]
2025-05-09 17:50:54,248 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-05-09 17:50:54,254 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2713 2025-05-05 125175.00
2714 2025-05-06 125775.00
2715 2025-05-07 125683.33
2716 2025-05-08 125050.00
2717 2025-05-09 124758.33
2025-05-09 17:50:54,313 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2720 2025-05-09 ... 2025-05-09 17:50:54.307463
[1 rows x 5 columns]
2025-05-09 17:50:54,332 - 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-09 17:50:54,910 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3738 2025-05-05 4679.0
3739 2025-05-06 4653.0
3740 2025-05-07 4665.0
3741 2025-05-08 4632.0
3742 2025-05-09 4629.0
2025-05-09 17:50:54,984 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3742 2025-05-09 4629.0 ... 2025-05-09 17:50:54.977334 2025-05-09 17:50:54.977731
[1 rows x 5 columns]
2025-05-09 17:50:55,004 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-05-09 17:50:55,010 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3738 2025-05-05 4679.0
3739 2025-05-06 4653.0
3740 2025-05-07 4665.0
3741 2025-05-08 4632.0
3742 2025-05-09 4629.0
2025-05-09 17:50:55,086 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3745 2025-05-09 4629.0 ... 2025-05-09 17:50:55.079284 2025-05-09 17:50:55.079669
[1 rows x 5 columns]
2025-05-09 17:50:55,177 - 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-09 17:50:55,808 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
2977 2025-05-05 7481.67
2978 2025-05-06 7481.67
2979 2025-05-07 7481.67
2980 2025-05-08 7440.00
2981 2025-05-09 7440.00
2025-05-09 17:50:55,871 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
2981 2025-05-09 7440.0 ... 2025-05-09 17:50:55.864238 2025-05-09 17:50:55.864631
[1 rows x 5 columns]
2025-05-09 17:50:55,890 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-05-09 17:50:55,896 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
2977 2025-05-05 7481.67
2978 2025-05-06 7481.67
2979 2025-05-07 7481.67
2980 2025-05-08 7440.00
2981 2025-05-09 7440.00
2025-05-09 17:50:55,958 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
2984 2025-05-09 7440.0 ... 2025-05-09 17:50:55.951147 2025-05-09 17:50:55.951532
[1 rows x 5 columns]
2025-05-09 17:50:55,977 - 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-09 17:50:56,547 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3739 2025-05-05 14208.83
3740 2025-05-06 14138.67
3741 2025-05-07 14124.33
3742 2025-05-08 14150.33
3743 2025-05-09 14136.00
2025-05-09 17:50:56,619 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date value ... created_at updated_at
3743 2025-05-09 14136.0 ... 2025-05-09 17:50:56.611979 2025-05-09 17:50:56.612370
[1 rows x 5 columns]
2025-05-09 17:50:56,639 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-05-09 17:50:56,645 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3739 2025-05-05 14208.83
3740 2025-05-06 14138.67
3741 2025-05-07 14124.33
3742 2025-05-08 14150.33
3743 2025-05-09 14136.00
2025-05-09 17:50:56,720 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date value ... created_at updated_at
3747 2025-05-09 14136.0 ... 2025-05-09 17:50:56.711344 2025-05-09 17:50:56.711982
[1 rows x 5 columns]
2025-05-09 17:50:56,740 - 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-09 17:50:57,303 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3684 2025-05-05 16812.50
3685 2025-05-06 16706.25
3686 2025-05-07 16637.50
3687 2025-05-08 16737.50
3688 2025-05-09 16718.75
2025-05-09 17:50:57,377 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date ... updated_at
3688 2025-05-09 ... 2025-05-09 17:50:57.369189
[1 rows x 5 columns]
2025-05-09 17:50:57,398 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-05-09 17:50:57,406 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3684 2025-05-05 16812.50
3685 2025-05-06 16706.25
3686 2025-05-07 16637.50
3687 2025-05-08 16737.50
3688 2025-05-09 16718.75
2025-05-09 17:50:57,479 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date ... updated_at
3691 2025-05-09 ... 2025-05-09 17:50:57.472789
[1 rows x 5 columns]
2025-05-09 17:50:57,498 - 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-09 17:50:58,025 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
2959 2025-05-05 3276.67
2960 2025-05-06 3263.33
2961 2025-05-07 3283.33
2962 2025-05-08 3276.67
2963 2025-05-09 3273.33
2025-05-09 17:50:58,088 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
2963 2025-05-09 3273.33 ... 2025-05-09 17:50:58.080601 2025-05-09 17:50:58.081040
[1 rows x 5 columns]
2025-05-09 17:50:58,107 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-05-09 17:50:58,113 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
2959 2025-05-05 3276.67
2960 2025-05-06 3263.33
2961 2025-05-07 3283.33
2962 2025-05-08 3276.67
2963 2025-05-09 3273.33
2025-05-09 17:50:58,184 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
2966 2025-05-09 3273.33 ... 2025-05-09 17:50:58.177257 2025-05-09 17:50:58.177643
[1 rows x 5 columns]
2025-05-09 17:50:58,203 - 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-09 17:50:58,788 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3239 2025-05-05 5462.5
3240 2025-05-06 5425.0
3241 2025-05-07 5425.0
3242 2025-05-08 5450.0
3243 2025-05-09 5470.0
2025-05-09 17:50:58,871 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3243 2025-05-09 5470.0 ... 2025-05-09 17:50:58.859994 2025-05-09 17:50:58.860657
[1 rows x 5 columns]
2025-05-09 17:50:58,891 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-05-09 17:50:58,897 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3239 2025-05-05 5462.5
3240 2025-05-06 5425.0
3241 2025-05-07 5425.0
3242 2025-05-08 5450.0
3243 2025-05-09 5470.0
2025-05-09 17:50:58,972 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3730 2025-05-09 5470.0 ... 2025-05-09 17:50:58.964649 2025-05-09 17:50:58.965080
[1 rows x 5 columns]
2025-05-09 17:50:58,992 - 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-09 17:50:59,518 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1303 2025-05-05 14830.0
1304 2025-05-06 14820.0
1305 2025-05-07 14830.0
1306 2025-05-08 14830.0
1307 2025-05-09 14780.0
2025-05-09 17:50:59,560 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1307 2025-05-09 14780.0 ... 2025-05-09 17:50:59.553379 2025-05-09 17:50:59.553788
[1 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-09 17:50:59,801 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-05-09 17:50:59.793470
117 2021-07-06 ... 2025-05-09 17:50:59.793470
121 2021-07-12 ... 2025-05-09 17:50:59.793470
122 2021-07-13 ... 2025-05-09 17:50:59.793470
194 2021-11-01 ... 2025-05-09 17:50:59.793470
[5 rows x 6 columns]
2025-05-09 17:50:59,840 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1303 2025-05-05 14830.0
1304 2025-05-06 14820.0
1305 2025-05-07 14830.0
1306 2025-05-08 14830.0
1307 2025-05-09 14780.0
2025-05-09 17:50:59,882 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1310 2025-05-09 14780.0 ... 2025-05-09 17:50:59.875343 2025-05-09 17:50:59.875718
[1 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-09 17:51:00,133 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-05-09 17:51:00.125207
117 2021-07-06 ... 2025-05-09 17:51:00.125207
121 2021-07-12 ... 2025-05-09 17:51:00.125207
122 2021-07-13 ... 2025-05-09 17:51:00.125207
194 2021-11-01 ... 2025-05-09 17:51:00.125207
[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-09 17:51:00,984 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3735 2025-05-05 77996.67
3736 2025-05-06 78233.33
3737 2025-05-07 78520.00
3738 2025-05-08 78458.33
3739 2025-05-09 78258.33
2025-05-09 17:51:01,057 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date ... updated_at
3739 2025-05-09 ... 2025-05-09 17:51:01.050779
[1 rows x 5 columns]
2025-05-09 17:51:01,077 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-05-09 17:51:01,082 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3735 2025-05-05 77996.67
3736 2025-05-06 78233.33
3737 2025-05-07 78520.00
3738 2025-05-08 78458.33
3739 2025-05-09 78258.33
2025-05-09 17:51:01,154 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date ... updated_at
3742 2025-05-09 ... 2025-05-09 17:51:01.147965
[1 rows x 5 columns]
2025-05-09 17:51:01,173 - 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-09 17:51:01,736 - 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-09 17:51:01,796 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-05-09 17:51:01,796 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-05-09 17:51:01,805 - 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-09 17:51:01,868 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-05-09 17:51:01,868 - 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-09 17:51:02,495 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2713 2025-05-05 261175.0
2714 2025-05-06 260362.5
2715 2025-05-07 261137.5
2716 2025-05-08 262050.0
2717 2025-05-09 259500.0
2025-05-09 17:51:02,554 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2717 2025-05-09 ... 2025-05-09 17:51:02.548283
[1 rows x 5 columns]
2025-05-09 17:51:02,574 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-05-09 17:51:02,580 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2713 2025-05-05 261175.0
2714 2025-05-06 260362.5
2715 2025-05-07 261137.5
2716 2025-05-08 262050.0
2717 2025-05-09 259500.0
2025-05-09 17:51:02,640 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2720 2025-05-09 ... 2025-05-09 17:51:02.634282
[1 rows x 5 columns]
2025-05-09 17:51:02,659 - 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-09 17:51:03,332 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3734 2025-05-05 22904.0
3735 2025-05-06 22864.0
3736 2025-05-07 22758.0
3737 2025-05-08 22832.0
3738 2025-05-09 22756.0
2025-05-09 17:51:03,406 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3738 2025-05-09 22756.0 ... 2025-05-09 17:51:03.398220 2025-05-09 17:51:03.398611
[1 rows x 5 columns]
2025-05-09 17:51:03,426 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-05-09 17:51:03,432 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3734 2025-05-05 22904.0
3735 2025-05-06 22864.0
3736 2025-05-07 22758.0
3737 2025-05-08 22832.0
3738 2025-05-09 22756.0
2025-05-09 17:51:03,508 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3741 2025-05-09 22756.0 ... 2025-05-09 17:51:03.500500 2025-05-09 17:51:03.500941
[1 rows x 5 columns]
2025-05-09 17:51:03,527 - 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-09 17:51:04,256 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3697 2025-05-05 3377.5
3698 2025-05-06 3377.5
3699 2025-05-07 3377.5
3700 2025-05-08 3367.5
3701 2025-05-09 3367.5
2025-05-09 17:51:04,329 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3701 2025-05-09 3367.5 ... 2025-05-09 17:51:04.321683 2025-05-09 17:51:04.322103
[1 rows x 5 columns]
2025-05-09 17:51:04,348 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-05-09 17:51:04,354 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3697 2025-05-05 3377.5
3698 2025-05-06 3377.5
3699 2025-05-07 3377.5
3700 2025-05-08 3367.5
3701 2025-05-09 3367.5
2025-05-09 17:51:04,428 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3704 2025-05-09 3367.5 ... 2025-05-09 17:51:04.420966 2025-05-09 17:51:04.421377
[1 rows x 5 columns]
2025-05-09 17:51:04,447 - 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-09 17:51:05,237 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1494 2025-05-05 4980.0
1495 2025-05-06 4967.5
1496 2025-05-07 4930.0
1497 2025-05-08 4917.5
1498 2025-05-09 4917.5
2025-05-09 17:51:05,281 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1498 2025-05-09 4917.5 ... 2025-05-09 17:51:05.273928 2025-05-09 17:51:05.274318
[1 rows x 5 columns]
2025-05-09 17:51:05,300 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-05-09 17:51:05,305 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1494 2025-05-05 4980.0
1495 2025-05-06 4967.5
1496 2025-05-07 4930.0
1497 2025-05-08 4917.5
1498 2025-05-09 4917.5
2025-05-09 17:51:05,349 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1501 2025-05-09 4917.5 ... 2025-05-09 17:51:05.342397 2025-05-09 17:51:05.342799
[1 rows x 5 columns]
2025-05-09 17:51:05,368 - 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-09 17:51:06,930 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2768 2025-05-05 2252.86
2769 2025-05-06 2272.86
2770 2025-05-07 2282.86
2771 2025-05-08 2285.71
2772 2025-05-09 2292.86
2025-05-09 17:51:06,993 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2772 2025-05-09 2292.86 ... 2025-05-09 17:51:06.985507 2025-05-09 17:51:06.985968
[1 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-09 17:51:07,039 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2771 2025-05-08 ... 2025-05-09 17:51:07.031691
[1 rows x 6 columns]
2025-05-09 17:51:07,068 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2768 2025-05-05 2252.86
2769 2025-05-06 2272.86
2770 2025-05-07 2282.86
2771 2025-05-08 2285.71
2772 2025-05-09 2292.86
2025-05-09 17:51:07,129 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2775 2025-05-09 2292.86 ... 2025-05-09 17:51:07.121953 2025-05-09 17:51:07.122343
[1 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-09 17:51:07,172 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2774 2025-05-08 ... 2025-05-09 17:51:07.164534
[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-09 17:51:07,718 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2768 2025-05-05 2252.86
2769 2025-05-06 2272.86
2770 2025-05-07 2282.86
2771 2025-05-08 2285.71
2772 2025-05-09 2926.00
2025-05-09 17:51:07,770 - 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-09 17:51:07,793 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2772 2025-05-09 ... 2025-05-09 17:51:07.786093
[1 rows x 6 columns]
2025-05-09 17:51:07,819 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2768 2025-05-05 2252.86
2769 2025-05-06 2272.86
2770 2025-05-07 2282.86
2771 2025-05-08 2285.71
2772 2025-05-09 2926.00
2025-05-09 17:51:07,872 - IOOppi_data - INFO : save new data to db: IOOppi_cs_g: no new data
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-09 17:51:07,895 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2775 2025-05-09 ... 2025-05-09 17:51:07.887693
[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-09 17:51:08,457 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3125 2025-05-05 9378.33
3126 2025-05-06 9330.00
3127 2025-05-07 9430.00
3128 2025-05-08 9471.67
3129 2025-05-09 9463.33
2025-05-09 17:51:08,516 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-05-09 17:51:08,516 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-05-09 17:51:08,522 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3125 2025-05-05 9378.33
3126 2025-05-06 9330.00
3127 2025-05-07 9430.00
3128 2025-05-08 9471.67
3129 2025-05-09 9463.33
2025-05-09 17:51:08,579 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-05-09 17:51:08,580 - 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-09 17:51:09,163 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1809 2025-05-05 4331.67
1810 2025-05-06 4331.67
1811 2025-05-07 4340.00
1812 2025-05-08 4340.00
1813 2025-05-09 4340.00
2025-05-09 17:51:09,210 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1813 2025-05-09 4340.0 ... 2025-05-09 17:51:09.203235 2025-05-09 17:51:09.203621
[1 rows x 5 columns]
2025-05-09 17:51:09,230 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-05-09 17:51:09,235 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1809 2025-05-05 4331.67
1810 2025-05-06 4331.67
1811 2025-05-07 4340.00
1812 2025-05-08 4340.00
1813 2025-05-09 4340.00
2025-05-09 17:51:09,284 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1816 2025-05-09 4340.0 ... 2025-05-09 17:51:09.276872 2025-05-09 17:51:09.277270
[1 rows x 5 columns]
2025-05-09 17:51:09,303 - 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-09 17:51:09,822 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1818 2025-05-05 6250.0
1819 2025-05-06 6250.0
1820 2025-05-07 6200.0
1821 2025-05-08 6200.0
1822 2025-05-09 6200.0
2025-05-09 17:51:09,871 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1822 2025-05-09 6200.0 ... 2025-05-09 17:51:09.864072 2025-05-09 17:51:09.864462
[1 rows x 5 columns]
2025-05-09 17:51:09,892 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-05-09 17:51:09,898 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1818 2025-05-05 6250.0
1819 2025-05-06 6250.0
1820 2025-05-07 6200.0
1821 2025-05-08 6200.0
1822 2025-05-09 6200.0
2025-05-09 17:51:09,946 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1825 2025-05-09 6200.0 ... 2025-05-09 17:51:09.939561 2025-05-09 17:51:09.939980
[1 rows x 5 columns]
2025-05-09 17:51:09,965 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-09 17:51:10,595 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3486 2025-05-05 8760.0
3487 2025-05-06 8678.0
3488 2025-05-07 8584.0
3489 2025-05-08 8538.0
3490 2025-05-09 8510.0
2025-05-09 17:51:10,664 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3490 2025-05-09 8510.0 ... 2025-05-09 17:51:10.656939 2025-05-09 17:51:10.657330
[1 rows x 5 columns]
2025-05-09 17:51:10,683 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-05-09 17:51:10,689 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3486 2025-05-05 8760.0
3487 2025-05-06 8678.0
3488 2025-05-07 8584.0
3489 2025-05-08 8538.0
3490 2025-05-09 8510.0
2025-05-09 17:51:10,760 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3493 2025-05-09 8510.0 ... 2025-05-09 17:51:10.753335 2025-05-09 17:51:10.753794
[1 rows x 5 columns]
2025-05-09 17:51:10,780 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data