=========================================================================
2025-08-18 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-08-18 17:50:28,693 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3395 2025-08-14 3315.5
3396 2025-08-15 3272.0
3397 2025-08-16 3272.0
3398 2025-08-17 3272.0
3399 2025-08-18 3267.0
2025-08-18 17:50:28,772 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3397 2025-08-16 3272.0 ... 2025-08-18 17:50:28.763547 2025-08-18 17:50:28.764048
3398 2025-08-17 3272.0 ... 2025-08-18 17:50:28.763547 2025-08-18 17:50:28.764048
3399 2025-08-18 3267.0 ... 2025-08-18 17:50:28.763547 2025-08-18 17:50:28.764048
[3 rows x 5 columns]
2025-08-18 17:50:28,792 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-08-18 17:50:28,799 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3395 2025-08-14 3315.5
3396 2025-08-15 3272.0
3397 2025-08-16 3272.0
3398 2025-08-17 3272.0
3399 2025-08-18 3267.0
2025-08-18 17:50:28,870 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3400 2025-08-16 3272.0 ... 2025-08-18 17:50:28.862317 2025-08-18 17:50:28.862750
3401 2025-08-17 3272.0 ... 2025-08-18 17:50:28.862317 2025-08-18 17:50:28.862750
3402 2025-08-18 3267.0 ... 2025-08-18 17:50:28.862317 2025-08-18 17:50:28.862750
[3 rows x 5 columns]
2025-08-18 17:50:28,889 - 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-08-18 17:50:29,488 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3616 2025-08-14 2346.67
3617 2025-08-15 2338.33
3618 2025-08-16 2338.33
3619 2025-08-17 2338.33
3620 2025-08-18 2318.67
2025-08-18 17:50:29,558 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3618 2025-08-16 2338.33 ... 2025-08-18 17:50:29.551015 2025-08-18 17:50:29.551429
3619 2025-08-17 2338.33 ... 2025-08-18 17:50:29.551015 2025-08-18 17:50:29.551429
3620 2025-08-18 2318.67 ... 2025-08-18 17:50:29.551015 2025-08-18 17:50:29.551429
[3 rows x 5 columns]
2025-08-18 17:50:29,582 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-08-18 17:50:29,589 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3616 2025-08-14 2346.67
3617 2025-08-15 2338.33
3618 2025-08-16 2338.33
3619 2025-08-17 2338.33
3620 2025-08-18 2318.67
2025-08-18 17:50:29,659 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3622 2025-08-16 2338.33 ... 2025-08-18 17:50:29.651947 2025-08-18 17:50:29.652330
3623 2025-08-17 2338.33 ... 2025-08-18 17:50:29.651947 2025-08-18 17:50:29.652330
3624 2025-08-18 2318.67 ... 2025-08-18 17:50:29.651947 2025-08-18 17:50:29.652330
[3 rows x 5 columns]
2025-08-18 17:50:29,679 - 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-08-18 17:50:30,289 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
956 2025-08-14 4717.50
957 2025-08-15 4726.88
958 2025-08-16 4726.88
959 2025-08-17 4726.88
960 2025-08-18 4720.25
2025-08-18 17:50:30,332 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
958 2025-08-16 4726.88 ... 2025-08-18 17:50:30.324108 2025-08-18 17:50:30.324505
959 2025-08-17 4726.88 ... 2025-08-18 17:50:30.324108 2025-08-18 17:50:30.324505
960 2025-08-18 4720.25 ... 2025-08-18 17:50:30.324108 2025-08-18 17:50:30.324505
[3 rows x 5 columns]
2025-08-18 17:50:30,351 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-08-18 17:50:30,357 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
956 2025-08-14 4717.50
957 2025-08-15 4726.88
958 2025-08-16 4726.88
959 2025-08-17 4726.88
960 2025-08-18 4720.25
2025-08-18 17:50:30,394 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
958 2025-08-16 4726.88 ... 2025-08-18 17:50:30.387356 2025-08-18 17:50:30.387797
959 2025-08-17 4726.88 ... 2025-08-18 17:50:30.387356 2025-08-18 17:50:30.387797
960 2025-08-18 4720.25 ... 2025-08-18 17:50:30.387356 2025-08-18 17:50:30.387797
[3 rows x 5 columns]
2025-08-18 17:50:30,414 - 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-08-18 17:50:31,106 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3835 2025-08-14 14775.00
3836 2025-08-15 14900.00
3837 2025-08-16 14900.00
3838 2025-08-17 14900.00
3839 2025-08-18 14891.67
2025-08-18 17:50:31,178 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3837 2025-08-16 ... 2025-08-18 17:50:31.171818
3838 2025-08-17 ... 2025-08-18 17:50:31.171818
3839 2025-08-18 ... 2025-08-18 17:50:31.171818
[3 rows x 5 columns]
2025-08-18 17:50:31,197 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-08-18 17:50:31,204 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3835 2025-08-14 14775.00
3836 2025-08-15 14900.00
3837 2025-08-16 14900.00
3838 2025-08-17 14900.00
3839 2025-08-18 14891.67
2025-08-18 17:50:31,278 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3840 2025-08-16 ... 2025-08-18 17:50:31.272021
3841 2025-08-17 ... 2025-08-18 17:50:31.272021
3842 2025-08-18 ... 2025-08-18 17:50:31.272021
[3 rows x 5 columns]
2025-08-18 17:50:31,303 - 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-08-18 17:50:31,892 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3167 2025-08-14 798.11
3168 2025-08-15 786.67
3169 2025-08-16 787.00
3170 2025-08-17 787.00
3171 2025-08-18 789.78
2025-08-18 17:50:31,959 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3169 2025-08-16 787.00 ... 2025-08-18 17:50:31.951411 2025-08-18 17:50:31.951864
3170 2025-08-17 787.00 ... 2025-08-18 17:50:31.951411 2025-08-18 17:50:31.951864
3171 2025-08-18 789.78 ... 2025-08-18 17:50:31.951411 2025-08-18 17:50:31.951864
[3 rows x 5 columns]
2025-08-18 17:50:31,978 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-08-18 17:50:31,985 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3167 2025-08-14 798.11
3168 2025-08-15 786.67
3169 2025-08-16 787.00
3170 2025-08-17 787.00
3171 2025-08-18 789.78
2025-08-18 17:50:32,053 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3172 2025-08-16 787.00 ... 2025-08-18 17:50:32.045320 2025-08-18 17:50:32.045780
3173 2025-08-17 787.00 ... 2025-08-18 17:50:32.045320 2025-08-18 17:50:32.045780
3174 2025-08-18 789.78 ... 2025-08-18 17:50:32.045320 2025-08-18 17:50:32.045780
[3 rows x 5 columns]
2025-08-18 17:50:32,072 - 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-08-18 17:50:32,656 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3370 2025-08-14 1158.4
3371 2025-08-15 1158.4
3372 2025-08-16 1142.4
3373 2025-08-17 1142.4
3374 2025-08-18 1142.4
2025-08-18 17:50:32,725 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3372 2025-08-16 1142.4 ... 2025-08-18 17:50:32.717476 2025-08-18 17:50:32.717935
3373 2025-08-17 1142.4 ... 2025-08-18 17:50:32.717476 2025-08-18 17:50:32.717935
3374 2025-08-18 1142.4 ... 2025-08-18 17:50:32.717476 2025-08-18 17:50:32.717935
[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-08-18 17:50:34,700 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-08-18 17:50:34.692504
21 2013-01-04 ... 2025-08-18 17:50:34.692504
54 2013-02-27 ... 2025-08-18 17:50:34.692504
60 2013-03-07 ... 2025-08-18 17:50:34.692504
61 2013-03-08 ... 2025-08-18 17:50:34.692504
[5 rows x 6 columns]
2025-08-18 17:50:34,857 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3370 2025-08-14 1158.4
3371 2025-08-15 1158.4
3372 2025-08-16 1142.4
3373 2025-08-17 1142.4
3374 2025-08-18 1142.4
2025-08-18 17:50:34,928 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3376 2025-08-16 1142.4 ... 2025-08-18 17:50:34.921102 2025-08-18 17:50:34.921491
3377 2025-08-17 1142.4 ... 2025-08-18 17:50:34.921102 2025-08-18 17:50:34.921491
3378 2025-08-18 1142.4 ... 2025-08-18 17:50:34.921102 2025-08-18 17:50:34.921491
[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-08-18 17:50:36,895 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-08-18 17:50:36.887689
21 2013-01-04 ... 2025-08-18 17:50:36.887689
54 2013-02-27 ... 2025-08-18 17:50:36.887689
60 2013-03-07 ... 2025-08-18 17:50:36.887689
61 2013-03-08 ... 2025-08-18 17:50:36.887689
[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-08-18 17:50:37,672 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1715 2025-08-14 7656.0
1716 2025-08-15 7596.0
1717 2025-08-16 7596.0
1718 2025-08-17 7596.0
1719 2025-08-18 7568.0
2025-08-18 17:50:37,719 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1717 2025-08-16 7596.0 ... 2025-08-18 17:50:37.712015 2025-08-18 17:50:37.712402
1718 2025-08-17 7596.0 ... 2025-08-18 17:50:37.712015 2025-08-18 17:50:37.712402
1719 2025-08-18 7568.0 ... 2025-08-18 17:50:37.712015 2025-08-18 17:50:37.712402
[3 rows x 5 columns]
2025-08-18 17:50:37,738 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-08-18 17:50:37,744 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1715 2025-08-14 7656.0
1716 2025-08-15 7596.0
1717 2025-08-16 7596.0
1718 2025-08-17 7596.0
1719 2025-08-18 7568.0
2025-08-18 17:50:37,792 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1720 2025-08-16 7596.0 ... 2025-08-18 17:50:37.784618 2025-08-18 17:50:37.785028
1721 2025-08-17 7596.0 ... 2025-08-18 17:50:37.784618 2025-08-18 17:50:37.785028
1722 2025-08-18 7568.0 ... 2025-08-18 17:50:37.784618 2025-08-18 17:50:37.785028
[3 rows x 5 columns]
2025-08-18 17:50:37,811 - 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-08-18 17:50:38,420 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3826 2025-08-14 5966.67
3827 2025-08-15 5951.67
3828 2025-08-16 5951.67
3829 2025-08-17 5951.67
3830 2025-08-18 5950.00
2025-08-18 17:50:38,496 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3828 2025-08-16 5951.67 ... 2025-08-18 17:50:38.488645 2025-08-18 17:50:38.489097
3829 2025-08-17 5951.67 ... 2025-08-18 17:50:38.488645 2025-08-18 17:50:38.489097
3830 2025-08-18 5950.00 ... 2025-08-18 17:50:38.488645 2025-08-18 17:50:38.489097
[3 rows x 5 columns]
2025-08-18 17:50:38,517 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-08-18 17:50:38,523 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3826 2025-08-14 5966.67
3827 2025-08-15 5951.67
3828 2025-08-16 5951.67
3829 2025-08-17 5951.67
3830 2025-08-18 5950.00
2025-08-18 17:50:38,601 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3832 2025-08-16 5951.67 ... 2025-08-18 17:50:38.591737 2025-08-18 17:50:38.592317
3833 2025-08-17 5951.67 ... 2025-08-18 17:50:38.591737 2025-08-18 17:50:38.592317
3834 2025-08-18 5950.00 ... 2025-08-18 17:50:38.591737 2025-08-18 17:50:38.592317
[3 rows x 5 columns]
2025-08-18 17:50:38,623 - 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-08-18 17:50:39,221 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1716 2025-08-14 13312.5
1717 2025-08-15 13237.5
1718 2025-08-16 13237.5
1719 2025-08-17 13237.5
1720 2025-08-18 13237.5
2025-08-18 17:50:39,268 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1718 2025-08-16 13237.5 ... 2025-08-18 17:50:39.261039 2025-08-18 17:50:39.261457
1719 2025-08-17 13237.5 ... 2025-08-18 17:50:39.261039 2025-08-18 17:50:39.261457
1720 2025-08-18 13237.5 ... 2025-08-18 17:50:39.261039 2025-08-18 17:50:39.261457
[3 rows x 5 columns]
2025-08-18 17:50:39,292 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-08-18 17:50:39,298 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1716 2025-08-14 13312.5
1717 2025-08-15 13237.5
1718 2025-08-16 13237.5
1719 2025-08-17 13237.5
1720 2025-08-18 13237.5
2025-08-18 17:50:39,346 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1721 2025-08-16 13237.5 ... 2025-08-18 17:50:39.338464 2025-08-18 17:50:39.338977
1722 2025-08-17 13237.5 ... 2025-08-18 17:50:39.338464 2025-08-18 17:50:39.338977
1723 2025-08-18 13237.5 ... 2025-08-18 17:50:39.338464 2025-08-18 17:50:39.338977
[3 rows x 5 columns]
2025-08-18 17:50:39,365 - 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-08-18 17:50:39,990 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3226 2025-08-14 9956.67
3227 2025-08-15 9876.67
3228 2025-08-16 9876.67
3229 2025-08-17 9876.67
3230 2025-08-18 9948.33
2025-08-18 17:50:40,055 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date value ... created_at updated_at
3228 2025-08-16 9876.67 ... 2025-08-18 17:50:40.048092 2025-08-18 17:50:40.048483
3229 2025-08-17 9876.67 ... 2025-08-18 17:50:40.048092 2025-08-18 17:50:40.048483
3230 2025-08-18 9948.33 ... 2025-08-18 17:50:40.048092 2025-08-18 17:50:40.048483
[3 rows x 5 columns]
2025-08-18 17:50:40,075 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-08-18 17:50:40,081 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3226 2025-08-14 9956.67
3227 2025-08-15 9876.67
3228 2025-08-16 9876.67
3229 2025-08-17 9876.67
3230 2025-08-18 9948.33
2025-08-18 17:50:40,147 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date value ... created_at updated_at
3232 2025-08-16 9876.67 ... 2025-08-18 17:50:40.139520 2025-08-18 17:50:40.139943
3233 2025-08-17 9876.67 ... 2025-08-18 17:50:40.139520 2025-08-18 17:50:40.139943
3234 2025-08-18 9948.33 ... 2025-08-18 17:50:40.139520 2025-08-18 17:50:40.139943
[3 rows x 5 columns]
2025-08-18 17:50:40,166 - 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-08-18 17:50:40,773 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3349 2025-08-14 2646.67
3350 2025-08-15 2648.33
3351 2025-08-16 2648.33
3352 2025-08-17 2648.33
3353 2025-08-18 2661.67
2025-08-18 17:50:40,842 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3351 2025-08-16 2648.33 ... 2025-08-18 17:50:40.834220 2025-08-18 17:50:40.834633
3352 2025-08-17 2648.33 ... 2025-08-18 17:50:40.834220 2025-08-18 17:50:40.834633
3353 2025-08-18 2661.67 ... 2025-08-18 17:50:40.834220 2025-08-18 17:50:40.834633
[3 rows x 5 columns]
2025-08-18 17:50:40,862 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-08-18 17:50:40,868 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3349 2025-08-14 2646.67
3350 2025-08-15 2648.33
3351 2025-08-16 2648.33
3352 2025-08-17 2648.33
3353 2025-08-18 2661.67
2025-08-18 17:50:40,937 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3355 2025-08-16 2648.33 ... 2025-08-18 17:50:40.929478 2025-08-18 17:50:40.929910
3356 2025-08-17 2648.33 ... 2025-08-18 17:50:40.929478 2025-08-18 17:50:40.929910
3357 2025-08-18 2661.67 ... 2025-08-18 17:50:40.929478 2025-08-18 17:50:40.929910
[3 rows x 5 columns]
2025-08-18 17:50:40,956 - 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-08-18 17:50:41,544 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1553 2025-08-14 1290.0
1554 2025-08-15 1290.0
1555 2025-08-16 1290.0
1556 2025-08-17 1290.0
1557 2025-08-18 1290.0
2025-08-18 17:50:41,589 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1555 2025-08-16 1290.0 ... 2025-08-18 17:50:41.582091 2025-08-18 17:50:41.582480
1556 2025-08-17 1290.0 ... 2025-08-18 17:50:41.582091 2025-08-18 17:50:41.582480
1557 2025-08-18 1290.0 ... 2025-08-18 17:50:41.582091 2025-08-18 17:50:41.582480
[3 rows x 5 columns]
2025-08-18 17:50:41,609 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-08-18 17:50:41,614 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1553 2025-08-14 1290.0
1554 2025-08-15 1290.0
1555 2025-08-16 1290.0
1556 2025-08-17 1290.0
1557 2025-08-18 1290.0
2025-08-18 17:50:41,659 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1559 2025-08-16 1290.0 ... 2025-08-18 17:50:41.652354 2025-08-18 17:50:41.652769
1560 2025-08-17 1290.0 ... 2025-08-18 17:50:41.652354 2025-08-18 17:50:41.652769
1561 2025-08-18 1290.0 ... 2025-08-18 17:50:41.652354 2025-08-18 17:50:41.652769
[3 rows x 5 columns]
2025-08-18 17:50:41,677 - 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-08-18 17:50:42,285 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1466 2025-08-14 6469.67
1467 2025-08-15 6471.25
1468 2025-08-16 6471.25
1469 2025-08-17 6471.25
1470 2025-08-18 6472.50
2025-08-18 17:50:42,330 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1468 2025-08-16 6471.25 ... 2025-08-18 17:50:42.323120 2025-08-18 17:50:42.323515
1469 2025-08-17 6471.25 ... 2025-08-18 17:50:42.323120 2025-08-18 17:50:42.323515
1470 2025-08-18 6472.50 ... 2025-08-18 17:50:42.323120 2025-08-18 17:50:42.323515
[3 rows x 5 columns]
2025-08-18 17:50:42,349 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-08-18 17:50:42,355 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1466 2025-08-14 6469.67
1467 2025-08-15 6471.25
1468 2025-08-16 6471.25
1469 2025-08-17 6471.25
1470 2025-08-18 6472.50
2025-08-18 17:50:42,409 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1472 2025-08-16 6471.25 ... 2025-08-18 17:50:42.396842 2025-08-18 17:50:42.397507
1473 2025-08-17 6471.25 ... 2025-08-18 17:50:42.396842 2025-08-18 17:50:42.397507
1474 2025-08-18 6472.50 ... 2025-08-18 17:50:42.396842 2025-08-18 17:50:42.397507
[3 rows x 5 columns]
2025-08-18 17:50:42,431 - 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-08-18 17:50:43,052 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3839 2025-08-14 3126.0
3840 2025-08-15 3092.0
3841 2025-08-16 3092.0
3842 2025-08-17 3092.0
3843 2025-08-18 3114.0
2025-08-18 17:50:43,126 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3841 2025-08-16 3092.0 ... 2025-08-18 17:50:43.118324 2025-08-18 17:50:43.118747
3842 2025-08-17 3092.0 ... 2025-08-18 17:50:43.118324 2025-08-18 17:50:43.118747
3843 2025-08-18 3114.0 ... 2025-08-18 17:50:43.118324 2025-08-18 17:50:43.118747
[3 rows x 5 columns]
2025-08-18 17:50:43,145 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-08-18 17:50:43,151 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3839 2025-08-14 3126.0
3840 2025-08-15 3092.0
3841 2025-08-16 3092.0
3842 2025-08-17 3092.0
3843 2025-08-18 3114.0
2025-08-18 17:50:43,225 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3844 2025-08-16 3092.0 ... 2025-08-18 17:50:43.217606 2025-08-18 17:50:43.218014
3845 2025-08-17 3092.0 ... 2025-08-18 17:50:43.217606 2025-08-18 17:50:43.218014
3846 2025-08-18 3114.0 ... 2025-08-18 17:50:43.217606 2025-08-18 17:50:43.218014
[3 rows x 5 columns]
2025-08-18 17:50:43,244 - 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-08-18 17:50:43,860 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3609 2025-08-14 8598.0
3610 2025-08-15 8608.0
3611 2025-08-16 8608.0
3612 2025-08-17 8608.0
3613 2025-08-18 8598.0
2025-08-18 17:50:43,930 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3611 2025-08-16 8608.0 ... 2025-08-18 17:50:43.923316 2025-08-18 17:50:43.923740
3612 2025-08-17 8608.0 ... 2025-08-18 17:50:43.923316 2025-08-18 17:50:43.923740
3613 2025-08-18 8598.0 ... 2025-08-18 17:50:43.923316 2025-08-18 17:50:43.923740
[3 rows x 5 columns]
2025-08-18 17:50:43,950 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-08-18 17:50:43,957 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3609 2025-08-14 8598.0
3610 2025-08-15 8608.0
3611 2025-08-16 8608.0
3612 2025-08-17 8608.0
3613 2025-08-18 8598.0
2025-08-18 17:50:44,027 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3614 2025-08-16 8608.0 ... 2025-08-18 17:50:44.020187 2025-08-18 17:50:44.020602
3615 2025-08-17 8608.0 ... 2025-08-18 17:50:44.020187 2025-08-18 17:50:44.020602
3616 2025-08-18 8598.0 ... 2025-08-18 17:50:44.020187 2025-08-18 17:50:44.020602
[3 rows x 5 columns]
2025-08-18 17:50:44,046 - 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-08-18 17:50:44,685 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3575 2025-08-14 4300.0
3576 2025-08-15 4300.0
3577 2025-08-16 4300.0
3578 2025-08-17 4300.0
3579 2025-08-18 4300.0
2025-08-18 17:50:44,755 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3577 2025-08-16 4300.0 ... 2025-08-18 17:50:44.747611 2025-08-18 17:50:44.748006
3578 2025-08-17 4300.0 ... 2025-08-18 17:50:44.747611 2025-08-18 17:50:44.748006
3579 2025-08-18 4300.0 ... 2025-08-18 17:50:44.747611 2025-08-18 17:50:44.748006
[3 rows x 5 columns]
2025-08-18 17:50:44,783 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-08-18 17:50:44,789 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3575 2025-08-14 4300.0
3576 2025-08-15 4300.0
3577 2025-08-16 4300.0
3578 2025-08-17 4300.0
3579 2025-08-18 4300.0
2025-08-18 17:50:44,860 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3580 2025-08-16 4300.0 ... 2025-08-18 17:50:44.853362 2025-08-18 17:50:44.853796
3581 2025-08-17 4300.0 ... 2025-08-18 17:50:44.853362 2025-08-18 17:50:44.853796
3582 2025-08-18 4300.0 ... 2025-08-18 17:50:44.853362 2025-08-18 17:50:44.853796
[3 rows x 5 columns]
2025-08-18 17:50:44,879 - 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-08-18 17:50:45,543 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2952 2025-08-14 5514.29
2953 2025-08-15 5504.29
2954 2025-08-16 5504.29
2955 2025-08-17 5504.29
2956 2025-08-18 5502.86
2025-08-18 17:50:45,606 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2954 2025-08-16 5504.29 ... 2025-08-18 17:50:45.598540 2025-08-18 17:50:45.598967
2955 2025-08-17 5504.29 ... 2025-08-18 17:50:45.598540 2025-08-18 17:50:45.598967
2956 2025-08-18 5502.86 ... 2025-08-18 17:50:45.598540 2025-08-18 17:50:45.598967
[3 rows x 5 columns]
2025-08-18 17:50:45,625 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-08-18 17:50:45,630 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2952 2025-08-14 5514.29
2953 2025-08-15 5504.29
2954 2025-08-16 5504.29
2955 2025-08-17 5504.29
2956 2025-08-18 5502.86
2025-08-18 17:50:45,693 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2958 2025-08-16 5504.29 ... 2025-08-18 17:50:45.685897 2025-08-18 17:50:45.686279
2959 2025-08-17 5504.29 ... 2025-08-18 17:50:45.685897 2025-08-18 17:50:45.686279
2960 2025-08-18 5502.86 ... 2025-08-18 17:50:45.685897 2025-08-18 17:50:45.686279
[3 rows x 5 columns]
2025-08-18 17:50:45,712 - 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-08-18 17:50:46,280 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3152 2025-08-14 3200.0
3153 2025-08-15 3210.0
3154 2025-08-16 3215.0
3155 2025-08-17 3215.0
3156 2025-08-18 3350.0
2025-08-18 17:50:46,346 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3154 2025-08-16 3215.0 ... 2025-08-18 17:50:46.338657 2025-08-18 17:50:46.339090
3155 2025-08-17 3215.0 ... 2025-08-18 17:50:46.338657 2025-08-18 17:50:46.339090
3156 2025-08-18 3350.0 ... 2025-08-18 17:50:46.338657 2025-08-18 17:50:46.339090
[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-08-18 17:50:46,502 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-08-18 17:50:46.494254
458 2015-09-21 ... 2025-08-18 17:50:46.494254
549 2016-02-03 ... 2025-08-18 17:50:46.494254
693 2016-09-05 ... 2025-08-18 17:50:46.494254
696 2016-09-08 ... 2025-08-18 17:50:46.494254
[5 rows x 6 columns]
2025-08-18 17:50:46,531 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3152 2025-08-14 3200.0
3153 2025-08-15 3210.0
3154 2025-08-16 3215.0
3155 2025-08-17 3215.0
3156 2025-08-18 3350.0
2025-08-18 17:50:46,599 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3157 2025-08-16 3215.0 ... 2025-08-18 17:50:46.592516 2025-08-18 17:50:46.592934
3158 2025-08-17 3215.0 ... 2025-08-18 17:50:46.592516 2025-08-18 17:50:46.592934
3159 2025-08-18 3350.0 ... 2025-08-18 17:50:46.592516 2025-08-18 17:50:46.592934
[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-08-18 17:50:46,745 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-08-18 17:50:46.737975
458 2015-09-21 ... 2025-08-18 17:50:46.737975
549 2016-02-03 ... 2025-08-18 17:50:46.737975
693 2016-09-05 ... 2025-08-18 17:50:46.737975
696 2016-09-08 ... 2025-08-18 17:50:46.737975
[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-08-18 17:50:47,399 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
956 2025-08-14 9630.0
957 2025-08-15 9610.0
958 2025-08-16 9610.0
959 2025-08-17 9610.0
960 2025-08-18 9610.0
2025-08-18 17:50:47,438 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
958 2025-08-16 9610.0 ... 2025-08-18 17:50:47.430409 2025-08-18 17:50:47.430844
959 2025-08-17 9610.0 ... 2025-08-18 17:50:47.430409 2025-08-18 17:50:47.430844
960 2025-08-18 9610.0 ... 2025-08-18 17:50:47.430409 2025-08-18 17:50:47.430844
[3 rows x 5 columns]
2025-08-18 17:50:47,457 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-08-18 17:50:47,462 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
956 2025-08-14 9630.0
957 2025-08-15 9610.0
958 2025-08-16 9610.0
959 2025-08-17 9610.0
960 2025-08-18 9610.0
2025-08-18 17:50:47,500 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
958 2025-08-16 9610.0 ... 2025-08-18 17:50:47.492656 2025-08-18 17:50:47.493056
959 2025-08-17 9610.0 ... 2025-08-18 17:50:47.492656 2025-08-18 17:50:47.493056
960 2025-08-18 9610.0 ... 2025-08-18 17:50:47.492656 2025-08-18 17:50:47.493056
[3 rows x 5 columns]
2025-08-18 17:50:47,519 - 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-08-18 17:50:48,235 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3835 2025-08-14 7453.33
3836 2025-08-15 7448.33
3837 2025-08-16 7448.33
3838 2025-08-17 7448.33
3839 2025-08-18 7448.33
2025-08-18 17:50:48,308 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3837 2025-08-16 7448.33 ... 2025-08-18 17:50:48.301114 2025-08-18 17:50:48.301501
3838 2025-08-17 7448.33 ... 2025-08-18 17:50:48.301114 2025-08-18 17:50:48.301501
3839 2025-08-18 7448.33 ... 2025-08-18 17:50:48.301114 2025-08-18 17:50:48.301501
[3 rows x 5 columns]
2025-08-18 17:50:48,327 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-08-18 17:50:48,333 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3835 2025-08-14 7453.33
3836 2025-08-15 7448.33
3837 2025-08-16 7448.33
3838 2025-08-17 7448.33
3839 2025-08-18 7448.33
2025-08-18 17:50:48,406 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3840 2025-08-16 7448.33 ... 2025-08-18 17:50:48.398981 2025-08-18 17:50:48.399364
3841 2025-08-17 7448.33 ... 2025-08-18 17:50:48.398981 2025-08-18 17:50:48.399364
3842 2025-08-18 7448.33 ... 2025-08-18 17:50:48.398981 2025-08-18 17:50:48.399364
[3 rows x 5 columns]
2025-08-18 17:50:48,425 - 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-08-18 17:50:49,042 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3173 2025-08-14 3670.0
3174 2025-08-15 3670.0
3175 2025-08-16 3670.0
3176 2025-08-17 3670.0
3177 2025-08-18 3680.0
2025-08-18 17:50:49,107 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3176 2025-08-16 3670.0 ... 2025-08-18 17:50:49.099951 2025-08-18 17:50:49.100339
3177 2025-08-17 3670.0 ... 2025-08-18 17:50:49.099951 2025-08-18 17:50:49.100339
3178 2025-08-18 3680.0 ... 2025-08-18 17:50:49.099951 2025-08-18 17:50:49.100339
[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-08-18 17:50:49,145 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-08-18 17:50:49.137436
[1 rows x 6 columns]
2025-08-18 17:50:49,169 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3173 2025-08-14 3670.0
3174 2025-08-15 3670.0
3175 2025-08-16 3670.0
3176 2025-08-17 3670.0
3177 2025-08-18 3680.0
2025-08-18 17:50:49,234 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3178 2025-08-16 3670.0 ... 2025-08-18 17:50:49.227095 2025-08-18 17:50:49.227478
3179 2025-08-17 3670.0 ... 2025-08-18 17:50:49.227095 2025-08-18 17:50:49.227478
3180 2025-08-18 3680.0 ... 2025-08-18 17:50:49.227095 2025-08-18 17:50:49.227478
[3 rows x 5 columns]
2025-08-18 17:50:49,254 - 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-08-18 17:50:49,877 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3838 2025-08-14 20730.00
3839 2025-08-15 20726.67
3840 2025-08-16 20726.67
3841 2025-08-17 20726.67
3842 2025-08-18 20726.67
2025-08-18 17:50:49,949 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date ... updated_at
3840 2025-08-16 ... 2025-08-18 17:50:49.942891
3841 2025-08-17 ... 2025-08-18 17:50:49.942891
3842 2025-08-18 ... 2025-08-18 17:50:49.942891
[3 rows x 5 columns]
2025-08-18 17:50:49,969 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-08-18 17:50:49,975 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3838 2025-08-14 20730.00
3839 2025-08-15 20726.67
3840 2025-08-16 20726.67
3841 2025-08-17 20726.67
3842 2025-08-18 20726.67
2025-08-18 17:50:50,047 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date ... updated_at
3843 2025-08-16 ... 2025-08-18 17:50:50.041223
3844 2025-08-17 ... 2025-08-18 17:50:50.041223
3845 2025-08-18 ... 2025-08-18 17:50:50.041223
[3 rows x 5 columns]
2025-08-18 17:50:50,067 - 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-08-18 17:50:50,673 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2952 2025-08-14 5900.0
2953 2025-08-15 5870.0
2954 2025-08-16 5870.0
2955 2025-08-17 5870.0
2956 2025-08-18 5874.0
2025-08-18 17:50:50,738 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2954 2025-08-16 5870.0 ... 2025-08-18 17:50:50.730270 2025-08-18 17:50:50.730715
2955 2025-08-17 5870.0 ... 2025-08-18 17:50:50.730270 2025-08-18 17:50:50.730715
2956 2025-08-18 5874.0 ... 2025-08-18 17:50:50.730270 2025-08-18 17:50:50.730715
[3 rows x 5 columns]
2025-08-18 17:50:50,757 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-08-18 17:50:50,763 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2952 2025-08-14 5900.0
2953 2025-08-15 5870.0
2954 2025-08-16 5870.0
2955 2025-08-17 5870.0
2956 2025-08-18 5874.0
2025-08-18 17:50:50,828 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2958 2025-08-16 5870.0 ... 2025-08-18 17:50:50.820254 2025-08-18 17:50:50.820694
2959 2025-08-17 5870.0 ... 2025-08-18 17:50:50.820254 2025-08-18 17:50:50.820694
2960 2025-08-18 5874.0 ... 2025-08-18 17:50:50.820254 2025-08-18 17:50:50.820694
[3 rows x 5 columns]
2025-08-18 17:50:50,847 - 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-08-18 17:50:51,559 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2227 2025-08-14 23600.0
2228 2025-08-15 23600.0
2229 2025-08-16 23600.0
2230 2025-08-17 23600.0
2231 2025-08-18 23600.0
2025-08-18 17:50:51,614 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2229 2025-08-16 23600.0 ... 2025-08-18 17:50:51.607286 2025-08-18 17:50:51.607710
2230 2025-08-17 23600.0 ... 2025-08-18 17:50:51.607286 2025-08-18 17:50:51.607710
2231 2025-08-18 23600.0 ... 2025-08-18 17:50:51.607286 2025-08-18 17:50:51.607710
[3 rows x 5 columns]
2025-08-18 17:50:51,634 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-08-18 17:50:51,639 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2227 2025-08-14 23600.0
2228 2025-08-15 23600.0
2229 2025-08-16 23600.0
2230 2025-08-17 23600.0
2231 2025-08-18 23600.0
2025-08-18 17:50:51,691 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2233 2025-08-16 23600.0 ... 2025-08-18 17:50:51.684216 2025-08-18 17:50:51.684622
2234 2025-08-17 23600.0 ... 2025-08-18 17:50:51.684216 2025-08-18 17:50:51.684622
2235 2025-08-18 23600.0 ... 2025-08-18 17:50:51.684216 2025-08-18 17:50:51.684622
[3 rows x 5 columns]
2025-08-18 17:50:51,710 - 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-08-18 17:50:52,284 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1742 2025-08-14 1765.00
1743 2025-08-15 1762.50
1744 2025-08-16 1762.50
1745 2025-08-17 1762.50
1746 2025-08-18 1766.25
2025-08-18 17:50:52,332 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1744 2025-08-16 1762.50 ... 2025-08-18 17:50:52.324505 2025-08-18 17:50:52.324985
1745 2025-08-17 1762.50 ... 2025-08-18 17:50:52.324505 2025-08-18 17:50:52.324985
1746 2025-08-18 1766.25 ... 2025-08-18 17:50:52.324505 2025-08-18 17:50:52.324985
[3 rows x 5 columns]
2025-08-18 17:50:52,352 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-08-18 17:50:52,357 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1742 2025-08-14 1765.00
1743 2025-08-15 1762.50
1744 2025-08-16 1762.50
1745 2025-08-17 1762.50
1746 2025-08-18 1766.25
2025-08-18 17:50:52,483 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1748 2025-08-16 1762.50 ... 2025-08-18 17:50:52.475543 2025-08-18 17:50:52.475991
1749 2025-08-17 1762.50 ... 2025-08-18 17:50:52.475543 2025-08-18 17:50:52.475991
1750 2025-08-18 1766.25 ... 2025-08-18 17:50:52.475543 2025-08-18 17:50:52.475991
[3 rows x 5 columns]
2025-08-18 17:50:52,502 - 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-08-18 17:50:53,312 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2814 2025-08-14 123800.0
2815 2025-08-15 121850.0
2816 2025-08-16 121850.0
2817 2025-08-17 121850.0
2818 2025-08-18 121850.0
2025-08-18 17:50:53,372 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2816 2025-08-16 ... 2025-08-18 17:50:53.366255
2817 2025-08-17 ... 2025-08-18 17:50:53.366255
2818 2025-08-18 ... 2025-08-18 17:50:53.366255
[3 rows x 5 columns]
2025-08-18 17:50:53,392 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-08-18 17:50:53,398 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2814 2025-08-14 123800.0
2815 2025-08-15 121850.0
2816 2025-08-16 121850.0
2817 2025-08-17 121850.0
2818 2025-08-18 121850.0
2025-08-18 17:50:53,459 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2819 2025-08-16 ... 2025-08-18 17:50:53.452840
2820 2025-08-17 ... 2025-08-18 17:50:53.452840
2821 2025-08-18 ... 2025-08-18 17:50:53.452840
[3 rows x 5 columns]
2025-08-18 17:50:53,478 - 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-08-18 17:50:54,085 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3839 2025-08-14 4828.0
3840 2025-08-15 4813.0
3841 2025-08-16 4813.0
3842 2025-08-17 4813.0
3843 2025-08-18 4738.0
2025-08-18 17:50:54,161 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3841 2025-08-16 4813.0 ... 2025-08-18 17:50:54.153621 2025-08-18 17:50:54.154046
3842 2025-08-17 4813.0 ... 2025-08-18 17:50:54.153621 2025-08-18 17:50:54.154046
3843 2025-08-18 4738.0 ... 2025-08-18 17:50:54.153621 2025-08-18 17:50:54.154046
[3 rows x 5 columns]
2025-08-18 17:50:54,180 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-08-18 17:50:54,186 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3839 2025-08-14 4828.0
3840 2025-08-15 4813.0
3841 2025-08-16 4813.0
3842 2025-08-17 4813.0
3843 2025-08-18 4738.0
2025-08-18 17:50:54,262 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3844 2025-08-16 4813.0 ... 2025-08-18 17:50:54.254994 2025-08-18 17:50:54.255411
3845 2025-08-17 4813.0 ... 2025-08-18 17:50:54.254994 2025-08-18 17:50:54.255411
3846 2025-08-18 4738.0 ... 2025-08-18 17:50:54.254994 2025-08-18 17:50:54.255411
[3 rows x 5 columns]
2025-08-18 17:50:54,281 - 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-08-18 17:50:54,949 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
3078 2025-08-14 7246.67
3079 2025-08-15 7246.67
3080 2025-08-16 7246.67
3081 2025-08-17 7246.67
3082 2025-08-18 7230.00
2025-08-18 17:50:55,014 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
3080 2025-08-16 7246.67 ... 2025-08-18 17:50:55.006156 2025-08-18 17:50:55.006583
3081 2025-08-17 7246.67 ... 2025-08-18 17:50:55.006156 2025-08-18 17:50:55.006583
3082 2025-08-18 7230.00 ... 2025-08-18 17:50:55.006156 2025-08-18 17:50:55.006583
[3 rows x 5 columns]
2025-08-18 17:50:55,032 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-08-18 17:50:55,038 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
3078 2025-08-14 7246.67
3079 2025-08-15 7246.67
3080 2025-08-16 7246.67
3081 2025-08-17 7246.67
3082 2025-08-18 7230.00
2025-08-18 17:50:55,102 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
3083 2025-08-16 7246.67 ... 2025-08-18 17:50:55.095399 2025-08-18 17:50:55.095813
3084 2025-08-17 7246.67 ... 2025-08-18 17:50:55.095399 2025-08-18 17:50:55.095813
3085 2025-08-18 7230.00 ... 2025-08-18 17:50:55.095399 2025-08-18 17:50:55.095813
[3 rows x 5 columns]
2025-08-18 17:50:55,121 - 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-08-18 17:50:55,732 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3840 2025-08-14 15223.17
3841 2025-08-15 15221.67
3842 2025-08-16 15221.67
3843 2025-08-17 15221.67
3844 2025-08-18 15235.00
2025-08-18 17:50:55,806 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date ... updated_at
3842 2025-08-16 ... 2025-08-18 17:50:55.799402
3843 2025-08-17 ... 2025-08-18 17:50:55.799402
3844 2025-08-18 ... 2025-08-18 17:50:55.799402
[3 rows x 5 columns]
2025-08-18 17:50:55,826 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-08-18 17:50:55,833 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3840 2025-08-14 15223.17
3841 2025-08-15 15221.67
3842 2025-08-16 15221.67
3843 2025-08-17 15221.67
3844 2025-08-18 15235.00
2025-08-18 17:50:55,905 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date ... updated_at
3846 2025-08-16 ... 2025-08-18 17:50:55.899405
3847 2025-08-17 ... 2025-08-18 17:50:55.899405
3848 2025-08-18 ... 2025-08-18 17:50:55.899405
[3 rows x 5 columns]
2025-08-18 17:50:55,925 - 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-08-18 17:50:56,613 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3785 2025-08-14 16775.00
3786 2025-08-15 16756.25
3787 2025-08-16 16756.25
3788 2025-08-17 16756.25
3789 2025-08-18 16743.75
2025-08-18 17:50:56,685 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date ... updated_at
3787 2025-08-16 ... 2025-08-18 17:50:56.679491
3788 2025-08-17 ... 2025-08-18 17:50:56.679491
3789 2025-08-18 ... 2025-08-18 17:50:56.679491
[3 rows x 5 columns]
2025-08-18 17:50:56,705 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-08-18 17:50:56,710 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3785 2025-08-14 16775.00
3786 2025-08-15 16756.25
3787 2025-08-16 16756.25
3788 2025-08-17 16756.25
3789 2025-08-18 16743.75
2025-08-18 17:50:56,781 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date ... updated_at
3790 2025-08-16 ... 2025-08-18 17:50:56.775403
3791 2025-08-17 ... 2025-08-18 17:50:56.775403
3792 2025-08-18 ... 2025-08-18 17:50:56.775403
[3 rows x 5 columns]
2025-08-18 17:50:56,802 - 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-08-18 17:50:57,495 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
3060 2025-08-14 3510.0
3061 2025-08-15 3480.0
3062 2025-08-16 3480.0
3063 2025-08-17 3480.0
3064 2025-08-18 3510.0
2025-08-18 17:50:57,560 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
3062 2025-08-16 3480.0 ... 2025-08-18 17:50:57.552512 2025-08-18 17:50:57.552964
3063 2025-08-17 3480.0 ... 2025-08-18 17:50:57.552512 2025-08-18 17:50:57.552964
3064 2025-08-18 3510.0 ... 2025-08-18 17:50:57.552512 2025-08-18 17:50:57.552964
[3 rows x 5 columns]
2025-08-18 17:50:57,581 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-08-18 17:50:57,587 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
3060 2025-08-14 3510.0
3061 2025-08-15 3480.0
3062 2025-08-16 3480.0
3063 2025-08-17 3480.0
3064 2025-08-18 3510.0
2025-08-18 17:50:57,653 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
3065 2025-08-16 3480.0 ... 2025-08-18 17:50:57.645624 2025-08-18 17:50:57.646020
3066 2025-08-17 3480.0 ... 2025-08-18 17:50:57.645624 2025-08-18 17:50:57.646020
3067 2025-08-18 3510.0 ... 2025-08-18 17:50:57.645624 2025-08-18 17:50:57.646020
[3 rows x 5 columns]
2025-08-18 17:50:57,671 - 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-08-18 17:50:58,355 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3340 2025-08-14 5337.5
3341 2025-08-15 5337.5
3342 2025-08-16 5337.5
3343 2025-08-17 5337.5
3344 2025-08-18 5300.0
2025-08-18 17:50:58,422 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3342 2025-08-16 5337.5 ... 2025-08-18 17:50:58.415185 2025-08-18 17:50:58.415601
3343 2025-08-17 5337.5 ... 2025-08-18 17:50:58.415185 2025-08-18 17:50:58.415601
3344 2025-08-18 5300.0 ... 2025-08-18 17:50:58.415185 2025-08-18 17:50:58.415601
[3 rows x 5 columns]
2025-08-18 17:50:58,441 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-08-18 17:50:58,447 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3340 2025-08-14 5337.5
3341 2025-08-15 5337.5
3342 2025-08-16 5337.5
3343 2025-08-17 5337.5
3344 2025-08-18 5300.0
2025-08-18 17:50:58,519 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3829 2025-08-16 5337.5 ... 2025-08-18 17:50:58.512126 2025-08-18 17:50:58.512506
3830 2025-08-17 5337.5 ... 2025-08-18 17:50:58.512126 2025-08-18 17:50:58.512506
3831 2025-08-18 5300.0 ... 2025-08-18 17:50:58.512126 2025-08-18 17:50:58.512506
[3 rows x 5 columns]
2025-08-18 17:50:58,538 - 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-08-18 17:50:59,240 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1404 2025-08-14 13870.0
1405 2025-08-15 13870.0
1406 2025-08-16 13870.0
1407 2025-08-17 13870.0
1408 2025-08-18 13850.0
2025-08-18 17:50:59,284 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1406 2025-08-16 13870.0 ... 2025-08-18 17:50:59.276743 2025-08-18 17:50:59.277163
1407 2025-08-17 13870.0 ... 2025-08-18 17:50:59.276743 2025-08-18 17:50:59.277163
1408 2025-08-18 13850.0 ... 2025-08-18 17:50:59.276743 2025-08-18 17:50:59.277163
[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-08-18 17:50:59,523 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-08-18 17:50:59.514991
117 2021-07-06 ... 2025-08-18 17:50:59.514991
121 2021-07-12 ... 2025-08-18 17:50:59.514991
122 2021-07-13 ... 2025-08-18 17:50:59.514991
194 2021-11-01 ... 2025-08-18 17:50:59.514991
[5 rows x 6 columns]
2025-08-18 17:50:59,560 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1404 2025-08-14 13870.0
1405 2025-08-15 13870.0
1406 2025-08-16 13870.0
1407 2025-08-17 13870.0
1408 2025-08-18 13850.0
2025-08-18 17:50:59,604 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1409 2025-08-16 13870.0 ... 2025-08-18 17:50:59.596681 2025-08-18 17:50:59.597080
1410 2025-08-17 13870.0 ... 2025-08-18 17:50:59.596681 2025-08-18 17:50:59.597080
1411 2025-08-18 13850.0 ... 2025-08-18 17:50:59.596681 2025-08-18 17:50:59.597080
[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-08-18 17:50:59,842 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-08-18 17:50:59.834474
117 2021-07-06 ... 2025-08-18 17:50:59.834474
121 2021-07-12 ... 2025-08-18 17:50:59.834474
122 2021-07-13 ... 2025-08-18 17:50:59.834474
194 2021-11-01 ... 2025-08-18 17:50:59.834474
[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-08-18 17:51:00,530 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3836 2025-08-14 79510.0
3837 2025-08-15 79285.0
3838 2025-08-16 79285.0
3839 2025-08-17 79285.0
3840 2025-08-18 79310.0
2025-08-18 17:51:00,603 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date value ... created_at updated_at
3838 2025-08-16 79285.0 ... 2025-08-18 17:51:00.595918 2025-08-18 17:51:00.596320
3839 2025-08-17 79285.0 ... 2025-08-18 17:51:00.595918 2025-08-18 17:51:00.596320
3840 2025-08-18 79310.0 ... 2025-08-18 17:51:00.595918 2025-08-18 17:51:00.596320
[3 rows x 5 columns]
2025-08-18 17:51:00,622 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-08-18 17:51:00,628 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3836 2025-08-14 79510.0
3837 2025-08-15 79285.0
3838 2025-08-16 79285.0
3839 2025-08-17 79285.0
3840 2025-08-18 79310.0
2025-08-18 17:51:00,707 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date value ... created_at updated_at
3841 2025-08-16 79285.0 ... 2025-08-18 17:51:00.695640 2025-08-18 17:51:00.696185
3842 2025-08-17 79285.0 ... 2025-08-18 17:51:00.695640 2025-08-18 17:51:00.696185
3843 2025-08-18 79310.0 ... 2025-08-18 17:51:00.695640 2025-08-18 17:51:00.696185
[3 rows x 5 columns]
2025-08-18 17:51:00,726 - 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-08-18 17:51:01,339 - 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-08-18 17:51:01,392 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-08-18 17:51:01,392 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-08-18 17:51:01,398 - 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-08-18 17:51:01,457 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-08-18 17:51:01,457 - 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-08-18 17:51:02,144 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2814 2025-08-14 269812.5
2815 2025-08-15 266137.5
2816 2025-08-16 266137.5
2817 2025-08-17 266137.5
2818 2025-08-18 267100.0
2025-08-18 17:51:02,203 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2816 2025-08-16 ... 2025-08-18 17:51:02.197406
2817 2025-08-17 ... 2025-08-18 17:51:02.197406
2818 2025-08-18 ... 2025-08-18 17:51:02.197406
[3 rows x 5 columns]
2025-08-18 17:51:02,224 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-08-18 17:51:02,230 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2814 2025-08-14 269812.5
2815 2025-08-15 266137.5
2816 2025-08-16 266137.5
2817 2025-08-17 266137.5
2818 2025-08-18 267100.0
2025-08-18 17:51:02,290 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2819 2025-08-16 ... 2025-08-18 17:51:02.284408
2820 2025-08-17 ... 2025-08-18 17:51:02.284408
2821 2025-08-18 ... 2025-08-18 17:51:02.284408
[3 rows x 5 columns]
2025-08-18 17:51:02,309 - 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-08-18 17:51:02,985 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3835 2025-08-14 22506.0
3836 2025-08-15 22438.0
3837 2025-08-16 22438.0
3838 2025-08-17 22438.0
3839 2025-08-18 22288.0
2025-08-18 17:51:03,062 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3837 2025-08-16 22438.0 ... 2025-08-18 17:51:03.054386 2025-08-18 17:51:03.054854
3838 2025-08-17 22438.0 ... 2025-08-18 17:51:03.054386 2025-08-18 17:51:03.054854
3839 2025-08-18 22288.0 ... 2025-08-18 17:51:03.054386 2025-08-18 17:51:03.054854
[3 rows x 5 columns]
2025-08-18 17:51:03,083 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-08-18 17:51:03,090 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3835 2025-08-14 22506.0
3836 2025-08-15 22438.0
3837 2025-08-16 22438.0
3838 2025-08-17 22438.0
3839 2025-08-18 22288.0
2025-08-18 17:51:03,167 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3840 2025-08-16 22438.0 ... 2025-08-18 17:51:03.159660 2025-08-18 17:51:03.160074
3841 2025-08-17 22438.0 ... 2025-08-18 17:51:03.159660 2025-08-18 17:51:03.160074
3842 2025-08-18 22288.0 ... 2025-08-18 17:51:03.159660 2025-08-18 17:51:03.160074
[3 rows x 5 columns]
2025-08-18 17:51:03,186 - 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-08-18 17:51:03,818 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3798 2025-08-14 3442.5
3799 2025-08-15 3442.5
3800 2025-08-16 3410.0
3801 2025-08-17 3410.0
3802 2025-08-18 3415.0
2025-08-18 17:51:03,892 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3800 2025-08-16 3410.0 ... 2025-08-18 17:51:03.884643 2025-08-18 17:51:03.885048
3801 2025-08-17 3410.0 ... 2025-08-18 17:51:03.884643 2025-08-18 17:51:03.885048
3802 2025-08-18 3415.0 ... 2025-08-18 17:51:03.884643 2025-08-18 17:51:03.885048
[3 rows x 5 columns]
2025-08-18 17:51:03,912 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-08-18 17:51:03,918 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3798 2025-08-14 3442.5
3799 2025-08-15 3442.5
3800 2025-08-16 3410.0
3801 2025-08-17 3410.0
3802 2025-08-18 3415.0
2025-08-18 17:51:03,999 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3803 2025-08-16 3410.0 ... 2025-08-18 17:51:03.990078 2025-08-18 17:51:03.990596
3804 2025-08-17 3410.0 ... 2025-08-18 17:51:03.990078 2025-08-18 17:51:03.990596
3805 2025-08-18 3415.0 ... 2025-08-18 17:51:03.990078 2025-08-18 17:51:03.990596
[3 rows x 5 columns]
2025-08-18 17:51:04,022 - 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-08-18 17:51:04,612 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1595 2025-08-14 4680.0
1596 2025-08-15 4680.0
1597 2025-08-16 4680.0
1598 2025-08-17 4680.0
1599 2025-08-18 4670.0
2025-08-18 17:51:04,659 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1597 2025-08-16 4680.0 ... 2025-08-18 17:51:04.651597 2025-08-18 17:51:04.651999
1598 2025-08-17 4680.0 ... 2025-08-18 17:51:04.651597 2025-08-18 17:51:04.651999
1599 2025-08-18 4670.0 ... 2025-08-18 17:51:04.651597 2025-08-18 17:51:04.651999
[3 rows x 5 columns]
2025-08-18 17:51:04,678 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-08-18 17:51:04,685 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1595 2025-08-14 4680.0
1596 2025-08-15 4680.0
1597 2025-08-16 4680.0
1598 2025-08-17 4680.0
1599 2025-08-18 4670.0
2025-08-18 17:51:04,733 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1600 2025-08-16 4680.0 ... 2025-08-18 17:51:04.725815 2025-08-18 17:51:04.726211
1601 2025-08-17 4680.0 ... 2025-08-18 17:51:04.725815 2025-08-18 17:51:04.726211
1602 2025-08-18 4670.0 ... 2025-08-18 17:51:04.725815 2025-08-18 17:51:04.726211
[3 rows x 5 columns]
2025-08-18 17:51:04,752 - 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-08-18 17:51:05,324 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2869 2025-08-14 2320.00
2870 2025-08-15 2318.57
2871 2025-08-16 2318.57
2872 2025-08-17 2318.57
2873 2025-08-18 2317.14
2025-08-18 17:51:05,384 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2871 2025-08-16 2318.57 ... 2025-08-18 17:51:05.377443 2025-08-18 17:51:05.377867
2872 2025-08-17 2318.57 ... 2025-08-18 17:51:05.377443 2025-08-18 17:51:05.377867
2873 2025-08-18 2317.14 ... 2025-08-18 17:51:05.377443 2025-08-18 17:51:05.377867
[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-08-18 17:51:05,426 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2870 2025-08-15 ... 2025-08-18 17:51:05.419132
[1 rows x 6 columns]
2025-08-18 17:51:05,451 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2869 2025-08-14 2320.00
2870 2025-08-15 2318.57
2871 2025-08-16 2318.57
2872 2025-08-17 2318.57
2873 2025-08-18 2317.14
2025-08-18 17:51:05,514 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2874 2025-08-16 2318.57 ... 2025-08-18 17:51:05.506972 2025-08-18 17:51:05.507359
2875 2025-08-17 2318.57 ... 2025-08-18 17:51:05.506972 2025-08-18 17:51:05.507359
2876 2025-08-18 2317.14 ... 2025-08-18 17:51:05.506972 2025-08-18 17:51:05.507359
[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-08-18 17:51:05,556 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2873 2025-08-15 ... 2025-08-18 17:51:05.548878
[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-08-18 17:51:06,175 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2869 2025-08-14 2320.00
2870 2025-08-15 2318.57
2871 2025-08-16 2318.57
2872 2025-08-17 2318.57
2873 2025-08-18 2926.00
2025-08-18 17:51:06,227 - 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-08-18 17:51:06,250 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2873 2025-08-18 ... 2025-08-18 17:51:06.243009
[1 rows x 6 columns]
2025-08-18 17:51:06,275 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2869 2025-08-14 2320.00
2870 2025-08-15 2318.57
2871 2025-08-16 2318.57
2872 2025-08-17 2318.57
2873 2025-08-18 2926.00
2025-08-18 17:51:06,328 - 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-08-18 17:51:06,352 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2876 2025-08-18 ... 2025-08-18 17:51:06.345220
[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-08-18 17:51:06,866 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3226 2025-08-14 9956.67
3227 2025-08-15 9876.67
3228 2025-08-16 9876.67
3229 2025-08-17 9876.67
3230 2025-08-18 9948.33
2025-08-18 17:51:06,922 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-08-18 17:51:06,922 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-08-18 17:51:06,928 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3226 2025-08-14 9956.67
3227 2025-08-15 9876.67
3228 2025-08-16 9876.67
3229 2025-08-17 9876.67
3230 2025-08-18 9948.33
2025-08-18 17:51:06,987 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-08-18 17:51:06,987 - 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-08-18 17:51:07,712 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1910 2025-08-14 4480.00
1911 2025-08-15 4466.67
1912 2025-08-16 4466.67
1913 2025-08-17 4466.67
1914 2025-08-18 4458.33
2025-08-18 17:51:07,761 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1912 2025-08-16 4466.67 ... 2025-08-18 17:51:07.754197 2025-08-18 17:51:07.754615
1913 2025-08-17 4466.67 ... 2025-08-18 17:51:07.754197 2025-08-18 17:51:07.754615
1914 2025-08-18 4458.33 ... 2025-08-18 17:51:07.754197 2025-08-18 17:51:07.754615
[3 rows x 5 columns]
2025-08-18 17:51:07,780 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-08-18 17:51:07,786 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1910 2025-08-14 4480.00
1911 2025-08-15 4466.67
1912 2025-08-16 4466.67
1913 2025-08-17 4466.67
1914 2025-08-18 4458.33
2025-08-18 17:51:07,839 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1915 2025-08-16 4466.67 ... 2025-08-18 17:51:07.831741 2025-08-18 17:51:07.832131
1916 2025-08-17 4466.67 ... 2025-08-18 17:51:07.831741 2025-08-18 17:51:07.832131
1917 2025-08-18 4458.33 ... 2025-08-18 17:51:07.831741 2025-08-18 17:51:07.832131
[3 rows x 5 columns]
2025-08-18 17:51:07,859 - 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-08-18 17:51:08,441 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1919 2025-08-14 5876.67
1920 2025-08-15 5876.67
1921 2025-08-16 5876.67
1922 2025-08-17 5876.67
1923 2025-08-18 5876.67
2025-08-18 17:51:08,490 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1921 2025-08-16 5876.67 ... 2025-08-18 17:51:08.482703 2025-08-18 17:51:08.483104
1922 2025-08-17 5876.67 ... 2025-08-18 17:51:08.482703 2025-08-18 17:51:08.483104
1923 2025-08-18 5876.67 ... 2025-08-18 17:51:08.482703 2025-08-18 17:51:08.483104
[3 rows x 5 columns]
2025-08-18 17:51:08,509 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-08-18 17:51:08,515 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1919 2025-08-14 5876.67
1920 2025-08-15 5876.67
1921 2025-08-16 5876.67
1922 2025-08-17 5876.67
1923 2025-08-18 5876.67
2025-08-18 17:51:08,565 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1924 2025-08-16 5876.67 ... 2025-08-18 17:51:08.558140 2025-08-18 17:51:08.558544
1925 2025-08-17 5876.67 ... 2025-08-18 17:51:08.558140 2025-08-18 17:51:08.558544
1926 2025-08-18 5876.67 ... 2025-08-18 17:51:08.558140 2025-08-18 17:51:08.558544
[3 rows x 5 columns]
2025-08-18 17:51:08,584 - 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-08-18 17:51:09,263 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3587 2025-08-14 9408.0
3588 2025-08-15 9428.0
3589 2025-08-16 9428.0
3590 2025-08-17 9428.0
3591 2025-08-18 9626.0
2025-08-18 17:51:09,338 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3589 2025-08-16 9428.0 ... 2025-08-18 17:51:09.330050 2025-08-18 17:51:09.330449
3590 2025-08-17 9428.0 ... 2025-08-18 17:51:09.330050 2025-08-18 17:51:09.330449
3591 2025-08-18 9626.0 ... 2025-08-18 17:51:09.330050 2025-08-18 17:51:09.330449
[3 rows x 5 columns]
2025-08-18 17:51:09,359 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-08-18 17:51:09,366 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3587 2025-08-14 9408.0
3588 2025-08-15 9428.0
3589 2025-08-16 9428.0
3590 2025-08-17 9428.0
3591 2025-08-18 9626.0
2025-08-18 17:51:09,440 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3592 2025-08-16 9428.0 ... 2025-08-18 17:51:09.432539 2025-08-18 17:51:09.432969
3593 2025-08-17 9428.0 ... 2025-08-18 17:51:09.432539 2025-08-18 17:51:09.432969
3594 2025-08-18 9626.0 ... 2025-08-18 17:51:09.432539 2025-08-18 17:51:09.432969
[3 rows x 5 columns]
2025-08-18 17:51:09,459 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data