=========================================================================
2025-05-16 17:50:26 Fri START TASK.01 IOOppi_data update_data
=========================================================================
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-16 17:50:28,602 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3301 2025-05-12 3160.33
3302 2025-05-13 3164.78
3303 2025-05-14 3191.78
3304 2025-05-15 3189.89
3305 2025-05-16 3184.22
2025-05-16 17:50:28,672 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3305 2025-05-16 3184.22 ... 2025-05-16 17:50:28.665129 2025-05-16 17:50:28.665525
[1 rows x 5 columns]
2025-05-16 17:50:28,695 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-05-16 17:50:28,701 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3301 2025-05-12 3160.33
3302 2025-05-13 3164.78
3303 2025-05-14 3191.78
3304 2025-05-15 3189.89
3305 2025-05-16 3184.22
2025-05-16 17:50:28,766 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3308 2025-05-16 3184.22 ... 2025-05-16 17:50:28.759339 2025-05-16 17:50:28.759714
[1 rows x 5 columns]
2025-05-16 17:50:28,788 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-16 17:50:29,329 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3522 2025-05-12 2402.50
3523 2025-05-13 2453.75
3524 2025-05-14 2521.25
3525 2025-05-15 2426.25
3526 2025-05-16 2426.25
2025-05-16 17:50:29,397 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3526 2025-05-16 2426.25 ... 2025-05-16 17:50:29.390642 2025-05-16 17:50:29.391056
[1 rows x 5 columns]
2025-05-16 17:50:29,418 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-05-16 17:50:29,423 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3522 2025-05-12 2402.50
3523 2025-05-13 2453.75
3524 2025-05-14 2521.25
3525 2025-05-15 2426.25
3526 2025-05-16 2426.25
2025-05-16 17:50:29,493 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3530 2025-05-16 2426.25 ... 2025-05-16 17:50:29.485136 2025-05-16 17:50:29.485522
[1 rows x 5 columns]
2025-05-16 17:50:29,513 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-16 17:50:30,058 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
862 2025-05-12 4888.33
863 2025-05-13 4913.34
864 2025-05-14 4913.34
865 2025-05-15 4991.66
866 2025-05-16 5007.50
2025-05-16 17:50:30,095 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
866 2025-05-16 5007.5 ... 2025-05-16 17:50:30.088367 2025-05-16 17:50:30.088810
[1 rows x 5 columns]
2025-05-16 17:50:30,116 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-05-16 17:50:30,121 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
862 2025-05-12 4888.33
863 2025-05-13 4913.34
864 2025-05-14 4913.34
865 2025-05-15 4991.66
866 2025-05-16 5007.50
2025-05-16 17:50:30,157 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
866 2025-05-16 5007.5 ... 2025-05-16 17:50:30.150085 2025-05-16 17:50:30.150457
[1 rows x 5 columns]
2025-05-16 17:50:30,177 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-16 17:50:30,744 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3741 2025-05-12 14738.33
3742 2025-05-13 14748.33
3743 2025-05-14 14983.33
3744 2025-05-15 14838.33
3745 2025-05-16 14658.33
2025-05-16 17:50:30,815 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3745 2025-05-16 ... 2025-05-16 17:50:30.809489
[1 rows x 5 columns]
2025-05-16 17:50:30,836 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-05-16 17:50:30,842 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3741 2025-05-12 14738.33
3742 2025-05-13 14748.33
3743 2025-05-14 14983.33
3744 2025-05-15 14838.33
3745 2025-05-16 14658.33
2025-05-16 17:50:30,913 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3748 2025-05-16 ... 2025-05-16 17:50:30.907343
[1 rows x 5 columns]
2025-05-16 17:50:30,934 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-16 17:50:31,582 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3073 2025-05-12 777.22
3074 2025-05-13 786.22
3075 2025-05-14 793.33
3076 2025-05-15 794.44
3077 2025-05-16 787.33
2025-05-16 17:50:31,650 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3077 2025-05-16 787.33 ... 2025-05-16 17:50:31.642602 2025-05-16 17:50:31.643030
[1 rows x 5 columns]
2025-05-16 17:50:31,671 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-05-16 17:50:31,676 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3073 2025-05-12 777.22
3074 2025-05-13 786.22
3075 2025-05-14 793.33
3076 2025-05-15 794.44
3077 2025-05-16 787.33
2025-05-16 17:50:31,739 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3080 2025-05-16 787.33 ... 2025-05-16 17:50:31.732586 2025-05-16 17:50:31.732986
[1 rows x 5 columns]
2025-05-16 17:50:31,759 - IOOppi_data - INFO : save diff data to db: IOOppi_i_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-16 17:50:32,291 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3276 2025-05-12 1210.4
3277 2025-05-13 1210.4
3278 2025-05-14 1196.0
3279 2025-05-15 1188.0
3280 2025-05-16 1168.0
2025-05-16 17:50:32,356 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3280 2025-05-16 1168.0 ... 2025-05-16 17:50:32.349617 2025-05-16 17:50:32.350024
[1 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-16 17:50:34,521 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-05-16 17:50:34.513814
21 2013-01-04 ... 2025-05-16 17:50:34.513814
54 2013-02-27 ... 2025-05-16 17:50:34.513814
60 2013-03-07 ... 2025-05-16 17:50:34.513814
61 2013-03-08 ... 2025-05-16 17:50:34.513814
[5 rows x 6 columns]
2025-05-16 17:50:34,694 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3276 2025-05-12 1210.4
3277 2025-05-13 1210.4
3278 2025-05-14 1196.0
3279 2025-05-15 1188.0
3280 2025-05-16 1168.0
2025-05-16 17:50:34,763 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3284 2025-05-16 1168.0 ... 2025-05-16 17:50:34.756656 2025-05-16 17:50:34.757067
[1 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-16 17:50:36,924 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-05-16 17:50:36.915984
21 2013-01-04 ... 2025-05-16 17:50:36.915984
54 2013-02-27 ... 2025-05-16 17:50:36.915984
60 2013-03-07 ... 2025-05-16 17:50:36.915984
61 2013-03-08 ... 2025-05-16 17:50:36.915984
[5 rows x 6 columns]
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-16 17:50:37,636 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1621 2025-05-12 7676.0
1622 2025-05-13 7720.0
1623 2025-05-14 7890.0
1624 2025-05-15 8270.0
1625 2025-05-16 8270.0
2025-05-16 17:50:37,680 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1625 2025-05-16 8270.0 ... 2025-05-16 17:50:37.673725 2025-05-16 17:50:37.674131
[1 rows x 5 columns]
2025-05-16 17:50:37,701 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-05-16 17:50:37,706 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1621 2025-05-12 7676.0
1622 2025-05-13 7720.0
1623 2025-05-14 7890.0
1624 2025-05-15 8270.0
1625 2025-05-16 8270.0
2025-05-16 17:50:37,752 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1628 2025-05-16 8270.0 ... 2025-05-16 17:50:37.745030 2025-05-16 17:50:37.745398
[1 rows x 5 columns]
2025-05-16 17:50:37,772 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-16 17:50:38,286 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3732 2025-05-12 6150.0
3733 2025-05-13 6145.0
3734 2025-05-14 6145.0
3735 2025-05-15 6145.0
3736 2025-05-16 6145.0
2025-05-16 17:50:38,359 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3736 2025-05-16 6145.0 ... 2025-05-16 17:50:38.351664 2025-05-16 17:50:38.352082
[1 rows x 5 columns]
2025-05-16 17:50:38,379 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-05-16 17:50:38,385 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3732 2025-05-12 6150.0
3733 2025-05-13 6145.0
3734 2025-05-14 6145.0
3735 2025-05-15 6145.0
3736 2025-05-16 6145.0
2025-05-16 17:50:38,458 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3740 2025-05-16 6145.0 ... 2025-05-16 17:50:38.451628 2025-05-16 17:50:38.452043
[1 rows x 5 columns]
2025-05-16 17:50:38,479 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-16 17:50:39,000 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1622 2025-05-12 13130.0
1623 2025-05-13 13130.0
1624 2025-05-14 13255.0
1625 2025-05-15 13255.0
1626 2025-05-16 13300.0
2025-05-16 17:50:39,047 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1626 2025-05-16 13300.0 ... 2025-05-16 17:50:39.040204 2025-05-16 17:50:39.040597
[1 rows x 5 columns]
2025-05-16 17:50:39,067 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-05-16 17:50:39,073 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1622 2025-05-12 13130.0
1623 2025-05-13 13130.0
1624 2025-05-14 13255.0
1625 2025-05-15 13255.0
1626 2025-05-16 13300.0
2025-05-16 17:50:39,121 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1629 2025-05-16 13300.0 ... 2025-05-16 17:50:39.113916 2025-05-16 17:50:39.114323
[1 rows x 5 columns]
2025-05-16 17:50:39,142 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-16 17:50:39,704 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3132 2025-05-12 9446.67
3133 2025-05-13 9468.33
3134 2025-05-14 9543.33
3135 2025-05-15 9395.00
3136 2025-05-16 9378.33
2025-05-16 17:50:39,767 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date value ... created_at updated_at
3136 2025-05-16 9378.33 ... 2025-05-16 17:50:39.760618 2025-05-16 17:50:39.761029
[1 rows x 5 columns]
2025-05-16 17:50:39,788 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-05-16 17:50:39,793 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3132 2025-05-12 9446.67
3133 2025-05-13 9468.33
3134 2025-05-14 9543.33
3135 2025-05-15 9395.00
3136 2025-05-16 9378.33
2025-05-16 17:50:39,857 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date value ... created_at updated_at
3140 2025-05-16 9378.33 ... 2025-05-16 17:50:39.850587 2025-05-16 17:50:39.850984
[1 rows x 5 columns]
2025-05-16 17:50:39,877 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-16 17:50:40,389 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3255 2025-05-12 2490.00
3256 2025-05-13 2476.67
3257 2025-05-14 2460.00
3258 2025-05-15 2476.67
3259 2025-05-16 2476.67
2025-05-16 17:50:40,453 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3259 2025-05-16 2476.67 ... 2025-05-16 17:50:40.446786 2025-05-16 17:50:40.447189
[1 rows x 5 columns]
2025-05-16 17:50:40,474 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-05-16 17:50:40,479 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3255 2025-05-12 2490.00
3256 2025-05-13 2476.67
3257 2025-05-14 2460.00
3258 2025-05-15 2476.67
3259 2025-05-16 2476.67
2025-05-16 17:50:40,545 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3263 2025-05-16 2476.67 ... 2025-05-16 17:50:40.537990 2025-05-16 17:50:40.538370
[1 rows x 5 columns]
2025-05-16 17:50:40,564 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-16 17:50:41,025 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1459 2025-05-12 1462.5
1460 2025-05-13 1462.5
1461 2025-05-14 1462.5
1462 2025-05-15 1462.5
1463 2025-05-16 1462.5
2025-05-16 17:50:41,068 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1463 2025-05-16 1462.5 ... 2025-05-16 17:50:41.061830 2025-05-16 17:50:41.062216
[1 rows x 5 columns]
2025-05-16 17:50:41,089 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-05-16 17:50:41,094 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1459 2025-05-12 1462.5
1460 2025-05-13 1462.5
1461 2025-05-14 1462.5
1462 2025-05-15 1462.5
1463 2025-05-16 1462.5
2025-05-16 17:50:41,138 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1467 2025-05-16 1462.5 ... 2025-05-16 17:50:41.131116 2025-05-16 17:50:41.131478
[1 rows x 5 columns]
2025-05-16 17:50:41,157 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-16 17:50:41,655 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1372 2025-05-12 6411.79
1373 2025-05-13 6535.29
1374 2025-05-14 6618.33
1375 2025-05-15 6688.96
1376 2025-05-16 6727.50
2025-05-16 17:50:41,698 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1376 2025-05-16 6727.5 ... 2025-05-16 17:50:41.690990 2025-05-16 17:50:41.691441
[1 rows x 5 columns]
2025-05-16 17:50:41,719 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-05-16 17:50:41,725 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1372 2025-05-12 6411.79
1373 2025-05-13 6535.29
1374 2025-05-14 6618.33
1375 2025-05-15 6688.96
1376 2025-05-16 6727.50
2025-05-16 17:50:41,767 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1380 2025-05-16 6727.5 ... 2025-05-16 17:50:41.760725 2025-05-16 17:50:41.761136
[1 rows x 5 columns]
2025-05-16 17:50:41,787 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-16 17:50:42,432 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3745 2025-05-12 3138.0
3746 2025-05-13 3116.0
3747 2025-05-14 3084.0
3748 2025-05-15 3074.0
3749 2025-05-16 2988.0
2025-05-16 17:50:42,504 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3749 2025-05-16 2988.0 ... 2025-05-16 17:50:42.496871 2025-05-16 17:50:42.497262
[1 rows x 5 columns]
2025-05-16 17:50:42,524 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-05-16 17:50:42,530 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3745 2025-05-12 3138.0
3746 2025-05-13 3116.0
3747 2025-05-14 3084.0
3748 2025-05-15 3074.0
3749 2025-05-16 2988.0
2025-05-16 17:50:42,602 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3752 2025-05-16 2988.0 ... 2025-05-16 17:50:42.594960 2025-05-16 17:50:42.595344
[1 rows x 5 columns]
2025-05-16 17:50:42,622 - IOOppi_data - INFO : save diff data to db: IOOppi_m_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-16 17:50:43,164 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3515 2025-05-12 8094.0
3516 2025-05-13 8076.0
3517 2025-05-14 8174.0
3518 2025-05-15 8054.0
3519 2025-05-16 8024.0
2025-05-16 17:50:43,233 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3519 2025-05-16 8024.0 ... 2025-05-16 17:50:43.226347 2025-05-16 17:50:43.226801
[1 rows x 5 columns]
2025-05-16 17:50:43,253 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-05-16 17:50:43,260 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3515 2025-05-12 8094.0
3516 2025-05-13 8076.0
3517 2025-05-14 8174.0
3518 2025-05-15 8054.0
3519 2025-05-16 8024.0
2025-05-16 17:50:43,329 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3522 2025-05-16 8024.0 ... 2025-05-16 17:50:43.322448 2025-05-16 17:50:43.322856
[1 rows x 5 columns]
2025-05-16 17:50:43,349 - IOOppi_data - INFO : save diff data to db: IOOppi_y_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-16 17:50:43,860 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3481 2025-05-12 4255.0
3482 2025-05-13 4255.0
3483 2025-05-14 4255.0
3484 2025-05-15 4255.0
3485 2025-05-16 4255.0
2025-05-16 17:50:43,928 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3485 2025-05-16 4255.0 ... 2025-05-16 17:50:43.921302 2025-05-16 17:50:43.921686
[1 rows x 5 columns]
2025-05-16 17:50:43,949 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-05-16 17:50:43,958 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3481 2025-05-12 4255.0
3482 2025-05-13 4255.0
3483 2025-05-14 4255.0
3484 2025-05-15 4255.0
3485 2025-05-16 4255.0
2025-05-16 17:50:44,028 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3488 2025-05-16 4255.0 ... 2025-05-16 17:50:44.021302 2025-05-16 17:50:44.021687
[1 rows x 5 columns]
2025-05-16 17:50:44,048 - IOOppi_data - INFO : save diff data to db: IOOppi_a_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-16 17:50:44,590 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2858 2025-05-12 5424.29
2859 2025-05-13 5424.29
2860 2025-05-14 5424.29
2861 2025-05-15 5424.29
2862 2025-05-16 5440.00
2025-05-16 17:50:44,653 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2862 2025-05-16 5440.0 ... 2025-05-16 17:50:44.646157 2025-05-16 17:50:44.646576
[1 rows x 5 columns]
2025-05-16 17:50:44,673 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-05-16 17:50:44,679 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2858 2025-05-12 5424.29
2859 2025-05-13 5424.29
2860 2025-05-14 5424.29
2861 2025-05-15 5424.29
2862 2025-05-16 5440.00
2025-05-16 17:50:44,743 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2866 2025-05-16 5440.0 ... 2025-05-16 17:50:44.736065 2025-05-16 17:50:44.736487
[1 rows x 5 columns]
2025-05-16 17:50:44,763 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-16 17:50:45,290 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3058 2025-05-12 3310.0
3059 2025-05-13 3365.0
3060 2025-05-14 3375.0
3061 2025-05-15 3375.0
3062 2025-05-16 3375.0
2025-05-16 17:50:45,354 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3062 2025-05-16 3375.0 ... 2025-05-16 17:50:45.347092 2025-05-16 17:50:45.347476
[1 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-16 17:50:45,517 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-05-16 17:50:45.509007
458 2015-09-21 ... 2025-05-16 17:50:45.509007
549 2016-02-03 ... 2025-05-16 17:50:45.509007
693 2016-09-05 ... 2025-05-16 17:50:45.509007
696 2016-09-08 ... 2025-05-16 17:50:45.509007
[5 rows x 6 columns]
2025-05-16 17:50:45,549 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3058 2025-05-12 3310.0
3059 2025-05-13 3365.0
3060 2025-05-14 3375.0
3061 2025-05-15 3375.0
3062 2025-05-16 3375.0
2025-05-16 17:50:45,614 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3065 2025-05-16 3375.0 ... 2025-05-16 17:50:45.607354 2025-05-16 17:50:45.607771
[1 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-16 17:50:45,776 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-05-16 17:50:45.768270
458 2015-09-21 ... 2025-05-16 17:50:45.768270
549 2016-02-03 ... 2025-05-16 17:50:45.768270
693 2016-09-05 ... 2025-05-16 17:50:45.768270
696 2016-09-08 ... 2025-05-16 17:50:45.768270
[5 rows x 6 columns]
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-16 17:50:46,382 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
862 2025-05-12 9610.0
863 2025-05-13 9610.0
864 2025-05-14 9610.0
865 2025-05-15 9520.0
866 2025-05-16 9480.0
2025-05-16 17:50:46,420 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
866 2025-05-16 9480.0 ... 2025-05-16 17:50:46.412545 2025-05-16 17:50:46.412981
[1 rows x 5 columns]
2025-05-16 17:50:46,440 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-05-16 17:50:46,446 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
862 2025-05-12 9610.0
863 2025-05-13 9610.0
864 2025-05-14 9610.0
865 2025-05-15 9520.0
866 2025-05-16 9480.0
2025-05-16 17:50:46,484 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
866 2025-05-16 9480.0 ... 2025-05-16 17:50:46.476662 2025-05-16 17:50:46.477078
[1 rows x 5 columns]
2025-05-16 17:50:46,504 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-16 17:50:47,059 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3741 2025-05-12 7428.33
3742 2025-05-13 7445.00
3743 2025-05-14 7508.33
3744 2025-05-15 7558.33
3745 2025-05-16 7566.67
2025-05-16 17:50:47,131 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3745 2025-05-16 7566.67 ... 2025-05-16 17:50:47.124289 2025-05-16 17:50:47.124677
[1 rows x 5 columns]
2025-05-16 17:50:47,152 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-05-16 17:50:47,158 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3741 2025-05-12 7428.33
3742 2025-05-13 7445.00
3743 2025-05-14 7508.33
3744 2025-05-15 7558.33
3745 2025-05-16 7566.67
2025-05-16 17:50:47,230 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3748 2025-05-16 7566.67 ... 2025-05-16 17:50:47.223118 2025-05-16 17:50:47.223507
[1 rows x 5 columns]
2025-05-16 17:50:47,251 - IOOppi_data - INFO : save diff data to db: IOOppi_l_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-16 17:50:47,765 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3079 2025-05-12 3585.0
3080 2025-05-13 3595.0
3081 2025-05-14 3595.0
3082 2025-05-15 3602.5
3083 2025-05-16 3600.0
2025-05-16 17:50:47,829 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3084 2025-05-16 3600.0 ... 2025-05-16 17:50:47.822168 2025-05-16 17:50:47.822550
[1 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-16 17:50:47,867 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-05-16 17:50:47.860228
[1 rows x 6 columns]
2025-05-16 17:50:47,893 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3079 2025-05-12 3585.0
3080 2025-05-13 3595.0
3081 2025-05-14 3595.0
3082 2025-05-15 3602.5
3083 2025-05-16 3600.0
2025-05-16 17:50:47,958 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3086 2025-05-16 3600.0 ... 2025-05-16 17:50:47.950954 2025-05-16 17:50:47.951340
[1 rows x 5 columns]
2025-05-16 17:50:47,978 - IOOppi_data - INFO : save diff data to db: IOOppi_bu_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-16 17:50:48,536 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3744 2025-05-12 19830.00
3745 2025-05-13 20033.33
3746 2025-05-14 20033.33
3747 2025-05-15 20226.67
3748 2025-05-16 20290.00
2025-05-16 17:50:48,610 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date value ... created_at updated_at
3748 2025-05-16 20290.0 ... 2025-05-16 17:50:48.601886 2025-05-16 17:50:48.602292
[1 rows x 5 columns]
2025-05-16 17:50:48,631 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-05-16 17:50:48,637 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3744 2025-05-12 19830.00
3745 2025-05-13 20033.33
3746 2025-05-14 20033.33
3747 2025-05-15 20226.67
3748 2025-05-16 20290.00
2025-05-16 17:50:48,711 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date value ... created_at updated_at
3751 2025-05-16 20290.0 ... 2025-05-16 17:50:48.704036 2025-05-16 17:50:48.704469
[1 rows x 5 columns]
2025-05-16 17:50:48,732 - IOOppi_data - INFO : save diff data to db: IOOppi_al_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-16 17:50:49,283 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2858 2025-05-12 5676.0
2859 2025-05-13 5676.0
2860 2025-05-14 5692.0
2861 2025-05-15 5706.0
2862 2025-05-16 5698.0
2025-05-16 17:50:49,345 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2862 2025-05-16 5698.0 ... 2025-05-16 17:50:49.338207 2025-05-16 17:50:49.338601
[1 rows x 5 columns]
2025-05-16 17:50:49,366 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-05-16 17:50:49,372 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2858 2025-05-12 5676.0
2859 2025-05-13 5676.0
2860 2025-05-14 5692.0
2861 2025-05-15 5706.0
2862 2025-05-16 5698.0
2025-05-16 17:50:49,436 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2866 2025-05-16 5698.0 ... 2025-05-16 17:50:49.427410 2025-05-16 17:50:49.427900
[1 rows x 5 columns]
2025-05-16 17:50:49,456 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-16 17:50:49,983 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2133 2025-05-12 23775.0
2134 2025-05-13 23775.0
2135 2025-05-14 23775.0
2136 2025-05-15 23775.0
2137 2025-05-16 23775.0
2025-05-16 17:50:50,035 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2137 2025-05-16 23775.0 ... 2025-05-16 17:50:50.028310 2025-05-16 17:50:50.028696
[1 rows x 5 columns]
2025-05-16 17:50:50,057 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-05-16 17:50:50,062 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2133 2025-05-12 23775.0
2134 2025-05-13 23775.0
2135 2025-05-14 23775.0
2136 2025-05-15 23775.0
2137 2025-05-16 23775.0
2025-05-16 17:50:50,116 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2141 2025-05-16 23775.0 ... 2025-05-16 17:50:50.108564 2025-05-16 17:50:50.108975
[1 rows x 5 columns]
2025-05-16 17:50:50,136 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-16 17:50:50,693 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1648 2025-05-12 1945.00
1649 2025-05-13 1945.00
1650 2025-05-14 1945.00
1651 2025-05-15 1946.67
1652 2025-05-16 1946.67
2025-05-16 17:50:50,740 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1652 2025-05-16 1946.67 ... 2025-05-16 17:50:50.733162 2025-05-16 17:50:50.733589
[1 rows x 5 columns]
2025-05-16 17:50:50,761 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-05-16 17:50:50,766 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1648 2025-05-12 1945.00
1649 2025-05-13 1945.00
1650 2025-05-14 1945.00
1651 2025-05-15 1946.67
1652 2025-05-16 1946.67
2025-05-16 17:50:50,814 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1656 2025-05-16 1946.67 ... 2025-05-16 17:50:50.807172 2025-05-16 17:50:50.807720
[1 rows x 5 columns]
2025-05-16 17:50:50,835 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-16 17:50:51,384 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2720 2025-05-12 126525.00
2721 2025-05-13 124916.67
2722 2025-05-14 126308.33
2723 2025-05-15 126525.00
2724 2025-05-16 126258.33
2025-05-16 17:50:51,442 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2724 2025-05-16 ... 2025-05-16 17:50:51.435805
[1 rows x 5 columns]
2025-05-16 17:50:51,462 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-05-16 17:50:51,468 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2720 2025-05-12 126525.00
2721 2025-05-13 124916.67
2722 2025-05-14 126308.33
2723 2025-05-15 126525.00
2724 2025-05-16 126258.33
2025-05-16 17:50:51,529 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2727 2025-05-16 ... 2025-05-16 17:50:51.522472
[1 rows x 5 columns]
2025-05-16 17:50:51,549 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-16 17:50:52,098 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3745 2025-05-12 4604.0
3746 2025-05-13 4602.0
3747 2025-05-14 4697.0
3748 2025-05-15 4756.0
3749 2025-05-16 4782.0
2025-05-16 17:50:52,171 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3749 2025-05-16 4782.0 ... 2025-05-16 17:50:52.162721 2025-05-16 17:50:52.163204
[1 rows x 5 columns]
2025-05-16 17:50:52,192 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-05-16 17:50:52,198 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3745 2025-05-12 4604.0
3746 2025-05-13 4602.0
3747 2025-05-14 4697.0
3748 2025-05-15 4756.0
3749 2025-05-16 4782.0
2025-05-16 17:50:52,273 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3752 2025-05-16 4782.0 ... 2025-05-16 17:50:52.266591 2025-05-16 17:50:52.267004
[1 rows x 5 columns]
2025-05-16 17:50:52,293 - IOOppi_data - INFO : save diff data to db: IOOppi_v_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-16 17:50:52,935 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
2984 2025-05-12 7440.0
2985 2025-05-13 7440.0
2986 2025-05-14 7440.0
2987 2025-05-15 7440.0
2988 2025-05-16 7440.0
2025-05-16 17:50:52,997 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
2988 2025-05-16 7440.0 ... 2025-05-16 17:50:52.990187 2025-05-16 17:50:52.990569
[1 rows x 5 columns]
2025-05-16 17:50:53,021 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-05-16 17:50:53,027 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
2984 2025-05-12 7440.0
2985 2025-05-13 7440.0
2986 2025-05-14 7440.0
2987 2025-05-15 7440.0
2988 2025-05-16 7440.0
2025-05-16 17:50:53,089 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
2991 2025-05-16 7440.0 ... 2025-05-16 17:50:53.082648 2025-05-16 17:50:53.083048
[1 rows x 5 columns]
2025-05-16 17:50:53,109 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-16 17:50:53,692 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3746 2025-05-12 14200.83
3747 2025-05-13 14388.83
3748 2025-05-14 14482.83
3749 2025-05-15 14512.33
3750 2025-05-16 14558.17
2025-05-16 17:50:53,764 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date ... updated_at
3750 2025-05-16 ... 2025-05-16 17:50:53.757972
[1 rows x 5 columns]
2025-05-16 17:50:53,784 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-05-16 17:50:53,790 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3746 2025-05-12 14200.83
3747 2025-05-13 14388.83
3748 2025-05-14 14482.83
3749 2025-05-15 14512.33
3750 2025-05-16 14558.17
2025-05-16 17:50:53,863 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date ... updated_at
3754 2025-05-16 ... 2025-05-16 17:50:53.856630
[1 rows x 5 columns]
2025-05-16 17:50:53,883 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-16 17:50:54,430 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3691 2025-05-12 16806.25
3692 2025-05-13 16850.00
3693 2025-05-14 16850.00
3694 2025-05-15 16906.25
3695 2025-05-16 16847.50
2025-05-16 17:50:54,502 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date value ... created_at updated_at
3695 2025-05-16 16847.5 ... 2025-05-16 17:50:54.494987 2025-05-16 17:50:54.495383
[1 rows x 5 columns]
2025-05-16 17:50:54,523 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-05-16 17:50:54,529 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3691 2025-05-12 16806.25
3692 2025-05-13 16850.00
3693 2025-05-14 16850.00
3694 2025-05-15 16906.25
3695 2025-05-16 16847.50
2025-05-16 17:50:54,601 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date value ... created_at updated_at
3698 2025-05-16 16847.5 ... 2025-05-16 17:50:54.593994 2025-05-16 17:50:54.594382
[1 rows x 5 columns]
2025-05-16 17:50:54,621 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-16 17:50:55,146 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
2966 2025-05-12 3256.67
2967 2025-05-13 3296.67
2968 2025-05-14 3313.33
2969 2025-05-15 3313.33
2970 2025-05-16 3310.00
2025-05-16 17:50:55,285 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
2970 2025-05-16 3310.0 ... 2025-05-16 17:50:55.278481 2025-05-16 17:50:55.278904
[1 rows x 5 columns]
2025-05-16 17:50:55,306 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-05-16 17:50:55,313 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
2966 2025-05-12 3256.67
2967 2025-05-13 3296.67
2968 2025-05-14 3313.33
2969 2025-05-15 3313.33
2970 2025-05-16 3310.00
2025-05-16 17:50:55,376 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
2973 2025-05-16 3310.0 ... 2025-05-16 17:50:55.369374 2025-05-16 17:50:55.369785
[1 rows x 5 columns]
2025-05-16 17:50:55,396 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-16 17:50:55,933 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3246 2025-05-12 5470.0
3247 2025-05-13 5482.5
3248 2025-05-14 5470.0
3249 2025-05-15 5445.0
3250 2025-05-16 5445.0
2025-05-16 17:50:55,998 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3250 2025-05-16 5445.0 ... 2025-05-16 17:50:55.991052 2025-05-16 17:50:55.991427
[1 rows x 5 columns]
2025-05-16 17:50:56,020 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-05-16 17:50:56,025 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3246 2025-05-12 5470.0
3247 2025-05-13 5482.5
3248 2025-05-14 5470.0
3249 2025-05-15 5445.0
3250 2025-05-16 5445.0
2025-05-16 17:50:56,096 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3737 2025-05-16 5445.0 ... 2025-05-16 17:50:56.089920 2025-05-16 17:50:56.090299
[1 rows x 5 columns]
2025-05-16 17:50:56,117 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-16 17:50:56,605 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1310 2025-05-12 14750.0
1311 2025-05-13 14720.0
1312 2025-05-14 14730.0
1313 2025-05-15 14680.0
1314 2025-05-16 14650.0
2025-05-16 17:50:56,647 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1314 2025-05-16 14650.0 ... 2025-05-16 17:50:56.640285 2025-05-16 17:50:56.640697
[1 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-16 17:50:56,910 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-05-16 17:50:56.902431
117 2021-07-06 ... 2025-05-16 17:50:56.902431
121 2021-07-12 ... 2025-05-16 17:50:56.902431
122 2021-07-13 ... 2025-05-16 17:50:56.902431
194 2021-11-01 ... 2025-05-16 17:50:56.902431
[5 rows x 6 columns]
2025-05-16 17:50:56,951 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1310 2025-05-12 14750.0
1311 2025-05-13 14720.0
1312 2025-05-14 14730.0
1313 2025-05-15 14680.0
1314 2025-05-16 14650.0
2025-05-16 17:50:56,993 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1317 2025-05-16 14650.0 ... 2025-05-16 17:50:56.986497 2025-05-16 17:50:56.986907
[1 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-16 17:50:57,259 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-05-16 17:50:57.251693
117 2021-07-06 ... 2025-05-16 17:50:57.251693
121 2021-07-12 ... 2025-05-16 17:50:57.251693
122 2021-07-13 ... 2025-05-16 17:50:57.251693
194 2021-11-01 ... 2025-05-16 17:50:57.251693
[5 rows x 6 columns]
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-16 17:50:57,995 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3742 2025-05-12 78425.00
3743 2025-05-13 78168.33
3744 2025-05-14 78801.67
3745 2025-05-15 78938.33
3746 2025-05-16 78818.33
2025-05-16 17:50:58,068 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date ... updated_at
3746 2025-05-16 ... 2025-05-16 17:50:58.062062
[1 rows x 5 columns]
2025-05-16 17:50:58,089 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-05-16 17:50:58,095 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3742 2025-05-12 78425.00
3743 2025-05-13 78168.33
3744 2025-05-14 78801.67
3745 2025-05-15 78938.33
3746 2025-05-16 78818.33
2025-05-16 17:50:58,168 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date ... updated_at
3749 2025-05-16 ... 2025-05-16 17:50:58.162270
[1 rows x 5 columns]
2025-05-16 17:50:58,190 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-16 17:50:58,748 - IOOppi_data - INFO : save data to db IOOppi_PM_t data:
date value
2947 2024-06-26 2440.0
2948 2024-06-27 2460.0
2949 2024-06-28 2460.0
2950 2024-06-29 2460.0
2951 2024-06-30 2460.0
2025-05-16 17:50:58,803 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-05-16 17:50:58,803 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-05-16 17:50:58,808 - IOOppi_data - INFO : save data to db IOOppi_PM_g data:
date value
2947 2024-06-26 2440.0
2948 2024-06-27 2460.0
2949 2024-06-28 2460.0
2950 2024-06-29 2460.0
2951 2024-06-30 2460.0
2025-05-16 17:50:58,869 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-05-16 17:50:58,869 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-16 17:50:59,459 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2720 2025-05-12 262537.5
2721 2025-05-13 262125.0
2722 2025-05-14 265137.5
2723 2025-05-15 266125.0
2724 2025-05-16 265487.5
2025-05-16 17:50:59,518 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2724 2025-05-16 ... 2025-05-16 17:50:59.511781
[1 rows x 5 columns]
2025-05-16 17:50:59,538 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-05-16 17:50:59,544 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2720 2025-05-12 262537.5
2721 2025-05-13 262125.0
2722 2025-05-14 265137.5
2723 2025-05-15 266125.0
2724 2025-05-16 265487.5
2025-05-16 17:50:59,604 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2727 2025-05-16 ... 2025-05-16 17:50:59.598372
[1 rows x 5 columns]
2025-05-16 17:50:59,625 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-16 17:51:00,180 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3741 2025-05-12 22730.0
3742 2025-05-13 22662.0
3743 2025-05-14 22850.0
3744 2025-05-15 22880.0
3745 2025-05-16 22746.0
2025-05-16 17:51:00,252 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3745 2025-05-16 22746.0 ... 2025-05-16 17:51:00.245508 2025-05-16 17:51:00.245936
[1 rows x 5 columns]
2025-05-16 17:51:00,273 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-05-16 17:51:00,280 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3741 2025-05-12 22730.0
3742 2025-05-13 22662.0
3743 2025-05-14 22850.0
3744 2025-05-15 22880.0
3745 2025-05-16 22746.0
2025-05-16 17:51:00,355 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3748 2025-05-16 22746.0 ... 2025-05-16 17:51:00.347712 2025-05-16 17:51:00.348133
[1 rows x 5 columns]
2025-05-16 17:51:00,375 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-16 17:51:00,903 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3704 2025-05-12 3342.5
3705 2025-05-13 3342.5
3706 2025-05-14 3370.0
3707 2025-05-15 3377.5
3708 2025-05-16 3372.5
2025-05-16 17:51:00,977 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3708 2025-05-16 3372.5 ... 2025-05-16 17:51:00.969489 2025-05-16 17:51:00.969939
[1 rows x 5 columns]
2025-05-16 17:51:00,997 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-05-16 17:51:01,004 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3704 2025-05-12 3342.5
3705 2025-05-13 3342.5
3706 2025-05-14 3370.0
3707 2025-05-15 3377.5
3708 2025-05-16 3372.5
2025-05-16 17:51:01,077 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3711 2025-05-16 3372.5 ... 2025-05-16 17:51:01.068698 2025-05-16 17:51:01.069126
[1 rows x 5 columns]
2025-05-16 17:51:01,097 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-16 17:51:01,714 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1501 2025-05-12 4905.0
1502 2025-05-13 4882.5
1503 2025-05-14 4882.5
1504 2025-05-15 4847.5
1505 2025-05-16 4780.0
2025-05-16 17:51:01,758 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1505 2025-05-16 4780.0 ... 2025-05-16 17:51:01.751392 2025-05-16 17:51:01.751801
[1 rows x 5 columns]
2025-05-16 17:51:01,781 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-05-16 17:51:01,787 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1501 2025-05-12 4905.0
1502 2025-05-13 4882.5
1503 2025-05-14 4882.5
1504 2025-05-15 4847.5
1505 2025-05-16 4780.0
2025-05-16 17:51:01,832 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1508 2025-05-16 4780.0 ... 2025-05-16 17:51:01.825085 2025-05-16 17:51:01.825467
[1 rows x 5 columns]
2025-05-16 17:51:01,853 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-16 17:51:02,352 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2775 2025-05-12 2298.57
2776 2025-05-13 2300.00
2777 2025-05-14 2304.29
2778 2025-05-15 2304.29
2779 2025-05-16 2304.29
2025-05-16 17:51:02,416 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2779 2025-05-16 2304.29 ... 2025-05-16 17:51:02.408783 2025-05-16 17:51:02.409188
[1 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-16 17:51:02,461 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2778 2025-05-15 ... 2025-05-16 17:51:02.454187
[1 rows x 6 columns]
2025-05-16 17:51:02,490 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2775 2025-05-12 2298.57
2776 2025-05-13 2300.00
2777 2025-05-14 2304.29
2778 2025-05-15 2304.29
2779 2025-05-16 2304.29
2025-05-16 17:51:02,551 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2782 2025-05-16 2304.29 ... 2025-05-16 17:51:02.544698 2025-05-16 17:51:02.545111
[1 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-16 17:51:02,598 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2781 2025-05-15 ... 2025-05-16 17:51:02.591081
[1 rows x 6 columns]
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-16 17:51:03,247 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2775 2025-05-12 2298.57
2776 2025-05-13 2300.00
2777 2025-05-14 2304.29
2778 2025-05-15 2304.29
2779 2025-05-16 2922.00
2025-05-16 17:51:03,299 - IOOppi_data - INFO : save new data to db: IOOppi_cs_t: no new data
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-16 17:51:03,324 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2779 2025-05-16 ... 2025-05-16 17:51:03.316299
[1 rows x 6 columns]
2025-05-16 17:51:03,350 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2775 2025-05-12 2298.57
2776 2025-05-13 2300.00
2777 2025-05-14 2304.29
2778 2025-05-15 2304.29
2779 2025-05-16 2922.00
2025-05-16 17:51:03,402 - IOOppi_data - INFO : save new data to db: IOOppi_cs_g: no new data
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-16 17:51:03,425 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2782 2025-05-16 ... 2025-05-16 17:51:03.418684
[1 rows x 6 columns]
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-16 17:51:03,971 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3132 2025-05-12 9446.67
3133 2025-05-13 9468.33
3134 2025-05-14 9543.33
3135 2025-05-15 9395.00
3136 2025-05-16 9378.33
2025-05-16 17:51:04,026 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-05-16 17:51:04,026 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-05-16 17:51:04,031 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3132 2025-05-12 9446.67
3133 2025-05-13 9468.33
3134 2025-05-14 9543.33
3135 2025-05-15 9395.00
3136 2025-05-16 9378.33
2025-05-16 17:51:04,088 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-05-16 17:51:04,088 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-16 17:51:04,861 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1816 2025-05-12 4408.33
1817 2025-05-13 4408.33
1818 2025-05-14 4408.33
1819 2025-05-15 4536.67
1820 2025-05-16 4551.67
2025-05-16 17:51:04,909 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1820 2025-05-16 4551.67 ... 2025-05-16 17:51:04.902158 2025-05-16 17:51:04.902544
[1 rows x 5 columns]
2025-05-16 17:51:04,930 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-05-16 17:51:04,935 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1816 2025-05-12 4408.33
1817 2025-05-13 4408.33
1818 2025-05-14 4408.33
1819 2025-05-15 4536.67
1820 2025-05-16 4551.67
2025-05-16 17:51:04,983 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1823 2025-05-16 4551.67 ... 2025-05-16 17:51:04.976482 2025-05-16 17:51:04.976877
[1 rows x 5 columns]
2025-05-16 17:51:05,005 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-16 17:51:05,542 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1825 2025-05-12 6200.00
1826 2025-05-13 6250.00
1827 2025-05-14 6266.67
1828 2025-05-15 6300.00
1829 2025-05-16 6300.00
2025-05-16 17:51:05,590 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1829 2025-05-16 6300.0 ... 2025-05-16 17:51:05.582988 2025-05-16 17:51:05.583369
[1 rows x 5 columns]
2025-05-16 17:51:05,611 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-05-16 17:51:05,616 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1825 2025-05-12 6200.00
1826 2025-05-13 6250.00
1827 2025-05-14 6266.67
1828 2025-05-15 6300.00
1829 2025-05-16 6300.00
2025-05-16 17:51:05,665 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1832 2025-05-16 6300.0 ... 2025-05-16 17:51:05.658371 2025-05-16 17:51:05.658747
[1 rows x 5 columns]
2025-05-16 17:51:05,685 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-16 17:51:07,030 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3493 2025-05-12 8610.0
3494 2025-05-13 8564.0
3495 2025-05-14 8680.0
3496 2025-05-15 8680.0
3497 2025-05-16 8492.0
2025-05-16 17:51:07,100 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3497 2025-05-16 8492.0 ... 2025-05-16 17:51:07.093367 2025-05-16 17:51:07.093743
[1 rows x 5 columns]
2025-05-16 17:51:07,120 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-05-16 17:51:07,126 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3493 2025-05-12 8610.0
3494 2025-05-13 8564.0
3495 2025-05-14 8680.0
3496 2025-05-15 8680.0
3497 2025-05-16 8492.0
2025-05-16 17:51:07,196 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3500 2025-05-16 8492.0 ... 2025-05-16 17:51:07.188925 2025-05-16 17:51:07.189321
[1 rows x 5 columns]
2025-05-16 17:51:07,216 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data