=========================================================================
2025-05-15 17:50:26 Thu 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-15 17:50:28,442 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3300 2025-05-11 3141.44
3301 2025-05-12 3160.33
3302 2025-05-13 3164.78
3303 2025-05-14 3191.78
3304 2025-05-15 3189.89
2025-05-15 17:50:28,511 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3304 2025-05-15 3189.89 ... 2025-05-15 17:50:28.504054 2025-05-15 17:50:28.504463
[1 rows x 5 columns]
2025-05-15 17:50:28,533 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-05-15 17:50:28,538 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3300 2025-05-11 3141.44
3301 2025-05-12 3160.33
3302 2025-05-13 3164.78
3303 2025-05-14 3191.78
3304 2025-05-15 3189.89
2025-05-15 17:50:28,603 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3307 2025-05-15 3189.89 ... 2025-05-15 17:50:28.596013 2025-05-15 17:50:28.596397
[1 rows x 5 columns]
2025-05-15 17:50:28,623 - 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-15 17:50:29,486 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3521 2025-05-11 2402.50
3522 2025-05-12 2402.50
3523 2025-05-13 2453.75
3524 2025-05-14 2521.25
3525 2025-05-15 2426.25
2025-05-15 17:50:29,553 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3525 2025-05-15 2426.25 ... 2025-05-15 17:50:29.546595 2025-05-15 17:50:29.547
[1 rows x 5 columns]
2025-05-15 17:50:29,574 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-05-15 17:50:29,579 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3521 2025-05-11 2402.50
3522 2025-05-12 2402.50
3523 2025-05-13 2453.75
3524 2025-05-14 2521.25
3525 2025-05-15 2426.25
2025-05-15 17:50:29,646 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3529 2025-05-15 2426.25 ... 2025-05-15 17:50:29.639039 2025-05-15 17:50:29.639410
[1 rows x 5 columns]
2025-05-15 17:50:29,666 - 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-15 17:50:31,433 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
861 2025-05-11 4750.84
862 2025-05-12 4888.33
863 2025-05-13 4913.34
864 2025-05-14 4913.34
865 2025-05-15 4991.66
2025-05-15 17:50:31,469 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
865 2025-05-15 4991.66 ... 2025-05-15 17:50:31.462365 2025-05-15 17:50:31.462744
[1 rows x 5 columns]
2025-05-15 17:50:31,489 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-05-15 17:50:31,494 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
861 2025-05-11 4750.84
862 2025-05-12 4888.33
863 2025-05-13 4913.34
864 2025-05-14 4913.34
865 2025-05-15 4991.66
2025-05-15 17:50:31,529 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
865 2025-05-15 4991.66 ... 2025-05-15 17:50:31.522604 2025-05-15 17:50:31.522995
[1 rows x 5 columns]
2025-05-15 17:50:31,549 - 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-15 17:50:32,068 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3740 2025-05-11 14408.33
3741 2025-05-12 14738.33
3742 2025-05-13 14748.33
3743 2025-05-14 14983.33
3744 2025-05-15 14838.33
2025-05-15 17:50:32,140 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3744 2025-05-15 ... 2025-05-15 17:50:32.134100
[1 rows x 5 columns]
2025-05-15 17:50:32,159 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-05-15 17:50:32,165 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3740 2025-05-11 14408.33
3741 2025-05-12 14738.33
3742 2025-05-13 14748.33
3743 2025-05-14 14983.33
3744 2025-05-15 14838.33
2025-05-15 17:50:32,235 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3747 2025-05-15 ... 2025-05-15 17:50:32.229050
[1 rows x 5 columns]
2025-05-15 17:50:32,254 - 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-15 17:50:32,806 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3072 2025-05-11 770.89
3073 2025-05-12 777.22
3074 2025-05-13 786.22
3075 2025-05-14 793.33
3076 2025-05-15 794.44
2025-05-15 17:50:32,870 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3076 2025-05-15 794.44 ... 2025-05-15 17:50:32.863196 2025-05-15 17:50:32.863575
[1 rows x 5 columns]
2025-05-15 17:50:32,890 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-05-15 17:50:32,896 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3072 2025-05-11 770.89
3073 2025-05-12 777.22
3074 2025-05-13 786.22
3075 2025-05-14 793.33
3076 2025-05-15 794.44
2025-05-15 17:50:32,959 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3079 2025-05-15 794.44 ... 2025-05-15 17:50:32.952092 2025-05-15 17:50:32.952475
[1 rows x 5 columns]
2025-05-15 17:50:32,978 - 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-15 17:50:33,469 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3275 2025-05-11 1210.4
3276 2025-05-12 1210.4
3277 2025-05-13 1210.4
3278 2025-05-14 1196.0
3279 2025-05-15 1188.0
2025-05-15 17:50:33,534 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3279 2025-05-15 1188.0 ... 2025-05-15 17:50:33.527332 2025-05-15 17:50:33.527713
[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-15 17:50:35,588 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-05-15 17:50:35.580673
21 2013-01-04 ... 2025-05-15 17:50:35.580673
54 2013-02-27 ... 2025-05-15 17:50:35.580673
60 2013-03-07 ... 2025-05-15 17:50:35.580673
61 2013-03-08 ... 2025-05-15 17:50:35.580673
[5 rows x 6 columns]
2025-05-15 17:50:35,763 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3275 2025-05-11 1210.4
3276 2025-05-12 1210.4
3277 2025-05-13 1210.4
3278 2025-05-14 1196.0
3279 2025-05-15 1188.0
2025-05-15 17:50:35,831 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3283 2025-05-15 1188.0 ... 2025-05-15 17:50:35.824155 2025-05-15 17:50:35.824540
[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-15 17:50:37,884 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-05-15 17:50:37.876801
21 2013-01-04 ... 2025-05-15 17:50:37.876801
54 2013-02-27 ... 2025-05-15 17:50:37.876801
60 2013-03-07 ... 2025-05-15 17:50:37.876801
61 2013-03-08 ... 2025-05-15 17:50:37.876801
[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-15 17:50:38,584 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1620 2025-05-11 7680.0
1621 2025-05-12 7676.0
1622 2025-05-13 7720.0
1623 2025-05-14 7890.0
1624 2025-05-15 8270.0
2025-05-15 17:50:38,631 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1624 2025-05-15 8270.0 ... 2025-05-15 17:50:38.624214 2025-05-15 17:50:38.624596
[1 rows x 5 columns]
2025-05-15 17:50:38,652 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-05-15 17:50:38,657 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1620 2025-05-11 7680.0
1621 2025-05-12 7676.0
1622 2025-05-13 7720.0
1623 2025-05-14 7890.0
1624 2025-05-15 8270.0
2025-05-15 17:50:38,702 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1627 2025-05-15 8270.0 ... 2025-05-15 17:50:38.695705 2025-05-15 17:50:38.696108
[1 rows x 5 columns]
2025-05-15 17:50:38,722 - 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-15 17:50:39,236 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3731 2025-05-11 6135.0
3732 2025-05-12 6150.0
3733 2025-05-13 6145.0
3734 2025-05-14 6145.0
3735 2025-05-15 6145.0
2025-05-15 17:50:39,309 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3735 2025-05-15 6145.0 ... 2025-05-15 17:50:39.302199 2025-05-15 17:50:39.302586
[1 rows x 5 columns]
2025-05-15 17:50:39,329 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-05-15 17:50:39,335 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3731 2025-05-11 6135.0
3732 2025-05-12 6150.0
3733 2025-05-13 6145.0
3734 2025-05-14 6145.0
3735 2025-05-15 6145.0
2025-05-15 17:50:39,408 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3739 2025-05-15 6145.0 ... 2025-05-15 17:50:39.401169 2025-05-15 17:50:39.401548
[1 rows x 5 columns]
2025-05-15 17:50:39,427 - 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-15 17:50:39,924 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1621 2025-05-11 13042.5
1622 2025-05-12 13130.0
1623 2025-05-13 13130.0
1624 2025-05-14 13255.0
1625 2025-05-15 13255.0
2025-05-15 17:50:39,969 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1625 2025-05-15 13255.0 ... 2025-05-15 17:50:39.962598 2025-05-15 17:50:39.963013
[1 rows x 5 columns]
2025-05-15 17:50:39,989 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-05-15 17:50:39,994 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1621 2025-05-11 13042.5
1622 2025-05-12 13130.0
1623 2025-05-13 13130.0
1624 2025-05-14 13255.0
1625 2025-05-15 13255.0
2025-05-15 17:50:40,043 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1628 2025-05-15 13255.0 ... 2025-05-15 17:50:40.036041 2025-05-15 17:50:40.036425
[1 rows x 5 columns]
2025-05-15 17:50:40,063 - 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-15 17:50:40,628 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3131 2025-05-11 9463.33
3132 2025-05-12 9446.67
3133 2025-05-13 9468.33
3134 2025-05-14 9543.33
3135 2025-05-15 9395.00
2025-05-15 17:50:40,691 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date value ... created_at updated_at
3135 2025-05-15 9395.0 ... 2025-05-15 17:50:40.684618 2025-05-15 17:50:40.685032
[1 rows x 5 columns]
2025-05-15 17:50:40,710 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-05-15 17:50:40,716 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3131 2025-05-11 9463.33
3132 2025-05-12 9446.67
3133 2025-05-13 9468.33
3134 2025-05-14 9543.33
3135 2025-05-15 9395.00
2025-05-15 17:50:40,781 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date value ... created_at updated_at
3139 2025-05-15 9395.0 ... 2025-05-15 17:50:40.773643 2025-05-15 17:50:40.774057
[1 rows x 5 columns]
2025-05-15 17:50:40,800 - 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-15 17:50:41,439 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3254 2025-05-11 2506.67
3255 2025-05-12 2490.00
3256 2025-05-13 2476.67
3257 2025-05-14 2460.00
3258 2025-05-15 2476.67
2025-05-15 17:50:41,504 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3258 2025-05-15 2476.67 ... 2025-05-15 17:50:41.497287 2025-05-15 17:50:41.497673
[1 rows x 5 columns]
2025-05-15 17:50:41,524 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-05-15 17:50:41,529 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3254 2025-05-11 2506.67
3255 2025-05-12 2490.00
3256 2025-05-13 2476.67
3257 2025-05-14 2460.00
3258 2025-05-15 2476.67
2025-05-15 17:50:41,594 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3262 2025-05-15 2476.67 ... 2025-05-15 17:50:41.587299 2025-05-15 17:50:41.587667
[1 rows x 5 columns]
2025-05-15 17:50:41,614 - 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-15 17:50:42,080 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1458 2025-05-11 1462.5
1459 2025-05-12 1462.5
1460 2025-05-13 1462.5
1461 2025-05-14 1462.5
1462 2025-05-15 1462.5
2025-05-15 17:50:42,125 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1462 2025-05-15 1462.5 ... 2025-05-15 17:50:42.117551 2025-05-15 17:50:42.117978
[1 rows x 5 columns]
2025-05-15 17:50:42,144 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-05-15 17:50:42,150 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1458 2025-05-11 1462.5
1459 2025-05-12 1462.5
1460 2025-05-13 1462.5
1461 2025-05-14 1462.5
1462 2025-05-15 1462.5
2025-05-15 17:50:42,195 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1466 2025-05-15 1462.5 ... 2025-05-15 17:50:42.188238 2025-05-15 17:50:42.188641
[1 rows x 5 columns]
2025-05-15 17:50:42,214 - 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-15 17:50:42,750 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1371 2025-05-11 6377.92
1372 2025-05-12 6411.79
1373 2025-05-13 6535.29
1374 2025-05-14 6618.33
1375 2025-05-15 6688.96
2025-05-15 17:50:42,793 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1375 2025-05-15 6688.96 ... 2025-05-15 17:50:42.786045 2025-05-15 17:50:42.786429
[1 rows x 5 columns]
2025-05-15 17:50:42,813 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-05-15 17:50:42,818 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1371 2025-05-11 6377.92
1372 2025-05-12 6411.79
1373 2025-05-13 6535.29
1374 2025-05-14 6618.33
1375 2025-05-15 6688.96
2025-05-15 17:50:42,860 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1379 2025-05-15 6688.96 ... 2025-05-15 17:50:42.853721 2025-05-15 17:50:42.854130
[1 rows x 5 columns]
2025-05-15 17:50:42,879 - 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-15 17:50:44,138 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3744 2025-05-11 3300.0
3745 2025-05-12 3138.0
3746 2025-05-13 3116.0
3747 2025-05-14 3084.0
3748 2025-05-15 3074.0
2025-05-15 17:50:44,209 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3748 2025-05-15 3074.0 ... 2025-05-15 17:50:44.202503 2025-05-15 17:50:44.202906
[1 rows x 5 columns]
2025-05-15 17:50:44,229 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-05-15 17:50:44,234 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3744 2025-05-11 3300.0
3745 2025-05-12 3138.0
3746 2025-05-13 3116.0
3747 2025-05-14 3084.0
3748 2025-05-15 3074.0
2025-05-15 17:50:44,306 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3751 2025-05-15 3074.0 ... 2025-05-15 17:50:44.298743 2025-05-15 17:50:44.299148
[1 rows x 5 columns]
2025-05-15 17:50:44,325 - 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-15 17:50:45,522 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3514 2025-05-11 8076.0
3515 2025-05-12 8094.0
3516 2025-05-13 8076.0
3517 2025-05-14 8174.0
3518 2025-05-15 8054.0
2025-05-15 17:50:45,591 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3518 2025-05-15 8054.0 ... 2025-05-15 17:50:45.583846 2025-05-15 17:50:45.584262
[1 rows x 5 columns]
2025-05-15 17:50:45,610 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-05-15 17:50:45,616 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3514 2025-05-11 8076.0
3515 2025-05-12 8094.0
3516 2025-05-13 8076.0
3517 2025-05-14 8174.0
3518 2025-05-15 8054.0
2025-05-15 17:50:45,686 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3521 2025-05-15 8054.0 ... 2025-05-15 17:50:45.679354 2025-05-15 17:50:45.679731
[1 rows x 5 columns]
2025-05-15 17:50:45,706 - 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-15 17:50:46,258 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3480 2025-05-11 4245.0
3481 2025-05-12 4255.0
3482 2025-05-13 4255.0
3483 2025-05-14 4255.0
3484 2025-05-15 4255.0
2025-05-15 17:50:46,328 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3484 2025-05-15 4255.0 ... 2025-05-15 17:50:46.321101 2025-05-15 17:50:46.321485
[1 rows x 5 columns]
2025-05-15 17:50:46,347 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-05-15 17:50:46,354 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3480 2025-05-11 4245.0
3481 2025-05-12 4255.0
3482 2025-05-13 4255.0
3483 2025-05-14 4255.0
3484 2025-05-15 4255.0
2025-05-15 17:50:46,424 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3487 2025-05-15 4255.0 ... 2025-05-15 17:50:46.416426 2025-05-15 17:50:46.416831
[1 rows x 5 columns]
2025-05-15 17:50:46,444 - 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-15 17:50:47,019 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2857 2025-05-11 5402.86
2858 2025-05-12 5424.29
2859 2025-05-13 5424.29
2860 2025-05-14 5424.29
2861 2025-05-15 5424.29
2025-05-15 17:50:47,082 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2861 2025-05-15 5424.29 ... 2025-05-15 17:50:47.075241 2025-05-15 17:50:47.075623
[1 rows x 5 columns]
2025-05-15 17:50:47,102 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-05-15 17:50:47,107 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2857 2025-05-11 5402.86
2858 2025-05-12 5424.29
2859 2025-05-13 5424.29
2860 2025-05-14 5424.29
2861 2025-05-15 5424.29
2025-05-15 17:50:47,168 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2865 2025-05-15 5424.29 ... 2025-05-15 17:50:47.161222 2025-05-15 17:50:47.161598
[1 rows x 5 columns]
2025-05-15 17:50:47,187 - 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-15 17:50:48,889 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3057 2025-05-11 3225.0
3058 2025-05-12 3310.0
3059 2025-05-13 3365.0
3060 2025-05-14 3375.0
3061 2025-05-15 3375.0
2025-05-15 17:50:48,951 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3061 2025-05-15 3375.0 ... 2025-05-15 17:50:48.944641 2025-05-15 17:50:48.945076
[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-15 17:50:49,104 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-05-15 17:50:49.097049
458 2015-09-21 ... 2025-05-15 17:50:49.097049
549 2016-02-03 ... 2025-05-15 17:50:49.097049
693 2016-09-05 ... 2025-05-15 17:50:49.097049
696 2016-09-08 ... 2025-05-15 17:50:49.097049
[5 rows x 6 columns]
2025-05-15 17:50:49,137 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3057 2025-05-11 3225.0
3058 2025-05-12 3310.0
3059 2025-05-13 3365.0
3060 2025-05-14 3375.0
3061 2025-05-15 3375.0
2025-05-15 17:50:49,200 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3064 2025-05-15 3375.0 ... 2025-05-15 17:50:49.193450 2025-05-15 17:50:49.193853
[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-15 17:50:49,352 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-05-15 17:50:49.345119
458 2015-09-21 ... 2025-05-15 17:50:49.345119
549 2016-02-03 ... 2025-05-15 17:50:49.345119
693 2016-09-05 ... 2025-05-15 17:50:49.345119
696 2016-09-08 ... 2025-05-15 17:50:49.345119
[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-15 17:50:50,078 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
861 2025-05-11 9640.0
862 2025-05-12 9610.0
863 2025-05-13 9610.0
864 2025-05-14 9610.0
865 2025-05-15 9520.0
2025-05-15 17:50:50,113 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
865 2025-05-15 9520.0 ... 2025-05-15 17:50:50.106629 2025-05-15 17:50:50.107035
[1 rows x 5 columns]
2025-05-15 17:50:50,133 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-05-15 17:50:50,138 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
861 2025-05-11 9640.0
862 2025-05-12 9610.0
863 2025-05-13 9610.0
864 2025-05-14 9610.0
865 2025-05-15 9520.0
2025-05-15 17:50:50,172 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
865 2025-05-15 9520.0 ... 2025-05-15 17:50:50.165834 2025-05-15 17:50:50.166202
[1 rows x 5 columns]
2025-05-15 17:50:50,191 - 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-15 17:50:50,765 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3740 2025-05-11 7458.33
3741 2025-05-12 7428.33
3742 2025-05-13 7445.00
3743 2025-05-14 7508.33
3744 2025-05-15 7558.33
2025-05-15 17:50:50,835 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3744 2025-05-15 7558.33 ... 2025-05-15 17:50:50.828875 2025-05-15 17:50:50.829258
[1 rows x 5 columns]
2025-05-15 17:50:50,854 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-05-15 17:50:50,860 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3740 2025-05-11 7458.33
3741 2025-05-12 7428.33
3742 2025-05-13 7445.00
3743 2025-05-14 7508.33
3744 2025-05-15 7558.33
2025-05-15 17:50:50,931 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3747 2025-05-15 7558.33 ... 2025-05-15 17:50:50.924171 2025-05-15 17:50:50.924535
[1 rows x 5 columns]
2025-05-15 17:50:50,950 - 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-15 17:50:52,835 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3078 2025-05-11 3585.0
3079 2025-05-12 3585.0
3080 2025-05-13 3595.0
3081 2025-05-14 3595.0
3082 2025-05-15 3602.5
2025-05-15 17:50:52,899 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3083 2025-05-15 3602.5 ... 2025-05-15 17:50:52.892275 2025-05-15 17:50:52.892658
[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-15 17:50:52,936 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-05-15 17:50:52.928972
[1 rows x 6 columns]
2025-05-15 17:50:52,960 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3078 2025-05-11 3585.0
3079 2025-05-12 3585.0
3080 2025-05-13 3595.0
3081 2025-05-14 3595.0
3082 2025-05-15 3602.5
2025-05-15 17:50:53,025 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3085 2025-05-15 3602.5 ... 2025-05-15 17:50:53.018104 2025-05-15 17:50:53.018476
[1 rows x 5 columns]
2025-05-15 17:50:53,045 - 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-15 17:50:53,585 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3743 2025-05-11 19626.67
3744 2025-05-12 19830.00
3745 2025-05-13 20033.33
3746 2025-05-14 20033.33
3747 2025-05-15 20226.67
2025-05-15 17:50:53,655 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date ... updated_at
3747 2025-05-15 ... 2025-05-15 17:50:53.649456
[1 rows x 5 columns]
2025-05-15 17:50:53,676 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-05-15 17:50:53,682 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3743 2025-05-11 19626.67
3744 2025-05-12 19830.00
3745 2025-05-13 20033.33
3746 2025-05-14 20033.33
3747 2025-05-15 20226.67
2025-05-15 17:50:53,753 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date ... updated_at
3750 2025-05-15 ... 2025-05-15 17:50:53.747415
[1 rows x 5 columns]
2025-05-15 17:50:53,773 - 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-15 17:50:54,286 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2857 2025-05-11 5634.0
2858 2025-05-12 5676.0
2859 2025-05-13 5676.0
2860 2025-05-14 5692.0
2861 2025-05-15 5706.0
2025-05-15 17:50:54,347 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2861 2025-05-15 5706.0 ... 2025-05-15 17:50:54.340354 2025-05-15 17:50:54.340738
[1 rows x 5 columns]
2025-05-15 17:50:54,367 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-05-15 17:50:54,373 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2857 2025-05-11 5634.0
2858 2025-05-12 5676.0
2859 2025-05-13 5676.0
2860 2025-05-14 5692.0
2861 2025-05-15 5706.0
2025-05-15 17:50:54,436 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2865 2025-05-15 5706.0 ... 2025-05-15 17:50:54.428598 2025-05-15 17:50:54.429032
[1 rows x 5 columns]
2025-05-15 17:50:54,455 - 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-15 17:50:55,028 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2132 2025-05-11 23775.0
2133 2025-05-12 23775.0
2134 2025-05-13 23775.0
2135 2025-05-14 23775.0
2136 2025-05-15 23775.0
2025-05-15 17:50:55,079 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2136 2025-05-15 23775.0 ... 2025-05-15 17:50:55.072597 2025-05-15 17:50:55.073045
[1 rows x 5 columns]
2025-05-15 17:50:55,098 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-05-15 17:50:55,104 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2132 2025-05-11 23775.0
2133 2025-05-12 23775.0
2134 2025-05-13 23775.0
2135 2025-05-14 23775.0
2136 2025-05-15 23775.0
2025-05-15 17:50:55,155 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2140 2025-05-15 23775.0 ... 2025-05-15 17:50:55.148180 2025-05-15 17:50:55.148544
[1 rows x 5 columns]
2025-05-15 17:50:55,174 - 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-15 17:50:55,914 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1647 2025-05-11 1921.67
1648 2025-05-12 1945.00
1649 2025-05-13 1945.00
1650 2025-05-14 1945.00
1651 2025-05-15 1946.67
2025-05-15 17:50:55,960 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1651 2025-05-15 1946.67 ... 2025-05-15 17:50:55.953288 2025-05-15 17:50:55.953665
[1 rows x 5 columns]
2025-05-15 17:50:55,979 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-05-15 17:50:55,985 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1647 2025-05-11 1921.67
1648 2025-05-12 1945.00
1649 2025-05-13 1945.00
1650 2025-05-14 1945.00
1651 2025-05-15 1946.67
2025-05-15 17:50:56,032 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1655 2025-05-15 1946.67 ... 2025-05-15 17:50:56.025391 2025-05-15 17:50:56.025798
[1 rows x 5 columns]
2025-05-15 17:50:56,052 - 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-15 17:50:56,609 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2719 2025-05-11 124758.33
2720 2025-05-12 126525.00
2721 2025-05-13 124916.67
2722 2025-05-14 126308.33
2723 2025-05-15 126525.00
2025-05-15 17:50:56,671 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2723 2025-05-15 ... 2025-05-15 17:50:56.664438
[1 rows x 5 columns]
2025-05-15 17:50:56,691 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-05-15 17:50:56,698 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2719 2025-05-11 124758.33
2720 2025-05-12 126525.00
2721 2025-05-13 124916.67
2722 2025-05-14 126308.33
2723 2025-05-15 126525.00
2025-05-15 17:50:56,760 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2726 2025-05-15 ... 2025-05-15 17:50:56.754149
[1 rows x 5 columns]
2025-05-15 17:50:56,780 - 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-15 17:50:57,315 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3744 2025-05-11 4629.0
3745 2025-05-12 4604.0
3746 2025-05-13 4602.0
3747 2025-05-14 4697.0
3748 2025-05-15 4756.0
2025-05-15 17:50:57,388 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3748 2025-05-15 4756.0 ... 2025-05-15 17:50:57.380847 2025-05-15 17:50:57.381249
[1 rows x 5 columns]
2025-05-15 17:50:57,407 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-05-15 17:50:57,414 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3744 2025-05-11 4629.0
3745 2025-05-12 4604.0
3746 2025-05-13 4602.0
3747 2025-05-14 4697.0
3748 2025-05-15 4756.0
2025-05-15 17:50:57,487 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3751 2025-05-15 4756.0 ... 2025-05-15 17:50:57.479727 2025-05-15 17:50:57.480153
[1 rows x 5 columns]
2025-05-15 17:50:57,506 - 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-15 17:50:58,094 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
2983 2025-05-11 7440.0
2984 2025-05-12 7440.0
2985 2025-05-13 7440.0
2986 2025-05-14 7440.0
2987 2025-05-15 7440.0
2025-05-15 17:50:58,156 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
2987 2025-05-15 7440.0 ... 2025-05-15 17:50:58.149115 2025-05-15 17:50:58.149514
[1 rows x 5 columns]
2025-05-15 17:50:58,177 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-05-15 17:50:58,183 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
2983 2025-05-11 7440.0
2984 2025-05-12 7440.0
2985 2025-05-13 7440.0
2986 2025-05-14 7440.0
2987 2025-05-15 7440.0
2025-05-15 17:50:58,246 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
2990 2025-05-15 7440.0 ... 2025-05-15 17:50:58.239043 2025-05-15 17:50:58.239424
[1 rows x 5 columns]
2025-05-15 17:50:58,265 - 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-15 17:50:58,853 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3745 2025-05-11 14136.00
3746 2025-05-12 14200.83
3747 2025-05-13 14388.83
3748 2025-05-14 14482.83
3749 2025-05-15 14512.33
2025-05-15 17:50:58,926 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date ... updated_at
3749 2025-05-15 ... 2025-05-15 17:50:58.919929
[1 rows x 5 columns]
2025-05-15 17:50:58,945 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-05-15 17:50:58,951 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3745 2025-05-11 14136.00
3746 2025-05-12 14200.83
3747 2025-05-13 14388.83
3748 2025-05-14 14482.83
3749 2025-05-15 14512.33
2025-05-15 17:50:59,023 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date ... updated_at
3753 2025-05-15 ... 2025-05-15 17:50:59.017482
[1 rows x 5 columns]
2025-05-15 17:50:59,043 - 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-15 17:50:59,600 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3690 2025-05-11 16718.75
3691 2025-05-12 16806.25
3692 2025-05-13 16850.00
3693 2025-05-14 16850.00
3694 2025-05-15 16906.25
2025-05-15 17:50:59,671 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date ... updated_at
3694 2025-05-15 ... 2025-05-15 17:50:59.665532
[1 rows x 5 columns]
2025-05-15 17:50:59,691 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-05-15 17:50:59,697 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3690 2025-05-11 16718.75
3691 2025-05-12 16806.25
3692 2025-05-13 16850.00
3693 2025-05-14 16850.00
3694 2025-05-15 16906.25
2025-05-15 17:50:59,770 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date ... updated_at
3697 2025-05-15 ... 2025-05-15 17:50:59.763712
[1 rows x 5 columns]
2025-05-15 17:50:59,789 - 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-15 17:51:00,319 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
2965 2025-05-11 3273.33
2966 2025-05-12 3256.67
2967 2025-05-13 3296.67
2968 2025-05-14 3313.33
2969 2025-05-15 3313.33
2025-05-15 17:51:00,456 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
2969 2025-05-15 3313.33 ... 2025-05-15 17:51:00.448910 2025-05-15 17:51:00.449306
[1 rows x 5 columns]
2025-05-15 17:51:00,475 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-05-15 17:51:00,481 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
2965 2025-05-11 3273.33
2966 2025-05-12 3256.67
2967 2025-05-13 3296.67
2968 2025-05-14 3313.33
2969 2025-05-15 3313.33
2025-05-15 17:51:00,546 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
2972 2025-05-15 3313.33 ... 2025-05-15 17:51:00.539055 2025-05-15 17:51:00.539459
[1 rows x 5 columns]
2025-05-15 17:51:00,566 - 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-15 17:51:01,164 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3245 2025-05-11 5470.0
3246 2025-05-12 5470.0
3247 2025-05-13 5482.5
3248 2025-05-14 5470.0
3249 2025-05-15 5445.0
2025-05-15 17:51:01,233 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3249 2025-05-15 5445.0 ... 2025-05-15 17:51:01.225469 2025-05-15 17:51:01.225888
[1 rows x 5 columns]
2025-05-15 17:51:01,254 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-05-15 17:51:01,260 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3245 2025-05-11 5470.0
3246 2025-05-12 5470.0
3247 2025-05-13 5482.5
3248 2025-05-14 5470.0
3249 2025-05-15 5445.0
2025-05-15 17:51:01,338 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3736 2025-05-15 5445.0 ... 2025-05-15 17:51:01.330635 2025-05-15 17:51:01.331093
[1 rows x 5 columns]
2025-05-15 17:51:01,358 - 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-15 17:51:01,850 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1309 2025-05-11 14780.0
1310 2025-05-12 14750.0
1311 2025-05-13 14720.0
1312 2025-05-14 14730.0
1313 2025-05-15 14680.0
2025-05-15 17:51:01,893 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1313 2025-05-15 14680.0 ... 2025-05-15 17:51:01.885585 2025-05-15 17:51:01.886014
[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-15 17:51:02,140 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-05-15 17:51:02.132491
117 2021-07-06 ... 2025-05-15 17:51:02.132491
121 2021-07-12 ... 2025-05-15 17:51:02.132491
122 2021-07-13 ... 2025-05-15 17:51:02.132491
194 2021-11-01 ... 2025-05-15 17:51:02.132491
[5 rows x 6 columns]
2025-05-15 17:51:02,179 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1309 2025-05-11 14780.0
1310 2025-05-12 14750.0
1311 2025-05-13 14720.0
1312 2025-05-14 14730.0
1313 2025-05-15 14680.0
2025-05-15 17:51:02,221 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1316 2025-05-15 14680.0 ... 2025-05-15 17:51:02.214467 2025-05-15 17:51:02.214875
[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-15 17:51:02,466 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-05-15 17:51:02.458172
117 2021-07-06 ... 2025-05-15 17:51:02.458172
121 2021-07-12 ... 2025-05-15 17:51:02.458172
122 2021-07-13 ... 2025-05-15 17:51:02.458172
194 2021-11-01 ... 2025-05-15 17:51:02.458172
[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-15 17:51:03,125 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3741 2025-05-11 78258.33
3742 2025-05-12 78425.00
3743 2025-05-13 78168.33
3744 2025-05-14 78801.67
3745 2025-05-15 78938.33
2025-05-15 17:51:03,197 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date ... updated_at
3745 2025-05-15 ... 2025-05-15 17:51:03.191107
[1 rows x 5 columns]
2025-05-15 17:51:03,217 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-05-15 17:51:03,223 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3741 2025-05-11 78258.33
3742 2025-05-12 78425.00
3743 2025-05-13 78168.33
3744 2025-05-14 78801.67
3745 2025-05-15 78938.33
2025-05-15 17:51:03,297 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date ... updated_at
3748 2025-05-15 ... 2025-05-15 17:51:03.290658
[1 rows x 5 columns]
2025-05-15 17:51:03,316 - 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-15 17:51:03,856 - 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-15 17:51:03,911 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-05-15 17:51:03,911 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-05-15 17:51:03,916 - 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-15 17:51:03,978 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-05-15 17:51:03,978 - 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-15 17:51:04,563 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2719 2025-05-11 259500.0
2720 2025-05-12 262537.5
2721 2025-05-13 262125.0
2722 2025-05-14 265137.5
2723 2025-05-15 266125.0
2025-05-15 17:51:04,626 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2723 2025-05-15 ... 2025-05-15 17:51:04.618875
[1 rows x 5 columns]
2025-05-15 17:51:04,646 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-05-15 17:51:04,652 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2719 2025-05-11 259500.0
2720 2025-05-12 262537.5
2721 2025-05-13 262125.0
2722 2025-05-14 265137.5
2723 2025-05-15 266125.0
2025-05-15 17:51:04,714 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2726 2025-05-15 ... 2025-05-15 17:51:04.708114
[1 rows x 5 columns]
2025-05-15 17:51:04,734 - 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-15 17:51:05,291 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3740 2025-05-11 22756.0
3741 2025-05-12 22730.0
3742 2025-05-13 22662.0
3743 2025-05-14 22850.0
3744 2025-05-15 22880.0
2025-05-15 17:51:05,364 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3744 2025-05-15 22880.0 ... 2025-05-15 17:51:05.357077 2025-05-15 17:51:05.357459
[1 rows x 5 columns]
2025-05-15 17:51:05,383 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-05-15 17:51:05,390 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3740 2025-05-11 22756.0
3741 2025-05-12 22730.0
3742 2025-05-13 22662.0
3743 2025-05-14 22850.0
3744 2025-05-15 22880.0
2025-05-15 17:51:05,463 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3747 2025-05-15 22880.0 ... 2025-05-15 17:51:05.455914 2025-05-15 17:51:05.456303
[1 rows x 5 columns]
2025-05-15 17:51:05,483 - 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-15 17:51:06,112 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3703 2025-05-11 3367.5
3704 2025-05-12 3342.5
3705 2025-05-13 3342.5
3706 2025-05-14 3370.0
3707 2025-05-15 3377.5
2025-05-15 17:51:06,185 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3707 2025-05-15 3377.5 ... 2025-05-15 17:51:06.177859 2025-05-15 17:51:06.178283
[1 rows x 5 columns]
2025-05-15 17:51:06,205 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-05-15 17:51:06,211 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3703 2025-05-11 3367.5
3704 2025-05-12 3342.5
3705 2025-05-13 3342.5
3706 2025-05-14 3370.0
3707 2025-05-15 3377.5
2025-05-15 17:51:06,284 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3710 2025-05-15 3377.5 ... 2025-05-15 17:51:06.277383 2025-05-15 17:51:06.277806
[1 rows x 5 columns]
2025-05-15 17:51:06,304 - 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-15 17:51:06,932 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1500 2025-05-11 4917.5
1501 2025-05-12 4905.0
1502 2025-05-13 4882.5
1503 2025-05-14 4882.5
1504 2025-05-15 4847.5
2025-05-15 17:51:06,976 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1504 2025-05-15 4847.5 ... 2025-05-15 17:51:06.969349 2025-05-15 17:51:06.969730
[1 rows x 5 columns]
2025-05-15 17:51:06,995 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-05-15 17:51:07,001 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1500 2025-05-11 4917.5
1501 2025-05-12 4905.0
1502 2025-05-13 4882.5
1503 2025-05-14 4882.5
1504 2025-05-15 4847.5
2025-05-15 17:51:07,045 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1507 2025-05-15 4847.5 ... 2025-05-15 17:51:07.038458 2025-05-15 17:51:07.038863
[1 rows x 5 columns]
2025-05-15 17:51:07,064 - 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-15 17:51:07,726 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2774 2025-05-11 2292.86
2775 2025-05-12 2298.57
2776 2025-05-13 2300.00
2777 2025-05-14 2304.29
2778 2025-05-15 2304.29
2025-05-15 17:51:07,785 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2778 2025-05-15 2304.29 ... 2025-05-15 17:51:07.778274 2025-05-15 17:51:07.778650
[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-15 17:51:07,828 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2777 2025-05-14 ... 2025-05-15 17:51:07.820930
[1 rows x 6 columns]
2025-05-15 17:51:07,853 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2774 2025-05-11 2292.86
2775 2025-05-12 2298.57
2776 2025-05-13 2300.00
2777 2025-05-14 2304.29
2778 2025-05-15 2304.29
2025-05-15 17:51:07,913 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2781 2025-05-15 2304.29 ... 2025-05-15 17:51:07.906630 2025-05-15 17:51:07.907060
[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-15 17:51:07,955 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2780 2025-05-14 ... 2025-05-15 17:51:07.948157
[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-15 17:51:08,511 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2774 2025-05-11 2292.86
2775 2025-05-12 2298.57
2776 2025-05-13 2300.00
2777 2025-05-14 2304.29
2778 2025-05-15 2926.00
2025-05-15 17:51:08,563 - 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-15 17:51:08,586 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2778 2025-05-15 ... 2025-05-15 17:51:08.578909
[1 rows x 6 columns]
2025-05-15 17:51:08,612 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2774 2025-05-11 2292.86
2775 2025-05-12 2298.57
2776 2025-05-13 2300.00
2777 2025-05-14 2304.29
2778 2025-05-15 2926.00
2025-05-15 17:51:08,664 - 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-15 17:51:08,688 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2781 2025-05-15 ... 2025-05-15 17:51:08.680689
[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-15 17:51:09,211 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3131 2025-05-11 9463.33
3132 2025-05-12 9446.67
3133 2025-05-13 9468.33
3134 2025-05-14 9543.33
3135 2025-05-15 9395.00
2025-05-15 17:51:09,268 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-05-15 17:51:09,268 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-05-15 17:51:09,273 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3131 2025-05-11 9463.33
3132 2025-05-12 9446.67
3133 2025-05-13 9468.33
3134 2025-05-14 9543.33
3135 2025-05-15 9395.00
2025-05-15 17:51:09,331 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-05-15 17:51:09,331 - 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-15 17:51:09,924 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1815 2025-05-11 4340.00
1816 2025-05-12 4408.33
1817 2025-05-13 4408.33
1818 2025-05-14 4408.33
1819 2025-05-15 4536.67
2025-05-15 17:51:09,973 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1819 2025-05-15 4536.67 ... 2025-05-15 17:51:09.965978 2025-05-15 17:51:09.966373
[1 rows x 5 columns]
2025-05-15 17:51:09,992 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-05-15 17:51:09,998 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1815 2025-05-11 4340.00
1816 2025-05-12 4408.33
1817 2025-05-13 4408.33
1818 2025-05-14 4408.33
1819 2025-05-15 4536.67
2025-05-15 17:51:10,050 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1822 2025-05-15 4536.67 ... 2025-05-15 17:51:10.042805 2025-05-15 17:51:10.043210
[1 rows x 5 columns]
2025-05-15 17:51:10,069 - 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-15 17:51:10,622 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1824 2025-05-11 6200.00
1825 2025-05-12 6200.00
1826 2025-05-13 6250.00
1827 2025-05-14 6266.67
1828 2025-05-15 6300.00
2025-05-15 17:51:10,671 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1828 2025-05-15 6300.0 ... 2025-05-15 17:51:10.663906 2025-05-15 17:51:10.664323
[1 rows x 5 columns]
2025-05-15 17:51:10,691 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-05-15 17:51:10,697 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1824 2025-05-11 6200.00
1825 2025-05-12 6200.00
1826 2025-05-13 6250.00
1827 2025-05-14 6266.67
1828 2025-05-15 6300.00
2025-05-15 17:51:10,747 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1831 2025-05-15 6300.0 ... 2025-05-15 17:51:10.740372 2025-05-15 17:51:10.740778
[1 rows x 5 columns]
2025-05-15 17:51:10,767 - 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-15 17:51:11,411 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3492 2025-05-11 8510.0
3493 2025-05-12 8610.0
3494 2025-05-13 8564.0
3495 2025-05-14 8680.0
3496 2025-05-15 8680.0
2025-05-15 17:51:11,480 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3496 2025-05-15 8680.0 ... 2025-05-15 17:51:11.473236 2025-05-15 17:51:11.473619
[1 rows x 5 columns]
2025-05-15 17:51:11,500 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-05-15 17:51:11,506 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3492 2025-05-11 8510.0
3493 2025-05-12 8610.0
3494 2025-05-13 8564.0
3495 2025-05-14 8680.0
3496 2025-05-15 8680.0
2025-05-15 17:51:11,576 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3499 2025-05-15 8680.0 ... 2025-05-15 17:51:11.569155 2025-05-15 17:51:11.569834
[1 rows x 5 columns]
2025-05-15 17:51:11,596 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data