=========================================================================
2025-08-11 17:50:26 Mon START TASK.01 IOOppi_data update_data
=========================================================================
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-11 17:50:28,797 - IOOppi_data - INFO : save data to db IOOppi_rb_t data:
date value
3388 2025-08-07 3341.00
3389 2025-08-08 3331.00
3390 2025-08-09 3331.00
3391 2025-08-10 3331.00
3392 2025-08-11 3352.34
2025-08-11 17:50:28,876 - IOOppi_data - INFO : save new data to db IOOppi_rb_t: date value ... created_at updated_at
3390 2025-08-09 3331.00 ... 2025-08-11 17:50:28.868655 2025-08-11 17:50:28.869050
3391 2025-08-10 3331.00 ... 2025-08-11 17:50:28.868655 2025-08-11 17:50:28.869050
3392 2025-08-11 3352.34 ... 2025-08-11 17:50:28.868655 2025-08-11 17:50:28.869050
[3 rows x 5 columns]
2025-08-11 17:50:28,898 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_t: no diff data
2025-08-11 17:50:28,903 - IOOppi_data - INFO : save data to db IOOppi_rb_g data:
date value
3388 2025-08-07 3341.00
3389 2025-08-08 3331.00
3390 2025-08-09 3331.00
3391 2025-08-10 3331.00
3392 2025-08-11 3352.34
2025-08-11 17:50:28,975 - IOOppi_data - INFO : save new data to db IOOppi_rb_g: date value ... created_at updated_at
3393 2025-08-09 3331.00 ... 2025-08-11 17:50:28.968116 2025-08-11 17:50:28.968486
3394 2025-08-10 3331.00 ... 2025-08-11 17:50:28.968116 2025-08-11 17:50:28.968486
3395 2025-08-11 3352.34 ... 2025-08-11 17:50:28.968116 2025-08-11 17:50:28.968486
[3 rows x 5 columns]
2025-08-11 17:50:28,995 - IOOppi_data - INFO : save diff data to db: IOOppi_rb_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-11 17:50:29,729 - IOOppi_data - INFO : save data to db IOOppi_MA_t data:
date value
3609 2025-08-07 2380.83
3610 2025-08-08 2378.33
3611 2025-08-09 2378.33
3612 2025-08-10 2378.33
3613 2025-08-11 2382.50
2025-08-11 17:50:29,805 - IOOppi_data - INFO : save new data to db IOOppi_MA_t: date value ... created_at updated_at
3611 2025-08-09 2378.33 ... 2025-08-11 17:50:29.797979 2025-08-11 17:50:29.798364
3612 2025-08-10 2378.33 ... 2025-08-11 17:50:29.797979 2025-08-11 17:50:29.798364
3613 2025-08-11 2382.50 ... 2025-08-11 17:50:29.797979 2025-08-11 17:50:29.798364
[3 rows x 5 columns]
2025-08-11 17:50:29,825 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_t: no diff data
2025-08-11 17:50:29,831 - IOOppi_data - INFO : save data to db IOOppi_MA_g data:
date value
3609 2025-08-07 2380.83
3610 2025-08-08 2378.33
3611 2025-08-09 2378.33
3612 2025-08-10 2378.33
3613 2025-08-11 2382.50
2025-08-11 17:50:29,907 - IOOppi_data - INFO : save new data to db IOOppi_MA_g: date value ... created_at updated_at
3615 2025-08-09 2378.33 ... 2025-08-11 17:50:29.899793 2025-08-11 17:50:29.900176
3616 2025-08-10 2378.33 ... 2025-08-11 17:50:29.899793 2025-08-11 17:50:29.900176
3617 2025-08-11 2382.50 ... 2025-08-11 17:50:29.899793 2025-08-11 17:50:29.900176
[3 rows x 5 columns]
2025-08-11 17:50:29,926 - IOOppi_data - INFO : save diff data to db: IOOppi_MA_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-11 17:50:30,518 - IOOppi_data - INFO : save data to db IOOppi_PTA_t data:
date value
949 2025-08-07 4771.25
950 2025-08-08 4742.50
951 2025-08-09 4742.50
952 2025-08-10 4742.50
953 2025-08-11 4750.00
2025-08-11 17:50:30,558 - IOOppi_data - INFO : save new data to db IOOppi_PTA_t: date value ... created_at updated_at
951 2025-08-09 4742.5 ... 2025-08-11 17:50:30.551072 2025-08-11 17:50:30.551452
952 2025-08-10 4742.5 ... 2025-08-11 17:50:30.551072 2025-08-11 17:50:30.551452
953 2025-08-11 4750.0 ... 2025-08-11 17:50:30.551072 2025-08-11 17:50:30.551452
[3 rows x 5 columns]
2025-08-11 17:50:30,579 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_t: no diff data
2025-08-11 17:50:30,584 - IOOppi_data - INFO : save data to db IOOppi_PTA_g data:
date value
949 2025-08-07 4771.25
950 2025-08-08 4742.50
951 2025-08-09 4742.50
952 2025-08-10 4742.50
953 2025-08-11 4750.00
2025-08-11 17:50:30,625 - IOOppi_data - INFO : save new data to db IOOppi_PTA_g: date value ... created_at updated_at
951 2025-08-09 4742.5 ... 2025-08-11 17:50:30.618044 2025-08-11 17:50:30.618415
952 2025-08-10 4742.5 ... 2025-08-11 17:50:30.618044 2025-08-11 17:50:30.618415
953 2025-08-11 4750.0 ... 2025-08-11 17:50:30.618044 2025-08-11 17:50:30.618415
[3 rows x 5 columns]
2025-08-11 17:50:30,644 - IOOppi_data - INFO : save diff data to db: IOOppi_PTA_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-11 17:50:31,352 - IOOppi_data - INFO : save data to db IOOppi_ru_t data:
date value
3828 2025-08-07 14625.00
3829 2025-08-08 14675.00
3830 2025-08-09 14675.00
3831 2025-08-10 14675.00
3832 2025-08-11 14816.67
2025-08-11 17:50:31,432 - IOOppi_data - INFO : save new data to db IOOppi_ru_t: date ... updated_at
3830 2025-08-09 ... 2025-08-11 17:50:31.425512
3831 2025-08-10 ... 2025-08-11 17:50:31.425512
3832 2025-08-11 ... 2025-08-11 17:50:31.425512
[3 rows x 5 columns]
2025-08-11 17:50:31,451 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_t: no diff data
2025-08-11 17:50:31,456 - IOOppi_data - INFO : save data to db IOOppi_ru_g data:
date value
3828 2025-08-07 14625.00
3829 2025-08-08 14675.00
3830 2025-08-09 14675.00
3831 2025-08-10 14675.00
3832 2025-08-11 14816.67
2025-08-11 17:50:31,530 - IOOppi_data - INFO : save new data to db IOOppi_ru_g: date ... updated_at
3833 2025-08-09 ... 2025-08-11 17:50:31.524522
3834 2025-08-10 ... 2025-08-11 17:50:31.524522
3835 2025-08-11 ... 2025-08-11 17:50:31.524522
[3 rows x 5 columns]
2025-08-11 17:50:31,550 - IOOppi_data - INFO : save diff data to db: IOOppi_ru_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-11 17:50:32,213 - IOOppi_data - INFO : save data to db IOOppi_i_t data:
date value
3160 2025-08-07 788.56
3161 2025-08-08 785.67
3162 2025-08-09 785.67
3163 2025-08-10 785.67
3164 2025-08-11 790.22
2025-08-11 17:50:32,280 - IOOppi_data - INFO : save new data to db IOOppi_i_t: date value ... created_at updated_at
3162 2025-08-09 785.67 ... 2025-08-11 17:50:32.272836 2025-08-11 17:50:32.273217
3163 2025-08-10 785.67 ... 2025-08-11 17:50:32.272836 2025-08-11 17:50:32.273217
3164 2025-08-11 790.22 ... 2025-08-11 17:50:32.272836 2025-08-11 17:50:32.273217
[3 rows x 5 columns]
2025-08-11 17:50:32,299 - IOOppi_data - INFO : save diff data to db: IOOppi_i_t: no diff data
2025-08-11 17:50:32,305 - IOOppi_data - INFO : save data to db IOOppi_i_g data:
date value
3160 2025-08-07 788.56
3161 2025-08-08 785.67
3162 2025-08-09 785.67
3163 2025-08-10 785.67
3164 2025-08-11 790.22
2025-08-11 17:50:32,372 - IOOppi_data - INFO : save new data to db IOOppi_i_g: date value ... created_at updated_at
3165 2025-08-09 785.67 ... 2025-08-11 17:50:32.364852 2025-08-11 17:50:32.365228
3166 2025-08-10 785.67 ... 2025-08-11 17:50:32.364852 2025-08-11 17:50:32.365228
3167 2025-08-11 790.22 ... 2025-08-11 17:50:32.364852 2025-08-11 17:50:32.365228
[3 rows x 5 columns]
2025-08-11 17:50:32,391 - IOOppi_data - INFO : save diff data to db: IOOppi_i_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-11 17:50:32,951 - IOOppi_data - INFO : save data to db IOOppi_FG_t data:
date value
3363 2025-08-07 1204.0
3364 2025-08-08 1204.0
3365 2025-08-09 1204.0
3366 2025-08-10 1204.0
3367 2025-08-11 1204.0
2025-08-11 17:50:33,022 - IOOppi_data - INFO : save new data to db IOOppi_FG_t: date value ... created_at updated_at
3365 2025-08-09 1204.0 ... 2025-08-11 17:50:33.015149 2025-08-11 17:50:33.015537
3366 2025-08-10 1204.0 ... 2025-08-11 17:50:33.015149 2025-08-11 17:50:33.015537
3367 2025-08-11 1204.0 ... 2025-08-11 17:50:33.015149 2025-08-11 17:50:33.015537
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-08-11 17:50:35,111 - IOOppi_data - INFO : save diff data to db IOOppi_FG_t: date ... updated_at
12 2012-12-19 ... 2025-08-11 17:50:35.103763
21 2013-01-04 ... 2025-08-11 17:50:35.103763
54 2013-02-27 ... 2025-08-11 17:50:35.103763
60 2013-03-07 ... 2025-08-11 17:50:35.103763
61 2013-03-08 ... 2025-08-11 17:50:35.103763
[5 rows x 6 columns]
2025-08-11 17:50:35,280 - IOOppi_data - INFO : save data to db IOOppi_FG_g data:
date value
3363 2025-08-07 1204.0
3364 2025-08-08 1204.0
3365 2025-08-09 1204.0
3366 2025-08-10 1204.0
3367 2025-08-11 1204.0
2025-08-11 17:50:35,352 - IOOppi_data - INFO : save new data to db IOOppi_FG_g: date value ... created_at updated_at
3369 2025-08-09 1204.0 ... 2025-08-11 17:50:35.344785 2025-08-11 17:50:35.345170
3370 2025-08-10 1204.0 ... 2025-08-11 17:50:35.344785 2025-08-11 17:50:35.345170
3371 2025-08-11 1204.0 ... 2025-08-11 17:50:35.344785 2025-08-11 17:50:35.345170
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-08-11 17:50:37,346 - IOOppi_data - INFO : save diff data to db IOOppi_FG_g: date ... updated_at
12 2012-12-19 ... 2025-08-11 17:50:37.337713
21 2013-01-04 ... 2025-08-11 17:50:37.337713
54 2013-02-27 ... 2025-08-11 17:50:37.337713
60 2013-03-07 ... 2025-08-11 17:50:37.337713
61 2013-03-08 ... 2025-08-11 17:50:37.337713
[5 rows x 6 columns]
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-11 17:50:38,132 - IOOppi_data - INFO : save data to db IOOppi_eb_t data:
date value
1708 2025-08-07 7630.0
1709 2025-08-08 7640.0
1710 2025-08-09 7640.0
1711 2025-08-10 7640.0
1712 2025-08-11 7604.0
2025-08-11 17:50:38,181 - IOOppi_data - INFO : save new data to db IOOppi_eb_t: date value ... created_at updated_at
1710 2025-08-09 7640.0 ... 2025-08-11 17:50:38.174021 2025-08-11 17:50:38.174407
1711 2025-08-10 7640.0 ... 2025-08-11 17:50:38.174021 2025-08-11 17:50:38.174407
1712 2025-08-11 7604.0 ... 2025-08-11 17:50:38.174021 2025-08-11 17:50:38.174407
[3 rows x 5 columns]
2025-08-11 17:50:38,201 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_t: no diff data
2025-08-11 17:50:38,206 - IOOppi_data - INFO : save data to db IOOppi_eb_g data:
date value
1708 2025-08-07 7630.0
1709 2025-08-08 7640.0
1710 2025-08-09 7640.0
1711 2025-08-10 7640.0
1712 2025-08-11 7604.0
2025-08-11 17:50:38,254 - IOOppi_data - INFO : save new data to db IOOppi_eb_g: date value ... created_at updated_at
1713 2025-08-09 7640.0 ... 2025-08-11 17:50:38.247301 2025-08-11 17:50:38.247697
1714 2025-08-10 7640.0 ... 2025-08-11 17:50:38.247301 2025-08-11 17:50:38.247697
1715 2025-08-11 7604.0 ... 2025-08-11 17:50:38.247301 2025-08-11 17:50:38.247697
[3 rows x 5 columns]
2025-08-11 17:50:38,273 - IOOppi_data - INFO : save diff data to db: IOOppi_eb_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-11 17:50:38,847 - IOOppi_data - INFO : save data to db IOOppi_SR_t data:
date value
3819 2025-08-07 5956.67
3820 2025-08-08 5946.67
3821 2025-08-09 5946.67
3822 2025-08-10 5946.67
3823 2025-08-11 5953.33
2025-08-11 17:50:38,922 - IOOppi_data - INFO : save new data to db IOOppi_SR_t: date value ... created_at updated_at
3821 2025-08-09 5946.67 ... 2025-08-11 17:50:38.914796 2025-08-11 17:50:38.915183
3822 2025-08-10 5946.67 ... 2025-08-11 17:50:38.914796 2025-08-11 17:50:38.915183
3823 2025-08-11 5953.33 ... 2025-08-11 17:50:38.914796 2025-08-11 17:50:38.915183
[3 rows x 5 columns]
2025-08-11 17:50:38,941 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_t: no diff data
2025-08-11 17:50:38,947 - IOOppi_data - INFO : save data to db IOOppi_SR_g data:
date value
3819 2025-08-07 5956.67
3820 2025-08-08 5946.67
3821 2025-08-09 5946.67
3822 2025-08-10 5946.67
3823 2025-08-11 5953.33
2025-08-11 17:50:39,021 - IOOppi_data - INFO : save new data to db IOOppi_SR_g: date value ... created_at updated_at
3825 2025-08-09 5946.67 ... 2025-08-11 17:50:39.014056 2025-08-11 17:50:39.014449
3826 2025-08-10 5946.67 ... 2025-08-11 17:50:39.014056 2025-08-11 17:50:39.014449
3827 2025-08-11 5953.33 ... 2025-08-11 17:50:39.014056 2025-08-11 17:50:39.014449
[3 rows x 5 columns]
2025-08-11 17:50:39,041 - IOOppi_data - INFO : save diff data to db: IOOppi_SR_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-11 17:50:39,675 - IOOppi_data - INFO : save data to db IOOppi_ss_t data:
date value
1709 2025-08-07 13100.0
1710 2025-08-08 13212.5
1711 2025-08-09 13212.5
1712 2025-08-10 13212.5
1713 2025-08-11 13287.5
2025-08-11 17:50:39,722 - IOOppi_data - INFO : save new data to db IOOppi_ss_t: date value ... created_at updated_at
1711 2025-08-09 13212.5 ... 2025-08-11 17:50:39.714754 2025-08-11 17:50:39.715146
1712 2025-08-10 13212.5 ... 2025-08-11 17:50:39.714754 2025-08-11 17:50:39.715146
1713 2025-08-11 13287.5 ... 2025-08-11 17:50:39.714754 2025-08-11 17:50:39.715146
[3 rows x 5 columns]
2025-08-11 17:50:39,741 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_t: no diff data
2025-08-11 17:50:39,746 - IOOppi_data - INFO : save data to db IOOppi_ss_g data:
date value
1709 2025-08-07 13100.0
1710 2025-08-08 13212.5
1711 2025-08-09 13212.5
1712 2025-08-10 13212.5
1713 2025-08-11 13287.5
2025-08-11 17:50:39,793 - IOOppi_data - INFO : save new data to db IOOppi_ss_g: date value ... created_at updated_at
1714 2025-08-09 13212.5 ... 2025-08-11 17:50:39.785681 2025-08-11 17:50:39.786104
1715 2025-08-10 13212.5 ... 2025-08-11 17:50:39.785681 2025-08-11 17:50:39.786104
1716 2025-08-11 13287.5 ... 2025-08-11 17:50:39.785681 2025-08-11 17:50:39.786104
[3 rows x 5 columns]
2025-08-11 17:50:39,811 - IOOppi_data - INFO : save diff data to db: IOOppi_ss_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-11 17:50:40,767 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3219 2025-08-07 9598.33
3220 2025-08-08 9678.33
3221 2025-08-09 9678.33
3222 2025-08-10 9678.33
3223 2025-08-11 9698.33
2025-08-11 17:50:40,840 - IOOppi_data - INFO : save new data to db IOOppi_RS_t: date value ... created_at updated_at
3221 2025-08-09 9678.33 ... 2025-08-11 17:50:40.832876 2025-08-11 17:50:40.833276
3222 2025-08-10 9678.33 ... 2025-08-11 17:50:40.832876 2025-08-11 17:50:40.833276
3223 2025-08-11 9698.33 ... 2025-08-11 17:50:40.832876 2025-08-11 17:50:40.833276
[3 rows x 5 columns]
2025-08-11 17:50:40,859 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-08-11 17:50:40,865 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3219 2025-08-07 9598.33
3220 2025-08-08 9678.33
3221 2025-08-09 9678.33
3222 2025-08-10 9678.33
3223 2025-08-11 9698.33
2025-08-11 17:50:40,934 - IOOppi_data - INFO : save new data to db IOOppi_RS_g: date value ... created_at updated_at
3225 2025-08-09 9678.33 ... 2025-08-11 17:50:40.926576 2025-08-11 17:50:40.926994
3226 2025-08-10 9678.33 ... 2025-08-11 17:50:40.926576 2025-08-11 17:50:40.926994
3227 2025-08-11 9698.33 ... 2025-08-11 17:50:40.926576 2025-08-11 17:50:40.926994
[3 rows x 5 columns]
2025-08-11 17:50:40,953 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-11 17:50:41,629 - IOOppi_data - INFO : save data to db IOOppi_RM_t data:
date value
3342 2025-08-07 2676.67
3343 2025-08-08 2705.00
3344 2025-08-09 2705.00
3345 2025-08-10 2705.00
3346 2025-08-11 2695.00
2025-08-11 17:50:41,704 - IOOppi_data - INFO : save new data to db IOOppi_RM_t: date value ... created_at updated_at
3344 2025-08-09 2705.0 ... 2025-08-11 17:50:41.695830 2025-08-11 17:50:41.696220
3345 2025-08-10 2705.0 ... 2025-08-11 17:50:41.695830 2025-08-11 17:50:41.696220
3346 2025-08-11 2695.0 ... 2025-08-11 17:50:41.695830 2025-08-11 17:50:41.696220
[3 rows x 5 columns]
2025-08-11 17:50:41,723 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_t: no diff data
2025-08-11 17:50:41,730 - IOOppi_data - INFO : save data to db IOOppi_RM_g data:
date value
3342 2025-08-07 2676.67
3343 2025-08-08 2705.00
3344 2025-08-09 2705.00
3345 2025-08-10 2705.00
3346 2025-08-11 2695.00
2025-08-11 17:50:41,801 - IOOppi_data - INFO : save new data to db IOOppi_RM_g: date value ... created_at updated_at
3348 2025-08-09 2705.0 ... 2025-08-11 17:50:41.793909 2025-08-11 17:50:41.794284
3349 2025-08-10 2705.0 ... 2025-08-11 17:50:41.793909 2025-08-11 17:50:41.794284
3350 2025-08-11 2695.0 ... 2025-08-11 17:50:41.793909 2025-08-11 17:50:41.794284
[3 rows x 5 columns]
2025-08-11 17:50:41,819 - IOOppi_data - INFO : save diff data to db: IOOppi_RM_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-11 17:50:42,529 - IOOppi_data - INFO : save data to db IOOppi_SA_t data:
date value
1546 2025-08-07 1302.5
1547 2025-08-08 1302.5
1548 2025-08-09 1302.5
1549 2025-08-10 1302.5
1550 2025-08-11 1302.5
2025-08-11 17:50:42,573 - IOOppi_data - INFO : save new data to db IOOppi_SA_t: date value ... created_at updated_at
1548 2025-08-09 1302.5 ... 2025-08-11 17:50:42.566112 2025-08-11 17:50:42.566493
1549 2025-08-10 1302.5 ... 2025-08-11 17:50:42.566112 2025-08-11 17:50:42.566493
1550 2025-08-11 1302.5 ... 2025-08-11 17:50:42.566112 2025-08-11 17:50:42.566493
[3 rows x 5 columns]
2025-08-11 17:50:42,592 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_t: no diff data
2025-08-11 17:50:42,598 - IOOppi_data - INFO : save data to db IOOppi_SA_g data:
date value
1546 2025-08-07 1302.5
1547 2025-08-08 1302.5
1548 2025-08-09 1302.5
1549 2025-08-10 1302.5
1550 2025-08-11 1302.5
2025-08-11 17:50:42,642 - IOOppi_data - INFO : save new data to db IOOppi_SA_g: date value ... created_at updated_at
1552 2025-08-09 1302.5 ... 2025-08-11 17:50:42.635356 2025-08-11 17:50:42.635754
1553 2025-08-10 1302.5 ... 2025-08-11 17:50:42.635356 2025-08-11 17:50:42.635754
1554 2025-08-11 1302.5 ... 2025-08-11 17:50:42.635356 2025-08-11 17:50:42.635754
[3 rows x 5 columns]
2025-08-11 17:50:42,661 - IOOppi_data - INFO : save diff data to db: IOOppi_SA_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-11 17:50:43,322 - IOOppi_data - INFO : save data to db IOOppi_PF_t data:
date value
1459 2025-08-07 6474.83
1460 2025-08-08 6475.16
1461 2025-08-09 6475.16
1462 2025-08-10 6475.16
1463 2025-08-11 6483.33
2025-08-11 17:50:43,368 - IOOppi_data - INFO : save new data to db IOOppi_PF_t: date value ... created_at updated_at
1461 2025-08-09 6475.16 ... 2025-08-11 17:50:43.360248 2025-08-11 17:50:43.360755
1462 2025-08-10 6475.16 ... 2025-08-11 17:50:43.360248 2025-08-11 17:50:43.360755
1463 2025-08-11 6483.33 ... 2025-08-11 17:50:43.360248 2025-08-11 17:50:43.360755
[3 rows x 5 columns]
2025-08-11 17:50:43,387 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_t: no diff data
2025-08-11 17:50:43,394 - IOOppi_data - INFO : save data to db IOOppi_PF_g data:
date value
1459 2025-08-07 6474.83
1460 2025-08-08 6475.16
1461 2025-08-09 6475.16
1462 2025-08-10 6475.16
1463 2025-08-11 6483.33
2025-08-11 17:50:43,441 - IOOppi_data - INFO : save new data to db IOOppi_PF_g: date value ... created_at updated_at
1465 2025-08-09 6475.16 ... 2025-08-11 17:50:43.433087 2025-08-11 17:50:43.433497
1466 2025-08-10 6475.16 ... 2025-08-11 17:50:43.433087 2025-08-11 17:50:43.433497
1467 2025-08-11 6483.33 ... 2025-08-11 17:50:43.433087 2025-08-11 17:50:43.433497
[3 rows x 5 columns]
2025-08-11 17:50:43,460 - IOOppi_data - INFO : save diff data to db: IOOppi_PF_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-11 17:50:44,124 - IOOppi_data - INFO : save data to db IOOppi_m_t data:
date value
3832 2025-08-07 3008.0
3833 2025-08-08 3008.0
3834 2025-08-09 3008.0
3835 2025-08-10 3008.0
3836 2025-08-11 3032.0
2025-08-11 17:50:44,201 - IOOppi_data - INFO : save new data to db IOOppi_m_t: date value ... created_at updated_at
3834 2025-08-09 3008.0 ... 2025-08-11 17:50:44.193339 2025-08-11 17:50:44.193763
3835 2025-08-10 3008.0 ... 2025-08-11 17:50:44.193339 2025-08-11 17:50:44.193763
3836 2025-08-11 3032.0 ... 2025-08-11 17:50:44.193339 2025-08-11 17:50:44.193763
[3 rows x 5 columns]
2025-08-11 17:50:44,220 - IOOppi_data - INFO : save diff data to db: IOOppi_m_t: no diff data
2025-08-11 17:50:44,229 - IOOppi_data - INFO : save data to db IOOppi_m_g data:
date value
3832 2025-08-07 3008.0
3833 2025-08-08 3008.0
3834 2025-08-09 3008.0
3835 2025-08-10 3008.0
3836 2025-08-11 3032.0
2025-08-11 17:50:44,313 - IOOppi_data - INFO : save new data to db IOOppi_m_g: date value ... created_at updated_at
3837 2025-08-09 3008.0 ... 2025-08-11 17:50:44.304899 2025-08-11 17:50:44.305311
3838 2025-08-10 3008.0 ... 2025-08-11 17:50:44.304899 2025-08-11 17:50:44.305311
3839 2025-08-11 3032.0 ... 2025-08-11 17:50:44.304899 2025-08-11 17:50:44.305311
[3 rows x 5 columns]
2025-08-11 17:50:44,332 - IOOppi_data - INFO : save diff data to db: IOOppi_m_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-11 17:50:44,927 - IOOppi_data - INFO : save data to db IOOppi_y_t data:
date value
3602 2025-08-07 8458.0
3603 2025-08-08 8468.0
3604 2025-08-09 8468.0
3605 2025-08-10 8468.0
3606 2025-08-11 8508.0
2025-08-11 17:50:45,000 - IOOppi_data - INFO : save new data to db IOOppi_y_t: date value ... created_at updated_at
3604 2025-08-09 8468.0 ... 2025-08-11 17:50:44.992723 2025-08-11 17:50:44.993111
3605 2025-08-10 8468.0 ... 2025-08-11 17:50:44.992723 2025-08-11 17:50:44.993111
3606 2025-08-11 8508.0 ... 2025-08-11 17:50:44.992723 2025-08-11 17:50:44.993111
[3 rows x 5 columns]
2025-08-11 17:50:45,020 - IOOppi_data - INFO : save diff data to db: IOOppi_y_t: no diff data
2025-08-11 17:50:45,028 - IOOppi_data - INFO : save data to db IOOppi_y_g data:
date value
3602 2025-08-07 8458.0
3603 2025-08-08 8468.0
3604 2025-08-09 8468.0
3605 2025-08-10 8468.0
3606 2025-08-11 8508.0
2025-08-11 17:50:45,103 - IOOppi_data - INFO : save new data to db IOOppi_y_g: date value ... created_at updated_at
3607 2025-08-09 8468.0 ... 2025-08-11 17:50:45.095951 2025-08-11 17:50:45.096339
3608 2025-08-10 8468.0 ... 2025-08-11 17:50:45.095951 2025-08-11 17:50:45.096339
3609 2025-08-11 8508.0 ... 2025-08-11 17:50:45.095951 2025-08-11 17:50:45.096339
[3 rows x 5 columns]
2025-08-11 17:50:45,122 - IOOppi_data - INFO : save diff data to db: IOOppi_y_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-11 17:50:45,832 - IOOppi_data - INFO : save data to db IOOppi_a_t data:
date value
3568 2025-08-07 4300.0
3569 2025-08-08 4300.0
3570 2025-08-09 4300.0
3571 2025-08-10 4300.0
3572 2025-08-11 4300.0
2025-08-11 17:50:45,900 - IOOppi_data - INFO : save new data to db IOOppi_a_t: date value ... created_at updated_at
3570 2025-08-09 4300.0 ... 2025-08-11 17:50:45.892991 2025-08-11 17:50:45.893367
3571 2025-08-10 4300.0 ... 2025-08-11 17:50:45.892991 2025-08-11 17:50:45.893367
3572 2025-08-11 4300.0 ... 2025-08-11 17:50:45.892991 2025-08-11 17:50:45.893367
[3 rows x 5 columns]
2025-08-11 17:50:45,919 - IOOppi_data - INFO : save diff data to db: IOOppi_a_t: no diff data
2025-08-11 17:50:45,924 - IOOppi_data - INFO : save data to db IOOppi_a_g data:
date value
3568 2025-08-07 4300.0
3569 2025-08-08 4300.0
3570 2025-08-09 4300.0
3571 2025-08-10 4300.0
3572 2025-08-11 4300.0
2025-08-11 17:50:45,992 - IOOppi_data - INFO : save new data to db IOOppi_a_g: date value ... created_at updated_at
3573 2025-08-09 4300.0 ... 2025-08-11 17:50:45.985200 2025-08-11 17:50:45.985585
3574 2025-08-10 4300.0 ... 2025-08-11 17:50:45.985200 2025-08-11 17:50:45.985585
3575 2025-08-11 4300.0 ... 2025-08-11 17:50:45.985200 2025-08-11 17:50:45.985585
[3 rows x 5 columns]
2025-08-11 17:50:46,011 - IOOppi_data - INFO : save diff data to db: IOOppi_a_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-11 17:50:46,638 - IOOppi_data - INFO : save data to db IOOppi_SF_t data:
date value
2945 2025-08-07 5510.00
2946 2025-08-08 5490.00
2947 2025-08-09 5490.00
2948 2025-08-10 5490.00
2949 2025-08-11 5511.43
2025-08-11 17:50:46,700 - IOOppi_data - INFO : save new data to db IOOppi_SF_t: date value ... created_at updated_at
2947 2025-08-09 5490.00 ... 2025-08-11 17:50:46.692982 2025-08-11 17:50:46.693377
2948 2025-08-10 5490.00 ... 2025-08-11 17:50:46.692982 2025-08-11 17:50:46.693377
2949 2025-08-11 5511.43 ... 2025-08-11 17:50:46.692982 2025-08-11 17:50:46.693377
[3 rows x 5 columns]
2025-08-11 17:50:46,719 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_t: no diff data
2025-08-11 17:50:46,724 - IOOppi_data - INFO : save data to db IOOppi_SF_g data:
date value
2945 2025-08-07 5510.00
2946 2025-08-08 5490.00
2947 2025-08-09 5490.00
2948 2025-08-10 5490.00
2949 2025-08-11 5511.43
2025-08-11 17:50:46,787 - IOOppi_data - INFO : save new data to db IOOppi_SF_g: date value ... created_at updated_at
2951 2025-08-09 5490.00 ... 2025-08-11 17:50:46.780331 2025-08-11 17:50:46.780742
2952 2025-08-10 5490.00 ... 2025-08-11 17:50:46.780331 2025-08-11 17:50:46.780742
2953 2025-08-11 5511.43 ... 2025-08-11 17:50:46.780331 2025-08-11 17:50:46.780742
[3 rows x 5 columns]
2025-08-11 17:50:46,806 - IOOppi_data - INFO : save diff data to db: IOOppi_SF_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-11 17:50:47,386 - IOOppi_data - INFO : save data to db IOOppi_jd_t data:
date value
3145 2025-08-07 3075.0
3146 2025-08-08 3050.0
3147 2025-08-09 3050.0
3148 2025-08-10 3050.0
3149 2025-08-11 3190.0
2025-08-11 17:50:47,451 - IOOppi_data - INFO : save new data to db IOOppi_jd_t: date value ... created_at updated_at
3147 2025-08-09 3050.0 ... 2025-08-11 17:50:47.443459 2025-08-11 17:50:47.443873
3148 2025-08-10 3050.0 ... 2025-08-11 17:50:47.443459 2025-08-11 17:50:47.443873
3149 2025-08-11 3190.0 ... 2025-08-11 17:50:47.443459 2025-08-11 17:50:47.443873
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-08-11 17:50:47,605 - IOOppi_data - INFO : save diff data to db IOOppi_jd_t: date ... updated_at
39 2014-01-03 ... 2025-08-11 17:50:47.597049
458 2015-09-21 ... 2025-08-11 17:50:47.597049
549 2016-02-03 ... 2025-08-11 17:50:47.597049
693 2016-09-05 ... 2025-08-11 17:50:47.597049
696 2016-09-08 ... 2025-08-11 17:50:47.597049
[5 rows x 6 columns]
2025-08-11 17:50:47,639 - IOOppi_data - INFO : save data to db IOOppi_jd_g data:
date value
3145 2025-08-07 3075.0
3146 2025-08-08 3050.0
3147 2025-08-09 3050.0
3148 2025-08-10 3050.0
3149 2025-08-11 3190.0
2025-08-11 17:50:47,705 - IOOppi_data - INFO : save new data to db IOOppi_jd_g: date value ... created_at updated_at
3150 2025-08-09 3050.0 ... 2025-08-11 17:50:47.697677 2025-08-11 17:50:47.698063
3151 2025-08-10 3050.0 ... 2025-08-11 17:50:47.697677 2025-08-11 17:50:47.698063
3152 2025-08-11 3190.0 ... 2025-08-11 17:50:47.697677 2025-08-11 17:50:47.698063
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-08-11 17:50:47,858 - IOOppi_data - INFO : save diff data to db IOOppi_jd_g: date ... updated_at
39 2014-01-03 ... 2025-08-11 17:50:47.849816
458 2015-09-21 ... 2025-08-11 17:50:47.849816
549 2016-02-03 ... 2025-08-11 17:50:47.849816
693 2016-09-05 ... 2025-08-11 17:50:47.849816
696 2016-09-08 ... 2025-08-11 17:50:47.849816
[5 rows x 6 columns]
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-11 17:50:48,551 - IOOppi_data - INFO : save data to db IOOppi_SI_t data:
date value
949 2025-08-07 9590.0
950 2025-08-08 9590.0
951 2025-08-09 9590.0
952 2025-08-10 9590.0
953 2025-08-11 9630.0
2025-08-11 17:50:48,589 - IOOppi_data - INFO : save new data to db IOOppi_SI_t: date value ... created_at updated_at
951 2025-08-09 9590.0 ... 2025-08-11 17:50:48.581546 2025-08-11 17:50:48.581966
952 2025-08-10 9590.0 ... 2025-08-11 17:50:48.581546 2025-08-11 17:50:48.581966
953 2025-08-11 9630.0 ... 2025-08-11 17:50:48.581546 2025-08-11 17:50:48.581966
[3 rows x 5 columns]
2025-08-11 17:50:48,607 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_t: no diff data
2025-08-11 17:50:48,613 - IOOppi_data - INFO : save data to db IOOppi_SI_g data:
date value
949 2025-08-07 9590.0
950 2025-08-08 9590.0
951 2025-08-09 9590.0
952 2025-08-10 9590.0
953 2025-08-11 9630.0
2025-08-11 17:50:48,651 - IOOppi_data - INFO : save new data to db IOOppi_SI_g: date value ... created_at updated_at
951 2025-08-09 9590.0 ... 2025-08-11 17:50:48.643607 2025-08-11 17:50:48.644004
952 2025-08-10 9590.0 ... 2025-08-11 17:50:48.643607 2025-08-11 17:50:48.644004
953 2025-08-11 9630.0 ... 2025-08-11 17:50:48.643607 2025-08-11 17:50:48.644004
[3 rows x 5 columns]
2025-08-11 17:50:48,670 - IOOppi_data - INFO : save diff data to db: IOOppi_SI_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-11 17:50:49,270 - IOOppi_data - INFO : save data to db IOOppi_l_t data:
date value
3828 2025-08-07 7445.00
3829 2025-08-08 7436.67
3830 2025-08-09 7436.67
3831 2025-08-10 7436.67
3832 2025-08-11 7441.67
2025-08-11 17:50:49,344 - IOOppi_data - INFO : save new data to db IOOppi_l_t: date value ... created_at updated_at
3830 2025-08-09 7436.67 ... 2025-08-11 17:50:49.336908 2025-08-11 17:50:49.337305
3831 2025-08-10 7436.67 ... 2025-08-11 17:50:49.336908 2025-08-11 17:50:49.337305
3832 2025-08-11 7441.67 ... 2025-08-11 17:50:49.336908 2025-08-11 17:50:49.337305
[3 rows x 5 columns]
2025-08-11 17:50:49,363 - IOOppi_data - INFO : save diff data to db: IOOppi_l_t: no diff data
2025-08-11 17:50:49,369 - IOOppi_data - INFO : save data to db IOOppi_l_g data:
date value
3828 2025-08-07 7445.00
3829 2025-08-08 7436.67
3830 2025-08-09 7436.67
3831 2025-08-10 7436.67
3832 2025-08-11 7441.67
2025-08-11 17:50:49,444 - IOOppi_data - INFO : save new data to db IOOppi_l_g: date value ... created_at updated_at
3833 2025-08-09 7436.67 ... 2025-08-11 17:50:49.437140 2025-08-11 17:50:49.437544
3834 2025-08-10 7436.67 ... 2025-08-11 17:50:49.437140 2025-08-11 17:50:49.437544
3835 2025-08-11 7441.67 ... 2025-08-11 17:50:49.437140 2025-08-11 17:50:49.437544
[3 rows x 5 columns]
2025-08-11 17:50:49,463 - IOOppi_data - INFO : save diff data to db: IOOppi_l_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-11 17:50:50,164 - IOOppi_data - INFO : save data to db IOOppi_bu_t data:
date value
3166 2025-08-07 3700.00
3167 2025-08-08 3686.67
3168 2025-08-09 3686.67
3169 2025-08-10 3686.67
3170 2025-08-11 3670.00
2025-08-11 17:50:50,230 - IOOppi_data - INFO : save new data to db IOOppi_bu_t: date value ... created_at updated_at
3169 2025-08-09 3686.67 ... 2025-08-11 17:50:50.222950 2025-08-11 17:50:50.223335
3170 2025-08-10 3686.67 ... 2025-08-11 17:50:50.222950 2025-08-11 17:50:50.223335
3171 2025-08-11 3670.00 ... 2025-08-11 17:50:50.222950 2025-08-11 17:50:50.223335
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-08-11 17:50:50,266 - IOOppi_data - INFO : save diff data to db IOOppi_bu_t: date ... updated_at
2560 2023-12-09 ... 2025-08-11 17:50:50.258946
[1 rows x 6 columns]
2025-08-11 17:50:50,292 - IOOppi_data - INFO : save data to db IOOppi_bu_g data:
date value
3166 2025-08-07 3700.00
3167 2025-08-08 3686.67
3168 2025-08-09 3686.67
3169 2025-08-10 3686.67
3170 2025-08-11 3670.00
2025-08-11 17:50:50,360 - IOOppi_data - INFO : save new data to db IOOppi_bu_g: date value ... created_at updated_at
3171 2025-08-09 3686.67 ... 2025-08-11 17:50:50.352051 2025-08-11 17:50:50.352470
3172 2025-08-10 3686.67 ... 2025-08-11 17:50:50.352051 2025-08-11 17:50:50.352470
3173 2025-08-11 3670.00 ... 2025-08-11 17:50:50.352051 2025-08-11 17:50:50.352470
[3 rows x 5 columns]
2025-08-11 17:50:50,379 - IOOppi_data - INFO : save diff data to db: IOOppi_bu_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-11 17:50:51,263 - IOOppi_data - INFO : save data to db IOOppi_al_t data:
date value
3831 2025-08-07 20703.33
3832 2025-08-08 20703.33
3833 2025-08-09 20666.67
3834 2025-08-10 20666.67
3835 2025-08-11 20650.00
2025-08-11 17:50:51,337 - IOOppi_data - INFO : save new data to db IOOppi_al_t: date ... updated_at
3833 2025-08-09 ... 2025-08-11 17:50:51.330335
3834 2025-08-10 ... 2025-08-11 17:50:51.330335
3835 2025-08-11 ... 2025-08-11 17:50:51.330335
[3 rows x 5 columns]
2025-08-11 17:50:51,356 - IOOppi_data - INFO : save diff data to db: IOOppi_al_t: no diff data
2025-08-11 17:50:51,363 - IOOppi_data - INFO : save data to db IOOppi_al_g data:
date value
3831 2025-08-07 20703.33
3832 2025-08-08 20703.33
3833 2025-08-09 20666.67
3834 2025-08-10 20666.67
3835 2025-08-11 20650.00
2025-08-11 17:50:51,442 - IOOppi_data - INFO : save new data to db IOOppi_al_g: date ... updated_at
3836 2025-08-09 ... 2025-08-11 17:50:51.434942
3837 2025-08-10 ... 2025-08-11 17:50:51.434942
3838 2025-08-11 ... 2025-08-11 17:50:51.434942
[3 rows x 5 columns]
2025-08-11 17:50:51,462 - IOOppi_data - INFO : save diff data to db: IOOppi_al_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-11 17:50:52,177 - IOOppi_data - INFO : save data to db IOOppi_SM_t data:
date value
2945 2025-08-07 5864.0
2946 2025-08-08 5846.0
2947 2025-08-09 5846.0
2948 2025-08-10 5846.0
2949 2025-08-11 5880.0
2025-08-11 17:50:52,240 - IOOppi_data - INFO : save new data to db IOOppi_SM_t: date value ... created_at updated_at
2947 2025-08-09 5846.0 ... 2025-08-11 17:50:52.232433 2025-08-11 17:50:52.232844
2948 2025-08-10 5846.0 ... 2025-08-11 17:50:52.232433 2025-08-11 17:50:52.232844
2949 2025-08-11 5880.0 ... 2025-08-11 17:50:52.232433 2025-08-11 17:50:52.232844
[3 rows x 5 columns]
2025-08-11 17:50:52,260 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_t: no diff data
2025-08-11 17:50:52,266 - IOOppi_data - INFO : save data to db IOOppi_SM_g data:
date value
2945 2025-08-07 5864.0
2946 2025-08-08 5846.0
2947 2025-08-09 5846.0
2948 2025-08-10 5846.0
2949 2025-08-11 5880.0
2025-08-11 17:50:52,331 - IOOppi_data - INFO : save new data to db IOOppi_SM_g: date value ... created_at updated_at
2951 2025-08-09 5846.0 ... 2025-08-11 17:50:52.323614 2025-08-11 17:50:52.324006
2952 2025-08-10 5846.0 ... 2025-08-11 17:50:52.323614 2025-08-11 17:50:52.324006
2953 2025-08-11 5880.0 ... 2025-08-11 17:50:52.323614 2025-08-11 17:50:52.324006
[3 rows x 5 columns]
2025-08-11 17:50:52,349 - IOOppi_data - INFO : save diff data to db: IOOppi_SM_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-11 17:50:53,015 - IOOppi_data - INFO : save data to db IOOppi_CY_t data:
date value
2220 2025-08-07 23600.0
2221 2025-08-08 23600.0
2222 2025-08-09 23600.0
2223 2025-08-10 23600.0
2224 2025-08-11 23600.0
2025-08-11 17:50:53,069 - IOOppi_data - INFO : save new data to db IOOppi_CY_t: date value ... created_at updated_at
2222 2025-08-09 23600.0 ... 2025-08-11 17:50:53.062444 2025-08-11 17:50:53.062855
2223 2025-08-10 23600.0 ... 2025-08-11 17:50:53.062444 2025-08-11 17:50:53.062855
2224 2025-08-11 23600.0 ... 2025-08-11 17:50:53.062444 2025-08-11 17:50:53.062855
[3 rows x 5 columns]
2025-08-11 17:50:53,089 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_t: no diff data
2025-08-11 17:50:53,094 - IOOppi_data - INFO : save data to db IOOppi_CY_g data:
date value
2220 2025-08-07 23600.0
2221 2025-08-08 23600.0
2222 2025-08-09 23600.0
2223 2025-08-10 23600.0
2224 2025-08-11 23600.0
2025-08-11 17:50:53,147 - IOOppi_data - INFO : save new data to db IOOppi_CY_g: date value ... created_at updated_at
2226 2025-08-09 23600.0 ... 2025-08-11 17:50:53.139963 2025-08-11 17:50:53.140341
2227 2025-08-10 23600.0 ... 2025-08-11 17:50:53.139963 2025-08-11 17:50:53.140341
2228 2025-08-11 23600.0 ... 2025-08-11 17:50:53.139963 2025-08-11 17:50:53.140341
[3 rows x 5 columns]
2025-08-11 17:50:53,166 - IOOppi_data - INFO : save diff data to db: IOOppi_CY_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-11 17:50:53,769 - IOOppi_data - INFO : save data to db IOOppi_UR_t data:
date value
1735 2025-08-07 1795.0
1736 2025-08-08 1792.5
1737 2025-08-09 1792.5
1738 2025-08-10 1792.5
1739 2025-08-11 1777.5
2025-08-11 17:50:53,815 - IOOppi_data - INFO : save new data to db IOOppi_UR_t: date value ... created_at updated_at
1737 2025-08-09 1792.5 ... 2025-08-11 17:50:53.808289 2025-08-11 17:50:53.808687
1738 2025-08-10 1792.5 ... 2025-08-11 17:50:53.808289 2025-08-11 17:50:53.808687
1739 2025-08-11 1777.5 ... 2025-08-11 17:50:53.808289 2025-08-11 17:50:53.808687
[3 rows x 5 columns]
2025-08-11 17:50:53,834 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_t: no diff data
2025-08-11 17:50:53,839 - IOOppi_data - INFO : save data to db IOOppi_UR_g data:
date value
1735 2025-08-07 1795.0
1736 2025-08-08 1792.5
1737 2025-08-09 1792.5
1738 2025-08-10 1792.5
1739 2025-08-11 1777.5
2025-08-11 17:50:53,888 - IOOppi_data - INFO : save new data to db IOOppi_UR_g: date value ... created_at updated_at
1741 2025-08-09 1792.5 ... 2025-08-11 17:50:53.880419 2025-08-11 17:50:53.880845
1742 2025-08-10 1792.5 ... 2025-08-11 17:50:53.880419 2025-08-11 17:50:53.880845
1743 2025-08-11 1777.5 ... 2025-08-11 17:50:53.880419 2025-08-11 17:50:53.880845
[3 rows x 5 columns]
2025-08-11 17:50:53,907 - IOOppi_data - INFO : save diff data to db: IOOppi_UR_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-11 17:50:54,552 - IOOppi_data - INFO : save data to db IOOppi_ni_t data:
date value
2807 2025-08-07 122433.33
2808 2025-08-08 122316.67
2809 2025-08-09 122316.67
2810 2025-08-10 122316.67
2811 2025-08-11 123316.67
2025-08-11 17:50:54,611 - IOOppi_data - INFO : save new data to db IOOppi_ni_t: date ... updated_at
2809 2025-08-09 ... 2025-08-11 17:50:54.605021
2810 2025-08-10 ... 2025-08-11 17:50:54.605021
2811 2025-08-11 ... 2025-08-11 17:50:54.605021
[3 rows x 5 columns]
2025-08-11 17:50:54,630 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_t: no diff data
2025-08-11 17:50:54,636 - IOOppi_data - INFO : save data to db IOOppi_ni_g data:
date value
2807 2025-08-07 122433.33
2808 2025-08-08 122316.67
2809 2025-08-09 122316.67
2810 2025-08-10 122316.67
2811 2025-08-11 123316.67
2025-08-11 17:50:54,695 - IOOppi_data - INFO : save new data to db IOOppi_ni_g: date ... updated_at
2812 2025-08-09 ... 2025-08-11 17:50:54.689395
2813 2025-08-10 ... 2025-08-11 17:50:54.689395
2814 2025-08-11 ... 2025-08-11 17:50:54.689395
[3 rows x 5 columns]
2025-08-11 17:50:54,714 - IOOppi_data - INFO : save diff data to db: IOOppi_ni_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-11 17:50:55,380 - IOOppi_data - INFO : save data to db IOOppi_v_t data:
date value
3832 2025-08-07 4827.0
3833 2025-08-08 4780.0
3834 2025-08-09 4780.0
3835 2025-08-10 4780.0
3836 2025-08-11 4805.0
2025-08-11 17:50:55,456 - IOOppi_data - INFO : save new data to db IOOppi_v_t: date value ... created_at updated_at
3834 2025-08-09 4780.0 ... 2025-08-11 17:50:55.448693 2025-08-11 17:50:55.449078
3835 2025-08-10 4780.0 ... 2025-08-11 17:50:55.448693 2025-08-11 17:50:55.449078
3836 2025-08-11 4805.0 ... 2025-08-11 17:50:55.448693 2025-08-11 17:50:55.449078
[3 rows x 5 columns]
2025-08-11 17:50:55,475 - IOOppi_data - INFO : save diff data to db: IOOppi_v_t: no diff data
2025-08-11 17:50:55,481 - IOOppi_data - INFO : save data to db IOOppi_v_g data:
date value
3832 2025-08-07 4827.0
3833 2025-08-08 4780.0
3834 2025-08-09 4780.0
3835 2025-08-10 4780.0
3836 2025-08-11 4805.0
2025-08-11 17:50:55,555 - IOOppi_data - INFO : save new data to db IOOppi_v_g: date value ... created_at updated_at
3837 2025-08-09 4780.0 ... 2025-08-11 17:50:55.548243 2025-08-11 17:50:55.548676
3838 2025-08-10 4780.0 ... 2025-08-11 17:50:55.548243 2025-08-11 17:50:55.548676
3839 2025-08-11 4805.0 ... 2025-08-11 17:50:55.548243 2025-08-11 17:50:55.548676
[3 rows x 5 columns]
2025-08-11 17:50:55,574 - IOOppi_data - INFO : save diff data to db: IOOppi_v_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-11 17:50:56,228 - IOOppi_data - INFO : save data to db IOOppi_pp_t data:
date value
3071 2025-08-07 7255.00
3072 2025-08-08 7246.67
3073 2025-08-09 7246.67
3074 2025-08-10 7246.67
3075 2025-08-11 7246.67
2025-08-11 17:50:56,292 - IOOppi_data - INFO : save new data to db IOOppi_pp_t: date value ... created_at updated_at
3073 2025-08-09 7246.67 ... 2025-08-11 17:50:56.284952 2025-08-11 17:50:56.285332
3074 2025-08-10 7246.67 ... 2025-08-11 17:50:56.284952 2025-08-11 17:50:56.285332
3075 2025-08-11 7246.67 ... 2025-08-11 17:50:56.284952 2025-08-11 17:50:56.285332
[3 rows x 5 columns]
2025-08-11 17:50:56,311 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_t: no diff data
2025-08-11 17:50:56,317 - IOOppi_data - INFO : save data to db IOOppi_pp_g data:
date value
3071 2025-08-07 7255.00
3072 2025-08-08 7246.67
3073 2025-08-09 7246.67
3074 2025-08-10 7246.67
3075 2025-08-11 7246.67
2025-08-11 17:50:56,380 - IOOppi_data - INFO : save new data to db IOOppi_pp_g: date value ... created_at updated_at
3076 2025-08-09 7246.67 ... 2025-08-11 17:50:56.373121 2025-08-11 17:50:56.373497
3077 2025-08-10 7246.67 ... 2025-08-11 17:50:56.373121 2025-08-11 17:50:56.373497
3078 2025-08-11 7246.67 ... 2025-08-11 17:50:56.373121 2025-08-11 17:50:56.373497
[3 rows x 5 columns]
2025-08-11 17:50:56,399 - IOOppi_data - INFO : save diff data to db: IOOppi_pp_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-11 17:50:57,085 - IOOppi_data - INFO : save data to db IOOppi_CF_t data:
date value
3833 2025-08-07 15207.50
3834 2025-08-08 15192.83
3835 2025-08-09 15192.83
3836 2025-08-10 15192.83
3837 2025-08-11 15179.00
2025-08-11 17:50:57,158 - IOOppi_data - INFO : save new data to db IOOppi_CF_t: date ... updated_at
3835 2025-08-09 ... 2025-08-11 17:50:57.151976
3836 2025-08-10 ... 2025-08-11 17:50:57.151976
3837 2025-08-11 ... 2025-08-11 17:50:57.151976
[3 rows x 5 columns]
2025-08-11 17:50:57,178 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_t: no diff data
2025-08-11 17:50:57,183 - IOOppi_data - INFO : save data to db IOOppi_CF_g data:
date value
3833 2025-08-07 15207.50
3834 2025-08-08 15192.83
3835 2025-08-09 15192.83
3836 2025-08-10 15192.83
3837 2025-08-11 15179.00
2025-08-11 17:50:57,257 - IOOppi_data - INFO : save new data to db IOOppi_CF_g: date ... updated_at
3839 2025-08-09 ... 2025-08-11 17:50:57.250421
3840 2025-08-10 ... 2025-08-11 17:50:57.250421
3841 2025-08-11 ... 2025-08-11 17:50:57.250421
[3 rows x 5 columns]
2025-08-11 17:50:57,276 - IOOppi_data - INFO : save diff data to db: IOOppi_CF_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-11 17:50:57,966 - IOOppi_data - INFO : save data to db IOOppi_pb_t data:
date value
3778 2025-08-07 16825.00
3779 2025-08-08 16812.50
3780 2025-08-09 16812.50
3781 2025-08-10 16812.50
3782 2025-08-11 16818.75
2025-08-11 17:50:58,038 - IOOppi_data - INFO : save new data to db IOOppi_pb_t: date ... updated_at
3780 2025-08-09 ... 2025-08-11 17:50:58.032271
3781 2025-08-10 ... 2025-08-11 17:50:58.032271
3782 2025-08-11 ... 2025-08-11 17:50:58.032271
[3 rows x 5 columns]
2025-08-11 17:50:58,057 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_t: no diff data
2025-08-11 17:50:58,063 - IOOppi_data - INFO : save data to db IOOppi_pb_g data:
date value
3778 2025-08-07 16825.00
3779 2025-08-08 16812.50
3780 2025-08-09 16812.50
3781 2025-08-10 16812.50
3782 2025-08-11 16818.75
2025-08-11 17:50:58,135 - IOOppi_data - INFO : save new data to db IOOppi_pb_g: date ... updated_at
3783 2025-08-09 ... 2025-08-11 17:50:58.128592
3784 2025-08-10 ... 2025-08-11 17:50:58.128592
3785 2025-08-11 ... 2025-08-11 17:50:58.128592
[3 rows x 5 columns]
2025-08-11 17:50:58,154 - IOOppi_data - INFO : save diff data to db: IOOppi_pb_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-11 17:50:58,927 - IOOppi_data - INFO : save data to db IOOppi_hc_t data:
date value
3053 2025-08-07 3496.67
3054 2025-08-08 3476.67
3055 2025-08-09 3476.67
3056 2025-08-10 3476.67
3057 2025-08-11 3490.00
2025-08-11 17:50:58,992 - IOOppi_data - INFO : save new data to db IOOppi_hc_t: date value ... created_at updated_at
3055 2025-08-09 3476.67 ... 2025-08-11 17:50:58.985785 2025-08-11 17:50:58.986154
3056 2025-08-10 3476.67 ... 2025-08-11 17:50:58.985785 2025-08-11 17:50:58.986154
3057 2025-08-11 3490.00 ... 2025-08-11 17:50:58.985785 2025-08-11 17:50:58.986154
[3 rows x 5 columns]
2025-08-11 17:50:59,011 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_t: no diff data
2025-08-11 17:50:59,017 - IOOppi_data - INFO : save data to db IOOppi_hc_g data:
date value
3053 2025-08-07 3496.67
3054 2025-08-08 3476.67
3055 2025-08-09 3476.67
3056 2025-08-10 3476.67
3057 2025-08-11 3490.00
2025-08-11 17:50:59,080 - IOOppi_data - INFO : save new data to db IOOppi_hc_g: date value ... created_at updated_at
3058 2025-08-09 3476.67 ... 2025-08-11 17:50:59.073362 2025-08-11 17:50:59.073761
3059 2025-08-10 3476.67 ... 2025-08-11 17:50:59.073362 2025-08-11 17:50:59.073761
3060 2025-08-11 3490.00 ... 2025-08-11 17:50:59.073362 2025-08-11 17:50:59.073761
[3 rows x 5 columns]
2025-08-11 17:50:59,099 - IOOppi_data - INFO : save diff data to db: IOOppi_hc_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-11 17:50:59,692 - IOOppi_data - INFO : save data to db IOOppi_fu_t data:
date value
3333 2025-08-07 5325.0
3334 2025-08-08 5325.0
3335 2025-08-09 5325.0
3336 2025-08-10 5325.0
3337 2025-08-11 5325.0
2025-08-11 17:50:59,828 - IOOppi_data - INFO : save new data to db IOOppi_fu_t: date value ... created_at updated_at
3335 2025-08-09 5325.0 ... 2025-08-11 17:50:59.821210 2025-08-11 17:50:59.821619
3336 2025-08-10 5325.0 ... 2025-08-11 17:50:59.821210 2025-08-11 17:50:59.821619
3337 2025-08-11 5325.0 ... 2025-08-11 17:50:59.821210 2025-08-11 17:50:59.821619
[3 rows x 5 columns]
2025-08-11 17:50:59,847 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_t: no diff data
2025-08-11 17:50:59,853 - IOOppi_data - INFO : save data to db IOOppi_fu_g data:
date value
3333 2025-08-07 5325.0
3334 2025-08-08 5325.0
3335 2025-08-09 5325.0
3336 2025-08-10 5325.0
3337 2025-08-11 5325.0
2025-08-11 17:50:59,926 - IOOppi_data - INFO : save new data to db IOOppi_fu_g: date value ... created_at updated_at
3822 2025-08-09 5325.0 ... 2025-08-11 17:50:59.918761 2025-08-11 17:50:59.919144
3823 2025-08-10 5325.0 ... 2025-08-11 17:50:59.918761 2025-08-11 17:50:59.919144
3824 2025-08-11 5325.0 ... 2025-08-11 17:50:59.918761 2025-08-11 17:50:59.919144
[3 rows x 5 columns]
2025-08-11 17:50:59,944 - IOOppi_data - INFO : save diff data to db: IOOppi_fu_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-11 17:51:00,648 - IOOppi_data - INFO : save data to db IOOppi_lh_t data:
date value
1397 2025-08-07 14180.0
1398 2025-08-08 14080.0
1399 2025-08-09 14080.0
1400 2025-08-10 14080.0
1401 2025-08-11 14020.0
2025-08-11 17:51:00,689 - IOOppi_data - INFO : save new data to db IOOppi_lh_t: date value ... created_at updated_at
1399 2025-08-09 14080.0 ... 2025-08-11 17:51:00.682480 2025-08-11 17:51:00.682884
1400 2025-08-10 14080.0 ... 2025-08-11 17:51:00.682480 2025-08-11 17:51:00.682884
1401 2025-08-11 14020.0 ... 2025-08-11 17:51:00.682480 2025-08-11 17:51:00.682884
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-08-11 17:51:00,927 - IOOppi_data - INFO : save diff data to db IOOppi_lh_t: date ... updated_at
116 2021-07-05 ... 2025-08-11 17:51:00.919444
117 2021-07-06 ... 2025-08-11 17:51:00.919444
121 2021-07-12 ... 2025-08-11 17:51:00.919444
122 2021-07-13 ... 2025-08-11 17:51:00.919444
194 2021-11-01 ... 2025-08-11 17:51:00.919444
[5 rows x 6 columns]
2025-08-11 17:51:00,963 - IOOppi_data - INFO : save data to db IOOppi_lh_g data:
date value
1397 2025-08-07 14180.0
1398 2025-08-08 14080.0
1399 2025-08-09 14080.0
1400 2025-08-10 14080.0
1401 2025-08-11 14020.0
2025-08-11 17:51:01,005 - IOOppi_data - INFO : save new data to db IOOppi_lh_g: date value ... created_at updated_at
1402 2025-08-09 14080.0 ... 2025-08-11 17:51:00.998204 2025-08-11 17:51:00.998580
1403 2025-08-10 14080.0 ... 2025-08-11 17:51:00.998204 2025-08-11 17:51:00.998580
1404 2025-08-11 14020.0 ... 2025-08-11 17:51:00.998204 2025-08-11 17:51:00.998580
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-08-11 17:51:01,244 - IOOppi_data - INFO : save diff data to db IOOppi_lh_g: date ... updated_at
116 2021-07-05 ... 2025-08-11 17:51:01.235117
117 2021-07-06 ... 2025-08-11 17:51:01.235117
121 2021-07-12 ... 2025-08-11 17:51:01.235117
122 2021-07-13 ... 2025-08-11 17:51:01.235117
194 2021-11-01 ... 2025-08-11 17:51:01.235117
[5 rows x 6 columns]
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-11 17:51:02,184 - IOOppi_data - INFO : save data to db IOOppi_cu_t data:
date value
3829 2025-08-07 78518.33
3830 2025-08-08 78558.33
3831 2025-08-09 78558.33
3832 2025-08-10 78558.33
3833 2025-08-11 79156.67
2025-08-11 17:51:02,256 - IOOppi_data - INFO : save new data to db IOOppi_cu_t: date ... updated_at
3831 2025-08-09 ... 2025-08-11 17:51:02.249952
3832 2025-08-10 ... 2025-08-11 17:51:02.249952
3833 2025-08-11 ... 2025-08-11 17:51:02.249952
[3 rows x 5 columns]
2025-08-11 17:51:02,275 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_t: no diff data
2025-08-11 17:51:02,282 - IOOppi_data - INFO : save data to db IOOppi_cu_g data:
date value
3829 2025-08-07 78518.33
3830 2025-08-08 78558.33
3831 2025-08-09 78558.33
3832 2025-08-10 78558.33
3833 2025-08-11 79156.67
2025-08-11 17:51:02,355 - IOOppi_data - INFO : save new data to db IOOppi_cu_g: date ... updated_at
3834 2025-08-09 ... 2025-08-11 17:51:02.349008
3835 2025-08-10 ... 2025-08-11 17:51:02.349008
3836 2025-08-11 ... 2025-08-11 17:51:02.349008
[3 rows x 5 columns]
2025-08-11 17:51:02,375 - IOOppi_data - INFO : save diff data to db: IOOppi_cu_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-11 17:51:02,914 - IOOppi_data - INFO : save data to db IOOppi_PM_t data:
date value
2947 2024-06-26 2440.0
2948 2024-06-27 2460.0
2949 2024-06-28 2460.0
2950 2024-06-29 2460.0
2951 2024-06-30 2460.0
2025-08-11 17:51:02,970 - IOOppi_data - INFO : save new data to db: IOOppi_PM_t: no new data
2025-08-11 17:51:02,970 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_t: no diff data
2025-08-11 17:51:02,976 - IOOppi_data - INFO : save data to db IOOppi_PM_g data:
date value
2947 2024-06-26 2440.0
2948 2024-06-27 2460.0
2949 2024-06-28 2460.0
2950 2024-06-29 2460.0
2951 2024-06-30 2460.0
2025-08-11 17:51:03,042 - IOOppi_data - INFO : save new data to db: IOOppi_PM_g: no new data
2025-08-11 17:51:03,042 - IOOppi_data - INFO : save diff data to db: IOOppi_PM_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-11 17:51:03,765 - IOOppi_data - INFO : save data to db IOOppi_sn_t data:
date value
2807 2025-08-07 267300.0
2808 2025-08-08 268200.0
2809 2025-08-09 268200.0
2810 2025-08-10 268200.0
2811 2025-08-11 268075.0
2025-08-11 17:51:03,825 - IOOppi_data - INFO : save new data to db IOOppi_sn_t: date ... updated_at
2809 2025-08-09 ... 2025-08-11 17:51:03.819148
2810 2025-08-10 ... 2025-08-11 17:51:03.819148
2811 2025-08-11 ... 2025-08-11 17:51:03.819148
[3 rows x 5 columns]
2025-08-11 17:51:03,845 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_t: no diff data
2025-08-11 17:51:03,851 - IOOppi_data - INFO : save data to db IOOppi_sn_g data:
date value
2807 2025-08-07 267300.0
2808 2025-08-08 268200.0
2809 2025-08-09 268200.0
2810 2025-08-10 268200.0
2811 2025-08-11 268075.0
2025-08-11 17:51:03,912 - IOOppi_data - INFO : save new data to db IOOppi_sn_g: date ... updated_at
2812 2025-08-09 ... 2025-08-11 17:51:03.906193
2813 2025-08-10 ... 2025-08-11 17:51:03.906193
2814 2025-08-11 ... 2025-08-11 17:51:03.906193
[3 rows x 5 columns]
2025-08-11 17:51:03,933 - IOOppi_data - INFO : save diff data to db: IOOppi_sn_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-11 17:51:04,550 - IOOppi_data - INFO : save data to db IOOppi_zn_t data:
date value
3828 2025-08-07 22498.0
3829 2025-08-08 22458.0
3830 2025-08-09 22458.0
3831 2025-08-10 22458.0
3832 2025-08-11 22524.0
2025-08-11 17:51:04,622 - IOOppi_data - INFO : save new data to db IOOppi_zn_t: date value ... created_at updated_at
3830 2025-08-09 22458.0 ... 2025-08-11 17:51:04.615521 2025-08-11 17:51:04.615934
3831 2025-08-10 22458.0 ... 2025-08-11 17:51:04.615521 2025-08-11 17:51:04.615934
3832 2025-08-11 22524.0 ... 2025-08-11 17:51:04.615521 2025-08-11 17:51:04.615934
[3 rows x 5 columns]
2025-08-11 17:51:04,642 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_t: no diff data
2025-08-11 17:51:04,647 - IOOppi_data - INFO : save data to db IOOppi_zn_g data:
date value
3828 2025-08-07 22498.0
3829 2025-08-08 22458.0
3830 2025-08-09 22458.0
3831 2025-08-10 22458.0
3832 2025-08-11 22524.0
2025-08-11 17:51:04,720 - IOOppi_data - INFO : save new data to db IOOppi_zn_g: date value ... created_at updated_at
3833 2025-08-09 22458.0 ... 2025-08-11 17:51:04.713384 2025-08-11 17:51:04.713792
3834 2025-08-10 22458.0 ... 2025-08-11 17:51:04.713384 2025-08-11 17:51:04.713792
3835 2025-08-11 22524.0 ... 2025-08-11 17:51:04.713384 2025-08-11 17:51:04.713792
[3 rows x 5 columns]
2025-08-11 17:51:04,740 - IOOppi_data - INFO : save diff data to db: IOOppi_zn_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-11 17:51:05,425 - IOOppi_data - INFO : save data to db IOOppi_wr_t data:
date value
3791 2025-08-07 3465.0
3792 2025-08-08 3465.0
3793 2025-08-09 3457.5
3794 2025-08-10 3457.5
3795 2025-08-11 3477.5
2025-08-11 17:51:05,497 - IOOppi_data - INFO : save new data to db IOOppi_wr_t: date value ... created_at updated_at
3793 2025-08-09 3457.5 ... 2025-08-11 17:51:05.490207 2025-08-11 17:51:05.490627
3794 2025-08-10 3457.5 ... 2025-08-11 17:51:05.490207 2025-08-11 17:51:05.490627
3795 2025-08-11 3477.5 ... 2025-08-11 17:51:05.490207 2025-08-11 17:51:05.490627
[3 rows x 5 columns]
2025-08-11 17:51:05,517 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_t: no diff data
2025-08-11 17:51:05,523 - IOOppi_data - INFO : save data to db IOOppi_wr_g data:
date value
3791 2025-08-07 3465.0
3792 2025-08-08 3465.0
3793 2025-08-09 3457.5
3794 2025-08-10 3457.5
3795 2025-08-11 3477.5
2025-08-11 17:51:05,596 - IOOppi_data - INFO : save new data to db IOOppi_wr_g: date value ... created_at updated_at
3796 2025-08-09 3457.5 ... 2025-08-11 17:51:05.589060 2025-08-11 17:51:05.589453
3797 2025-08-10 3457.5 ... 2025-08-11 17:51:05.589060 2025-08-11 17:51:05.589453
3798 2025-08-11 3477.5 ... 2025-08-11 17:51:05.589060 2025-08-11 17:51:05.589453
[3 rows x 5 columns]
2025-08-11 17:51:05,615 - IOOppi_data - INFO : save diff data to db: IOOppi_wr_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-11 17:51:06,245 - IOOppi_data - INFO : save data to db IOOppi_pg_t data:
date value
1588 2025-08-07 4707.5
1589 2025-08-08 4707.5
1590 2025-08-09 4707.5
1591 2025-08-10 4707.5
1592 2025-08-11 4707.5
2025-08-11 17:51:06,291 - IOOppi_data - INFO : save new data to db IOOppi_pg_t: date value ... created_at updated_at
1590 2025-08-09 4707.5 ... 2025-08-11 17:51:06.283766 2025-08-11 17:51:06.284152
1591 2025-08-10 4707.5 ... 2025-08-11 17:51:06.283766 2025-08-11 17:51:06.284152
1592 2025-08-11 4707.5 ... 2025-08-11 17:51:06.283766 2025-08-11 17:51:06.284152
[3 rows x 5 columns]
2025-08-11 17:51:06,310 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_t: no diff data
2025-08-11 17:51:06,316 - IOOppi_data - INFO : save data to db IOOppi_pg_g data:
date value
1588 2025-08-07 4707.5
1589 2025-08-08 4707.5
1590 2025-08-09 4707.5
1591 2025-08-10 4707.5
1592 2025-08-11 4707.5
2025-08-11 17:51:06,363 - IOOppi_data - INFO : save new data to db IOOppi_pg_g: date value ... created_at updated_at
1593 2025-08-09 4707.5 ... 2025-08-11 17:51:06.355984 2025-08-11 17:51:06.356368
1594 2025-08-10 4707.5 ... 2025-08-11 17:51:06.355984 2025-08-11 17:51:06.356368
1595 2025-08-11 4707.5 ... 2025-08-11 17:51:06.355984 2025-08-11 17:51:06.356368
[3 rows x 5 columns]
2025-08-11 17:51:06,382 - IOOppi_data - INFO : save diff data to db: IOOppi_pg_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-11 17:51:07,059 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2862 2025-08-07 2324.29
2863 2025-08-08 2321.43
2864 2025-08-09 2321.43
2865 2025-08-10 2321.43
2866 2025-08-11 2321.43
2025-08-11 17:51:07,118 - IOOppi_data - INFO : save new data to db IOOppi_cs_t: date value ... created_at updated_at
2864 2025-08-09 2321.43 ... 2025-08-11 17:51:07.111579 2025-08-11 17:51:07.111962
2865 2025-08-10 2321.43 ... 2025-08-11 17:51:07.111579 2025-08-11 17:51:07.111962
2866 2025-08-11 2321.43 ... 2025-08-11 17:51:07.111579 2025-08-11 17:51:07.111962
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-08-11 17:51:07,159 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2863 2025-08-08 ... 2025-08-11 17:51:07.152722
[1 rows x 6 columns]
2025-08-11 17:51:07,184 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2862 2025-08-07 2324.29
2863 2025-08-08 2321.43
2864 2025-08-09 2321.43
2865 2025-08-10 2321.43
2866 2025-08-11 2321.43
2025-08-11 17:51:07,244 - IOOppi_data - INFO : save new data to db IOOppi_cs_g: date value ... created_at updated_at
2867 2025-08-09 2321.43 ... 2025-08-11 17:51:07.236957 2025-08-11 17:51:07.237321
2868 2025-08-10 2321.43 ... 2025-08-11 17:51:07.236957 2025-08-11 17:51:07.237321
2869 2025-08-11 2321.43 ... 2025-08-11 17:51:07.236957 2025-08-11 17:51:07.237321
[3 rows x 5 columns]
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-08-11 17:51:07,286 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2866 2025-08-08 ... 2025-08-11 17:51:07.279886
[1 rows x 6 columns]
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-11 17:51:07,924 - IOOppi_data - INFO : save data to db IOOppi_cs_t data:
date value
2862 2025-08-07 2324.29
2863 2025-08-08 2321.43
2864 2025-08-09 2321.43
2865 2025-08-10 2321.43
2866 2025-08-11 2934.00
2025-08-11 17:51:07,975 - IOOppi_data - INFO : save new data to db: IOOppi_cs_t: no new data
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-08-11 17:51:07,997 - IOOppi_data - INFO : save diff data to db IOOppi_cs_t: date ... updated_at
2866 2025-08-11 ... 2025-08-11 17:51:07.990175
[1 rows x 6 columns]
2025-08-11 17:51:08,021 - IOOppi_data - INFO : save data to db IOOppi_cs_g data:
date value
2862 2025-08-07 2324.29
2863 2025-08-08 2321.43
2864 2025-08-09 2321.43
2865 2025-08-10 2321.43
2866 2025-08-11 2934.00
2025-08-11 17:51:08,073 - IOOppi_data - INFO : save new data to db: IOOppi_cs_g: no new data
/root/project/IOOppi_data/IOOppi_request.py:308: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'index_code'] = index_code
/root/project/IOOppi_data/IOOppi_request.py:309: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'created_at'] = datetime.datetime.now()
/root/project/IOOppi_data/IOOppi_request.py:310: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
diff_df.loc[:, 'updated_at'] = datetime.datetime.now()
2025-08-11 17:51:08,095 - IOOppi_data - INFO : save diff data to db IOOppi_cs_g: date ... updated_at
2869 2025-08-11 ... 2025-08-11 17:51:08.088147
[1 rows x 6 columns]
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-11 17:51:08,687 - IOOppi_data - INFO : save data to db IOOppi_RS_t data:
date value
3219 2025-08-07 9598.33
3220 2025-08-08 9678.33
3221 2025-08-09 9678.33
3222 2025-08-10 9678.33
3223 2025-08-11 9698.33
2025-08-11 17:51:08,744 - IOOppi_data - INFO : save new data to db: IOOppi_RS_t: no new data
2025-08-11 17:51:08,744 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_t: no diff data
2025-08-11 17:51:08,750 - IOOppi_data - INFO : save data to db IOOppi_RS_g data:
date value
3219 2025-08-07 9598.33
3220 2025-08-08 9678.33
3221 2025-08-09 9678.33
3222 2025-08-10 9678.33
3223 2025-08-11 9698.33
2025-08-11 17:51:08,810 - IOOppi_data - INFO : save new data to db: IOOppi_RS_g: no new data
2025-08-11 17:51:08,810 - IOOppi_data - INFO : save diff data to db: IOOppi_RS_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-11 17:51:09,436 - IOOppi_data - INFO : save data to db IOOppi_eg_t data:
date value
1903 2025-08-07 4478.33
1904 2025-08-08 4478.33
1905 2025-08-09 4478.33
1906 2025-08-10 4478.33
1907 2025-08-11 4483.33
2025-08-11 17:51:09,484 - IOOppi_data - INFO : save new data to db IOOppi_eg_t: date value ... created_at updated_at
1905 2025-08-09 4478.33 ... 2025-08-11 17:51:09.477350 2025-08-11 17:51:09.477761
1906 2025-08-10 4478.33 ... 2025-08-11 17:51:09.477350 2025-08-11 17:51:09.477761
1907 2025-08-11 4483.33 ... 2025-08-11 17:51:09.477350 2025-08-11 17:51:09.477761
[3 rows x 5 columns]
2025-08-11 17:51:09,504 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_t: no diff data
2025-08-11 17:51:09,509 - IOOppi_data - INFO : save data to db IOOppi_eg_g data:
date value
1903 2025-08-07 4478.33
1904 2025-08-08 4478.33
1905 2025-08-09 4478.33
1906 2025-08-10 4478.33
1907 2025-08-11 4483.33
2025-08-11 17:51:09,557 - IOOppi_data - INFO : save new data to db IOOppi_eg_g: date value ... created_at updated_at
1908 2025-08-09 4478.33 ... 2025-08-11 17:51:09.550423 2025-08-11 17:51:09.550831
1909 2025-08-10 4478.33 ... 2025-08-11 17:51:09.550423 2025-08-11 17:51:09.550831
1910 2025-08-11 4483.33 ... 2025-08-11 17:51:09.550423 2025-08-11 17:51:09.550831
[3 rows x 5 columns]
2025-08-11 17:51:09,577 - IOOppi_data - INFO : save diff data to db: IOOppi_eg_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-11 17:51:10,156 - IOOppi_data - INFO : save data to db IOOppi_sp_t data:
date value
1912 2025-08-07 5883.33
1913 2025-08-08 5883.33
1914 2025-08-09 5883.33
1915 2025-08-10 5883.33
1916 2025-08-11 5883.33
2025-08-11 17:51:10,205 - IOOppi_data - INFO : save new data to db IOOppi_sp_t: date value ... created_at updated_at
1914 2025-08-09 5883.33 ... 2025-08-11 17:51:10.198452 2025-08-11 17:51:10.198861
1915 2025-08-10 5883.33 ... 2025-08-11 17:51:10.198452 2025-08-11 17:51:10.198861
1916 2025-08-11 5883.33 ... 2025-08-11 17:51:10.198452 2025-08-11 17:51:10.198861
[3 rows x 5 columns]
2025-08-11 17:51:10,225 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_t: no diff data
2025-08-11 17:51:10,230 - IOOppi_data - INFO : save data to db IOOppi_sp_g data:
date value
1912 2025-08-07 5883.33
1913 2025-08-08 5883.33
1914 2025-08-09 5883.33
1915 2025-08-10 5883.33
1916 2025-08-11 5883.33
2025-08-11 17:51:10,282 - IOOppi_data - INFO : save new data to db IOOppi_sp_g: date value ... created_at updated_at
1917 2025-08-09 5883.33 ... 2025-08-11 17:51:10.275064 2025-08-11 17:51:10.275435
1918 2025-08-10 5883.33 ... 2025-08-11 17:51:10.275064 2025-08-11 17:51:10.275435
1919 2025-08-11 5883.33 ... 2025-08-11 17:51:10.275064 2025-08-11 17:51:10.275435
[3 rows x 5 columns]
2025-08-11 17:51:10,301 - IOOppi_data - INFO : save diff data to db: IOOppi_sp_g: no diff data
/usr/local/lib/python3.10/site-packages/urllib3/connectionpool.py:1056: InsecureRequestWarning: Unverified HTTPS request is being made to host 'www.100ppi.com'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/1.26.x/advanced-usage.html#ssl-warnings
warnings.warn(
2025-08-11 17:51:11,154 - IOOppi_data - INFO : save data to db IOOppi_p_t data:
date value
3580 2025-08-07 9052.0
3581 2025-08-08 9072.0
3582 2025-08-09 9072.0
3583 2025-08-10 9072.0
3584 2025-08-11 9048.0
2025-08-11 17:51:11,224 - IOOppi_data - INFO : save new data to db IOOppi_p_t: date value ... created_at updated_at
3582 2025-08-09 9072.0 ... 2025-08-11 17:51:11.216734 2025-08-11 17:51:11.217121
3583 2025-08-10 9072.0 ... 2025-08-11 17:51:11.216734 2025-08-11 17:51:11.217121
3584 2025-08-11 9048.0 ... 2025-08-11 17:51:11.216734 2025-08-11 17:51:11.217121
[3 rows x 5 columns]
2025-08-11 17:51:11,243 - IOOppi_data - INFO : save diff data to db: IOOppi_p_t: no diff data
2025-08-11 17:51:11,249 - IOOppi_data - INFO : save data to db IOOppi_p_g data:
date value
3580 2025-08-07 9052.0
3581 2025-08-08 9072.0
3582 2025-08-09 9072.0
3583 2025-08-10 9072.0
3584 2025-08-11 9048.0
2025-08-11 17:51:11,321 - IOOppi_data - INFO : save new data to db IOOppi_p_g: date value ... created_at updated_at
3585 2025-08-09 9072.0 ... 2025-08-11 17:51:11.314213 2025-08-11 17:51:11.314635
3586 2025-08-10 9072.0 ... 2025-08-11 17:51:11.314213 2025-08-11 17:51:11.314635
3587 2025-08-11 9048.0 ... 2025-08-11 17:51:11.314213 2025-08-11 17:51:11.314635
[3 rows x 5 columns]
2025-08-11 17:51:11,340 - IOOppi_data - INFO : save diff data to db: IOOppi_p_g: no diff data