=========================================================================
2025-05-14 17:50:26 Wed 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-14 17:50:28,908 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3299 2025-05-10 3141.44
3300 2025-05-11 3141.44
3301 2025-05-12 3160.33
3302 2025-05-13 3164.78
3303 2025-05-14 3191.78
2025-05-14 17:50:28,978 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3303 2025-05-14 3191.78 ... 2025-05-14 17:50:28.970891 2025-05-14 17:50:28.971351
[1 rows x 5 columns]
2025-05-14 17:50:29,000 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-05-14 17:50:29,006 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3299 2025-05-10 3141.44
3300 2025-05-11 3141.44
3301 2025-05-12 3160.33
3302 2025-05-13 3164.78
3303 2025-05-14 3191.78
2025-05-14 17:50:29,070 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3306 2025-05-14 3191.78 ... 2025-05-14 17:50:29.063816 2025-05-14 17:50:29.064200
[1 rows x 5 columns]
2025-05-14 17:50:29,090 - 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-14 17:50:29,674 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3520 2025-05-10 2402.50
3521 2025-05-11 2402.50
3522 2025-05-12 2402.50
3523 2025-05-13 2453.75
3524 2025-05-14 2521.25
2025-05-14 17:50:29,743 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3524 2025-05-14 2521.25 ... 2025-05-14 17:50:29.735981 2025-05-14 17:50:29.736391
[1 rows x 5 columns]
2025-05-14 17:50:29,766 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-05-14 17:50:29,772 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3520 2025-05-10 2402.50
3521 2025-05-11 2402.50
3522 2025-05-12 2402.50
3523 2025-05-13 2453.75
3524 2025-05-14 2521.25
2025-05-14 17:50:29,841 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3528 2025-05-14 2521.25 ... 2025-05-14 17:50:29.834209 2025-05-14 17:50:29.834638
[1 rows x 5 columns]
2025-05-14 17:50:29,860 - 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-14 17:50:30,393 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
860 2025-05-10 4750.84
861 2025-05-11 4750.84
862 2025-05-12 4888.33
863 2025-05-13 4913.34
864 2025-05-14 4913.34
2025-05-14 17:50:30,428 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
864 2025-05-14 4913.34 ... 2025-05-14 17:50:30.421114 2025-05-14 17:50:30.421490
[1 rows x 5 columns]
2025-05-14 17:50:30,447 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-05-14 17:50:30,453 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
860 2025-05-10 4750.84
861 2025-05-11 4750.84
862 2025-05-12 4888.33
863 2025-05-13 4913.34
864 2025-05-14 4913.34
2025-05-14 17:50:30,489 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
864 2025-05-14 4913.34 ... 2025-05-14 17:50:30.482079 2025-05-14 17:50:30.482462
[1 rows x 5 columns]
2025-05-14 17:50:30,508 - 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-14 17:50:31,060 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3739 2025-05-10 14408.33
3740 2025-05-11 14408.33
3741 2025-05-12 14738.33
3742 2025-05-13 14748.33
3743 2025-05-14 14983.33
2025-05-14 17:50:31,131 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3743 2025-05-14 ... 2025-05-14 17:50:31.124693
[1 rows x 5 columns]
2025-05-14 17:50:31,151 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-05-14 17:50:31,157 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3739 2025-05-10 14408.33
3740 2025-05-11 14408.33
3741 2025-05-12 14738.33
3742 2025-05-13 14748.33
3743 2025-05-14 14983.33
2025-05-14 17:50:31,230 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3746 2025-05-14 ... 2025-05-14 17:50:31.223483
[1 rows x 5 columns]
2025-05-14 17:50:31,251 - 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-14 17:50:31,841 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3071 2025-05-10 770.89
3072 2025-05-11 770.89
3073 2025-05-12 777.22
3074 2025-05-13 786.22
3075 2025-05-14 793.33
2025-05-14 17:50:31,905 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3075 2025-05-14 793.33 ... 2025-05-14 17:50:31.897484 2025-05-14 17:50:31.897918
[1 rows x 5 columns]
2025-05-14 17:50:31,923 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-05-14 17:50:31,929 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3071 2025-05-10 770.89
3072 2025-05-11 770.89
3073 2025-05-12 777.22
3074 2025-05-13 786.22
3075 2025-05-14 793.33
2025-05-14 17:50:31,991 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3078 2025-05-14 793.33 ... 2025-05-14 17:50:31.984160 2025-05-14 17:50:31.984522
[1 rows x 5 columns]
2025-05-14 17:50:32,011 - 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-14 17:50:32,545 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3274 2025-05-10 1210.4
3275 2025-05-11 1210.4
3276 2025-05-12 1210.4
3277 2025-05-13 1210.4
3278 2025-05-14 1196.0
2025-05-14 17:50:32,611 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3278 2025-05-14 1196.0 ... 2025-05-14 17:50:32.603903 2025-05-14 17:50:32.604337
[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-14 17:50:34,567 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-05-14 17:50:34.559804
21 2013-01-04 ... 2025-05-14 17:50:34.559804
54 2013-02-27 ... 2025-05-14 17:50:34.559804
60 2013-03-07 ... 2025-05-14 17:50:34.559804
61 2013-03-08 ... 2025-05-14 17:50:34.559804
[5 rows x 6 columns]
2025-05-14 17:50:34,727 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3274 2025-05-10 1210.4
3275 2025-05-11 1210.4
3276 2025-05-12 1210.4
3277 2025-05-13 1210.4
3278 2025-05-14 1196.0
2025-05-14 17:50:34,797 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3282 2025-05-14 1196.0 ... 2025-05-14 17:50:34.789859 2025-05-14 17:50:34.790248
[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-14 17:50:36,756 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-05-14 17:50:36.748201
21 2013-01-04 ... 2025-05-14 17:50:36.748201
54 2013-02-27 ... 2025-05-14 17:50:36.748201
60 2013-03-07 ... 2025-05-14 17:50:36.748201
61 2013-03-08 ... 2025-05-14 17:50:36.748201
[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-14 17:50:37,467 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1619 2025-05-10 7680.0
1620 2025-05-11 7680.0
1621 2025-05-12 7676.0
1622 2025-05-13 7720.0
1623 2025-05-14 7890.0
2025-05-14 17:50:37,512 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1623 2025-05-14 7890.0 ... 2025-05-14 17:50:37.504706 2025-05-14 17:50:37.505112
[1 rows x 5 columns]
2025-05-14 17:50:37,531 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-05-14 17:50:37,536 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1619 2025-05-10 7680.0
1620 2025-05-11 7680.0
1621 2025-05-12 7676.0
1622 2025-05-13 7720.0
1623 2025-05-14 7890.0
2025-05-14 17:50:37,581 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1626 2025-05-14 7890.0 ... 2025-05-14 17:50:37.574374 2025-05-14 17:50:37.574743
[1 rows x 5 columns]
2025-05-14 17:50:37,600 - 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-14 17:50:38,118 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3730 2025-05-10 6135.0
3731 2025-05-11 6135.0
3732 2025-05-12 6150.0
3733 2025-05-13 6145.0
3734 2025-05-14 6145.0
2025-05-14 17:50:38,190 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3734 2025-05-14 6145.0 ... 2025-05-14 17:50:38.182786 2025-05-14 17:50:38.183175
[1 rows x 5 columns]
2025-05-14 17:50:38,209 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-05-14 17:50:38,215 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3730 2025-05-10 6135.0
3731 2025-05-11 6135.0
3732 2025-05-12 6150.0
3733 2025-05-13 6145.0
3734 2025-05-14 6145.0
2025-05-14 17:50:38,287 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3738 2025-05-14 6145.0 ... 2025-05-14 17:50:38.280433 2025-05-14 17:50:38.280858
[1 rows x 5 columns]
2025-05-14 17:50:38,307 - 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-14 17:50:38,808 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1620 2025-05-10 13042.5
1621 2025-05-11 13042.5
1622 2025-05-12 13130.0
1623 2025-05-13 13130.0
1624 2025-05-14 13255.0
2025-05-14 17:50:38,853 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1624 2025-05-14 13255.0 ... 2025-05-14 17:50:38.846191 2025-05-14 17:50:38.846567
[1 rows x 5 columns]
2025-05-14 17:50:38,873 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-05-14 17:50:38,878 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1620 2025-05-10 13042.5
1621 2025-05-11 13042.5
1622 2025-05-12 13130.0
1623 2025-05-13 13130.0
1624 2025-05-14 13255.0
2025-05-14 17:50:38,924 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1627 2025-05-14 13255.0 ... 2025-05-14 17:50:38.917113 2025-05-14 17:50:38.917508
[1 rows x 5 columns]
2025-05-14 17:50:38,943 - 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-14 17:50:39,480 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3130 2025-05-10 9463.33
3131 2025-05-11 9463.33
3132 2025-05-12 9446.67
3133 2025-05-13 9468.33
3134 2025-05-14 9543.33
2025-05-14 17:50:39,544 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date value ... created_at updated_at
3134 2025-05-14 9543.33 ... 2025-05-14 17:50:39.537182 2025-05-14 17:50:39.537564
[1 rows x 5 columns]
2025-05-14 17:50:39,563 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-05-14 17:50:39,569 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3130 2025-05-10 9463.33
3131 2025-05-11 9463.33
3132 2025-05-12 9446.67
3133 2025-05-13 9468.33
3134 2025-05-14 9543.33
2025-05-14 17:50:39,633 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date value ... created_at updated_at
3138 2025-05-14 9543.33 ... 2025-05-14 17:50:39.626345 2025-05-14 17:50:39.626726
[1 rows x 5 columns]
2025-05-14 17:50:39,652 - 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-14 17:50:40,201 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3253 2025-05-10 2506.67
3254 2025-05-11 2506.67
3255 2025-05-12 2490.00
3256 2025-05-13 2476.67
3257 2025-05-14 2460.00
2025-05-14 17:50:40,267 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3257 2025-05-14 2460.0 ... 2025-05-14 17:50:40.260066 2025-05-14 17:50:40.260483
[1 rows x 5 columns]
2025-05-14 17:50:40,285 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-05-14 17:50:40,291 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3253 2025-05-10 2506.67
3254 2025-05-11 2506.67
3255 2025-05-12 2490.00
3256 2025-05-13 2476.67
3257 2025-05-14 2460.00
2025-05-14 17:50:40,356 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3261 2025-05-14 2460.0 ... 2025-05-14 17:50:40.348971 2025-05-14 17:50:40.349345
[1 rows x 5 columns]
2025-05-14 17:50:40,376 - 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-14 17:50:40,838 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1457 2025-05-10 1462.5
1458 2025-05-11 1462.5
1459 2025-05-12 1462.5
1460 2025-05-13 1462.5
1461 2025-05-14 1462.5
2025-05-14 17:50:40,882 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1461 2025-05-14 1462.5 ... 2025-05-14 17:50:40.875149 2025-05-14 17:50:40.875534
[1 rows x 5 columns]
2025-05-14 17:50:40,902 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-05-14 17:50:40,907 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1457 2025-05-10 1462.5
1458 2025-05-11 1462.5
1459 2025-05-12 1462.5
1460 2025-05-13 1462.5
1461 2025-05-14 1462.5
2025-05-14 17:50:40,950 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1465 2025-05-14 1462.5 ... 2025-05-14 17:50:40.943598 2025-05-14 17:50:40.944005
[1 rows x 5 columns]
2025-05-14 17:50:40,971 - 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-14 17:50:41,546 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1370 2025-05-10 6377.92
1371 2025-05-11 6377.92
1372 2025-05-12 6411.79
1373 2025-05-13 6535.29
1374 2025-05-14 6618.33
2025-05-14 17:50:41,587 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1374 2025-05-14 6618.33 ... 2025-05-14 17:50:41.580410 2025-05-14 17:50:41.580806
[1 rows x 5 columns]
2025-05-14 17:50:41,606 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-05-14 17:50:41,611 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1370 2025-05-10 6377.92
1371 2025-05-11 6377.92
1372 2025-05-12 6411.79
1373 2025-05-13 6535.29
1374 2025-05-14 6618.33
2025-05-14 17:50:41,652 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1378 2025-05-14 6618.33 ... 2025-05-14 17:50:41.645579 2025-05-14 17:50:41.645965
[1 rows x 5 columns]
2025-05-14 17:50:41,672 - 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-14 17:50:42,201 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3743 2025-05-10 3300.0
3744 2025-05-11 3300.0
3745 2025-05-12 3138.0
3746 2025-05-13 3116.0
3747 2025-05-14 3084.0
2025-05-14 17:50:42,274 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3747 2025-05-14 3084.0 ... 2025-05-14 17:50:42.266964 2025-05-14 17:50:42.267364
[1 rows x 5 columns]
2025-05-14 17:50:42,294 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-05-14 17:50:42,300 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3743 2025-05-10 3300.0
3744 2025-05-11 3300.0
3745 2025-05-12 3138.0
3746 2025-05-13 3116.0
3747 2025-05-14 3084.0
2025-05-14 17:50:42,373 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3750 2025-05-14 3084.0 ... 2025-05-14 17:50:42.365995 2025-05-14 17:50:42.366384
[1 rows x 5 columns]
2025-05-14 17:50:42,392 - 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-14 17:50:42,933 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3513 2025-05-10 8076.0
3514 2025-05-11 8076.0
3515 2025-05-12 8094.0
3516 2025-05-13 8076.0
3517 2025-05-14 8174.0
2025-05-14 17:50:43,003 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3517 2025-05-14 8174.0 ... 2025-05-14 17:50:42.995050 2025-05-14 17:50:42.995429
[1 rows x 5 columns]
2025-05-14 17:50:43,025 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-05-14 17:50:43,033 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3513 2025-05-10 8076.0
3514 2025-05-11 8076.0
3515 2025-05-12 8094.0
3516 2025-05-13 8076.0
3517 2025-05-14 8174.0
2025-05-14 17:50:43,106 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3520 2025-05-14 8174.0 ... 2025-05-14 17:50:43.099255 2025-05-14 17:50:43.099638
[1 rows x 5 columns]
2025-05-14 17:50:43,125 - 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-14 17:50:43,649 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3479 2025-05-10 4245.0
3480 2025-05-11 4245.0
3481 2025-05-12 4255.0
3482 2025-05-13 4255.0
3483 2025-05-14 4255.0
2025-05-14 17:50:43,722 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3483 2025-05-14 4255.0 ... 2025-05-14 17:50:43.713283 2025-05-14 17:50:43.713676
[1 rows x 5 columns]
2025-05-14 17:50:43,743 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-05-14 17:50:43,750 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3479 2025-05-10 4245.0
3480 2025-05-11 4245.0
3481 2025-05-12 4255.0
3482 2025-05-13 4255.0
3483 2025-05-14 4255.0
2025-05-14 17:50:43,820 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3486 2025-05-14 4255.0 ... 2025-05-14 17:50:43.813113 2025-05-14 17:50:43.813507
[1 rows x 5 columns]
2025-05-14 17:50:43,840 - 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-14 17:50:44,383 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2856 2025-05-10 5402.86
2857 2025-05-11 5402.86
2858 2025-05-12 5424.29
2859 2025-05-13 5424.29
2860 2025-05-14 5424.29
2025-05-14 17:50:44,445 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2860 2025-05-14 5424.29 ... 2025-05-14 17:50:44.438079 2025-05-14 17:50:44.438476
[1 rows x 5 columns]
2025-05-14 17:50:44,464 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-05-14 17:50:44,470 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2856 2025-05-10 5402.86
2857 2025-05-11 5402.86
2858 2025-05-12 5424.29
2859 2025-05-13 5424.29
2860 2025-05-14 5424.29
2025-05-14 17:50:44,533 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2864 2025-05-14 5424.29 ... 2025-05-14 17:50:44.526072 2025-05-14 17:50:44.526461
[1 rows x 5 columns]
2025-05-14 17:50:44,554 - 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-14 17:50:45,072 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3056 2025-05-10 3225.0
3057 2025-05-11 3225.0
3058 2025-05-12 3310.0
3059 2025-05-13 3365.0
3060 2025-05-14 3375.0
2025-05-14 17:50:45,135 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3060 2025-05-14 3375.0 ... 2025-05-14 17:50:45.128492 2025-05-14 17:50:45.128910
[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-14 17:50:45,294 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-05-14 17:50:45.286188
458 2015-09-21 ... 2025-05-14 17:50:45.286188
549 2016-02-03 ... 2025-05-14 17:50:45.286188
693 2016-09-05 ... 2025-05-14 17:50:45.286188
696 2016-09-08 ... 2025-05-14 17:50:45.286188
[5 rows x 6 columns]
2025-05-14 17:50:45,327 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3056 2025-05-10 3225.0
3057 2025-05-11 3225.0
3058 2025-05-12 3310.0
3059 2025-05-13 3365.0
3060 2025-05-14 3375.0
2025-05-14 17:50:45,393 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3063 2025-05-14 3375.0 ... 2025-05-14 17:50:45.385684 2025-05-14 17:50:45.386107
[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-14 17:50:45,547 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-05-14 17:50:45.539856
458 2015-09-21 ... 2025-05-14 17:50:45.539856
549 2016-02-03 ... 2025-05-14 17:50:45.539856
693 2016-09-05 ... 2025-05-14 17:50:45.539856
696 2016-09-08 ... 2025-05-14 17:50:45.539856
[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-14 17:50:46,201 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
860 2025-05-10 9640.0
861 2025-05-11 9640.0
862 2025-05-12 9610.0
863 2025-05-13 9610.0
864 2025-05-14 9610.0
2025-05-14 17:50:46,239 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
864 2025-05-14 9610.0 ... 2025-05-14 17:50:46.230954 2025-05-14 17:50:46.231541
[1 rows x 5 columns]
2025-05-14 17:50:46,259 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-05-14 17:50:46,265 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
860 2025-05-10 9640.0
861 2025-05-11 9640.0
862 2025-05-12 9610.0
863 2025-05-13 9610.0
864 2025-05-14 9610.0
2025-05-14 17:50:46,304 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
864 2025-05-14 9610.0 ... 2025-05-14 17:50:46.297211 2025-05-14 17:50:46.297602
[1 rows x 5 columns]
2025-05-14 17:50:46,324 - 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-14 17:50:46,950 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3739 2025-05-10 7458.33
3740 2025-05-11 7458.33
3741 2025-05-12 7428.33
3742 2025-05-13 7445.00
3743 2025-05-14 7508.33
2025-05-14 17:50:47,021 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3743 2025-05-14 7508.33 ... 2025-05-14 17:50:47.014615 2025-05-14 17:50:47.015030
[1 rows x 5 columns]
2025-05-14 17:50:47,040 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-05-14 17:50:47,047 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3739 2025-05-10 7458.33
3740 2025-05-11 7458.33
3741 2025-05-12 7428.33
3742 2025-05-13 7445.00
3743 2025-05-14 7508.33
2025-05-14 17:50:47,118 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3746 2025-05-14 7508.33 ... 2025-05-14 17:50:47.111287 2025-05-14 17:50:47.111658
[1 rows x 5 columns]
2025-05-14 17:50:47,137 - 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-14 17:50:47,676 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3077 2025-05-10 3585.0
3078 2025-05-11 3585.0
3079 2025-05-12 3585.0
3080 2025-05-13 3595.0
3081 2025-05-14 3595.0
2025-05-14 17:50:47,739 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3082 2025-05-14 3595.0 ... 2025-05-14 17:50:47.732295 2025-05-14 17:50:47.732679
[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-14 17:50:47,776 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-05-14 17:50:47.769558
[1 rows x 6 columns]
2025-05-14 17:50:47,803 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3077 2025-05-10 3585.0
3078 2025-05-11 3585.0
3079 2025-05-12 3585.0
3080 2025-05-13 3595.0
3081 2025-05-14 3595.0
2025-05-14 17:50:47,867 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3084 2025-05-14 3595.0 ... 2025-05-14 17:50:47.860200 2025-05-14 17:50:47.860574
[1 rows x 5 columns]
2025-05-14 17:50:47,885 - 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-14 17:50:48,452 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3742 2025-05-10 19626.67
3743 2025-05-11 19626.67
3744 2025-05-12 19830.00
3745 2025-05-13 20033.33
3746 2025-05-14 20033.33
2025-05-14 17:50:48,525 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date ... updated_at
3746 2025-05-14 ... 2025-05-14 17:50:48.518490
[1 rows x 5 columns]
2025-05-14 17:50:48,544 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-05-14 17:50:48,550 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3742 2025-05-10 19626.67
3743 2025-05-11 19626.67
3744 2025-05-12 19830.00
3745 2025-05-13 20033.33
3746 2025-05-14 20033.33
2025-05-14 17:50:48,622 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date ... updated_at
3749 2025-05-14 ... 2025-05-14 17:50:48.616347
[1 rows x 5 columns]
2025-05-14 17:50:48,641 - 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-14 17:50:49,170 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2856 2025-05-10 5634.0
2857 2025-05-11 5634.0
2858 2025-05-12 5676.0
2859 2025-05-13 5676.0
2860 2025-05-14 5692.0
2025-05-14 17:50:49,232 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2860 2025-05-14 5692.0 ... 2025-05-14 17:50:49.225016 2025-05-14 17:50:49.225406
[1 rows x 5 columns]
2025-05-14 17:50:49,251 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-05-14 17:50:49,257 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2856 2025-05-10 5634.0
2857 2025-05-11 5634.0
2858 2025-05-12 5676.0
2859 2025-05-13 5676.0
2860 2025-05-14 5692.0
2025-05-14 17:50:49,319 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2864 2025-05-14 5692.0 ... 2025-05-14 17:50:49.312482 2025-05-14 17:50:49.312882
[1 rows x 5 columns]
2025-05-14 17:50:49,339 - 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-14 17:50:49,956 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2131 2025-05-10 23775.0
2132 2025-05-11 23775.0
2133 2025-05-12 23775.0
2134 2025-05-13 23775.0
2135 2025-05-14 23775.0
2025-05-14 17:50:50,007 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2135 2025-05-14 23775.0 ... 2025-05-14 17:50:50.000317 2025-05-14 17:50:50.000709
[1 rows x 5 columns]
2025-05-14 17:50:50,026 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-05-14 17:50:50,032 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2131 2025-05-10 23775.0
2132 2025-05-11 23775.0
2133 2025-05-12 23775.0
2134 2025-05-13 23775.0
2135 2025-05-14 23775.0
2025-05-14 17:50:50,084 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2139 2025-05-14 23775.0 ... 2025-05-14 17:50:50.077138 2025-05-14 17:50:50.077509
[1 rows x 5 columns]
2025-05-14 17:50:50,103 - 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-14 17:50:50,633 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1646 2025-05-10 1921.67
1647 2025-05-11 1921.67
1648 2025-05-12 1945.00
1649 2025-05-13 1945.00
1650 2025-05-14 1945.00
2025-05-14 17:50:50,686 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1650 2025-05-14 1945.0 ... 2025-05-14 17:50:50.678744 2025-05-14 17:50:50.679193
[1 rows x 5 columns]
2025-05-14 17:50:50,706 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-05-14 17:50:50,712 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1646 2025-05-10 1921.67
1647 2025-05-11 1921.67
1648 2025-05-12 1945.00
1649 2025-05-13 1945.00
1650 2025-05-14 1945.00
2025-05-14 17:50:50,758 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1654 2025-05-14 1945.0 ... 2025-05-14 17:50:50.750810 2025-05-14 17:50:50.751202
[1 rows x 5 columns]
2025-05-14 17:50:50,776 - 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-14 17:50:51,495 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2718 2025-05-10 124758.33
2719 2025-05-11 124758.33
2720 2025-05-12 126525.00
2721 2025-05-13 124916.67
2722 2025-05-14 126308.33
2025-05-14 17:50:51,554 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2722 2025-05-14 ... 2025-05-14 17:50:51.548053
[1 rows x 5 columns]
2025-05-14 17:50:51,573 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-05-14 17:50:51,579 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2718 2025-05-10 124758.33
2719 2025-05-11 124758.33
2720 2025-05-12 126525.00
2721 2025-05-13 124916.67
2722 2025-05-14 126308.33
2025-05-14 17:50:51,640 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2725 2025-05-14 ... 2025-05-14 17:50:51.633820
[1 rows x 5 columns]
2025-05-14 17:50:51,659 - 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-14 17:50:52,220 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3743 2025-05-10 4629.0
3744 2025-05-11 4629.0
3745 2025-05-12 4604.0
3746 2025-05-13 4602.0
3747 2025-05-14 4697.0
2025-05-14 17:50:52,292 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3747 2025-05-14 4697.0 ... 2025-05-14 17:50:52.285385 2025-05-14 17:50:52.285826
[1 rows x 5 columns]
2025-05-14 17:50:52,312 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-05-14 17:50:52,319 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3743 2025-05-10 4629.0
3744 2025-05-11 4629.0
3745 2025-05-12 4604.0
3746 2025-05-13 4602.0
3747 2025-05-14 4697.0
2025-05-14 17:50:52,393 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3750 2025-05-14 4697.0 ... 2025-05-14 17:50:52.386526 2025-05-14 17:50:52.386942
[1 rows x 5 columns]
2025-05-14 17:50:52,412 - 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-14 17:50:52,968 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
2982 2025-05-10 7440.0
2983 2025-05-11 7440.0
2984 2025-05-12 7440.0
2985 2025-05-13 7440.0
2986 2025-05-14 7440.0
2025-05-14 17:50:53,029 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
2986 2025-05-14 7440.0 ... 2025-05-14 17:50:53.022674 2025-05-14 17:50:53.023083
[1 rows x 5 columns]
2025-05-14 17:50:53,049 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-05-14 17:50:53,054 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
2982 2025-05-10 7440.0
2983 2025-05-11 7440.0
2984 2025-05-12 7440.0
2985 2025-05-13 7440.0
2986 2025-05-14 7440.0
2025-05-14 17:50:53,118 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
2989 2025-05-14 7440.0 ... 2025-05-14 17:50:53.110538 2025-05-14 17:50:53.110970
[1 rows x 5 columns]
2025-05-14 17:50:53,137 - 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-14 17:50:53,819 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3744 2025-05-10 14136.00
3745 2025-05-11 14136.00
3746 2025-05-12 14200.83
3747 2025-05-13 14388.83
3748 2025-05-14 14482.83
2025-05-14 17:50:53,890 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date ... updated_at
3748 2025-05-14 ... 2025-05-14 17:50:53.883801
[1 rows x 5 columns]
2025-05-14 17:50:53,909 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-05-14 17:50:53,914 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3744 2025-05-10 14136.00
3745 2025-05-11 14136.00
3746 2025-05-12 14200.83
3747 2025-05-13 14388.83
3748 2025-05-14 14482.83
2025-05-14 17:50:53,984 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date ... updated_at
3752 2025-05-14 ... 2025-05-14 17:50:53.978910
[1 rows x 5 columns]
2025-05-14 17:50:54,003 - 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-14 17:50:54,554 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3689 2025-05-10 16718.75
3690 2025-05-11 16718.75
3691 2025-05-12 16806.25
3692 2025-05-13 16850.00
3693 2025-05-14 16850.00
2025-05-14 17:50:54,628 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date value ... created_at updated_at
3693 2025-05-14 16850.0 ... 2025-05-14 17:50:54.620460 2025-05-14 17:50:54.620898
[1 rows x 5 columns]
2025-05-14 17:50:54,647 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-05-14 17:50:54,653 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3689 2025-05-10 16718.75
3690 2025-05-11 16718.75
3691 2025-05-12 16806.25
3692 2025-05-13 16850.00
3693 2025-05-14 16850.00
2025-05-14 17:50:54,724 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date value ... created_at updated_at
3696 2025-05-14 16850.0 ... 2025-05-14 17:50:54.717384 2025-05-14 17:50:54.717783
[1 rows x 5 columns]
2025-05-14 17:50:54,743 - 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-14 17:50:55,273 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
2964 2025-05-10 3273.33
2965 2025-05-11 3273.33
2966 2025-05-12 3256.67
2967 2025-05-13 3296.67
2968 2025-05-14 3313.33
2025-05-14 17:50:55,340 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
2968 2025-05-14 3313.33 ... 2025-05-14 17:50:55.332443 2025-05-14 17:50:55.332944
[1 rows x 5 columns]
2025-05-14 17:50:55,360 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-05-14 17:50:55,365 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
2964 2025-05-10 3273.33
2965 2025-05-11 3273.33
2966 2025-05-12 3256.67
2967 2025-05-13 3296.67
2968 2025-05-14 3313.33
2025-05-14 17:50:55,428 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
2971 2025-05-14 3313.33 ... 2025-05-14 17:50:55.421621 2025-05-14 17:50:55.422034
[1 rows x 5 columns]
2025-05-14 17:50:55,448 - 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-14 17:50:56,065 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3244 2025-05-10 5470.0
3245 2025-05-11 5470.0
3246 2025-05-12 5470.0
3247 2025-05-13 5482.5
3248 2025-05-14 5470.0
2025-05-14 17:50:56,140 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3248 2025-05-14 5470.0 ... 2025-05-14 17:50:56.129630 2025-05-14 17:50:56.130252
[1 rows x 5 columns]
2025-05-14 17:50:56,162 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-05-14 17:50:56,172 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3244 2025-05-10 5470.0
3245 2025-05-11 5470.0
3246 2025-05-12 5470.0
3247 2025-05-13 5482.5
3248 2025-05-14 5470.0
2025-05-14 17:50:56,258 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3735 2025-05-14 5470.0 ... 2025-05-14 17:50:56.250883 2025-05-14 17:50:56.251291
[1 rows x 5 columns]
2025-05-14 17:50:56,278 - 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-14 17:50:56,773 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1308 2025-05-10 14780.0
1309 2025-05-11 14780.0
1310 2025-05-12 14750.0
1311 2025-05-13 14720.0
1312 2025-05-14 14730.0
2025-05-14 17:50:56,818 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1312 2025-05-14 14730.0 ... 2025-05-14 17:50:56.810238 2025-05-14 17:50:56.810636
[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-14 17:50:57,059 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-05-14 17:50:57.051201
117 2021-07-06 ... 2025-05-14 17:50:57.051201
121 2021-07-12 ... 2025-05-14 17:50:57.051201
122 2021-07-13 ... 2025-05-14 17:50:57.051201
194 2021-11-01 ... 2025-05-14 17:50:57.051201
[5 rows x 6 columns]
2025-05-14 17:50:57,096 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1308 2025-05-10 14780.0
1309 2025-05-11 14780.0
1310 2025-05-12 14750.0
1311 2025-05-13 14720.0
1312 2025-05-14 14730.0
2025-05-14 17:50:57,138 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1315 2025-05-14 14730.0 ... 2025-05-14 17:50:57.131494 2025-05-14 17:50:57.131897
[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-14 17:50:57,377 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-05-14 17:50:57.369169
117 2021-07-06 ... 2025-05-14 17:50:57.369169
121 2021-07-12 ... 2025-05-14 17:50:57.369169
122 2021-07-13 ... 2025-05-14 17:50:57.369169
194 2021-11-01 ... 2025-05-14 17:50:57.369169
[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-14 17:50:58,135 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3740 2025-05-10 78258.33
3741 2025-05-11 78258.33
3742 2025-05-12 78425.00
3743 2025-05-13 78168.33
3744 2025-05-14 78801.67
2025-05-14 17:50:58,204 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date ... updated_at
3744 2025-05-14 ... 2025-05-14 17:50:58.198223
[1 rows x 5 columns]
2025-05-14 17:50:58,223 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-05-14 17:50:58,228 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3740 2025-05-10 78258.33
3741 2025-05-11 78258.33
3742 2025-05-12 78425.00
3743 2025-05-13 78168.33
3744 2025-05-14 78801.67
2025-05-14 17:50:58,298 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date ... updated_at
3747 2025-05-14 ... 2025-05-14 17:50:58.292706
[1 rows x 5 columns]
2025-05-14 17:50:58,318 - 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-14 17:50:58,784 - 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-14 17:50:58,837 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-05-14 17:50:58,837 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-05-14 17:50:58,843 - 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-14 17:50:58,905 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-05-14 17:50:58,906 - 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-14 17:50:59,488 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2718 2025-05-10 259500.0
2719 2025-05-11 259500.0
2720 2025-05-12 262537.5
2721 2025-05-13 262125.0
2722 2025-05-14 265137.5
2025-05-14 17:50:59,546 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2722 2025-05-14 ... 2025-05-14 17:50:59.539953
[1 rows x 5 columns]
2025-05-14 17:50:59,564 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-05-14 17:50:59,569 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2718 2025-05-10 259500.0
2719 2025-05-11 259500.0
2720 2025-05-12 262537.5
2721 2025-05-13 262125.0
2722 2025-05-14 265137.5
2025-05-14 17:50:59,628 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2725 2025-05-14 ... 2025-05-14 17:50:59.621909
[1 rows x 5 columns]
2025-05-14 17:50:59,646 - 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-14 17:51:00,203 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3739 2025-05-10 22756.0
3740 2025-05-11 22756.0
3741 2025-05-12 22730.0
3742 2025-05-13 22662.0
3743 2025-05-14 22850.0
2025-05-14 17:51:00,275 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3743 2025-05-14 22850.0 ... 2025-05-14 17:51:00.268022 2025-05-14 17:51:00.268405
[1 rows x 5 columns]
2025-05-14 17:51:00,294 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-05-14 17:51:00,300 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3739 2025-05-10 22756.0
3740 2025-05-11 22756.0
3741 2025-05-12 22730.0
3742 2025-05-13 22662.0
3743 2025-05-14 22850.0
2025-05-14 17:51:00,373 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3746 2025-05-14 22850.0 ... 2025-05-14 17:51:00.366162 2025-05-14 17:51:00.366619
[1 rows x 5 columns]
2025-05-14 17:51:00,392 - 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-14 17:51:00,919 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3702 2025-05-10 3367.5
3703 2025-05-11 3367.5
3704 2025-05-12 3342.5
3705 2025-05-13 3342.5
3706 2025-05-14 3370.0
2025-05-14 17:51:00,989 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3706 2025-05-14 3370.0 ... 2025-05-14 17:51:00.982628 2025-05-14 17:51:00.983040
[1 rows x 5 columns]
2025-05-14 17:51:01,008 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-05-14 17:51:01,015 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3702 2025-05-10 3367.5
3703 2025-05-11 3367.5
3704 2025-05-12 3342.5
3705 2025-05-13 3342.5
3706 2025-05-14 3370.0
2025-05-14 17:51:01,091 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3709 2025-05-14 3370.0 ... 2025-05-14 17:51:01.080882 2025-05-14 17:51:01.081456
[1 rows x 5 columns]
2025-05-14 17:51:01,112 - 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-14 17:51:01,819 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1499 2025-05-10 4917.5
1500 2025-05-11 4917.5
1501 2025-05-12 4905.0
1502 2025-05-13 4882.5
1503 2025-05-14 4882.5
2025-05-14 17:51:01,862 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1503 2025-05-14 4882.5 ... 2025-05-14 17:51:01.855842 2025-05-14 17:51:01.856230
[1 rows x 5 columns]
2025-05-14 17:51:01,881 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-05-14 17:51:01,886 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1499 2025-05-10 4917.5
1500 2025-05-11 4917.5
1501 2025-05-12 4905.0
1502 2025-05-13 4882.5
1503 2025-05-14 4882.5
2025-05-14 17:51:01,930 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1506 2025-05-14 4882.5 ... 2025-05-14 17:51:01.923704 2025-05-14 17:51:01.924107
[1 rows x 5 columns]
2025-05-14 17:51:01,949 - 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-14 17:51:02,513 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2773 2025-05-10 2292.86
2774 2025-05-11 2292.86
2775 2025-05-12 2298.57
2776 2025-05-13 2300.00
2777 2025-05-14 2304.29
2025-05-14 17:51:02,573 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2777 2025-05-14 2304.29 ... 2025-05-14 17:51:02.566115 2025-05-14 17:51:02.566507
[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-14 17:51:02,616 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2776 2025-05-13 ... 2025-05-14 17:51:02.608655
[1 rows x 6 columns]
2025-05-14 17:51:02,640 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2773 2025-05-10 2292.86
2774 2025-05-11 2292.86
2775 2025-05-12 2298.57
2776 2025-05-13 2300.00
2777 2025-05-14 2304.29
2025-05-14 17:51:02,701 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2780 2025-05-14 2304.29 ... 2025-05-14 17:51:02.694056 2025-05-14 17:51:02.694434
[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-14 17:51:02,742 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2779 2025-05-13 ... 2025-05-14 17:51:02.734994
[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-14 17:51:03,272 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2773 2025-05-10 2292.86
2774 2025-05-11 2292.86
2775 2025-05-12 2298.57
2776 2025-05-13 2300.00
2777 2025-05-14 2926.00
2025-05-14 17:51:03,324 - 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-14 17:51:03,347 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2777 2025-05-14 ... 2025-05-14 17:51:03.339639
[1 rows x 6 columns]
2025-05-14 17:51:03,371 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2773 2025-05-10 2292.86
2774 2025-05-11 2292.86
2775 2025-05-12 2298.57
2776 2025-05-13 2300.00
2777 2025-05-14 2926.00
2025-05-14 17:51:03,424 - 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-14 17:51:03,447 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2780 2025-05-14 ... 2025-05-14 17:51:03.440140
[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-14 17:51:04,063 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3130 2025-05-10 9463.33
3131 2025-05-11 9463.33
3132 2025-05-12 9446.67
3133 2025-05-13 9468.33
3134 2025-05-14 9543.33
2025-05-14 17:51:04,118 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-05-14 17:51:04,118 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-05-14 17:51:04,123 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3130 2025-05-10 9463.33
3131 2025-05-11 9463.33
3132 2025-05-12 9446.67
3133 2025-05-13 9468.33
3134 2025-05-14 9543.33
2025-05-14 17:51:04,180 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-05-14 17:51:04,180 - 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-14 17:51:04,709 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1814 2025-05-10 4340.00
1815 2025-05-11 4340.00
1816 2025-05-12 4408.33
1817 2025-05-13 4408.33
1818 2025-05-14 4408.33
2025-05-14 17:51:04,757 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1818 2025-05-14 4408.33 ... 2025-05-14 17:51:04.750028 2025-05-14 17:51:04.750412
[1 rows x 5 columns]
2025-05-14 17:51:04,777 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-05-14 17:51:04,783 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1814 2025-05-10 4340.00
1815 2025-05-11 4340.00
1816 2025-05-12 4408.33
1817 2025-05-13 4408.33
1818 2025-05-14 4408.33
2025-05-14 17:51:04,832 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1821 2025-05-14 4408.33 ... 2025-05-14 17:51:04.824717 2025-05-14 17:51:04.825133
[1 rows x 5 columns]
2025-05-14 17:51:04,851 - 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-14 17:51:05,392 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1823 2025-05-10 6200.00
1824 2025-05-11 6200.00
1825 2025-05-12 6200.00
1826 2025-05-13 6250.00
1827 2025-05-14 6266.67
2025-05-14 17:51:05,444 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1827 2025-05-14 6266.67 ... 2025-05-14 17:51:05.435569 2025-05-14 17:51:05.435994
[1 rows x 5 columns]
2025-05-14 17:51:05,464 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-05-14 17:51:05,471 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1823 2025-05-10 6200.00
1824 2025-05-11 6200.00
1825 2025-05-12 6200.00
1826 2025-05-13 6250.00
1827 2025-05-14 6266.67
2025-05-14 17:51:05,522 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1830 2025-05-14 6266.67 ... 2025-05-14 17:51:05.514448 2025-05-14 17:51:05.514870
[1 rows x 5 columns]
2025-05-14 17:51:05,541 - 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-14 17:51:06,212 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3491 2025-05-10 8510.0
3492 2025-05-11 8510.0
3493 2025-05-12 8610.0
3494 2025-05-13 8564.0
3495 2025-05-14 8680.0
2025-05-14 17:51:06,283 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3495 2025-05-14 8680.0 ... 2025-05-14 17:51:06.275969 2025-05-14 17:51:06.276396
[1 rows x 5 columns]
2025-05-14 17:51:06,304 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-05-14 17:51:06,311 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3491 2025-05-10 8510.0
3492 2025-05-11 8510.0
3493 2025-05-12 8610.0
3494 2025-05-13 8564.0
3495 2025-05-14 8680.0
2025-05-14 17:51:06,381 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3498 2025-05-14 8680.0 ... 2025-05-14 17:51:06.373707 2025-05-14 17:51:06.374122
[1 rows x 5 columns]
2025-05-14 17:51:06,400 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data