=========================================================================
2025-08-04 17:50:26 Mon START TASK.01 IOOppi_data update_data
=========================================================================
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-04 17:50:28,421 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3381 2025-07-31 3345.00
3382 2025-08-01 3331.50
3383 2025-08-02 3331.50
3384 2025-08-03 3331.50
3385 2025-08-04 3307.66
2025-08-04 17:50:28,503 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3382 2025-08-01 3331.50 ... 2025-08-04 17:50:28.494881 2025-08-04 17:50:28.495307
3383 2025-08-02 3331.50 ... 2025-08-04 17:50:28.494881 2025-08-04 17:50:28.495307
3384 2025-08-03 3331.50 ... 2025-08-04 17:50:28.494881 2025-08-04 17:50:28.495307
3385 2025-08-04 3307.66 ... 2025-08-04 17:50:28.494881 2025-08-04 17:50:28.495307
[4 rows x 5 columns]
2025-08-04 17:50:28,524 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-08-04 17:50:28,530 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3381 2025-07-31 3345.00
3382 2025-08-01 3331.50
3383 2025-08-02 3331.50
3384 2025-08-03 3331.50
3385 2025-08-04 3307.66
2025-08-04 17:50:28,603 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3385 2025-08-01 3331.50 ... 2025-08-04 17:50:28.595715 2025-08-04 17:50:28.596179
3386 2025-08-02 3331.50 ... 2025-08-04 17:50:28.595715 2025-08-04 17:50:28.596179
3387 2025-08-03 3331.50 ... 2025-08-04 17:50:28.595715 2025-08-04 17:50:28.596179
3388 2025-08-04 3307.66 ... 2025-08-04 17:50:28.595715 2025-08-04 17:50:28.596179
[4 rows x 5 columns]
2025-08-04 17:50:28,622 - 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-08-04 17:50:29,601 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3602 2025-07-31 2393.33
3603 2025-08-01 2389.17
3604 2025-08-02 2389.17
3605 2025-08-03 2389.17
3606 2025-08-04 2375.83
2025-08-04 17:50:29,677 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3603 2025-08-01 2389.17 ... 2025-08-04 17:50:29.669468 2025-08-04 17:50:29.669876
3604 2025-08-02 2389.17 ... 2025-08-04 17:50:29.669468 2025-08-04 17:50:29.669876
3605 2025-08-03 2389.17 ... 2025-08-04 17:50:29.669468 2025-08-04 17:50:29.669876
3606 2025-08-04 2375.83 ... 2025-08-04 17:50:29.669468 2025-08-04 17:50:29.669876
[4 rows x 5 columns]
2025-08-04 17:50:29,696 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-08-04 17:50:29,701 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3602 2025-07-31 2393.33
3603 2025-08-01 2389.17
3604 2025-08-02 2389.17
3605 2025-08-03 2389.17
3606 2025-08-04 2375.83
2025-08-04 17:50:29,778 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3607 2025-08-01 2389.17 ... 2025-08-04 17:50:29.769483 2025-08-04 17:50:29.769896
3608 2025-08-02 2389.17 ... 2025-08-04 17:50:29.769483 2025-08-04 17:50:29.769896
3609 2025-08-03 2389.17 ... 2025-08-04 17:50:29.769483 2025-08-04 17:50:29.769896
3610 2025-08-04 2375.83 ... 2025-08-04 17:50:29.769483 2025-08-04 17:50:29.769896
[4 rows x 5 columns]
2025-08-04 17:50:29,798 - 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-08-04 17:50:30,400 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
942 2025-07-31 4859.59
943 2025-08-01 4821.25
944 2025-08-02 4821.25
945 2025-08-03 4821.25
946 2025-08-04 4808.75
2025-08-04 17:50:30,440 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
943 2025-08-01 4821.25 ... 2025-08-04 17:50:30.432968 2025-08-04 17:50:30.433359
944 2025-08-02 4821.25 ... 2025-08-04 17:50:30.432968 2025-08-04 17:50:30.433359
945 2025-08-03 4821.25 ... 2025-08-04 17:50:30.432968 2025-08-04 17:50:30.433359
946 2025-08-04 4808.75 ... 2025-08-04 17:50:30.432968 2025-08-04 17:50:30.433359
[4 rows x 5 columns]
2025-08-04 17:50:30,459 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-08-04 17:50:30,465 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
942 2025-07-31 4859.59
943 2025-08-01 4821.25
944 2025-08-02 4821.25
945 2025-08-03 4821.25
946 2025-08-04 4808.75
2025-08-04 17:50:30,505 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
943 2025-08-01 4821.25 ... 2025-08-04 17:50:30.498445 2025-08-04 17:50:30.498850
944 2025-08-02 4821.25 ... 2025-08-04 17:50:30.498445 2025-08-04 17:50:30.498850
945 2025-08-03 4821.25 ... 2025-08-04 17:50:30.498445 2025-08-04 17:50:30.498850
946 2025-08-04 4808.75 ... 2025-08-04 17:50:30.498445 2025-08-04 17:50:30.498850
[4 rows x 5 columns]
2025-08-04 17:50:30,524 - 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-08-04 17:50:31,274 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3821 2025-07-31 14700.00
3822 2025-08-01 14458.33
3823 2025-08-02 14458.33
3824 2025-08-03 14458.33
3825 2025-08-04 14433.33
2025-08-04 17:50:31,354 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3822 2025-08-01 ... 2025-08-04 17:50:31.347248
3823 2025-08-02 ... 2025-08-04 17:50:31.347248
3824 2025-08-03 ... 2025-08-04 17:50:31.347248
3825 2025-08-04 ... 2025-08-04 17:50:31.347248
[4 rows x 5 columns]
2025-08-04 17:50:31,373 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-08-04 17:50:31,379 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3821 2025-07-31 14700.00
3822 2025-08-01 14458.33
3823 2025-08-02 14458.33
3824 2025-08-03 14458.33
3825 2025-08-04 14433.33
2025-08-04 17:50:31,456 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3825 2025-08-01 ... 2025-08-04 17:50:31.449114
3826 2025-08-02 ... 2025-08-04 17:50:31.449114
3827 2025-08-03 ... 2025-08-04 17:50:31.449114
3828 2025-08-04 ... 2025-08-04 17:50:31.449114
[4 rows x 5 columns]
2025-08-04 17:50:31,474 - 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-08-04 17:50:32,166 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3153 2025-07-31 786.22
3154 2025-08-01 786.22
3155 2025-08-02 786.22
3156 2025-08-03 786.22
3157 2025-08-04 780.67
2025-08-04 17:50:32,233 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3154 2025-08-01 786.22 ... 2025-08-04 17:50:32.225728 2025-08-04 17:50:32.226143
3155 2025-08-02 786.22 ... 2025-08-04 17:50:32.225728 2025-08-04 17:50:32.226143
3156 2025-08-03 786.22 ... 2025-08-04 17:50:32.225728 2025-08-04 17:50:32.226143
3157 2025-08-04 780.67 ... 2025-08-04 17:50:32.225728 2025-08-04 17:50:32.226143
[4 rows x 5 columns]
2025-08-04 17:50:32,251 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-08-04 17:50:32,257 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3153 2025-07-31 786.22
3154 2025-08-01 786.22
3155 2025-08-02 786.22
3156 2025-08-03 786.22
3157 2025-08-04 780.67
2025-08-04 17:50:32,325 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3157 2025-08-01 786.22 ... 2025-08-04 17:50:32.317861 2025-08-04 17:50:32.318245
3158 2025-08-02 786.22 ... 2025-08-04 17:50:32.317861 2025-08-04 17:50:32.318245
3159 2025-08-03 786.22 ... 2025-08-04 17:50:32.317861 2025-08-04 17:50:32.318245
3160 2025-08-04 780.67 ... 2025-08-04 17:50:32.317861 2025-08-04 17:50:32.318245
[4 rows x 5 columns]
2025-08-04 17:50:32,344 - 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-08-04 17:50:32,928 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3356 2025-07-31 1284.0
3357 2025-08-01 1284.0
3358 2025-08-02 1284.0
3359 2025-08-03 1284.0
3360 2025-08-04 1234.4
2025-08-04 17:50:32,999 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3357 2025-08-01 1284.0 ... 2025-08-04 17:50:32.991984 2025-08-04 17:50:32.992385
3358 2025-08-02 1284.0 ... 2025-08-04 17:50:32.991984 2025-08-04 17:50:32.992385
3359 2025-08-03 1284.0 ... 2025-08-04 17:50:32.991984 2025-08-04 17:50:32.992385
3360 2025-08-04 1234.4 ... 2025-08-04 17:50:32.991984 2025-08-04 17:50:32.992385
[4 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-08-04 17:50:34,998 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-08-04 17:50:34.990585
21 2013-01-04 ... 2025-08-04 17:50:34.990585
54 2013-02-27 ... 2025-08-04 17:50:34.990585
60 2013-03-07 ... 2025-08-04 17:50:34.990585
61 2013-03-08 ... 2025-08-04 17:50:34.990585
[5 rows x 6 columns]
2025-08-04 17:50:35,161 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3356 2025-07-31 1284.0
3357 2025-08-01 1284.0
3358 2025-08-02 1284.0
3359 2025-08-03 1284.0
3360 2025-08-04 1234.4
2025-08-04 17:50:35,232 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3361 2025-08-01 1284.0 ... 2025-08-04 17:50:35.225014 2025-08-04 17:50:35.225404
3362 2025-08-02 1284.0 ... 2025-08-04 17:50:35.225014 2025-08-04 17:50:35.225404
3363 2025-08-03 1284.0 ... 2025-08-04 17:50:35.225014 2025-08-04 17:50:35.225404
3364 2025-08-04 1234.4 ... 2025-08-04 17:50:35.225014 2025-08-04 17:50:35.225404
[4 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-08-04 17:50:37,152 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-08-04 17:50:37.144636
21 2013-01-04 ... 2025-08-04 17:50:37.144636
54 2013-02-27 ... 2025-08-04 17:50:37.144636
60 2013-03-07 ... 2025-08-04 17:50:37.144636
61 2013-03-08 ... 2025-08-04 17:50:37.144636
[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-08-04 17:50:37,915 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1701 2025-07-31 7694.0
1702 2025-08-01 7646.0
1703 2025-08-02 7646.0
1704 2025-08-03 7646.0
1705 2025-08-04 7610.0
2025-08-04 17:50:37,963 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1702 2025-08-01 7646.0 ... 2025-08-04 17:50:37.956343 2025-08-04 17:50:37.956721
1703 2025-08-02 7646.0 ... 2025-08-04 17:50:37.956343 2025-08-04 17:50:37.956721
1704 2025-08-03 7646.0 ... 2025-08-04 17:50:37.956343 2025-08-04 17:50:37.956721
1705 2025-08-04 7610.0 ... 2025-08-04 17:50:37.956343 2025-08-04 17:50:37.956721
[4 rows x 5 columns]
2025-08-04 17:50:37,983 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-08-04 17:50:37,988 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1701 2025-07-31 7694.0
1702 2025-08-01 7646.0
1703 2025-08-02 7646.0
1704 2025-08-03 7646.0
1705 2025-08-04 7610.0
2025-08-04 17:50:38,035 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1705 2025-08-01 7646.0 ... 2025-08-04 17:50:38.028258 2025-08-04 17:50:38.028630
1706 2025-08-02 7646.0 ... 2025-08-04 17:50:38.028258 2025-08-04 17:50:38.028630
1707 2025-08-03 7646.0 ... 2025-08-04 17:50:38.028258 2025-08-04 17:50:38.028630
1708 2025-08-04 7610.0 ... 2025-08-04 17:50:38.028258 2025-08-04 17:50:38.028630
[4 rows x 5 columns]
2025-08-04 17:50:38,055 - 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-08-04 17:50:38,640 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3812 2025-07-31 6036.67
3813 2025-08-01 6036.67
3814 2025-08-02 6036.67
3815 2025-08-03 6036.67
3816 2025-08-04 6030.00
2025-08-04 17:50:38,712 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3813 2025-08-01 6036.67 ... 2025-08-04 17:50:38.705247 2025-08-04 17:50:38.705628
3814 2025-08-02 6036.67 ... 2025-08-04 17:50:38.705247 2025-08-04 17:50:38.705628
3815 2025-08-03 6036.67 ... 2025-08-04 17:50:38.705247 2025-08-04 17:50:38.705628
3816 2025-08-04 6030.00 ... 2025-08-04 17:50:38.705247 2025-08-04 17:50:38.705628
[4 rows x 5 columns]
2025-08-04 17:50:38,731 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-08-04 17:50:38,737 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3812 2025-07-31 6036.67
3813 2025-08-01 6036.67
3814 2025-08-02 6036.67
3815 2025-08-03 6036.67
3816 2025-08-04 6030.00
2025-08-04 17:50:38,809 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3817 2025-08-01 6036.67 ... 2025-08-04 17:50:38.802367 2025-08-04 17:50:38.802771
3818 2025-08-02 6036.67 ... 2025-08-04 17:50:38.802367 2025-08-04 17:50:38.802771
3819 2025-08-03 6036.67 ... 2025-08-04 17:50:38.802367 2025-08-04 17:50:38.802771
3820 2025-08-04 6030.00 ... 2025-08-04 17:50:38.802367 2025-08-04 17:50:38.802771
[4 rows x 5 columns]
2025-08-04 17:50:38,827 - 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-08-04 17:50:39,475 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1702 2025-07-31 13080.0
1703 2025-08-01 13080.0
1704 2025-08-02 13080.0
1705 2025-08-03 13080.0
1706 2025-08-04 13100.0
2025-08-04 17:50:39,522 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1703 2025-08-01 13080.0 ... 2025-08-04 17:50:39.514520 2025-08-04 17:50:39.514936
1704 2025-08-02 13080.0 ... 2025-08-04 17:50:39.514520 2025-08-04 17:50:39.514936
1705 2025-08-03 13080.0 ... 2025-08-04 17:50:39.514520 2025-08-04 17:50:39.514936
1706 2025-08-04 13100.0 ... 2025-08-04 17:50:39.514520 2025-08-04 17:50:39.514936
[4 rows x 5 columns]
2025-08-04 17:50:39,542 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-08-04 17:50:39,548 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1702 2025-07-31 13080.0
1703 2025-08-01 13080.0
1704 2025-08-02 13080.0
1705 2025-08-03 13080.0
1706 2025-08-04 13100.0
2025-08-04 17:50:39,594 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1706 2025-08-01 13080.0 ... 2025-08-04 17:50:39.587314 2025-08-04 17:50:39.587695
1707 2025-08-02 13080.0 ... 2025-08-04 17:50:39.587314 2025-08-04 17:50:39.587695
1708 2025-08-03 13080.0 ... 2025-08-04 17:50:39.587314 2025-08-04 17:50:39.587695
1709 2025-08-04 13100.0 ... 2025-08-04 17:50:39.587314 2025-08-04 17:50:39.587695
[4 rows x 5 columns]
2025-08-04 17:50:39,613 - 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-08-04 17:50:40,380 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3212 2025-07-31 9621.67
3213 2025-08-01 9623.33
3214 2025-08-02 9623.33
3215 2025-08-03 9623.33
3216 2025-08-04 9623.33
2025-08-04 17:50:40,447 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date value ... created_at updated_at
3213 2025-08-01 9623.33 ... 2025-08-04 17:50:40.440162 2025-08-04 17:50:40.440547
3214 2025-08-02 9623.33 ... 2025-08-04 17:50:40.440162 2025-08-04 17:50:40.440547
3215 2025-08-03 9623.33 ... 2025-08-04 17:50:40.440162 2025-08-04 17:50:40.440547
3216 2025-08-04 9623.33 ... 2025-08-04 17:50:40.440162 2025-08-04 17:50:40.440547
[4 rows x 5 columns]
2025-08-04 17:50:40,466 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-08-04 17:50:40,472 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3212 2025-07-31 9621.67
3213 2025-08-01 9623.33
3214 2025-08-02 9623.33
3215 2025-08-03 9623.33
3216 2025-08-04 9623.33
2025-08-04 17:50:40,536 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date value ... created_at updated_at
3217 2025-08-01 9623.33 ... 2025-08-04 17:50:40.529038 2025-08-04 17:50:40.529420
3218 2025-08-02 9623.33 ... 2025-08-04 17:50:40.529038 2025-08-04 17:50:40.529420
3219 2025-08-03 9623.33 ... 2025-08-04 17:50:40.529038 2025-08-04 17:50:40.529420
3220 2025-08-04 9623.33 ... 2025-08-04 17:50:40.529038 2025-08-04 17:50:40.529420
[4 rows x 5 columns]
2025-08-04 17:50:40,555 - 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-08-04 17:50:41,247 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3335 2025-07-31 2656.67
3336 2025-08-01 2650.00
3337 2025-08-02 2650.00
3338 2025-08-03 2650.00
3339 2025-08-04 2653.33
2025-08-04 17:50:41,316 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3336 2025-08-01 2650.00 ... 2025-08-04 17:50:41.308147 2025-08-04 17:50:41.308535
3337 2025-08-02 2650.00 ... 2025-08-04 17:50:41.308147 2025-08-04 17:50:41.308535
3338 2025-08-03 2650.00 ... 2025-08-04 17:50:41.308147 2025-08-04 17:50:41.308535
3339 2025-08-04 2653.33 ... 2025-08-04 17:50:41.308147 2025-08-04 17:50:41.308535
[4 rows x 5 columns]
2025-08-04 17:50:41,334 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-08-04 17:50:41,340 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3335 2025-07-31 2656.67
3336 2025-08-01 2650.00
3337 2025-08-02 2650.00
3338 2025-08-03 2650.00
3339 2025-08-04 2653.33
2025-08-04 17:50:41,410 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3340 2025-08-01 2650.00 ... 2025-08-04 17:50:41.402797 2025-08-04 17:50:41.403190
3341 2025-08-02 2650.00 ... 2025-08-04 17:50:41.402797 2025-08-04 17:50:41.403190
3342 2025-08-03 2650.00 ... 2025-08-04 17:50:41.402797 2025-08-04 17:50:41.403190
3343 2025-08-04 2653.33 ... 2025-08-04 17:50:41.402797 2025-08-04 17:50:41.403190
[4 rows x 5 columns]
2025-08-04 17:50:41,428 - 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-08-04 17:50:42,095 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1539 2025-07-31 1315.0
1540 2025-08-01 1315.0
1541 2025-08-02 1315.0
1542 2025-08-03 1315.0
1543 2025-08-04 1315.0
2025-08-04 17:50:42,147 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1540 2025-08-01 1315.0 ... 2025-08-04 17:50:42.139721 2025-08-04 17:50:42.140154
1541 2025-08-02 1315.0 ... 2025-08-04 17:50:42.139721 2025-08-04 17:50:42.140154
1542 2025-08-03 1315.0 ... 2025-08-04 17:50:42.139721 2025-08-04 17:50:42.140154
1543 2025-08-04 1315.0 ... 2025-08-04 17:50:42.139721 2025-08-04 17:50:42.140154
[4 rows x 5 columns]
2025-08-04 17:50:42,166 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-08-04 17:50:42,172 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1539 2025-07-31 1315.0
1540 2025-08-01 1315.0
1541 2025-08-02 1315.0
1542 2025-08-03 1315.0
1543 2025-08-04 1315.0
2025-08-04 17:50:42,218 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1544 2025-08-01 1315.0 ... 2025-08-04 17:50:42.210445 2025-08-04 17:50:42.210859
1545 2025-08-02 1315.0 ... 2025-08-04 17:50:42.210445 2025-08-04 17:50:42.210859
1546 2025-08-03 1315.0 ... 2025-08-04 17:50:42.210445 2025-08-04 17:50:42.210859
1547 2025-08-04 1315.0 ... 2025-08-04 17:50:42.210445 2025-08-04 17:50:42.210859
[4 rows x 5 columns]
2025-08-04 17:50:42,236 - 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-08-04 17:50:42,850 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1452 2025-07-31 6600.00
1453 2025-08-01 6576.67
1454 2025-08-02 6576.67
1455 2025-08-03 6576.67
1456 2025-08-04 6532.92
2025-08-04 17:50:42,894 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1453 2025-08-01 6576.67 ... 2025-08-04 17:50:42.886712 2025-08-04 17:50:42.887125
1454 2025-08-02 6576.67 ... 2025-08-04 17:50:42.886712 2025-08-04 17:50:42.887125
1455 2025-08-03 6576.67 ... 2025-08-04 17:50:42.886712 2025-08-04 17:50:42.887125
1456 2025-08-04 6532.92 ... 2025-08-04 17:50:42.886712 2025-08-04 17:50:42.887125
[4 rows x 5 columns]
2025-08-04 17:50:42,912 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-08-04 17:50:42,918 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1452 2025-07-31 6600.00
1453 2025-08-01 6576.67
1454 2025-08-02 6576.67
1455 2025-08-03 6576.67
1456 2025-08-04 6532.92
2025-08-04 17:50:42,963 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1457 2025-08-01 6576.67 ... 2025-08-04 17:50:42.955500 2025-08-04 17:50:42.955928
1458 2025-08-02 6576.67 ... 2025-08-04 17:50:42.955500 2025-08-04 17:50:42.955928
1459 2025-08-03 6576.67 ... 2025-08-04 17:50:42.955500 2025-08-04 17:50:42.955928
1460 2025-08-04 6532.92 ... 2025-08-04 17:50:42.955500 2025-08-04 17:50:42.955928
[4 rows x 5 columns]
2025-08-04 17:50:42,982 - 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-08-04 17:50:43,597 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3825 2025-07-31 2984.0
3826 2025-08-01 2998.0
3827 2025-08-02 2998.0
3828 2025-08-03 2998.0
3829 2025-08-04 3016.0
2025-08-04 17:50:43,674 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3826 2025-08-01 2998.0 ... 2025-08-04 17:50:43.666918 2025-08-04 17:50:43.667320
3827 2025-08-02 2998.0 ... 2025-08-04 17:50:43.666918 2025-08-04 17:50:43.667320
3828 2025-08-03 2998.0 ... 2025-08-04 17:50:43.666918 2025-08-04 17:50:43.667320
3829 2025-08-04 3016.0 ... 2025-08-04 17:50:43.666918 2025-08-04 17:50:43.667320
[4 rows x 5 columns]
2025-08-04 17:50:43,693 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-08-04 17:50:43,700 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3825 2025-07-31 2984.0
3826 2025-08-01 2998.0
3827 2025-08-02 2998.0
3828 2025-08-03 2998.0
3829 2025-08-04 3016.0
2025-08-04 17:50:43,778 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3829 2025-08-01 2998.0 ... 2025-08-04 17:50:43.770829 2025-08-04 17:50:43.771264
3830 2025-08-02 2998.0 ... 2025-08-04 17:50:43.770829 2025-08-04 17:50:43.771264
3831 2025-08-03 2998.0 ... 2025-08-04 17:50:43.770829 2025-08-04 17:50:43.771264
3832 2025-08-04 3016.0 ... 2025-08-04 17:50:43.770829 2025-08-04 17:50:43.771264
[4 rows x 5 columns]
2025-08-04 17:50:43,796 - 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-08-04 17:50:44,402 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3595 2025-07-31 8454.0
3596 2025-08-01 8484.0
3597 2025-08-02 8484.0
3598 2025-08-03 8484.0
3599 2025-08-04 8428.0
2025-08-04 17:50:44,473 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3596 2025-08-01 8484.0 ... 2025-08-04 17:50:44.465874 2025-08-04 17:50:44.466263
3597 2025-08-02 8484.0 ... 2025-08-04 17:50:44.465874 2025-08-04 17:50:44.466263
3598 2025-08-03 8484.0 ... 2025-08-04 17:50:44.465874 2025-08-04 17:50:44.466263
3599 2025-08-04 8428.0 ... 2025-08-04 17:50:44.465874 2025-08-04 17:50:44.466263
[4 rows x 5 columns]
2025-08-04 17:50:44,491 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-08-04 17:50:44,497 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3595 2025-07-31 8454.0
3596 2025-08-01 8484.0
3597 2025-08-02 8484.0
3598 2025-08-03 8484.0
3599 2025-08-04 8428.0
2025-08-04 17:50:44,569 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3599 2025-08-01 8484.0 ... 2025-08-04 17:50:44.562110 2025-08-04 17:50:44.562543
3600 2025-08-02 8484.0 ... 2025-08-04 17:50:44.562110 2025-08-04 17:50:44.562543
3601 2025-08-03 8484.0 ... 2025-08-04 17:50:44.562110 2025-08-04 17:50:44.562543
3602 2025-08-04 8428.0 ... 2025-08-04 17:50:44.562110 2025-08-04 17:50:44.562543
[4 rows x 5 columns]
2025-08-04 17:50:44,587 - 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-08-04 17:50:45,168 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3561 2025-07-31 4295.0
3562 2025-08-01 4300.0
3563 2025-08-02 4300.0
3564 2025-08-03 4300.0
3565 2025-08-04 4300.0
2025-08-04 17:50:45,235 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3562 2025-08-01 4300.0 ... 2025-08-04 17:50:45.227736 2025-08-04 17:50:45.228147
3563 2025-08-02 4300.0 ... 2025-08-04 17:50:45.227736 2025-08-04 17:50:45.228147
3564 2025-08-03 4300.0 ... 2025-08-04 17:50:45.227736 2025-08-04 17:50:45.228147
3565 2025-08-04 4300.0 ... 2025-08-04 17:50:45.227736 2025-08-04 17:50:45.228147
[4 rows x 5 columns]
2025-08-04 17:50:45,254 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-08-04 17:50:45,260 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3561 2025-07-31 4295.0
3562 2025-08-01 4300.0
3563 2025-08-02 4300.0
3564 2025-08-03 4300.0
3565 2025-08-04 4300.0
2025-08-04 17:50:45,328 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3565 2025-08-01 4300.0 ... 2025-08-04 17:50:45.320916 2025-08-04 17:50:45.321299
3566 2025-08-02 4300.0 ... 2025-08-04 17:50:45.320916 2025-08-04 17:50:45.321299
3567 2025-08-03 4300.0 ... 2025-08-04 17:50:45.320916 2025-08-04 17:50:45.321299
3568 2025-08-04 4300.0 ... 2025-08-04 17:50:45.320916 2025-08-04 17:50:45.321299
[4 rows x 5 columns]
2025-08-04 17:50:45,348 - 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-08-04 17:50:46,261 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2938 2025-07-31 5528.57
2939 2025-08-01 5485.71
2940 2025-08-02 5485.71
2941 2025-08-03 5485.71
2942 2025-08-04 5485.71
2025-08-04 17:50:46,326 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2939 2025-08-01 5485.71 ... 2025-08-04 17:50:46.317802 2025-08-04 17:50:46.318195
2940 2025-08-02 5485.71 ... 2025-08-04 17:50:46.317802 2025-08-04 17:50:46.318195
2941 2025-08-03 5485.71 ... 2025-08-04 17:50:46.317802 2025-08-04 17:50:46.318195
2942 2025-08-04 5485.71 ... 2025-08-04 17:50:46.317802 2025-08-04 17:50:46.318195
[4 rows x 5 columns]
2025-08-04 17:50:46,345 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-08-04 17:50:46,352 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2938 2025-07-31 5528.57
2939 2025-08-01 5485.71
2940 2025-08-02 5485.71
2941 2025-08-03 5485.71
2942 2025-08-04 5485.71
2025-08-04 17:50:46,415 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2943 2025-08-01 5485.71 ... 2025-08-04 17:50:46.406678 2025-08-04 17:50:46.407344
2944 2025-08-02 5485.71 ... 2025-08-04 17:50:46.406678 2025-08-04 17:50:46.407344
2945 2025-08-03 5485.71 ... 2025-08-04 17:50:46.406678 2025-08-04 17:50:46.407344
2946 2025-08-04 5485.71 ... 2025-08-04 17:50:46.406678 2025-08-04 17:50:46.407344
[4 rows x 5 columns]
2025-08-04 17:50:46,433 - 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-08-04 17:50:46,978 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3138 2025-07-31 3335.0
3139 2025-08-01 3325.0
3140 2025-08-02 3325.0
3141 2025-08-03 3325.0
3142 2025-08-04 3210.0
2025-08-04 17:50:47,042 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3139 2025-08-01 3325.0 ... 2025-08-04 17:50:47.034780 2025-08-04 17:50:47.035173
3140 2025-08-02 3325.0 ... 2025-08-04 17:50:47.034780 2025-08-04 17:50:47.035173
3141 2025-08-03 3325.0 ... 2025-08-04 17:50:47.034780 2025-08-04 17:50:47.035173
3142 2025-08-04 3210.0 ... 2025-08-04 17:50:47.034780 2025-08-04 17:50:47.035173
[4 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-08-04 17:50:47,188 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-08-04 17:50:47.181009
458 2015-09-21 ... 2025-08-04 17:50:47.181009
549 2016-02-03 ... 2025-08-04 17:50:47.181009
693 2016-09-05 ... 2025-08-04 17:50:47.181009
696 2016-09-08 ... 2025-08-04 17:50:47.181009
[5 rows x 6 columns]
2025-08-04 17:50:47,219 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3138 2025-07-31 3335.0
3139 2025-08-01 3325.0
3140 2025-08-02 3325.0
3141 2025-08-03 3325.0
3142 2025-08-04 3210.0
2025-08-04 17:50:47,287 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3142 2025-08-01 3325.0 ... 2025-08-04 17:50:47.279245 2025-08-04 17:50:47.279625
3143 2025-08-02 3325.0 ... 2025-08-04 17:50:47.279245 2025-08-04 17:50:47.279625
3144 2025-08-03 3325.0 ... 2025-08-04 17:50:47.279245 2025-08-04 17:50:47.279625
3145 2025-08-04 3210.0 ... 2025-08-04 17:50:47.279245 2025-08-04 17:50:47.279625
[4 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-08-04 17:50:47,440 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-08-04 17:50:47.432221
458 2015-09-21 ... 2025-08-04 17:50:47.432221
549 2016-02-03 ... 2025-08-04 17:50:47.432221
693 2016-09-05 ... 2025-08-04 17:50:47.432221
696 2016-09-08 ... 2025-08-04 17:50:47.432221
[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-08-04 17:50:48,116 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
942 2025-07-31 10000.0
943 2025-08-01 9980.0
944 2025-08-02 9980.0
945 2025-08-03 9980.0
946 2025-08-04 9780.0
2025-08-04 17:50:48,152 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
943 2025-08-01 9980.0 ... 2025-08-04 17:50:48.145208 2025-08-04 17:50:48.145605
944 2025-08-02 9980.0 ... 2025-08-04 17:50:48.145208 2025-08-04 17:50:48.145605
945 2025-08-03 9980.0 ... 2025-08-04 17:50:48.145208 2025-08-04 17:50:48.145605
946 2025-08-04 9780.0 ... 2025-08-04 17:50:48.145208 2025-08-04 17:50:48.145605
[4 rows x 5 columns]
2025-08-04 17:50:48,171 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-08-04 17:50:48,176 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
942 2025-07-31 10000.0
943 2025-08-01 9980.0
944 2025-08-02 9980.0
945 2025-08-03 9980.0
946 2025-08-04 9780.0
2025-08-04 17:50:48,211 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
943 2025-08-01 9980.0 ... 2025-08-04 17:50:48.204649 2025-08-04 17:50:48.205048
944 2025-08-02 9980.0 ... 2025-08-04 17:50:48.204649 2025-08-04 17:50:48.205048
945 2025-08-03 9980.0 ... 2025-08-04 17:50:48.204649 2025-08-04 17:50:48.205048
946 2025-08-04 9780.0 ... 2025-08-04 17:50:48.204649 2025-08-04 17:50:48.205048
[4 rows x 5 columns]
2025-08-04 17:50:48,232 - 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-08-04 17:50:48,921 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3821 2025-07-31 7466.67
3822 2025-08-01 7453.33
3823 2025-08-02 7453.33
3824 2025-08-03 7453.33
3825 2025-08-04 7441.67
2025-08-04 17:50:48,994 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3822 2025-08-01 7453.33 ... 2025-08-04 17:50:48.986688 2025-08-04 17:50:48.987131
3823 2025-08-02 7453.33 ... 2025-08-04 17:50:48.986688 2025-08-04 17:50:48.987131
3824 2025-08-03 7453.33 ... 2025-08-04 17:50:48.986688 2025-08-04 17:50:48.987131
3825 2025-08-04 7441.67 ... 2025-08-04 17:50:48.986688 2025-08-04 17:50:48.987131
[4 rows x 5 columns]
2025-08-04 17:50:49,015 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-08-04 17:50:49,021 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3821 2025-07-31 7466.67
3822 2025-08-01 7453.33
3823 2025-08-02 7453.33
3824 2025-08-03 7453.33
3825 2025-08-04 7441.67
2025-08-04 17:50:49,094 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3825 2025-08-01 7453.33 ... 2025-08-04 17:50:49.086979 2025-08-04 17:50:49.087369
3826 2025-08-02 7453.33 ... 2025-08-04 17:50:49.086979 2025-08-04 17:50:49.087369
3827 2025-08-03 7453.33 ... 2025-08-04 17:50:49.086979 2025-08-04 17:50:49.087369
3828 2025-08-04 7441.67 ... 2025-08-04 17:50:49.086979 2025-08-04 17:50:49.087369
[4 rows x 5 columns]
2025-08-04 17:50:49,113 - 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-08-04 17:50:49,700 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3159 2025-07-31 3726.67
3160 2025-08-01 3730.00
3161 2025-08-02 3730.00
3162 2025-08-03 3730.00
3163 2025-08-04 3726.67
2025-08-04 17:50:49,765 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3161 2025-08-01 3730.00 ... 2025-08-04 17:50:49.757836 2025-08-04 17:50:49.758224
3162 2025-08-02 3730.00 ... 2025-08-04 17:50:49.757836 2025-08-04 17:50:49.758224
3163 2025-08-03 3730.00 ... 2025-08-04 17:50:49.757836 2025-08-04 17:50:49.758224
3164 2025-08-04 3726.67 ... 2025-08-04 17:50:49.757836 2025-08-04 17:50:49.758224
[4 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-08-04 17:50:49,800 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-08-04 17:50:49.793107
[1 rows x 6 columns]
2025-08-04 17:50:49,823 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3159 2025-07-31 3726.67
3160 2025-08-01 3730.00
3161 2025-08-02 3730.00
3162 2025-08-03 3730.00
3163 2025-08-04 3726.67
2025-08-04 17:50:49,886 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3163 2025-08-01 3730.00 ... 2025-08-04 17:50:49.879350 2025-08-04 17:50:49.879731
3164 2025-08-02 3730.00 ... 2025-08-04 17:50:49.879350 2025-08-04 17:50:49.879731
3165 2025-08-03 3730.00 ... 2025-08-04 17:50:49.879350 2025-08-04 17:50:49.879731
3166 2025-08-04 3726.67 ... 2025-08-04 17:50:49.879350 2025-08-04 17:50:49.879731
[4 rows x 5 columns]
2025-08-04 17:50:49,905 - 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-08-04 17:50:50,528 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3824 2025-07-31 20596.67
3825 2025-08-01 20596.67
3826 2025-08-02 20536.67
3827 2025-08-03 20536.67
3828 2025-08-04 20493.33
2025-08-04 17:50:50,600 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date ... updated_at
3825 2025-08-01 ... 2025-08-04 17:50:50.594350
3826 2025-08-02 ... 2025-08-04 17:50:50.594350
3827 2025-08-03 ... 2025-08-04 17:50:50.594350
3828 2025-08-04 ... 2025-08-04 17:50:50.594350
[4 rows x 5 columns]
2025-08-04 17:50:50,620 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-08-04 17:50:50,626 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3824 2025-07-31 20596.67
3825 2025-08-01 20596.67
3826 2025-08-02 20536.67
3827 2025-08-03 20536.67
3828 2025-08-04 20493.33
2025-08-04 17:50:50,699 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date ... updated_at
3828 2025-08-01 ... 2025-08-04 17:50:50.692809
3829 2025-08-02 ... 2025-08-04 17:50:50.692809
3830 2025-08-03 ... 2025-08-04 17:50:50.692809
3831 2025-08-04 ... 2025-08-04 17:50:50.692809
[4 rows x 5 columns]
2025-08-04 17:50:50,717 - 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-08-04 17:50:51,577 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2938 2025-07-31 5876.0
2939 2025-08-01 5836.0
2940 2025-08-02 5836.0
2941 2025-08-03 5836.0
2942 2025-08-04 5816.0
2025-08-04 17:50:51,638 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2939 2025-08-01 5836.0 ... 2025-08-04 17:50:51.631474 2025-08-04 17:50:51.631880
2940 2025-08-02 5836.0 ... 2025-08-04 17:50:51.631474 2025-08-04 17:50:51.631880
2941 2025-08-03 5836.0 ... 2025-08-04 17:50:51.631474 2025-08-04 17:50:51.631880
2942 2025-08-04 5816.0 ... 2025-08-04 17:50:51.631474 2025-08-04 17:50:51.631880
[4 rows x 5 columns]
2025-08-04 17:50:51,657 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-08-04 17:50:51,663 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2938 2025-07-31 5876.0
2939 2025-08-01 5836.0
2940 2025-08-02 5836.0
2941 2025-08-03 5836.0
2942 2025-08-04 5816.0
2025-08-04 17:50:51,726 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2943 2025-08-01 5836.0 ... 2025-08-04 17:50:51.718380 2025-08-04 17:50:51.718963
2944 2025-08-02 5836.0 ... 2025-08-04 17:50:51.718380 2025-08-04 17:50:51.718963
2945 2025-08-03 5836.0 ... 2025-08-04 17:50:51.718380 2025-08-04 17:50:51.718963
2946 2025-08-04 5816.0 ... 2025-08-04 17:50:51.718380 2025-08-04 17:50:51.718963
[4 rows x 5 columns]
2025-08-04 17:50:51,744 - 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-08-04 17:50:52,364 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2213 2025-07-31 23600.0
2214 2025-08-01 23600.0
2215 2025-08-02 23600.0
2216 2025-08-03 23600.0
2217 2025-08-04 23600.0
2025-08-04 17:50:52,418 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2214 2025-08-01 23600.0 ... 2025-08-04 17:50:52.411235 2025-08-04 17:50:52.411642
2215 2025-08-02 23600.0 ... 2025-08-04 17:50:52.411235 2025-08-04 17:50:52.411642
2216 2025-08-03 23600.0 ... 2025-08-04 17:50:52.411235 2025-08-04 17:50:52.411642
2217 2025-08-04 23600.0 ... 2025-08-04 17:50:52.411235 2025-08-04 17:50:52.411642
[4 rows x 5 columns]
2025-08-04 17:50:52,437 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-08-04 17:50:52,442 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2213 2025-07-31 23600.0
2214 2025-08-01 23600.0
2215 2025-08-02 23600.0
2216 2025-08-03 23600.0
2217 2025-08-04 23600.0
2025-08-04 17:50:52,496 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2218 2025-08-01 23600.0 ... 2025-08-04 17:50:52.488567 2025-08-04 17:50:52.488971
2219 2025-08-02 23600.0 ... 2025-08-04 17:50:52.488567 2025-08-04 17:50:52.488971
2220 2025-08-03 23600.0 ... 2025-08-04 17:50:52.488567 2025-08-04 17:50:52.488971
2221 2025-08-04 23600.0 ... 2025-08-04 17:50:52.488567 2025-08-04 17:50:52.488971
[4 rows x 5 columns]
2025-08-04 17:50:52,514 - 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-08-04 17:50:53,087 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1728 2025-07-31 1812.5
1729 2025-08-01 1812.5
1730 2025-08-02 1812.5
1731 2025-08-03 1812.5
1732 2025-08-04 1812.5
2025-08-04 17:50:53,134 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1729 2025-08-01 1812.5 ... 2025-08-04 17:50:53.127096 2025-08-04 17:50:53.127504
1730 2025-08-02 1812.5 ... 2025-08-04 17:50:53.127096 2025-08-04 17:50:53.127504
1731 2025-08-03 1812.5 ... 2025-08-04 17:50:53.127096 2025-08-04 17:50:53.127504
1732 2025-08-04 1812.5 ... 2025-08-04 17:50:53.127096 2025-08-04 17:50:53.127504
[4 rows x 5 columns]
2025-08-04 17:50:53,152 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-08-04 17:50:53,158 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1728 2025-07-31 1812.5
1729 2025-08-01 1812.5
1730 2025-08-02 1812.5
1731 2025-08-03 1812.5
1732 2025-08-04 1812.5
2025-08-04 17:50:53,203 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1733 2025-08-01 1812.5 ... 2025-08-04 17:50:53.196574 2025-08-04 17:50:53.196970
1734 2025-08-02 1812.5 ... 2025-08-04 17:50:53.196574 2025-08-04 17:50:53.196970
1735 2025-08-03 1812.5 ... 2025-08-04 17:50:53.196574 2025-08-04 17:50:53.196970
1736 2025-08-04 1812.5 ... 2025-08-04 17:50:53.196574 2025-08-04 17:50:53.196970
[4 rows x 5 columns]
2025-08-04 17:50:53,223 - 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-08-04 17:50:53,858 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2800 2025-07-31 121466.67
2801 2025-08-01 121150.00
2802 2025-08-02 121150.00
2803 2025-08-03 121150.00
2804 2025-08-04 121600.00
2025-08-04 17:50:53,922 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2801 2025-08-01 ... 2025-08-04 17:50:53.915999
2802 2025-08-02 ... 2025-08-04 17:50:53.915999
2803 2025-08-03 ... 2025-08-04 17:50:53.915999
2804 2025-08-04 ... 2025-08-04 17:50:53.915999
[4 rows x 5 columns]
2025-08-04 17:50:53,941 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-08-04 17:50:53,947 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2800 2025-07-31 121466.67
2801 2025-08-01 121150.00
2802 2025-08-02 121150.00
2803 2025-08-03 121150.00
2804 2025-08-04 121600.00
2025-08-04 17:50:54,007 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2804 2025-08-01 ... 2025-08-04 17:50:54.000464
2805 2025-08-02 ... 2025-08-04 17:50:54.000464
2806 2025-08-03 ... 2025-08-04 17:50:54.000464
2807 2025-08-04 ... 2025-08-04 17:50:54.000464
[4 rows x 5 columns]
2025-08-04 17:50:54,025 - 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-08-04 17:50:54,666 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3825 2025-07-31 4869.0
3826 2025-08-01 4812.0
3827 2025-08-02 4812.0
3828 2025-08-03 4812.0
3829 2025-08-04 4751.0
2025-08-04 17:50:54,747 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3826 2025-08-01 4812.0 ... 2025-08-04 17:50:54.740021 2025-08-04 17:50:54.740406
3827 2025-08-02 4812.0 ... 2025-08-04 17:50:54.740021 2025-08-04 17:50:54.740406
3828 2025-08-03 4812.0 ... 2025-08-04 17:50:54.740021 2025-08-04 17:50:54.740406
3829 2025-08-04 4751.0 ... 2025-08-04 17:50:54.740021 2025-08-04 17:50:54.740406
[4 rows x 5 columns]
2025-08-04 17:50:54,766 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-08-04 17:50:54,772 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3825 2025-07-31 4869.0
3826 2025-08-01 4812.0
3827 2025-08-02 4812.0
3828 2025-08-03 4812.0
3829 2025-08-04 4751.0
2025-08-04 17:50:54,844 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3829 2025-08-01 4812.0 ... 2025-08-04 17:50:54.837460 2025-08-04 17:50:54.837878
3830 2025-08-02 4812.0 ... 2025-08-04 17:50:54.837460 2025-08-04 17:50:54.837878
3831 2025-08-03 4812.0 ... 2025-08-04 17:50:54.837460 2025-08-04 17:50:54.837878
3832 2025-08-04 4751.0 ... 2025-08-04 17:50:54.837460 2025-08-04 17:50:54.837878
[4 rows x 5 columns]
2025-08-04 17:50:54,862 - 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-08-04 17:50:55,532 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
3064 2025-07-31 7278.33
3065 2025-08-01 7290.00
3066 2025-08-02 7290.00
3067 2025-08-03 7290.00
3068 2025-08-04 7295.00
2025-08-04 17:50:55,595 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
3065 2025-08-01 7290.0 ... 2025-08-04 17:50:55.587712 2025-08-04 17:50:55.588126
3066 2025-08-02 7290.0 ... 2025-08-04 17:50:55.587712 2025-08-04 17:50:55.588126
3067 2025-08-03 7290.0 ... 2025-08-04 17:50:55.587712 2025-08-04 17:50:55.588126
3068 2025-08-04 7295.0 ... 2025-08-04 17:50:55.587712 2025-08-04 17:50:55.588126
[4 rows x 5 columns]
2025-08-04 17:50:55,613 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-08-04 17:50:55,619 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
3064 2025-07-31 7278.33
3065 2025-08-01 7290.00
3066 2025-08-02 7290.00
3067 2025-08-03 7290.00
3068 2025-08-04 7295.00
2025-08-04 17:50:55,684 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
3068 2025-08-01 7290.0 ... 2025-08-04 17:50:55.676374 2025-08-04 17:50:55.676841
3069 2025-08-02 7290.0 ... 2025-08-04 17:50:55.676374 2025-08-04 17:50:55.676841
3070 2025-08-03 7290.0 ... 2025-08-04 17:50:55.676374 2025-08-04 17:50:55.676841
3071 2025-08-04 7295.0 ... 2025-08-04 17:50:55.676374 2025-08-04 17:50:55.676841
[4 rows x 5 columns]
2025-08-04 17:50:55,704 - 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-08-04 17:50:56,374 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3826 2025-07-31 15557.50
3827 2025-08-01 15269.50
3828 2025-08-02 15269.50
3829 2025-08-03 15269.50
3830 2025-08-04 15172.17
2025-08-04 17:50:56,447 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date ... updated_at
3827 2025-08-01 ... 2025-08-04 17:50:56.440353
3828 2025-08-02 ... 2025-08-04 17:50:56.440353
3829 2025-08-03 ... 2025-08-04 17:50:56.440353
3830 2025-08-04 ... 2025-08-04 17:50:56.440353
[4 rows x 5 columns]
2025-08-04 17:50:56,465 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-08-04 17:50:56,471 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3826 2025-07-31 15557.50
3827 2025-08-01 15269.50
3828 2025-08-02 15269.50
3829 2025-08-03 15269.50
3830 2025-08-04 15172.17
2025-08-04 17:50:56,545 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date ... updated_at
3831 2025-08-01 ... 2025-08-04 17:50:56.538724
3832 2025-08-02 ... 2025-08-04 17:50:56.538724
3833 2025-08-03 ... 2025-08-04 17:50:56.538724
3834 2025-08-04 ... 2025-08-04 17:50:56.538724
[4 rows x 5 columns]
2025-08-04 17:50:56,564 - 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-08-04 17:50:57,264 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3771 2025-07-31 16743.75
3772 2025-08-01 16600.00
3773 2025-08-02 16600.00
3774 2025-08-03 16600.00
3775 2025-08-04 16737.50
2025-08-04 17:50:57,341 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date value ... created_at updated_at
3772 2025-08-01 16600.0 ... 2025-08-04 17:50:57.333634 2025-08-04 17:50:57.334056
3773 2025-08-02 16600.0 ... 2025-08-04 17:50:57.333634 2025-08-04 17:50:57.334056
3774 2025-08-03 16600.0 ... 2025-08-04 17:50:57.333634 2025-08-04 17:50:57.334056
3775 2025-08-04 16737.5 ... 2025-08-04 17:50:57.333634 2025-08-04 17:50:57.334056
[4 rows x 5 columns]
2025-08-04 17:50:57,359 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-08-04 17:50:57,365 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3771 2025-07-31 16743.75
3772 2025-08-01 16600.00
3773 2025-08-02 16600.00
3774 2025-08-03 16600.00
3775 2025-08-04 16737.50
2025-08-04 17:50:57,438 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date value ... created_at updated_at
3775 2025-08-01 16600.0 ... 2025-08-04 17:50:57.431032 2025-08-04 17:50:57.431418
3776 2025-08-02 16600.0 ... 2025-08-04 17:50:57.431032 2025-08-04 17:50:57.431418
3777 2025-08-03 16600.0 ... 2025-08-04 17:50:57.431032 2025-08-04 17:50:57.431418
3778 2025-08-04 16737.5 ... 2025-08-04 17:50:57.431032 2025-08-04 17:50:57.431418
[4 rows x 5 columns]
2025-08-04 17:50:57,456 - 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-08-04 17:50:58,087 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
3046 2025-07-31 3510.00
3047 2025-08-01 3510.00
3048 2025-08-02 3473.33
3049 2025-08-03 3473.33
3050 2025-08-04 3433.33
2025-08-04 17:50:58,154 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
3047 2025-08-01 3510.00 ... 2025-08-04 17:50:58.146921 2025-08-04 17:50:58.147312
3048 2025-08-02 3473.33 ... 2025-08-04 17:50:58.146921 2025-08-04 17:50:58.147312
3049 2025-08-03 3473.33 ... 2025-08-04 17:50:58.146921 2025-08-04 17:50:58.147312
3050 2025-08-04 3433.33 ... 2025-08-04 17:50:58.146921 2025-08-04 17:50:58.147312
[4 rows x 5 columns]
2025-08-04 17:50:58,173 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-08-04 17:50:58,179 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
3046 2025-07-31 3510.00
3047 2025-08-01 3510.00
3048 2025-08-02 3473.33
3049 2025-08-03 3473.33
3050 2025-08-04 3433.33
2025-08-04 17:50:58,246 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
3050 2025-08-01 3510.00 ... 2025-08-04 17:50:58.238061 2025-08-04 17:50:58.238461
3051 2025-08-02 3473.33 ... 2025-08-04 17:50:58.238061 2025-08-04 17:50:58.238461
3052 2025-08-03 3473.33 ... 2025-08-04 17:50:58.238061 2025-08-04 17:50:58.238461
3053 2025-08-04 3433.33 ... 2025-08-04 17:50:58.238061 2025-08-04 17:50:58.238461
[4 rows x 5 columns]
2025-08-04 17:50:58,265 - 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-08-04 17:50:58,947 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3326 2025-07-31 5312.5
3327 2025-08-01 5312.5
3328 2025-08-02 5362.5
3329 2025-08-03 5362.5
3330 2025-08-04 5387.5
2025-08-04 17:50:59,093 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3327 2025-08-01 5312.5 ... 2025-08-04 17:50:59.085435 2025-08-04 17:50:59.085867
3328 2025-08-02 5362.5 ... 2025-08-04 17:50:59.085435 2025-08-04 17:50:59.085867
3329 2025-08-03 5362.5 ... 2025-08-04 17:50:59.085435 2025-08-04 17:50:59.085867
3330 2025-08-04 5387.5 ... 2025-08-04 17:50:59.085435 2025-08-04 17:50:59.085867
[4 rows x 5 columns]
2025-08-04 17:50:59,111 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-08-04 17:50:59,117 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3326 2025-07-31 5312.5
3327 2025-08-01 5312.5
3328 2025-08-02 5362.5
3329 2025-08-03 5362.5
3330 2025-08-04 5387.5
2025-08-04 17:50:59,189 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3814 2025-08-01 5312.5 ... 2025-08-04 17:50:59.181530 2025-08-04 17:50:59.181937
3815 2025-08-02 5362.5 ... 2025-08-04 17:50:59.181530 2025-08-04 17:50:59.181937
3816 2025-08-03 5362.5 ... 2025-08-04 17:50:59.181530 2025-08-04 17:50:59.181937
3817 2025-08-04 5387.5 ... 2025-08-04 17:50:59.181530 2025-08-04 17:50:59.181937
[4 rows x 5 columns]
2025-08-04 17:50:59,207 - 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-08-04 17:50:59,793 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1390 2025-07-31 14180.0
1391 2025-08-01 14200.0
1392 2025-08-02 14200.0
1393 2025-08-03 14200.0
1394 2025-08-04 14180.0
2025-08-04 17:50:59,836 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1391 2025-08-01 14200.0 ... 2025-08-04 17:50:59.828872 2025-08-04 17:50:59.829259
1392 2025-08-02 14200.0 ... 2025-08-04 17:50:59.828872 2025-08-04 17:50:59.829259
1393 2025-08-03 14200.0 ... 2025-08-04 17:50:59.828872 2025-08-04 17:50:59.829259
1394 2025-08-04 14180.0 ... 2025-08-04 17:50:59.828872 2025-08-04 17:50:59.829259
[4 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-08-04 17:51:00,074 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-08-04 17:51:00.066489
117 2021-07-06 ... 2025-08-04 17:51:00.066489
121 2021-07-12 ... 2025-08-04 17:51:00.066489
122 2021-07-13 ... 2025-08-04 17:51:00.066489
194 2021-11-01 ... 2025-08-04 17:51:00.066489
[5 rows x 6 columns]
2025-08-04 17:51:00,112 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1390 2025-07-31 14180.0
1391 2025-08-01 14200.0
1392 2025-08-02 14200.0
1393 2025-08-03 14200.0
1394 2025-08-04 14180.0
2025-08-04 17:51:00,155 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1394 2025-08-01 14200.0 ... 2025-08-04 17:51:00.147995 2025-08-04 17:51:00.148373
1395 2025-08-02 14200.0 ... 2025-08-04 17:51:00.147995 2025-08-04 17:51:00.148373
1396 2025-08-03 14200.0 ... 2025-08-04 17:51:00.147995 2025-08-04 17:51:00.148373
1397 2025-08-04 14180.0 ... 2025-08-04 17:51:00.147995 2025-08-04 17:51:00.148373
[4 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-08-04 17:51:00,383 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-08-04 17:51:00.376221
117 2021-07-06 ... 2025-08-04 17:51:00.376221
121 2021-07-12 ... 2025-08-04 17:51:00.376221
122 2021-07-13 ... 2025-08-04 17:51:00.376221
194 2021-11-01 ... 2025-08-04 17:51:00.376221
[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-08-04 17:51:01,077 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3822 2025-07-31 78590.00
3823 2025-08-01 78371.67
3824 2025-08-02 78371.67
3825 2025-08-03 78371.67
3826 2025-08-04 78418.33
2025-08-04 17:51:01,148 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date ... updated_at
3823 2025-08-01 ... 2025-08-04 17:51:01.141675
3824 2025-08-02 ... 2025-08-04 17:51:01.141675
3825 2025-08-03 ... 2025-08-04 17:51:01.141675
3826 2025-08-04 ... 2025-08-04 17:51:01.141675
[4 rows x 5 columns]
2025-08-04 17:51:01,168 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-08-04 17:51:01,174 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3822 2025-07-31 78590.00
3823 2025-08-01 78371.67
3824 2025-08-02 78371.67
3825 2025-08-03 78371.67
3826 2025-08-04 78418.33
2025-08-04 17:51:01,246 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date ... updated_at
3826 2025-08-01 ... 2025-08-04 17:51:01.240275
3827 2025-08-02 ... 2025-08-04 17:51:01.240275
3828 2025-08-03 ... 2025-08-04 17:51:01.240275
3829 2025-08-04 ... 2025-08-04 17:51:01.240275
[4 rows x 5 columns]
2025-08-04 17:51:01,265 - 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-08-04 17:51:01,782 - 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-08-04 17:51:01,840 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-08-04 17:51:01,840 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-08-04 17:51:01,847 - 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-08-04 17:51:01,909 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-08-04 17:51:01,909 - 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-08-04 17:51:04,092 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2800 2025-07-31 265575.0
2801 2025-08-01 264625.0
2802 2025-08-02 264625.0
2803 2025-08-03 264625.0
2804 2025-08-04 265812.5
2025-08-04 17:51:04,154 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2801 2025-08-01 ... 2025-08-04 17:51:04.147052
2802 2025-08-02 ... 2025-08-04 17:51:04.147052
2803 2025-08-03 ... 2025-08-04 17:51:04.147052
2804 2025-08-04 ... 2025-08-04 17:51:04.147052
[4 rows x 5 columns]
2025-08-04 17:51:04,173 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-08-04 17:51:04,179 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2800 2025-07-31 265575.0
2801 2025-08-01 264625.0
2802 2025-08-02 264625.0
2803 2025-08-03 264625.0
2804 2025-08-04 265812.5
2025-08-04 17:51:04,244 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2804 2025-08-01 ... 2025-08-04 17:51:04.237055
2805 2025-08-02 ... 2025-08-04 17:51:04.237055
2806 2025-08-03 ... 2025-08-04 17:51:04.237055
2807 2025-08-04 ... 2025-08-04 17:51:04.237055
[4 rows x 5 columns]
2025-08-04 17:51:04,262 - 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-08-04 17:51:04,900 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3821 2025-07-31 22296.0
3822 2025-08-01 22300.0
3823 2025-08-02 22300.0
3824 2025-08-03 22300.0
3825 2025-08-04 22148.0
2025-08-04 17:51:04,971 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3822 2025-08-01 22300.0 ... 2025-08-04 17:51:04.963733 2025-08-04 17:51:04.964176
3823 2025-08-02 22300.0 ... 2025-08-04 17:51:04.963733 2025-08-04 17:51:04.964176
3824 2025-08-03 22300.0 ... 2025-08-04 17:51:04.963733 2025-08-04 17:51:04.964176
3825 2025-08-04 22148.0 ... 2025-08-04 17:51:04.963733 2025-08-04 17:51:04.964176
[4 rows x 5 columns]
2025-08-04 17:51:04,990 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-08-04 17:51:04,996 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3821 2025-07-31 22296.0
3822 2025-08-01 22300.0
3823 2025-08-02 22300.0
3824 2025-08-03 22300.0
3825 2025-08-04 22148.0
2025-08-04 17:51:05,068 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3825 2025-08-01 22300.0 ... 2025-08-04 17:51:05.061340 2025-08-04 17:51:05.061724
3826 2025-08-02 22300.0 ... 2025-08-04 17:51:05.061340 2025-08-04 17:51:05.061724
3827 2025-08-03 22300.0 ... 2025-08-04 17:51:05.061340 2025-08-04 17:51:05.061724
3828 2025-08-04 22148.0 ... 2025-08-04 17:51:05.061340 2025-08-04 17:51:05.061724
[4 rows x 5 columns]
2025-08-04 17:51:05,087 - 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-08-04 17:51:05,810 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3784 2025-07-31 3537.5
3785 2025-08-01 3537.5
3786 2025-08-02 3537.5
3787 2025-08-03 3537.5
3788 2025-08-04 3537.5
2025-08-04 17:51:05,881 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3785 2025-08-01 3537.5 ... 2025-08-04 17:51:05.873723 2025-08-04 17:51:05.874133
3786 2025-08-02 3537.5 ... 2025-08-04 17:51:05.873723 2025-08-04 17:51:05.874133
3787 2025-08-03 3537.5 ... 2025-08-04 17:51:05.873723 2025-08-04 17:51:05.874133
3788 2025-08-04 3537.5 ... 2025-08-04 17:51:05.873723 2025-08-04 17:51:05.874133
[4 rows x 5 columns]
2025-08-04 17:51:05,900 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-08-04 17:51:05,906 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3784 2025-07-31 3537.5
3785 2025-08-01 3537.5
3786 2025-08-02 3537.5
3787 2025-08-03 3537.5
3788 2025-08-04 3537.5
2025-08-04 17:51:05,976 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3788 2025-08-01 3537.5 ... 2025-08-04 17:51:05.969496 2025-08-04 17:51:05.969897
3789 2025-08-02 3537.5 ... 2025-08-04 17:51:05.969496 2025-08-04 17:51:05.969897
3790 2025-08-03 3537.5 ... 2025-08-04 17:51:05.969496 2025-08-04 17:51:05.969897
3791 2025-08-04 3537.5 ... 2025-08-04 17:51:05.969496 2025-08-04 17:51:05.969897
[4 rows x 5 columns]
2025-08-04 17:51:05,996 - 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-08-04 17:51:07,212 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1581 2025-07-31 4762.5
1582 2025-08-01 4747.5
1583 2025-08-02 4747.5
1584 2025-08-03 4747.5
1585 2025-08-04 4657.5
2025-08-04 17:51:07,257 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1582 2025-08-01 4747.5 ... 2025-08-04 17:51:07.250095 2025-08-04 17:51:07.250478
1583 2025-08-02 4747.5 ... 2025-08-04 17:51:07.250095 2025-08-04 17:51:07.250478
1584 2025-08-03 4747.5 ... 2025-08-04 17:51:07.250095 2025-08-04 17:51:07.250478
1585 2025-08-04 4657.5 ... 2025-08-04 17:51:07.250095 2025-08-04 17:51:07.250478
[4 rows x 5 columns]
2025-08-04 17:51:07,276 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-08-04 17:51:07,282 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1581 2025-07-31 4762.5
1582 2025-08-01 4747.5
1583 2025-08-02 4747.5
1584 2025-08-03 4747.5
1585 2025-08-04 4657.5
2025-08-04 17:51:07,328 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1585 2025-08-01 4747.5 ... 2025-08-04 17:51:07.321136 2025-08-04 17:51:07.321545
1586 2025-08-02 4747.5 ... 2025-08-04 17:51:07.321136 2025-08-04 17:51:07.321545
1587 2025-08-03 4747.5 ... 2025-08-04 17:51:07.321136 2025-08-04 17:51:07.321545
1588 2025-08-04 4657.5 ... 2025-08-04 17:51:07.321136 2025-08-04 17:51:07.321545
[4 rows x 5 columns]
2025-08-04 17:51:07,347 - 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-08-04 17:51:07,932 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2855 2025-07-31 2332.86
2856 2025-08-01 2332.86
2857 2025-08-02 2332.86
2858 2025-08-03 2332.86
2859 2025-08-04 2328.57
2025-08-04 17:51:07,993 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2856 2025-08-01 2332.86 ... 2025-08-04 17:51:07.986133 2025-08-04 17:51:07.986517
2857 2025-08-02 2332.86 ... 2025-08-04 17:51:07.986133 2025-08-04 17:51:07.986517
2858 2025-08-03 2332.86 ... 2025-08-04 17:51:07.986133 2025-08-04 17:51:07.986517
2859 2025-08-04 2328.57 ... 2025-08-04 17:51:07.986133 2025-08-04 17:51:07.986517
[4 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-08-04 17:51:08,035 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2855 2025-07-31 ... 2025-08-04 17:51:08.028402
[1 rows x 6 columns]
2025-08-04 17:51:08,059 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2855 2025-07-31 2332.86
2856 2025-08-01 2332.86
2857 2025-08-02 2332.86
2858 2025-08-03 2332.86
2859 2025-08-04 2328.57
2025-08-04 17:51:08,120 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2859 2025-08-01 2332.86 ... 2025-08-04 17:51:08.112987 2025-08-04 17:51:08.113390
2860 2025-08-02 2332.86 ... 2025-08-04 17:51:08.112987 2025-08-04 17:51:08.113390
2861 2025-08-03 2332.86 ... 2025-08-04 17:51:08.112987 2025-08-04 17:51:08.113390
2862 2025-08-04 2328.57 ... 2025-08-04 17:51:08.112987 2025-08-04 17:51:08.113390
[4 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-08-04 17:51:08,160 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2858 2025-07-31 ... 2025-08-04 17:51:08.153490
[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-08-04 17:51:09,216 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2855 2025-07-31 2332.86
2856 2025-08-01 2332.86
2857 2025-08-02 2332.86
2858 2025-08-03 2332.86
2859 2025-08-04 2940.00
2025-08-04 17:51:09,267 - 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-08-04 17:51:09,289 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2859 2025-08-04 ... 2025-08-04 17:51:09.281881
[1 rows x 6 columns]
2025-08-04 17:51:09,312 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2855 2025-07-31 2332.86
2856 2025-08-01 2332.86
2857 2025-08-02 2332.86
2858 2025-08-03 2332.86
2859 2025-08-04 2940.00
2025-08-04 17:51:09,363 - 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-08-04 17:51:09,385 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2862 2025-08-04 ... 2025-08-04 17:51:09.377891
[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-08-04 17:51:09,971 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3212 2025-07-31 9621.67
3213 2025-08-01 9623.33
3214 2025-08-02 9623.33
3215 2025-08-03 9623.33
3216 2025-08-04 9623.33
2025-08-04 17:51:10,026 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-08-04 17:51:10,026 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-08-04 17:51:10,032 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3212 2025-07-31 9621.67
3213 2025-08-01 9623.33
3214 2025-08-02 9623.33
3215 2025-08-03 9623.33
3216 2025-08-04 9623.33
2025-08-04 17:51:10,088 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-08-04 17:51:10,089 - 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-08-04 17:51:10,764 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1896 2025-07-31 4436.67
1897 2025-08-01 4436.67
1898 2025-08-02 4435.00
1899 2025-08-03 4435.00
1900 2025-08-04 4435.00
2025-08-04 17:51:10,815 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1897 2025-08-01 4436.67 ... 2025-08-04 17:51:10.806993 2025-08-04 17:51:10.807436
1898 2025-08-02 4435.00 ... 2025-08-04 17:51:10.806993 2025-08-04 17:51:10.807436
1899 2025-08-03 4435.00 ... 2025-08-04 17:51:10.806993 2025-08-04 17:51:10.807436
1900 2025-08-04 4435.00 ... 2025-08-04 17:51:10.806993 2025-08-04 17:51:10.807436
[4 rows x 5 columns]
2025-08-04 17:51:10,834 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-08-04 17:51:10,840 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1896 2025-07-31 4436.67
1897 2025-08-01 4436.67
1898 2025-08-02 4435.00
1899 2025-08-03 4435.00
1900 2025-08-04 4435.00
2025-08-04 17:51:10,894 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1900 2025-08-01 4436.67 ... 2025-08-04 17:51:10.886461 2025-08-04 17:51:10.887065
1901 2025-08-02 4435.00 ... 2025-08-04 17:51:10.886461 2025-08-04 17:51:10.887065
1902 2025-08-03 4435.00 ... 2025-08-04 17:51:10.886461 2025-08-04 17:51:10.887065
1903 2025-08-04 4435.00 ... 2025-08-04 17:51:10.886461 2025-08-04 17:51:10.887065
[4 rows x 5 columns]
2025-08-04 17:51:10,913 - 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-08-04 17:51:11,499 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1905 2025-07-31 5900.0
1906 2025-08-01 5900.0
1907 2025-08-02 5900.0
1908 2025-08-03 5900.0
1909 2025-08-04 5900.0
2025-08-04 17:51:11,549 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1906 2025-08-01 5900.0 ... 2025-08-04 17:51:11.542096 2025-08-04 17:51:11.542494
1907 2025-08-02 5900.0 ... 2025-08-04 17:51:11.542096 2025-08-04 17:51:11.542494
1908 2025-08-03 5900.0 ... 2025-08-04 17:51:11.542096 2025-08-04 17:51:11.542494
1909 2025-08-04 5900.0 ... 2025-08-04 17:51:11.542096 2025-08-04 17:51:11.542494
[4 rows x 5 columns]
2025-08-04 17:51:11,568 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-08-04 17:51:11,574 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1905 2025-07-31 5900.0
1906 2025-08-01 5900.0
1907 2025-08-02 5900.0
1908 2025-08-03 5900.0
1909 2025-08-04 5900.0
2025-08-04 17:51:11,623 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1909 2025-08-01 5900.0 ... 2025-08-04 17:51:11.615902 2025-08-04 17:51:11.616284
1910 2025-08-02 5900.0 ... 2025-08-04 17:51:11.615902 2025-08-04 17:51:11.616284
1911 2025-08-03 5900.0 ... 2025-08-04 17:51:11.615902 2025-08-04 17:51:11.616284
1912 2025-08-04 5900.0 ... 2025-08-04 17:51:11.615902 2025-08-04 17:51:11.616284
[4 rows x 5 columns]
2025-08-04 17:51:11,643 - 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-08-04 17:51:14,239 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3573 2025-07-31 9012.0
3574 2025-08-01 8992.0
3575 2025-08-02 8992.0
3576 2025-08-03 8992.0
3577 2025-08-04 8888.0
2025-08-04 17:51:14,311 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3574 2025-08-01 8992.0 ... 2025-08-04 17:51:14.303357 2025-08-04 17:51:14.303744
3575 2025-08-02 8992.0 ... 2025-08-04 17:51:14.303357 2025-08-04 17:51:14.303744
3576 2025-08-03 8992.0 ... 2025-08-04 17:51:14.303357 2025-08-04 17:51:14.303744
3577 2025-08-04 8888.0 ... 2025-08-04 17:51:14.303357 2025-08-04 17:51:14.303744
[4 rows x 5 columns]
2025-08-04 17:51:14,330 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-08-04 17:51:14,337 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3573 2025-07-31 9012.0
3574 2025-08-01 8992.0
3575 2025-08-02 8992.0
3576 2025-08-03 8992.0
3577 2025-08-04 8888.0
2025-08-04 17:51:14,407 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3577 2025-08-01 8992.0 ... 2025-08-04 17:51:14.399677 2025-08-04 17:51:14.400126
3578 2025-08-02 8992.0 ... 2025-08-04 17:51:14.399677 2025-08-04 17:51:14.400126
3579 2025-08-03 8992.0 ... 2025-08-04 17:51:14.399677 2025-08-04 17:51:14.400126
3580 2025-08-04 8888.0 ... 2025-08-04 17:51:14.399677 2025-08-04 17:51:14.400126
[4 rows x 5 columns]
2025-08-04 17:51:14,426 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data