=========================================================================
2025-09-29 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-09-29 17:50:28,053 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3437 2025-09-25 3204.5
3438 2025-09-26 3193.5
3439 2025-09-27 3193.5
3440 2025-09-28 3183.5
3441 2025-09-29 3176.0
2025-09-29 17:50:28,133 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3439 2025-09-27 3193.5 ... 2025-09-29 17:50:28.124655 2025-09-29 17:50:28.125144
3440 2025-09-28 3183.5 ... 2025-09-29 17:50:28.124655 2025-09-29 17:50:28.125144
3441 2025-09-29 3176.0 ... 2025-09-29 17:50:28.124655 2025-09-29 17:50:28.125144
[3 rows x 5 columns]
2025-09-29 17:50:28,164 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-09-29 17:50:28,170 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3437 2025-09-25 3204.5
3438 2025-09-26 3193.5
3439 2025-09-27 3193.5
3440 2025-09-28 3183.5
3441 2025-09-29 3176.0
2025-09-29 17:50:28,244 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3442 2025-09-27 3193.5 ... 2025-09-29 17:50:28.236992 2025-09-29 17:50:28.237383
3443 2025-09-28 3183.5 ... 2025-09-29 17:50:28.236992 2025-09-29 17:50:28.237383
3444 2025-09-29 3176.0 ... 2025-09-29 17:50:28.236992 2025-09-29 17:50:28.237383
[3 rows x 5 columns]
2025-09-29 17:50:28,267 - 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-09-29 17:50:28,846 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3658 2025-09-25 2253.75
3659 2025-09-26 2257.50
3660 2025-09-27 2257.50
3661 2025-09-28 2263.75
3662 2025-09-29 2260.00
2025-09-29 17:50:28,922 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3660 2025-09-27 2257.50 ... 2025-09-29 17:50:28.915557 2025-09-29 17:50:28.915974
3661 2025-09-28 2263.75 ... 2025-09-29 17:50:28.915557 2025-09-29 17:50:28.915974
3662 2025-09-29 2260.00 ... 2025-09-29 17:50:28.915557 2025-09-29 17:50:28.915974
[3 rows x 5 columns]
2025-09-29 17:50:28,942 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-09-29 17:50:28,948 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3658 2025-09-25 2253.75
3659 2025-09-26 2257.50
3660 2025-09-27 2257.50
3661 2025-09-28 2263.75
3662 2025-09-29 2260.00
2025-09-29 17:50:29,022 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3664 2025-09-27 2257.50 ... 2025-09-29 17:50:29.015100 2025-09-29 17:50:29.015483
3665 2025-09-28 2263.75 ... 2025-09-29 17:50:29.015100 2025-09-29 17:50:29.015483
3666 2025-09-29 2260.00 ... 2025-09-29 17:50:29.015100 2025-09-29 17:50:29.015483
[3 rows x 5 columns]
2025-09-29 17:50:29,042 - 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-09-29 17:50:29,703 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
998 2025-09-25 4635.00
999 2025-09-26 4639.41
1000 2025-09-27 4639.41
1001 2025-09-28 4639.41
1002 2025-09-29 4612.50
2025-09-29 17:50:29,741 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
1000 2025-09-27 4639.41 ... 2025-09-29 17:50:29.733782 2025-09-29 17:50:29.734168
1001 2025-09-28 4639.41 ... 2025-09-29 17:50:29.733782 2025-09-29 17:50:29.734168
1002 2025-09-29 4612.50 ... 2025-09-29 17:50:29.733782 2025-09-29 17:50:29.734168
[3 rows x 5 columns]
2025-09-29 17:50:29,761 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-09-29 17:50:29,766 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
998 2025-09-25 4635.00
999 2025-09-26 4639.41
1000 2025-09-27 4639.41
1001 2025-09-28 4639.41
1002 2025-09-29 4612.50
2025-09-29 17:50:29,804 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
1000 2025-09-27 4639.41 ... 2025-09-29 17:50:29.796949 2025-09-29 17:50:29.797325
1001 2025-09-28 4639.41 ... 2025-09-29 17:50:29.796949 2025-09-29 17:50:29.797325
1002 2025-09-29 4612.50 ... 2025-09-29 17:50:29.796949 2025-09-29 17:50:29.797325
[3 rows x 5 columns]
2025-09-29 17:50:29,824 - 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-09-29 17:50:30,423 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3877 2025-09-25 14958.33
3878 2025-09-26 14866.67
3879 2025-09-27 14866.67
3880 2025-09-28 14808.33
3881 2025-09-29 14775.00
2025-09-29 17:50:30,501 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3879 2025-09-27 ... 2025-09-29 17:50:30.495421
3880 2025-09-28 ... 2025-09-29 17:50:30.495421
3881 2025-09-29 ... 2025-09-29 17:50:30.495421
[3 rows x 5 columns]
2025-09-29 17:50:30,521 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-09-29 17:50:30,527 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3877 2025-09-25 14958.33
3878 2025-09-26 14866.67
3879 2025-09-27 14866.67
3880 2025-09-28 14808.33
3881 2025-09-29 14775.00
2025-09-29 17:50:30,603 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3882 2025-09-27 ... 2025-09-29 17:50:30.597501
3883 2025-09-28 ... 2025-09-29 17:50:30.597501
3884 2025-09-29 ... 2025-09-29 17:50:30.597501
[3 rows x 5 columns]
2025-09-29 17:50:30,623 - 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-09-29 17:50:31,230 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3209 2025-09-25 806.11
3210 2025-09-26 806.67
3211 2025-09-27 806.67
3212 2025-09-28 798.67
3213 2025-09-29 793.44
2025-09-29 17:50:31,296 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3211 2025-09-27 806.67 ... 2025-09-29 17:50:31.289550 2025-09-29 17:50:31.289959
3212 2025-09-28 798.67 ... 2025-09-29 17:50:31.289550 2025-09-29 17:50:31.289959
3213 2025-09-29 793.44 ... 2025-09-29 17:50:31.289550 2025-09-29 17:50:31.289959
[3 rows x 5 columns]
2025-09-29 17:50:31,323 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-09-29 17:50:31,328 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3209 2025-09-25 806.11
3210 2025-09-26 806.67
3211 2025-09-27 806.67
3212 2025-09-28 798.67
3213 2025-09-29 793.44
2025-09-29 17:50:31,396 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3214 2025-09-27 806.67 ... 2025-09-29 17:50:31.389602 2025-09-29 17:50:31.389991
3215 2025-09-28 798.67 ... 2025-09-29 17:50:31.389602 2025-09-29 17:50:31.389991
3216 2025-09-29 793.44 ... 2025-09-29 17:50:31.389602 2025-09-29 17:50:31.389991
[3 rows x 5 columns]
2025-09-29 17:50:31,416 - 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-09-29 17:50:32,066 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3412 2025-09-25 1180.0
3413 2025-09-26 1234.4
3414 2025-09-27 1234.4
3415 2025-09-28 1234.4
3416 2025-09-29 1234.4
2025-09-29 17:50:32,136 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3414 2025-09-27 1234.4 ... 2025-09-29 17:50:32.129244 2025-09-29 17:50:32.129648
3415 2025-09-28 1234.4 ... 2025-09-29 17:50:32.129244 2025-09-29 17:50:32.129648
3416 2025-09-29 1234.4 ... 2025-09-29 17:50:32.129244 2025-09-29 17:50:32.129648
[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-09-29 17:50:34,383 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-09-29 17:50:34.375128
21 2013-01-04 ... 2025-09-29 17:50:34.375128
54 2013-02-27 ... 2025-09-29 17:50:34.375128
60 2013-03-07 ... 2025-09-29 17:50:34.375128
61 2013-03-08 ... 2025-09-29 17:50:34.375128
[5 rows x 6 columns]
2025-09-29 17:50:34,885 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3412 2025-09-25 1180.0
3413 2025-09-26 1234.4
3414 2025-09-27 1234.4
3415 2025-09-28 1234.4
3416 2025-09-29 1234.4
2025-09-29 17:50:34,957 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3418 2025-09-27 1234.4 ... 2025-09-29 17:50:34.950103 2025-09-29 17:50:34.950494
3419 2025-09-28 1234.4 ... 2025-09-29 17:50:34.950103 2025-09-29 17:50:34.950494
3420 2025-09-29 1234.4 ... 2025-09-29 17:50:34.950103 2025-09-29 17:50:34.950494
[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-09-29 17:50:37,088 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-09-29 17:50:37.080372
21 2013-01-04 ... 2025-09-29 17:50:37.080372
54 2013-02-27 ... 2025-09-29 17:50:37.080372
60 2013-03-07 ... 2025-09-29 17:50:37.080372
61 2013-03-08 ... 2025-09-29 17:50:37.080372
[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-09-29 17:50:38,138 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1757 2025-09-25 7120.0
1758 2025-09-26 7120.0
1759 2025-09-27 7120.0
1760 2025-09-28 7124.0
1761 2025-09-29 7124.0
2025-09-29 17:50:38,188 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1759 2025-09-27 7120.0 ... 2025-09-29 17:50:38.181188 2025-09-29 17:50:38.181598
1760 2025-09-28 7124.0 ... 2025-09-29 17:50:38.181188 2025-09-29 17:50:38.181598
1761 2025-09-29 7124.0 ... 2025-09-29 17:50:38.181188 2025-09-29 17:50:38.181598
[3 rows x 5 columns]
2025-09-29 17:50:38,209 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-09-29 17:50:38,215 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1757 2025-09-25 7120.0
1758 2025-09-26 7120.0
1759 2025-09-27 7120.0
1760 2025-09-28 7124.0
1761 2025-09-29 7124.0
2025-09-29 17:50:38,267 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1762 2025-09-27 7120.0 ... 2025-09-29 17:50:38.259780 2025-09-29 17:50:38.260155
1763 2025-09-28 7124.0 ... 2025-09-29 17:50:38.259780 2025-09-29 17:50:38.260155
1764 2025-09-29 7124.0 ... 2025-09-29 17:50:38.259780 2025-09-29 17:50:38.260155
[3 rows x 5 columns]
2025-09-29 17:50:38,289 - 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-09-29 17:50:38,865 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3868 2025-09-25 5806.67
3869 2025-09-26 5820.00
3870 2025-09-27 5820.00
3871 2025-09-28 5820.00
3872 2025-09-29 5820.00
2025-09-29 17:50:38,942 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3870 2025-09-27 5820.0 ... 2025-09-29 17:50:38.934841 2025-09-29 17:50:38.935224
3871 2025-09-28 5820.0 ... 2025-09-29 17:50:38.934841 2025-09-29 17:50:38.935224
3872 2025-09-29 5820.0 ... 2025-09-29 17:50:38.934841 2025-09-29 17:50:38.935224
[3 rows x 5 columns]
2025-09-29 17:50:38,963 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-09-29 17:50:38,969 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3868 2025-09-25 5806.67
3869 2025-09-26 5820.00
3870 2025-09-27 5820.00
3871 2025-09-28 5820.00
3872 2025-09-29 5820.00
2025-09-29 17:50:39,047 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3874 2025-09-27 5820.0 ... 2025-09-29 17:50:39.039757 2025-09-29 17:50:39.040152
3875 2025-09-28 5820.0 ... 2025-09-29 17:50:39.039757 2025-09-29 17:50:39.040152
3876 2025-09-29 5820.0 ... 2025-09-29 17:50:39.039757 2025-09-29 17:50:39.040152
[3 rows x 5 columns]
2025-09-29 17:50:39,067 - 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-09-29 17:50:39,665 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1758 2025-09-25 13092.5
1759 2025-09-26 13067.5
1760 2025-09-27 13067.5
1761 2025-09-28 13055.0
1762 2025-09-29 13055.0
2025-09-29 17:50:39,715 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1760 2025-09-27 13067.5 ... 2025-09-29 17:50:39.708395 2025-09-29 17:50:39.708800
1761 2025-09-28 13055.0 ... 2025-09-29 17:50:39.708395 2025-09-29 17:50:39.708800
1762 2025-09-29 13055.0 ... 2025-09-29 17:50:39.708395 2025-09-29 17:50:39.708800
[3 rows x 5 columns]
2025-09-29 17:50:39,735 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-09-29 17:50:39,741 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1758 2025-09-25 13092.5
1759 2025-09-26 13067.5
1760 2025-09-27 13067.5
1761 2025-09-28 13055.0
1762 2025-09-29 13055.0
2025-09-29 17:50:39,794 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1763 2025-09-27 13067.5 ... 2025-09-29 17:50:39.783003 2025-09-29 17:50:39.783611
1764 2025-09-28 13055.0 ... 2025-09-29 17:50:39.783003 2025-09-29 17:50:39.783611
1765 2025-09-29 13055.0 ... 2025-09-29 17:50:39.783003 2025-09-29 17:50:39.783611
[3 rows x 5 columns]
2025-09-29 17:50:39,814 - 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-09-29 17:50:40,417 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3268 2025-09-25 10278.33
3269 2025-09-26 10305.00
3270 2025-09-27 10305.00
3271 2025-09-28 10305.00
3272 2025-09-29 10236.67
2025-09-29 17:50:40,486 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date ... updated_at
3270 2025-09-27 ... 2025-09-29 17:50:40.480211
3271 2025-09-28 ... 2025-09-29 17:50:40.480211
3272 2025-09-29 ... 2025-09-29 17:50:40.480211
[3 rows x 5 columns]
2025-09-29 17:50:40,507 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-09-29 17:50:40,512 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3268 2025-09-25 10278.33
3269 2025-09-26 10305.00
3270 2025-09-27 10305.00
3271 2025-09-28 10305.00
3272 2025-09-29 10236.67
2025-09-29 17:50:40,581 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date ... updated_at
3274 2025-09-27 ... 2025-09-29 17:50:40.574953
3275 2025-09-28 ... 2025-09-29 17:50:40.574953
3276 2025-09-29 ... 2025-09-29 17:50:40.574953
[3 rows x 5 columns]
2025-09-29 17:50:40,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-09-29 17:50:41,201 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3391 2025-09-25 2541.67
3392 2025-09-26 2548.33
3393 2025-09-27 2548.33
3394 2025-09-28 2548.33
3395 2025-09-29 2533.33
2025-09-29 17:50:41,272 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3393 2025-09-27 2548.33 ... 2025-09-29 17:50:41.264554 2025-09-29 17:50:41.264971
3394 2025-09-28 2548.33 ... 2025-09-29 17:50:41.264554 2025-09-29 17:50:41.264971
3395 2025-09-29 2533.33 ... 2025-09-29 17:50:41.264554 2025-09-29 17:50:41.264971
[3 rows x 5 columns]
2025-09-29 17:50:41,292 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-09-29 17:50:41,298 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3391 2025-09-25 2541.67
3392 2025-09-26 2548.33
3393 2025-09-27 2548.33
3394 2025-09-28 2548.33
3395 2025-09-29 2533.33
2025-09-29 17:50:41,368 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3397 2025-09-27 2548.33 ... 2025-09-29 17:50:41.361041 2025-09-29 17:50:41.361421
3398 2025-09-28 2548.33 ... 2025-09-29 17:50:41.361041 2025-09-29 17:50:41.361421
3399 2025-09-29 2533.33 ... 2025-09-29 17:50:41.361041 2025-09-29 17:50:41.361421
[3 rows x 5 columns]
2025-09-29 17:50:41,388 - 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-09-29 17:50:42,080 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1595 2025-09-25 1262.5
1596 2025-09-26 1262.5
1597 2025-09-27 1262.5
1598 2025-09-28 1262.5
1599 2025-09-29 1262.5
2025-09-29 17:50:42,132 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1597 2025-09-27 1262.5 ... 2025-09-29 17:50:42.124981 2025-09-29 17:50:42.125366
1598 2025-09-28 1262.5 ... 2025-09-29 17:50:42.124981 2025-09-29 17:50:42.125366
1599 2025-09-29 1262.5 ... 2025-09-29 17:50:42.124981 2025-09-29 17:50:42.125366
[3 rows x 5 columns]
2025-09-29 17:50:42,153 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-09-29 17:50:42,158 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1595 2025-09-25 1262.5
1596 2025-09-26 1262.5
1597 2025-09-27 1262.5
1598 2025-09-28 1262.5
1599 2025-09-29 1262.5
2025-09-29 17:50:42,206 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1601 2025-09-27 1262.5 ... 2025-09-29 17:50:42.199330 2025-09-29 17:50:42.199742
1602 2025-09-28 1262.5 ... 2025-09-29 17:50:42.199330 2025-09-29 17:50:42.199742
1603 2025-09-29 1262.5 ... 2025-09-29 17:50:42.199330 2025-09-29 17:50:42.199742
[3 rows x 5 columns]
2025-09-29 17:50:42,227 - 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-09-29 17:50:42,787 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1508 2025-09-25 6427.29
1509 2025-09-26 6441.12
1510 2025-09-27 6441.12
1511 2025-09-28 6441.12
1512 2025-09-29 6444.13
2025-09-29 17:50:42,836 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1510 2025-09-27 6441.12 ... 2025-09-29 17:50:42.828707 2025-09-29 17:50:42.829109
1511 2025-09-28 6441.12 ... 2025-09-29 17:50:42.828707 2025-09-29 17:50:42.829109
1512 2025-09-29 6444.13 ... 2025-09-29 17:50:42.828707 2025-09-29 17:50:42.829109
[3 rows x 5 columns]
2025-09-29 17:50:42,856 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-09-29 17:50:42,861 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1508 2025-09-25 6427.29
1509 2025-09-26 6441.12
1510 2025-09-27 6441.12
1511 2025-09-28 6441.12
1512 2025-09-29 6444.13
2025-09-29 17:50:42,906 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1514 2025-09-27 6441.12 ... 2025-09-29 17:50:42.899705 2025-09-29 17:50:42.900084
1515 2025-09-28 6441.12 ... 2025-09-29 17:50:42.899705 2025-09-29 17:50:42.900084
1516 2025-09-29 6444.13 ... 2025-09-29 17:50:42.899705 2025-09-29 17:50:42.900084
[3 rows x 5 columns]
2025-09-29 17:50:42,927 - 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-09-29 17:50:43,582 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3881 2025-09-25 3002.0
3882 2025-09-26 2998.0
3883 2025-09-27 2998.0
3884 2025-09-28 2988.0
3885 2025-09-29 2988.0
2025-09-29 17:50:43,664 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3883 2025-09-27 2998.0 ... 2025-09-29 17:50:43.655123 2025-09-29 17:50:43.655583
3884 2025-09-28 2988.0 ... 2025-09-29 17:50:43.655123 2025-09-29 17:50:43.655583
3885 2025-09-29 2988.0 ... 2025-09-29 17:50:43.655123 2025-09-29 17:50:43.655583
[3 rows x 5 columns]
2025-09-29 17:50:43,684 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-09-29 17:50:43,691 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3881 2025-09-25 3002.0
3882 2025-09-26 2998.0
3883 2025-09-27 2998.0
3884 2025-09-28 2988.0
3885 2025-09-29 2988.0
2025-09-29 17:50:43,777 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3886 2025-09-27 2998.0 ... 2025-09-29 17:50:43.769184 2025-09-29 17:50:43.769756
3887 2025-09-28 2988.0 ... 2025-09-29 17:50:43.769184 2025-09-29 17:50:43.769756
3888 2025-09-29 2988.0 ... 2025-09-29 17:50:43.769184 2025-09-29 17:50:43.769756
[3 rows x 5 columns]
2025-09-29 17:50:43,798 - 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-09-29 17:50:44,421 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3651 2025-09-25 8278.0
3652 2025-09-26 8258.0
3653 2025-09-27 8258.0
3654 2025-09-28 8258.0
3655 2025-09-29 8228.0
2025-09-29 17:50:44,495 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3653 2025-09-27 8258.0 ... 2025-09-29 17:50:44.488168 2025-09-29 17:50:44.488549
3654 2025-09-28 8258.0 ... 2025-09-29 17:50:44.488168 2025-09-29 17:50:44.488549
3655 2025-09-29 8228.0 ... 2025-09-29 17:50:44.488168 2025-09-29 17:50:44.488549
[3 rows x 5 columns]
2025-09-29 17:50:44,515 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-09-29 17:50:44,521 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3651 2025-09-25 8278.0
3652 2025-09-26 8258.0
3653 2025-09-27 8258.0
3654 2025-09-28 8258.0
3655 2025-09-29 8228.0
2025-09-29 17:50:44,599 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3656 2025-09-27 8258.0 ... 2025-09-29 17:50:44.591779 2025-09-29 17:50:44.592206
3657 2025-09-28 8258.0 ... 2025-09-29 17:50:44.591779 2025-09-29 17:50:44.592206
3658 2025-09-29 8228.0 ... 2025-09-29 17:50:44.591779 2025-09-29 17:50:44.592206
[3 rows x 5 columns]
2025-09-29 17:50:44,620 - 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-09-29 17:50:45,243 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3617 2025-09-25 4290.0
3618 2025-09-26 4285.0
3619 2025-09-27 4285.0
3620 2025-09-28 4285.0
3621 2025-09-29 4285.0
2025-09-29 17:50:45,320 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3619 2025-09-27 4285.0 ... 2025-09-29 17:50:45.312707 2025-09-29 17:50:45.313099
3620 2025-09-28 4285.0 ... 2025-09-29 17:50:45.312707 2025-09-29 17:50:45.313099
3621 2025-09-29 4285.0 ... 2025-09-29 17:50:45.312707 2025-09-29 17:50:45.313099
[3 rows x 5 columns]
2025-09-29 17:50:45,342 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-09-29 17:50:45,348 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3617 2025-09-25 4290.0
3618 2025-09-26 4285.0
3619 2025-09-27 4285.0
3620 2025-09-28 4285.0
3621 2025-09-29 4285.0
2025-09-29 17:50:45,420 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3622 2025-09-27 4285.0 ... 2025-09-29 17:50:45.413163 2025-09-29 17:50:45.413545
3623 2025-09-28 4285.0 ... 2025-09-29 17:50:45.413163 2025-09-29 17:50:45.413545
3624 2025-09-29 4285.0 ... 2025-09-29 17:50:45.413163 2025-09-29 17:50:45.413545
[3 rows x 5 columns]
2025-09-29 17:50:45,440 - 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-09-29 17:50:46,037 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2994 2025-09-25 5337.14
2995 2025-09-26 5325.71
2996 2025-09-27 5325.71
2997 2025-09-28 5322.86
2998 2025-09-29 5322.86
2025-09-29 17:50:46,103 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2996 2025-09-27 5325.71 ... 2025-09-29 17:50:46.095984 2025-09-29 17:50:46.096362
2997 2025-09-28 5322.86 ... 2025-09-29 17:50:46.095984 2025-09-29 17:50:46.096362
2998 2025-09-29 5322.86 ... 2025-09-29 17:50:46.095984 2025-09-29 17:50:46.096362
[3 rows x 5 columns]
2025-09-29 17:50:46,123 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-09-29 17:50:46,128 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2994 2025-09-25 5337.14
2995 2025-09-26 5325.71
2996 2025-09-27 5325.71
2997 2025-09-28 5322.86
2998 2025-09-29 5322.86
2025-09-29 17:50:46,193 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
3000 2025-09-27 5325.71 ... 2025-09-29 17:50:46.185869 2025-09-29 17:50:46.186239
3001 2025-09-28 5322.86 ... 2025-09-29 17:50:46.185869 2025-09-29 17:50:46.186239
3002 2025-09-29 5322.86 ... 2025-09-29 17:50:46.185869 2025-09-29 17:50:46.186239
[3 rows x 5 columns]
2025-09-29 17:50:46,213 - 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-09-29 17:50:46,841 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3194 2025-09-25 3875.0
3195 2025-09-26 3775.0
3196 2025-09-27 3775.0
3197 2025-09-28 3690.0
3198 2025-09-29 3690.0
2025-09-29 17:50:46,915 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3196 2025-09-27 3775.0 ... 2025-09-29 17:50:46.907872 2025-09-29 17:50:46.908325
3197 2025-09-28 3690.0 ... 2025-09-29 17:50:46.907872 2025-09-29 17:50:46.908325
3198 2025-09-29 3690.0 ... 2025-09-29 17:50:46.907872 2025-09-29 17:50:46.908325
[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-09-29 17:50:47,094 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-09-29 17:50:47.086661
458 2015-09-21 ... 2025-09-29 17:50:47.086661
549 2016-02-03 ... 2025-09-29 17:50:47.086661
693 2016-09-05 ... 2025-09-29 17:50:47.086661
696 2016-09-08 ... 2025-09-29 17:50:47.086661
[5 rows x 6 columns]
2025-09-29 17:50:47,134 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3194 2025-09-25 3875.0
3195 2025-09-26 3775.0
3196 2025-09-27 3775.0
3197 2025-09-28 3690.0
3198 2025-09-29 3690.0
2025-09-29 17:50:47,204 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3199 2025-09-27 3775.0 ... 2025-09-29 17:50:47.196381 2025-09-29 17:50:47.196807
3200 2025-09-28 3690.0 ... 2025-09-29 17:50:47.196381 2025-09-29 17:50:47.196807
3201 2025-09-29 3690.0 ... 2025-09-29 17:50:47.196381 2025-09-29 17:50:47.196807
[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-09-29 17:50:47,368 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-09-29 17:50:47.360759
458 2015-09-21 ... 2025-09-29 17:50:47.360759
549 2016-02-03 ... 2025-09-29 17:50:47.360759
693 2016-09-05 ... 2025-09-29 17:50:47.360759
696 2016-09-08 ... 2025-09-29 17:50:47.360759
[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-09-29 17:50:48,055 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
998 2025-09-25 9700.0
999 2025-09-26 9720.0
1000 2025-09-27 9720.0
1001 2025-09-28 9730.0
1002 2025-09-29 9710.0
2025-09-29 17:50:48,097 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
1000 2025-09-27 9720.0 ... 2025-09-29 17:50:48.090079 2025-09-29 17:50:48.090474
1001 2025-09-28 9730.0 ... 2025-09-29 17:50:48.090079 2025-09-29 17:50:48.090474
1002 2025-09-29 9710.0 ... 2025-09-29 17:50:48.090079 2025-09-29 17:50:48.090474
[3 rows x 5 columns]
2025-09-29 17:50:48,117 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-09-29 17:50:48,123 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
998 2025-09-25 9700.0
999 2025-09-26 9720.0
1000 2025-09-27 9720.0
1001 2025-09-28 9730.0
1002 2025-09-29 9710.0
2025-09-29 17:50:48,164 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
1000 2025-09-27 9720.0 ... 2025-09-29 17:50:48.154831 2025-09-29 17:50:48.155265
1001 2025-09-28 9730.0 ... 2025-09-29 17:50:48.154831 2025-09-29 17:50:48.155265
1002 2025-09-29 9710.0 ... 2025-09-29 17:50:48.154831 2025-09-29 17:50:48.155265
[3 rows x 5 columns]
2025-09-29 17:50:48,185 - 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-09-29 17:50:48,759 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3877 2025-09-25 7346.67
3878 2025-09-26 7345.00
3879 2025-09-27 7345.00
3880 2025-09-28 7355.00
3881 2025-09-29 7355.00
2025-09-29 17:50:48,841 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3879 2025-09-27 7345.0 ... 2025-09-29 17:50:48.833051 2025-09-29 17:50:48.833450
3880 2025-09-28 7355.0 ... 2025-09-29 17:50:48.833051 2025-09-29 17:50:48.833450
3881 2025-09-29 7355.0 ... 2025-09-29 17:50:48.833051 2025-09-29 17:50:48.833450
[3 rows x 5 columns]
2025-09-29 17:50:48,861 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-09-29 17:50:48,868 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3877 2025-09-25 7346.67
3878 2025-09-26 7345.00
3879 2025-09-27 7345.00
3880 2025-09-28 7355.00
3881 2025-09-29 7355.00
2025-09-29 17:50:48,946 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3882 2025-09-27 7345.0 ... 2025-09-29 17:50:48.939048 2025-09-29 17:50:48.939426
3883 2025-09-28 7355.0 ... 2025-09-29 17:50:48.939048 2025-09-29 17:50:48.939426
3884 2025-09-29 7355.0 ... 2025-09-29 17:50:48.939048 2025-09-29 17:50:48.939426
[3 rows x 5 columns]
2025-09-29 17:50:48,967 - 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-09-29 17:50:49,543 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3215 2025-09-25 3603.33
3216 2025-09-26 3603.33
3217 2025-09-27 3603.33
3218 2025-09-28 3603.33
3219 2025-09-29 3593.33
2025-09-29 17:50:49,613 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3218 2025-09-27 3603.33 ... 2025-09-29 17:50:49.605710 2025-09-29 17:50:49.606095
3219 2025-09-28 3603.33 ... 2025-09-29 17:50:49.605710 2025-09-29 17:50:49.606095
3220 2025-09-29 3593.33 ... 2025-09-29 17:50:49.605710 2025-09-29 17:50:49.606095
[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-09-29 17:50:49,650 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-09-29 17:50:49.643727
[1 rows x 6 columns]
2025-09-29 17:50:49,678 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3215 2025-09-25 3603.33
3216 2025-09-26 3603.33
3217 2025-09-27 3603.33
3218 2025-09-28 3603.33
3219 2025-09-29 3593.33
2025-09-29 17:50:49,749 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3220 2025-09-27 3603.33 ... 2025-09-29 17:50:49.741552 2025-09-29 17:50:49.741993
3221 2025-09-28 3603.33 ... 2025-09-29 17:50:49.741552 2025-09-29 17:50:49.741993
3222 2025-09-29 3593.33 ... 2025-09-29 17:50:49.741552 2025-09-29 17:50:49.741993
[3 rows x 5 columns]
2025-09-29 17:50:49,770 - 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-09-29 17:50:50,376 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3880 2025-09-25 20783.33
3881 2025-09-26 20783.33
3882 2025-09-27 20783.33
3883 2025-09-28 20783.33
3884 2025-09-29 20700.00
2025-09-29 17:50:50,451 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date ... updated_at
3882 2025-09-27 ... 2025-09-29 17:50:50.445103
3883 2025-09-28 ... 2025-09-29 17:50:50.445103
3884 2025-09-29 ... 2025-09-29 17:50:50.445103
[3 rows x 5 columns]
2025-09-29 17:50:50,472 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-09-29 17:50:50,478 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3880 2025-09-25 20783.33
3881 2025-09-26 20783.33
3882 2025-09-27 20783.33
3883 2025-09-28 20783.33
3884 2025-09-29 20700.00
2025-09-29 17:50:50,559 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date ... updated_at
3885 2025-09-27 ... 2025-09-29 17:50:50.552514
3886 2025-09-28 ... 2025-09-29 17:50:50.552514
3887 2025-09-29 ... 2025-09-29 17:50:50.552514
[3 rows x 5 columns]
2025-09-29 17:50:50,580 - 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-09-29 17:50:51,158 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2994 2025-09-25 5726.0
2995 2025-09-26 5700.0
2996 2025-09-27 5700.0
2997 2025-09-28 5700.0
2998 2025-09-29 5672.0
2025-09-29 17:50:51,226 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2996 2025-09-27 5700.0 ... 2025-09-29 17:50:51.218991 2025-09-29 17:50:51.219389
2997 2025-09-28 5700.0 ... 2025-09-29 17:50:51.218991 2025-09-29 17:50:51.219389
2998 2025-09-29 5672.0 ... 2025-09-29 17:50:51.218991 2025-09-29 17:50:51.219389
[3 rows x 5 columns]
2025-09-29 17:50:51,246 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-09-29 17:50:51,252 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2994 2025-09-25 5726.0
2995 2025-09-26 5700.0
2996 2025-09-27 5700.0
2997 2025-09-28 5700.0
2998 2025-09-29 5672.0
2025-09-29 17:50:51,320 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
3000 2025-09-27 5700.0 ... 2025-09-29 17:50:51.312296 2025-09-29 17:50:51.312720
3001 2025-09-28 5700.0 ... 2025-09-29 17:50:51.312296 2025-09-29 17:50:51.312720
3002 2025-09-29 5672.0 ... 2025-09-29 17:50:51.312296 2025-09-29 17:50:51.312720
[3 rows x 5 columns]
2025-09-29 17:50:51,340 - 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-09-29 17:50:51,964 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2269 2025-09-25 23550.0
2270 2025-09-26 23550.0
2271 2025-09-27 23550.0
2272 2025-09-28 23550.0
2273 2025-09-29 23550.0
2025-09-29 17:50:52,020 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2271 2025-09-27 23550.0 ... 2025-09-29 17:50:52.013369 2025-09-29 17:50:52.013782
2272 2025-09-28 23550.0 ... 2025-09-29 17:50:52.013369 2025-09-29 17:50:52.013782
2273 2025-09-29 23550.0 ... 2025-09-29 17:50:52.013369 2025-09-29 17:50:52.013782
[3 rows x 5 columns]
2025-09-29 17:50:52,041 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-09-29 17:50:52,046 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2269 2025-09-25 23550.0
2270 2025-09-26 23550.0
2271 2025-09-27 23550.0
2272 2025-09-28 23550.0
2273 2025-09-29 23550.0
2025-09-29 17:50:52,103 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2275 2025-09-27 23550.0 ... 2025-09-29 17:50:52.095680 2025-09-29 17:50:52.096069
2276 2025-09-28 23550.0 ... 2025-09-29 17:50:52.095680 2025-09-29 17:50:52.096069
2277 2025-09-29 23550.0 ... 2025-09-29 17:50:52.095680 2025-09-29 17:50:52.096069
[3 rows x 5 columns]
2025-09-29 17:50:52,123 - 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-09-29 17:50:52,770 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1784 2025-09-25 1647.50
1785 2025-09-26 1636.25
1786 2025-09-27 1636.25
1787 2025-09-28 1631.25
1788 2025-09-29 1621.25
2025-09-29 17:50:52,817 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1786 2025-09-27 1636.25 ... 2025-09-29 17:50:52.809802 2025-09-29 17:50:52.810186
1787 2025-09-28 1631.25 ... 2025-09-29 17:50:52.809802 2025-09-29 17:50:52.810186
1788 2025-09-29 1621.25 ... 2025-09-29 17:50:52.809802 2025-09-29 17:50:52.810186
[3 rows x 5 columns]
2025-09-29 17:50:52,838 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-09-29 17:50:52,843 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1784 2025-09-25 1647.50
1785 2025-09-26 1636.25
1786 2025-09-27 1636.25
1787 2025-09-28 1631.25
1788 2025-09-29 1621.25
2025-09-29 17:50:52,890 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1790 2025-09-27 1636.25 ... 2025-09-29 17:50:52.882901 2025-09-29 17:50:52.883268
1791 2025-09-28 1631.25 ... 2025-09-29 17:50:52.882901 2025-09-29 17:50:52.883268
1792 2025-09-29 1621.25 ... 2025-09-29 17:50:52.882901 2025-09-29 17:50:52.883268
[3 rows x 5 columns]
2025-09-29 17:50:52,910 - 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-09-29 17:50:53,601 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2856 2025-09-25 124400.0
2857 2025-09-26 122700.0
2858 2025-09-27 122700.0
2859 2025-09-28 122700.0
2860 2025-09-29 122050.0
2025-09-29 17:50:53,665 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2858 2025-09-27 ... 2025-09-29 17:50:53.658843
2859 2025-09-28 ... 2025-09-29 17:50:53.658843
2860 2025-09-29 ... 2025-09-29 17:50:53.658843
[3 rows x 5 columns]
2025-09-29 17:50:53,687 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-09-29 17:50:53,696 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2856 2025-09-25 124400.0
2857 2025-09-26 122700.0
2858 2025-09-27 122700.0
2859 2025-09-28 122700.0
2860 2025-09-29 122050.0
2025-09-29 17:50:53,770 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2861 2025-09-27 ... 2025-09-29 17:50:53.763467
2862 2025-09-28 ... 2025-09-29 17:50:53.763467
2863 2025-09-29 ... 2025-09-29 17:50:53.763467
[3 rows x 5 columns]
2025-09-29 17:50:53,790 - 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-09-29 17:50:54,385 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3881 2025-09-25 4648.0
3882 2025-09-26 4635.0
3883 2025-09-27 4635.0
3884 2025-09-28 4624.0
3885 2025-09-29 4626.0
2025-09-29 17:50:54,463 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3883 2025-09-27 4635.0 ... 2025-09-29 17:50:54.456087 2025-09-29 17:50:54.456476
3884 2025-09-28 4624.0 ... 2025-09-29 17:50:54.456087 2025-09-29 17:50:54.456476
3885 2025-09-29 4626.0 ... 2025-09-29 17:50:54.456087 2025-09-29 17:50:54.456476
[3 rows x 5 columns]
2025-09-29 17:50:54,483 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-09-29 17:50:54,490 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3881 2025-09-25 4648.0
3882 2025-09-26 4635.0
3883 2025-09-27 4635.0
3884 2025-09-28 4624.0
3885 2025-09-29 4626.0
2025-09-29 17:50:54,565 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3886 2025-09-27 4635.0 ... 2025-09-29 17:50:54.557853 2025-09-29 17:50:54.558245
3887 2025-09-28 4624.0 ... 2025-09-29 17:50:54.557853 2025-09-29 17:50:54.558245
3888 2025-09-29 4626.0 ... 2025-09-29 17:50:54.557853 2025-09-29 17:50:54.558245
[3 rows x 5 columns]
2025-09-29 17:50:54,585 - 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-09-29 17:50:55,175 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
3120 2025-09-25 6973.33
3121 2025-09-26 6973.33
3122 2025-09-27 6973.33
3123 2025-09-28 6973.33
3124 2025-09-29 6920.00
2025-09-29 17:50:55,250 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
3122 2025-09-27 6973.33 ... 2025-09-29 17:50:55.243068 2025-09-29 17:50:55.243454
3123 2025-09-28 6973.33 ... 2025-09-29 17:50:55.243068 2025-09-29 17:50:55.243454
3124 2025-09-29 6920.00 ... 2025-09-29 17:50:55.243068 2025-09-29 17:50:55.243454
[3 rows x 5 columns]
2025-09-29 17:50:55,271 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-09-29 17:50:55,278 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
3120 2025-09-25 6973.33
3121 2025-09-26 6973.33
3122 2025-09-27 6973.33
3123 2025-09-28 6973.33
3124 2025-09-29 6920.00
2025-09-29 17:50:55,346 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
3125 2025-09-27 6973.33 ... 2025-09-29 17:50:55.339074 2025-09-29 17:50:55.339458
3126 2025-09-28 6973.33 ... 2025-09-29 17:50:55.339074 2025-09-29 17:50:55.339458
3127 2025-09-29 6920.00 ... 2025-09-29 17:50:55.339074 2025-09-29 17:50:55.339458
[3 rows x 5 columns]
2025-09-29 17:50:55,367 - 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-09-29 17:50:56,275 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3882 2025-09-25 15106.67
3883 2025-09-26 15058.50
3884 2025-09-27 15058.50
3885 2025-09-28 15021.67
3886 2025-09-29 14982.50
2025-09-29 17:50:56,359 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date ... updated_at
3884 2025-09-27 ... 2025-09-29 17:50:56.352607
3885 2025-09-28 ... 2025-09-29 17:50:56.352607
3886 2025-09-29 ... 2025-09-29 17:50:56.352607
[3 rows x 5 columns]
2025-09-29 17:50:56,456 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-09-29 17:50:56,463 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3882 2025-09-25 15106.67
3883 2025-09-26 15058.50
3884 2025-09-27 15058.50
3885 2025-09-28 15021.67
3886 2025-09-29 14982.50
2025-09-29 17:50:56,541 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date ... updated_at
3888 2025-09-27 ... 2025-09-29 17:50:56.534831
3889 2025-09-28 ... 2025-09-29 17:50:56.534831
3890 2025-09-29 ... 2025-09-29 17:50:56.534831
[3 rows x 5 columns]
2025-09-29 17:50:56,561 - 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-09-29 17:50:57,162 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3827 2025-09-25 17031.25
3828 2025-09-26 16993.75
3829 2025-09-27 16993.75
3830 2025-09-28 16993.75
3831 2025-09-29 16856.25
2025-09-29 17:50:57,236 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date ... updated_at
3829 2025-09-27 ... 2025-09-29 17:50:57.230039
3830 2025-09-28 ... 2025-09-29 17:50:57.230039
3831 2025-09-29 ... 2025-09-29 17:50:57.230039
[3 rows x 5 columns]
2025-09-29 17:50:57,256 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-09-29 17:50:57,262 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3827 2025-09-25 17031.25
3828 2025-09-26 16993.75
3829 2025-09-27 16993.75
3830 2025-09-28 16993.75
3831 2025-09-29 16856.25
2025-09-29 17:50:57,337 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date ... updated_at
3832 2025-09-27 ... 2025-09-29 17:50:57.330860
3833 2025-09-28 ... 2025-09-29 17:50:57.330860
3834 2025-09-29 ... 2025-09-29 17:50:57.330860
[3 rows x 5 columns]
2025-09-29 17:50:57,357 - 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-09-29 17:50:58,049 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
3102 2025-09-25 3433.33
3103 2025-09-26 3423.33
3104 2025-09-27 3423.33
3105 2025-09-28 3400.00
3106 2025-09-29 3390.00
2025-09-29 17:50:58,115 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
3104 2025-09-27 3423.33 ... 2025-09-29 17:50:58.108006 2025-09-29 17:50:58.108389
3105 2025-09-28 3400.00 ... 2025-09-29 17:50:58.108006 2025-09-29 17:50:58.108389
3106 2025-09-29 3390.00 ... 2025-09-29 17:50:58.108006 2025-09-29 17:50:58.108389
[3 rows x 5 columns]
2025-09-29 17:50:58,135 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-09-29 17:50:58,140 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
3102 2025-09-25 3433.33
3103 2025-09-26 3423.33
3104 2025-09-27 3423.33
3105 2025-09-28 3400.00
3106 2025-09-29 3390.00
2025-09-29 17:50:58,207 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
3107 2025-09-27 3423.33 ... 2025-09-29 17:50:58.200362 2025-09-29 17:50:58.200765
3108 2025-09-28 3400.00 ... 2025-09-29 17:50:58.200362 2025-09-29 17:50:58.200765
3109 2025-09-29 3390.00 ... 2025-09-29 17:50:58.200362 2025-09-29 17:50:58.200765
[3 rows x 5 columns]
2025-09-29 17:50:58,227 - 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-09-29 17:50:58,800 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3382 2025-09-25 5437.5
3383 2025-09-26 5437.5
3384 2025-09-27 5437.5
3385 2025-09-28 5475.0
3386 2025-09-29 5475.0
2025-09-29 17:50:58,874 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3384 2025-09-27 5437.5 ... 2025-09-29 17:50:58.866001 2025-09-29 17:50:58.866434
3385 2025-09-28 5475.0 ... 2025-09-29 17:50:58.866001 2025-09-29 17:50:58.866434
3386 2025-09-29 5475.0 ... 2025-09-29 17:50:58.866001 2025-09-29 17:50:58.866434
[3 rows x 5 columns]
2025-09-29 17:50:58,894 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-09-29 17:50:58,901 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3382 2025-09-25 5437.5
3383 2025-09-26 5437.5
3384 2025-09-27 5437.5
3385 2025-09-28 5475.0
3386 2025-09-29 5475.0
2025-09-29 17:50:58,981 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3871 2025-09-27 5437.5 ... 2025-09-29 17:50:58.973350 2025-09-29 17:50:58.973828
3872 2025-09-28 5475.0 ... 2025-09-29 17:50:58.973350 2025-09-29 17:50:58.973828
3873 2025-09-29 5475.0 ... 2025-09-29 17:50:58.973350 2025-09-29 17:50:58.973828
[3 rows x 5 columns]
2025-09-29 17:50:59,001 - 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-09-29 17:50:59,564 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1446 2025-09-25 12900.0
1447 2025-09-26 12820.0
1448 2025-09-27 12820.0
1449 2025-09-28 12730.0
1450 2025-09-29 12700.0
2025-09-29 17:50:59,610 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1448 2025-09-27 12820.0 ... 2025-09-29 17:50:59.603452 2025-09-29 17:50:59.603873
1449 2025-09-28 12730.0 ... 2025-09-29 17:50:59.603452 2025-09-29 17:50:59.603873
1450 2025-09-29 12700.0 ... 2025-09-29 17:50:59.603452 2025-09-29 17:50:59.603873
[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-09-29 17:50:59,875 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-09-29 17:50:59.866367
117 2021-07-06 ... 2025-09-29 17:50:59.866367
121 2021-07-12 ... 2025-09-29 17:50:59.866367
122 2021-07-13 ... 2025-09-29 17:50:59.866367
194 2021-11-01 ... 2025-09-29 17:50:59.866367
[5 rows x 6 columns]
2025-09-29 17:50:59,939 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1446 2025-09-25 12900.0
1447 2025-09-26 12820.0
1448 2025-09-27 12820.0
1449 2025-09-28 12730.0
1450 2025-09-29 12700.0
2025-09-29 17:50:59,987 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1451 2025-09-27 12820.0 ... 2025-09-29 17:50:59.979164 2025-09-29 17:50:59.979602
1452 2025-09-28 12730.0 ... 2025-09-29 17:50:59.979164 2025-09-29 17:50:59.979602
1453 2025-09-29 12700.0 ... 2025-09-29 17:50:59.979164 2025-09-29 17:50:59.979602
[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-09-29 17:51:00,249 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-09-29 17:51:00.241881
117 2021-07-06 ... 2025-09-29 17:51:00.241881
121 2021-07-12 ... 2025-09-29 17:51:00.241881
122 2021-07-13 ... 2025-09-29 17:51:00.241881
194 2021-11-01 ... 2025-09-29 17:51:00.241881
[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-09-29 17:51:00,966 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3878 2025-09-25 82435.00
3879 2025-09-26 82558.33
3880 2025-09-27 82558.33
3881 2025-09-28 82558.33
3882 2025-09-29 82271.67
2025-09-29 17:51:01,045 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date ... updated_at
3880 2025-09-27 ... 2025-09-29 17:51:01.037067
3881 2025-09-28 ... 2025-09-29 17:51:01.037067
3882 2025-09-29 ... 2025-09-29 17:51:01.037067
[3 rows x 5 columns]
2025-09-29 17:51:01,066 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-09-29 17:51:01,073 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3878 2025-09-25 82435.00
3879 2025-09-26 82558.33
3880 2025-09-27 82558.33
3881 2025-09-28 82558.33
3882 2025-09-29 82271.67
2025-09-29 17:51:01,155 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date ... updated_at
3883 2025-09-27 ... 2025-09-29 17:51:01.149126
3884 2025-09-28 ... 2025-09-29 17:51:01.149126
3885 2025-09-29 ... 2025-09-29 17:51:01.149126
[3 rows x 5 columns]
2025-09-29 17:51:01,176 - 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-09-29 17:51:01,672 - 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-09-29 17:51:01,733 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-09-29 17:51:01,733 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-09-29 17:51:01,739 - 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-09-29 17:51:01,806 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-09-29 17:51:01,806 - 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-09-29 17:51:02,477 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2856 2025-09-25 273987.5
2857 2025-09-26 273800.0
2858 2025-09-27 273800.0
2859 2025-09-28 273800.0
2860 2025-09-29 271400.0
2025-09-29 17:51:02,542 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2858 2025-09-27 ... 2025-09-29 17:51:02.535842
2859 2025-09-28 ... 2025-09-29 17:51:02.535842
2860 2025-09-29 ... 2025-09-29 17:51:02.535842
[3 rows x 5 columns]
2025-09-29 17:51:02,563 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-09-29 17:51:02,569 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2856 2025-09-25 273987.5
2857 2025-09-26 273800.0
2858 2025-09-27 273800.0
2859 2025-09-28 273800.0
2860 2025-09-29 271400.0
2025-09-29 17:51:02,634 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2861 2025-09-27 ... 2025-09-29 17:51:02.628334
2862 2025-09-28 ... 2025-09-29 17:51:02.628334
2863 2025-09-29 ... 2025-09-29 17:51:02.628334
[3 rows x 5 columns]
2025-09-29 17:51:02,654 - 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-09-29 17:51:03,408 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3877 2025-09-25 21864.0
3878 2025-09-26 21948.0
3879 2025-09-27 21948.0
3880 2025-09-28 21948.0
3881 2025-09-29 21618.0
2025-09-29 17:51:03,489 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3879 2025-09-27 21948.0 ... 2025-09-29 17:51:03.481688 2025-09-29 17:51:03.482081
3880 2025-09-28 21948.0 ... 2025-09-29 17:51:03.481688 2025-09-29 17:51:03.482081
3881 2025-09-29 21618.0 ... 2025-09-29 17:51:03.481688 2025-09-29 17:51:03.482081
[3 rows x 5 columns]
2025-09-29 17:51:03,509 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-09-29 17:51:03,515 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3877 2025-09-25 21864.0
3878 2025-09-26 21948.0
3879 2025-09-27 21948.0
3880 2025-09-28 21948.0
3881 2025-09-29 21618.0
2025-09-29 17:51:03,596 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3882 2025-09-27 21948.0 ... 2025-09-29 17:51:03.588710 2025-09-29 17:51:03.589109
3883 2025-09-28 21948.0 ... 2025-09-29 17:51:03.588710 2025-09-29 17:51:03.589109
3884 2025-09-29 21618.0 ... 2025-09-29 17:51:03.588710 2025-09-29 17:51:03.589109
[3 rows x 5 columns]
2025-09-29 17:51:03,616 - 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-09-29 17:51:04,234 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3840 2025-09-25 3385.0
3841 2025-09-26 3370.0
3842 2025-09-27 3370.0
3843 2025-09-28 3357.5
3844 2025-09-29 3357.5
2025-09-29 17:51:04,310 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3842 2025-09-27 3370.0 ... 2025-09-29 17:51:04.303479 2025-09-29 17:51:04.303896
3843 2025-09-28 3357.5 ... 2025-09-29 17:51:04.303479 2025-09-29 17:51:04.303896
3844 2025-09-29 3357.5 ... 2025-09-29 17:51:04.303479 2025-09-29 17:51:04.303896
[3 rows x 5 columns]
2025-09-29 17:51:04,330 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-09-29 17:51:04,336 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3840 2025-09-25 3385.0
3841 2025-09-26 3370.0
3842 2025-09-27 3370.0
3843 2025-09-28 3357.5
3844 2025-09-29 3357.5
2025-09-29 17:51:04,414 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3845 2025-09-27 3370.0 ... 2025-09-29 17:51:04.406707 2025-09-29 17:51:04.407102
3846 2025-09-28 3357.5 ... 2025-09-29 17:51:04.406707 2025-09-29 17:51:04.407102
3847 2025-09-29 3357.5 ... 2025-09-29 17:51:04.406707 2025-09-29 17:51:04.407102
[3 rows x 5 columns]
2025-09-29 17:51:04,433 - 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-09-29 17:51:05,036 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1637 2025-09-25 4575.0
1638 2025-09-26 4592.5
1639 2025-09-27 4592.5
1640 2025-09-28 4592.5
1641 2025-09-29 4580.0
2025-09-29 17:51:05,084 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1639 2025-09-27 4592.5 ... 2025-09-29 17:51:05.077072 2025-09-29 17:51:05.077448
1640 2025-09-28 4592.5 ... 2025-09-29 17:51:05.077072 2025-09-29 17:51:05.077448
1641 2025-09-29 4580.0 ... 2025-09-29 17:51:05.077072 2025-09-29 17:51:05.077448
[3 rows x 5 columns]
2025-09-29 17:51:05,104 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-09-29 17:51:05,110 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1637 2025-09-25 4575.0
1638 2025-09-26 4592.5
1639 2025-09-27 4592.5
1640 2025-09-28 4592.5
1641 2025-09-29 4580.0
2025-09-29 17:51:05,156 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1642 2025-09-27 4592.5 ... 2025-09-29 17:51:05.149741 2025-09-29 17:51:05.150115
1643 2025-09-28 4592.5 ... 2025-09-29 17:51:05.149741 2025-09-29 17:51:05.150115
1644 2025-09-29 4580.0 ... 2025-09-29 17:51:05.149741 2025-09-29 17:51:05.150115
[3 rows x 5 columns]
2025-09-29 17:51:05,179 - 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-09-29 17:51:05,755 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2911 2025-09-25 2288.57
2912 2025-09-26 2288.57
2913 2025-09-27 2288.57
2914 2025-09-28 2288.57
2915 2025-09-29 2288.57
2025-09-29 17:51:05,823 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2913 2025-09-27 2288.57 ... 2025-09-29 17:51:05.815578 2025-09-29 17:51:05.815978
2914 2025-09-28 2288.57 ... 2025-09-29 17:51:05.815578 2025-09-29 17:51:05.815978
2915 2025-09-29 2288.57 ... 2025-09-29 17:51:05.815578 2025-09-29 17:51:05.815978
[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-09-29 17:51:05,864 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2912 2025-09-26 ... 2025-09-29 17:51:05.857323
[1 rows x 6 columns]
2025-09-29 17:51:05,890 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2911 2025-09-25 2288.57
2912 2025-09-26 2288.57
2913 2025-09-27 2288.57
2914 2025-09-28 2288.57
2915 2025-09-29 2288.57
2025-09-29 17:51:05,957 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2916 2025-09-27 2288.57 ... 2025-09-29 17:51:05.949895 2025-09-29 17:51:05.950286
2917 2025-09-28 2288.57 ... 2025-09-29 17:51:05.949895 2025-09-29 17:51:05.950286
2918 2025-09-29 2288.57 ... 2025-09-29 17:51:05.949895 2025-09-29 17:51:05.950286
[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-09-29 17:51:06,000 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2915 2025-09-26 ... 2025-09-29 17:51:05.992584
[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-09-29 17:51:06,646 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2911 2025-09-25 2288.57
2912 2025-09-26 2288.57
2913 2025-09-27 2288.57
2914 2025-09-28 2288.57
2915 2025-09-29 2828.00
2025-09-29 17:51:06,709 - 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-09-29 17:51:06,732 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2915 2025-09-29 ... 2025-09-29 17:51:06.725751
[1 rows x 6 columns]
2025-09-29 17:51:06,758 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2911 2025-09-25 2288.57
2912 2025-09-26 2288.57
2913 2025-09-27 2288.57
2914 2025-09-28 2288.57
2915 2025-09-29 2828.00
2025-09-29 17:51:06,810 - 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-09-29 17:51:06,835 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2918 2025-09-29 ... 2025-09-29 17:51:06.828083
[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-09-29 17:51:07,435 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3268 2025-09-25 10278.33
3269 2025-09-26 10305.00
3270 2025-09-27 10305.00
3271 2025-09-28 10305.00
3272 2025-09-29 10236.67
2025-09-29 17:51:07,493 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-09-29 17:51:07,493 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-09-29 17:51:07,498 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3268 2025-09-25 10278.33
3269 2025-09-26 10305.00
3270 2025-09-27 10305.00
3271 2025-09-28 10305.00
3272 2025-09-29 10236.67
2025-09-29 17:51:07,557 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-09-29 17:51:07,557 - 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-09-29 17:51:08,272 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1952 2025-09-25 4401.67
1953 2025-09-26 4390.00
1954 2025-09-27 4390.00
1955 2025-09-28 4390.00
1956 2025-09-29 4385.00
2025-09-29 17:51:08,324 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1954 2025-09-27 4390.0 ... 2025-09-29 17:51:08.316755 2025-09-29 17:51:08.317158
1955 2025-09-28 4390.0 ... 2025-09-29 17:51:08.316755 2025-09-29 17:51:08.317158
1956 2025-09-29 4385.0 ... 2025-09-29 17:51:08.316755 2025-09-29 17:51:08.317158
[3 rows x 5 columns]
2025-09-29 17:51:08,345 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-09-29 17:51:08,350 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1952 2025-09-25 4401.67
1953 2025-09-26 4390.00
1954 2025-09-27 4390.00
1955 2025-09-28 4390.00
1956 2025-09-29 4385.00
2025-09-29 17:51:08,402 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1957 2025-09-27 4390.0 ... 2025-09-29 17:51:08.395237 2025-09-29 17:51:08.395634
1958 2025-09-28 4390.0 ... 2025-09-29 17:51:08.395237 2025-09-29 17:51:08.395634
1959 2025-09-29 4385.0 ... 2025-09-29 17:51:08.395237 2025-09-29 17:51:08.395634
[3 rows x 5 columns]
2025-09-29 17:51:08,422 - 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-09-29 17:51:09,004 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1961 2025-09-25 5716.67
1962 2025-09-26 5716.67
1963 2025-09-27 5716.67
1964 2025-09-28 5683.33
1965 2025-09-29 5666.67
2025-09-29 17:51:09,059 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1963 2025-09-27 5716.67 ... 2025-09-29 17:51:09.051936 2025-09-29 17:51:09.052322
1964 2025-09-28 5683.33 ... 2025-09-29 17:51:09.051936 2025-09-29 17:51:09.052322
1965 2025-09-29 5666.67 ... 2025-09-29 17:51:09.051936 2025-09-29 17:51:09.052322
[3 rows x 5 columns]
2025-09-29 17:51:09,079 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-09-29 17:51:09,085 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1961 2025-09-25 5716.67
1962 2025-09-26 5716.67
1963 2025-09-27 5716.67
1964 2025-09-28 5683.33
1965 2025-09-29 5666.67
2025-09-29 17:51:09,138 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1966 2025-09-27 5716.67 ... 2025-09-29 17:51:09.130983 2025-09-29 17:51:09.131365
1967 2025-09-28 5683.33 ... 2025-09-29 17:51:09.130983 2025-09-29 17:51:09.131365
1968 2025-09-29 5666.67 ... 2025-09-29 17:51:09.130983 2025-09-29 17:51:09.131365
[3 rows x 5 columns]
2025-09-29 17:51:09,157 - 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-09-29 17:51:09,739 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3629 2025-09-25 9188.0
3630 2025-09-26 9238.0
3631 2025-09-27 9238.0
3632 2025-09-28 9238.0
3633 2025-09-29 9248.0
2025-09-29 17:51:09,813 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3631 2025-09-27 9238.0 ... 2025-09-29 17:51:09.806348 2025-09-29 17:51:09.806754
3632 2025-09-28 9238.0 ... 2025-09-29 17:51:09.806348 2025-09-29 17:51:09.806754
3633 2025-09-29 9248.0 ... 2025-09-29 17:51:09.806348 2025-09-29 17:51:09.806754
[3 rows x 5 columns]
2025-09-29 17:51:09,834 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-09-29 17:51:09,841 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3629 2025-09-25 9188.0
3630 2025-09-26 9238.0
3631 2025-09-27 9238.0
3632 2025-09-28 9238.0
3633 2025-09-29 9248.0
2025-09-29 17:51:09,917 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3634 2025-09-27 9238.0 ... 2025-09-29 17:51:09.909749 2025-09-29 17:51:09.910132
3635 2025-09-28 9238.0 ... 2025-09-29 17:51:09.909749 2025-09-29 17:51:09.910132
3636 2025-09-29 9248.0 ... 2025-09-29 17:51:09.909749 2025-09-29 17:51:09.910132
[3 rows x 5 columns]
2025-09-29 17:51:09,937 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data