=========================================================================
2025-05-01 17:50:26 Thu START TASK.01 IOOppi_data update_data
=========================================================================
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-01 17:50:28,636 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3286 2025-04-27 3214.78
3287 2025-04-28 3204.56
3288 2025-04-29 3186.89
3289 2025-04-30 3183.22
3290 2025-05-01 3183.22
2025-05-01 17:50:28,707 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3290 2025-05-01 3183.22 ... 2025-05-01 17:50:28.699498 2025-05-01 17:50:28.699914
[1 rows x 5 columns]
2025-05-01 17:50:28,727 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-05-01 17:50:28,734 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3286 2025-04-27 3214.78
3287 2025-04-28 3204.56
3288 2025-04-29 3186.89
3289 2025-04-30 3183.22
3290 2025-05-01 3183.22
2025-05-01 17:50:28,801 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3293 2025-05-01 3183.22 ... 2025-05-01 17:50:28.793848 2025-05-01 17:50:28.794255
[1 rows x 5 columns]
2025-05-01 17:50:28,822 - 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-01 17:50:29,437 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3507 2025-04-27 2428.75
3508 2025-04-28 2451.25
3509 2025-04-29 2437.50
3510 2025-04-30 2440.00
3511 2025-05-01 2440.00
2025-05-01 17:50:29,506 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3511 2025-05-01 2440.0 ... 2025-05-01 17:50:29.499084 2025-05-01 17:50:29.499498
[1 rows x 5 columns]
2025-05-01 17:50:29,525 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-05-01 17:50:29,532 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3507 2025-04-27 2428.75
3508 2025-04-28 2451.25
3509 2025-04-29 2437.50
3510 2025-04-30 2440.00
3511 2025-05-01 2440.00
2025-05-01 17:50:29,603 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3515 2025-05-01 2440.0 ... 2025-05-01 17:50:29.595620 2025-05-01 17:50:29.596080
[1 rows x 5 columns]
2025-05-01 17:50:29,622 - 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-01 17:50:30,148 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
847 2025-04-27 4493.75
848 2025-04-28 4567.50
849 2025-04-29 4565.00
850 2025-04-30 4584.38
851 2025-05-01 4584.38
2025-05-01 17:50:30,184 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
851 2025-05-01 4584.38 ... 2025-05-01 17:50:30.177104 2025-05-01 17:50:30.177527
[1 rows x 5 columns]
2025-05-01 17:50:30,203 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-05-01 17:50:30,210 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
847 2025-04-27 4493.75
848 2025-04-28 4567.50
849 2025-04-29 4565.00
850 2025-04-30 4584.38
851 2025-05-01 4584.38
2025-05-01 17:50:30,247 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
851 2025-05-01 4584.38 ... 2025-05-01 17:50:30.239429 2025-05-01 17:50:30.239872
[1 rows x 5 columns]
2025-05-01 17:50:30,266 - 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-01 17:50:30,809 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3726 2025-04-27 14468.33
3727 2025-04-28 14488.33
3728 2025-04-29 14408.33
3729 2025-04-30 14308.33
3730 2025-05-01 14308.33
2025-05-01 17:50:30,880 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3730 2025-05-01 ... 2025-05-01 17:50:30.874403
[1 rows x 5 columns]
2025-05-01 17:50:30,899 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-05-01 17:50:30,905 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3726 2025-04-27 14468.33
3727 2025-04-28 14488.33
3728 2025-04-29 14408.33
3729 2025-04-30 14308.33
3730 2025-05-01 14308.33
2025-05-01 17:50:30,980 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3733 2025-05-01 ... 2025-05-01 17:50:30.973665
[1 rows x 5 columns]
2025-05-01 17:50:30,999 - 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-01 17:50:31,567 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3058 2025-04-27 777.33
3059 2025-04-28 778.56
3060 2025-04-29 779.44
3061 2025-04-30 778.11
3062 2025-05-01 778.11
2025-05-01 17:50:31,631 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3062 2025-05-01 778.11 ... 2025-05-01 17:50:31.624415 2025-05-01 17:50:31.624815
[1 rows x 5 columns]
2025-05-01 17:50:31,651 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-05-01 17:50:31,657 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3058 2025-04-27 777.33
3059 2025-04-28 778.56
3060 2025-04-29 779.44
3061 2025-04-30 778.11
3062 2025-05-01 778.11
2025-05-01 17:50:31,721 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3065 2025-05-01 778.11 ... 2025-05-01 17:50:31.713867 2025-05-01 17:50:31.714270
[1 rows x 5 columns]
2025-05-01 17:50:31,740 - 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-01 17:50:32,294 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3261 2025-04-27 1246.4
3262 2025-04-28 1246.4
3263 2025-04-29 1246.4
3264 2025-04-30 1246.4
3265 2025-05-01 1246.4
2025-05-01 17:50:32,359 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3265 2025-05-01 1246.4 ... 2025-05-01 17:50:32.351969 2025-05-01 17:50:32.352380
[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-01 17:50:34,288 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-05-01 17:50:34.279945
21 2013-01-04 ... 2025-05-01 17:50:34.279945
54 2013-02-27 ... 2025-05-01 17:50:34.279945
60 2013-03-07 ... 2025-05-01 17:50:34.279945
61 2013-03-08 ... 2025-05-01 17:50:34.279945
[5 rows x 6 columns]
2025-05-01 17:50:34,441 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3261 2025-04-27 1246.4
3262 2025-04-28 1246.4
3263 2025-04-29 1246.4
3264 2025-04-30 1246.4
3265 2025-05-01 1246.4
2025-05-01 17:50:34,507 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3269 2025-05-01 1246.4 ... 2025-05-01 17:50:34.499876 2025-05-01 17:50:34.500290
[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-01 17:50:36,418 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-05-01 17:50:36.410596
21 2013-01-04 ... 2025-05-01 17:50:36.410596
54 2013-02-27 ... 2025-05-01 17:50:36.410596
60 2013-03-07 ... 2025-05-01 17:50:36.410596
61 2013-03-08 ... 2025-05-01 17:50:36.410596
[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-01 17:50:37,714 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1606 2025-04-27 7808.0
1607 2025-04-28 7748.0
1608 2025-04-29 7660.0
1609 2025-04-30 7680.0
1610 2025-05-01 7680.0
2025-05-01 17:50:37,759 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1610 2025-05-01 7680.0 ... 2025-05-01 17:50:37.752458 2025-05-01 17:50:37.752852
[1 rows x 5 columns]
2025-05-01 17:50:37,779 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-05-01 17:50:37,784 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1606 2025-04-27 7808.0
1607 2025-04-28 7748.0
1608 2025-04-29 7660.0
1609 2025-04-30 7680.0
1610 2025-05-01 7680.0
2025-05-01 17:50:37,830 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1613 2025-05-01 7680.0 ... 2025-05-01 17:50:37.822858 2025-05-01 17:50:37.823271
[1 rows x 5 columns]
2025-05-01 17:50:37,848 - 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-01 17:50:38,744 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3717 2025-04-27 6167.5
3718 2025-04-28 6170.0
3719 2025-04-29 6170.0
3720 2025-04-30 6160.0
3721 2025-05-01 6160.0
2025-05-01 17:50:38,815 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3721 2025-05-01 6160.0 ... 2025-05-01 17:50:38.807837 2025-05-01 17:50:38.808248
[1 rows x 5 columns]
2025-05-01 17:50:38,834 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-05-01 17:50:38,840 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3717 2025-04-27 6167.5
3718 2025-04-28 6170.0
3719 2025-04-29 6170.0
3720 2025-04-30 6160.0
3721 2025-05-01 6160.0
2025-05-01 17:50:38,912 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3725 2025-05-01 6160.0 ... 2025-05-01 17:50:38.904740 2025-05-01 17:50:38.905129
[1 rows x 5 columns]
2025-05-01 17:50:38,930 - 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-01 17:50:40,281 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1607 2025-04-27 13125.0
1608 2025-04-28 13125.0
1609 2025-04-29 13050.0
1610 2025-04-30 13050.0
1611 2025-05-01 13050.0
2025-05-01 17:50:40,327 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1611 2025-05-01 13050.0 ... 2025-05-01 17:50:40.320444 2025-05-01 17:50:40.320841
[1 rows x 5 columns]
2025-05-01 17:50:40,347 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-05-01 17:50:40,353 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1607 2025-04-27 13125.0
1608 2025-04-28 13125.0
1609 2025-04-29 13050.0
1610 2025-04-30 13050.0
1611 2025-05-01 13050.0
2025-05-01 17:50:40,401 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1614 2025-05-01 13050.0 ... 2025-05-01 17:50:40.393772 2025-05-01 17:50:40.394174
[1 rows x 5 columns]
2025-05-01 17:50:40,421 - 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-01 17:50:41,247 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3117 2025-04-27 9600.00
3118 2025-04-28 9411.67
3119 2025-04-29 9401.67
3120 2025-04-30 9378.33
3121 2025-05-01 9378.33
2025-05-01 17:50:41,314 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date value ... created_at updated_at
3121 2025-05-01 9378.33 ... 2025-05-01 17:50:41.306384 2025-05-01 17:50:41.306833
[1 rows x 5 columns]
2025-05-01 17:50:41,332 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-05-01 17:50:41,339 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3117 2025-04-27 9600.00
3118 2025-04-28 9411.67
3119 2025-04-29 9401.67
3120 2025-04-30 9378.33
3121 2025-05-01 9378.33
2025-05-01 17:50:41,405 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date value ... created_at updated_at
3125 2025-05-01 9378.33 ... 2025-05-01 17:50:41.398109 2025-05-01 17:50:41.398568
[1 rows x 5 columns]
2025-05-01 17:50:41,424 - 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-01 17:50:41,964 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3240 2025-04-27 2666.67
3241 2025-04-28 2615.00
3242 2025-04-29 2595.00
3243 2025-04-30 2531.67
3244 2025-05-01 2531.67
2025-05-01 17:50:42,029 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3244 2025-05-01 2531.67 ... 2025-05-01 17:50:42.022444 2025-05-01 17:50:42.022838
[1 rows x 5 columns]
2025-05-01 17:50:42,048 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-05-01 17:50:42,054 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3240 2025-04-27 2666.67
3241 2025-04-28 2615.00
3242 2025-04-29 2595.00
3243 2025-04-30 2531.67
3244 2025-05-01 2531.67
2025-05-01 17:50:42,120 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3248 2025-05-01 2531.67 ... 2025-05-01 17:50:42.113464 2025-05-01 17:50:42.113855
[1 rows x 5 columns]
2025-05-01 17:50:42,138 - 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-01 17:50:42,726 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1444 2025-04-27 1502.5
1445 2025-04-28 1502.5
1446 2025-04-29 1502.5
1447 2025-04-30 1502.5
1448 2025-05-01 1502.5
2025-05-01 17:50:42,770 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1448 2025-05-01 1502.5 ... 2025-05-01 17:50:42.762703 2025-05-01 17:50:42.763144
[1 rows x 5 columns]
2025-05-01 17:50:42,791 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-05-01 17:50:42,797 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1444 2025-04-27 1502.5
1445 2025-04-28 1502.5
1446 2025-04-29 1502.5
1447 2025-04-30 1502.5
1448 2025-05-01 1502.5
2025-05-01 17:50:42,841 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1452 2025-05-01 1502.5 ... 2025-05-01 17:50:42.833892 2025-05-01 17:50:42.834308
[1 rows x 5 columns]
2025-05-01 17:50:42,860 - 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-01 17:50:43,416 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1357 2025-04-27 6309.38
1358 2025-04-28 6352.92
1359 2025-04-29 6359.17
1360 2025-04-30 6351.46
1361 2025-05-01 6351.46
2025-05-01 17:50:43,458 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1361 2025-05-01 6351.46 ... 2025-05-01 17:50:43.451526 2025-05-01 17:50:43.451911
[1 rows x 5 columns]
2025-05-01 17:50:43,477 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-05-01 17:50:43,483 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1357 2025-04-27 6309.38
1358 2025-04-28 6352.92
1359 2025-04-29 6359.17
1360 2025-04-30 6351.46
1361 2025-05-01 6351.46
2025-05-01 17:50:43,525 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1365 2025-05-01 6351.46 ... 2025-05-01 17:50:43.518388 2025-05-01 17:50:43.518794
[1 rows x 5 columns]
2025-05-01 17:50:43,544 - 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-01 17:50:44,120 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3730 2025-04-27 3571.67
3731 2025-04-28 3523.33
3732 2025-04-29 3485.00
3733 2025-04-30 3476.67
3734 2025-05-01 3476.67
2025-05-01 17:50:44,193 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3734 2025-05-01 3476.67 ... 2025-05-01 17:50:44.186307 2025-05-01 17:50:44.186710
[1 rows x 5 columns]
2025-05-01 17:50:44,213 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-05-01 17:50:44,219 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3730 2025-04-27 3571.67
3731 2025-04-28 3523.33
3732 2025-04-29 3485.00
3733 2025-04-30 3476.67
3734 2025-05-01 3476.67
2025-05-01 17:50:44,291 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3737 2025-05-01 3476.67 ... 2025-05-01 17:50:44.284478 2025-05-01 17:50:44.284888
[1 rows x 5 columns]
2025-05-01 17:50:44,310 - 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-01 17:50:44,904 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3500 2025-04-27 8236.0
3501 2025-04-28 8106.0
3502 2025-04-29 8086.0
3503 2025-04-30 8126.0
3504 2025-05-01 8126.0
2025-05-01 17:50:44,974 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3504 2025-05-01 8126.0 ... 2025-05-01 17:50:44.967060 2025-05-01 17:50:44.967485
[1 rows x 5 columns]
2025-05-01 17:50:44,993 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-05-01 17:50:44,999 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3500 2025-04-27 8236.0
3501 2025-04-28 8106.0
3502 2025-04-29 8086.0
3503 2025-04-30 8126.0
3504 2025-05-01 8126.0
2025-05-01 17:50:45,070 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3507 2025-05-01 8126.0 ... 2025-05-01 17:50:45.062369 2025-05-01 17:50:45.062829
[1 rows x 5 columns]
2025-05-01 17:50:45,089 - 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-01 17:50:45,649 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3466 2025-04-27 4245.0
3467 2025-04-28 4245.0
3468 2025-04-29 4245.0
3469 2025-04-30 4245.0
3470 2025-05-01 4245.0
2025-05-01 17:50:45,716 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3470 2025-05-01 4245.0 ... 2025-05-01 17:50:45.708902 2025-05-01 17:50:45.709321
[1 rows x 5 columns]
2025-05-01 17:50:45,735 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-05-01 17:50:45,741 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3466 2025-04-27 4245.0
3467 2025-04-28 4245.0
3468 2025-04-29 4245.0
3469 2025-04-30 4245.0
3470 2025-05-01 4245.0
2025-05-01 17:50:45,812 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3473 2025-05-01 4245.0 ... 2025-05-01 17:50:45.804568 2025-05-01 17:50:45.804989
[1 rows x 5 columns]
2025-05-01 17:50:45,830 - 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-01 17:50:46,567 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2843 2025-04-27 5571.43
2844 2025-04-28 5548.57
2845 2025-04-29 5548.57
2846 2025-04-30 5548.57
2847 2025-05-01 5548.57
2025-05-01 17:50:46,630 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2847 2025-05-01 5548.57 ... 2025-05-01 17:50:46.622493 2025-05-01 17:50:46.622890
[1 rows x 5 columns]
2025-05-01 17:50:46,648 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-05-01 17:50:46,654 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2843 2025-04-27 5571.43
2844 2025-04-28 5548.57
2845 2025-04-29 5548.57
2846 2025-04-30 5548.57
2847 2025-05-01 5548.57
2025-05-01 17:50:46,721 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2851 2025-05-01 5548.57 ... 2025-05-01 17:50:46.713279 2025-05-01 17:50:46.713723
[1 rows x 5 columns]
2025-05-01 17:50:46,739 - 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-01 17:50:48,768 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3043 2025-04-27 3450.0
3044 2025-04-28 3400.0
3045 2025-04-29 3400.0
3046 2025-04-30 3375.0
3047 2025-05-01 3375.0
2025-05-01 17:50:48,832 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3047 2025-05-01 3375.0 ... 2025-05-01 17:50:48.824918 2025-05-01 17:50:48.825348
[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-01 17:50:48,979 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-05-01 17:50:48.971412
458 2015-09-21 ... 2025-05-01 17:50:48.971412
549 2016-02-03 ... 2025-05-01 17:50:48.971412
693 2016-09-05 ... 2025-05-01 17:50:48.971412
696 2016-09-08 ... 2025-05-01 17:50:48.971412
[5 rows x 6 columns]
2025-05-01 17:50:49,008 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3043 2025-04-27 3450.0
3044 2025-04-28 3400.0
3045 2025-04-29 3400.0
3046 2025-04-30 3375.0
3047 2025-05-01 3375.0
2025-05-01 17:50:49,072 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3050 2025-05-01 3375.0 ... 2025-05-01 17:50:49.065009 2025-05-01 17:50:49.065434
[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-01 17:50:49,219 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-05-01 17:50:49.211454
458 2015-09-21 ... 2025-05-01 17:50:49.211454
549 2016-02-03 ... 2025-05-01 17:50:49.211454
693 2016-09-05 ... 2025-05-01 17:50:49.211454
696 2016-09-08 ... 2025-05-01 17:50:49.211454
[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-01 17:50:50,133 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
847 2025-04-27 10040.0
848 2025-04-28 10040.0
849 2025-04-29 9960.0
850 2025-04-30 9880.0
851 2025-05-01 9880.0
2025-05-01 17:50:50,172 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
851 2025-05-01 9880.0 ... 2025-05-01 17:50:50.161736 2025-05-01 17:50:50.162423
[1 rows x 5 columns]
2025-05-01 17:50:50,191 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-05-01 17:50:50,199 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
847 2025-04-27 10040.0
848 2025-04-28 10040.0
849 2025-04-29 9960.0
850 2025-04-30 9880.0
851 2025-05-01 9880.0
2025-05-01 17:50:50,241 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
851 2025-05-01 9880.0 ... 2025-05-01 17:50:50.232787 2025-05-01 17:50:50.233241
[1 rows x 5 columns]
2025-05-01 17:50:50,260 - 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-01 17:50:50,807 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3726 2025-04-27 7568.33
3727 2025-04-28 7571.67
3728 2025-04-29 7553.33
3729 2025-04-30 7553.33
3730 2025-05-01 7553.33
2025-05-01 17:50:50,878 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3730 2025-05-01 7553.33 ... 2025-05-01 17:50:50.871306 2025-05-01 17:50:50.871701
[1 rows x 5 columns]
2025-05-01 17:50:50,897 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-05-01 17:50:50,903 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3726 2025-04-27 7568.33
3727 2025-04-28 7571.67
3728 2025-04-29 7553.33
3729 2025-04-30 7553.33
3730 2025-05-01 7553.33
2025-05-01 17:50:50,975 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3733 2025-05-01 7553.33 ... 2025-05-01 17:50:50.967667 2025-05-01 17:50:50.968065
[1 rows x 5 columns]
2025-05-01 17:50:50,993 - 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-01 17:50:51,541 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3064 2025-04-27 3605.0
3065 2025-04-28 3615.0
3066 2025-04-29 3650.0
3067 2025-04-30 3647.5
3068 2025-05-01 3647.5
2025-05-01 17:50:51,606 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3069 2025-05-01 3647.5 ... 2025-05-01 17:50:51.599534 2025-05-01 17:50:51.599929
[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-01 17:50:51,641 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-05-01 17:50:51.634465
[1 rows x 6 columns]
2025-05-01 17:50:51,665 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3064 2025-04-27 3605.0
3065 2025-04-28 3615.0
3066 2025-04-29 3650.0
3067 2025-04-30 3647.5
3068 2025-05-01 3647.5
2025-05-01 17:50:51,732 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3071 2025-05-01 3647.5 ... 2025-05-01 17:50:51.725697 2025-05-01 17:50:51.726083
[1 rows x 5 columns]
2025-05-01 17:50:51,751 - 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-01 17:50:52,427 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3729 2025-04-27 20083.33
3730 2025-04-28 19966.67
3731 2025-04-29 19966.67
3732 2025-04-30 20073.33
3733 2025-05-01 20073.33
2025-05-01 17:50:52,500 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date ... updated_at
3733 2025-05-01 ... 2025-05-01 17:50:52.493269
[1 rows x 5 columns]
2025-05-01 17:50:52,521 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-05-01 17:50:52,527 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3729 2025-04-27 20083.33
3730 2025-04-28 19966.67
3731 2025-04-29 19966.67
3732 2025-04-30 20073.33
3733 2025-05-01 20073.33
2025-05-01 17:50:52,598 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date ... updated_at
3736 2025-05-01 ... 2025-05-01 17:50:52.592531
[1 rows x 5 columns]
2025-05-01 17:50:52,617 - 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-01 17:50:53,187 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2843 2025-04-27 5690.0
2844 2025-04-28 5652.0
2845 2025-04-29 5652.0
2846 2025-04-30 5640.0
2847 2025-05-01 5640.0
2025-05-01 17:50:53,247 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2847 2025-05-01 5640.0 ... 2025-05-01 17:50:53.240674 2025-05-01 17:50:53.241064
[1 rows x 5 columns]
2025-05-01 17:50:53,266 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-05-01 17:50:53,272 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2843 2025-04-27 5690.0
2844 2025-04-28 5652.0
2845 2025-04-29 5652.0
2846 2025-04-30 5640.0
2847 2025-05-01 5640.0
2025-05-01 17:50:53,334 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2851 2025-05-01 5640.0 ... 2025-05-01 17:50:53.326484 2025-05-01 17:50:53.326879
[1 rows x 5 columns]
2025-05-01 17:50:53,352 - 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-01 17:50:53,932 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2118 2025-04-27 23825.0
2119 2025-04-28 23825.0
2120 2025-04-29 23775.0
2121 2025-04-30 23775.0
2122 2025-05-01 23775.0
2025-05-01 17:50:53,984 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2122 2025-05-01 23775.0 ... 2025-05-01 17:50:53.976658 2025-05-01 17:50:53.977048
[1 rows x 5 columns]
2025-05-01 17:50:54,002 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-05-01 17:50:54,008 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2118 2025-04-27 23825.0
2119 2025-04-28 23825.0
2120 2025-04-29 23775.0
2121 2025-04-30 23775.0
2122 2025-05-01 23775.0
2025-05-01 17:50:54,060 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2126 2025-05-01 23775.0 ... 2025-05-01 17:50:54.053233 2025-05-01 17:50:54.053629
[1 rows x 5 columns]
2025-05-01 17:50:54,079 - 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-01 17:50:54,635 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1633 2025-04-27 1870.00
1634 2025-04-28 1865.00
1635 2025-04-29 1861.67
1636 2025-04-30 1870.00
1637 2025-05-01 1875.00
2025-05-01 17:50:54,683 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1637 2025-05-01 1875.0 ... 2025-05-01 17:50:54.675449 2025-05-01 17:50:54.675901
[1 rows x 5 columns]
2025-05-01 17:50:54,702 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-05-01 17:50:54,707 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1633 2025-04-27 1870.00
1634 2025-04-28 1865.00
1635 2025-04-29 1861.67
1636 2025-04-30 1870.00
1637 2025-05-01 1875.00
2025-05-01 17:50:54,754 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1641 2025-05-01 1875.0 ... 2025-05-01 17:50:54.747331 2025-05-01 17:50:54.747721
[1 rows x 5 columns]
2025-05-01 17:50:54,775 - 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-01 17:50:55,379 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2705 2025-04-27 126908.33
2706 2025-04-28 125033.33
2707 2025-04-29 125616.67
2708 2025-04-30 125175.00
2709 2025-05-01 125175.00
2025-05-01 17:50:55,440 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2709 2025-05-01 ... 2025-05-01 17:50:55.433431
[1 rows x 5 columns]
2025-05-01 17:50:55,458 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-05-01 17:50:55,464 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2705 2025-04-27 126908.33
2706 2025-04-28 125033.33
2707 2025-04-29 125616.67
2708 2025-04-30 125175.00
2709 2025-05-01 125175.00
2025-05-01 17:50:55,525 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2712 2025-05-01 ... 2025-05-01 17:50:55.518776
[1 rows x 5 columns]
2025-05-01 17:50:55,544 - 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-01 17:50:56,124 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3730 2025-04-27 4715.0
3731 2025-04-28 4695.0
3732 2025-04-29 4692.0
3733 2025-04-30 4679.0
3734 2025-05-01 4679.0
2025-05-01 17:50:56,198 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3734 2025-05-01 4679.0 ... 2025-05-01 17:50:56.191033 2025-05-01 17:50:56.191469
[1 rows x 5 columns]
2025-05-01 17:50:56,217 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-05-01 17:50:56,223 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3730 2025-04-27 4715.0
3731 2025-04-28 4695.0
3732 2025-04-29 4692.0
3733 2025-04-30 4679.0
3734 2025-05-01 4679.0
2025-05-01 17:50:56,298 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3737 2025-05-01 4679.0 ... 2025-05-01 17:50:56.290516 2025-05-01 17:50:56.290939
[1 rows x 5 columns]
2025-05-01 17:50:56,316 - 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-01 17:50:57,185 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
2969 2025-04-27 7481.67
2970 2025-04-28 7481.67
2971 2025-04-29 7481.67
2972 2025-04-30 7481.67
2973 2025-05-01 7481.67
2025-05-01 17:50:57,247 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
2973 2025-05-01 7481.67 ... 2025-05-01 17:50:57.240639 2025-05-01 17:50:57.241032
[1 rows x 5 columns]
2025-05-01 17:50:57,266 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-05-01 17:50:57,271 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
2969 2025-04-27 7481.67
2970 2025-04-28 7481.67
2971 2025-04-29 7481.67
2972 2025-04-30 7481.67
2973 2025-05-01 7481.67
2025-05-01 17:50:57,333 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
2976 2025-05-01 7481.67 ... 2025-05-01 17:50:57.326519 2025-05-01 17:50:57.326905
[1 rows x 5 columns]
2025-05-01 17:50:57,352 - 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-01 17:50:58,002 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3731 2025-04-27 14260.83
3732 2025-04-28 14273.33
3733 2025-04-29 14261.83
3734 2025-04-30 14208.83
3735 2025-05-01 14208.83
2025-05-01 17:50:58,075 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date ... updated_at
3735 2025-05-01 ... 2025-05-01 17:50:58.068830
[1 rows x 5 columns]
2025-05-01 17:50:58,094 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-05-01 17:50:58,100 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3731 2025-04-27 14260.83
3732 2025-04-28 14273.33
3733 2025-04-29 14261.83
3734 2025-04-30 14208.83
3735 2025-05-01 14208.83
2025-05-01 17:50:58,172 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date ... updated_at
3739 2025-05-01 ... 2025-05-01 17:50:58.166277
[1 rows x 5 columns]
2025-05-01 17:50:58,192 - 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-01 17:50:58,779 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3676 2025-04-27 16981.25
3677 2025-04-28 16875.00
3678 2025-04-29 16887.50
3679 2025-04-30 16812.50
3680 2025-05-01 16812.50
2025-05-01 17:50:58,850 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date value ... created_at updated_at
3680 2025-05-01 16812.5 ... 2025-05-01 17:50:58.843062 2025-05-01 17:50:58.843485
[1 rows x 5 columns]
2025-05-01 17:50:58,869 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-05-01 17:50:58,875 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3676 2025-04-27 16981.25
3677 2025-04-28 16875.00
3678 2025-04-29 16887.50
3679 2025-04-30 16812.50
3680 2025-05-01 16812.50
2025-05-01 17:50:59,027 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date value ... created_at updated_at
3683 2025-05-01 16812.5 ... 2025-05-01 17:50:59.019735 2025-05-01 17:50:59.020130
[1 rows x 5 columns]
2025-05-01 17:50:59,045 - 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-01 17:50:59,621 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
2951 2025-04-25 3270.00
2952 2025-04-28 3310.00
2953 2025-04-29 3273.33
2954 2025-04-30 3276.67
2955 2025-05-01 3276.67
2025-05-01 17:50:59,685 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
2955 2025-05-01 3276.67 ... 2025-05-01 17:50:59.677845 2025-05-01 17:50:59.678262
[1 rows x 5 columns]
2025-05-01 17:50:59,704 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-05-01 17:50:59,710 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
2951 2025-04-25 3270.00
2952 2025-04-28 3310.00
2953 2025-04-29 3273.33
2954 2025-04-30 3276.67
2955 2025-05-01 3276.67
2025-05-01 17:50:59,774 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
2958 2025-05-01 3276.67 ... 2025-05-01 17:50:59.766882 2025-05-01 17:50:59.767338
[1 rows x 5 columns]
2025-05-01 17:50:59,793 - 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-01 17:51:00,458 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3231 2025-04-27 5475.0
3232 2025-04-28 5475.0
3233 2025-04-29 5462.5
3234 2025-04-30 5462.5
3235 2025-05-01 5462.5
2025-05-01 17:51:00,530 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3235 2025-05-01 5462.5 ... 2025-05-01 17:51:00.523185 2025-05-01 17:51:00.523648
[1 rows x 5 columns]
2025-05-01 17:51:00,550 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-05-01 17:51:00,557 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3231 2025-04-27 5475.0
3232 2025-04-28 5475.0
3233 2025-04-29 5462.5
3234 2025-04-30 5462.5
3235 2025-05-01 5462.5
2025-05-01 17:51:00,631 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3722 2025-05-01 5462.5 ... 2025-05-01 17:51:00.623875 2025-05-01 17:51:00.624287
[1 rows x 5 columns]
2025-05-01 17:51:00,650 - 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-01 17:51:01,609 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1295 2025-04-27 14870.0
1296 2025-04-28 14870.0
1297 2025-04-29 14830.0
1298 2025-04-30 14830.0
1299 2025-05-01 14830.0
2025-05-01 17:51:01,651 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1299 2025-05-01 14830.0 ... 2025-05-01 17:51:01.643676 2025-05-01 17:51:01.644070
[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-01 17:51:01,894 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-05-01 17:51:01.885589
117 2021-07-06 ... 2025-05-01 17:51:01.885589
121 2021-07-12 ... 2025-05-01 17:51:01.885589
122 2021-07-13 ... 2025-05-01 17:51:01.885589
194 2021-11-01 ... 2025-05-01 17:51:01.885589
[5 rows x 6 columns]
2025-05-01 17:51:01,932 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1295 2025-04-27 14870.0
1296 2025-04-28 14870.0
1297 2025-04-29 14830.0
1298 2025-04-30 14830.0
1299 2025-05-01 14830.0
2025-05-01 17:51:01,974 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1302 2025-05-01 14830.0 ... 2025-05-01 17:51:01.966936 2025-05-01 17:51:01.967353
[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-01 17:51:02,214 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-05-01 17:51:02.206242
117 2021-07-06 ... 2025-05-01 17:51:02.206242
121 2021-07-12 ... 2025-05-01 17:51:02.206242
122 2021-07-13 ... 2025-05-01 17:51:02.206242
194 2021-11-01 ... 2025-05-01 17:51:02.206242
[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-01 17:51:02,812 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3727 2025-04-27 78158.33
3728 2025-04-28 77535.00
3729 2025-04-29 78101.67
3730 2025-04-30 77996.67
3731 2025-05-01 77996.67
2025-05-01 17:51:02,885 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date ... updated_at
3731 2025-05-01 ... 2025-05-01 17:51:02.878695
[1 rows x 5 columns]
2025-05-01 17:51:02,903 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-05-01 17:51:02,912 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3727 2025-04-27 78158.33
3728 2025-04-28 77535.00
3729 2025-04-29 78101.67
3730 2025-04-30 77996.67
3731 2025-05-01 77996.67
2025-05-01 17:51:02,984 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date ... updated_at
3734 2025-05-01 ... 2025-05-01 17:51:02.978491
[1 rows x 5 columns]
2025-05-01 17:51:03,003 - 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-01 17:51:03,540 - 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-01 17:51:03,597 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-05-01 17:51:03,597 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-05-01 17:51:03,603 - 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-01 17:51:03,671 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-05-01 17:51:03,672 - 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-01 17:51:04,257 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2705 2025-04-27 263012.5
2706 2025-04-28 260175.0
2707 2025-04-29 262175.0
2708 2025-04-30 261175.0
2709 2025-05-01 261175.0
2025-05-01 17:51:04,315 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2709 2025-05-01 ... 2025-05-01 17:51:04.309263
[1 rows x 5 columns]
2025-05-01 17:51:04,334 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-05-01 17:51:04,340 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2705 2025-04-27 263012.5
2706 2025-04-28 260175.0
2707 2025-04-29 262175.0
2708 2025-04-30 261175.0
2709 2025-05-01 261175.0
2025-05-01 17:51:04,400 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2712 2025-05-01 ... 2025-05-01 17:51:04.393741
[1 rows x 5 columns]
2025-05-01 17:51:04,418 - 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-01 17:51:06,451 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3726 2025-04-27 23186.0
3727 2025-04-28 22874.0
3728 2025-04-29 22970.0
3729 2025-04-30 22904.0
3730 2025-05-01 22904.0
2025-05-01 17:51:06,522 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3730 2025-05-01 22904.0 ... 2025-05-01 17:51:06.515625 2025-05-01 17:51:06.516038
[1 rows x 5 columns]
2025-05-01 17:51:06,541 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-05-01 17:51:06,547 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3726 2025-04-27 23186.0
3727 2025-04-28 22874.0
3728 2025-04-29 22970.0
3729 2025-04-30 22904.0
3730 2025-05-01 22904.0
2025-05-01 17:51:06,620 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3733 2025-05-01 22904.0 ... 2025-05-01 17:51:06.612810 2025-05-01 17:51:06.613202
[1 rows x 5 columns]
2025-05-01 17:51:06,638 - 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-01 17:51:07,208 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3689 2025-04-27 3335.0
3690 2025-04-28 3397.5
3691 2025-04-29 3387.5
3692 2025-04-30 3387.5
3693 2025-05-01 3377.5
2025-05-01 17:51:07,282 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3693 2025-05-01 3377.5 ... 2025-05-01 17:51:07.274989 2025-05-01 17:51:07.275426
[1 rows x 5 columns]
2025-05-01 17:51:07,302 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-05-01 17:51:07,308 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3689 2025-04-27 3335.0
3690 2025-04-28 3397.5
3691 2025-04-29 3387.5
3692 2025-04-30 3387.5
3693 2025-05-01 3377.5
2025-05-01 17:51:07,381 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3696 2025-05-01 3377.5 ... 2025-05-01 17:51:07.373291 2025-05-01 17:51:07.373695
[1 rows x 5 columns]
2025-05-01 17:51:07,399 - 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-01 17:51:07,925 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1486 2025-04-27 4977.5
1487 2025-04-28 4967.5
1488 2025-04-29 4967.5
1489 2025-04-30 4980.0
1490 2025-05-01 4980.0
2025-05-01 17:51:07,970 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1490 2025-05-01 4980.0 ... 2025-05-01 17:51:07.962759 2025-05-01 17:51:07.963150
[1 rows x 5 columns]
2025-05-01 17:51:07,989 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-05-01 17:51:07,995 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1486 2025-04-27 4977.5
1487 2025-04-28 4967.5
1488 2025-04-29 4967.5
1489 2025-04-30 4980.0
1490 2025-05-01 4980.0
2025-05-01 17:51:08,041 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1493 2025-05-01 4980.0 ... 2025-05-01 17:51:08.033795 2025-05-01 17:51:08.034190
[1 rows x 5 columns]
2025-05-01 17:51:08,060 - 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-01 17:51:09,444 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2760 2025-04-27 2228.57
2761 2025-04-28 2232.86
2762 2025-04-29 2244.29
2763 2025-04-30 2252.86
2764 2025-05-01 2252.86
2025-05-01 17:51:09,503 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2764 2025-05-01 2252.86 ... 2025-05-01 17:51:09.496500 2025-05-01 17:51:09.496892
[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-01 17:51:09,544 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2763 2025-04-30 ... 2025-05-01 17:51:09.537366
[1 rows x 6 columns]
2025-05-01 17:51:09,569 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2760 2025-04-27 2228.57
2761 2025-04-28 2232.86
2762 2025-04-29 2244.29
2763 2025-04-30 2252.86
2764 2025-05-01 2252.86
2025-05-01 17:51:09,629 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2767 2025-05-01 2252.86 ... 2025-05-01 17:51:09.622565 2025-05-01 17:51:09.622961
[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-01 17:51:09,670 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2766 2025-04-30 ... 2025-05-01 17:51:09.662686
[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-01 17:51:10,233 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2760 2025-04-27 2228.57
2761 2025-04-28 2232.86
2762 2025-04-29 2244.29
2763 2025-04-30 2252.86
2764 2025-05-01 2846.00
2025-05-01 17:51:10,285 - 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-01 17:51:10,308 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2764 2025-05-01 ... 2025-05-01 17:51:10.301100
[1 rows x 6 columns]
2025-05-01 17:51:10,332 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2760 2025-04-27 2228.57
2761 2025-04-28 2232.86
2762 2025-04-29 2244.29
2763 2025-04-30 2252.86
2764 2025-05-01 2846.00
2025-05-01 17:51:10,403 - 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-01 17:51:10,427 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2767 2025-05-01 ... 2025-05-01 17:51:10.419053
[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-01 17:51:10,932 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3117 2025-04-27 9600.00
3118 2025-04-28 9411.67
3119 2025-04-29 9401.67
3120 2025-04-30 9378.33
3121 2025-05-01 9378.33
2025-05-01 17:51:10,990 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-05-01 17:51:10,990 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-05-01 17:51:10,995 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3117 2025-04-27 9600.00
3118 2025-04-28 9411.67
3119 2025-04-29 9401.67
3120 2025-04-30 9378.33
3121 2025-05-01 9378.33
2025-05-01 17:51:11,052 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-05-01 17:51:11,052 - 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-01 17:51:11,585 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1801 2025-04-27 4350.00
1802 2025-04-28 4343.33
1803 2025-04-29 4328.33
1804 2025-04-30 4331.67
1805 2025-05-01 4331.67
2025-05-01 17:51:11,633 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1805 2025-05-01 4331.67 ... 2025-05-01 17:51:11.626364 2025-05-01 17:51:11.626778
[1 rows x 5 columns]
2025-05-01 17:51:11,652 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-05-01 17:51:11,658 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1801 2025-04-27 4350.00
1802 2025-04-28 4343.33
1803 2025-04-29 4328.33
1804 2025-04-30 4331.67
1805 2025-05-01 4331.67
2025-05-01 17:51:11,705 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1808 2025-05-01 4331.67 ... 2025-05-01 17:51:11.698698 2025-05-01 17:51:11.699118
[1 rows x 5 columns]
2025-05-01 17:51:11,725 - 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-01 17:51:13,713 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1810 2025-04-27 6366.67
1811 2025-04-28 6366.67
1812 2025-04-29 6366.67
1813 2025-04-30 6250.00
1814 2025-05-01 6250.00
2025-05-01 17:51:13,762 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1814 2025-05-01 6250.0 ... 2025-05-01 17:51:13.754720 2025-05-01 17:51:13.755120
[1 rows x 5 columns]
2025-05-01 17:51:13,780 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-05-01 17:51:13,786 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1810 2025-04-27 6366.67
1811 2025-04-28 6366.67
1812 2025-04-29 6366.67
1813 2025-04-30 6250.00
1814 2025-05-01 6250.00
2025-05-01 17:51:13,835 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1817 2025-05-01 6250.0 ... 2025-05-01 17:51:13.827637 2025-05-01 17:51:13.828033
[1 rows x 5 columns]
2025-05-01 17:51:13,853 - 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-01 17:51:14,399 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3478 2025-04-27 9064.0
3479 2025-04-28 8920.0
3480 2025-04-29 8800.0
3481 2025-04-30 8760.0
3482 2025-05-01 8760.0
2025-05-01 17:51:14,466 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3482 2025-05-01 8760.0 ... 2025-05-01 17:51:14.459553 2025-05-01 17:51:14.459944
[1 rows x 5 columns]
2025-05-01 17:51:14,485 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-05-01 17:51:14,492 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3478 2025-04-27 9064.0
3479 2025-04-28 8920.0
3480 2025-04-29 8800.0
3481 2025-04-30 8760.0
3482 2025-05-01 8760.0
2025-05-01 17:51:14,562 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3485 2025-05-01 8760.0 ... 2025-05-01 17:51:14.554807 2025-05-01 17:51:14.555195
[1 rows x 5 columns]
2025-05-01 17:51:14,580 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data