package data_manage

import (
	"github.com/beego/beego/v2/client/orm"
)

func GetFirstBaseFromTradeIndexByDate(exchange string) (item *BaseFromTradeShanghaiIndex, err error) {
	o := orm.NewOrm()
	sql := "SELECT * FROM base_from_trade_" + exchange + "_index where rank < 50 order by data_time asc"
	err = o.Raw(sql).QueryRow(&item)
	return
}