=========================================================================
2025-05-12 17:50:26 Mon START TASK.01 IOOppi_data update_data
=========================================================================
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-05-12 17:50:28,898 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3297 2025-05-08 3162.78
3298 2025-05-09 3141.44
3299 2025-05-10 3141.44
3300 2025-05-11 3141.44
3301 2025-05-12 3160.33
2025-05-12 17:50:28,969 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3299 2025-05-10 3141.44 ... 2025-05-12 17:50:28.961880 2025-05-12 17:50:28.962306
3300 2025-05-11 3141.44 ... 2025-05-12 17:50:28.961880 2025-05-12 17:50:28.962306
3301 2025-05-12 3160.33 ... 2025-05-12 17:50:28.961880 2025-05-12 17:50:28.962306
[3 rows x 5 columns]
2025-05-12 17:50:28,990 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-05-12 17:50:28,996 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3297 2025-05-08 3162.78
3298 2025-05-09 3141.44
3299 2025-05-10 3141.44
3300 2025-05-11 3141.44
3301 2025-05-12 3160.33
2025-05-12 17:50:29,063 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3302 2025-05-10 3141.44 ... 2025-05-12 17:50:29.055615 2025-05-12 17:50:29.056044
3303 2025-05-11 3141.44 ... 2025-05-12 17:50:29.055615 2025-05-12 17:50:29.056044
3304 2025-05-12 3160.33 ... 2025-05-12 17:50:29.055615 2025-05-12 17:50:29.056044
[3 rows x 5 columns]
2025-05-12 17:50:29,082 - 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-12 17:50:29,662 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3518 2025-05-08 2390.0
3519 2025-05-09 2402.5
3520 2025-05-10 2402.5
3521 2025-05-11 2402.5
3522 2025-05-12 2402.5
2025-05-12 17:50:29,731 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3520 2025-05-10 2402.5 ... 2025-05-12 17:50:29.723941 2025-05-12 17:50:29.724337
3521 2025-05-11 2402.5 ... 2025-05-12 17:50:29.723941 2025-05-12 17:50:29.724337
3522 2025-05-12 2402.5 ... 2025-05-12 17:50:29.723941 2025-05-12 17:50:29.724337
[3 rows x 5 columns]
2025-05-12 17:50:29,750 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-05-12 17:50:29,756 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3518 2025-05-08 2390.0
3519 2025-05-09 2402.5
3520 2025-05-10 2402.5
3521 2025-05-11 2402.5
3522 2025-05-12 2402.5
2025-05-12 17:50:29,824 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3524 2025-05-10 2402.5 ... 2025-05-12 17:50:29.816928 2025-05-12 17:50:29.817326
3525 2025-05-11 2402.5 ... 2025-05-12 17:50:29.816928 2025-05-12 17:50:29.817326
3526 2025-05-12 2402.5 ... 2025-05-12 17:50:29.816928 2025-05-12 17:50:29.817326
[3 rows x 5 columns]
2025-05-12 17:50:29,843 - 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-12 17:50:30,492 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
858 2025-05-08 4688.34
859 2025-05-09 4750.84
860 2025-05-10 4750.84
861 2025-05-11 4750.84
862 2025-05-12 4888.33
2025-05-12 17:50:30,529 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
860 2025-05-10 4750.84 ... 2025-05-12 17:50:30.521260 2025-05-12 17:50:30.521677
861 2025-05-11 4750.84 ... 2025-05-12 17:50:30.521260 2025-05-12 17:50:30.521677
862 2025-05-12 4888.33 ... 2025-05-12 17:50:30.521260 2025-05-12 17:50:30.521677
[3 rows x 5 columns]
2025-05-12 17:50:30,548 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-05-12 17:50:30,553 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
858 2025-05-08 4688.34
859 2025-05-09 4750.84
860 2025-05-10 4750.84
861 2025-05-11 4750.84
862 2025-05-12 4888.33
2025-05-12 17:50:30,590 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
860 2025-05-10 4750.84 ... 2025-05-12 17:50:30.582721 2025-05-12 17:50:30.583213
861 2025-05-11 4750.84 ... 2025-05-12 17:50:30.582721 2025-05-12 17:50:30.583213
862 2025-05-12 4888.33 ... 2025-05-12 17:50:30.582721 2025-05-12 17:50:30.583213
[3 rows x 5 columns]
2025-05-12 17:50:30,609 - 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-12 17:50:31,172 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3737 2025-05-08 14458.33
3738 2025-05-09 14408.33
3739 2025-05-10 14408.33
3740 2025-05-11 14408.33
3741 2025-05-12 14738.33
2025-05-12 17:50:31,250 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3739 2025-05-10 ... 2025-05-12 17:50:31.243196
3740 2025-05-11 ... 2025-05-12 17:50:31.243196
3741 2025-05-12 ... 2025-05-12 17:50:31.243196
[3 rows x 5 columns]
2025-05-12 17:50:31,269 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-05-12 17:50:31,275 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3737 2025-05-08 14458.33
3738 2025-05-09 14408.33
3739 2025-05-10 14408.33
3740 2025-05-11 14408.33
3741 2025-05-12 14738.33
2025-05-12 17:50:31,350 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3742 2025-05-10 ... 2025-05-12 17:50:31.343540
3743 2025-05-11 ... 2025-05-12 17:50:31.343540
3744 2025-05-12 ... 2025-05-12 17:50:31.343540
[3 rows x 5 columns]
2025-05-12 17:50:31,369 - 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-12 17:50:31,889 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3069 2025-05-08 776.22
3070 2025-05-09 770.89
3071 2025-05-10 770.89
3072 2025-05-11 770.89
3073 2025-05-12 777.22
2025-05-12 17:50:31,953 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3071 2025-05-10 770.89 ... 2025-05-12 17:50:31.946177 2025-05-12 17:50:31.946562
3072 2025-05-11 770.89 ... 2025-05-12 17:50:31.946177 2025-05-12 17:50:31.946562
3073 2025-05-12 777.22 ... 2025-05-12 17:50:31.946177 2025-05-12 17:50:31.946562
[3 rows x 5 columns]
2025-05-12 17:50:31,973 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-05-12 17:50:31,980 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3069 2025-05-08 776.22
3070 2025-05-09 770.89
3071 2025-05-10 770.89
3072 2025-05-11 770.89
3073 2025-05-12 777.22
2025-05-12 17:50:32,053 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3074 2025-05-10 770.89 ... 2025-05-12 17:50:32.041938 2025-05-12 17:50:32.042556
3075 2025-05-11 770.89 ... 2025-05-12 17:50:32.041938 2025-05-12 17:50:32.042556
3076 2025-05-12 777.22 ... 2025-05-12 17:50:32.041938 2025-05-12 17:50:32.042556
[3 rows x 5 columns]
2025-05-12 17:50:32,074 - 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-12 17:50:32,607 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3272 2025-05-08 1214.4
3273 2025-05-09 1214.4
3274 2025-05-10 1210.4
3275 2025-05-11 1210.4
3276 2025-05-12 1210.4
2025-05-12 17:50:32,677 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3274 2025-05-10 1210.4 ... 2025-05-12 17:50:32.668634 2025-05-12 17:50:32.669165
3275 2025-05-11 1210.4 ... 2025-05-12 17:50:32.668634 2025-05-12 17:50:32.669165
3276 2025-05-12 1210.4 ... 2025-05-12 17:50:32.668634 2025-05-12 17:50:32.669165
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-12 17:50:34,641 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-05-12 17:50:34.633476
21 2013-01-04 ... 2025-05-12 17:50:34.633476
54 2013-02-27 ... 2025-05-12 17:50:34.633476
60 2013-03-07 ... 2025-05-12 17:50:34.633476
61 2013-03-08 ... 2025-05-12 17:50:34.633476
[5 rows x 6 columns]
2025-05-12 17:50:34,797 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3272 2025-05-08 1214.4
3273 2025-05-09 1214.4
3274 2025-05-10 1210.4
3275 2025-05-11 1210.4
3276 2025-05-12 1210.4
2025-05-12 17:50:34,864 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3278 2025-05-10 1210.4 ... 2025-05-12 17:50:34.856882 2025-05-12 17:50:34.857274
3279 2025-05-11 1210.4 ... 2025-05-12 17:50:34.856882 2025-05-12 17:50:34.857274
3280 2025-05-12 1210.4 ... 2025-05-12 17:50:34.856882 2025-05-12 17:50:34.857274
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-12 17:50:36,817 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-05-12 17:50:36.809613
21 2013-01-04 ... 2025-05-12 17:50:36.809613
54 2013-02-27 ... 2025-05-12 17:50:36.809613
60 2013-03-07 ... 2025-05-12 17:50:36.809613
61 2013-03-08 ... 2025-05-12 17:50:36.809613
[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-12 17:50:37,616 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1617 2025-05-08 7686.0
1618 2025-05-09 7680.0
1619 2025-05-10 7680.0
1620 2025-05-11 7680.0
1621 2025-05-12 7676.0
2025-05-12 17:50:37,669 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1619 2025-05-10 7680.0 ... 2025-05-12 17:50:37.660506 2025-05-12 17:50:37.661011
1620 2025-05-11 7680.0 ... 2025-05-12 17:50:37.660506 2025-05-12 17:50:37.661011
1621 2025-05-12 7676.0 ... 2025-05-12 17:50:37.660506 2025-05-12 17:50:37.661011
[3 rows x 5 columns]
2025-05-12 17:50:37,688 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-05-12 17:50:37,695 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1617 2025-05-08 7686.0
1618 2025-05-09 7680.0
1619 2025-05-10 7680.0
1620 2025-05-11 7680.0
1621 2025-05-12 7676.0
2025-05-12 17:50:37,746 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1622 2025-05-10 7680.0 ... 2025-05-12 17:50:37.737878 2025-05-12 17:50:37.738297
1623 2025-05-11 7680.0 ... 2025-05-12 17:50:37.737878 2025-05-12 17:50:37.738297
1624 2025-05-12 7676.0 ... 2025-05-12 17:50:37.737878 2025-05-12 17:50:37.738297
[3 rows x 5 columns]
2025-05-12 17:50:37,766 - 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-12 17:50:38,332 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3728 2025-05-08 6156.67
3729 2025-05-09 6146.67
3730 2025-05-10 6135.00
3731 2025-05-11 6135.00
3732 2025-05-12 6150.00
2025-05-12 17:50:38,405 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3730 2025-05-10 6135.0 ... 2025-05-12 17:50:38.396970 2025-05-12 17:50:38.397375
3731 2025-05-11 6135.0 ... 2025-05-12 17:50:38.396970 2025-05-12 17:50:38.397375
3732 2025-05-12 6150.0 ... 2025-05-12 17:50:38.396970 2025-05-12 17:50:38.397375
[3 rows x 5 columns]
2025-05-12 17:50:38,425 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-05-12 17:50:38,432 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3728 2025-05-08 6156.67
3729 2025-05-09 6146.67
3730 2025-05-10 6135.00
3731 2025-05-11 6135.00
3732 2025-05-12 6150.00
2025-05-12 17:50:38,507 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3734 2025-05-10 6135.0 ... 2025-05-12 17:50:38.499669 2025-05-12 17:50:38.500148
3735 2025-05-11 6135.0 ... 2025-05-12 17:50:38.499669 2025-05-12 17:50:38.500148
3736 2025-05-12 6150.0 ... 2025-05-12 17:50:38.499669 2025-05-12 17:50:38.500148
[3 rows x 5 columns]
2025-05-12 17:50:38,526 - 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-12 17:50:39,056 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1618 2025-05-08 13042.5
1619 2025-05-09 13042.5
1620 2025-05-10 13042.5
1621 2025-05-11 13042.5
1622 2025-05-12 13130.0
2025-05-12 17:50:39,102 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1620 2025-05-10 13042.5 ... 2025-05-12 17:50:39.095220 2025-05-12 17:50:39.095617
1621 2025-05-11 13042.5 ... 2025-05-12 17:50:39.095220 2025-05-12 17:50:39.095617
1622 2025-05-12 13130.0 ... 2025-05-12 17:50:39.095220 2025-05-12 17:50:39.095617
[3 rows x 5 columns]
2025-05-12 17:50:39,121 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-05-12 17:50:39,127 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1618 2025-05-08 13042.5
1619 2025-05-09 13042.5
1620 2025-05-10 13042.5
1621 2025-05-11 13042.5
1622 2025-05-12 13130.0
2025-05-12 17:50:39,174 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1623 2025-05-10 13042.5 ... 2025-05-12 17:50:39.167182 2025-05-12 17:50:39.167567
1624 2025-05-11 13042.5 ... 2025-05-12 17:50:39.167182 2025-05-12 17:50:39.167567
1625 2025-05-12 13130.0 ... 2025-05-12 17:50:39.167182 2025-05-12 17:50:39.167567
[3 rows x 5 columns]
2025-05-12 17:50:39,194 - 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-12 17:50:39,787 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3128 2025-05-08 9471.67
3129 2025-05-09 9463.33
3130 2025-05-10 9463.33
3131 2025-05-11 9463.33
3132 2025-05-12 9446.67
2025-05-12 17:50:39,852 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date value ... created_at updated_at
3130 2025-05-10 9463.33 ... 2025-05-12 17:50:39.845092 2025-05-12 17:50:39.845488
3131 2025-05-11 9463.33 ... 2025-05-12 17:50:39.845092 2025-05-12 17:50:39.845488
3132 2025-05-12 9446.67 ... 2025-05-12 17:50:39.845092 2025-05-12 17:50:39.845488
[3 rows x 5 columns]
2025-05-12 17:50:39,870 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-05-12 17:50:39,876 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3128 2025-05-08 9471.67
3129 2025-05-09 9463.33
3130 2025-05-10 9463.33
3131 2025-05-11 9463.33
3132 2025-05-12 9446.67
2025-05-12 17:50:39,942 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date value ... created_at updated_at
3134 2025-05-10 9463.33 ... 2025-05-12 17:50:39.934723 2025-05-12 17:50:39.935148
3135 2025-05-11 9463.33 ... 2025-05-12 17:50:39.934723 2025-05-12 17:50:39.935148
3136 2025-05-12 9446.67 ... 2025-05-12 17:50:39.934723 2025-05-12 17:50:39.935148
[3 rows x 5 columns]
2025-05-12 17:50:39,961 - 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-12 17:50:40,534 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3251 2025-05-08 2550.00
3252 2025-05-09 2506.67
3253 2025-05-10 2506.67
3254 2025-05-11 2506.67
3255 2025-05-12 2490.00
2025-05-12 17:50:40,604 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3253 2025-05-10 2506.67 ... 2025-05-12 17:50:40.596373 2025-05-12 17:50:40.596786
3254 2025-05-11 2506.67 ... 2025-05-12 17:50:40.596373 2025-05-12 17:50:40.596786
3255 2025-05-12 2490.00 ... 2025-05-12 17:50:40.596373 2025-05-12 17:50:40.596786
[3 rows x 5 columns]
2025-05-12 17:50:40,623 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-05-12 17:50:40,630 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3251 2025-05-08 2550.00
3252 2025-05-09 2506.67
3253 2025-05-10 2506.67
3254 2025-05-11 2506.67
3255 2025-05-12 2490.00
2025-05-12 17:50:40,696 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3257 2025-05-10 2506.67 ... 2025-05-12 17:50:40.689195 2025-05-12 17:50:40.689586
3258 2025-05-11 2506.67 ... 2025-05-12 17:50:40.689195 2025-05-12 17:50:40.689586
3259 2025-05-12 2490.00 ... 2025-05-12 17:50:40.689195 2025-05-12 17:50:40.689586
[3 rows x 5 columns]
2025-05-12 17:50:40,716 - 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-12 17:50:41,546 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1455 2025-05-08 1462.5
1456 2025-05-09 1462.5
1457 2025-05-10 1462.5
1458 2025-05-11 1462.5
1459 2025-05-12 1462.5
2025-05-12 17:50:41,590 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1457 2025-05-10 1462.5 ... 2025-05-12 17:50:41.582914 2025-05-12 17:50:41.583303
1458 2025-05-11 1462.5 ... 2025-05-12 17:50:41.582914 2025-05-12 17:50:41.583303
1459 2025-05-12 1462.5 ... 2025-05-12 17:50:41.582914 2025-05-12 17:50:41.583303
[3 rows x 5 columns]
2025-05-12 17:50:41,609 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-05-12 17:50:41,615 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1455 2025-05-08 1462.5
1456 2025-05-09 1462.5
1457 2025-05-10 1462.5
1458 2025-05-11 1462.5
1459 2025-05-12 1462.5
2025-05-12 17:50:41,660 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1461 2025-05-10 1462.5 ... 2025-05-12 17:50:41.652995 2025-05-12 17:50:41.653430
1462 2025-05-11 1462.5 ... 2025-05-12 17:50:41.652995 2025-05-12 17:50:41.653430
1463 2025-05-12 1462.5 ... 2025-05-12 17:50:41.652995 2025-05-12 17:50:41.653430
[3 rows x 5 columns]
2025-05-12 17:50:41,679 - 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-12 17:50:42,215 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1368 2025-05-08 6364.79
1369 2025-05-09 6377.92
1370 2025-05-10 6377.92
1371 2025-05-11 6377.92
1372 2025-05-12 6411.79
2025-05-12 17:50:42,258 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1370 2025-05-10 6377.92 ... 2025-05-12 17:50:42.250594 2025-05-12 17:50:42.251001
1371 2025-05-11 6377.92 ... 2025-05-12 17:50:42.250594 2025-05-12 17:50:42.251001
1372 2025-05-12 6411.79 ... 2025-05-12 17:50:42.250594 2025-05-12 17:50:42.251001
[3 rows x 5 columns]
2025-05-12 17:50:42,278 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-05-12 17:50:42,284 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1368 2025-05-08 6364.79
1369 2025-05-09 6377.92
1370 2025-05-10 6377.92
1371 2025-05-11 6377.92
1372 2025-05-12 6411.79
2025-05-12 17:50:42,327 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1374 2025-05-10 6377.92 ... 2025-05-12 17:50:42.320190 2025-05-12 17:50:42.320579
1375 2025-05-11 6377.92 ... 2025-05-12 17:50:42.320190 2025-05-12 17:50:42.320579
1376 2025-05-12 6411.79 ... 2025-05-12 17:50:42.320190 2025-05-12 17:50:42.320579
[3 rows x 5 columns]
2025-05-12 17:50:42,346 - 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-12 17:50:42,886 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3741 2025-05-08 3300.0
3742 2025-05-09 3300.0
3743 2025-05-10 3300.0
3744 2025-05-11 3300.0
3745 2025-05-12 3138.0
2025-05-12 17:50:42,959 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3743 2025-05-10 3300.0 ... 2025-05-12 17:50:42.951610 2025-05-12 17:50:42.952024
3744 2025-05-11 3300.0 ... 2025-05-12 17:50:42.951610 2025-05-12 17:50:42.952024
3745 2025-05-12 3138.0 ... 2025-05-12 17:50:42.951610 2025-05-12 17:50:42.952024
[3 rows x 5 columns]
2025-05-12 17:50:42,977 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-05-12 17:50:42,984 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3741 2025-05-08 3300.0
3742 2025-05-09 3300.0
3743 2025-05-10 3300.0
3744 2025-05-11 3300.0
3745 2025-05-12 3138.0
2025-05-12 17:50:43,058 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3746 2025-05-10 3300.0 ... 2025-05-12 17:50:43.050415 2025-05-12 17:50:43.050827
3747 2025-05-11 3300.0 ... 2025-05-12 17:50:43.050415 2025-05-12 17:50:43.050827
3748 2025-05-12 3138.0 ... 2025-05-12 17:50:43.050415 2025-05-12 17:50:43.050827
[3 rows x 5 columns]
2025-05-12 17:50:43,076 - 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-12 17:50:43,782 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3511 2025-05-08 8056.0
3512 2025-05-09 8076.0
3513 2025-05-10 8076.0
3514 2025-05-11 8076.0
3515 2025-05-12 8094.0
2025-05-12 17:50:43,852 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3513 2025-05-10 8076.0 ... 2025-05-12 17:50:43.844580 2025-05-12 17:50:43.845002
3514 2025-05-11 8076.0 ... 2025-05-12 17:50:43.844580 2025-05-12 17:50:43.845002
3515 2025-05-12 8094.0 ... 2025-05-12 17:50:43.844580 2025-05-12 17:50:43.845002
[3 rows x 5 columns]
2025-05-12 17:50:43,871 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-05-12 17:50:43,877 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3511 2025-05-08 8056.0
3512 2025-05-09 8076.0
3513 2025-05-10 8076.0
3514 2025-05-11 8076.0
3515 2025-05-12 8094.0
2025-05-12 17:50:43,947 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3516 2025-05-10 8076.0 ... 2025-05-12 17:50:43.940023 2025-05-12 17:50:43.940417
3517 2025-05-11 8076.0 ... 2025-05-12 17:50:43.940023 2025-05-12 17:50:43.940417
3518 2025-05-12 8094.0 ... 2025-05-12 17:50:43.940023 2025-05-12 17:50:43.940417
[3 rows x 5 columns]
2025-05-12 17:50:43,966 - 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-12 17:50:44,488 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3477 2025-05-08 4230.0
3478 2025-05-09 4245.0
3479 2025-05-10 4245.0
3480 2025-05-11 4245.0
3481 2025-05-12 4255.0
2025-05-12 17:50:44,564 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3479 2025-05-10 4245.0 ... 2025-05-12 17:50:44.556483 2025-05-12 17:50:44.556949
3480 2025-05-11 4245.0 ... 2025-05-12 17:50:44.556483 2025-05-12 17:50:44.556949
3481 2025-05-12 4255.0 ... 2025-05-12 17:50:44.556483 2025-05-12 17:50:44.556949
[3 rows x 5 columns]
2025-05-12 17:50:44,583 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-05-12 17:50:44,589 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3477 2025-05-08 4230.0
3478 2025-05-09 4245.0
3479 2025-05-10 4245.0
3480 2025-05-11 4245.0
3481 2025-05-12 4255.0
2025-05-12 17:50:44,659 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3482 2025-05-10 4245.0 ... 2025-05-12 17:50:44.652220 2025-05-12 17:50:44.652648
3483 2025-05-11 4245.0 ... 2025-05-12 17:50:44.652220 2025-05-12 17:50:44.652648
3484 2025-05-12 4255.0 ... 2025-05-12 17:50:44.652220 2025-05-12 17:50:44.652648
[3 rows x 5 columns]
2025-05-12 17:50:44,678 - 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-12 17:50:45,231 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2854 2025-05-08 5402.86
2855 2025-05-09 5402.86
2856 2025-05-10 5402.86
2857 2025-05-11 5402.86
2858 2025-05-12 5424.29
2025-05-12 17:50:45,294 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2856 2025-05-10 5402.86 ... 2025-05-12 17:50:45.286869 2025-05-12 17:50:45.287306
2857 2025-05-11 5402.86 ... 2025-05-12 17:50:45.286869 2025-05-12 17:50:45.287306
2858 2025-05-12 5424.29 ... 2025-05-12 17:50:45.286869 2025-05-12 17:50:45.287306
[3 rows x 5 columns]
2025-05-12 17:50:45,314 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-05-12 17:50:45,320 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2854 2025-05-08 5402.86
2855 2025-05-09 5402.86
2856 2025-05-10 5402.86
2857 2025-05-11 5402.86
2858 2025-05-12 5424.29
2025-05-12 17:50:45,382 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2860 2025-05-10 5402.86 ... 2025-05-12 17:50:45.374674 2025-05-12 17:50:45.375100
2861 2025-05-11 5402.86 ... 2025-05-12 17:50:45.374674 2025-05-12 17:50:45.375100
2862 2025-05-12 5424.29 ... 2025-05-12 17:50:45.374674 2025-05-12 17:50:45.375100
[3 rows x 5 columns]
2025-05-12 17:50:45,400 - 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-12 17:50:45,882 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3054 2025-05-08 3225.0
3055 2025-05-09 3225.0
3056 2025-05-10 3225.0
3057 2025-05-11 3225.0
3058 2025-05-12 3310.0
2025-05-12 17:50:45,957 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3056 2025-05-10 3225.0 ... 2025-05-12 17:50:45.949613 2025-05-12 17:50:45.950041
3057 2025-05-11 3225.0 ... 2025-05-12 17:50:45.949613 2025-05-12 17:50:45.950041
3058 2025-05-12 3310.0 ... 2025-05-12 17:50:45.949613 2025-05-12 17:50:45.950041
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-12 17:50:46,108 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-05-12 17:50:46.100503
458 2015-09-21 ... 2025-05-12 17:50:46.100503
549 2016-02-03 ... 2025-05-12 17:50:46.100503
693 2016-09-05 ... 2025-05-12 17:50:46.100503
696 2016-09-08 ... 2025-05-12 17:50:46.100503
[5 rows x 6 columns]
2025-05-12 17:50:46,138 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3054 2025-05-08 3225.0
3055 2025-05-09 3225.0
3056 2025-05-10 3225.0
3057 2025-05-11 3225.0
3058 2025-05-12 3310.0
2025-05-12 17:50:46,203 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3059 2025-05-10 3225.0 ... 2025-05-12 17:50:46.195691 2025-05-12 17:50:46.196125
3060 2025-05-11 3225.0 ... 2025-05-12 17:50:46.195691 2025-05-12 17:50:46.196125
3061 2025-05-12 3310.0 ... 2025-05-12 17:50:46.195691 2025-05-12 17:50:46.196125
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-12 17:50:46,352 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-05-12 17:50:46.344034
458 2015-09-21 ... 2025-05-12 17:50:46.344034
549 2016-02-03 ... 2025-05-12 17:50:46.344034
693 2016-09-05 ... 2025-05-12 17:50:46.344034
696 2016-09-08 ... 2025-05-12 17:50:46.344034
[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-12 17:50:46,978 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
858 2025-05-08 9640.0
859 2025-05-09 9640.0
860 2025-05-10 9640.0
861 2025-05-11 9640.0
862 2025-05-12 9610.0
2025-05-12 17:50:47,017 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
860 2025-05-10 9640.0 ... 2025-05-12 17:50:47.008610 2025-05-12 17:50:47.009096
861 2025-05-11 9640.0 ... 2025-05-12 17:50:47.008610 2025-05-12 17:50:47.009096
862 2025-05-12 9610.0 ... 2025-05-12 17:50:47.008610 2025-05-12 17:50:47.009096
[3 rows x 5 columns]
2025-05-12 17:50:47,038 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-05-12 17:50:47,043 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
858 2025-05-08 9640.0
859 2025-05-09 9640.0
860 2025-05-10 9640.0
861 2025-05-11 9640.0
862 2025-05-12 9610.0
2025-05-12 17:50:47,081 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
860 2025-05-10 9640.0 ... 2025-05-12 17:50:47.072960 2025-05-12 17:50:47.073371
861 2025-05-11 9640.0 ... 2025-05-12 17:50:47.072960 2025-05-12 17:50:47.073371
862 2025-05-12 9610.0 ... 2025-05-12 17:50:47.072960 2025-05-12 17:50:47.073371
[3 rows x 5 columns]
2025-05-12 17:50:47,099 - 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-12 17:50:47,637 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3737 2025-05-08 7465.00
3738 2025-05-09 7458.33
3739 2025-05-10 7458.33
3740 2025-05-11 7458.33
3741 2025-05-12 7428.33
2025-05-12 17:50:47,715 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3739 2025-05-10 7458.33 ... 2025-05-12 17:50:47.707737 2025-05-12 17:50:47.708201
3740 2025-05-11 7458.33 ... 2025-05-12 17:50:47.707737 2025-05-12 17:50:47.708201
3741 2025-05-12 7428.33 ... 2025-05-12 17:50:47.707737 2025-05-12 17:50:47.708201
[3 rows x 5 columns]
2025-05-12 17:50:47,735 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-05-12 17:50:47,742 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3737 2025-05-08 7465.00
3738 2025-05-09 7458.33
3739 2025-05-10 7458.33
3740 2025-05-11 7458.33
3741 2025-05-12 7428.33
2025-05-12 17:50:47,816 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3742 2025-05-10 7458.33 ... 2025-05-12 17:50:47.808233 2025-05-12 17:50:47.808668
3743 2025-05-11 7458.33 ... 2025-05-12 17:50:47.808233 2025-05-12 17:50:47.808668
3744 2025-05-12 7428.33 ... 2025-05-12 17:50:47.808233 2025-05-12 17:50:47.808668
[3 rows x 5 columns]
2025-05-12 17:50:47,835 - 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-12 17:50:48,447 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3075 2025-05-08 3582.5
3076 2025-05-09 3585.0
3077 2025-05-10 3585.0
3078 2025-05-11 3585.0
3079 2025-05-12 3585.0
2025-05-12 17:50:48,530 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3078 2025-05-10 3585.0 ... 2025-05-12 17:50:48.522316 2025-05-12 17:50:48.522724
3079 2025-05-11 3585.0 ... 2025-05-12 17:50:48.522316 2025-05-12 17:50:48.522724
3080 2025-05-12 3585.0 ... 2025-05-12 17:50:48.522316 2025-05-12 17:50:48.522724
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-12 17:50:48,569 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-05-12 17:50:48.560464
[1 rows x 6 columns]
2025-05-12 17:50:48,595 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3075 2025-05-08 3582.5
3076 2025-05-09 3585.0
3077 2025-05-10 3585.0
3078 2025-05-11 3585.0
3079 2025-05-12 3585.0
2025-05-12 17:50:48,663 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3080 2025-05-10 3585.0 ... 2025-05-12 17:50:48.655539 2025-05-12 17:50:48.655990
3081 2025-05-11 3585.0 ... 2025-05-12 17:50:48.655539 2025-05-12 17:50:48.655990
3082 2025-05-12 3585.0 ... 2025-05-12 17:50:48.655539 2025-05-12 17:50:48.655990
[3 rows x 5 columns]
2025-05-12 17:50:48,682 - 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-12 17:50:49,258 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3740 2025-05-08 19630.00
3741 2025-05-09 19630.00
3742 2025-05-10 19626.67
3743 2025-05-11 19626.67
3744 2025-05-12 19830.00
2025-05-12 17:50:49,331 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date ... updated_at
3742 2025-05-10 ... 2025-05-12 17:50:49.324403
3743 2025-05-11 ... 2025-05-12 17:50:49.324403
3744 2025-05-12 ... 2025-05-12 17:50:49.324403
[3 rows x 5 columns]
2025-05-12 17:50:49,350 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-05-12 17:50:49,357 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3740 2025-05-08 19630.00
3741 2025-05-09 19630.00
3742 2025-05-10 19626.67
3743 2025-05-11 19626.67
3744 2025-05-12 19830.00
2025-05-12 17:50:49,431 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date ... updated_at
3745 2025-05-10 ... 2025-05-12 17:50:49.424360
3746 2025-05-11 ... 2025-05-12 17:50:49.424360
3747 2025-05-12 ... 2025-05-12 17:50:49.424360
[3 rows x 5 columns]
2025-05-12 17:50:49,450 - 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-12 17:50:49,979 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2854 2025-05-08 5590.0
2855 2025-05-09 5634.0
2856 2025-05-10 5634.0
2857 2025-05-11 5634.0
2858 2025-05-12 5676.0
2025-05-12 17:50:50,047 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2856 2025-05-10 5634.0 ... 2025-05-12 17:50:50.036372 2025-05-12 17:50:50.037005
2857 2025-05-11 5634.0 ... 2025-05-12 17:50:50.036372 2025-05-12 17:50:50.037005
2858 2025-05-12 5676.0 ... 2025-05-12 17:50:50.036372 2025-05-12 17:50:50.037005
[3 rows x 5 columns]
2025-05-12 17:50:50,067 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-05-12 17:50:50,073 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2854 2025-05-08 5590.0
2855 2025-05-09 5634.0
2856 2025-05-10 5634.0
2857 2025-05-11 5634.0
2858 2025-05-12 5676.0
2025-05-12 17:50:50,136 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2860 2025-05-10 5634.0 ... 2025-05-12 17:50:50.128433 2025-05-12 17:50:50.128912
2861 2025-05-11 5634.0 ... 2025-05-12 17:50:50.128433 2025-05-12 17:50:50.128912
2862 2025-05-12 5676.0 ... 2025-05-12 17:50:50.128433 2025-05-12 17:50:50.128912
[3 rows x 5 columns]
2025-05-12 17:50:50,154 - 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-12 17:50:50,677 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2129 2025-05-08 23775.0
2130 2025-05-09 23775.0
2131 2025-05-10 23775.0
2132 2025-05-11 23775.0
2133 2025-05-12 23775.0
2025-05-12 17:50:50,729 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2131 2025-05-10 23775.0 ... 2025-05-12 17:50:50.721847 2025-05-12 17:50:50.722243
2132 2025-05-11 23775.0 ... 2025-05-12 17:50:50.721847 2025-05-12 17:50:50.722243
2133 2025-05-12 23775.0 ... 2025-05-12 17:50:50.721847 2025-05-12 17:50:50.722243
[3 rows x 5 columns]
2025-05-12 17:50:50,748 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-05-12 17:50:50,753 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2129 2025-05-08 23775.0
2130 2025-05-09 23775.0
2131 2025-05-10 23775.0
2132 2025-05-11 23775.0
2133 2025-05-12 23775.0
2025-05-12 17:50:50,806 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2135 2025-05-10 23775.0 ... 2025-05-12 17:50:50.798504 2025-05-12 17:50:50.798924
2136 2025-05-11 23775.0 ... 2025-05-12 17:50:50.798504 2025-05-12 17:50:50.798924
2137 2025-05-12 23775.0 ... 2025-05-12 17:50:50.798504 2025-05-12 17:50:50.798924
[3 rows x 5 columns]
2025-05-12 17:50:50,824 - 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-12 17:50:51,377 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1644 2025-05-08 1911.67
1645 2025-05-09 1921.67
1646 2025-05-10 1921.67
1647 2025-05-11 1921.67
1648 2025-05-12 1945.00
2025-05-12 17:50:51,424 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1646 2025-05-10 1921.67 ... 2025-05-12 17:50:51.416986 2025-05-12 17:50:51.417381
1647 2025-05-11 1921.67 ... 2025-05-12 17:50:51.416986 2025-05-12 17:50:51.417381
1648 2025-05-12 1945.00 ... 2025-05-12 17:50:51.416986 2025-05-12 17:50:51.417381
[3 rows x 5 columns]
2025-05-12 17:50:51,443 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-05-12 17:50:51,450 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1644 2025-05-08 1911.67
1645 2025-05-09 1921.67
1646 2025-05-10 1921.67
1647 2025-05-11 1921.67
1648 2025-05-12 1945.00
2025-05-12 17:50:51,497 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1650 2025-05-10 1921.67 ... 2025-05-12 17:50:51.489799 2025-05-12 17:50:51.490209
1651 2025-05-11 1921.67 ... 2025-05-12 17:50:51.489799 2025-05-12 17:50:51.490209
1652 2025-05-12 1945.00 ... 2025-05-12 17:50:51.489799 2025-05-12 17:50:51.490209
[3 rows x 5 columns]
2025-05-12 17:50:51,516 - 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-12 17:50:52,181 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2716 2025-05-08 125050.00
2717 2025-05-09 124758.33
2718 2025-05-10 124758.33
2719 2025-05-11 124758.33
2720 2025-05-12 126525.00
2025-05-12 17:50:52,239 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2718 2025-05-10 ... 2025-05-12 17:50:52.233472
2719 2025-05-11 ... 2025-05-12 17:50:52.233472
2720 2025-05-12 ... 2025-05-12 17:50:52.233472
[3 rows x 5 columns]
2025-05-12 17:50:52,259 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-05-12 17:50:52,265 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2716 2025-05-08 125050.00
2717 2025-05-09 124758.33
2718 2025-05-10 124758.33
2719 2025-05-11 124758.33
2720 2025-05-12 126525.00
2025-05-12 17:50:52,324 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2721 2025-05-10 ... 2025-05-12 17:50:52.317638
2722 2025-05-11 ... 2025-05-12 17:50:52.317638
2723 2025-05-12 ... 2025-05-12 17:50:52.317638
[3 rows x 5 columns]
2025-05-12 17:50:52,342 - 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-12 17:50:52,910 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3741 2025-05-08 4632.0
3742 2025-05-09 4629.0
3743 2025-05-10 4629.0
3744 2025-05-11 4629.0
3745 2025-05-12 4604.0
2025-05-12 17:50:52,983 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3743 2025-05-10 4629.0 ... 2025-05-12 17:50:52.976146 2025-05-12 17:50:52.976533
3744 2025-05-11 4629.0 ... 2025-05-12 17:50:52.976146 2025-05-12 17:50:52.976533
3745 2025-05-12 4604.0 ... 2025-05-12 17:50:52.976146 2025-05-12 17:50:52.976533
[3 rows x 5 columns]
2025-05-12 17:50:53,003 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-05-12 17:50:53,009 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3741 2025-05-08 4632.0
3742 2025-05-09 4629.0
3743 2025-05-10 4629.0
3744 2025-05-11 4629.0
3745 2025-05-12 4604.0
2025-05-12 17:50:53,082 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3746 2025-05-10 4629.0 ... 2025-05-12 17:50:53.075306 2025-05-12 17:50:53.075689
3747 2025-05-11 4629.0 ... 2025-05-12 17:50:53.075306 2025-05-12 17:50:53.075689
3748 2025-05-12 4604.0 ... 2025-05-12 17:50:53.075306 2025-05-12 17:50:53.075689
[3 rows x 5 columns]
2025-05-12 17:50:53,178 - 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-12 17:50:53,704 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
2980 2025-05-08 7440.0
2981 2025-05-09 7440.0
2982 2025-05-10 7440.0
2983 2025-05-11 7440.0
2984 2025-05-12 7440.0
2025-05-12 17:50:53,770 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
2982 2025-05-10 7440.0 ... 2025-05-12 17:50:53.762243 2025-05-12 17:50:53.762630
2983 2025-05-11 7440.0 ... 2025-05-12 17:50:53.762243 2025-05-12 17:50:53.762630
2984 2025-05-12 7440.0 ... 2025-05-12 17:50:53.762243 2025-05-12 17:50:53.762630
[3 rows x 5 columns]
2025-05-12 17:50:53,789 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-05-12 17:50:53,795 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
2980 2025-05-08 7440.0
2981 2025-05-09 7440.0
2982 2025-05-10 7440.0
2983 2025-05-11 7440.0
2984 2025-05-12 7440.0
2025-05-12 17:50:53,859 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
2985 2025-05-10 7440.0 ... 2025-05-12 17:50:53.851454 2025-05-12 17:50:53.851876
2986 2025-05-11 7440.0 ... 2025-05-12 17:50:53.851454 2025-05-12 17:50:53.851876
2987 2025-05-12 7440.0 ... 2025-05-12 17:50:53.851454 2025-05-12 17:50:53.851876
[3 rows x 5 columns]
2025-05-12 17:50:53,878 - 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-12 17:50:54,427 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3742 2025-05-08 14150.33
3743 2025-05-09 14136.00
3744 2025-05-10 14136.00
3745 2025-05-11 14136.00
3746 2025-05-12 14200.83
2025-05-12 17:50:54,501 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date ... updated_at
3744 2025-05-10 ... 2025-05-12 17:50:54.493993
3745 2025-05-11 ... 2025-05-12 17:50:54.493993
3746 2025-05-12 ... 2025-05-12 17:50:54.493993
[3 rows x 5 columns]
2025-05-12 17:50:54,520 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-05-12 17:50:54,527 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3742 2025-05-08 14150.33
3743 2025-05-09 14136.00
3744 2025-05-10 14136.00
3745 2025-05-11 14136.00
3746 2025-05-12 14200.83
2025-05-12 17:50:54,601 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date ... updated_at
3748 2025-05-10 ... 2025-05-12 17:50:54.594375
3749 2025-05-11 ... 2025-05-12 17:50:54.594375
3750 2025-05-12 ... 2025-05-12 17:50:54.594375
[3 rows x 5 columns]
2025-05-12 17:50:54,620 - 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-12 17:50:55,192 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3687 2025-05-08 16737.50
3688 2025-05-09 16718.75
3689 2025-05-10 16718.75
3690 2025-05-11 16718.75
3691 2025-05-12 16806.25
2025-05-12 17:50:55,263 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date ... updated_at
3689 2025-05-10 ... 2025-05-12 17:50:55.257194
3690 2025-05-11 ... 2025-05-12 17:50:55.257194
3691 2025-05-12 ... 2025-05-12 17:50:55.257194
[3 rows x 5 columns]
2025-05-12 17:50:55,305 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-05-12 17:50:55,312 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3687 2025-05-08 16737.50
3688 2025-05-09 16718.75
3689 2025-05-10 16718.75
3690 2025-05-11 16718.75
3691 2025-05-12 16806.25
2025-05-12 17:50:55,386 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date ... updated_at
3692 2025-05-10 ... 2025-05-12 17:50:55.379416
3693 2025-05-11 ... 2025-05-12 17:50:55.379416
3694 2025-05-12 ... 2025-05-12 17:50:55.379416
[3 rows x 5 columns]
2025-05-12 17:50:55,406 - 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-12 17:50:55,944 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
2962 2025-05-08 3276.67
2963 2025-05-09 3273.33
2964 2025-05-10 3273.33
2965 2025-05-11 3273.33
2966 2025-05-12 3256.67
2025-05-12 17:50:56,009 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
2964 2025-05-10 3273.33 ... 2025-05-12 17:50:56.002064 2025-05-12 17:50:56.002459
2965 2025-05-11 3273.33 ... 2025-05-12 17:50:56.002064 2025-05-12 17:50:56.002459
2966 2025-05-12 3256.67 ... 2025-05-12 17:50:56.002064 2025-05-12 17:50:56.002459
[3 rows x 5 columns]
2025-05-12 17:50:56,029 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-05-12 17:50:56,036 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
2962 2025-05-08 3276.67
2963 2025-05-09 3273.33
2964 2025-05-10 3273.33
2965 2025-05-11 3273.33
2966 2025-05-12 3256.67
2025-05-12 17:50:56,102 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
2967 2025-05-10 3273.33 ... 2025-05-12 17:50:56.094968 2025-05-12 17:50:56.095379
2968 2025-05-11 3273.33 ... 2025-05-12 17:50:56.094968 2025-05-12 17:50:56.095379
2969 2025-05-12 3256.67 ... 2025-05-12 17:50:56.094968 2025-05-12 17:50:56.095379
[3 rows x 5 columns]
2025-05-12 17:50:56,122 - 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-12 17:50:56,781 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3242 2025-05-08 5450.0
3243 2025-05-09 5470.0
3244 2025-05-10 5470.0
3245 2025-05-11 5470.0
3246 2025-05-12 5470.0
2025-05-12 17:50:56,849 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3244 2025-05-10 5470.0 ... 2025-05-12 17:50:56.841303 2025-05-12 17:50:56.841693
3245 2025-05-11 5470.0 ... 2025-05-12 17:50:56.841303 2025-05-12 17:50:56.841693
3246 2025-05-12 5470.0 ... 2025-05-12 17:50:56.841303 2025-05-12 17:50:56.841693
[3 rows x 5 columns]
2025-05-12 17:50:56,868 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-05-12 17:50:56,875 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3242 2025-05-08 5450.0
3243 2025-05-09 5470.0
3244 2025-05-10 5470.0
3245 2025-05-11 5470.0
3246 2025-05-12 5470.0
2025-05-12 17:50:56,950 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3731 2025-05-10 5470.0 ... 2025-05-12 17:50:56.942438 2025-05-12 17:50:56.942855
3732 2025-05-11 5470.0 ... 2025-05-12 17:50:56.942438 2025-05-12 17:50:56.942855
3733 2025-05-12 5470.0 ... 2025-05-12 17:50:56.942438 2025-05-12 17:50:56.942855
[3 rows x 5 columns]
2025-05-12 17:50:56,969 - 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-12 17:50:57,592 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1306 2025-05-08 14830.0
1307 2025-05-09 14780.0
1308 2025-05-10 14780.0
1309 2025-05-11 14780.0
1310 2025-05-12 14750.0
2025-05-12 17:50:57,636 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1308 2025-05-10 14780.0 ... 2025-05-12 17:50:57.628262 2025-05-12 17:50:57.628656
1309 2025-05-11 14780.0 ... 2025-05-12 17:50:57.628262 2025-05-12 17:50:57.628656
1310 2025-05-12 14750.0 ... 2025-05-12 17:50:57.628262 2025-05-12 17:50:57.628656
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-12 17:50:57,877 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-05-12 17:50:57.868890
117 2021-07-06 ... 2025-05-12 17:50:57.868890
121 2021-07-12 ... 2025-05-12 17:50:57.868890
122 2021-07-13 ... 2025-05-12 17:50:57.868890
194 2021-11-01 ... 2025-05-12 17:50:57.868890
[5 rows x 6 columns]
2025-05-12 17:50:57,914 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1306 2025-05-08 14830.0
1307 2025-05-09 14780.0
1308 2025-05-10 14780.0
1309 2025-05-11 14780.0
1310 2025-05-12 14750.0
2025-05-12 17:50:57,959 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1311 2025-05-10 14780.0 ... 2025-05-12 17:50:57.951212 2025-05-12 17:50:57.951644
1312 2025-05-11 14780.0 ... 2025-05-12 17:50:57.951212 2025-05-12 17:50:57.951644
1313 2025-05-12 14750.0 ... 2025-05-12 17:50:57.951212 2025-05-12 17:50:57.951644
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-12 17:50:58,201 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-05-12 17:50:58.192637
117 2021-07-06 ... 2025-05-12 17:50:58.192637
121 2021-07-12 ... 2025-05-12 17:50:58.192637
122 2021-07-13 ... 2025-05-12 17:50:58.192637
194 2021-11-01 ... 2025-05-12 17:50:58.192637
[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-12 17:50:58,786 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3738 2025-05-08 78458.33
3739 2025-05-09 78258.33
3740 2025-05-10 78258.33
3741 2025-05-11 78258.33
3742 2025-05-12 78425.00
2025-05-12 17:50:58,861 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date ... updated_at
3740 2025-05-10 ... 2025-05-12 17:50:58.854530
3741 2025-05-11 ... 2025-05-12 17:50:58.854530
3742 2025-05-12 ... 2025-05-12 17:50:58.854530
[3 rows x 5 columns]
2025-05-12 17:50:58,880 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-05-12 17:50:58,886 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3738 2025-05-08 78458.33
3739 2025-05-09 78258.33
3740 2025-05-10 78258.33
3741 2025-05-11 78258.33
3742 2025-05-12 78425.00
2025-05-12 17:50:58,959 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date ... updated_at
3743 2025-05-10 ... 2025-05-12 17:50:58.952580
3744 2025-05-11 ... 2025-05-12 17:50:58.952580
3745 2025-05-12 ... 2025-05-12 17:50:58.952580
[3 rows x 5 columns]
2025-05-12 17:50:58,978 - 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-12 17:50:59,468 - 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-12 17:50:59,521 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-05-12 17:50:59,521 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-05-12 17:50:59,526 - 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-12 17:50:59,587 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-05-12 17:50:59,587 - 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-12 17:51:00,171 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2716 2025-05-08 262050.0
2717 2025-05-09 259500.0
2718 2025-05-10 259500.0
2719 2025-05-11 259500.0
2720 2025-05-12 262537.5
2025-05-12 17:51:00,231 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2718 2025-05-10 ... 2025-05-12 17:51:00.224510
2719 2025-05-11 ... 2025-05-12 17:51:00.224510
2720 2025-05-12 ... 2025-05-12 17:51:00.224510
[3 rows x 5 columns]
2025-05-12 17:51:00,250 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-05-12 17:51:00,256 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2716 2025-05-08 262050.0
2717 2025-05-09 259500.0
2718 2025-05-10 259500.0
2719 2025-05-11 259500.0
2720 2025-05-12 262537.5
2025-05-12 17:51:00,320 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2721 2025-05-10 ... 2025-05-12 17:51:00.313087
2722 2025-05-11 ... 2025-05-12 17:51:00.313087
2723 2025-05-12 ... 2025-05-12 17:51:00.313087
[3 rows x 5 columns]
2025-05-12 17:51:00,338 - 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-12 17:51:00,967 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3737 2025-05-08 22832.0
3738 2025-05-09 22756.0
3739 2025-05-10 22756.0
3740 2025-05-11 22756.0
3741 2025-05-12 22730.0
2025-05-12 17:51:01,043 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3739 2025-05-10 22756.0 ... 2025-05-12 17:51:01.035206 2025-05-12 17:51:01.035605
3740 2025-05-11 22756.0 ... 2025-05-12 17:51:01.035206 2025-05-12 17:51:01.035605
3741 2025-05-12 22730.0 ... 2025-05-12 17:51:01.035206 2025-05-12 17:51:01.035605
[3 rows x 5 columns]
2025-05-12 17:51:01,062 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-05-12 17:51:01,069 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3737 2025-05-08 22832.0
3738 2025-05-09 22756.0
3739 2025-05-10 22756.0
3740 2025-05-11 22756.0
3741 2025-05-12 22730.0
2025-05-12 17:51:01,143 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3742 2025-05-10 22756.0 ... 2025-05-12 17:51:01.135322 2025-05-12 17:51:01.135716
3743 2025-05-11 22756.0 ... 2025-05-12 17:51:01.135322 2025-05-12 17:51:01.135716
3744 2025-05-12 22730.0 ... 2025-05-12 17:51:01.135322 2025-05-12 17:51:01.135716
[3 rows x 5 columns]
2025-05-12 17:51:01,162 - 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-12 17:51:01,693 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3700 2025-05-08 3367.5
3701 2025-05-09 3367.5
3702 2025-05-10 3367.5
3703 2025-05-11 3367.5
3704 2025-05-12 3342.5
2025-05-12 17:51:01,769 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3702 2025-05-10 3367.5 ... 2025-05-12 17:51:01.761750 2025-05-12 17:51:01.762179
3703 2025-05-11 3367.5 ... 2025-05-12 17:51:01.761750 2025-05-12 17:51:01.762179
3704 2025-05-12 3342.5 ... 2025-05-12 17:51:01.761750 2025-05-12 17:51:01.762179
[3 rows x 5 columns]
2025-05-12 17:51:01,788 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-05-12 17:51:01,794 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3700 2025-05-08 3367.5
3701 2025-05-09 3367.5
3702 2025-05-10 3367.5
3703 2025-05-11 3367.5
3704 2025-05-12 3342.5
2025-05-12 17:51:01,870 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3705 2025-05-10 3367.5 ... 2025-05-12 17:51:01.860547 2025-05-12 17:51:01.861026
3706 2025-05-11 3367.5 ... 2025-05-12 17:51:01.860547 2025-05-12 17:51:01.861026
3707 2025-05-12 3342.5 ... 2025-05-12 17:51:01.860547 2025-05-12 17:51:01.861026
[3 rows x 5 columns]
2025-05-12 17:51:01,890 - 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-12 17:51:02,516 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1497 2025-05-08 4917.5
1498 2025-05-09 4917.5
1499 2025-05-10 4917.5
1500 2025-05-11 4917.5
1501 2025-05-12 4905.0
2025-05-12 17:51:02,562 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1499 2025-05-10 4917.5 ... 2025-05-12 17:51:02.555001 2025-05-12 17:51:02.555395
1500 2025-05-11 4917.5 ... 2025-05-12 17:51:02.555001 2025-05-12 17:51:02.555395
1501 2025-05-12 4905.0 ... 2025-05-12 17:51:02.555001 2025-05-12 17:51:02.555395
[3 rows x 5 columns]
2025-05-12 17:51:02,582 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-05-12 17:51:02,587 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1497 2025-05-08 4917.5
1498 2025-05-09 4917.5
1499 2025-05-10 4917.5
1500 2025-05-11 4917.5
1501 2025-05-12 4905.0
2025-05-12 17:51:02,631 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1502 2025-05-10 4917.5 ... 2025-05-12 17:51:02.624636 2025-05-12 17:51:02.625051
1503 2025-05-11 4917.5 ... 2025-05-12 17:51:02.624636 2025-05-12 17:51:02.625051
1504 2025-05-12 4905.0 ... 2025-05-12 17:51:02.624636 2025-05-12 17:51:02.625051
[3 rows x 5 columns]
2025-05-12 17:51:02,651 - 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-12 17:51:03,166 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2771 2025-05-08 2285.71
2772 2025-05-09 2292.86
2773 2025-05-10 2292.86
2774 2025-05-11 2292.86
2775 2025-05-12 2298.57
2025-05-12 17:51:03,228 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2773 2025-05-10 2292.86 ... 2025-05-12 17:51:03.220361 2025-05-12 17:51:03.220776
2774 2025-05-11 2292.86 ... 2025-05-12 17:51:03.220361 2025-05-12 17:51:03.220776
2775 2025-05-12 2298.57 ... 2025-05-12 17:51:03.220361 2025-05-12 17:51:03.220776
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-12 17:51:03,273 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2772 2025-05-09 ... 2025-05-12 17:51:03.265486
[1 rows x 6 columns]
2025-05-12 17:51:03,297 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2771 2025-05-08 2285.71
2772 2025-05-09 2292.86
2773 2025-05-10 2292.86
2774 2025-05-11 2292.86
2775 2025-05-12 2298.57
2025-05-12 17:51:03,358 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2776 2025-05-10 2292.86 ... 2025-05-12 17:51:03.350731 2025-05-12 17:51:03.351167
2777 2025-05-11 2292.86 ... 2025-05-12 17:51:03.350731 2025-05-12 17:51:03.351167
2778 2025-05-12 2298.57 ... 2025-05-12 17:51:03.350731 2025-05-12 17:51:03.351167
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-05-12 17:51:03,400 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2775 2025-05-09 ... 2025-05-12 17:51:03.392649
[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-12 17:51:03,972 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2771 2025-05-08 2285.71
2772 2025-05-09 2292.86
2773 2025-05-10 2292.86
2774 2025-05-11 2292.86
2775 2025-05-12 2926.00
2025-05-12 17:51:04,025 - 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-12 17:51:04,048 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2775 2025-05-12 ... 2025-05-12 17:51:04.040676
[1 rows x 6 columns]
2025-05-12 17:51:04,072 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2771 2025-05-08 2285.71
2772 2025-05-09 2292.86
2773 2025-05-10 2292.86
2774 2025-05-11 2292.86
2775 2025-05-12 2926.00
2025-05-12 17:51:04,124 - 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-12 17:51:04,147 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2778 2025-05-12 ... 2025-05-12 17:51:04.140111
[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-12 17:51:04,665 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3128 2025-05-08 9471.67
3129 2025-05-09 9463.33
3130 2025-05-10 9463.33
3131 2025-05-11 9463.33
3132 2025-05-12 9446.67
2025-05-12 17:51:04,720 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-05-12 17:51:04,720 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-05-12 17:51:04,726 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3128 2025-05-08 9471.67
3129 2025-05-09 9463.33
3130 2025-05-10 9463.33
3131 2025-05-11 9463.33
3132 2025-05-12 9446.67
2025-05-12 17:51:04,783 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-05-12 17:51:04,783 - 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-12 17:51:05,302 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1812 2025-05-08 4340.00
1813 2025-05-09 4340.00
1814 2025-05-10 4340.00
1815 2025-05-11 4340.00
1816 2025-05-12 4408.33
2025-05-12 17:51:05,352 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1814 2025-05-10 4340.00 ... 2025-05-12 17:51:05.344810 2025-05-12 17:51:05.345207
1815 2025-05-11 4340.00 ... 2025-05-12 17:51:05.344810 2025-05-12 17:51:05.345207
1816 2025-05-12 4408.33 ... 2025-05-12 17:51:05.344810 2025-05-12 17:51:05.345207
[3 rows x 5 columns]
2025-05-12 17:51:05,371 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-05-12 17:51:05,377 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1812 2025-05-08 4340.00
1813 2025-05-09 4340.00
1814 2025-05-10 4340.00
1815 2025-05-11 4340.00
1816 2025-05-12 4408.33
2025-05-12 17:51:05,427 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1817 2025-05-10 4340.00 ... 2025-05-12 17:51:05.420182 2025-05-12 17:51:05.420563
1818 2025-05-11 4340.00 ... 2025-05-12 17:51:05.420182 2025-05-12 17:51:05.420563
1819 2025-05-12 4408.33 ... 2025-05-12 17:51:05.420182 2025-05-12 17:51:05.420563
[3 rows x 5 columns]
2025-05-12 17:51:05,447 - 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-12 17:51:05,997 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1821 2025-05-08 6200.0
1822 2025-05-09 6200.0
1823 2025-05-10 6200.0
1824 2025-05-11 6200.0
1825 2025-05-12 6200.0
2025-05-12 17:51:06,045 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1823 2025-05-10 6200.0 ... 2025-05-12 17:51:06.037957 2025-05-12 17:51:06.038351
1824 2025-05-11 6200.0 ... 2025-05-12 17:51:06.037957 2025-05-12 17:51:06.038351
1825 2025-05-12 6200.0 ... 2025-05-12 17:51:06.037957 2025-05-12 17:51:06.038351
[3 rows x 5 columns]
2025-05-12 17:51:06,065 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-05-12 17:51:06,071 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1821 2025-05-08 6200.0
1822 2025-05-09 6200.0
1823 2025-05-10 6200.0
1824 2025-05-11 6200.0
1825 2025-05-12 6200.0
2025-05-12 17:51:06,121 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1826 2025-05-10 6200.0 ... 2025-05-12 17:51:06.113790 2025-05-12 17:51:06.114203
1827 2025-05-11 6200.0 ... 2025-05-12 17:51:06.113790 2025-05-12 17:51:06.114203
1828 2025-05-12 6200.0 ... 2025-05-12 17:51:06.113790 2025-05-12 17:51:06.114203
[3 rows x 5 columns]
2025-05-12 17:51:06,140 - 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-12 17:51:06,688 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3489 2025-05-08 8538.0
3490 2025-05-09 8510.0
3491 2025-05-10 8510.0
3492 2025-05-11 8510.0
3493 2025-05-12 8610.0
2025-05-12 17:51:06,758 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3491 2025-05-10 8510.0 ... 2025-05-12 17:51:06.750787 2025-05-12 17:51:06.751191
3492 2025-05-11 8510.0 ... 2025-05-12 17:51:06.750787 2025-05-12 17:51:06.751191
3493 2025-05-12 8610.0 ... 2025-05-12 17:51:06.750787 2025-05-12 17:51:06.751191
[3 rows x 5 columns]
2025-05-12 17:51:06,777 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-05-12 17:51:06,784 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3489 2025-05-08 8538.0
3490 2025-05-09 8510.0
3491 2025-05-10 8510.0
3492 2025-05-11 8510.0
3493 2025-05-12 8610.0
2025-05-12 17:51:06,854 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3494 2025-05-10 8510.0 ... 2025-05-12 17:51:06.846247 2025-05-12 17:51:06.846634
3495 2025-05-11 8510.0 ... 2025-05-12 17:51:06.846247 2025-05-12 17:51:06.846634
3496 2025-05-12 8610.0 ... 2025-05-12 17:51:06.846247 2025-05-12 17:51:06.846634
[3 rows x 5 columns]
2025-05-12 17:51:06,876 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data