=========================================================================
2025-05-21 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-21 17:50:28,430 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3306 2025-05-17 3184.22
3307 2025-05-18 3184.22
3308 2025-05-19 3158.22
3309 2025-05-20 3158.78
3310 2025-05-21 3154.44
2025-05-21 17:50:28,500 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3310 2025-05-21 3154.44 ... 2025-05-21 17:50:28.492838 2025-05-21 17:50:28.493245
[1 rows x 5 columns]
2025-05-21 17:50:28,525 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-05-21 17:50:28,531 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3306 2025-05-17 3184.22
3307 2025-05-18 3184.22
3308 2025-05-19 3158.22
3309 2025-05-20 3158.78
3310 2025-05-21 3154.44
2025-05-21 17:50:28,597 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3313 2025-05-21 3154.44 ... 2025-05-21 17:50:28.590125 2025-05-21 17:50:28.590494
[1 rows x 5 columns]
2025-05-21 17:50:28,617 - 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-21 17:50:29,193 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3527 2025-05-17 2426.25
3528 2025-05-18 2426.25
3529 2025-05-19 2362.50
3530 2025-05-20 2327.50
3531 2025-05-21 2321.25
2025-05-21 17:50:29,262 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3531 2025-05-21 2321.25 ... 2025-05-21 17:50:29.255438 2025-05-21 17:50:29.255844
[1 rows x 5 columns]
2025-05-21 17:50:29,282 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-05-21 17:50:29,288 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3527 2025-05-17 2426.25
3528 2025-05-18 2426.25
3529 2025-05-19 2362.50
3530 2025-05-20 2327.50
3531 2025-05-21 2321.25
2025-05-21 17:50:29,357 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3535 2025-05-21 2321.25 ... 2025-05-21 17:50:29.350269 2025-05-21 17:50:29.350657
[1 rows x 5 columns]
2025-05-21 17:50:29,377 - 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-21 17:50:29,933 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
867 2025-05-17 5007.50
868 2025-05-18 5007.50
869 2025-05-19 4993.75
870 2025-05-20 5001.25
871 2025-05-21 4986.25
2025-05-21 17:50:29,970 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
871 2025-05-21 4986.25 ... 2025-05-21 17:50:29.963170 2025-05-21 17:50:29.963580
[1 rows x 5 columns]
2025-05-21 17:50:29,990 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-05-21 17:50:29,995 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
867 2025-05-17 5007.50
868 2025-05-18 5007.50
869 2025-05-19 4993.75
870 2025-05-20 5001.25
871 2025-05-21 4986.25
2025-05-21 17:50:30,031 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
871 2025-05-21 4986.25 ... 2025-05-21 17:50:30.024376 2025-05-21 17:50:30.024745
[1 rows x 5 columns]
2025-05-21 17:50:30,051 - 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-21 17:50:30,624 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3746 2025-05-17 14658.33
3747 2025-05-18 14658.33
3748 2025-05-19 14758.33
3749 2025-05-20 14708.33
3750 2025-05-21 14558.33
2025-05-21 17:50:30,696 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3750 2025-05-21 ... 2025-05-21 17:50:30.689998
[1 rows x 5 columns]
2025-05-21 17:50:30,717 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-05-21 17:50:30,722 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3746 2025-05-17 14658.33
3747 2025-05-18 14658.33
3748 2025-05-19 14758.33
3749 2025-05-20 14708.33
3750 2025-05-21 14558.33
2025-05-21 17:50:30,795 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3753 2025-05-21 ... 2025-05-21 17:50:30.789216
[1 rows x 5 columns]
2025-05-21 17:50:30,816 - 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-21 17:50:31,324 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3078 2025-05-17 784.44
3079 2025-05-18 784.44
3080 2025-05-19 779.44
3081 2025-05-20 779.78
3082 2025-05-21 781.00
2025-05-21 17:50:31,389 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3082 2025-05-21 781.0 ... 2025-05-21 17:50:31.381741 2025-05-21 17:50:31.382156
[1 rows x 5 columns]
2025-05-21 17:50:31,412 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-05-21 17:50:31,418 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3078 2025-05-17 784.44
3079 2025-05-18 784.44
3080 2025-05-19 779.44
3081 2025-05-20 779.78
3082 2025-05-21 781.00
2025-05-21 17:50:31,484 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3085 2025-05-21 781.0 ... 2025-05-21 17:50:31.477279 2025-05-21 17:50:31.477659
[1 rows x 5 columns]
2025-05-21 17:50:31,510 - 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-21 17:50:31,998 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3281 2025-05-17 1168.0
3282 2025-05-18 1168.0
3283 2025-05-19 1168.0
3284 2025-05-20 1164.0
3285 2025-05-21 1148.0
2025-05-21 17:50:32,066 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3285 2025-05-21 1148.0 ... 2025-05-21 17:50:32.059066 2025-05-21 17:50:32.059456
[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-21 17:50:34,264 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-05-21 17:50:34.256699
21 2013-01-04 ... 2025-05-21 17:50:34.256699
54 2013-02-27 ... 2025-05-21 17:50:34.256699
60 2013-03-07 ... 2025-05-21 17:50:34.256699
61 2013-03-08 ... 2025-05-21 17:50:34.256699
[5 rows x 6 columns]
2025-05-21 17:50:34,434 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3281 2025-05-17 1168.0
3282 2025-05-18 1168.0
3283 2025-05-19 1168.0
3284 2025-05-20 1164.0
3285 2025-05-21 1148.0
2025-05-21 17:50:34,503 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3289 2025-05-21 1148.0 ... 2025-05-21 17:50:34.495706 2025-05-21 17:50:34.496135
[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-21 17:50:36,681 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-05-21 17:50:36.673721
21 2013-01-04 ... 2025-05-21 17:50:36.673721
54 2013-02-27 ... 2025-05-21 17:50:36.673721
60 2013-03-07 ... 2025-05-21 17:50:36.673721
61 2013-03-08 ... 2025-05-21 17:50:36.673721
[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-21 17:50:37,387 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1626 2025-05-17 8270.0
1627 2025-05-18 8270.0
1628 2025-05-19 8224.0
1629 2025-05-20 8220.0
1630 2025-05-21 8130.0
2025-05-21 17:50:37,432 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1630 2025-05-21 8130.0 ... 2025-05-21 17:50:37.425905 2025-05-21 17:50:37.426303
[1 rows x 5 columns]
2025-05-21 17:50:37,453 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-05-21 17:50:37,458 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1626 2025-05-17 8270.0
1627 2025-05-18 8270.0
1628 2025-05-19 8224.0
1629 2025-05-20 8220.0
1630 2025-05-21 8130.0
2025-05-21 17:50:37,504 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1633 2025-05-21 8130.0 ... 2025-05-21 17:50:37.497466 2025-05-21 17:50:37.497860
[1 rows x 5 columns]
2025-05-21 17:50:37,613 - 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-21 17:50:38,136 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3737 2025-05-17 6145.0
3738 2025-05-18 6145.0
3739 2025-05-19 6145.0
3740 2025-05-20 6145.0
3741 2025-05-21 6145.0
2025-05-21 17:50:38,208 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3741 2025-05-21 6145.0 ... 2025-05-21 17:50:38.201730 2025-05-21 17:50:38.202140
[1 rows x 5 columns]
2025-05-21 17:50:38,229 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-05-21 17:50:38,234 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3737 2025-05-17 6145.0
3738 2025-05-18 6145.0
3739 2025-05-19 6145.0
3740 2025-05-20 6145.0
3741 2025-05-21 6145.0
2025-05-21 17:50:38,307 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3745 2025-05-21 6145.0 ... 2025-05-21 17:50:38.300126 2025-05-21 17:50:38.300529
[1 rows x 5 columns]
2025-05-21 17:50:38,327 - 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-21 17:50:38,818 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1627 2025-05-17 13300.0
1628 2025-05-18 13300.0
1629 2025-05-19 13287.5
1630 2025-05-20 13287.5
1631 2025-05-21 13237.5
2025-05-21 17:50:38,864 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1631 2025-05-21 13237.5 ... 2025-05-21 17:50:38.857258 2025-05-21 17:50:38.857638
[1 rows x 5 columns]
2025-05-21 17:50:38,885 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-05-21 17:50:38,890 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1627 2025-05-17 13300.0
1628 2025-05-18 13300.0
1629 2025-05-19 13287.5
1630 2025-05-20 13287.5
1631 2025-05-21 13237.5
2025-05-21 17:50:38,937 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1634 2025-05-21 13237.5 ... 2025-05-21 17:50:38.929701 2025-05-21 17:50:38.930274
[1 rows x 5 columns]
2025-05-21 17:50:38,957 - 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-21 17:50:39,483 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3137 2025-05-17 9378.33
3138 2025-05-18 9378.33
3139 2025-05-19 9475.00
3140 2025-05-20 9520.00
3141 2025-05-21 9541.67
2025-05-21 17:50:39,548 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date value ... created_at updated_at
3141 2025-05-21 9541.67 ... 2025-05-21 17:50:39.541131 2025-05-21 17:50:39.541513
[1 rows x 5 columns]
2025-05-21 17:50:39,569 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-05-21 17:50:39,574 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3137 2025-05-17 9378.33
3138 2025-05-18 9378.33
3139 2025-05-19 9475.00
3140 2025-05-20 9520.00
3141 2025-05-21 9541.67
2025-05-21 17:50:39,640 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date value ... created_at updated_at
3145 2025-05-21 9541.67 ... 2025-05-21 17:50:39.632893 2025-05-21 17:50:39.633275
[1 rows x 5 columns]
2025-05-21 17:50:39,660 - 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-21 17:50:40,324 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3260 2025-05-17 2476.67
3261 2025-05-18 2476.67
3262 2025-05-19 2471.67
3263 2025-05-20 2475.00
3264 2025-05-21 2485.00
2025-05-21 17:50:40,390 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3264 2025-05-21 2485.0 ... 2025-05-21 17:50:40.383343 2025-05-21 17:50:40.383729
[1 rows x 5 columns]
2025-05-21 17:50:40,411 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-05-21 17:50:40,417 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3260 2025-05-17 2476.67
3261 2025-05-18 2476.67
3262 2025-05-19 2471.67
3263 2025-05-20 2475.00
3264 2025-05-21 2485.00
2025-05-21 17:50:40,483 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3268 2025-05-21 2485.0 ... 2025-05-21 17:50:40.476327 2025-05-21 17:50:40.476703
[1 rows x 5 columns]
2025-05-21 17:50:40,504 - 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-21 17:50:40,970 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1464 2025-05-17 1462.5
1465 2025-05-18 1462.5
1466 2025-05-19 1462.5
1467 2025-05-20 1462.5
1468 2025-05-21 1462.5
2025-05-21 17:50:41,014 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1468 2025-05-21 1462.5 ... 2025-05-21 17:50:41.007084 2025-05-21 17:50:41.007462
[1 rows x 5 columns]
2025-05-21 17:50:41,034 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-05-21 17:50:41,039 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1464 2025-05-17 1462.5
1465 2025-05-18 1462.5
1466 2025-05-19 1462.5
1467 2025-05-20 1462.5
1468 2025-05-21 1462.5
2025-05-21 17:50:41,085 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1472 2025-05-21 1462.5 ... 2025-05-21 17:50:41.077303 2025-05-21 17:50:41.077680
[1 rows x 5 columns]
2025-05-21 17:50:41,104 - 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-21 17:50:41,632 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1377 2025-05-17 6727.50
1378 2025-05-18 6727.50
1379 2025-05-19 6701.04
1380 2025-05-20 6687.71
1381 2025-05-21 6660.00
2025-05-21 17:50:41,676 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1381 2025-05-21 6660.0 ... 2025-05-21 17:50:41.668905 2025-05-21 17:50:41.669298
[1 rows x 5 columns]
2025-05-21 17:50:41,697 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-05-21 17:50:41,702 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1377 2025-05-17 6727.50
1378 2025-05-18 6727.50
1379 2025-05-19 6701.04
1380 2025-05-20 6687.71
1381 2025-05-21 6660.00
2025-05-21 17:50:41,746 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1385 2025-05-21 6660.0 ... 2025-05-21 17:50:41.739629 2025-05-21 17:50:41.740039
[1 rows x 5 columns]
2025-05-21 17:50:41,768 - 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-21 17:50:42,311 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3750 2025-05-17 2988.0
3751 2025-05-18 2988.0
3752 2025-05-19 2972.0
3753 2025-05-20 2966.0
3754 2025-05-21 2986.0
2025-05-21 17:50:42,385 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3754 2025-05-21 2986.0 ... 2025-05-21 17:50:42.378117 2025-05-21 17:50:42.378508
[1 rows x 5 columns]
2025-05-21 17:50:42,405 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-05-21 17:50:42,411 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3750 2025-05-17 2988.0
3751 2025-05-18 2988.0
3752 2025-05-19 2972.0
3753 2025-05-20 2966.0
3754 2025-05-21 2986.0
2025-05-21 17:50:42,485 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3757 2025-05-21 2986.0 ... 2025-05-21 17:50:42.477871 2025-05-21 17:50:42.478269
[1 rows x 5 columns]
2025-05-21 17:50:42,505 - 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-21 17:50:43,062 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3520 2025-05-17 8024.0
3521 2025-05-18 8024.0
3522 2025-05-19 8044.0
3523 2025-05-20 8074.0
3524 2025-05-21 8074.0
2025-05-21 17:50:43,133 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3524 2025-05-21 8074.0 ... 2025-05-21 17:50:43.126580 2025-05-21 17:50:43.126994
[1 rows x 5 columns]
2025-05-21 17:50:43,154 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-05-21 17:50:43,160 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3520 2025-05-17 8024.0
3521 2025-05-18 8024.0
3522 2025-05-19 8044.0
3523 2025-05-20 8074.0
3524 2025-05-21 8074.0
2025-05-21 17:50:43,232 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3527 2025-05-21 8074.0 ... 2025-05-21 17:50:43.225448 2025-05-21 17:50:43.225866
[1 rows x 5 columns]
2025-05-21 17:50:43,252 - 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-21 17:50:43,809 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3486 2025-05-17 4255.0
3487 2025-05-18 4255.0
3488 2025-05-19 4255.0
3489 2025-05-20 4255.0
3490 2025-05-21 4255.0
2025-05-21 17:50:43,879 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3490 2025-05-21 4255.0 ... 2025-05-21 17:50:43.871869 2025-05-21 17:50:43.872256
[1 rows x 5 columns]
2025-05-21 17:50:43,899 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-05-21 17:50:43,904 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3486 2025-05-17 4255.0
3487 2025-05-18 4255.0
3488 2025-05-19 4255.0
3489 2025-05-20 4255.0
3490 2025-05-21 4255.0
2025-05-21 17:50:43,975 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3493 2025-05-21 4255.0 ... 2025-05-21 17:50:43.967901 2025-05-21 17:50:43.968289
[1 rows x 5 columns]
2025-05-21 17:50:43,995 - 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-21 17:50:44,539 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2863 2025-05-17 5440.00
2864 2025-05-18 5440.00
2865 2025-05-19 5435.71
2866 2025-05-20 5435.71
2867 2025-05-21 5435.71
2025-05-21 17:50:44,601 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2867 2025-05-21 5435.71 ... 2025-05-21 17:50:44.594232 2025-05-21 17:50:44.594617
[1 rows x 5 columns]
2025-05-21 17:50:44,621 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-05-21 17:50:44,627 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2863 2025-05-17 5440.00
2864 2025-05-18 5440.00
2865 2025-05-19 5435.71
2866 2025-05-20 5435.71
2867 2025-05-21 5435.71
2025-05-21 17:50:44,690 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2871 2025-05-21 5435.71 ... 2025-05-21 17:50:44.683075 2025-05-21 17:50:44.683459
[1 rows x 5 columns]
2025-05-21 17:50:44,710 - 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-21 17:50:45,385 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3063 2025-05-17 3375.0
3064 2025-05-18 3375.0
3065 2025-05-19 3290.0
3066 2025-05-20 3190.0
3067 2025-05-21 3190.0
2025-05-21 17:50:45,449 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3067 2025-05-21 3190.0 ... 2025-05-21 17:50:45.442314 2025-05-21 17:50:45.442695
[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-21 17:50:45,610 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-05-21 17:50:45.602555
458 2015-09-21 ... 2025-05-21 17:50:45.602555
549 2016-02-03 ... 2025-05-21 17:50:45.602555
693 2016-09-05 ... 2025-05-21 17:50:45.602555
696 2016-09-08 ... 2025-05-21 17:50:45.602555
[5 rows x 6 columns]
2025-05-21 17:50:45,642 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3063 2025-05-17 3375.0
3064 2025-05-18 3375.0
3065 2025-05-19 3290.0
3066 2025-05-20 3190.0
3067 2025-05-21 3190.0
2025-05-21 17:50:45,707 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3070 2025-05-21 3190.0 ... 2025-05-21 17:50:45.700245 2025-05-21 17:50:45.700689
[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-21 17:50:45,870 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-05-21 17:50:45.862244
458 2015-09-21 ... 2025-05-21 17:50:45.862244
549 2016-02-03 ... 2025-05-21 17:50:45.862244
693 2016-09-05 ... 2025-05-21 17:50:45.862244
696 2016-09-08 ... 2025-05-21 17:50:45.862244
[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-21 17:50:46,456 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
867 2025-05-17 9480.0
868 2025-05-18 9480.0
869 2025-05-19 9390.0
870 2025-05-20 9290.0
871 2025-05-21 9210.0
2025-05-21 17:50:46,492 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
871 2025-05-21 9210.0 ... 2025-05-21 17:50:46.485316 2025-05-21 17:50:46.485698
[1 rows x 5 columns]
2025-05-21 17:50:46,512 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-05-21 17:50:46,517 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
867 2025-05-17 9480.0
868 2025-05-18 9480.0
869 2025-05-19 9390.0
870 2025-05-20 9290.0
871 2025-05-21 9210.0
2025-05-21 17:50:46,553 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
871 2025-05-21 9210.0 ... 2025-05-21 17:50:46.546216 2025-05-21 17:50:46.546572
[1 rows x 5 columns]
2025-05-21 17:50:46,572 - 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-21 17:50:47,101 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3746 2025-05-17 7566.67
3747 2025-05-18 7566.67
3748 2025-05-19 7583.33
3749 2025-05-20 7591.67
3750 2025-05-21 7583.33
2025-05-21 17:50:47,175 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3750 2025-05-21 7583.33 ... 2025-05-21 17:50:47.167943 2025-05-21 17:50:47.168335
[1 rows x 5 columns]
2025-05-21 17:50:47,195 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-05-21 17:50:47,200 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3746 2025-05-17 7566.67
3747 2025-05-18 7566.67
3748 2025-05-19 7583.33
3749 2025-05-20 7591.67
3750 2025-05-21 7583.33
2025-05-21 17:50:47,275 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3753 2025-05-21 7583.33 ... 2025-05-21 17:50:47.267877 2025-05-21 17:50:47.268299
[1 rows x 5 columns]
2025-05-21 17:50:47,295 - 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-21 17:50:47,833 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3084 2025-05-17 3600.0
3085 2025-05-18 3600.0
3086 2025-05-19 3582.5
3087 2025-05-20 3590.0
3088 2025-05-21 3582.5
2025-05-21 17:50:47,903 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3089 2025-05-21 3582.5 ... 2025-05-21 17:50:47.896033 2025-05-21 17:50:47.896412
[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-21 17:50:47,942 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-05-21 17:50:47.935450
[1 rows x 6 columns]
2025-05-21 17:50:47,968 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3084 2025-05-17 3600.0
3085 2025-05-18 3600.0
3086 2025-05-19 3582.5
3087 2025-05-20 3590.0
3088 2025-05-21 3582.5
2025-05-21 17:50:48,033 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3091 2025-05-21 3582.5 ... 2025-05-21 17:50:48.026128 2025-05-21 17:50:48.026504
[1 rows x 5 columns]
2025-05-21 17:50:48,053 - 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-21 17:50:48,640 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3749 2025-05-17 20290.00
3750 2025-05-18 20290.00
3751 2025-05-19 20290.00
3752 2025-05-20 20226.67
3753 2025-05-21 20226.67
2025-05-21 17:50:48,712 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date ... updated_at
3753 2025-05-21 ... 2025-05-21 17:50:48.705958
[1 rows x 5 columns]
2025-05-21 17:50:48,732 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-05-21 17:50:48,737 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3749 2025-05-17 20290.00
3750 2025-05-18 20290.00
3751 2025-05-19 20290.00
3752 2025-05-20 20226.67
3753 2025-05-21 20226.67
2025-05-21 17:50:48,809 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date ... updated_at
3756 2025-05-21 ... 2025-05-21 17:50:48.803285
[1 rows x 5 columns]
2025-05-21 17:50:48,829 - 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-21 17:50:49,357 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2863 2025-05-17 5698.0
2864 2025-05-18 5698.0
2865 2025-05-19 5664.0
2866 2025-05-20 5656.0
2867 2025-05-21 5636.0
2025-05-21 17:50:49,420 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2867 2025-05-21 5636.0 ... 2025-05-21 17:50:49.413573 2025-05-21 17:50:49.413998
[1 rows x 5 columns]
2025-05-21 17:50:49,441 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-05-21 17:50:49,447 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2863 2025-05-17 5698.0
2864 2025-05-18 5698.0
2865 2025-05-19 5664.0
2866 2025-05-20 5656.0
2867 2025-05-21 5636.0
2025-05-21 17:50:49,510 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2871 2025-05-21 5636.0 ... 2025-05-21 17:50:49.503129 2025-05-21 17:50:49.503522
[1 rows x 5 columns]
2025-05-21 17:50:49,531 - 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-21 17:50:50,115 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2138 2025-05-17 23775.0
2139 2025-05-18 23775.0
2140 2025-05-19 23775.0
2141 2025-05-20 23775.0
2142 2025-05-21 23775.0
2025-05-21 17:50:50,168 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2142 2025-05-21 23775.0 ... 2025-05-21 17:50:50.161444 2025-05-21 17:50:50.161857
[1 rows x 5 columns]
2025-05-21 17:50:50,189 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-05-21 17:50:50,195 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2138 2025-05-17 23775.0
2139 2025-05-18 23775.0
2140 2025-05-19 23775.0
2141 2025-05-20 23775.0
2142 2025-05-21 23775.0
2025-05-21 17:50:50,248 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2146 2025-05-21 23775.0 ... 2025-05-21 17:50:50.241408 2025-05-21 17:50:50.241820
[1 rows x 5 columns]
2025-05-21 17:50:50,269 - 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-21 17:50:50,976 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1653 2025-05-17 1946.67
1654 2025-05-18 1946.67
1655 2025-05-19 1945.00
1656 2025-05-20 1930.00
1657 2025-05-21 1926.00
2025-05-21 17:50:51,033 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1657 2025-05-21 1926.0 ... 2025-05-21 17:50:51.026140 2025-05-21 17:50:51.026526
[1 rows x 5 columns]
2025-05-21 17:50:51,054 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-05-21 17:50:51,060 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1653 2025-05-17 1946.67
1654 2025-05-18 1946.67
1655 2025-05-19 1945.00
1656 2025-05-20 1930.00
1657 2025-05-21 1926.00
2025-05-21 17:50:51,110 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1661 2025-05-21 1926.0 ... 2025-05-21 17:50:51.102056 2025-05-21 17:50:51.102484
[1 rows x 5 columns]
2025-05-21 17:50:51,131 - 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-21 17:50:51,742 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2725 2025-05-17 126258.33
2726 2025-05-18 126258.33
2727 2025-05-19 125083.33
2728 2025-05-20 124775.00
2729 2025-05-21 124658.33
2025-05-21 17:50:51,801 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2729 2025-05-21 ... 2025-05-21 17:50:51.795615
[1 rows x 5 columns]
2025-05-21 17:50:51,823 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-05-21 17:50:51,828 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2725 2025-05-17 126258.33
2726 2025-05-18 126258.33
2727 2025-05-19 125083.33
2728 2025-05-20 124775.00
2729 2025-05-21 124658.33
2025-05-21 17:50:51,888 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2732 2025-05-21 ... 2025-05-21 17:50:51.882160
[1 rows x 5 columns]
2025-05-21 17:50:51,909 - 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-21 17:50:52,490 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3750 2025-05-17 4782.0
3751 2025-05-18 4782.0
3752 2025-05-19 4726.0
3753 2025-05-20 4719.0
3754 2025-05-21 4721.0
2025-05-21 17:50:52,564 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3754 2025-05-21 4721.0 ... 2025-05-21 17:50:52.557124 2025-05-21 17:50:52.557513
[1 rows x 5 columns]
2025-05-21 17:50:52,584 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-05-21 17:50:52,590 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3750 2025-05-17 4782.0
3751 2025-05-18 4782.0
3752 2025-05-19 4726.0
3753 2025-05-20 4719.0
3754 2025-05-21 4721.0
2025-05-21 17:50:52,664 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3757 2025-05-21 4721.0 ... 2025-05-21 17:50:52.657727 2025-05-21 17:50:52.658148
[1 rows x 5 columns]
2025-05-21 17:50:52,685 - 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-21 17:50:53,226 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
2989 2025-05-17 7440.0
2990 2025-05-18 7440.0
2991 2025-05-19 7440.0
2992 2025-05-20 7440.0
2993 2025-05-21 7440.0
2025-05-21 17:50:53,310 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
2993 2025-05-21 7440.0 ... 2025-05-21 17:50:53.301848 2025-05-21 17:50:53.302461
[1 rows x 5 columns]
2025-05-21 17:50:53,331 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-05-21 17:50:53,337 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
2989 2025-05-17 7440.0
2990 2025-05-18 7440.0
2991 2025-05-19 7440.0
2992 2025-05-20 7440.0
2993 2025-05-21 7440.0
2025-05-21 17:50:53,403 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
2996 2025-05-21 7440.0 ... 2025-05-21 17:50:53.396190 2025-05-21 17:50:53.396582
[1 rows x 5 columns]
2025-05-21 17:50:53,424 - 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-21 17:50:54,020 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3751 2025-05-17 14558.17
3752 2025-05-18 14558.17
3753 2025-05-19 14551.17
3754 2025-05-20 14539.17
3755 2025-05-21 14550.83
2025-05-21 17:50:54,094 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date ... updated_at
3755 2025-05-21 ... 2025-05-21 17:50:54.088202
[1 rows x 5 columns]
2025-05-21 17:50:54,115 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-05-21 17:50:54,122 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3751 2025-05-17 14558.17
3752 2025-05-18 14558.17
3753 2025-05-19 14551.17
3754 2025-05-20 14539.17
3755 2025-05-21 14550.83
2025-05-21 17:50:54,196 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date ... updated_at
3759 2025-05-21 ... 2025-05-21 17:50:54.189683
[1 rows x 5 columns]
2025-05-21 17:50:54,217 - 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-21 17:50:54,768 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3696 2025-05-17 16847.50
3697 2025-05-18 16847.50
3698 2025-05-19 16825.00
3699 2025-05-20 16750.00
3700 2025-05-21 16831.25
2025-05-21 17:50:54,840 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date ... updated_at
3700 2025-05-21 ... 2025-05-21 17:50:54.834624
[1 rows x 5 columns]
2025-05-21 17:50:54,874 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-05-21 17:50:54,880 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3696 2025-05-17 16847.50
3697 2025-05-18 16847.50
3698 2025-05-19 16825.00
3699 2025-05-20 16750.00
3700 2025-05-21 16831.25
2025-05-21 17:50:54,953 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date ... updated_at
3703 2025-05-21 ... 2025-05-21 17:50:54.946798
[1 rows x 5 columns]
2025-05-21 17:50:54,973 - 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-21 17:50:55,502 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
2971 2025-05-17 3310.00
2972 2025-05-18 3310.00
2973 2025-05-19 3290.00
2974 2025-05-20 3290.00
2975 2025-05-21 3286.67
2025-05-21 17:50:55,639 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
2975 2025-05-21 3286.67 ... 2025-05-21 17:50:55.632443 2025-05-21 17:50:55.632858
[1 rows x 5 columns]
2025-05-21 17:50:55,660 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-05-21 17:50:55,666 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
2971 2025-05-17 3310.00
2972 2025-05-18 3310.00
2973 2025-05-19 3290.00
2974 2025-05-20 3290.00
2975 2025-05-21 3286.67
2025-05-21 17:50:55,730 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
2978 2025-05-21 3286.67 ... 2025-05-21 17:50:55.723179 2025-05-21 17:50:55.723562
[1 rows x 5 columns]
2025-05-21 17:50:55,751 - 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-21 17:50:56,302 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3251 2025-05-17 5445.0
3252 2025-05-18 5445.0
3253 2025-05-19 5462.5
3254 2025-05-20 5462.5
3255 2025-05-21 5437.5
2025-05-21 17:50:56,369 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3255 2025-05-21 5437.5 ... 2025-05-21 17:50:56.362457 2025-05-21 17:50:56.362912
[1 rows x 5 columns]
2025-05-21 17:50:56,390 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-05-21 17:50:56,396 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3251 2025-05-17 5445.0
3252 2025-05-18 5445.0
3253 2025-05-19 5462.5
3254 2025-05-20 5462.5
3255 2025-05-21 5437.5
2025-05-21 17:50:56,469 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3742 2025-05-21 5437.5 ... 2025-05-21 17:50:56.462747 2025-05-21 17:50:56.463154
[1 rows x 5 columns]
2025-05-21 17:50:56,491 - 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-21 17:50:57,000 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1315 2025-05-17 14650.0
1316 2025-05-18 14650.0
1317 2025-05-19 14620.0
1318 2025-05-20 14600.0
1319 2025-05-21 14570.0
2025-05-21 17:50:57,043 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1319 2025-05-21 14570.0 ... 2025-05-21 17:50:57.036494 2025-05-21 17:50:57.036905
[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-21 17:50:57,304 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-05-21 17:50:57.296412
117 2021-07-06 ... 2025-05-21 17:50:57.296412
121 2021-07-12 ... 2025-05-21 17:50:57.296412
122 2021-07-13 ... 2025-05-21 17:50:57.296412
194 2021-11-01 ... 2025-05-21 17:50:57.296412
[5 rows x 6 columns]
2025-05-21 17:50:57,343 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1315 2025-05-17 14650.0
1316 2025-05-18 14650.0
1317 2025-05-19 14620.0
1318 2025-05-20 14600.0
1319 2025-05-21 14570.0
2025-05-21 17:50:57,386 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1322 2025-05-21 14570.0 ... 2025-05-21 17:50:57.379232 2025-05-21 17:50:57.379655
[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-21 17:50:57,647 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-05-21 17:50:57.639646
117 2021-07-06 ... 2025-05-21 17:50:57.639646
121 2021-07-12 ... 2025-05-21 17:50:57.639646
122 2021-07-13 ... 2025-05-21 17:50:57.639646
194 2021-11-01 ... 2025-05-21 17:50:57.639646
[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-21 17:50:58,851 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3747 2025-05-17 78818.33
3748 2025-05-18 78818.33
3749 2025-05-19 78113.33
3750 2025-05-20 78343.33
3751 2025-05-21 78493.33
2025-05-21 17:50:58,923 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date ... updated_at
3751 2025-05-21 ... 2025-05-21 17:50:58.917090
[1 rows x 5 columns]
2025-05-21 17:50:58,944 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-05-21 17:50:58,950 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3747 2025-05-17 78818.33
3748 2025-05-18 78818.33
3749 2025-05-19 78113.33
3750 2025-05-20 78343.33
3751 2025-05-21 78493.33
2025-05-21 17:50:59,023 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date ... updated_at
3754 2025-05-21 ... 2025-05-21 17:50:59.016816
[1 rows x 5 columns]
2025-05-21 17:50:59,043 - 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-21 17:50:59,537 - 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-21 17:50:59,593 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-05-21 17:50:59,593 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-05-21 17:50:59,598 - 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-21 17:50:59,661 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-05-21 17:50:59,661 - 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-21 17:51:00,372 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2725 2025-05-17 265487.5
2726 2025-05-18 265487.5
2727 2025-05-19 265187.5
2728 2025-05-20 265187.5
2729 2025-05-21 268212.5
2025-05-21 17:51:00,432 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2729 2025-05-21 ... 2025-05-21 17:51:00.426268
[1 rows x 5 columns]
2025-05-21 17:51:00,452 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-05-21 17:51:00,458 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2725 2025-05-17 265487.5
2726 2025-05-18 265487.5
2727 2025-05-19 265187.5
2728 2025-05-20 265187.5
2729 2025-05-21 268212.5
2025-05-21 17:51:00,518 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2732 2025-05-21 ... 2025-05-21 17:51:00.512387
[1 rows x 5 columns]
2025-05-21 17:51:00,538 - 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-21 17:51:01,510 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3746 2025-05-17 22746.0
3747 2025-05-18 22746.0
3748 2025-05-19 22590.0
3749 2025-05-20 22574.0
3750 2025-05-21 22744.0
2025-05-21 17:51:01,586 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3750 2025-05-21 22744.0 ... 2025-05-21 17:51:01.578870 2025-05-21 17:51:01.579264
[1 rows x 5 columns]
2025-05-21 17:51:01,607 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-05-21 17:51:01,613 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3746 2025-05-17 22746.0
3747 2025-05-18 22746.0
3748 2025-05-19 22590.0
3749 2025-05-20 22574.0
3750 2025-05-21 22744.0
2025-05-21 17:51:01,687 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3753 2025-05-21 22744.0 ... 2025-05-21 17:51:01.680207 2025-05-21 17:51:01.680588
[1 rows x 5 columns]
2025-05-21 17:51:01,708 - 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-21 17:51:02,404 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3709 2025-05-17 3372.5
3710 2025-05-18 3372.5
3711 2025-05-19 3347.5
3712 2025-05-20 3347.5
3713 2025-05-21 3335.0
2025-05-21 17:51:02,478 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3713 2025-05-21 3335.0 ... 2025-05-21 17:51:02.470797 2025-05-21 17:51:02.471189
[1 rows x 5 columns]
2025-05-21 17:51:02,499 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-05-21 17:51:02,505 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3709 2025-05-17 3372.5
3710 2025-05-18 3372.5
3711 2025-05-19 3347.5
3712 2025-05-20 3347.5
3713 2025-05-21 3335.0
2025-05-21 17:51:02,579 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3716 2025-05-21 3335.0 ... 2025-05-21 17:51:02.572319 2025-05-21 17:51:02.572704
[1 rows x 5 columns]
2025-05-21 17:51:02,600 - 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-21 17:51:03,134 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1506 2025-05-17 4780.0
1507 2025-05-18 4780.0
1508 2025-05-19 4740.0
1509 2025-05-20 4702.5
1510 2025-05-21 4715.0
2025-05-21 17:51:03,179 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1510 2025-05-21 4715.0 ... 2025-05-21 17:51:03.172169 2025-05-21 17:51:03.172545
[1 rows x 5 columns]
2025-05-21 17:51:03,199 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-05-21 17:51:03,204 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1506 2025-05-17 4780.0
1507 2025-05-18 4780.0
1508 2025-05-19 4740.0
1509 2025-05-20 4702.5
1510 2025-05-21 4715.0
2025-05-21 17:51:03,250 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1513 2025-05-21 4715.0 ... 2025-05-21 17:51:03.243167 2025-05-21 17:51:03.243538
[1 rows x 5 columns]
2025-05-21 17:51:03,270 - 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-21 17:51:03,811 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2780 2025-05-17 2304.29
2781 2025-05-18 2304.29
2782 2025-05-19 2301.43
2783 2025-05-20 2301.43
2784 2025-05-21 2298.57
2025-05-21 17:51:03,871 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2784 2025-05-21 2298.57 ... 2025-05-21 17:51:03.864813 2025-05-21 17:51:03.865206
[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-21 17:51:03,914 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2783 2025-05-20 ... 2025-05-21 17:51:03.907487
[1 rows x 6 columns]
2025-05-21 17:51:03,940 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2780 2025-05-17 2304.29
2781 2025-05-18 2304.29
2782 2025-05-19 2301.43
2783 2025-05-20 2301.43
2784 2025-05-21 2298.57
2025-05-21 17:51:04,002 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2787 2025-05-21 2298.57 ... 2025-05-21 17:51:03.995184 2025-05-21 17:51:03.995561
[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-21 17:51:04,046 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2786 2025-05-20 ... 2025-05-21 17:51:04.038715
[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-21 17:51:04,575 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2780 2025-05-17 2304.29
2781 2025-05-18 2304.29
2782 2025-05-19 2301.43
2783 2025-05-20 2301.43
2784 2025-05-21 2922.00
2025-05-21 17:51:04,627 - 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-21 17:51:04,651 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2784 2025-05-21 ... 2025-05-21 17:51:04.644169
[1 rows x 6 columns]
2025-05-21 17:51:04,676 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2780 2025-05-17 2304.29
2781 2025-05-18 2304.29
2782 2025-05-19 2301.43
2783 2025-05-20 2301.43
2784 2025-05-21 2922.00
2025-05-21 17:51:04,730 - 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-21 17:51:04,754 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2787 2025-05-21 ... 2025-05-21 17:51:04.747053
[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-21 17:51:05,251 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3137 2025-05-17 9378.33
3138 2025-05-18 9378.33
3139 2025-05-19 9475.00
3140 2025-05-20 9520.00
3141 2025-05-21 9541.67
2025-05-21 17:51:05,308 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-05-21 17:51:05,308 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-05-21 17:51:05,314 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3137 2025-05-17 9378.33
3138 2025-05-18 9378.33
3139 2025-05-19 9475.00
3140 2025-05-20 9520.00
3141 2025-05-21 9541.67
2025-05-21 17:51:05,371 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-05-21 17:51:05,372 - 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-21 17:51:06,738 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1821 2025-05-17 4551.67
1822 2025-05-18 4551.67
1823 2025-05-19 4560.00
1824 2025-05-20 4540.00
1825 2025-05-21 4543.33
2025-05-21 17:51:06,787 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1825 2025-05-21 4543.33 ... 2025-05-21 17:51:06.779953 2025-05-21 17:51:06.780341
[1 rows x 5 columns]
2025-05-21 17:51:06,807 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-05-21 17:51:06,812 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1821 2025-05-17 4551.67
1822 2025-05-18 4551.67
1823 2025-05-19 4560.00
1824 2025-05-20 4540.00
1825 2025-05-21 4543.33
2025-05-21 17:51:06,862 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1828 2025-05-21 4543.33 ... 2025-05-21 17:51:06.855013 2025-05-21 17:51:06.855394
[1 rows x 5 columns]
2025-05-21 17:51:06,882 - 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-21 17:51:07,406 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1830 2025-05-17 6300.0
1831 2025-05-18 6300.0
1832 2025-05-19 6300.0
1833 2025-05-20 6300.0
1834 2025-05-21 6300.0
2025-05-21 17:51:07,455 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1834 2025-05-21 6300.0 ... 2025-05-21 17:51:07.448609 2025-05-21 17:51:07.449051
[1 rows x 5 columns]
2025-05-21 17:51:07,476 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-05-21 17:51:07,481 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1830 2025-05-17 6300.0
1831 2025-05-18 6300.0
1832 2025-05-19 6300.0
1833 2025-05-20 6300.0
1834 2025-05-21 6300.0
2025-05-21 17:51:07,530 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1837 2025-05-21 6300.0 ... 2025-05-21 17:51:07.523171 2025-05-21 17:51:07.523544
[1 rows x 5 columns]
2025-05-21 17:51:07,550 - 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-21 17:51:08,085 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3498 2025-05-17 8492.0
3499 2025-05-18 8492.0
3500 2025-05-19 8542.0
3501 2025-05-20 8636.0
3502 2025-05-21 8584.0
2025-05-21 17:51:08,157 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3502 2025-05-21 8584.0 ... 2025-05-21 17:51:08.149963 2025-05-21 17:51:08.150350
[1 rows x 5 columns]
2025-05-21 17:51:08,178 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-05-21 17:51:08,184 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3498 2025-05-17 8492.0
3499 2025-05-18 8492.0
3500 2025-05-19 8542.0
3501 2025-05-20 8636.0
3502 2025-05-21 8584.0
2025-05-21 17:51:08,254 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3505 2025-05-21 8584.0 ... 2025-05-21 17:51:08.247703 2025-05-21 17:51:08.248118
[1 rows x 5 columns]
2025-05-21 17:51:08,275 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data