=========================================================================
2025-05-02 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-02 17:50:28,421 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3287 2025-04-28 3204.56
3288 2025-04-29 3186.89
3289 2025-04-30 3183.22
3290 2025-05-01 3183.22
3291 2025-05-02 3183.22
2025-05-02 17:50:28,491 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3291 2025-05-02 3183.22 ... 2025-05-02 17:50:28.483665 2025-05-02 17:50:28.484115
[1 rows x 5 columns]
2025-05-02 17:50:28,511 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-05-02 17:50:28,517 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3287 2025-04-28 3204.56
3288 2025-04-29 3186.89
3289 2025-04-30 3183.22
3290 2025-05-01 3183.22
3291 2025-05-02 3183.22
2025-05-02 17:50:28,583 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3294 2025-05-02 3183.22 ... 2025-05-02 17:50:28.576404 2025-05-02 17:50:28.576791
[1 rows x 5 columns]
2025-05-02 17:50:28,603 - 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-02 17:50:29,321 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3508 2025-04-28 2451.25
3509 2025-04-29 2437.50
3510 2025-04-30 2440.00
3511 2025-05-01 2440.00
3512 2025-05-02 2440.00
2025-05-02 17:50:29,391 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3512 2025-05-02 2440.0 ... 2025-05-02 17:50:29.384141 2025-05-02 17:50:29.384605
[1 rows x 5 columns]
2025-05-02 17:50:29,410 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-05-02 17:50:29,416 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3508 2025-04-28 2451.25
3509 2025-04-29 2437.50
3510 2025-04-30 2440.00
3511 2025-05-01 2440.00
3512 2025-05-02 2440.00
2025-05-02 17:50:29,486 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3516 2025-05-02 2440.0 ... 2025-05-02 17:50:29.478851 2025-05-02 17:50:29.479262
[1 rows x 5 columns]
2025-05-02 17:50:29,506 - 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-02 17:50:30,068 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
848 2025-04-28 4567.50
849 2025-04-29 4565.00
850 2025-04-30 4584.38
851 2025-05-01 4584.38
852 2025-05-02 4584.38
2025-05-02 17:50:30,105 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
852 2025-05-02 4584.38 ... 2025-05-02 17:50:30.098387 2025-05-02 17:50:30.098786
[1 rows x 5 columns]
2025-05-02 17:50:30,126 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-05-02 17:50:30,131 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
848 2025-04-28 4567.50
849 2025-04-29 4565.00
850 2025-04-30 4584.38
851 2025-05-01 4584.38
852 2025-05-02 4584.38
2025-05-02 17:50:30,166 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
852 2025-05-02 4584.38 ... 2025-05-02 17:50:30.159470 2025-05-02 17:50:30.159851
[1 rows x 5 columns]
2025-05-02 17:50:30,185 - 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-02 17:50:30,761 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3727 2025-04-28 14488.33
3728 2025-04-29 14408.33
3729 2025-04-30 14308.33
3730 2025-05-01 14308.33
3731 2025-05-02 14308.33
2025-05-02 17:50:30,833 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3731 2025-05-02 ... 2025-05-02 17:50:30.826554
[1 rows x 5 columns]
2025-05-02 17:50:30,852 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-05-02 17:50:30,857 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3727 2025-04-28 14488.33
3728 2025-04-29 14408.33
3729 2025-04-30 14308.33
3730 2025-05-01 14308.33
3731 2025-05-02 14308.33
2025-05-02 17:50:30,931 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3734 2025-05-02 ... 2025-05-02 17:50:30.923811
[1 rows x 5 columns]
2025-05-02 17:50:30,950 - 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-02 17:50:31,494 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3059 2025-04-28 778.56
3060 2025-04-29 779.44
3061 2025-04-30 778.11
3062 2025-05-01 778.11
3063 2025-05-02 778.11
2025-05-02 17:50:31,560 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3063 2025-05-02 778.11 ... 2025-05-02 17:50:31.553194 2025-05-02 17:50:31.553626
[1 rows x 5 columns]
2025-05-02 17:50:31,579 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-05-02 17:50:31,585 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3059 2025-04-28 778.56
3060 2025-04-29 779.44
3061 2025-04-30 778.11
3062 2025-05-01 778.11
3063 2025-05-02 778.11
2025-05-02 17:50:31,651 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3066 2025-05-02 778.11 ... 2025-05-02 17:50:31.643770 2025-05-02 17:50:31.644177
[1 rows x 5 columns]
2025-05-02 17:50:31,670 - 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-02 17:50:32,498 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3262 2025-04-28 1246.4
3263 2025-04-29 1246.4
3264 2025-04-30 1246.4
3265 2025-05-01 1246.4
3266 2025-05-02 1246.4
2025-05-02 17:50:32,565 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3266 2025-05-02 1246.4 ... 2025-05-02 17:50:32.557878 2025-05-02 17:50:32.558292
[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-02 17:50:34,570 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-05-02 17:50:34.562833
21 2013-01-04 ... 2025-05-02 17:50:34.562833
54 2013-02-27 ... 2025-05-02 17:50:34.562833
60 2013-03-07 ... 2025-05-02 17:50:34.562833
61 2013-03-08 ... 2025-05-02 17:50:34.562833
[5 rows x 6 columns]
2025-05-02 17:50:34,735 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3262 2025-04-28 1246.4
3263 2025-04-29 1246.4
3264 2025-04-30 1246.4
3265 2025-05-01 1246.4
3266 2025-05-02 1246.4
2025-05-02 17:50:34,803 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3270 2025-05-02 1246.4 ... 2025-05-02 17:50:34.796010 2025-05-02 17:50:34.796437
[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-02 17:50:36,812 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-05-02 17:50:36.803979
21 2013-01-04 ... 2025-05-02 17:50:36.803979
54 2013-02-27 ... 2025-05-02 17:50:36.803979
60 2013-03-07 ... 2025-05-02 17:50:36.803979
61 2013-03-08 ... 2025-05-02 17:50:36.803979
[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-02 17:50:37,526 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1607 2025-04-28 7748.0
1608 2025-04-29 7660.0
1609 2025-04-30 7680.0
1610 2025-05-01 7680.0
1611 2025-05-02 7680.0
2025-05-02 17:50:37,575 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1611 2025-05-02 7680.0 ... 2025-05-02 17:50:37.567139 2025-05-02 17:50:37.567588
[1 rows x 5 columns]
2025-05-02 17:50:37,595 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-05-02 17:50:37,600 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1607 2025-04-28 7748.0
1608 2025-04-29 7660.0
1609 2025-04-30 7680.0
1610 2025-05-01 7680.0
1611 2025-05-02 7680.0
2025-05-02 17:50:37,648 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1614 2025-05-02 7680.0 ... 2025-05-02 17:50:37.641164 2025-05-02 17:50:37.641594
[1 rows x 5 columns]
2025-05-02 17:50:37,668 - 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-02 17:50:38,539 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3718 2025-04-28 6170.0
3719 2025-04-29 6170.0
3720 2025-04-30 6160.0
3721 2025-05-01 6160.0
3722 2025-05-02 6160.0
2025-05-02 17:50:38,611 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3722 2025-05-02 6160.0 ... 2025-05-02 17:50:38.603805 2025-05-02 17:50:38.604195
[1 rows x 5 columns]
2025-05-02 17:50:38,630 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-05-02 17:50:38,636 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3718 2025-04-28 6170.0
3719 2025-04-29 6170.0
3720 2025-04-30 6160.0
3721 2025-05-01 6160.0
3722 2025-05-02 6160.0
2025-05-02 17:50:38,709 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3726 2025-05-02 6160.0 ... 2025-05-02 17:50:38.701609 2025-05-02 17:50:38.701995
[1 rows x 5 columns]
2025-05-02 17:50:38,728 - 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-02 17:50:39,267 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1608 2025-04-28 13125.0
1609 2025-04-29 13050.0
1610 2025-04-30 13050.0
1611 2025-05-01 13050.0
1612 2025-05-02 13050.0
2025-05-02 17:50:39,313 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1612 2025-05-02 13050.0 ... 2025-05-02 17:50:39.306007 2025-05-02 17:50:39.306421
[1 rows x 5 columns]
2025-05-02 17:50:39,332 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-05-02 17:50:39,338 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1608 2025-04-28 13125.0
1609 2025-04-29 13050.0
1610 2025-04-30 13050.0
1611 2025-05-01 13050.0
1612 2025-05-02 13050.0
2025-05-02 17:50:39,385 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1615 2025-05-02 13050.0 ... 2025-05-02 17:50:39.377559 2025-05-02 17:50:39.377942
[1 rows x 5 columns]
2025-05-02 17:50:39,403 - 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-02 17:50:39,989 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3118 2025-04-28 9411.67
3119 2025-04-29 9401.67
3120 2025-04-30 9378.33
3121 2025-05-01 9378.33
3122 2025-05-02 9378.33
2025-05-02 17:50:40,055 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date value ... created_at updated_at
3122 2025-05-02 9378.33 ... 2025-05-02 17:50:40.048124 2025-05-02 17:50:40.048554
[1 rows x 5 columns]
2025-05-02 17:50:40,075 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-05-02 17:50:40,081 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3118 2025-04-28 9411.67
3119 2025-04-29 9401.67
3120 2025-04-30 9378.33
3121 2025-05-01 9378.33
3122 2025-05-02 9378.33
2025-05-02 17:50:40,147 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date value ... created_at updated_at
3126 2025-05-02 9378.33 ... 2025-05-02 17:50:40.140440 2025-05-02 17:50:40.140838
[1 rows x 5 columns]
2025-05-02 17:50:40,166 - 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-02 17:50:40,753 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3241 2025-04-28 2615.00
3242 2025-04-29 2595.00
3243 2025-04-30 2531.67
3244 2025-05-01 2531.67
3245 2025-05-02 2531.67
2025-05-02 17:50:40,823 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3245 2025-05-02 2531.67 ... 2025-05-02 17:50:40.816114 2025-05-02 17:50:40.816544
[1 rows x 5 columns]
2025-05-02 17:50:40,843 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-05-02 17:50:40,849 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3241 2025-04-28 2615.00
3242 2025-04-29 2595.00
3243 2025-04-30 2531.67
3244 2025-05-01 2531.67
3245 2025-05-02 2531.67
2025-05-02 17:50:40,916 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3249 2025-05-02 2531.67 ... 2025-05-02 17:50:40.908871 2025-05-02 17:50:40.909276
[1 rows x 5 columns]
2025-05-02 17:50:40,935 - 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-02 17:50:42,733 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1445 2025-04-28 1502.5
1446 2025-04-29 1502.5
1447 2025-04-30 1502.5
1448 2025-05-01 1502.5
1449 2025-05-02 1502.5
2025-05-02 17:50:42,778 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1449 2025-05-02 1502.5 ... 2025-05-02 17:50:42.771026 2025-05-02 17:50:42.771444
[1 rows x 5 columns]
2025-05-02 17:50:42,798 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-05-02 17:50:42,803 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1445 2025-04-28 1502.5
1446 2025-04-29 1502.5
1447 2025-04-30 1502.5
1448 2025-05-01 1502.5
1449 2025-05-02 1502.5
2025-05-02 17:50:42,848 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1453 2025-05-02 1502.5 ... 2025-05-02 17:50:42.841322 2025-05-02 17:50:42.841721
[1 rows x 5 columns]
2025-05-02 17:50:42,867 - 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-02 17:50:43,463 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1358 2025-04-28 6352.92
1359 2025-04-29 6359.17
1360 2025-04-30 6351.46
1361 2025-05-01 6351.46
1362 2025-05-02 6351.46
2025-05-02 17:50:43,506 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1362 2025-05-02 6351.46 ... 2025-05-02 17:50:43.498948 2025-05-02 17:50:43.499365
[1 rows x 5 columns]
2025-05-02 17:50:43,525 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-05-02 17:50:43,530 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1358 2025-04-28 6352.92
1359 2025-04-29 6359.17
1360 2025-04-30 6351.46
1361 2025-05-01 6351.46
1362 2025-05-02 6351.46
2025-05-02 17:50:43,573 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1366 2025-05-02 6351.46 ... 2025-05-02 17:50:43.566650 2025-05-02 17:50:43.567027
[1 rows x 5 columns]
2025-05-02 17:50:43,592 - 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-02 17:50:44,179 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3731 2025-04-28 3523.33
3732 2025-04-29 3485.00
3733 2025-04-30 3476.67
3734 2025-05-01 3476.67
3735 2025-05-02 3476.67
2025-05-02 17:50:44,255 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3735 2025-05-02 3476.67 ... 2025-05-02 17:50:44.248323 2025-05-02 17:50:44.248721
[1 rows x 5 columns]
2025-05-02 17:50:44,275 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-05-02 17:50:44,280 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3731 2025-04-28 3523.33
3732 2025-04-29 3485.00
3733 2025-04-30 3476.67
3734 2025-05-01 3476.67
3735 2025-05-02 3476.67
2025-05-02 17:50:44,354 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3738 2025-05-02 3476.67 ... 2025-05-02 17:50:44.347009 2025-05-02 17:50:44.347426
[1 rows x 5 columns]
2025-05-02 17:50:44,373 - 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-02 17:50:44,946 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3501 2025-04-28 8106.0
3502 2025-04-29 8086.0
3503 2025-04-30 8126.0
3504 2025-05-01 8126.0
3505 2025-05-02 8126.0
2025-05-02 17:50:45,018 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3505 2025-05-02 8126.0 ... 2025-05-02 17:50:45.010549 2025-05-02 17:50:45.010964
[1 rows x 5 columns]
2025-05-02 17:50:45,037 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-05-02 17:50:45,044 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3501 2025-04-28 8106.0
3502 2025-04-29 8086.0
3503 2025-04-30 8126.0
3504 2025-05-01 8126.0
3505 2025-05-02 8126.0
2025-05-02 17:50:45,120 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3508 2025-05-02 8126.0 ... 2025-05-02 17:50:45.112571 2025-05-02 17:50:45.113025
[1 rows x 5 columns]
2025-05-02 17:50:45,139 - 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-02 17:50:45,761 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3467 2025-04-28 4245.0
3468 2025-04-29 4245.0
3469 2025-04-30 4245.0
3470 2025-05-01 4245.0
3471 2025-05-02 4245.0
2025-05-02 17:50:45,830 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3471 2025-05-02 4245.0 ... 2025-05-02 17:50:45.822695 2025-05-02 17:50:45.823085
[1 rows x 5 columns]
2025-05-02 17:50:45,848 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-05-02 17:50:45,854 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3467 2025-04-28 4245.0
3468 2025-04-29 4245.0
3469 2025-04-30 4245.0
3470 2025-05-01 4245.0
3471 2025-05-02 4245.0
2025-05-02 17:50:45,925 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3474 2025-05-02 4245.0 ... 2025-05-02 17:50:45.916446 2025-05-02 17:50:45.916855
[1 rows x 5 columns]
2025-05-02 17:50:45,946 - 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-02 17:50:46,494 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2844 2025-04-28 5548.57
2845 2025-04-29 5548.57
2846 2025-04-30 5548.57
2847 2025-05-01 5548.57
2848 2025-05-02 5548.57
2025-05-02 17:50:46,556 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2848 2025-05-02 5548.57 ... 2025-05-02 17:50:46.548734 2025-05-02 17:50:46.549124
[1 rows x 5 columns]
2025-05-02 17:50:46,575 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-05-02 17:50:46,580 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2844 2025-04-28 5548.57
2845 2025-04-29 5548.57
2846 2025-04-30 5548.57
2847 2025-05-01 5548.57
2848 2025-05-02 5548.57
2025-05-02 17:50:46,643 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2852 2025-05-02 5548.57 ... 2025-05-02 17:50:46.636427 2025-05-02 17:50:46.636820
[1 rows x 5 columns]
2025-05-02 17:50:46,662 - 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-02 17:50:47,212 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3044 2025-04-28 3400.0
3045 2025-04-29 3400.0
3046 2025-04-30 3375.0
3047 2025-05-01 3375.0
3048 2025-05-02 3375.0
2025-05-02 17:50:47,277 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3048 2025-05-02 3375.0 ... 2025-05-02 17:50:47.269829 2025-05-02 17:50:47.270273
[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-02 17:50:47,427 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-05-02 17:50:47.419955
458 2015-09-21 ... 2025-05-02 17:50:47.419955
549 2016-02-03 ... 2025-05-02 17:50:47.419955
693 2016-09-05 ... 2025-05-02 17:50:47.419955
696 2016-09-08 ... 2025-05-02 17:50:47.419955
[5 rows x 6 columns]
2025-05-02 17:50:47,458 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3044 2025-04-28 3400.0
3045 2025-04-29 3400.0
3046 2025-04-30 3375.0
3047 2025-05-01 3375.0
3048 2025-05-02 3375.0
2025-05-02 17:50:47,523 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3051 2025-05-02 3375.0 ... 2025-05-02 17:50:47.516389 2025-05-02 17:50:47.516785
[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-02 17:50:47,676 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-05-02 17:50:47.667885
458 2015-09-21 ... 2025-05-02 17:50:47.667885
549 2016-02-03 ... 2025-05-02 17:50:47.667885
693 2016-09-05 ... 2025-05-02 17:50:47.667885
696 2016-09-08 ... 2025-05-02 17:50:47.667885
[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-02 17:50:48,276 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
848 2025-04-28 10040.0
849 2025-04-29 9960.0
850 2025-04-30 9880.0
851 2025-05-01 9880.0
852 2025-05-02 9880.0
2025-05-02 17:50:48,312 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
852 2025-05-02 9880.0 ... 2025-05-02 17:50:48.305530 2025-05-02 17:50:48.305915
[1 rows x 5 columns]
2025-05-02 17:50:48,333 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-05-02 17:50:48,339 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
848 2025-04-28 10040.0
849 2025-04-29 9960.0
850 2025-04-30 9880.0
851 2025-05-01 9880.0
852 2025-05-02 9880.0
2025-05-02 17:50:48,375 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
852 2025-05-02 9880.0 ... 2025-05-02 17:50:48.367983 2025-05-02 17:50:48.368394
[1 rows x 5 columns]
2025-05-02 17:50:48,393 - 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-02 17:50:48,970 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3727 2025-04-28 7571.67
3728 2025-04-29 7553.33
3729 2025-04-30 7553.33
3730 2025-05-01 7553.33
3731 2025-05-02 7553.33
2025-05-02 17:50:49,043 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3731 2025-05-02 7553.33 ... 2025-05-02 17:50:49.036319 2025-05-02 17:50:49.036723
[1 rows x 5 columns]
2025-05-02 17:50:49,063 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-05-02 17:50:49,070 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3727 2025-04-28 7571.67
3728 2025-04-29 7553.33
3729 2025-04-30 7553.33
3730 2025-05-01 7553.33
3731 2025-05-02 7553.33
2025-05-02 17:50:49,144 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3734 2025-05-02 7553.33 ... 2025-05-02 17:50:49.136524 2025-05-02 17:50:49.136974
[1 rows x 5 columns]
2025-05-02 17:50:49,163 - 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-02 17:50:49,727 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3065 2025-04-28 3615.0
3066 2025-04-29 3650.0
3067 2025-04-30 3647.5
3068 2025-05-01 3647.5
3069 2025-05-02 3647.5
2025-05-02 17:50:49,791 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3070 2025-05-02 3647.5 ... 2025-05-02 17:50:49.784259 2025-05-02 17:50:49.784658
[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-02 17:50:49,827 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-05-02 17:50:49.819925
[1 rows x 6 columns]
2025-05-02 17:50:49,851 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3065 2025-04-28 3615.0
3066 2025-04-29 3650.0
3067 2025-04-30 3647.5
3068 2025-05-01 3647.5
3069 2025-05-02 3647.5
2025-05-02 17:50:49,915 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3072 2025-05-02 3647.5 ... 2025-05-02 17:50:49.908424 2025-05-02 17:50:49.908815
[1 rows x 5 columns]
2025-05-02 17:50:49,934 - 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-02 17:50:50,503 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3730 2025-04-28 19966.67
3731 2025-04-29 19966.67
3732 2025-04-30 20073.33
3733 2025-05-01 20073.33
3734 2025-05-02 20073.33
2025-05-02 17:50:50,574 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date ... updated_at
3734 2025-05-02 ... 2025-05-02 17:50:50.567713
[1 rows x 5 columns]
2025-05-02 17:50:50,593 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-05-02 17:50:50,599 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3730 2025-04-28 19966.67
3731 2025-04-29 19966.67
3732 2025-04-30 20073.33
3733 2025-05-01 20073.33
3734 2025-05-02 20073.33
2025-05-02 17:50:50,682 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date ... updated_at
3737 2025-05-02 ... 2025-05-02 17:50:50.676024
[1 rows x 5 columns]
2025-05-02 17:50:50,702 - 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-02 17:50:51,307 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2844 2025-04-28 5652.0
2845 2025-04-29 5652.0
2846 2025-04-30 5640.0
2847 2025-05-01 5640.0
2848 2025-05-02 5640.0
2025-05-02 17:50:51,370 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2848 2025-05-02 5640.0 ... 2025-05-02 17:50:51.363039 2025-05-02 17:50:51.363467
[1 rows x 5 columns]
2025-05-02 17:50:51,389 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-05-02 17:50:51,395 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2844 2025-04-28 5652.0
2845 2025-04-29 5652.0
2846 2025-04-30 5640.0
2847 2025-05-01 5640.0
2848 2025-05-02 5640.0
2025-05-02 17:50:51,459 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2852 2025-05-02 5640.0 ... 2025-05-02 17:50:51.451877 2025-05-02 17:50:51.452309
[1 rows x 5 columns]
2025-05-02 17:50:51,478 - 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-02 17:50:52,053 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2119 2025-04-28 23825.0
2120 2025-04-29 23775.0
2121 2025-04-30 23775.0
2122 2025-05-01 23775.0
2123 2025-05-02 23775.0
2025-05-02 17:50:52,112 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2123 2025-05-02 23775.0 ... 2025-05-02 17:50:52.105076 2025-05-02 17:50:52.105500
[1 rows x 5 columns]
2025-05-02 17:50:52,132 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-05-02 17:50:52,138 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2119 2025-04-28 23825.0
2120 2025-04-29 23775.0
2121 2025-04-30 23775.0
2122 2025-05-01 23775.0
2123 2025-05-02 23775.0
2025-05-02 17:50:52,191 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2127 2025-05-02 23775.0 ... 2025-05-02 17:50:52.184223 2025-05-02 17:50:52.184618
[1 rows x 5 columns]
2025-05-02 17:50:52,210 - 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-02 17:50:52,760 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1634 2025-04-28 1865.00
1635 2025-04-29 1861.67
1636 2025-04-30 1870.00
1637 2025-05-01 1875.00
1638 2025-05-02 1875.00
2025-05-02 17:50:52,805 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1638 2025-05-02 1875.0 ... 2025-05-02 17:50:52.798550 2025-05-02 17:50:52.798932
[1 rows x 5 columns]
2025-05-02 17:50:52,825 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-05-02 17:50:52,831 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1634 2025-04-28 1865.00
1635 2025-04-29 1861.67
1636 2025-04-30 1870.00
1637 2025-05-01 1875.00
1638 2025-05-02 1875.00
2025-05-02 17:50:52,877 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1642 2025-05-02 1875.0 ... 2025-05-02 17:50:52.870130 2025-05-02 17:50:52.870542
[1 rows x 5 columns]
2025-05-02 17:50:52,896 - 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-02 17:50:53,450 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2706 2025-04-28 125033.33
2707 2025-04-29 125616.67
2708 2025-04-30 125175.00
2709 2025-05-01 125175.00
2710 2025-05-02 125175.00
2025-05-02 17:50:53,509 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2710 2025-05-02 ... 2025-05-02 17:50:53.502820
[1 rows x 5 columns]
2025-05-02 17:50:53,528 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-05-02 17:50:53,534 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2706 2025-04-28 125033.33
2707 2025-04-29 125616.67
2708 2025-04-30 125175.00
2709 2025-05-01 125175.00
2710 2025-05-02 125175.00
2025-05-02 17:50:53,595 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2713 2025-05-02 ... 2025-05-02 17:50:53.588613
[1 rows x 5 columns]
2025-05-02 17:50:53,614 - 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-02 17:50:54,194 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3731 2025-04-28 4695.0
3732 2025-04-29 4692.0
3733 2025-04-30 4679.0
3734 2025-05-01 4679.0
3735 2025-05-02 4679.0
2025-05-02 17:50:54,267 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3735 2025-05-02 4679.0 ... 2025-05-02 17:50:54.260154 2025-05-02 17:50:54.260627
[1 rows x 5 columns]
2025-05-02 17:50:54,287 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-05-02 17:50:54,294 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3731 2025-04-28 4695.0
3732 2025-04-29 4692.0
3733 2025-04-30 4679.0
3734 2025-05-01 4679.0
3735 2025-05-02 4679.0
2025-05-02 17:50:54,366 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3738 2025-05-02 4679.0 ... 2025-05-02 17:50:54.359555 2025-05-02 17:50:54.359940
[1 rows x 5 columns]
2025-05-02 17:50:54,386 - 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-02 17:50:54,983 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
2970 2025-04-28 7481.67
2971 2025-04-29 7481.67
2972 2025-04-30 7481.67
2973 2025-05-01 7481.67
2974 2025-05-02 7481.67
2025-05-02 17:50:55,047 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
2974 2025-05-02 7481.67 ... 2025-05-02 17:50:55.039657 2025-05-02 17:50:55.040042
[1 rows x 5 columns]
2025-05-02 17:50:55,066 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-05-02 17:50:55,072 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
2970 2025-04-28 7481.67
2971 2025-04-29 7481.67
2972 2025-04-30 7481.67
2973 2025-05-01 7481.67
2974 2025-05-02 7481.67
2025-05-02 17:50:55,136 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
2977 2025-05-02 7481.67 ... 2025-05-02 17:50:55.128737 2025-05-02 17:50:55.129177
[1 rows x 5 columns]
2025-05-02 17:50:55,154 - 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-02 17:50:55,784 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3732 2025-04-28 14273.33
3733 2025-04-29 14261.83
3734 2025-04-30 14208.83
3735 2025-05-01 14208.83
3736 2025-05-02 14208.83
2025-05-02 17:50:55,858 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date ... updated_at
3736 2025-05-02 ... 2025-05-02 17:50:55.852361
[1 rows x 5 columns]
2025-05-02 17:50:55,878 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-05-02 17:50:55,884 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3732 2025-04-28 14273.33
3733 2025-04-29 14261.83
3734 2025-04-30 14208.83
3735 2025-05-01 14208.83
3736 2025-05-02 14208.83
2025-05-02 17:50:55,960 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date ... updated_at
3740 2025-05-02 ... 2025-05-02 17:50:55.954362
[1 rows x 5 columns]
2025-05-02 17:50:55,980 - 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-02 17:50:56,536 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3677 2025-04-28 16875.0
3678 2025-04-29 16887.5
3679 2025-04-30 16812.5
3680 2025-05-01 16812.5
3681 2025-05-02 16812.5
2025-05-02 17:50:56,609 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date value ... created_at updated_at
3681 2025-05-02 16812.5 ... 2025-05-02 17:50:56.602055 2025-05-02 17:50:56.602477
[1 rows x 5 columns]
2025-05-02 17:50:56,629 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-05-02 17:50:56,636 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3677 2025-04-28 16875.0
3678 2025-04-29 16887.5
3679 2025-04-30 16812.5
3680 2025-05-01 16812.5
3681 2025-05-02 16812.5
2025-05-02 17:50:56,785 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date value ... created_at updated_at
3684 2025-05-02 16812.5 ... 2025-05-02 17:50:56.777377 2025-05-02 17:50:56.777775
[1 rows x 5 columns]
2025-05-02 17:50:56,804 - 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-02 17:50:57,372 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
2952 2025-04-28 3310.00
2953 2025-04-29 3273.33
2954 2025-04-30 3276.67
2955 2025-05-01 3276.67
2956 2025-05-02 3276.67
2025-05-02 17:50:57,434 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
2956 2025-05-02 3276.67 ... 2025-05-02 17:50:57.427455 2025-05-02 17:50:57.427851
[1 rows x 5 columns]
2025-05-02 17:50:57,453 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-05-02 17:50:57,459 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
2952 2025-04-28 3310.00
2953 2025-04-29 3273.33
2954 2025-04-30 3276.67
2955 2025-05-01 3276.67
2956 2025-05-02 3276.67
2025-05-02 17:50:57,521 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
2959 2025-05-02 3276.67 ... 2025-05-02 17:50:57.514335 2025-05-02 17:50:57.514731
[1 rows x 5 columns]
2025-05-02 17:50:57,542 - 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-02 17:50:58,098 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3232 2025-04-28 5475.0
3233 2025-04-29 5462.5
3234 2025-04-30 5462.5
3235 2025-05-01 5462.5
3236 2025-05-02 5462.5
2025-05-02 17:50:58,165 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3236 2025-05-02 5462.5 ... 2025-05-02 17:50:58.158143 2025-05-02 17:50:58.158570
[1 rows x 5 columns]
2025-05-02 17:50:58,184 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-05-02 17:50:58,190 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3232 2025-04-28 5475.0
3233 2025-04-29 5462.5
3234 2025-04-30 5462.5
3235 2025-05-01 5462.5
3236 2025-05-02 5462.5
2025-05-02 17:50:58,264 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3723 2025-05-02 5462.5 ... 2025-05-02 17:50:58.257087 2025-05-02 17:50:58.257501
[1 rows x 5 columns]
2025-05-02 17:50:58,283 - 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-02 17:50:58,822 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1296 2025-04-28 14870.0
1297 2025-04-29 14830.0
1298 2025-04-30 14830.0
1299 2025-05-01 14830.0
1300 2025-05-02 14830.0
2025-05-02 17:50:58,866 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1300 2025-05-02 14830.0 ... 2025-05-02 17:50:58.859081 2025-05-02 17:50:58.859509
[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-02 17:50:59,108 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-05-02 17:50:59.100472
117 2021-07-06 ... 2025-05-02 17:50:59.100472
121 2021-07-12 ... 2025-05-02 17:50:59.100472
122 2021-07-13 ... 2025-05-02 17:50:59.100472
194 2021-11-01 ... 2025-05-02 17:50:59.100472
[5 rows x 6 columns]
2025-05-02 17:50:59,147 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1296 2025-04-28 14870.0
1297 2025-04-29 14830.0
1298 2025-04-30 14830.0
1299 2025-05-01 14830.0
1300 2025-05-02 14830.0
2025-05-02 17:50:59,193 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1303 2025-05-02 14830.0 ... 2025-05-02 17:50:59.185314 2025-05-02 17:50:59.185716
[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-02 17:50:59,437 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-05-02 17:50:59.429502
117 2021-07-06 ... 2025-05-02 17:50:59.429502
121 2021-07-12 ... 2025-05-02 17:50:59.429502
122 2021-07-13 ... 2025-05-02 17:50:59.429502
194 2021-11-01 ... 2025-05-02 17:50:59.429502
[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-02 17:51:00,039 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3728 2025-04-28 77535.00
3729 2025-04-29 78101.67
3730 2025-04-30 77996.67
3731 2025-05-01 77996.67
3732 2025-05-02 77996.67
2025-05-02 17:51:00,112 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date ... updated_at
3732 2025-05-02 ... 2025-05-02 17:51:00.105511
[1 rows x 5 columns]
2025-05-02 17:51:00,131 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-05-02 17:51:00,138 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3728 2025-04-28 77535.00
3729 2025-04-29 78101.67
3730 2025-04-30 77996.67
3731 2025-05-01 77996.67
3732 2025-05-02 77996.67
2025-05-02 17:51:00,213 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date ... updated_at
3735 2025-05-02 ... 2025-05-02 17:51:00.206438
[1 rows x 5 columns]
2025-05-02 17:51:00,232 - 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-02 17:51:00,737 - 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-02 17:51:00,792 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-05-02 17:51:00,792 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-05-02 17:51:00,798 - 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-02 17:51:00,860 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-05-02 17:51:00,860 - 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-02 17:51:01,457 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2706 2025-04-28 260175.0
2707 2025-04-29 262175.0
2708 2025-04-30 261175.0
2709 2025-05-01 261175.0
2710 2025-05-02 261175.0
2025-05-02 17:51:01,517 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2710 2025-05-02 ... 2025-05-02 17:51:01.510835
[1 rows x 5 columns]
2025-05-02 17:51:01,537 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-05-02 17:51:01,543 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2706 2025-04-28 260175.0
2707 2025-04-29 262175.0
2708 2025-04-30 261175.0
2709 2025-05-01 261175.0
2710 2025-05-02 261175.0
2025-05-02 17:51:01,604 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2713 2025-05-02 ... 2025-05-02 17:51:01.598184
[1 rows x 5 columns]
2025-05-02 17:51:01,625 - 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-02 17:51:02,219 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3727 2025-04-28 22874.0
3728 2025-04-29 22970.0
3729 2025-04-30 22904.0
3730 2025-05-01 22904.0
3731 2025-05-02 22904.0
2025-05-02 17:51:02,299 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3731 2025-05-02 22904.0 ... 2025-05-02 17:51:02.291655 2025-05-02 17:51:02.292079
[1 rows x 5 columns]
2025-05-02 17:51:02,319 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-05-02 17:51:02,326 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3727 2025-04-28 22874.0
3728 2025-04-29 22970.0
3729 2025-04-30 22904.0
3730 2025-05-01 22904.0
3731 2025-05-02 22904.0
2025-05-02 17:51:02,400 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3734 2025-05-02 22904.0 ... 2025-05-02 17:51:02.392781 2025-05-02 17:51:02.393170
[1 rows x 5 columns]
2025-05-02 17:51:02,419 - 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-02 17:51:02,977 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3690 2025-04-28 3397.5
3691 2025-04-29 3387.5
3692 2025-04-30 3387.5
3693 2025-05-01 3377.5
3694 2025-05-02 3377.5
2025-05-02 17:51:03,050 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3694 2025-05-02 3377.5 ... 2025-05-02 17:51:03.043 2025-05-02 17:51:03.043423
[1 rows x 5 columns]
2025-05-02 17:51:03,070 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-05-02 17:51:03,076 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3690 2025-04-28 3397.5
3691 2025-04-29 3387.5
3692 2025-04-30 3387.5
3693 2025-05-01 3377.5
3694 2025-05-02 3377.5
2025-05-02 17:51:03,151 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3697 2025-05-02 3377.5 ... 2025-05-02 17:51:03.143529 2025-05-02 17:51:03.143917
[1 rows x 5 columns]
2025-05-02 17:51:03,170 - 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-02 17:51:03,725 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1487 2025-04-28 4967.5
1488 2025-04-29 4967.5
1489 2025-04-30 4980.0
1490 2025-05-01 4980.0
1491 2025-05-02 4980.0
2025-05-02 17:51:03,770 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1491 2025-05-02 4980.0 ... 2025-05-02 17:51:03.762697 2025-05-02 17:51:03.763085
[1 rows x 5 columns]
2025-05-02 17:51:03,790 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-05-02 17:51:03,796 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1487 2025-04-28 4967.5
1488 2025-04-29 4967.5
1489 2025-04-30 4980.0
1490 2025-05-01 4980.0
1491 2025-05-02 4980.0
2025-05-02 17:51:03,840 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1494 2025-05-02 4980.0 ... 2025-05-02 17:51:03.833582 2025-05-02 17:51:03.833965
[1 rows x 5 columns]
2025-05-02 17:51:03,860 - 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-02 17:51:04,436 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2761 2025-04-28 2232.86
2762 2025-04-29 2244.29
2763 2025-04-30 2252.86
2764 2025-05-01 2252.86
2765 2025-05-02 2252.86
2025-05-02 17:51:04,498 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2765 2025-05-02 2252.86 ... 2025-05-02 17:51:04.490713 2025-05-02 17:51:04.491184
[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-02 17:51:04,540 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2764 2025-05-01 ... 2025-05-02 17:51:04.532808
[1 rows x 6 columns]
2025-05-02 17:51:04,565 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2761 2025-04-28 2232.86
2762 2025-04-29 2244.29
2763 2025-04-30 2252.86
2764 2025-05-01 2252.86
2765 2025-05-02 2252.86
2025-05-02 17:51:04,625 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2768 2025-05-02 2252.86 ... 2025-05-02 17:51:04.618305 2025-05-02 17:51:04.618694
[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-02 17:51:04,667 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2767 2025-05-01 ... 2025-05-02 17:51:04.660239
[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-02 17:51:05,245 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2761 2025-04-28 2232.86
2762 2025-04-29 2244.29
2763 2025-04-30 2252.86
2764 2025-05-01 2252.86
2765 2025-05-02 2846.00
2025-05-02 17:51:05,299 - 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-02 17:51:05,324 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2765 2025-05-02 ... 2025-05-02 17:51:05.316977
[1 rows x 6 columns]
2025-05-02 17:51:05,350 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2761 2025-04-28 2232.86
2762 2025-04-29 2244.29
2763 2025-04-30 2252.86
2764 2025-05-01 2252.86
2765 2025-05-02 2846.00
2025-05-02 17:51:05,405 - 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-02 17:51:05,428 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2768 2025-05-02 ... 2025-05-02 17:51:05.421169
[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-02 17:51:05,968 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3118 2025-04-28 9411.67
3119 2025-04-29 9401.67
3120 2025-04-30 9378.33
3121 2025-05-01 9378.33
3122 2025-05-02 9378.33
2025-05-02 17:51:06,024 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-05-02 17:51:06,024 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-05-02 17:51:06,030 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3118 2025-04-28 9411.67
3119 2025-04-29 9401.67
3120 2025-04-30 9378.33
3121 2025-05-01 9378.33
3122 2025-05-02 9378.33
2025-05-02 17:51:06,086 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-05-02 17:51:06,087 - 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-02 17:51:06,650 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1802 2025-04-28 4343.33
1803 2025-04-29 4328.33
1804 2025-04-30 4331.67
1805 2025-05-01 4331.67
1806 2025-05-02 4331.67
2025-05-02 17:51:06,699 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1806 2025-05-02 4331.67 ... 2025-05-02 17:51:06.691858 2025-05-02 17:51:06.692275
[1 rows x 5 columns]
2025-05-02 17:51:06,718 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-05-02 17:51:06,724 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1802 2025-04-28 4343.33
1803 2025-04-29 4328.33
1804 2025-04-30 4331.67
1805 2025-05-01 4331.67
1806 2025-05-02 4331.67
2025-05-02 17:51:06,773 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1809 2025-05-02 4331.67 ... 2025-05-02 17:51:06.765801 2025-05-02 17:51:06.766181
[1 rows x 5 columns]
2025-05-02 17:51:06,792 - 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-02 17:51:07,331 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1811 2025-04-28 6366.67
1812 2025-04-29 6366.67
1813 2025-04-30 6250.00
1814 2025-05-01 6250.00
1815 2025-05-02 6250.00
2025-05-02 17:51:07,382 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1815 2025-05-02 6250.0 ... 2025-05-02 17:51:07.374476 2025-05-02 17:51:07.374924
[1 rows x 5 columns]
2025-05-02 17:51:07,402 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-05-02 17:51:07,409 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1811 2025-04-28 6366.67
1812 2025-04-29 6366.67
1813 2025-04-30 6250.00
1814 2025-05-01 6250.00
1815 2025-05-02 6250.00
2025-05-02 17:51:07,459 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1818 2025-05-02 6250.0 ... 2025-05-02 17:51:07.452051 2025-05-02 17:51:07.452470
[1 rows x 5 columns]
2025-05-02 17:51:07,478 - 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-02 17:51:08,081 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3479 2025-04-28 8920.0
3480 2025-04-29 8800.0
3481 2025-04-30 8760.0
3482 2025-05-01 8760.0
3483 2025-05-02 8760.0
2025-05-02 17:51:08,153 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3483 2025-05-02 8760.0 ... 2025-05-02 17:51:08.145857 2025-05-02 17:51:08.146275
[1 rows x 5 columns]
2025-05-02 17:51:08,172 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-05-02 17:51:08,178 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3479 2025-04-28 8920.0
3480 2025-04-29 8800.0
3481 2025-04-30 8760.0
3482 2025-05-01 8760.0
3483 2025-05-02 8760.0
2025-05-02 17:51:08,250 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3486 2025-05-02 8760.0 ... 2025-05-02 17:51:08.242859 2025-05-02 17:51:08.243269
[1 rows x 5 columns]
2025-05-02 17:51:08,270 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data