=========================================================================
2025-06-02 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-06-02 17:50:28,713 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3318 2025-05-29 3069.00
3319 2025-05-30 3062.22
3320 2025-05-31 3062.22
3321 2025-06-01 3062.22
3322 2025-06-02 3062.22
2025-06-02 17:50:28,795 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3320 2025-05-31 3062.22 ... 2025-06-02 17:50:28.787031 2025-06-02 17:50:28.787459
3321 2025-06-01 3062.22 ... 2025-06-02 17:50:28.787031 2025-06-02 17:50:28.787459
3322 2025-06-02 3062.22 ... 2025-06-02 17:50:28.787031 2025-06-02 17:50:28.787459
[3 rows x 5 columns]
2025-06-02 17:50:28,817 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-06-02 17:50:28,823 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3318 2025-05-29 3069.00
3319 2025-05-30 3062.22
3320 2025-05-31 3062.22
3321 2025-06-01 3062.22
3322 2025-06-02 3062.22
2025-06-02 17:50:28,899 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3323 2025-05-31 3062.22 ... 2025-06-02 17:50:28.891319 2025-06-02 17:50:28.891767
3324 2025-06-01 3062.22 ... 2025-06-02 17:50:28.891319 2025-06-02 17:50:28.891767
3325 2025-06-02 3062.22 ... 2025-06-02 17:50:28.891319 2025-06-02 17:50:28.891767
[3 rows x 5 columns]
2025-06-02 17:50:28,920 - 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-06-02 17:50:29,491 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3539 2025-05-29 2247.0
3540 2025-05-30 2245.0
3541 2025-05-31 2250.0
3542 2025-06-01 2250.0
3543 2025-06-02 2250.0
2025-06-02 17:50:29,569 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3541 2025-05-31 2250.0 ... 2025-06-02 17:50:29.561399 2025-06-02 17:50:29.561824
3542 2025-06-01 2250.0 ... 2025-06-02 17:50:29.561399 2025-06-02 17:50:29.561824
3543 2025-06-02 2250.0 ... 2025-06-02 17:50:29.561399 2025-06-02 17:50:29.561824
[3 rows x 5 columns]
2025-06-02 17:50:29,589 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-06-02 17:50:29,595 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3539 2025-05-29 2247.0
3540 2025-05-30 2245.0
3541 2025-05-31 2250.0
3542 2025-06-01 2250.0
3543 2025-06-02 2250.0
2025-06-02 17:50:29,672 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3545 2025-05-31 2250.0 ... 2025-06-02 17:50:29.665100 2025-06-02 17:50:29.665504
3546 2025-06-01 2250.0 ... 2025-06-02 17:50:29.665100 2025-06-02 17:50:29.665504
3547 2025-06-02 2250.0 ... 2025-06-02 17:50:29.665100 2025-06-02 17:50:29.665504
[3 rows x 5 columns]
2025-06-02 17:50:29,692 - 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-06-02 17:50:30,229 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
879 2025-05-29 4972.50
880 2025-05-30 4965.62
881 2025-05-31 4965.62
882 2025-06-01 4965.62
883 2025-06-02 4965.62
2025-06-02 17:50:30,268 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
881 2025-05-31 4965.62 ... 2025-06-02 17:50:30.260839 2025-06-02 17:50:30.261239
882 2025-06-01 4965.62 ... 2025-06-02 17:50:30.260839 2025-06-02 17:50:30.261239
883 2025-06-02 4965.62 ... 2025-06-02 17:50:30.260839 2025-06-02 17:50:30.261239
[3 rows x 5 columns]
2025-06-02 17:50:30,288 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-06-02 17:50:30,293 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
879 2025-05-29 4972.50
880 2025-05-30 4965.62
881 2025-05-31 4965.62
882 2025-06-01 4965.62
883 2025-06-02 4965.62
2025-06-02 17:50:30,334 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
881 2025-05-31 4965.62 ... 2025-06-02 17:50:30.326361 2025-06-02 17:50:30.326737
882 2025-06-01 4965.62 ... 2025-06-02 17:50:30.326361 2025-06-02 17:50:30.326737
883 2025-06-02 4965.62 ... 2025-06-02 17:50:30.326361 2025-06-02 17:50:30.326737
[3 rows x 5 columns]
2025-06-02 17:50:30,354 - 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-06-02 17:50:30,939 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3758 2025-05-29 13708.33
3759 2025-05-30 13308.33
3760 2025-05-31 13308.33
3761 2025-06-01 13308.33
3762 2025-06-02 13308.33
2025-06-02 17:50:31,019 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3760 2025-05-31 ... 2025-06-02 17:50:31.012839
3761 2025-06-01 ... 2025-06-02 17:50:31.012839
3762 2025-06-02 ... 2025-06-02 17:50:31.012839
[3 rows x 5 columns]
2025-06-02 17:50:31,039 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-06-02 17:50:31,045 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3758 2025-05-29 13708.33
3759 2025-05-30 13308.33
3760 2025-05-31 13308.33
3761 2025-06-01 13308.33
3762 2025-06-02 13308.33
2025-06-02 17:50:31,124 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3763 2025-05-31 ... 2025-06-02 17:50:31.116454
3764 2025-06-01 ... 2025-06-02 17:50:31.116454
3765 2025-06-02 ... 2025-06-02 17:50:31.116454
[3 rows x 5 columns]
2025-06-02 17:50:31,143 - 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-06-02 17:50:31,703 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3090 2025-05-29 753.67
3091 2025-05-30 750.33
3092 2025-05-31 750.33
3093 2025-06-01 750.33
3094 2025-06-02 750.33
2025-06-02 17:50:31,770 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3092 2025-05-31 750.33 ... 2025-06-02 17:50:31.763445 2025-06-02 17:50:31.763867
3093 2025-06-01 750.33 ... 2025-06-02 17:50:31.763445 2025-06-02 17:50:31.763867
3094 2025-06-02 750.33 ... 2025-06-02 17:50:31.763445 2025-06-02 17:50:31.763867
[3 rows x 5 columns]
2025-06-02 17:50:31,789 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-06-02 17:50:31,794 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3090 2025-05-29 753.67
3091 2025-05-30 750.33
3092 2025-05-31 750.33
3093 2025-06-01 750.33
3094 2025-06-02 750.33
2025-06-02 17:50:31,860 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3095 2025-05-31 750.33 ... 2025-06-02 17:50:31.853492 2025-06-02 17:50:31.853892
3096 2025-06-01 750.33 ... 2025-06-02 17:50:31.853492 2025-06-02 17:50:31.853892
3097 2025-06-02 750.33 ... 2025-06-02 17:50:31.853492 2025-06-02 17:50:31.853892
[3 rows x 5 columns]
2025-06-02 17:50:31,880 - 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-06-02 17:50:32,441 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3293 2025-05-29 1152.0
3294 2025-05-30 1150.4
3295 2025-05-31 1150.4
3296 2025-06-01 1150.4
3297 2025-06-02 1150.4
2025-06-02 17:50:32,510 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3295 2025-05-31 1150.4 ... 2025-06-02 17:50:32.503489 2025-06-02 17:50:32.503895
3296 2025-06-01 1150.4 ... 2025-06-02 17:50:32.503489 2025-06-02 17:50:32.503895
3297 2025-06-02 1150.4 ... 2025-06-02 17:50:32.503489 2025-06-02 17:50:32.503895
[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-06-02 17:50:34,618 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-06-02 17:50:34.610139
21 2013-01-04 ... 2025-06-02 17:50:34.610139
54 2013-02-27 ... 2025-06-02 17:50:34.610139
60 2013-03-07 ... 2025-06-02 17:50:34.610139
61 2013-03-08 ... 2025-06-02 17:50:34.610139
[5 rows x 6 columns]
2025-06-02 17:50:34,802 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3293 2025-05-29 1152.0
3294 2025-05-30 1150.4
3295 2025-05-31 1150.4
3296 2025-06-01 1150.4
3297 2025-06-02 1150.4
2025-06-02 17:50:34,871 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3299 2025-05-31 1150.4 ... 2025-06-02 17:50:34.864525 2025-06-02 17:50:34.864934
3300 2025-06-01 1150.4 ... 2025-06-02 17:50:34.864525 2025-06-02 17:50:34.864934
3301 2025-06-02 1150.4 ... 2025-06-02 17:50:34.864525 2025-06-02 17:50:34.864934
[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-06-02 17:50:36,882 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-06-02 17:50:36.874342
21 2013-01-04 ... 2025-06-02 17:50:36.874342
54 2013-02-27 ... 2025-06-02 17:50:36.874342
60 2013-03-07 ... 2025-06-02 17:50:36.874342
61 2013-03-08 ... 2025-06-02 17:50:36.874342
[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-06-02 17:50:37,675 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1638 2025-05-29 8110.0
1639 2025-05-30 8104.0
1640 2025-05-31 8104.0
1641 2025-06-01 8104.0
1642 2025-06-02 8104.0
2025-06-02 17:50:37,724 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1640 2025-05-31 8104.0 ... 2025-06-02 17:50:37.716507 2025-06-02 17:50:37.716918
1641 2025-06-01 8104.0 ... 2025-06-02 17:50:37.716507 2025-06-02 17:50:37.716918
1642 2025-06-02 8104.0 ... 2025-06-02 17:50:37.716507 2025-06-02 17:50:37.716918
[3 rows x 5 columns]
2025-06-02 17:50:37,743 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-06-02 17:50:37,750 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1638 2025-05-29 8110.0
1639 2025-05-30 8104.0
1640 2025-05-31 8104.0
1641 2025-06-01 8104.0
1642 2025-06-02 8104.0
2025-06-02 17:50:37,798 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1643 2025-05-31 8104.0 ... 2025-06-02 17:50:37.791058 2025-06-02 17:50:37.791433
1644 2025-06-01 8104.0 ... 2025-06-02 17:50:37.791058 2025-06-02 17:50:37.791433
1645 2025-06-02 8104.0 ... 2025-06-02 17:50:37.791058 2025-06-02 17:50:37.791433
[3 rows x 5 columns]
2025-06-02 17:50:37,818 - 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-06-02 17:50:38,377 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3749 2025-05-29 6130.0
3750 2025-05-30 6130.0
3751 2025-05-31 6130.0
3752 2025-06-01 6130.0
3753 2025-06-02 6130.0
2025-06-02 17:50:38,457 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3751 2025-05-31 6130.0 ... 2025-06-02 17:50:38.448942 2025-06-02 17:50:38.449382
3752 2025-06-01 6130.0 ... 2025-06-02 17:50:38.448942 2025-06-02 17:50:38.449382
3753 2025-06-02 6130.0 ... 2025-06-02 17:50:38.448942 2025-06-02 17:50:38.449382
[3 rows x 5 columns]
2025-06-02 17:50:38,477 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-06-02 17:50:38,483 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3749 2025-05-29 6130.0
3750 2025-05-30 6130.0
3751 2025-05-31 6130.0
3752 2025-06-01 6130.0
3753 2025-06-02 6130.0
2025-06-02 17:50:38,560 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3755 2025-05-31 6130.0 ... 2025-06-02 17:50:38.551940 2025-06-02 17:50:38.552329
3756 2025-06-01 6130.0 ... 2025-06-02 17:50:38.551940 2025-06-02 17:50:38.552329
3757 2025-06-02 6130.0 ... 2025-06-02 17:50:38.551940 2025-06-02 17:50:38.552329
[3 rows x 5 columns]
2025-06-02 17:50:38,580 - 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-06-02 17:50:39,127 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1639 2025-05-29 13175.0
1640 2025-05-30 13175.0
1641 2025-05-31 13175.0
1642 2025-06-01 13175.0
1643 2025-06-02 13175.0
2025-06-02 17:50:39,173 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1641 2025-05-31 13175.0 ... 2025-06-02 17:50:39.165992 2025-06-02 17:50:39.166384
1642 2025-06-01 13175.0 ... 2025-06-02 17:50:39.165992 2025-06-02 17:50:39.166384
1643 2025-06-02 13175.0 ... 2025-06-02 17:50:39.165992 2025-06-02 17:50:39.166384
[3 rows x 5 columns]
2025-06-02 17:50:39,193 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-06-02 17:50:39,198 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1639 2025-05-29 13175.0
1640 2025-05-30 13175.0
1641 2025-05-31 13175.0
1642 2025-06-01 13175.0
1643 2025-06-02 13175.0
2025-06-02 17:50:39,244 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1644 2025-05-31 13175.0 ... 2025-06-02 17:50:39.237100 2025-06-02 17:50:39.237476
1645 2025-06-01 13175.0 ... 2025-06-02 17:50:39.237100 2025-06-02 17:50:39.237476
1646 2025-06-02 13175.0 ... 2025-06-02 17:50:39.237100 2025-06-02 17:50:39.237476
[3 rows x 5 columns]
2025-06-02 17:50:39,264 - 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-06-02 17:50:39,956 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3149 2025-05-29 9530.00
3150 2025-05-30 9456.67
3151 2025-05-31 9456.67
3152 2025-06-01 9456.67
3153 2025-06-02 9456.67
2025-06-02 17:50:40,028 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date value ... created_at updated_at
3151 2025-05-31 9456.67 ... 2025-06-02 17:50:40.020604 2025-06-02 17:50:40.021060
3152 2025-06-01 9456.67 ... 2025-06-02 17:50:40.020604 2025-06-02 17:50:40.021060
3153 2025-06-02 9456.67 ... 2025-06-02 17:50:40.020604 2025-06-02 17:50:40.021060
[3 rows x 5 columns]
2025-06-02 17:50:40,049 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-06-02 17:50:40,055 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3149 2025-05-29 9530.00
3150 2025-05-30 9456.67
3151 2025-05-31 9456.67
3152 2025-06-01 9456.67
3153 2025-06-02 9456.67
2025-06-02 17:50:40,126 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date value ... created_at updated_at
3155 2025-05-31 9456.67 ... 2025-06-02 17:50:40.118683 2025-06-02 17:50:40.119112
3156 2025-06-01 9456.67 ... 2025-06-02 17:50:40.118683 2025-06-02 17:50:40.119112
3157 2025-06-02 9456.67 ... 2025-06-02 17:50:40.118683 2025-06-02 17:50:40.119112
[3 rows x 5 columns]
2025-06-02 17:50:40,147 - 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-06-02 17:50:40,723 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3272 2025-05-29 2543.33
3273 2025-05-30 2565.00
3274 2025-05-31 2565.00
3275 2025-06-01 2565.00
3276 2025-06-02 2565.00
2025-06-02 17:50:40,789 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3274 2025-05-31 2565.0 ... 2025-06-02 17:50:40.781492 2025-06-02 17:50:40.781900
3275 2025-06-01 2565.0 ... 2025-06-02 17:50:40.781492 2025-06-02 17:50:40.781900
3276 2025-06-02 2565.0 ... 2025-06-02 17:50:40.781492 2025-06-02 17:50:40.781900
[3 rows x 5 columns]
2025-06-02 17:50:40,809 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-06-02 17:50:40,815 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3272 2025-05-29 2543.33
3273 2025-05-30 2565.00
3274 2025-05-31 2565.00
3275 2025-06-01 2565.00
3276 2025-06-02 2565.00
2025-06-02 17:50:40,881 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3278 2025-05-31 2565.0 ... 2025-06-02 17:50:40.873882 2025-06-02 17:50:40.874271
3279 2025-06-01 2565.0 ... 2025-06-02 17:50:40.873882 2025-06-02 17:50:40.874271
3280 2025-06-02 2565.0 ... 2025-06-02 17:50:40.873882 2025-06-02 17:50:40.874271
[3 rows x 5 columns]
2025-06-02 17:50:40,901 - 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-06-02 17:50:41,452 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1476 2025-05-29 1450.0
1477 2025-05-30 1450.0
1478 2025-05-31 1450.0
1479 2025-06-01 1450.0
1480 2025-06-02 1450.0
2025-06-02 17:50:41,495 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1478 2025-05-31 1450.0 ... 2025-06-02 17:50:41.488466 2025-06-02 17:50:41.488867
1479 2025-06-01 1450.0 ... 2025-06-02 17:50:41.488466 2025-06-02 17:50:41.488867
1480 2025-06-02 1450.0 ... 2025-06-02 17:50:41.488466 2025-06-02 17:50:41.488867
[3 rows x 5 columns]
2025-06-02 17:50:41,515 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-06-02 17:50:41,521 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1476 2025-05-29 1450.0
1477 2025-05-30 1450.0
1478 2025-05-31 1450.0
1479 2025-06-01 1450.0
1480 2025-06-02 1450.0
2025-06-02 17:50:41,564 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1482 2025-05-31 1450.0 ... 2025-06-02 17:50:41.557554 2025-06-02 17:50:41.557947
1483 2025-06-01 1450.0 ... 2025-06-02 17:50:41.557554 2025-06-02 17:50:41.557947
1484 2025-06-02 1450.0 ... 2025-06-02 17:50:41.557554 2025-06-02 17:50:41.557947
[3 rows x 5 columns]
2025-06-02 17:50:41,584 - 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-06-02 17:50:42,110 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1389 2025-05-29 6522.08
1390 2025-05-30 6511.46
1391 2025-05-31 6511.46
1392 2025-06-01 6511.46
1393 2025-06-02 6511.46
2025-06-02 17:50:42,154 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1391 2025-05-31 6511.46 ... 2025-06-02 17:50:42.147293 2025-06-02 17:50:42.147688
1392 2025-06-01 6511.46 ... 2025-06-02 17:50:42.147293 2025-06-02 17:50:42.147688
1393 2025-06-02 6511.46 ... 2025-06-02 17:50:42.147293 2025-06-02 17:50:42.147688
[3 rows x 5 columns]
2025-06-02 17:50:42,175 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-06-02 17:50:42,180 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1389 2025-05-29 6522.08
1390 2025-05-30 6511.46
1391 2025-05-31 6511.46
1392 2025-06-01 6511.46
1393 2025-06-02 6511.46
2025-06-02 17:50:42,223 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1395 2025-05-31 6511.46 ... 2025-06-02 17:50:42.216651 2025-06-02 17:50:42.217047
1396 2025-06-01 6511.46 ... 2025-06-02 17:50:42.216651 2025-06-02 17:50:42.217047
1397 2025-06-02 6511.46 ... 2025-06-02 17:50:42.216651 2025-06-02 17:50:42.217047
[3 rows x 5 columns]
2025-06-02 17:50:42,243 - 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-06-02 17:50:42,819 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3762 2025-05-29 2952.0
3763 2025-05-30 2956.0
3764 2025-05-31 2956.0
3765 2025-06-01 2956.0
3766 2025-06-02 2956.0
2025-06-02 17:50:42,895 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3764 2025-05-31 2956.0 ... 2025-06-02 17:50:42.887785 2025-06-02 17:50:42.888180
3765 2025-06-01 2956.0 ... 2025-06-02 17:50:42.887785 2025-06-02 17:50:42.888180
3766 2025-06-02 2956.0 ... 2025-06-02 17:50:42.887785 2025-06-02 17:50:42.888180
[3 rows x 5 columns]
2025-06-02 17:50:42,914 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-06-02 17:50:42,919 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3762 2025-05-29 2952.0
3763 2025-05-30 2956.0
3764 2025-05-31 2956.0
3765 2025-06-01 2956.0
3766 2025-06-02 2956.0
2025-06-02 17:50:42,994 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3767 2025-05-31 2956.0 ... 2025-06-02 17:50:42.986576 2025-06-02 17:50:42.986979
3768 2025-06-01 2956.0 ... 2025-06-02 17:50:42.986576 2025-06-02 17:50:42.986979
3769 2025-06-02 2956.0 ... 2025-06-02 17:50:42.986576 2025-06-02 17:50:42.986979
[3 rows x 5 columns]
2025-06-02 17:50:43,013 - 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-06-02 17:50:43,565 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3532 2025-05-29 7984.0
3533 2025-05-30 7904.0
3534 2025-05-31 7904.0
3535 2025-06-01 7904.0
3536 2025-06-02 7904.0
2025-06-02 17:50:43,638 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3534 2025-05-31 7904.0 ... 2025-06-02 17:50:43.631266 2025-06-02 17:50:43.631670
3535 2025-06-01 7904.0 ... 2025-06-02 17:50:43.631266 2025-06-02 17:50:43.631670
3536 2025-06-02 7904.0 ... 2025-06-02 17:50:43.631266 2025-06-02 17:50:43.631670
[3 rows x 5 columns]
2025-06-02 17:50:43,659 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-06-02 17:50:43,665 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3532 2025-05-29 7984.0
3533 2025-05-30 7904.0
3534 2025-05-31 7904.0
3535 2025-06-01 7904.0
3536 2025-06-02 7904.0
2025-06-02 17:50:43,739 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3537 2025-05-31 7904.0 ... 2025-06-02 17:50:43.731511 2025-06-02 17:50:43.731916
3538 2025-06-01 7904.0 ... 2025-06-02 17:50:43.731511 2025-06-02 17:50:43.731916
3539 2025-06-02 7904.0 ... 2025-06-02 17:50:43.731511 2025-06-02 17:50:43.731916
[3 rows x 5 columns]
2025-06-02 17:50:43,758 - 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-06-02 17:50:44,285 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3498 2025-05-29 4255.0
3499 2025-05-30 4255.0
3500 2025-05-31 4255.0
3501 2025-06-01 4255.0
3502 2025-06-02 4255.0
2025-06-02 17:50:44,354 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3500 2025-05-31 4255.0 ... 2025-06-02 17:50:44.346930 2025-06-02 17:50:44.347325
3501 2025-06-01 4255.0 ... 2025-06-02 17:50:44.346930 2025-06-02 17:50:44.347325
3502 2025-06-02 4255.0 ... 2025-06-02 17:50:44.346930 2025-06-02 17:50:44.347325
[3 rows x 5 columns]
2025-06-02 17:50:44,373 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-06-02 17:50:44,379 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3498 2025-05-29 4255.0
3499 2025-05-30 4255.0
3500 2025-05-31 4255.0
3501 2025-06-01 4255.0
3502 2025-06-02 4255.0
2025-06-02 17:50:44,448 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3503 2025-05-31 4255.0 ... 2025-06-02 17:50:44.441278 2025-06-02 17:50:44.441655
3504 2025-06-01 4255.0 ... 2025-06-02 17:50:44.441278 2025-06-02 17:50:44.441655
3505 2025-06-02 4255.0 ... 2025-06-02 17:50:44.441278 2025-06-02 17:50:44.441655
[3 rows x 5 columns]
2025-06-02 17:50:44,468 - 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-06-02 17:50:45,020 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2875 2025-05-29 5298.57
2876 2025-05-30 5298.57
2877 2025-05-31 5298.57
2878 2025-06-01 5298.57
2879 2025-06-02 5298.57
2025-06-02 17:50:45,082 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2877 2025-05-31 5298.57 ... 2025-06-02 17:50:45.074993 2025-06-02 17:50:45.075380
2878 2025-06-01 5298.57 ... 2025-06-02 17:50:45.074993 2025-06-02 17:50:45.075380
2879 2025-06-02 5298.57 ... 2025-06-02 17:50:45.074993 2025-06-02 17:50:45.075380
[3 rows x 5 columns]
2025-06-02 17:50:45,101 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-06-02 17:50:45,107 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2875 2025-05-29 5298.57
2876 2025-05-30 5298.57
2877 2025-05-31 5298.57
2878 2025-06-01 5298.57
2879 2025-06-02 5298.57
2025-06-02 17:50:45,168 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2881 2025-05-31 5298.57 ... 2025-06-02 17:50:45.161511 2025-06-02 17:50:45.161914
2882 2025-06-01 5298.57 ... 2025-06-02 17:50:45.161511 2025-06-02 17:50:45.161914
2883 2025-06-02 5298.57 ... 2025-06-02 17:50:45.161511 2025-06-02 17:50:45.161914
[3 rows x 5 columns]
2025-06-02 17:50:45,188 - 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-06-02 17:50:45,809 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3075 2025-05-29 3040.0
3076 2025-05-30 3015.0
3077 2025-05-31 3015.0
3078 2025-06-01 3015.0
3079 2025-06-02 3015.0
2025-06-02 17:50:45,873 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3077 2025-05-31 3015.0 ... 2025-06-02 17:50:45.865823 2025-06-02 17:50:45.866223
3078 2025-06-01 3015.0 ... 2025-06-02 17:50:45.865823 2025-06-02 17:50:45.866223
3079 2025-06-02 3015.0 ... 2025-06-02 17:50:45.865823 2025-06-02 17:50:45.866223
[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-06-02 17:50:46,028 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-06-02 17:50:46.020882
458 2015-09-21 ... 2025-06-02 17:50:46.020882
549 2016-02-03 ... 2025-06-02 17:50:46.020882
693 2016-09-05 ... 2025-06-02 17:50:46.020882
696 2016-09-08 ... 2025-06-02 17:50:46.020882
[5 rows x 6 columns]
2025-06-02 17:50:46,058 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3075 2025-05-29 3040.0
3076 2025-05-30 3015.0
3077 2025-05-31 3015.0
3078 2025-06-01 3015.0
3079 2025-06-02 3015.0
2025-06-02 17:50:46,125 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3080 2025-05-31 3015.0 ... 2025-06-02 17:50:46.117210 2025-06-02 17:50:46.117593
3081 2025-06-01 3015.0 ... 2025-06-02 17:50:46.117210 2025-06-02 17:50:46.117593
3082 2025-06-02 3015.0 ... 2025-06-02 17:50:46.117210 2025-06-02 17:50:46.117593
[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-06-02 17:50:46,279 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-06-02 17:50:46.271970
458 2015-09-21 ... 2025-06-02 17:50:46.271970
549 2016-02-03 ... 2025-06-02 17:50:46.271970
693 2016-09-05 ... 2025-06-02 17:50:46.271970
696 2016-09-08 ... 2025-06-02 17:50:46.271970
[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-06-02 17:50:46,946 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
879 2025-05-29 8990.0
880 2025-05-30 8780.0
881 2025-05-31 8780.0
882 2025-06-01 8780.0
883 2025-06-02 8780.0
2025-06-02 17:50:46,981 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
881 2025-05-31 8780.0 ... 2025-06-02 17:50:46.974624 2025-06-02 17:50:46.975032
882 2025-06-01 8780.0 ... 2025-06-02 17:50:46.974624 2025-06-02 17:50:46.975032
883 2025-06-02 8780.0 ... 2025-06-02 17:50:46.974624 2025-06-02 17:50:46.975032
[3 rows x 5 columns]
2025-06-02 17:50:47,001 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-06-02 17:50:47,006 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
879 2025-05-29 8990.0
880 2025-05-30 8780.0
881 2025-05-31 8780.0
882 2025-06-01 8780.0
883 2025-06-02 8780.0
2025-06-02 17:50:47,042 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
881 2025-05-31 8780.0 ... 2025-06-02 17:50:47.035253 2025-06-02 17:50:47.035628
882 2025-06-01 8780.0 ... 2025-06-02 17:50:47.035253 2025-06-02 17:50:47.035628
883 2025-06-02 8780.0 ... 2025-06-02 17:50:47.035253 2025-06-02 17:50:47.035628
[3 rows x 5 columns]
2025-06-02 17:50:47,061 - 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-06-02 17:50:47,632 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3758 2025-05-29 7378.33
3759 2025-05-30 7368.33
3760 2025-05-31 7368.33
3761 2025-06-01 7368.33
3762 2025-06-02 7368.33
2025-06-02 17:50:47,704 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3760 2025-05-31 7368.33 ... 2025-06-02 17:50:47.696849 2025-06-02 17:50:47.697239
3761 2025-06-01 7368.33 ... 2025-06-02 17:50:47.696849 2025-06-02 17:50:47.697239
3762 2025-06-02 7368.33 ... 2025-06-02 17:50:47.696849 2025-06-02 17:50:47.697239
[3 rows x 5 columns]
2025-06-02 17:50:47,723 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-06-02 17:50:47,728 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3758 2025-05-29 7378.33
3759 2025-05-30 7368.33
3760 2025-05-31 7368.33
3761 2025-06-01 7368.33
3762 2025-06-02 7368.33
2025-06-02 17:50:47,801 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3763 2025-05-31 7368.33 ... 2025-06-02 17:50:47.793623 2025-06-02 17:50:47.794031
3764 2025-06-01 7368.33 ... 2025-06-02 17:50:47.793623 2025-06-02 17:50:47.794031
3765 2025-06-02 7368.33 ... 2025-06-02 17:50:47.793623 2025-06-02 17:50:47.794031
[3 rows x 5 columns]
2025-06-02 17:50:47,820 - 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-06-02 17:50:48,354 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3096 2025-05-29 3611.67
3097 2025-05-30 3611.67
3098 2025-05-31 3625.00
3099 2025-06-01 3625.00
3100 2025-06-02 3625.00
2025-06-02 17:50:48,418 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3099 2025-05-31 3625.0 ... 2025-06-02 17:50:48.411398 2025-06-02 17:50:48.411806
3100 2025-06-01 3625.0 ... 2025-06-02 17:50:48.411398 2025-06-02 17:50:48.411806
3101 2025-06-02 3625.0 ... 2025-06-02 17:50:48.411398 2025-06-02 17:50:48.411806
[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-06-02 17:50:48,455 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-06-02 17:50:48.448187
[1 rows x 6 columns]
2025-06-02 17:50:48,480 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3096 2025-05-29 3611.67
3097 2025-05-30 3611.67
3098 2025-05-31 3625.00
3099 2025-06-01 3625.00
3100 2025-06-02 3625.00
2025-06-02 17:50:48,545 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3101 2025-05-31 3625.0 ... 2025-06-02 17:50:48.538048 2025-06-02 17:50:48.538436
3102 2025-06-01 3625.0 ... 2025-06-02 17:50:48.538048 2025-06-02 17:50:48.538436
3103 2025-06-02 3625.0 ... 2025-06-02 17:50:48.538048 2025-06-02 17:50:48.538436
[3 rows x 5 columns]
2025-06-02 17:50:48,565 - 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-06-02 17:50:49,136 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3761 2025-05-29 20396.67
3762 2025-05-30 20303.33
3763 2025-05-31 20303.33
3764 2025-06-01 20303.33
3765 2025-06-02 20303.33
2025-06-02 17:50:49,211 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date ... updated_at
3763 2025-05-31 ... 2025-06-02 17:50:49.204478
3764 2025-06-01 ... 2025-06-02 17:50:49.204478
3765 2025-06-02 ... 2025-06-02 17:50:49.204478
[3 rows x 5 columns]
2025-06-02 17:50:49,231 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-06-02 17:50:49,237 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3761 2025-05-29 20396.67
3762 2025-05-30 20303.33
3763 2025-05-31 20303.33
3764 2025-06-01 20303.33
3765 2025-06-02 20303.33
2025-06-02 17:50:49,312 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date ... updated_at
3766 2025-05-31 ... 2025-06-02 17:50:49.305975
3767 2025-06-01 ... 2025-06-02 17:50:49.305975
3768 2025-06-02 ... 2025-06-02 17:50:49.305975
[3 rows x 5 columns]
2025-06-02 17:50:49,332 - 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-06-02 17:50:49,959 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2875 2025-05-29 5570.0
2876 2025-05-30 5520.0
2877 2025-05-31 5520.0
2878 2025-06-01 5520.0
2879 2025-06-02 5520.0
2025-06-02 17:50:50,021 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2877 2025-05-31 5520.0 ... 2025-06-02 17:50:50.013563 2025-06-02 17:50:50.013968
2878 2025-06-01 5520.0 ... 2025-06-02 17:50:50.013563 2025-06-02 17:50:50.013968
2879 2025-06-02 5520.0 ... 2025-06-02 17:50:50.013563 2025-06-02 17:50:50.013968
[3 rows x 5 columns]
2025-06-02 17:50:50,040 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-06-02 17:50:50,045 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2875 2025-05-29 5570.0
2876 2025-05-30 5520.0
2877 2025-05-31 5520.0
2878 2025-06-01 5520.0
2879 2025-06-02 5520.0
2025-06-02 17:50:50,108 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2881 2025-05-31 5520.0 ... 2025-06-02 17:50:50.100107 2025-06-02 17:50:50.100565
2882 2025-06-01 5520.0 ... 2025-06-02 17:50:50.100107 2025-06-02 17:50:50.100565
2883 2025-06-02 5520.0 ... 2025-06-02 17:50:50.100107 2025-06-02 17:50:50.100565
[3 rows x 5 columns]
2025-06-02 17:50:50,129 - 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-06-02 17:50:50,699 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2150 2025-05-29 23800.0
2151 2025-05-30 23800.0
2152 2025-05-31 23800.0
2153 2025-06-01 23800.0
2154 2025-06-02 23800.0
2025-06-02 17:50:50,754 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2152 2025-05-31 23800.0 ... 2025-06-02 17:50:50.745163 2025-06-02 17:50:50.745539
2153 2025-06-01 23800.0 ... 2025-06-02 17:50:50.745163 2025-06-02 17:50:50.745539
2154 2025-06-02 23800.0 ... 2025-06-02 17:50:50.745163 2025-06-02 17:50:50.745539
[3 rows x 5 columns]
2025-06-02 17:50:50,773 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-06-02 17:50:50,779 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2150 2025-05-29 23800.0
2151 2025-05-30 23800.0
2152 2025-05-31 23800.0
2153 2025-06-01 23800.0
2154 2025-06-02 23800.0
2025-06-02 17:50:50,831 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2156 2025-05-31 23800.0 ... 2025-06-02 17:50:50.824337 2025-06-02 17:50:50.824745
2157 2025-06-01 23800.0 ... 2025-06-02 17:50:50.824337 2025-06-02 17:50:50.824745
2158 2025-06-02 23800.0 ... 2025-06-02 17:50:50.824337 2025-06-02 17:50:50.824745
[3 rows x 5 columns]
2025-06-02 17:50:50,850 - 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-06-02 17:50:51,437 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1665 2025-05-29 1896.0
1666 2025-05-30 1892.0
1667 2025-05-31 1892.0
1668 2025-06-01 1892.0
1669 2025-06-02 1892.0
2025-06-02 17:50:51,486 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1667 2025-05-31 1892.0 ... 2025-06-02 17:50:51.477910 2025-06-02 17:50:51.478301
1668 2025-06-01 1892.0 ... 2025-06-02 17:50:51.477910 2025-06-02 17:50:51.478301
1669 2025-06-02 1892.0 ... 2025-06-02 17:50:51.477910 2025-06-02 17:50:51.478301
[3 rows x 5 columns]
2025-06-02 17:50:51,505 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-06-02 17:50:51,511 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1665 2025-05-29 1896.0
1666 2025-05-30 1892.0
1667 2025-05-31 1892.0
1668 2025-06-01 1892.0
1669 2025-06-02 1892.0
2025-06-02 17:50:51,560 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1671 2025-05-31 1892.0 ... 2025-06-02 17:50:51.552084 2025-06-02 17:50:51.552507
1672 2025-06-01 1892.0 ... 2025-06-02 17:50:51.552084 2025-06-02 17:50:51.552507
1673 2025-06-02 1892.0 ... 2025-06-02 17:50:51.552084 2025-06-02 17:50:51.552507
[3 rows x 5 columns]
2025-06-02 17:50:51,580 - 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-06-02 17:50:52,146 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2737 2025-05-29 121758.33
2738 2025-05-30 122425.00
2739 2025-05-31 122425.00
2740 2025-06-01 122425.00
2741 2025-06-02 122425.00
2025-06-02 17:50:52,204 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2739 2025-05-31 ... 2025-06-02 17:50:52.198231
2740 2025-06-01 ... 2025-06-02 17:50:52.198231
2741 2025-06-02 ... 2025-06-02 17:50:52.198231
[3 rows x 5 columns]
2025-06-02 17:50:52,224 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-06-02 17:50:52,229 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2737 2025-05-29 121758.33
2738 2025-05-30 122425.00
2739 2025-05-31 122425.00
2740 2025-06-01 122425.00
2741 2025-06-02 122425.00
2025-06-02 17:50:52,288 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2742 2025-05-31 ... 2025-06-02 17:50:52.282220
2743 2025-06-01 ... 2025-06-02 17:50:52.282220
2744 2025-06-02 ... 2025-06-02 17:50:52.282220
[3 rows x 5 columns]
2025-06-02 17:50:52,307 - 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-06-02 17:50:52,906 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3762 2025-05-29 4591.0
3763 2025-05-30 4597.0
3764 2025-05-31 4597.0
3765 2025-06-01 4597.0
3766 2025-06-02 4597.0
2025-06-02 17:50:52,983 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3764 2025-05-31 4597.0 ... 2025-06-02 17:50:52.975959 2025-06-02 17:50:52.976348
3765 2025-06-01 4597.0 ... 2025-06-02 17:50:52.975959 2025-06-02 17:50:52.976348
3766 2025-06-02 4597.0 ... 2025-06-02 17:50:52.975959 2025-06-02 17:50:52.976348
[3 rows x 5 columns]
2025-06-02 17:50:53,003 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-06-02 17:50:53,009 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3762 2025-05-29 4591.0
3763 2025-05-30 4597.0
3764 2025-05-31 4597.0
3765 2025-06-01 4597.0
3766 2025-06-02 4597.0
2025-06-02 17:50:53,084 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3767 2025-05-31 4597.0 ... 2025-06-02 17:50:53.076946 2025-06-02 17:50:53.077334
3768 2025-06-01 4597.0 ... 2025-06-02 17:50:53.076946 2025-06-02 17:50:53.077334
3769 2025-06-02 4597.0 ... 2025-06-02 17:50:53.076946 2025-06-02 17:50:53.077334
[3 rows x 5 columns]
2025-06-02 17:50:53,103 - 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-06-02 17:50:53,677 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
3001 2025-05-29 7418.33
3002 2025-05-30 7393.33
3003 2025-05-31 7393.33
3004 2025-06-01 7393.33
3005 2025-06-02 7393.33
2025-06-02 17:50:53,741 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
3003 2025-05-31 7393.33 ... 2025-06-02 17:50:53.734422 2025-06-02 17:50:53.734850
3004 2025-06-01 7393.33 ... 2025-06-02 17:50:53.734422 2025-06-02 17:50:53.734850
3005 2025-06-02 7393.33 ... 2025-06-02 17:50:53.734422 2025-06-02 17:50:53.734850
[3 rows x 5 columns]
2025-06-02 17:50:53,762 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-06-02 17:50:53,767 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
3001 2025-05-29 7418.33
3002 2025-05-30 7393.33
3003 2025-05-31 7393.33
3004 2025-06-01 7393.33
3005 2025-06-02 7393.33
2025-06-02 17:50:53,830 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
3006 2025-05-31 7393.33 ... 2025-06-02 17:50:53.823334 2025-06-02 17:50:53.823724
3007 2025-06-01 7393.33 ... 2025-06-02 17:50:53.823334 2025-06-02 17:50:53.823724
3008 2025-06-02 7393.33 ... 2025-06-02 17:50:53.823334 2025-06-02 17:50:53.823724
[3 rows x 5 columns]
2025-06-02 17:50:53,849 - 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-06-02 17:50:54,417 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3763 2025-05-29 14581.67
3764 2025-05-30 14580.33
3765 2025-05-31 14580.33
3766 2025-06-01 14580.33
3767 2025-06-02 14580.33
2025-06-02 17:50:54,489 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date ... updated_at
3765 2025-05-31 ... 2025-06-02 17:50:54.483213
3766 2025-06-01 ... 2025-06-02 17:50:54.483213
3767 2025-06-02 ... 2025-06-02 17:50:54.483213
[3 rows x 5 columns]
2025-06-02 17:50:54,508 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-06-02 17:50:54,514 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3763 2025-05-29 14581.67
3764 2025-05-30 14580.33
3765 2025-05-31 14580.33
3766 2025-06-01 14580.33
3767 2025-06-02 14580.33
2025-06-02 17:50:54,586 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date ... updated_at
3769 2025-05-31 ... 2025-06-02 17:50:54.580258
3770 2025-06-01 ... 2025-06-02 17:50:54.580258
3771 2025-06-02 ... 2025-06-02 17:50:54.580258
[3 rows x 5 columns]
2025-06-02 17:50:54,606 - 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-06-02 17:50:55,168 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3708 2025-05-29 16687.5
3709 2025-05-30 16487.5
3710 2025-05-31 16487.5
3711 2025-06-01 16487.5
3712 2025-06-02 16487.5
2025-06-02 17:50:55,239 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date value ... created_at updated_at
3710 2025-05-31 16487.5 ... 2025-06-02 17:50:55.231730 2025-06-02 17:50:55.232143
3711 2025-06-01 16487.5 ... 2025-06-02 17:50:55.231730 2025-06-02 17:50:55.232143
3712 2025-06-02 16487.5 ... 2025-06-02 17:50:55.231730 2025-06-02 17:50:55.232143
[3 rows x 5 columns]
2025-06-02 17:50:55,258 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-06-02 17:50:55,264 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3708 2025-05-29 16687.5
3709 2025-05-30 16487.5
3710 2025-05-31 16487.5
3711 2025-06-01 16487.5
3712 2025-06-02 16487.5
2025-06-02 17:50:55,336 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date value ... created_at updated_at
3713 2025-05-31 16487.5 ... 2025-06-02 17:50:55.329214 2025-06-02 17:50:55.329592
3714 2025-06-01 16487.5 ... 2025-06-02 17:50:55.329214 2025-06-02 17:50:55.329592
3715 2025-06-02 16487.5 ... 2025-06-02 17:50:55.329214 2025-06-02 17:50:55.329592
[3 rows x 5 columns]
2025-06-02 17:50:55,355 - 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-06-02 17:50:55,891 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
2983 2025-05-29 3226.67
2984 2025-05-30 3196.67
2985 2025-05-31 3196.67
2986 2025-06-01 3196.67
2987 2025-06-02 3196.67
2025-06-02 17:50:55,956 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
2985 2025-05-31 3196.67 ... 2025-06-02 17:50:55.949116 2025-06-02 17:50:55.949542
2986 2025-06-01 3196.67 ... 2025-06-02 17:50:55.949116 2025-06-02 17:50:55.949542
2987 2025-06-02 3196.67 ... 2025-06-02 17:50:55.949116 2025-06-02 17:50:55.949542
[3 rows x 5 columns]
2025-06-02 17:50:55,975 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-06-02 17:50:55,981 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
2983 2025-05-29 3226.67
2984 2025-05-30 3196.67
2985 2025-05-31 3196.67
2986 2025-06-01 3196.67
2987 2025-06-02 3196.67
2025-06-02 17:50:56,047 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
2988 2025-05-31 3196.67 ... 2025-06-02 17:50:56.040100 2025-06-02 17:50:56.040507
2989 2025-06-01 3196.67 ... 2025-06-02 17:50:56.040100 2025-06-02 17:50:56.040507
2990 2025-06-02 3196.67 ... 2025-06-02 17:50:56.040100 2025-06-02 17:50:56.040507
[3 rows x 5 columns]
2025-06-02 17:50:56,138 - 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-06-02 17:50:56,669 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3263 2025-05-29 5350.0
3264 2025-05-30 5337.5
3265 2025-05-31 5337.5
3266 2025-06-01 5337.5
3267 2025-06-02 5337.5
2025-06-02 17:50:56,735 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3265 2025-05-31 5337.5 ... 2025-06-02 17:50:56.728 2025-06-02 17:50:56.728385
3266 2025-06-01 5337.5 ... 2025-06-02 17:50:56.728 2025-06-02 17:50:56.728385
3267 2025-06-02 5337.5 ... 2025-06-02 17:50:56.728 2025-06-02 17:50:56.728385
[3 rows x 5 columns]
2025-06-02 17:50:56,754 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-06-02 17:50:56,760 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3263 2025-05-29 5350.0
3264 2025-05-30 5337.5
3265 2025-05-31 5337.5
3266 2025-06-01 5337.5
3267 2025-06-02 5337.5
2025-06-02 17:50:56,833 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3752 2025-05-31 5337.5 ... 2025-06-02 17:50:56.826338 2025-06-02 17:50:56.826722
3753 2025-06-01 5337.5 ... 2025-06-02 17:50:56.826338 2025-06-02 17:50:56.826722
3754 2025-06-02 5337.5 ... 2025-06-02 17:50:56.826338 2025-06-02 17:50:56.826722
[3 rows x 5 columns]
2025-06-02 17:50:56,852 - 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-06-02 17:50:57,397 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1327 2025-05-29 14570.0
1328 2025-05-30 14530.0
1329 2025-05-31 14530.0
1330 2025-06-01 14530.0
1331 2025-06-02 14530.0
2025-06-02 17:50:57,441 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1329 2025-05-31 14530.0 ... 2025-06-02 17:50:57.434081 2025-06-02 17:50:57.434478
1330 2025-06-01 14530.0 ... 2025-06-02 17:50:57.434081 2025-06-02 17:50:57.434478
1331 2025-06-02 14530.0 ... 2025-06-02 17:50:57.434081 2025-06-02 17:50:57.434478
[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-06-02 17:50:57,685 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-06-02 17:50:57.677336
117 2021-07-06 ... 2025-06-02 17:50:57.677336
121 2021-07-12 ... 2025-06-02 17:50:57.677336
122 2021-07-13 ... 2025-06-02 17:50:57.677336
194 2021-11-01 ... 2025-06-02 17:50:57.677336
[5 rows x 6 columns]
2025-06-02 17:50:57,722 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1327 2025-05-29 14570.0
1328 2025-05-30 14530.0
1329 2025-05-31 14530.0
1330 2025-06-01 14530.0
1331 2025-06-02 14530.0
2025-06-02 17:50:57,763 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1332 2025-05-31 14530.0 ... 2025-06-02 17:50:57.756671 2025-06-02 17:50:57.757075
1333 2025-06-01 14530.0 ... 2025-06-02 17:50:57.756671 2025-06-02 17:50:57.757075
1334 2025-06-02 14530.0 ... 2025-06-02 17:50:57.756671 2025-06-02 17:50:57.757075
[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-06-02 17:50:58,007 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-06-02 17:50:57.998673
117 2021-07-06 ... 2025-06-02 17:50:57.998673
121 2021-07-12 ... 2025-06-02 17:50:57.998673
122 2021-07-13 ... 2025-06-02 17:50:57.998673
194 2021-11-01 ... 2025-06-02 17:50:57.998673
[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-06-02 17:50:58,611 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3759 2025-05-29 78550.00
3760 2025-05-30 78286.67
3761 2025-05-31 78286.67
3762 2025-06-01 78286.67
3763 2025-06-02 78286.67
2025-06-02 17:50:58,682 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date ... updated_at
3761 2025-05-31 ... 2025-06-02 17:50:58.676054
3762 2025-06-01 ... 2025-06-02 17:50:58.676054
3763 2025-06-02 ... 2025-06-02 17:50:58.676054
[3 rows x 5 columns]
2025-06-02 17:50:58,701 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-06-02 17:50:58,707 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3759 2025-05-29 78550.00
3760 2025-05-30 78286.67
3761 2025-05-31 78286.67
3762 2025-06-01 78286.67
3763 2025-06-02 78286.67
2025-06-02 17:50:58,778 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date ... updated_at
3764 2025-05-31 ... 2025-06-02 17:50:58.772288
3765 2025-06-01 ... 2025-06-02 17:50:58.772288
3766 2025-06-02 ... 2025-06-02 17:50:58.772288
[3 rows x 5 columns]
2025-06-02 17:50:58,797 - 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-06-02 17:50:59,315 - 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-06-02 17:50:59,372 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-06-02 17:50:59,372 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-06-02 17:50:59,378 - 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-06-02 17:50:59,446 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-06-02 17:50:59,446 - 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-06-02 17:51:00,025 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2737 2025-05-29 260550.0
2738 2025-05-30 251325.0
2739 2025-05-31 251325.0
2740 2025-06-01 251325.0
2741 2025-06-02 251325.0
2025-06-02 17:51:00,088 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2739 2025-05-31 ... 2025-06-02 17:51:00.081360
2740 2025-06-01 ... 2025-06-02 17:51:00.081360
2741 2025-06-02 ... 2025-06-02 17:51:00.081360
[3 rows x 5 columns]
2025-06-02 17:51:00,108 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-06-02 17:51:00,116 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2737 2025-05-29 260550.0
2738 2025-05-30 251325.0
2739 2025-05-31 251325.0
2740 2025-06-01 251325.0
2741 2025-06-02 251325.0
2025-06-02 17:51:00,183 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2742 2025-05-31 ... 2025-06-02 17:51:00.176308
2743 2025-06-01 ... 2025-06-02 17:51:00.176308
2744 2025-06-02 ... 2025-06-02 17:51:00.176308
[3 rows x 5 columns]
2025-06-02 17:51:00,203 - 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-06-02 17:51:00,747 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3758 2025-05-29 22826.0
3759 2025-05-30 22738.0
3760 2025-05-31 22738.0
3761 2025-06-01 22738.0
3762 2025-06-02 22738.0
2025-06-02 17:51:00,820 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3760 2025-05-31 22738.0 ... 2025-06-02 17:51:00.812560 2025-06-02 17:51:00.813008
3761 2025-06-01 22738.0 ... 2025-06-02 17:51:00.812560 2025-06-02 17:51:00.813008
3762 2025-06-02 22738.0 ... 2025-06-02 17:51:00.812560 2025-06-02 17:51:00.813008
[3 rows x 5 columns]
2025-06-02 17:51:00,839 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-06-02 17:51:00,845 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3758 2025-05-29 22826.0
3759 2025-05-30 22738.0
3760 2025-05-31 22738.0
3761 2025-06-01 22738.0
3762 2025-06-02 22738.0
2025-06-02 17:51:00,919 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3763 2025-05-31 22738.0 ... 2025-06-02 17:51:00.911936 2025-06-02 17:51:00.912325
3764 2025-06-01 22738.0 ... 2025-06-02 17:51:00.911936 2025-06-02 17:51:00.912325
3765 2025-06-02 22738.0 ... 2025-06-02 17:51:00.911936 2025-06-02 17:51:00.912325
[3 rows x 5 columns]
2025-06-02 17:51:00,938 - 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-06-02 17:51:01,570 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3721 2025-05-29 3252.5
3722 2025-05-30 3260.0
3723 2025-05-31 3260.0
3724 2025-06-01 3260.0
3725 2025-06-02 3260.0
2025-06-02 17:51:01,646 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3723 2025-05-31 3260.0 ... 2025-06-02 17:51:01.638342 2025-06-02 17:51:01.638796
3724 2025-06-01 3260.0 ... 2025-06-02 17:51:01.638342 2025-06-02 17:51:01.638796
3725 2025-06-02 3260.0 ... 2025-06-02 17:51:01.638342 2025-06-02 17:51:01.638796
[3 rows x 5 columns]
2025-06-02 17:51:01,672 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-06-02 17:51:01,679 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3721 2025-05-29 3252.5
3722 2025-05-30 3260.0
3723 2025-05-31 3260.0
3724 2025-06-01 3260.0
3725 2025-06-02 3260.0
2025-06-02 17:51:01,752 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3726 2025-05-31 3260.0 ... 2025-06-02 17:51:01.745061 2025-06-02 17:51:01.745444
3727 2025-06-01 3260.0 ... 2025-06-02 17:51:01.745061 2025-06-02 17:51:01.745444
3728 2025-06-02 3260.0 ... 2025-06-02 17:51:01.745061 2025-06-02 17:51:01.745444
[3 rows x 5 columns]
2025-06-02 17:51:01,772 - 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-06-02 17:51:02,302 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1518 2025-05-29 4747.5
1519 2025-05-30 4750.0
1520 2025-05-31 4750.0
1521 2025-06-01 4750.0
1522 2025-06-02 4750.0
2025-06-02 17:51:02,346 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1520 2025-05-31 4750.0 ... 2025-06-02 17:51:02.339432 2025-06-02 17:51:02.339836
1521 2025-06-01 4750.0 ... 2025-06-02 17:51:02.339432 2025-06-02 17:51:02.339836
1522 2025-06-02 4750.0 ... 2025-06-02 17:51:02.339432 2025-06-02 17:51:02.339836
[3 rows x 5 columns]
2025-06-02 17:51:02,368 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-06-02 17:51:02,373 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1518 2025-05-29 4747.5
1519 2025-05-30 4750.0
1520 2025-05-31 4750.0
1521 2025-06-01 4750.0
1522 2025-06-02 4750.0
2025-06-02 17:51:02,419 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1523 2025-05-31 4750.0 ... 2025-06-02 17:51:02.412264 2025-06-02 17:51:02.412636
1524 2025-06-01 4750.0 ... 2025-06-02 17:51:02.412264 2025-06-02 17:51:02.412636
1525 2025-06-02 4750.0 ... 2025-06-02 17:51:02.412264 2025-06-02 17:51:02.412636
[3 rows x 5 columns]
2025-06-02 17:51:02,438 - 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-06-02 17:51:02,983 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2792 2025-05-29 2294.29
2793 2025-05-30 2294.29
2794 2025-05-31 2294.29
2795 2025-06-01 2294.29
2796 2025-06-02 2294.29
2025-06-02 17:51:03,044 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2794 2025-05-31 2294.29 ... 2025-06-02 17:51:03.037103 2025-06-02 17:51:03.037501
2795 2025-06-01 2294.29 ... 2025-06-02 17:51:03.037103 2025-06-02 17:51:03.037501
2796 2025-06-02 2294.29 ... 2025-06-02 17:51:03.037103 2025-06-02 17:51:03.037501
[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-06-02 17:51:03,087 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2793 2025-05-30 ... 2025-06-02 17:51:03.079187
[1 rows x 6 columns]
2025-06-02 17:51:03,112 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2792 2025-05-29 2294.29
2793 2025-05-30 2294.29
2794 2025-05-31 2294.29
2795 2025-06-01 2294.29
2796 2025-06-02 2294.29
2025-06-02 17:51:03,174 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2797 2025-05-31 2294.29 ... 2025-06-02 17:51:03.166831 2025-06-02 17:51:03.167224
2798 2025-06-01 2294.29 ... 2025-06-02 17:51:03.166831 2025-06-02 17:51:03.167224
2799 2025-06-02 2294.29 ... 2025-06-02 17:51:03.166831 2025-06-02 17:51:03.167224
[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-06-02 17:51:03,216 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2796 2025-05-30 ... 2025-06-02 17:51:03.209468
[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-06-02 17:51:03,767 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2792 2025-05-29 2294.29
2793 2025-05-30 2294.29
2794 2025-05-31 2294.29
2795 2025-06-01 2294.29
2796 2025-06-02 2898.00
2025-06-02 17:51:03,818 - 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-06-02 17:51:03,842 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2796 2025-06-02 ... 2025-06-02 17:51:03.834470
[1 rows x 6 columns]
2025-06-02 17:51:03,868 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2792 2025-05-29 2294.29
2793 2025-05-30 2294.29
2794 2025-05-31 2294.29
2795 2025-06-01 2294.29
2796 2025-06-02 2898.00
2025-06-02 17:51:03,922 - 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-06-02 17:51:03,945 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2799 2025-06-02 ... 2025-06-02 17:51:03.938227
[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-06-02 17:51:04,483 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3149 2025-05-29 9530.00
3150 2025-05-30 9456.67
3151 2025-05-31 9456.67
3152 2025-06-01 9456.67
3153 2025-06-02 9456.67
2025-06-02 17:51:04,539 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-06-02 17:51:04,539 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-06-02 17:51:04,544 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3149 2025-05-29 9530.00
3150 2025-05-30 9456.67
3151 2025-05-31 9456.67
3152 2025-06-01 9456.67
3153 2025-06-02 9456.67
2025-06-02 17:51:04,601 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-06-02 17:51:04,601 - 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-06-02 17:51:05,148 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1833 2025-05-29 4521.67
1834 2025-05-30 4521.67
1835 2025-05-31 4521.67
1836 2025-06-01 4521.67
1837 2025-06-02 4521.67
2025-06-02 17:51:05,199 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1835 2025-05-31 4521.67 ... 2025-06-02 17:51:05.191162 2025-06-02 17:51:05.191543
1836 2025-06-01 4521.67 ... 2025-06-02 17:51:05.191162 2025-06-02 17:51:05.191543
1837 2025-06-02 4521.67 ... 2025-06-02 17:51:05.191162 2025-06-02 17:51:05.191543
[3 rows x 5 columns]
2025-06-02 17:51:05,218 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-06-02 17:51:05,224 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1833 2025-05-29 4521.67
1834 2025-05-30 4521.67
1835 2025-05-31 4521.67
1836 2025-06-01 4521.67
1837 2025-06-02 4521.67
2025-06-02 17:51:05,272 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1838 2025-05-31 4521.67 ... 2025-06-02 17:51:05.265465 2025-06-02 17:51:05.265881
1839 2025-06-01 4521.67 ... 2025-06-02 17:51:05.265465 2025-06-02 17:51:05.265881
1840 2025-06-02 4521.67 ... 2025-06-02 17:51:05.265465 2025-06-02 17:51:05.265881
[3 rows x 5 columns]
2025-06-02 17:51:05,292 - 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-06-02 17:51:05,801 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1842 2025-05-29 6250.00
1843 2025-05-30 6216.67
1844 2025-05-31 6216.67
1845 2025-06-01 6216.67
1846 2025-06-02 6216.67
2025-06-02 17:51:05,850 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1844 2025-05-31 6216.67 ... 2025-06-02 17:51:05.843371 2025-06-02 17:51:05.843825
1845 2025-06-01 6216.67 ... 2025-06-02 17:51:05.843371 2025-06-02 17:51:05.843825
1846 2025-06-02 6216.67 ... 2025-06-02 17:51:05.843371 2025-06-02 17:51:05.843825
[3 rows x 5 columns]
2025-06-02 17:51:05,870 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-06-02 17:51:05,875 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1842 2025-05-29 6250.00
1843 2025-05-30 6216.67
1844 2025-05-31 6216.67
1845 2025-06-01 6216.67
1846 2025-06-02 6216.67
2025-06-02 17:51:05,923 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1847 2025-05-31 6216.67 ... 2025-06-02 17:51:05.916064 2025-06-02 17:51:05.916435
1848 2025-06-01 6216.67 ... 2025-06-02 17:51:05.916064 2025-06-02 17:51:05.916435
1849 2025-06-02 6216.67 ... 2025-06-02 17:51:05.916064 2025-06-02 17:51:05.916435
[3 rows x 5 columns]
2025-06-02 17:51:05,942 - 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-06-02 17:51:06,493 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3510 2025-05-29 8652.0
3511 2025-05-30 8652.0
3512 2025-05-31 8542.0
3513 2025-06-01 8542.0
3514 2025-06-02 8542.0
2025-06-02 17:51:06,565 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3512 2025-05-31 8542.0 ... 2025-06-02 17:51:06.557483 2025-06-02 17:51:06.557908
3513 2025-06-01 8542.0 ... 2025-06-02 17:51:06.557483 2025-06-02 17:51:06.557908
3514 2025-06-02 8542.0 ... 2025-06-02 17:51:06.557483 2025-06-02 17:51:06.557908
[3 rows x 5 columns]
2025-06-02 17:51:06,584 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-06-02 17:51:06,590 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3510 2025-05-29 8652.0
3511 2025-05-30 8652.0
3512 2025-05-31 8542.0
3513 2025-06-01 8542.0
3514 2025-06-02 8542.0
2025-06-02 17:51:06,662 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3515 2025-05-31 8542.0 ... 2025-06-02 17:51:06.655188 2025-06-02 17:51:06.655569
3516 2025-06-01 8542.0 ... 2025-06-02 17:51:06.655188 2025-06-02 17:51:06.655569
3517 2025-06-02 8542.0 ... 2025-06-02 17:51:06.655188 2025-06-02 17:51:06.655569
[3 rows x 5 columns]
2025-06-02 17:51:06,682 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data