该数据库包含从2017年1月1日至今,国内2千多条直飞航线的出发前90天内的历史价格信息,具有包含价格历史长、连续性高、密度高、价格数据准确等特点。数据来源于互联网公开可查询数据,可用于科研、价格预测、出行优化等各种领域。
相关应用文章:
机票大数据分析,揭示购票的秘密2018春节机票怎么买?看这几张图就够了我为什么要开发这款小程序?从数据到产品——爱飞狗背后的故事联系方式:微信号bcdata
数据详情时间跨度:从2016年7月1日至今航线列表航班列表数据量注:以下统计数据从2017年1月1日至2019年10月1日,共计1003天进行计算。
低频数据低频数据收集每日下午2点附近的机票价格,数据库中总共包含1025159650(10亿)条数据。平均每天1025159(一百万)条数据。
高频数据高频数据采取连续收集,每日采集从10次到20次不等,数据量大约为低频数据的10到20倍不等,约100亿到200亿条数据。平均每天一千万左右。高频数据可以看到每日不同时刻价格的变化,可以更加深入的分析。
字段数据包含以下字段:
字段解释departdate起飞日期departtime起飞时间arrivetime到达时间crawldate采集日期。2019年1月13日前包含起飞前45天内的价格信息,之后包含起飞前90天的价格信息flightno航班号sharedflightno共享航班号departcity出发机场三字码departtower出发航站楼arrivecity到达机场三字码arrivetower到达航站楼discount折扣价格price经济舱最低价格信息样例数据2017年1月1日起飞的CA4305航班数据,通过crawldate可以看到距离起飞前若干天的机票变化情况(未排序)。例如第一条2016年12月29日,就是起飞前3天的价格数据,不含税为1020元,折扣为7.1折;同理第二条为起飞前5天的价格数据,为540元,3.8折。index,departdate,departtime,arrivetime,crawldate,flightno,sharedflightno,departcity,departtower,arrivecity,arrivetower,discount,price0,2017-01-01,07:30:00,09:55:00,2016-12-29,CA4305,,CTU,T2,CAN,,71,10201,2017-01-01,07:30:00,09:55:00,2016-12-27,CA4305,,CTU,T2,CAN,,38,5402,2017-01-01,07:30:00,09:55:00,2016-12-31,CA4305,,CTU,T2,CAN,,68,9703,2017-01-01,07:30:00,09:55:00,2016-12-26,CA4305,,CTU,T2,CAN,,38,5404,2017-01-01,07:30:00,09:55:00,2016-12-30,CA4305,,CTU,T2,CAN,,68,9705,2017-01-01,07:30:00,09:55:00,2016-12-25,CA4305,,CTU,T2,CAN,,38,5406,2017-01-01,07:30:00,09:55:00,2016-12-24,CA4305,,CTU,T2,CAN,,38,5407,2017-01-01,07:30:00,09:55:00,2016-12-23,CA4305,,CTU,T2,CAN,,38,5408,2017-01-01,07:30:00,09:55:00,2016-12-22,CA4305,,CTU,T2,CAN,,38,5409,2017-01-01,07:30:00,09:55:00,2016-12-28,CA4305,,CTU,T2,CAN,,38,54010,2017-01-01,07:30:00,09:55:00,2016-12-21,CA4305,,CTU,T2,CAN,,38,54011,2017-01-01,07:30:00,09:55:00,2016-12-20,CA4305,,CTU,T2,CAN,,38,54012,2017-01-01,07:30:00,09:55:00,2016-12-17,CA4305,,CTU,T2,CAN,,38,54013,2017-01-01,07:30:00,09:55:00,2016-12-18,CA4305,,CTU,T2,CAN,,38,54014,2017-01-01,07:30:00,09:55:00,2016-12-16,CA4305,,CTU,T2,CAN,,38,54015,2017-01-01,07:30:00,09:55:00,2016-12-19,CA4305,,CTU,T2,CAN,,38,54016,2017-01-01,07:30:00,09:55:00,2016-12-13,CA4305,,CTU,T2,CAN,,38,54017,2017-01-01,07:30:00,09:55:00,2016-12-12,CA4305,,CTU,T2,CAN,,38,54018,2017-01-01,07:30:00,09:55:00,2016-12-11,CA4305,,CTU,T2,CAN,,38,54019,2017-01-01,07:30:00,09:55:00,2016-12-15,CA4305,,CTU,T2,CAN,,45,64020,2017-01-01,07:30:00,09:55:00,2016-12-14,CA4305,,CTU,T2,CAN,,38,54021,2017-01-01,07:30:00,09:55:00,2016-12-10,CA4305,,CTU,T2,CAN,,38,54022,2017-01-01,07:30:00,09:55:00,2016-12-09,CA4305,,CTU,T2,CAN,,38,54023,2017-01-01,07:30:00,09:55:00,2016-12-07,CA4305,,CTU,T2,CAN,,30,43024,2017-01-01,07:30:00,09:55:00,2016-12-08,CA4305,,CTU,T2,CAN,,38,54025,2017-01-01,07:30:00,09:55:00,2016-12-06,CA4305,,CTU,T2,CAN,,30,43026,2017-01-01,07:30:00,09:55:00,2016-12-04,CA4305,,CTU,T2,CAN,,38,55027,2017-01-01,07:30:00,09:55:00,2016-12-05,CA4305,,CTU,T2,CAN,,38,54028,2017-01-01,07:30:00,09:55:00,2016-12-03,CA4305,,CTU,T2,CAN,,38,54829,2017-01-01,07:30:00,09:55:00,2016-12-02,CA4305,,CTU,T2,CAN,,38,54030,2017-01-01,07:30:00,09:55:00,2016-12-01,CA4305,,CTU,T2,CAN,,38,54031,2017-01-01,07:30:00,09:55:00,2016-11-30,CA4305,,CTU,T2,CAN,,38,54032,2017-01-01,07:30:00,09:55:00,2016-11-29,CA4305,,CTU,T2,CAN,,38,54033,2017-01-01,07:30:00,09:55:00,2016-11-27,CA4305,,CTU,T2,CAN,,38,54034,2017-01-01,07:30:00,09:55:00,2016-11-26,CA4305,,CTU,T2,CAN,,38,54035,2017-01-01,07:30:00,09:55:00,2016-11-25,CA4305,,CTU,T2,CAN,,38,54036,2017-01-01,07:30:00,09:55:00,2016-11-28,CA4305,,CTU,T2,CAN,,38,54037,2017-01-01,07:30:00,09:55:00,2016-11-23,CA4305,,CTU,T2,CAN,,40,57038,2017-01-01,07:30:00,09:55:00,2016-11-22,CA4305,,CTU,T2,CAN,,40,57039,2017-01-01,07:30:00,09:55:00,2016-11-24,CA4305,,CTU,T2,CAN,,38,540CA4305航班2017年1月1日至2019年10月1日共计1003天的起飞数据。请加公众号 爱飞狗 ,输入“数据库”获取。以上数据可渲染出此价格图,可参考此文章《机票大数据分析,揭示购票的秘密》