[大数据]【Hive SQL 新算法】求任意时间段连续登录N天用户数/用户明细/最长连续登陆天数/用户留存率问题总结

注：本计算方法原创来源于：https://blog.csdn.net/hweinifengkuang/article/details/92832309

在原创的基础上优化的：

建测试表

CREATE TABLE `user_login_table`(	
  `user_id` int COMMENT '用户ID', 	
  `login_date` date COMMENT '登录日期'
)	

插入1000条测试数据

• 数据见文末

计算连续登陆

-- 第二段 根据登陆时间减去排列顺序 得出用户连续登陆的分组
SELECT user_id,date_sub(login_date,rank) as login_group,min(login_date) as start_login_time
    ,max(login_date) as end_login_time,count(1) as continuous_days
FROM (
	-- 第一段首先根据用户分组，登陆时间排序，结果按照登陆时间升序排列
    SELECT DISTINCT user_id,login_date,dense_rank() OVER(PARTITION BY user_id order by login_date) as rank
    FROM tmp.user_login_table ORDER BY user_id,rank
) a
GROUP BY user_id,date_sub(login_date,rank);

计算结果如下：

这种计算方式有个好处，在这个结果表上再进一步的运算，可以得到任意个时间段内连续登陆的用户数，及用户明细

计算留存率问题

select
first_date,
sum(case when by_day = 0 then 1 else 0 end) day_0,
    sum(case when by_day = 1 then 1 else 0 end) day_1,
    sum(case when by_day = 2 then 1 else 0 end) day_2,
    sum(case when by_day = 3 then 1 else 0 end) day_3,
    sum(case when by_day = 4 then 1 else 0 end) day_4,
    sum(case when by_day = 5 then 1 else 0 end) day_5,
    sum(case when by_day = 6 then 1 else 0 end) day_6,
    sum(case when by_day = 7 then 1 else 0 end) day_7plus
from(
select
user_id,
login_date,first_date,
datediff(login_date,first_date) by_day
from(
select 
    user_id,
    login_date,min(login_date) over(partition by user_id order by login_date) as first_date
from user_login_table
group by user_id,login_date
) a 
) b
group by first_date;

• 结果如下：
  

测试数据

10003,2021-07-03
10001,2021-07-09
10007,2021-07-09
10012,2021-07-07
10003,2021-07-10
10015,2021-07-06
10008,2021-07-03
10006,2021-06-01
10015,2021-07-05
10018,2021-07-05
10018,2021-07-01
10002,2021-06-03
10006,2021-06-03
10002,2021-06-10
10010,2021-06-05
10015,2021-06-07
10015,2021-07-07
10003,2021-06-01
10010,2021-06-05
10013,2021-06-05
10004,2021-07-09
10016,2021-07-02
10008,2021-06-09
10013,2021-06-08
10007,2021-06-06
10012,2021-07-07
10009,2021-06-03
10010,2021-07-04
10019,2021-06-08
10014,2021-07-09
10014,2021-07-02
10017,2021-07-01
10008,2021-07-02
10004,2021-07-02
10015,2021-07-09
10007,2021-06-06
10004,2021-06-04
10019,2021-06-10
10016,2021-07-08
10000,2021-07-05
10015,2021-06-09
10011,2021-06-04
10020,2021-07-04
10015,2021-06-05
10000,2021-07-09
10003,2021-06-06
10005,2021-06-03
10003,2021-06-06
10017,2021-06-06
10017,2021-06-04
10014,2021-06-03
10019,2021-06-03
10017,2021-06-04
10011,2021-07-08
10013,2021-07-01
10011,2021-07-04
10014,2021-06-09
10010,2021-07-03
10005,2021-06-08
10001,2021-06-05
10007,2021-06-05
10016,2021-06-04
10000,2021-07-09
10010,2021-06-04
10000,2021-07-10
10013,2021-07-09
10009,2021-07-06
10011,2021-07-10
10009,2021-07-07
10016,2021-06-06
10011,2021-06-06
10015,2021-06-05
10012,2021-06-02
10002,2021-07-03
10002,2021-06-10
10015,2021-06-04
10017,2021-07-04
10009,2021-07-03
10000,2021-07-04
10011,2021-06-04
10010,2021-07-06
10010,2021-06-09
10017,2021-06-08
10012,2021-07-08
10015,2021-07-04
10010,2021-06-01
10005,2021-07-04
10004,2021-07-01
10007,2021-07-03
10007,2021-07-02
10002,2021-06-06
10003,2021-07-05
10006,2021-07-07
10016,2021-06-01
10009,2021-07-09
10005,2021-07-07
10020,2021-06-03
10007,2021-06-10
10011,2021-06-10
10020,2021-07-07
10010,2021-06-03
10017,2021-06-01
10009,2021-07-09
10013,2021-07-05
10020,2021-07-07
10013,2021-07-05
10013,2021-06-09
10001,2021-07-04
10013,2021-07-06
10002,2021-07-06
10000,2021-07-10
10012,2021-07-10
10008,2021-06-07
10012,2021-07-07
10008,2021-07-03
10019,2021-07-05
10007,2021-07-07
10005,2021-06-10
10002,2021-07-07
10007,2021-07-05
10000,2021-06-02
10003,2021-06-02
10005,2021-06-01
10001,2021-06-06
10008,2021-07-09
10015,2021-06-08
10005,2021-07-04
10005,2021-07-08
10020,2021-06-06
10014,2021-07-05
10000,2021-07-04
10002,2021-06-05
10020,2021-06-10
10003,2021-07-08
10008,2021-07-02
10004,2021-06-07
10000,2021-07-02
10003,2021-07-09
10012,2021-06-09
10013,2021-07-07
10011,2021-06-01
10005,2021-06-08
10004,2021-06-08
10019,2021-07-03
10013,2021-07-04
10001,2021-07-06
10010,2021-07-07
10014,2021-06-03
10004,2021-07-06
10013,2021-06-03
10008,2021-07-05
10007,2021-07-07
10007,2021-06-09
10000,2021-06-05
10006,2021-06-04
10010,2021-06-03
10005,2021-06-03
10006,2021-06-09
10019,2021-06-04
10020,2021-07-02
10020,2021-07-10
10002,2021-07-04
10020,2021-07-09
10015,2021-07-09
10002,2021-07-04
10020,2021-06-04
10001,2021-07-01
10005,2021-07-02
10002,2021-07-08
10010,2021-07-04
10001,2021-07-01
10006,2021-06-07
10010,2021-06-04
10003,2021-07-07
10008,2021-07-03
10016,2021-07-10
10019,2021-07-09
10000,2021-06-07
10019,2021-07-06
10019,2021-07-10
10017,2021-07-04
10009,2021-07-04
10016,2021-06-10
10003,2021-06-09
10004,2021-07-10
10014,2021-06-06
10000,2021-06-07
10011,2021-07-02
10011,2021-07-04
10015,2021-07-10
10012,2021-07-04
10008,2021-07-03
10002,2021-06-03
10016,2021-06-03
10010,2021-07-09
10006,2021-07-07
10006,2021-06-09
10013,2021-06-04
10018,2021-07-10
10010,2021-06-04
10011,2021-07-07
10009,2021-07-02
10002,2021-06-03
10006,2021-06-10
10008,2021-06-03
10017,2021-06-10
10004,2021-07-08
10020,2021-07-10
10005,2021-07-06
10007,2021-06-05
10000,2021-07-09
10002,2021-06-02
10002,2021-07-09
10011,2021-06-10
10001,2021-06-07
10019,2021-07-03
10008,2021-07-04
10014,2021-06-01
10009,2021-06-07
10009,2021-06-07
10006,2021-06-09
10017,2021-07-01
10007,2021-07-01
10012,2021-07-08
10020,2021-06-10
10003,2021-07-01
10017,2021-06-06
10015,2021-06-06
10000,2021-06-02
10018,2021-06-01
10006,2021-06-04
10010,2021-06-01
10013,2021-07-07
10012,2021-07-07
10000,2021-06-09
10020,2021-07-02
10007,2021-07-04
10018,2021-06-07
10006,2021-07-01
10006,2021-06-01
10016,2021-06-08
10019,2021-07-10
10005,2021-06-03
10003,2021-06-01
10009,2021-07-02
10003,2021-06-05
10002,2021-07-09
10000,2021-06-06
10000,2021-06-06
10017,2021-06-07
10001,2021-06-06
10019,2021-06-05
10000,2021-06-04
10008,2021-06-10
10005,2021-07-07
10002,2021-07-07
10009,2021-06-10
10013,2021-06-01
10013,2021-06-04
10019,2021-06-09
10003,2021-07-10
10003,2021-06-06
10013,2021-07-10
10007,2021-07-01
10000,2021-06-07
10003,2021-07-09
10010,2021-06-07
10015,2021-07-07
10006,2021-07-04
10003,2021-06-08
10018,2021-06-09
10001,2021-06-03
10017,2021-07-01
10005,2021-06-05
10009,2021-06-06
10001,2021-06-06
10017,2021-06-04
10014,2021-07-09
10001,2021-06-07
10005,2021-07-05
10002,2021-06-05
10017,2021-07-05
10019,2021-06-10
10019,2021-07-03
10010,2021-07-03
10006,2021-07-05
10010,2021-07-08
10019,2021-06-07
10008,2021-07-02
10008,2021-07-03
10006,2021-07-10
10018,2021-06-09
10013,2021-07-05
10019,2021-06-08
10004,2021-07-02
10000,2021-07-07
10006,2021-07-06
10008,2021-07-10
10016,2021-07-02
10019,2021-06-02
10016,2021-06-02
10012,2021-07-07
10020,2021-07-07
10002,2021-07-09
10002,2021-07-03
10000,2021-06-08
10014,2021-07-02
10015,2021-06-10
10007,2021-07-03
10007,2021-07-01
10015,2021-07-07
10016,2021-06-09
10013,2021-06-10
10004,2021-07-05
10015,2021-07-08
10017,2021-07-02
10016,2021-07-04
10019,2021-06-07
10002,2021-07-10
10013,2021-07-04
10014,2021-07-10
10019,2021-07-05
10002,2021-07-04
10009,2021-07-06
10019,2021-07-02
10004,2021-07-04
10002,2021-07-04
10016,2021-07-02
10013,2021-06-06
10003,2021-06-09
10004,2021-06-07
10006,2021-07-03
10005,2021-07-09
10020,2021-06-05
10010,2021-06-05
10005,2021-06-03
10018,2021-06-01
10018,2021-06-09
10000,2021-07-06
10009,2021-07-06
10014,2021-07-06
10005,2021-07-08
10016,2021-07-05
10001,2021-07-08
10000,2021-07-01
10018,2021-07-09
10009,2021-07-06
10012,2021-07-08
10004,2021-06-02
10015,2021-06-10
10015,2021-07-09
10005,2021-06-01
10000,2021-07-03
10014,2021-07-06
10008,2021-06-04
10015,2021-07-03
10012,2021-06-10
10008,2021-06-05
10013,2021-07-02
10018,2021-06-01
10012,2021-06-04
10020,2021-06-04
10017,2021-07-06
10008,2021-07-07
10007,2021-07-01
10007,2021-07-02
10007,2021-06-09
10019,2021-07-02
10005,2021-06-05
10020,2021-06-01
10020,2021-06-03
10016,2021-07-03
10017,2021-06-03
10004,2021-07-08
10007,2021-06-07
10006,2021-07-07
10019,2021-07-10
10005,2021-07-10
10006,2021-06-05
10020,2021-06-05
10000,2021-06-07
10019,2021-07-04
10007,2021-07-02
10011,2021-07-04
10020,2021-06-06
10019,2021-06-09
10016,2021-07-03
10003,2021-07-07
10014,2021-07-03
10003,2021-07-10
10009,2021-06-02
10011,2021-07-01
10000,2021-06-09
10005,2021-07-07
10000,2021-06-01
10008,2021-07-09
10014,2021-06-07
10002,2021-06-04
10004,2021-06-09
10013,2021-06-06
10004,2021-06-05
10009,2021-06-07
10020,2021-06-08
10005,2021-06-04
10006,2021-06-04
10003,2021-07-04
10008,2021-06-10
10006,2021-07-07
10006,2021-06-08
10008,2021-07-01
10012,2021-06-10
10007,2021-06-03
10010,2021-07-06
10014,2021-07-10
10001,2021-07-04
10008,2021-07-03
10008,2021-06-05
10004,2021-06-07
10003,2021-07-06
10010,2021-07-04
10020,2021-07-10
10000,2021-06-08
10018,2021-07-01
10008,2021-06-04
10016,2021-07-01
10011,2021-06-08
10010,2021-06-09
10019,2021-06-09
10014,2021-07-01
10001,2021-07-08
10009,2021-07-10
10009,2021-06-10
10003,2021-06-07
10000,2021-07-01
10003,2021-07-02
10006,2021-07-03
10000,2021-07-08
10003,2021-06-07
10005,2021-07-05
10020,2021-06-02
10010,2021-07-08
10000,2021-06-01
10007,2021-06-05
10007,2021-07-05
10014,2021-07-05
10009,2021-07-03
10001,2021-06-03
10019,2021-07-07
10017,2021-06-08
10016,2021-06-06
10020,2021-07-09
10018,2021-07-07
10005,2021-07-07
10010,2021-07-09
10007,2021-07-03
10000,2021-06-01
10014,2021-07-02
10018,2021-06-09
10010,2021-07-06
10020,2021-06-07
10006,2021-07-08
10001,2021-06-10
10020,2021-06-05
10019,2021-06-02
10011,2021-07-03
10010,2021-06-10
10000,2021-06-09
10018,2021-06-02
10004,2021-06-04
10018,2021-06-02
10010,2021-06-02
10000,2021-07-02
10006,2021-06-08
10018,2021-06-03
10011,2021-06-10
10019,2021-07-03
10014,2021-06-04
10003,2021-07-08
10000,2021-06-07
10002,2021-06-08
10000,2021-07-04
10000,2021-07-02
10008,2021-06-02
10020,2021-06-06
10015,2021-07-01
10012,2021-06-07
10012,2021-07-07
10005,2021-06-10
10020,2021-06-05
10013,2021-07-09
10014,2021-07-02
10013,2021-07-07
10017,2021-07-08
10018,2021-06-06
10017,2021-06-09
10018,2021-07-01
10014,2021-06-06
10013,2021-06-02
10010,2021-07-02
10019,2021-07-04
10014,2021-06-03
10001,2021-07-07
10001,2021-07-08
10019,2021-07-03
10008,2021-07-07
10008,2021-07-01
10005,2021-06-04
10011,2021-06-08
10007,2021-06-08
10012,2021-07-09
10015,2021-06-07
10017,2021-06-08
10007,2021-07-05
10001,2021-07-05
10005,2021-06-01
10000,2021-07-05
10007,2021-07-06
10010,2021-07-07
10020,2021-07-05
10005,2021-07-10
10018,2021-07-05
10017,2021-06-05
10017,2021-07-05
10019,2021-07-07
10002,2021-06-08
10009,2021-07-07
10020,2021-07-05
10003,2021-06-10
10011,2021-06-04
10004,2021-06-06
10011,2021-06-02
10004,2021-07-06
10009,2021-06-09
10004,2021-07-01
10010,2021-07-04
10020,2021-06-09
10009,2021-07-08
10018,2021-07-05
10018,2021-07-06
10006,2021-06-06
10005,2021-07-08
10020,2021-06-05
10008,2021-07-09
10012,2021-07-08
10000,2021-07-05
10014,2021-06-02
10011,2021-06-07
10005,2021-06-09
10014,2021-07-09
10013,2021-06-07
10008,2021-07-10
10000,2021-06-02
10003,2021-06-08
10001,2021-07-06
10003,2021-07-06
10016,2021-07-05
10001,2021-06-03
10019,2021-06-03
10017,2021-06-07
10020,2021-06-10
10020,2021-06-02
10011,2021-07-04
10005,2021-06-06
10009,2021-07-07
10008,2021-06-08
10010,2021-07-04
10020,2021-06-07
10018,2021-07-06
10018,2021-07-09
10005,2021-06-03
10008,2021-06-06
10008,2021-07-03
10015,2021-06-04
10001,2021-06-09
10005,2021-07-10
10010,2021-06-02
10017,2021-06-10
10002,2021-07-02
10014,2021-06-10
10004,2021-06-02
10020,2021-06-01
10005,2021-06-07
10005,2021-06-01
10005,2021-06-04
10006,2021-06-02
10016,2021-06-04
10014,2021-07-02
10013,2021-07-01
10010,2021-06-03
10011,2021-07-03
10004,2021-06-06
10010,2021-07-04
10001,2021-06-02
10009,2021-06-07
10012,2021-07-08
10009,2021-06-08
10007,2021-06-09
10019,2021-07-07
10005,2021-06-10
10018,2021-07-08
10009,2021-06-05
10001,2021-07-10
10017,2021-06-02
10000,2021-06-04
10006,2021-06-08
10001,2021-07-10
10019,2021-06-03
10011,2021-07-03
10010,2021-07-09
10010,2021-06-09
10020,2021-06-03
10014,2021-07-09
10019,2021-07-09
10011,2021-06-07
10010,2021-06-01
10001,2021-06-04
10017,2021-07-03
10013,2021-06-03
10017,2021-06-09
10005,2021-06-10
10008,2021-06-01
10009,2021-06-05
10008,2021-07-08
10003,2021-06-06
10018,2021-07-08
10019,2021-06-06
10002,2021-07-07
10019,2021-06-10
10017,2021-07-08
10010,2021-07-03
10007,2021-06-04
10017,2021-06-01
10015,2021-07-05
10006,2021-06-10
10004,2021-06-06
10002,2021-07-05
10007,2021-06-07
10009,2021-06-09
10015,2021-07-08
10009,2021-06-09
10006,2021-07-10
10016,2021-06-02
10016,2021-06-04
10019,2021-07-01
10002,2021-06-03
10011,2021-07-04
10012,2021-06-01
10002,2021-07-03
10018,2021-06-06
10015,2021-07-09
10012,2021-06-09
10004,2021-06-01
10016,2021-06-04
10010,2021-07-02
10018,2021-06-03
10010,2021-06-06
10001,2021-07-09
10013,2021-06-08
10006,2021-06-08
10002,2021-07-05
10019,2021-06-04
10019,2021-06-07
10013,2021-06-09
10005,2021-07-08
10005,2021-07-04
10001,2021-06-08
10000,2021-07-04
10001,2021-07-09
10008,2021-06-10
10006,2021-06-05
10020,2021-06-07
10011,2021-07-05
10010,2021-06-09
10008,2021-07-09
10019,2021-06-06
10006,2021-07-06
10007,2021-06-10
10002,2021-07-02
10014,2021-06-08
10013,2021-06-01
10008,2021-07-02
10004,2021-07-01
10019,2021-07-02
10008,2021-06-05
10007,2021-06-08
10015,2021-07-06
10014,2021-07-02
10019,2021-06-10
10014,2021-07-10
10020,2021-07-05
10006,2021-07-05
10002,2021-06-05
10018,2021-06-03
10006,2021-07-03
10005,2021-07-08
10007,2021-07-10
10020,2021-07-10
10001,2021-07-03
10002,2021-06-03
10020,2021-06-02
10009,2021-07-01
10001,2021-07-04
10008,2021-06-04
10007,2021-07-10
10017,2021-07-02
10000,2021-07-09
10017,2021-06-04
10004,2021-06-05
10001,2021-06-03
10010,2021-06-04
10010,2021-07-05
10007,2021-07-03
10011,2021-07-10
10020,2021-07-02
10000,2021-06-07
10014,2021-06-08
10002,2021-07-04
10004,2021-07-05
10017,2021-07-07
10007,2021-06-10
10018,2021-07-05
10012,2021-06-03
10013,2021-06-03
10006,2021-07-03
10020,2021-06-03
10000,2021-07-02
10007,2021-06-06
10007,2021-07-03
10011,2021-07-08
10013,2021-06-04
10017,2021-06-02
10001,2021-07-07
10009,2021-07-02
10003,2021-06-06
10004,2021-06-01
10007,2021-07-07
10007,2021-07-05
10000,2021-07-05
10003,2021-06-02
10004,2021-06-08
10006,2021-07-08
10010,2021-07-07
10017,2021-07-08
10013,2021-07-04
10001,2021-07-06
10016,2021-06-10
10014,2021-06-09
10013,2021-06-01
10004,2021-07-08
10003,2021-07-01
10017,2021-07-10
10010,2021-07-07
10003,2021-06-09
10012,2021-07-10
10012,2021-06-05
10000,2021-07-05
10004,2021-07-01
10010,2021-07-10
10003,2021-07-04
10020,2021-06-05
10018,2021-07-08
10019,2021-07-02
10012,2021-06-03
10018,2021-07-06
10015,2021-07-04
10002,2021-06-10
10018,2021-07-10
10005,2021-07-06
10002,2021-07-02
10011,2021-07-09
10007,2021-07-07
10017,2021-06-03
10017,2021-07-06
10013,2021-07-09
10008,2021-06-10
10019,2021-06-08
10010,2021-07-07
10006,2021-07-05
10018,2021-06-10
10004,2021-07-10
10013,2021-06-10
10017,2021-06-09
10006,2021-07-07
10008,2021-07-07
10003,2021-07-04
10002,2021-07-01
10019,2021-06-07
10001,2021-07-03
10013,2021-06-09
10004,2021-06-07
10008,2021-07-02
10011,2021-06-04
10005,2021-06-01
10014,2021-07-03
10002,2021-06-10
10003,2021-06-07
10018,2021-06-03
10004,2021-07-04
10003,2021-06-07
10006,2021-06-02
10012,2021-07-01
10002,2021-06-06
10009,2021-07-03
10014,2021-06-09
10000,2021-06-07
10020,2021-07-08
10020,2021-06-09
10011,2021-06-05
10001,2021-07-01
10001,2021-06-03
10018,2021-06-04
10007,2021-07-08
10013,2021-07-09
10001,2021-06-05
10018,2021-06-09
10012,2021-07-05
10009,2021-06-02
10006,2021-06-04
10003,2021-06-04
10008,2021-07-02
10002,2021-07-10
10013,2021-07-02
10012,2021-06-02
10004,2021-06-10
10020,2021-07-10
10004,2021-06-02
10010,2021-06-07
10018,2021-06-09
10007,2021-06-04
10010,2021-07-05
10007,2021-06-08
10006,2021-07-04
10008,2021-06-02
10001,2021-07-09
10012,2021-07-02
10013,2021-06-08
10006,2021-07-10
10007,2021-06-08
10007,2021-07-07
10020,2021-07-04
10009,2021-06-10
10000,2021-07-10
10012,2021-06-08
10007,2021-07-07
10019,2021-07-04
10005,2021-06-09
10006,2021-07-04
10010,2021-06-09
10006,2021-07-01
10010,2021-07-06
10005,2021-07-01
10017,2021-07-04
10014,2021-07-08
10000,2021-07-04
10016,2021-07-07
10001,2021-07-03
10005,2021-07-10
10002,2021-07-04
10002,2021-06-04
10002,2021-07-04
10015,2021-07-03
10007,2021-07-07
10007,2021-07-05
10004,2021-06-01
10017,2021-07-04
10020,2021-07-04
10013,2021-07-02
10010,2021-06-04
10015,2021-06-03
10002,2021-07-06
10005,2021-06-02
10014,2021-06-10
10007,2021-06-02
10010,2021-07-04
10004,2021-07-05
10008,2021-07-05
10003,2021-07-07
10011,2021-07-05
10019,2021-06-06
10017,2021-06-10
10016,2021-06-10
10007,2021-07-05
10015,2021-06-05
10003,2021-06-03
10000,2021-07-06
10004,2021-07-05
10011,2021-07-02
10006,2021-06-09
10014,2021-07-09
10010,2021-07-08
10011,2021-07-02
10013,2021-06-07
10003,2021-07-03
10002,2021-06-03
10007,2021-06-07
10008,2021-07-07
10014,2021-07-10
10013,2021-07-09
10011,2021-07-03
10001,2021-07-05
10011,2021-07-03
10011,2021-07-06
10019,2021-06-07
10020,2021-06-07
10007,2021-07-09
10015,2021-06-05
10009,2021-06-03
10000,2021-06-01
10015,2021-07-02
10005,2021-06-06
10008,2021-07-03
10013,2021-06-09
10012,2021-06-03
10005,2021-07-05
10011,2021-06-06
10000,2021-07-06
10017,2021-06-01
10001,2021-07-05
10017,2021-06-02
10012,2021-06-10
10013,2021-07-03
10006,2021-06-09
10017,2021-07-04
10001,2021-07-10
10014,2021-07-02
10020,2021-06-07
10012,2021-06-08
10019,2021-06-05
10012,2021-07-09
10016,2021-06-03
10016,2021-06-06
10016,2021-06-06
10006,2021-06-07
10013,2021-06-09
10002,2021-07-04
10017,2021-07-05
10020,2021-06-01
10000,2021-07-02
10010,2021-06-05
10008,2021-06-07
10012,2021-06-10
10008,2021-06-09
10019,2021-07-06
10004,2021-07-01
10012,2021-07-10
10003,2021-06-03
10003,2021-06-07
10015,2021-07-02
10015,2021-07-07
10019,2021-07-05
10005,2021-07-08
10016,2021-06-10
10020,2021-06-06
10007,2021-06-03
10011,2021-06-05
10006,2021-06-02
10017,2021-06-10
10010,2021-07-02
10001,2021-06-01
10005,2021-07-08
10007,2021-07-06
10004,2021-06-08
10013,2021-07-07
10010,2021-06-01
10006,2021-06-06
10020,2021-07-07
10002,2021-07-06
10017,2021-07-03
10008,2021-06-10
10011,2021-06-04
10006,2021-06-10
10000,2021-06-08
10009,2021-06-06
10020,2021-06-01
10006,2021-07-01
10009,2021-07-05
10019,2021-06-06
10010,2021-07-08
10013,2021-06-06
10000,2021-07-03
10002,2021-07-03
10018,2021-07-10
10007,2021-07-09
10018,2021-06-07
10004,2021-07-05
10006,2021-07-05
10011,2021-06-06
10014,2021-07-03
10005,2021-07-06
10001,2021-06-07
10004,2021-07-01
10005,2021-06-05
10016,2021-07-01
10009,2021-06-04
10003,2021-06-05
10019,2021-06-06
10008,2021-06-08
10019,2021-07-10
10017,2021-06-05
10009,2021-07-10