【数据建议】集合竞价表可以增加未匹配的金额吗

由bqv93dy2创建，最终由bqv93dy2更新于2025-08-17 07:27 被浏览 1 用户

%%sql
select
    date,
    instrument,
    open_auction_order_volume	as	竞价总委托量,
    open_auction_cancel_volume	as	竞价总撤单量,
    open_auction_trade_volume	as	竞价总成交量,
    open_auction_order_volume-open_auction_cancel_volume-open_auction_trade_volume as 竞价未成交量,
    open_auction_trade_price*竞价未成交量/1e8 as 竞价未成交额亿,
    open_auction_trade_amount,
    open_auction_trade_price,

    from cn_stock_factors_auction
    where date>'2025-08-14' and instrument in ('600208.SH','600737.SH')
    order by open_auction_trade_amount

这样计算出来的结果无法显示价位上究竟是多方占优还是空房占优，而且结果与同花顺提供数据有差别。