=========================================================================
2025-06-09 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-06-09 17:50:28,414 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3325 2025-06-05 3063.00
3326 2025-06-06 3080.33
3327 2025-06-07 3080.33
3328 2025-06-08 3080.33
3329 2025-06-09 3069.00
2025-06-09 17:50:28,495 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3327 2025-06-07 3080.33 ... 2025-06-09 17:50:28.487216 2025-06-09 17:50:28.487638
3328 2025-06-08 3080.33 ... 2025-06-09 17:50:28.487216 2025-06-09 17:50:28.487638
3329 2025-06-09 3069.00 ... 2025-06-09 17:50:28.487216 2025-06-09 17:50:28.487638
[3 rows x 5 columns]
2025-06-09 17:50:28,517 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-06-09 17:50:28,524 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3325 2025-06-05 3063.00
3326 2025-06-06 3080.33
3327 2025-06-07 3080.33
3328 2025-06-08 3080.33
3329 2025-06-09 3069.00
2025-06-09 17:50:28,600 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3330 2025-06-07 3080.33 ... 2025-06-09 17:50:28.593038 2025-06-09 17:50:28.593426
3331 2025-06-08 3080.33 ... 2025-06-09 17:50:28.593038 2025-06-09 17:50:28.593426
3332 2025-06-09 3069.00 ... 2025-06-09 17:50:28.593038 2025-06-09 17:50:28.593426
[3 rows x 5 columns]
2025-06-09 17:50:28,620 - 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-06-09 17:50:29,169 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3546 2025-06-05 2302.0
3547 2025-06-06 2313.0
3548 2025-06-07 2313.0
3549 2025-06-08 2313.0
3550 2025-06-09 2331.0
2025-06-09 17:50:29,246 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3548 2025-06-07 2313.0 ... 2025-06-09 17:50:29.238844 2025-06-09 17:50:29.239251
3549 2025-06-08 2313.0 ... 2025-06-09 17:50:29.238844 2025-06-09 17:50:29.239251
3550 2025-06-09 2331.0 ... 2025-06-09 17:50:29.238844 2025-06-09 17:50:29.239251
[3 rows x 5 columns]
2025-06-09 17:50:29,266 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-06-09 17:50:29,272 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3546 2025-06-05 2302.0
3547 2025-06-06 2313.0
3548 2025-06-07 2313.0
3549 2025-06-08 2313.0
3550 2025-06-09 2331.0
2025-06-09 17:50:29,347 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3552 2025-06-07 2313.0 ... 2025-06-09 17:50:29.339774 2025-06-09 17:50:29.340198
3553 2025-06-08 2313.0 ... 2025-06-09 17:50:29.339774 2025-06-09 17:50:29.340198
3554 2025-06-09 2331.0 ... 2025-06-09 17:50:29.339774 2025-06-09 17:50:29.340198
[3 rows x 5 columns]
2025-06-09 17:50:29,367 - 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-06-09 17:50:29,938 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
886 2025-06-05 4880.66
887 2025-06-06 4903.25
888 2025-06-07 4903.25
889 2025-06-08 4903.25
890 2025-06-09 4884.50
2025-06-09 17:50:29,977 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
888 2025-06-07 4903.25 ... 2025-06-09 17:50:29.970014 2025-06-09 17:50:29.970401
889 2025-06-08 4903.25 ... 2025-06-09 17:50:29.970014 2025-06-09 17:50:29.970401
890 2025-06-09 4884.50 ... 2025-06-09 17:50:29.970014 2025-06-09 17:50:29.970401
[3 rows x 5 columns]
2025-06-09 17:50:29,997 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-06-09 17:50:30,003 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
886 2025-06-05 4880.66
887 2025-06-06 4903.25
888 2025-06-07 4903.25
889 2025-06-08 4903.25
890 2025-06-09 4884.50
2025-06-09 17:50:30,044 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
888 2025-06-07 4903.25 ... 2025-06-09 17:50:30.037179 2025-06-09 17:50:30.037560
889 2025-06-08 4903.25 ... 2025-06-09 17:50:30.037179 2025-06-09 17:50:30.037560
890 2025-06-09 4884.50 ... 2025-06-09 17:50:30.037179 2025-06-09 17:50:30.037560
[3 rows x 5 columns]
2025-06-09 17:50:30,063 - 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-06-09 17:50:30,629 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3765 2025-06-05 13458.33
3766 2025-06-06 13508.33
3767 2025-06-07 13508.33
3768 2025-06-08 13508.33
3769 2025-06-09 13573.33
2025-06-09 17:50:30,713 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3767 2025-06-07 ... 2025-06-09 17:50:30.706653
3768 2025-06-08 ... 2025-06-09 17:50:30.706653
3769 2025-06-09 ... 2025-06-09 17:50:30.706653
[3 rows x 5 columns]
2025-06-09 17:50:30,733 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-06-09 17:50:30,739 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3765 2025-06-05 13458.33
3766 2025-06-06 13508.33
3767 2025-06-07 13508.33
3768 2025-06-08 13508.33
3769 2025-06-09 13573.33
2025-06-09 17:50:30,819 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3770 2025-06-07 ... 2025-06-09 17:50:30.812842
3771 2025-06-08 ... 2025-06-09 17:50:30.812842
3772 2025-06-09 ... 2025-06-09 17:50:30.812842
[3 rows x 5 columns]
2025-06-09 17:50:30,839 - 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-06-09 17:50:31,388 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3097 2025-06-05 750.00
3098 2025-06-06 751.44
3099 2025-06-07 751.44
3100 2025-06-08 748.11
3101 2025-06-09 746.11
2025-06-09 17:50:31,460 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3099 2025-06-07 751.44 ... 2025-06-09 17:50:31.452411 2025-06-09 17:50:31.452871
3100 2025-06-08 748.11 ... 2025-06-09 17:50:31.452411 2025-06-09 17:50:31.452871
3101 2025-06-09 746.11 ... 2025-06-09 17:50:31.452411 2025-06-09 17:50:31.452871
[3 rows x 5 columns]
2025-06-09 17:50:31,480 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-06-09 17:50:31,487 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3097 2025-06-05 750.00
3098 2025-06-06 751.44
3099 2025-06-07 751.44
3100 2025-06-08 748.11
3101 2025-06-09 746.11
2025-06-09 17:50:31,559 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3102 2025-06-07 751.44 ... 2025-06-09 17:50:31.551605 2025-06-09 17:50:31.552048
3103 2025-06-08 748.11 ... 2025-06-09 17:50:31.551605 2025-06-09 17:50:31.552048
3104 2025-06-09 746.11 ... 2025-06-09 17:50:31.551605 2025-06-09 17:50:31.552048
[3 rows x 5 columns]
2025-06-09 17:50:31,579 - 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-06-09 17:50:32,117 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3300 2025-06-05 1120.0
3301 2025-06-06 1120.0
3302 2025-06-07 1120.0
3303 2025-06-08 1120.0
3304 2025-06-09 1120.0
2025-06-09 17:50:32,190 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3302 2025-06-07 1120.0 ... 2025-06-09 17:50:32.182922 2025-06-09 17:50:32.183332
3303 2025-06-08 1120.0 ... 2025-06-09 17:50:32.182922 2025-06-09 17:50:32.183332
3304 2025-06-09 1120.0 ... 2025-06-09 17:50:32.182922 2025-06-09 17:50:32.183332
[3 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-06-09 17:50:34,302 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-06-09 17:50:34.294419
21 2013-01-04 ... 2025-06-09 17:50:34.294419
54 2013-02-27 ... 2025-06-09 17:50:34.294419
60 2013-03-07 ... 2025-06-09 17:50:34.294419
61 2013-03-08 ... 2025-06-09 17:50:34.294419
[5 rows x 6 columns]
2025-06-09 17:50:34,477 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3300 2025-06-05 1120.0
3301 2025-06-06 1120.0
3302 2025-06-07 1120.0
3303 2025-06-08 1120.0
3304 2025-06-09 1120.0
2025-06-09 17:50:34,553 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3306 2025-06-07 1120.0 ... 2025-06-09 17:50:34.542772 2025-06-09 17:50:34.543286
3307 2025-06-08 1120.0 ... 2025-06-09 17:50:34.542772 2025-06-09 17:50:34.543286
3308 2025-06-09 1120.0 ... 2025-06-09 17:50:34.542772 2025-06-09 17:50:34.543286
[3 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-06-09 17:50:36,562 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-06-09 17:50:36.554412
21 2013-01-04 ... 2025-06-09 17:50:36.554412
54 2013-02-27 ... 2025-06-09 17:50:36.554412
60 2013-03-07 ... 2025-06-09 17:50:36.554412
61 2013-03-08 ... 2025-06-09 17:50:36.554412
[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-06-09 17:50:37,332 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1645 2025-06-05 7970.0
1646 2025-06-06 7970.0
1647 2025-06-07 7970.0
1648 2025-06-08 7970.0
1649 2025-06-09 7870.0
2025-06-09 17:50:37,380 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1647 2025-06-07 7970.0 ... 2025-06-09 17:50:37.372854 2025-06-09 17:50:37.373251
1648 2025-06-08 7970.0 ... 2025-06-09 17:50:37.372854 2025-06-09 17:50:37.373251
1649 2025-06-09 7870.0 ... 2025-06-09 17:50:37.372854 2025-06-09 17:50:37.373251
[3 rows x 5 columns]
2025-06-09 17:50:37,399 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-06-09 17:50:37,405 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1645 2025-06-05 7970.0
1646 2025-06-06 7970.0
1647 2025-06-07 7970.0
1648 2025-06-08 7970.0
1649 2025-06-09 7870.0
2025-06-09 17:50:37,453 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1650 2025-06-07 7970.0 ... 2025-06-09 17:50:37.446143 2025-06-09 17:50:37.446532
1651 2025-06-08 7970.0 ... 2025-06-09 17:50:37.446143 2025-06-09 17:50:37.446532
1652 2025-06-09 7870.0 ... 2025-06-09 17:50:37.446143 2025-06-09 17:50:37.446532
[3 rows x 5 columns]
2025-06-09 17:50:37,472 - 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-06-09 17:50:38,348 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3756 2025-06-05 6095.0
3757 2025-06-06 6095.0
3758 2025-06-07 6095.0
3759 2025-06-08 6095.0
3760 2025-06-09 6095.0
2025-06-09 17:50:38,422 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3758 2025-06-07 6095.0 ... 2025-06-09 17:50:38.414976 2025-06-09 17:50:38.415368
3759 2025-06-08 6095.0 ... 2025-06-09 17:50:38.414976 2025-06-09 17:50:38.415368
3760 2025-06-09 6095.0 ... 2025-06-09 17:50:38.414976 2025-06-09 17:50:38.415368
[3 rows x 5 columns]
2025-06-09 17:50:38,442 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-06-09 17:50:38,448 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3756 2025-06-05 6095.0
3757 2025-06-06 6095.0
3758 2025-06-07 6095.0
3759 2025-06-08 6095.0
3760 2025-06-09 6095.0
2025-06-09 17:50:38,521 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3762 2025-06-07 6095.0 ... 2025-06-09 17:50:38.514231 2025-06-09 17:50:38.514619
3763 2025-06-08 6095.0 ... 2025-06-09 17:50:38.514231 2025-06-09 17:50:38.514619
3764 2025-06-09 6095.0 ... 2025-06-09 17:50:38.514231 2025-06-09 17:50:38.514619
[3 rows x 5 columns]
2025-06-09 17:50:38,541 - 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-06-09 17:50:39,057 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1646 2025-06-05 13175.0
1647 2025-06-06 13175.0
1648 2025-06-07 13175.0
1649 2025-06-08 13175.0
1650 2025-06-09 13100.0
2025-06-09 17:50:39,104 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1648 2025-06-07 13175.0 ... 2025-06-09 17:50:39.096849 2025-06-09 17:50:39.097255
1649 2025-06-08 13175.0 ... 2025-06-09 17:50:39.096849 2025-06-09 17:50:39.097255
1650 2025-06-09 13100.0 ... 2025-06-09 17:50:39.096849 2025-06-09 17:50:39.097255
[3 rows x 5 columns]
2025-06-09 17:50:39,123 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-06-09 17:50:39,129 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1646 2025-06-05 13175.0
1647 2025-06-06 13175.0
1648 2025-06-07 13175.0
1649 2025-06-08 13175.0
1650 2025-06-09 13100.0
2025-06-09 17:50:39,176 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1651 2025-06-07 13175.0 ... 2025-06-09 17:50:39.168518 2025-06-09 17:50:39.168950
1652 2025-06-08 13175.0 ... 2025-06-09 17:50:39.168518 2025-06-09 17:50:39.168950
1653 2025-06-09 13100.0 ... 2025-06-09 17:50:39.168518 2025-06-09 17:50:39.168950
[3 rows x 5 columns]
2025-06-09 17:50:39,195 - 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-06-09 17:50:39,790 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3156 2025-06-05 9296.67
3157 2025-06-06 9296.67
3158 2025-06-07 9296.67
3159 2025-06-08 9296.67
3160 2025-06-09 9331.67
2025-06-09 17:50:39,861 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date value ... created_at updated_at
3158 2025-06-07 9296.67 ... 2025-06-09 17:50:39.853664 2025-06-09 17:50:39.854085
3159 2025-06-08 9296.67 ... 2025-06-09 17:50:39.853664 2025-06-09 17:50:39.854085
3160 2025-06-09 9331.67 ... 2025-06-09 17:50:39.853664 2025-06-09 17:50:39.854085
[3 rows x 5 columns]
2025-06-09 17:50:39,881 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-06-09 17:50:39,887 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3156 2025-06-05 9296.67
3157 2025-06-06 9296.67
3158 2025-06-07 9296.67
3159 2025-06-08 9296.67
3160 2025-06-09 9331.67
2025-06-09 17:50:39,955 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date value ... created_at updated_at
3162 2025-06-07 9296.67 ... 2025-06-09 17:50:39.948028 2025-06-09 17:50:39.948431
3163 2025-06-08 9296.67 ... 2025-06-09 17:50:39.948028 2025-06-09 17:50:39.948431
3164 2025-06-09 9331.67 ... 2025-06-09 17:50:39.948028 2025-06-09 17:50:39.948431
[3 rows x 5 columns]
2025-06-09 17:50:39,974 - 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-06-09 17:50:40,530 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3279 2025-06-05 2498.33
3280 2025-06-06 2535.00
3281 2025-06-07 2535.00
3282 2025-06-08 2535.00
3283 2025-06-09 2543.33
2025-06-09 17:50:40,600 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3281 2025-06-07 2535.00 ... 2025-06-09 17:50:40.592795 2025-06-09 17:50:40.593247
3282 2025-06-08 2535.00 ... 2025-06-09 17:50:40.592795 2025-06-09 17:50:40.593247
3283 2025-06-09 2543.33 ... 2025-06-09 17:50:40.592795 2025-06-09 17:50:40.593247
[3 rows x 5 columns]
2025-06-09 17:50:40,625 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-06-09 17:50:40,636 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3279 2025-06-05 2498.33
3280 2025-06-06 2535.00
3281 2025-06-07 2535.00
3282 2025-06-08 2535.00
3283 2025-06-09 2543.33
2025-06-09 17:50:40,706 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3285 2025-06-07 2535.00 ... 2025-06-09 17:50:40.699317 2025-06-09 17:50:40.699706
3286 2025-06-08 2535.00 ... 2025-06-09 17:50:40.699317 2025-06-09 17:50:40.699706
3287 2025-06-09 2543.33 ... 2025-06-09 17:50:40.699317 2025-06-09 17:50:40.699706
[3 rows x 5 columns]
2025-06-09 17:50:40,727 - 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-06-09 17:50:41,207 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1483 2025-06-05 1375.0
1484 2025-06-06 1375.0
1485 2025-06-07 1375.0
1486 2025-06-08 1375.0
1487 2025-06-09 1370.0
2025-06-09 17:50:41,251 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1485 2025-06-07 1375.0 ... 2025-06-09 17:50:41.244254 2025-06-09 17:50:41.244642
1486 2025-06-08 1375.0 ... 2025-06-09 17:50:41.244254 2025-06-09 17:50:41.244642
1487 2025-06-09 1370.0 ... 2025-06-09 17:50:41.244254 2025-06-09 17:50:41.244642
[3 rows x 5 columns]
2025-06-09 17:50:41,271 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-06-09 17:50:41,276 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1483 2025-06-05 1375.0
1484 2025-06-06 1375.0
1485 2025-06-07 1375.0
1486 2025-06-08 1375.0
1487 2025-06-09 1370.0
2025-06-09 17:50:41,321 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1489 2025-06-07 1375.0 ... 2025-06-09 17:50:41.313582 2025-06-09 17:50:41.313995
1490 2025-06-08 1375.0 ... 2025-06-09 17:50:41.313582 2025-06-09 17:50:41.313995
1491 2025-06-09 1370.0 ... 2025-06-09 17:50:41.313582 2025-06-09 17:50:41.313995
[3 rows x 5 columns]
2025-06-09 17:50:41,340 - 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-06-09 17:50:41,923 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1396 2025-06-05 6495.83
1397 2025-06-06 6507.50
1398 2025-06-07 6507.50
1399 2025-06-08 6507.50
1400 2025-06-09 6518.12
2025-06-09 17:50:41,967 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1398 2025-06-07 6507.50 ... 2025-06-09 17:50:41.959667 2025-06-09 17:50:41.960091
1399 2025-06-08 6507.50 ... 2025-06-09 17:50:41.959667 2025-06-09 17:50:41.960091
1400 2025-06-09 6518.12 ... 2025-06-09 17:50:41.959667 2025-06-09 17:50:41.960091
[3 rows x 5 columns]
2025-06-09 17:50:41,986 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-06-09 17:50:41,992 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1396 2025-06-05 6495.83
1397 2025-06-06 6507.50
1398 2025-06-07 6507.50
1399 2025-06-08 6507.50
1400 2025-06-09 6518.12
2025-06-09 17:50:42,037 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1402 2025-06-07 6507.50 ... 2025-06-09 17:50:42.030113 2025-06-09 17:50:42.030525
1403 2025-06-08 6507.50 ... 2025-06-09 17:50:42.030113 2025-06-09 17:50:42.030525
1404 2025-06-09 6518.12 ... 2025-06-09 17:50:42.030113 2025-06-09 17:50:42.030525
[3 rows x 5 columns]
2025-06-09 17:50:42,057 - 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-06-09 17:50:42,626 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3769 2025-06-05 2900.0
3770 2025-06-06 2940.0
3771 2025-06-07 2940.0
3772 2025-06-08 2940.0
3773 2025-06-09 2944.0
2025-06-09 17:50:42,705 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3771 2025-06-07 2940.0 ... 2025-06-09 17:50:42.697913 2025-06-09 17:50:42.698351
3772 2025-06-08 2940.0 ... 2025-06-09 17:50:42.697913 2025-06-09 17:50:42.698351
3773 2025-06-09 2944.0 ... 2025-06-09 17:50:42.697913 2025-06-09 17:50:42.698351
[3 rows x 5 columns]
2025-06-09 17:50:42,726 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-06-09 17:50:42,732 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3769 2025-06-05 2900.0
3770 2025-06-06 2940.0
3771 2025-06-07 2940.0
3772 2025-06-08 2940.0
3773 2025-06-09 2944.0
2025-06-09 17:50:42,811 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3774 2025-06-07 2940.0 ... 2025-06-09 17:50:42.803100 2025-06-09 17:50:42.803503
3775 2025-06-08 2940.0 ... 2025-06-09 17:50:42.803100 2025-06-09 17:50:42.803503
3776 2025-06-09 2944.0 ... 2025-06-09 17:50:42.803100 2025-06-09 17:50:42.803503
[3 rows x 5 columns]
2025-06-09 17:50:42,830 - 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-06-09 17:50:43,671 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3539 2025-06-05 7934.0
3540 2025-06-06 7994.0
3541 2025-06-07 7994.0
3542 2025-06-08 7994.0
3543 2025-06-09 8024.0
2025-06-09 17:50:43,745 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3541 2025-06-07 7994.0 ... 2025-06-09 17:50:43.738142 2025-06-09 17:50:43.738563
3542 2025-06-08 7994.0 ... 2025-06-09 17:50:43.738142 2025-06-09 17:50:43.738563
3543 2025-06-09 8024.0 ... 2025-06-09 17:50:43.738142 2025-06-09 17:50:43.738563
[3 rows x 5 columns]
2025-06-09 17:50:43,765 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-06-09 17:50:43,774 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3539 2025-06-05 7934.0
3540 2025-06-06 7994.0
3541 2025-06-07 7994.0
3542 2025-06-08 7994.0
3543 2025-06-09 8024.0
2025-06-09 17:50:43,847 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3544 2025-06-07 7994.0 ... 2025-06-09 17:50:43.840046 2025-06-09 17:50:43.840436
3545 2025-06-08 7994.0 ... 2025-06-09 17:50:43.840046 2025-06-09 17:50:43.840436
3546 2025-06-09 8024.0 ... 2025-06-09 17:50:43.840046 2025-06-09 17:50:43.840436
[3 rows x 5 columns]
2025-06-09 17:50:43,868 - 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-06-09 17:50:44,416 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3505 2025-06-05 4255.0
3506 2025-06-06 4270.0
3507 2025-06-07 4270.0
3508 2025-06-08 4270.0
3509 2025-06-09 4295.0
2025-06-09 17:50:44,487 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3507 2025-06-07 4270.0 ... 2025-06-09 17:50:44.479423 2025-06-09 17:50:44.479829
3508 2025-06-08 4270.0 ... 2025-06-09 17:50:44.479423 2025-06-09 17:50:44.479829
3509 2025-06-09 4295.0 ... 2025-06-09 17:50:44.479423 2025-06-09 17:50:44.479829
[3 rows x 5 columns]
2025-06-09 17:50:44,506 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-06-09 17:50:44,513 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3505 2025-06-05 4255.0
3506 2025-06-06 4270.0
3507 2025-06-07 4270.0
3508 2025-06-08 4270.0
3509 2025-06-09 4295.0
2025-06-09 17:50:44,585 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3510 2025-06-07 4270.0 ... 2025-06-09 17:50:44.577431 2025-06-09 17:50:44.578105
3511 2025-06-08 4270.0 ... 2025-06-09 17:50:44.577431 2025-06-09 17:50:44.578105
3512 2025-06-09 4295.0 ... 2025-06-09 17:50:44.577431 2025-06-09 17:50:44.578105
[3 rows x 5 columns]
2025-06-09 17:50:44,605 - 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-06-09 17:50:45,278 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2882 2025-06-05 5152.86
2883 2025-06-06 5090.00
2884 2025-06-07 5090.00
2885 2025-06-08 5090.00
2886 2025-06-09 5088.57
2025-06-09 17:50:45,339 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2884 2025-06-07 5090.00 ... 2025-06-09 17:50:45.332330 2025-06-09 17:50:45.332718
2885 2025-06-08 5090.00 ... 2025-06-09 17:50:45.332330 2025-06-09 17:50:45.332718
2886 2025-06-09 5088.57 ... 2025-06-09 17:50:45.332330 2025-06-09 17:50:45.332718
[3 rows x 5 columns]
2025-06-09 17:50:45,360 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-06-09 17:50:45,366 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2882 2025-06-05 5152.86
2883 2025-06-06 5090.00
2884 2025-06-07 5090.00
2885 2025-06-08 5090.00
2886 2025-06-09 5088.57
2025-06-09 17:50:45,428 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2888 2025-06-07 5090.00 ... 2025-06-09 17:50:45.420625 2025-06-09 17:50:45.421034
2889 2025-06-08 5090.00 ... 2025-06-09 17:50:45.420625 2025-06-09 17:50:45.421034
2890 2025-06-09 5088.57 ... 2025-06-09 17:50:45.420625 2025-06-09 17:50:45.421034
[3 rows x 5 columns]
2025-06-09 17:50:45,447 - 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-06-09 17:50:46,016 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3082 2025-06-05 2975.0
3083 2025-06-06 2940.0
3084 2025-06-07 2940.0
3085 2025-06-08 2940.0
3086 2025-06-09 2915.0
2025-06-09 17:50:46,083 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3084 2025-06-07 2940.0 ... 2025-06-09 17:50:46.074174 2025-06-09 17:50:46.074784
3085 2025-06-08 2940.0 ... 2025-06-09 17:50:46.074174 2025-06-09 17:50:46.074784
3086 2025-06-09 2915.0 ... 2025-06-09 17:50:46.074174 2025-06-09 17:50:46.074784
[3 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-06-09 17:50:46,237 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-06-09 17:50:46.229657
458 2015-09-21 ... 2025-06-09 17:50:46.229657
549 2016-02-03 ... 2025-06-09 17:50:46.229657
693 2016-09-05 ... 2025-06-09 17:50:46.229657
696 2016-09-08 ... 2025-06-09 17:50:46.229657
[5 rows x 6 columns]
2025-06-09 17:50:46,268 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3082 2025-06-05 2975.0
3083 2025-06-06 2940.0
3084 2025-06-07 2940.0
3085 2025-06-08 2940.0
3086 2025-06-09 2915.0
2025-06-09 17:50:46,335 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3087 2025-06-07 2940.0 ... 2025-06-09 17:50:46.327542 2025-06-09 17:50:46.327954
3088 2025-06-08 2940.0 ... 2025-06-09 17:50:46.327542 2025-06-09 17:50:46.327954
3089 2025-06-09 2915.0 ... 2025-06-09 17:50:46.327542 2025-06-09 17:50:46.327954
[3 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-06-09 17:50:46,490 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-06-09 17:50:46.482345
458 2015-09-21 ... 2025-06-09 17:50:46.482345
549 2016-02-03 ... 2025-06-09 17:50:46.482345
693 2016-09-05 ... 2025-06-09 17:50:46.482345
696 2016-09-08 ... 2025-06-09 17:50:46.482345
[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-06-09 17:50:47,069 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
886 2025-06-05 8640.0
887 2025-06-06 8640.0
888 2025-06-07 8620.0
889 2025-06-08 8620.0
890 2025-06-09 8620.0
2025-06-09 17:50:47,105 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
888 2025-06-07 8620.0 ... 2025-06-09 17:50:47.097969 2025-06-09 17:50:47.098367
889 2025-06-08 8620.0 ... 2025-06-09 17:50:47.097969 2025-06-09 17:50:47.098367
890 2025-06-09 8620.0 ... 2025-06-09 17:50:47.097969 2025-06-09 17:50:47.098367
[3 rows x 5 columns]
2025-06-09 17:50:47,124 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-06-09 17:50:47,129 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
886 2025-06-05 8640.0
887 2025-06-06 8640.0
888 2025-06-07 8620.0
889 2025-06-08 8620.0
890 2025-06-09 8620.0
2025-06-09 17:50:47,166 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
888 2025-06-07 8620.0 ... 2025-06-09 17:50:47.158682 2025-06-09 17:50:47.159100
889 2025-06-08 8620.0 ... 2025-06-09 17:50:47.158682 2025-06-09 17:50:47.159100
890 2025-06-09 8620.0 ... 2025-06-09 17:50:47.158682 2025-06-09 17:50:47.159100
[3 rows x 5 columns]
2025-06-09 17:50:47,185 - 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-06-09 17:50:47,722 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3765 2025-06-05 7346.67
3766 2025-06-06 7346.67
3767 2025-06-07 7346.67
3768 2025-06-08 7346.67
3769 2025-06-09 7346.67
2025-06-09 17:50:47,797 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3767 2025-06-07 7346.67 ... 2025-06-09 17:50:47.790094 2025-06-09 17:50:47.790484
3768 2025-06-08 7346.67 ... 2025-06-09 17:50:47.790094 2025-06-09 17:50:47.790484
3769 2025-06-09 7346.67 ... 2025-06-09 17:50:47.790094 2025-06-09 17:50:47.790484
[3 rows x 5 columns]
2025-06-09 17:50:47,817 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-06-09 17:50:47,823 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3765 2025-06-05 7346.67
3766 2025-06-06 7346.67
3767 2025-06-07 7346.67
3768 2025-06-08 7346.67
3769 2025-06-09 7346.67
2025-06-09 17:50:47,896 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3770 2025-06-07 7346.67 ... 2025-06-09 17:50:47.888918 2025-06-09 17:50:47.889306
3771 2025-06-08 7346.67 ... 2025-06-09 17:50:47.888918 2025-06-09 17:50:47.889306
3772 2025-06-09 7346.67 ... 2025-06-09 17:50:47.888918 2025-06-09 17:50:47.889306
[3 rows x 5 columns]
2025-06-09 17:50:47,915 - 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-06-09 17:50:48,652 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3103 2025-06-05 3610.0
3104 2025-06-06 3610.0
3105 2025-06-07 3610.0
3106 2025-06-08 3610.0
3107 2025-06-09 3630.0
2025-06-09 17:50:48,719 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3106 2025-06-07 3610.0 ... 2025-06-09 17:50:48.711939 2025-06-09 17:50:48.712339
3107 2025-06-08 3610.0 ... 2025-06-09 17:50:48.711939 2025-06-09 17:50:48.712339
3108 2025-06-09 3630.0 ... 2025-06-09 17:50:48.711939 2025-06-09 17:50:48.712339
[3 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-06-09 17:50:48,757 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-06-09 17:50:48.749372
[1 rows x 6 columns]
2025-06-09 17:50:48,783 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3103 2025-06-05 3610.0
3104 2025-06-06 3610.0
3105 2025-06-07 3610.0
3106 2025-06-08 3610.0
3107 2025-06-09 3630.0
2025-06-09 17:50:48,851 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3108 2025-06-07 3610.0 ... 2025-06-09 17:50:48.843569 2025-06-09 17:50:48.843989
3109 2025-06-08 3610.0 ... 2025-06-09 17:50:48.843569 2025-06-09 17:50:48.843989
3110 2025-06-09 3630.0 ... 2025-06-09 17:50:48.843569 2025-06-09 17:50:48.843989
[3 rows x 5 columns]
2025-06-09 17:50:48,871 - 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-06-09 17:50:49,510 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3768 2025-06-05 20293.33
3769 2025-06-06 20246.67
3770 2025-06-07 20246.67
3771 2025-06-08 20246.67
3772 2025-06-09 20246.67
2025-06-09 17:50:49,583 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date ... updated_at
3770 2025-06-07 ... 2025-06-09 17:50:49.577355
3771 2025-06-08 ... 2025-06-09 17:50:49.577355
3772 2025-06-09 ... 2025-06-09 17:50:49.577355
[3 rows x 5 columns]
2025-06-09 17:50:49,602 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-06-09 17:50:49,609 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3768 2025-06-05 20293.33
3769 2025-06-06 20246.67
3770 2025-06-07 20246.67
3771 2025-06-08 20246.67
3772 2025-06-09 20246.67
2025-06-09 17:50:49,682 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date ... updated_at
3773 2025-06-07 ... 2025-06-09 17:50:49.675479
3774 2025-06-08 ... 2025-06-09 17:50:49.675479
3775 2025-06-09 ... 2025-06-09 17:50:49.675479
[3 rows x 5 columns]
2025-06-09 17:50:49,701 - 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-06-09 17:50:50,292 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2882 2025-06-05 5500.0
2883 2025-06-06 5536.0
2884 2025-06-07 5536.0
2885 2025-06-08 5536.0
2886 2025-06-09 5530.0
2025-06-09 17:50:50,354 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2884 2025-06-07 5536.0 ... 2025-06-09 17:50:50.347016 2025-06-09 17:50:50.347407
2885 2025-06-08 5536.0 ... 2025-06-09 17:50:50.347016 2025-06-09 17:50:50.347407
2886 2025-06-09 5530.0 ... 2025-06-09 17:50:50.347016 2025-06-09 17:50:50.347407
[3 rows x 5 columns]
2025-06-09 17:50:50,374 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-06-09 17:50:50,380 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2882 2025-06-05 5500.0
2883 2025-06-06 5536.0
2884 2025-06-07 5536.0
2885 2025-06-08 5536.0
2886 2025-06-09 5530.0
2025-06-09 17:50:50,442 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2888 2025-06-07 5536.0 ... 2025-06-09 17:50:50.434856 2025-06-09 17:50:50.435251
2889 2025-06-08 5536.0 ... 2025-06-09 17:50:50.434856 2025-06-09 17:50:50.435251
2890 2025-06-09 5530.0 ... 2025-06-09 17:50:50.434856 2025-06-09 17:50:50.435251
[3 rows x 5 columns]
2025-06-09 17:50:50,461 - 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-06-09 17:50:51,050 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2157 2025-06-05 23725.0
2158 2025-06-06 23725.0
2159 2025-06-07 23725.0
2160 2025-06-08 23725.0
2161 2025-06-09 23725.0
2025-06-09 17:50:51,104 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2159 2025-06-07 23725.0 ... 2025-06-09 17:50:51.096549 2025-06-09 17:50:51.096955
2160 2025-06-08 23725.0 ... 2025-06-09 17:50:51.096549 2025-06-09 17:50:51.096955
2161 2025-06-09 23725.0 ... 2025-06-09 17:50:51.096549 2025-06-09 17:50:51.096955
[3 rows x 5 columns]
2025-06-09 17:50:51,123 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-06-09 17:50:51,129 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2157 2025-06-05 23725.0
2158 2025-06-06 23725.0
2159 2025-06-07 23725.0
2160 2025-06-08 23725.0
2161 2025-06-09 23725.0
2025-06-09 17:50:51,182 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2163 2025-06-07 23725.0 ... 2025-06-09 17:50:51.175096 2025-06-09 17:50:51.175479
2164 2025-06-08 23725.0 ... 2025-06-09 17:50:51.175096 2025-06-09 17:50:51.175479
2165 2025-06-09 23725.0 ... 2025-06-09 17:50:51.175096 2025-06-09 17:50:51.175479
[3 rows x 5 columns]
2025-06-09 17:50:51,202 - 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-06-09 17:50:51,725 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1672 2025-06-05 1868.33
1673 2025-06-06 1850.00
1674 2025-06-07 1850.00
1675 2025-06-08 1850.00
1676 2025-06-09 1821.67
2025-06-09 17:50:51,772 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1674 2025-06-07 1850.00 ... 2025-06-09 17:50:51.765167 2025-06-09 17:50:51.765557
1675 2025-06-08 1850.00 ... 2025-06-09 17:50:51.765167 2025-06-09 17:50:51.765557
1676 2025-06-09 1821.67 ... 2025-06-09 17:50:51.765167 2025-06-09 17:50:51.765557
[3 rows x 5 columns]
2025-06-09 17:50:51,792 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-06-09 17:50:51,797 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1672 2025-06-05 1868.33
1673 2025-06-06 1850.00
1674 2025-06-07 1850.00
1675 2025-06-08 1850.00
1676 2025-06-09 1821.67
2025-06-09 17:50:51,918 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1678 2025-06-07 1850.00 ... 2025-06-09 17:50:51.911595 2025-06-09 17:50:51.911999
1679 2025-06-08 1850.00 ... 2025-06-09 17:50:51.911595 2025-06-09 17:50:51.911999
1680 2025-06-09 1821.67 ... 2025-06-09 17:50:51.911595 2025-06-09 17:50:51.911999
[3 rows x 5 columns]
2025-06-09 17:50:51,939 - 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-06-09 17:50:52,619 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2744 2025-06-05 123133.33
2745 2025-06-06 123450.00
2746 2025-06-07 123450.00
2747 2025-06-08 123450.00
2748 2025-06-09 124133.33
2025-06-09 17:50:52,680 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2746 2025-06-07 ... 2025-06-09 17:50:52.674134
2747 2025-06-08 ... 2025-06-09 17:50:52.674134
2748 2025-06-09 ... 2025-06-09 17:50:52.674134
[3 rows x 5 columns]
2025-06-09 17:50:52,700 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-06-09 17:50:52,706 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2744 2025-06-05 123133.33
2745 2025-06-06 123450.00
2746 2025-06-07 123450.00
2747 2025-06-08 123450.00
2748 2025-06-09 124133.33
2025-06-09 17:50:52,768 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2749 2025-06-07 ... 2025-06-09 17:50:52.761090
2750 2025-06-08 ... 2025-06-09 17:50:52.761090
2751 2025-06-09 ... 2025-06-09 17:50:52.761090
[3 rows x 5 columns]
2025-06-09 17:50:52,787 - 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-06-09 17:50:53,400 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3769 2025-06-05 4565.0
3770 2025-06-06 4604.0
3771 2025-06-07 4604.0
3772 2025-06-08 4604.0
3773 2025-06-09 4602.0
2025-06-09 17:50:53,478 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3771 2025-06-07 4604.0 ... 2025-06-09 17:50:53.471025 2025-06-09 17:50:53.471417
3772 2025-06-08 4604.0 ... 2025-06-09 17:50:53.471025 2025-06-09 17:50:53.471417
3773 2025-06-09 4602.0 ... 2025-06-09 17:50:53.471025 2025-06-09 17:50:53.471417
[3 rows x 5 columns]
2025-06-09 17:50:53,497 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-06-09 17:50:53,504 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3769 2025-06-05 4565.0
3770 2025-06-06 4604.0
3771 2025-06-07 4604.0
3772 2025-06-08 4604.0
3773 2025-06-09 4602.0
2025-06-09 17:50:53,583 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3774 2025-06-07 4604.0 ... 2025-06-09 17:50:53.575293 2025-06-09 17:50:53.575732
3775 2025-06-08 4604.0 ... 2025-06-09 17:50:53.575293 2025-06-09 17:50:53.575732
3776 2025-06-09 4602.0 ... 2025-06-09 17:50:53.575293 2025-06-09 17:50:53.575732
[3 rows x 5 columns]
2025-06-09 17:50:53,602 - 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-06-09 17:50:54,278 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
3008 2025-06-05 7388.33
3009 2025-06-06 7380.00
3010 2025-06-07 7380.00
3011 2025-06-08 7380.00
3012 2025-06-09 7380.00
2025-06-09 17:50:54,342 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
3010 2025-06-07 7380.0 ... 2025-06-09 17:50:54.335470 2025-06-09 17:50:54.335879
3011 2025-06-08 7380.0 ... 2025-06-09 17:50:54.335470 2025-06-09 17:50:54.335879
3012 2025-06-09 7380.0 ... 2025-06-09 17:50:54.335470 2025-06-09 17:50:54.335879
[3 rows x 5 columns]
2025-06-09 17:50:54,361 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-06-09 17:50:54,367 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
3008 2025-06-05 7388.33
3009 2025-06-06 7380.00
3010 2025-06-07 7380.00
3011 2025-06-08 7380.00
3012 2025-06-09 7380.00
2025-06-09 17:50:54,433 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
3013 2025-06-07 7380.0 ... 2025-06-09 17:50:54.425296 2025-06-09 17:50:54.425709
3014 2025-06-08 7380.0 ... 2025-06-09 17:50:54.425296 2025-06-09 17:50:54.425709
3015 2025-06-09 7380.0 ... 2025-06-09 17:50:54.425296 2025-06-09 17:50:54.425709
[3 rows x 5 columns]
2025-06-09 17:50:54,452 - 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-06-09 17:50:55,047 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3770 2025-06-05 14555.50
3771 2025-06-06 14569.33
3772 2025-06-07 14569.33
3773 2025-06-08 14569.33
3774 2025-06-09 14623.00
2025-06-09 17:50:55,122 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date ... updated_at
3772 2025-06-07 ... 2025-06-09 17:50:55.115514
3773 2025-06-08 ... 2025-06-09 17:50:55.115514
3774 2025-06-09 ... 2025-06-09 17:50:55.115514
[3 rows x 5 columns]
2025-06-09 17:50:55,142 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-06-09 17:50:55,149 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3770 2025-06-05 14555.50
3771 2025-06-06 14569.33
3772 2025-06-07 14569.33
3773 2025-06-08 14569.33
3774 2025-06-09 14623.00
2025-06-09 17:50:55,223 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date ... updated_at
3776 2025-06-07 ... 2025-06-09 17:50:55.216417
3777 2025-06-08 ... 2025-06-09 17:50:55.216417
3778 2025-06-09 ... 2025-06-09 17:50:55.216417
[3 rows x 5 columns]
2025-06-09 17:50:55,242 - 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-06-09 17:50:55,784 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3715 2025-06-05 16593.75
3716 2025-06-06 16568.75
3717 2025-06-07 16568.75
3718 2025-06-08 16568.75
3719 2025-06-09 16593.75
2025-06-09 17:50:55,858 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date ... updated_at
3717 2025-06-07 ... 2025-06-09 17:50:55.851433
3718 2025-06-08 ... 2025-06-09 17:50:55.851433
3719 2025-06-09 ... 2025-06-09 17:50:55.851433
[3 rows x 5 columns]
2025-06-09 17:50:55,878 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-06-09 17:50:55,884 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3715 2025-06-05 16593.75
3716 2025-06-06 16568.75
3717 2025-06-07 16568.75
3718 2025-06-08 16568.75
3719 2025-06-09 16593.75
2025-06-09 17:50:55,957 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date ... updated_at
3720 2025-06-07 ... 2025-06-09 17:50:55.951033
3721 2025-06-08 ... 2025-06-09 17:50:55.951033
3722 2025-06-09 ... 2025-06-09 17:50:55.951033
[3 rows x 5 columns]
2025-06-09 17:50:55,977 - 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-06-09 17:50:56,546 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
2990 2025-06-05 3176.67
2991 2025-06-06 3170.00
2992 2025-06-07 3170.00
2993 2025-06-08 3170.00
2994 2025-06-09 3170.00
2025-06-09 17:50:56,613 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
2992 2025-06-07 3170.0 ... 2025-06-09 17:50:56.605696 2025-06-09 17:50:56.606138
2993 2025-06-08 3170.0 ... 2025-06-09 17:50:56.605696 2025-06-09 17:50:56.606138
2994 2025-06-09 3170.0 ... 2025-06-09 17:50:56.605696 2025-06-09 17:50:56.606138
[3 rows x 5 columns]
2025-06-09 17:50:56,633 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-06-09 17:50:56,639 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
2990 2025-06-05 3176.67
2991 2025-06-06 3170.00
2992 2025-06-07 3170.00
2993 2025-06-08 3170.00
2994 2025-06-09 3170.00
2025-06-09 17:50:56,708 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
2995 2025-06-07 3170.0 ... 2025-06-09 17:50:56.698317 2025-06-09 17:50:56.698901
2996 2025-06-08 3170.0 ... 2025-06-09 17:50:56.698317 2025-06-09 17:50:56.698901
2997 2025-06-09 3170.0 ... 2025-06-09 17:50:56.698317 2025-06-09 17:50:56.698901
[3 rows x 5 columns]
2025-06-09 17:50:56,728 - 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-06-09 17:50:57,298 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3270 2025-06-05 5312.5
3271 2025-06-06 5312.5
3272 2025-06-07 5312.5
3273 2025-06-08 5312.5
3274 2025-06-09 5275.0
2025-06-09 17:50:57,365 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3272 2025-06-07 5312.5 ... 2025-06-09 17:50:57.357873 2025-06-09 17:50:57.358335
3273 2025-06-08 5312.5 ... 2025-06-09 17:50:57.357873 2025-06-09 17:50:57.358335
3274 2025-06-09 5275.0 ... 2025-06-09 17:50:57.357873 2025-06-09 17:50:57.358335
[3 rows x 5 columns]
2025-06-09 17:50:57,384 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-06-09 17:50:57,391 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3270 2025-06-05 5312.5
3271 2025-06-06 5312.5
3272 2025-06-07 5312.5
3273 2025-06-08 5312.5
3274 2025-06-09 5275.0
2025-06-09 17:50:57,466 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3759 2025-06-07 5312.5 ... 2025-06-09 17:50:57.459023 2025-06-09 17:50:57.459420
3760 2025-06-08 5312.5 ... 2025-06-09 17:50:57.459023 2025-06-09 17:50:57.459420
3761 2025-06-09 5275.0 ... 2025-06-09 17:50:57.459023 2025-06-09 17:50:57.459420
[3 rows x 5 columns]
2025-06-09 17:50:57,485 - 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-06-09 17:50:58,049 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1334 2025-06-05 14420.0
1335 2025-06-06 14300.0
1336 2025-06-07 14300.0
1337 2025-06-08 14300.0
1338 2025-06-09 14270.0
2025-06-09 17:50:58,094 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1336 2025-06-07 14300.0 ... 2025-06-09 17:50:58.086403 2025-06-09 17:50:58.086873
1337 2025-06-08 14300.0 ... 2025-06-09 17:50:58.086403 2025-06-09 17:50:58.086873
1338 2025-06-09 14270.0 ... 2025-06-09 17:50:58.086403 2025-06-09 17:50:58.086873
[3 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-06-09 17:50:58,344 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-06-09 17:50:58.335800
117 2021-07-06 ... 2025-06-09 17:50:58.335800
121 2021-07-12 ... 2025-06-09 17:50:58.335800
122 2021-07-13 ... 2025-06-09 17:50:58.335800
194 2021-11-01 ... 2025-06-09 17:50:58.335800
[5 rows x 6 columns]
2025-06-09 17:50:58,381 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1334 2025-06-05 14420.0
1335 2025-06-06 14300.0
1336 2025-06-07 14300.0
1337 2025-06-08 14300.0
1338 2025-06-09 14270.0
2025-06-09 17:50:58,425 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1339 2025-06-07 14300.0 ... 2025-06-09 17:50:58.418193 2025-06-09 17:50:58.418583
1340 2025-06-08 14300.0 ... 2025-06-09 17:50:58.418193 2025-06-09 17:50:58.418583
1341 2025-06-09 14270.0 ... 2025-06-09 17:50:58.418193 2025-06-09 17:50:58.418583
[3 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-06-09 17:50:58,677 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-06-09 17:50:58.669068
117 2021-07-06 ... 2025-06-09 17:50:58.669068
121 2021-07-12 ... 2025-06-09 17:50:58.669068
122 2021-07-13 ... 2025-06-09 17:50:58.669068
194 2021-11-01 ... 2025-06-09 17:50:58.669068
[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-06-09 17:50:59,483 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3766 2025-06-05 78410.00
3767 2025-06-06 78913.33
3768 2025-06-07 78913.33
3769 2025-06-08 78913.33
3770 2025-06-09 78891.67
2025-06-09 17:50:59,554 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date ... updated_at
3768 2025-06-07 ... 2025-06-09 17:50:59.548447
3769 2025-06-08 ... 2025-06-09 17:50:59.548447
3770 2025-06-09 ... 2025-06-09 17:50:59.548447
[3 rows x 5 columns]
2025-06-09 17:50:59,574 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-06-09 17:50:59,580 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3766 2025-06-05 78410.00
3767 2025-06-06 78913.33
3768 2025-06-07 78913.33
3769 2025-06-08 78913.33
3770 2025-06-09 78891.67
2025-06-09 17:50:59,653 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date ... updated_at
3771 2025-06-07 ... 2025-06-09 17:50:59.646531
3772 2025-06-08 ... 2025-06-09 17:50:59.646531
3773 2025-06-09 ... 2025-06-09 17:50:59.646531
[3 rows x 5 columns]
2025-06-09 17:50:59,671 - 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-06-09 17:51:00,161 - 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-06-09 17:51:00,215 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-06-09 17:51:00,215 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-06-09 17:51:00,221 - 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-06-09 17:51:00,282 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-06-09 17:51:00,282 - 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-06-09 17:51:00,870 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2744 2025-06-05 259812.5
2745 2025-06-06 264462.5
2746 2025-06-07 264462.5
2747 2025-06-08 264462.5
2748 2025-06-09 263900.0
2025-06-09 17:51:00,934 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2746 2025-06-07 ... 2025-06-09 17:51:00.927466
2747 2025-06-08 ... 2025-06-09 17:51:00.927466
2748 2025-06-09 ... 2025-06-09 17:51:00.927466
[3 rows x 5 columns]
2025-06-09 17:51:00,954 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-06-09 17:51:00,960 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2744 2025-06-05 259812.5
2745 2025-06-06 264462.5
2746 2025-06-07 264462.5
2747 2025-06-08 264462.5
2748 2025-06-09 263900.0
2025-06-09 17:51:01,026 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2749 2025-06-07 ... 2025-06-09 17:51:01.017432
2750 2025-06-08 ... 2025-06-09 17:51:01.017432
2751 2025-06-09 ... 2025-06-09 17:51:01.017432
[3 rows x 5 columns]
2025-06-09 17:51:01,047 - 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-06-09 17:51:01,613 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3765 2025-06-05 22870.0
3766 2025-06-06 22680.0
3767 2025-06-07 22680.0
3768 2025-06-08 22680.0
3769 2025-06-09 22582.0
2025-06-09 17:51:01,686 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3767 2025-06-07 22680.0 ... 2025-06-09 17:51:01.678556 2025-06-09 17:51:01.679005
3768 2025-06-08 22680.0 ... 2025-06-09 17:51:01.678556 2025-06-09 17:51:01.679005
3769 2025-06-09 22582.0 ... 2025-06-09 17:51:01.678556 2025-06-09 17:51:01.679005
[3 rows x 5 columns]
2025-06-09 17:51:01,707 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-06-09 17:51:01,714 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3765 2025-06-05 22870.0
3766 2025-06-06 22680.0
3767 2025-06-07 22680.0
3768 2025-06-08 22680.0
3769 2025-06-09 22582.0
2025-06-09 17:51:01,788 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3770 2025-06-07 22680.0 ... 2025-06-09 17:51:01.780876 2025-06-09 17:51:01.781271
3771 2025-06-08 22680.0 ... 2025-06-09 17:51:01.780876 2025-06-09 17:51:01.781271
3772 2025-06-09 22582.0 ... 2025-06-09 17:51:01.780876 2025-06-09 17:51:01.781271
[3 rows x 5 columns]
2025-06-09 17:51:01,807 - 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-06-09 17:51:02,385 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3728 2025-06-05 3240.0
3729 2025-06-06 3262.5
3730 2025-06-07 3262.5
3731 2025-06-08 3262.5
3732 2025-06-09 3260.0
2025-06-09 17:51:02,460 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3730 2025-06-07 3262.5 ... 2025-06-09 17:51:02.452990 2025-06-09 17:51:02.453398
3731 2025-06-08 3262.5 ... 2025-06-09 17:51:02.452990 2025-06-09 17:51:02.453398
3732 2025-06-09 3260.0 ... 2025-06-09 17:51:02.452990 2025-06-09 17:51:02.453398
[3 rows x 5 columns]
2025-06-09 17:51:02,480 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-06-09 17:51:02,487 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3728 2025-06-05 3240.0
3729 2025-06-06 3262.5
3730 2025-06-07 3262.5
3731 2025-06-08 3262.5
3732 2025-06-09 3260.0
2025-06-09 17:51:02,560 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3733 2025-06-07 3262.5 ... 2025-06-09 17:51:02.553033 2025-06-09 17:51:02.553428
3734 2025-06-08 3262.5 ... 2025-06-09 17:51:02.553033 2025-06-09 17:51:02.553428
3735 2025-06-09 3260.0 ... 2025-06-09 17:51:02.553033 2025-06-09 17:51:02.553428
[3 rows x 5 columns]
2025-06-09 17:51:02,581 - 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-06-09 17:51:03,131 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1525 2025-06-05 4770.0
1526 2025-06-06 4770.0
1527 2025-06-07 4770.0
1528 2025-06-08 4770.0
1529 2025-06-09 4782.5
2025-06-09 17:51:03,176 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1527 2025-06-07 4770.0 ... 2025-06-09 17:51:03.168629 2025-06-09 17:51:03.169065
1528 2025-06-08 4770.0 ... 2025-06-09 17:51:03.168629 2025-06-09 17:51:03.169065
1529 2025-06-09 4782.5 ... 2025-06-09 17:51:03.168629 2025-06-09 17:51:03.169065
[3 rows x 5 columns]
2025-06-09 17:51:03,195 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-06-09 17:51:03,201 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1525 2025-06-05 4770.0
1526 2025-06-06 4770.0
1527 2025-06-07 4770.0
1528 2025-06-08 4770.0
1529 2025-06-09 4782.5
2025-06-09 17:51:03,248 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1530 2025-06-07 4770.0 ... 2025-06-09 17:51:03.240693 2025-06-09 17:51:03.241123
1531 2025-06-08 4770.0 ... 2025-06-09 17:51:03.240693 2025-06-09 17:51:03.241123
1532 2025-06-09 4782.5 ... 2025-06-09 17:51:03.240693 2025-06-09 17:51:03.241123
[3 rows x 5 columns]
2025-06-09 17:51:03,268 - 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-06-09 17:51:03,802 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2799 2025-06-05 2294.29
2800 2025-06-06 2294.29
2801 2025-06-07 2294.29
2802 2025-06-08 2294.29
2803 2025-06-09 2300.00
2025-06-09 17:51:03,863 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2801 2025-06-07 2294.29 ... 2025-06-09 17:51:03.855697 2025-06-09 17:51:03.856113
2802 2025-06-08 2294.29 ... 2025-06-09 17:51:03.855697 2025-06-09 17:51:03.856113
2803 2025-06-09 2300.00 ... 2025-06-09 17:51:03.855697 2025-06-09 17:51:03.856113
[3 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-06-09 17:51:03,905 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2800 2025-06-06 ... 2025-06-09 17:51:03.898455
[1 rows x 6 columns]
2025-06-09 17:51:03,930 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2799 2025-06-05 2294.29
2800 2025-06-06 2294.29
2801 2025-06-07 2294.29
2802 2025-06-08 2294.29
2803 2025-06-09 2300.00
2025-06-09 17:51:03,993 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2804 2025-06-07 2294.29 ... 2025-06-09 17:51:03.985552 2025-06-09 17:51:03.986009
2805 2025-06-08 2294.29 ... 2025-06-09 17:51:03.985552 2025-06-09 17:51:03.986009
2806 2025-06-09 2300.00 ... 2025-06-09 17:51:03.985552 2025-06-09 17:51:03.986009
[3 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-06-09 17:51:04,037 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2803 2025-06-06 ... 2025-06-09 17:51:04.029499
[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-06-09 17:51:04,896 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2799 2025-06-05 2294.29
2800 2025-06-06 2294.29
2801 2025-06-07 2294.29
2802 2025-06-08 2294.29
2803 2025-06-09 2898.00
2025-06-09 17:51:04,948 - 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-06-09 17:51:04,971 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2803 2025-06-09 ... 2025-06-09 17:51:04.963990
[1 rows x 6 columns]
2025-06-09 17:51:04,996 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2799 2025-06-05 2294.29
2800 2025-06-06 2294.29
2801 2025-06-07 2294.29
2802 2025-06-08 2294.29
2803 2025-06-09 2898.00
2025-06-09 17:51:05,049 - 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-06-09 17:51:05,072 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2806 2025-06-09 ... 2025-06-09 17:51:05.065203
[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-06-09 17:51:05,597 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3156 2025-06-05 9296.67
3157 2025-06-06 9296.67
3158 2025-06-07 9296.67
3159 2025-06-08 9296.67
3160 2025-06-09 9331.67
2025-06-09 17:51:05,655 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-06-09 17:51:05,655 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-06-09 17:51:05,661 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3156 2025-06-05 9296.67
3157 2025-06-06 9296.67
3158 2025-06-07 9296.67
3159 2025-06-08 9296.67
3160 2025-06-09 9331.67
2025-06-09 17:51:05,720 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-06-09 17:51:05,720 - 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-06-09 17:51:06,250 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1840 2025-06-05 4495.00
1841 2025-06-06 4498.33
1842 2025-06-07 4498.33
1843 2025-06-08 4498.33
1844 2025-06-09 4498.33
2025-06-09 17:51:06,301 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1842 2025-06-07 4498.33 ... 2025-06-09 17:51:06.293349 2025-06-09 17:51:06.293788
1843 2025-06-08 4498.33 ... 2025-06-09 17:51:06.293349 2025-06-09 17:51:06.293788
1844 2025-06-09 4498.33 ... 2025-06-09 17:51:06.293349 2025-06-09 17:51:06.293788
[3 rows x 5 columns]
2025-06-09 17:51:06,320 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-06-09 17:51:06,327 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1840 2025-06-05 4495.00
1841 2025-06-06 4498.33
1842 2025-06-07 4498.33
1843 2025-06-08 4498.33
1844 2025-06-09 4498.33
2025-06-09 17:51:06,377 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1845 2025-06-07 4498.33 ... 2025-06-09 17:51:06.369955 2025-06-09 17:51:06.370366
1846 2025-06-08 4498.33 ... 2025-06-09 17:51:06.369955 2025-06-09 17:51:06.370366
1847 2025-06-09 4498.33 ... 2025-06-09 17:51:06.369955 2025-06-09 17:51:06.370366
[3 rows x 5 columns]
2025-06-09 17:51:06,397 - 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-06-09 17:51:06,943 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1849 2025-06-05 6216.67
1850 2025-06-06 6216.67
1851 2025-06-07 6216.67
1852 2025-06-08 6216.67
1853 2025-06-09 6216.67
2025-06-09 17:51:06,994 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1851 2025-06-07 6216.67 ... 2025-06-09 17:51:06.986297 2025-06-09 17:51:06.986686
1852 2025-06-08 6216.67 ... 2025-06-09 17:51:06.986297 2025-06-09 17:51:06.986686
1853 2025-06-09 6216.67 ... 2025-06-09 17:51:06.986297 2025-06-09 17:51:06.986686
[3 rows x 5 columns]
2025-06-09 17:51:07,014 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-06-09 17:51:07,020 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1849 2025-06-05 6216.67
1850 2025-06-06 6216.67
1851 2025-06-07 6216.67
1852 2025-06-08 6216.67
1853 2025-06-09 6216.67
2025-06-09 17:51:07,071 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1854 2025-06-07 6216.67 ... 2025-06-09 17:51:07.063332 2025-06-09 17:51:07.063715
1855 2025-06-08 6216.67 ... 2025-06-09 17:51:07.063332 2025-06-09 17:51:07.063715
1856 2025-06-09 6216.67 ... 2025-06-09 17:51:07.063332 2025-06-09 17:51:07.063715
[3 rows x 5 columns]
2025-06-09 17:51:07,090 - 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-06-09 17:51:07,691 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3517 2025-06-05 8542.0
3518 2025-06-06 8520.0
3519 2025-06-07 8520.0
3520 2025-06-08 8520.0
3521 2025-06-09 8644.0
2025-06-09 17:51:07,760 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3519 2025-06-07 8520.0 ... 2025-06-09 17:51:07.752960 2025-06-09 17:51:07.753358
3520 2025-06-08 8520.0 ... 2025-06-09 17:51:07.752960 2025-06-09 17:51:07.753358
3521 2025-06-09 8644.0 ... 2025-06-09 17:51:07.752960 2025-06-09 17:51:07.753358
[3 rows x 5 columns]
2025-06-09 17:51:07,780 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-06-09 17:51:07,787 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3517 2025-06-05 8542.0
3518 2025-06-06 8520.0
3519 2025-06-07 8520.0
3520 2025-06-08 8520.0
3521 2025-06-09 8644.0
2025-06-09 17:51:07,857 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3522 2025-06-07 8520.0 ... 2025-06-09 17:51:07.849893 2025-06-09 17:51:07.850282
3523 2025-06-08 8520.0 ... 2025-06-09 17:51:07.849893 2025-06-09 17:51:07.850282
3524 2025-06-09 8644.0 ... 2025-06-09 17:51:07.849893 2025-06-09 17:51:07.850282
[3 rows x 5 columns]
2025-06-09 17:51:07,881 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data