level2逐笔委托查询接口
沪深逐笔委托队列查询
前置步骤
分配数据库服务器
查询模板
以下是沪深委托队列查询的请求模板：
http://<数据库服务器>/sql?mode=order_book&code=<股票代码>&offset=<offset>&token=<token>
查询参数说明
| 参数名 | 类型 | 说明 |
|---|---|---|
| mode | string | 查询类别，委托队列查询使用order_book |
| code | string | 需要查询的证券代码 |
| offset | string | 支持按队列偏移量查询，未指定则查询最新数据 |
| token | string | 用户账户的认证token，用于验证请求权限 |
查询示例
- 查询最新委托列表
http://<数据库服务器>/sql?mode=order_book&code=000001&token=<token>
- 根据偏移量查询
http://<数据库服务器>/sql?mode=order_book&code=000001&offset=<offset>&token=<token>
返回参数说明
| 字段名 | 类型 | 说明 |
|---|---|---|
| offset | int | 偏移标记，用于继续查询前面的数据 |
| price | float | 委托价格 |
| volume | int | 档位挂单总量（股） |
| type | int | 委托类型，B表示买，S表示卖 |
| time | string | 委托时间 |
返回数据示例
{"code": 0,"cnt": 1,"msg": "","data": {"code": "000001","slice": 192,"fields": ["offset", "price", "volume", "type", "time"],"list": [[90593065,16.97,800,"B","09:32:02"],...[90592690,16.98,7400,"S","09:31:58"]]}
}
参考地址:沪深Level2逐笔委托队列
在线测试
您可以通过以下链接进行在线测试：逐笔委托队列查询。
接口返回:
{"code": 0,"cnt": 43,"msg": "","data": {"code": "000553","slice": 192,"fields": ["offset","price","volume","type","time"],"list": [[20085635,7.19,100,"S","09:58:10"],[20085552,7.19,1000,"S","09:58:10"],[20066698,7.19,1000,"B","09:58:07"],[20052932,7.16,200,"S","09:58:06"],[20018359,7.17,900,"B","09:58:02"],[20008414,7.17,800,"B","09:58:01"],[19993661,7.19,2100,"S","09:57:59"],[19982569,7.19,200,"S","09:57:57"],[19953167,7.06,5100,"B","09:57:53"],[19950051,7.19,500,"S","09:57:53"],[19941533,6.66,1000,"B","09:57:52"],[19931896,7.19,1000,"S","09:57:50"],[19921481,7.18,1200,"B","09:57:49"],[19912073,7.19,500,"S","09:57:48"],[19901164,7.19,6600,"S","09:57:46"],[19874560,7.17,800,"B","09:57:42"],[19844281,7.19,100,"S","09:57:38"],[19828677,7.19,1300,"B","09:57:36"],[19823156,7.19,100,"S","09:57:35"],[19822756,7.19,100,"S","09:57:35"],[19822745,7.19,100,"S","09:57:35"],[19822742,7.19,100,"S","09:57:35"],[19822739,7.19,100,"S","09:57:35"],[19822729,7.19,100,"S","09:57:35"],[19822727,7.19,100,"S","09:57:35"],[19822726,7.19,100,"S","09:57:35"],[19822669,7.19,500,"B","09:57:35"],[19808489,7.19,100,"B","09:57:34"],[19800900,7.19,200,"S","09:57:33"],[19800898,7.19,200,"S","09:57:33"],[19800800,7.19,200,"S","09:57:33"],[19768640,7.19,100,"B","09:57:28"],[19766089,7.19,200,"B","09:57:28"],[19750186,7.19,300,"B","09:57:26"],[19714644,7.19,100,"B","09:57:22"],[19705088,7.19,200,"B","09:57:20"],[19685915,7.19,1500,"S","09:57:18"],[19635034,7.19,2000,"S","09:57:14"],[19624409,7.11,100,"S","09:57:13"],[19612485,7.19,300,"S","09:57:12"],[19572673,7.19,1500,"B","09:57:09"],[19569705,7.19,1500,"B","09:57:09"],[19552258,7.19,1400,"S","09:57:07"],[19520496,7.19,100,"S","09:57:03"],[19503489,7.19,400,"B","09:57:01"],[19484252,7.19,300,"B","09:56:59"],[19483528,7.19,900,"B","09:56:59"],[19479712,7.19,700,"S","09:56:59"],[19479655,7.19,1000,"S","09:56:58"],[19478965,7.19,100,"S","09:56:58"],[19478804,7.19,4700,"S","09:56:58"],[19474519,7.19,400,"B","09:56:58"],[19414312,6.9,500,"B","09:56:50"],[19411463,7.19,5000,"S","09:56:50"],[19410505,7.19,300,"B","09:56:50"],[19391046,7.11,6300,"B","09:56:47"],[19374850,6.99,2000,"B","09:56:45"],[19364187,7.19,2600,"B","09:56:44"],[19356958,7.19,1200,"B","09:56:43"],[19331397,7.19,6200,"B","09:56:39"],[19326963,7.17,800,"B","09:56:39"],[19326775,7.19,200,"B","09:56:39"],[19283106,7.19,1900,"B","09:56:33"],[19279170,7.19,7000,"B","09:56:32"],[19279107,7.19,2000,"S","09:56:32"],[19274169,7.19,700,"S","09:56:31"],[19273267,7.19,300,"B","09:56:31"],[19265745,7.19,10000,"B","09:56:30"],[19264099,7.19,1900,"B","09:56:30"],[19251826,7.19,1200,"B","09:56:28"],[19238458,6.5,5000,"B","09:56:26"],[19235089,7.19,1000,"B","09:56:26"],[19227706,7.19,1000,"S","09:56:25"],[19217903,7.1,6800,"B","09:56:24"],[19207410,7.07,200,"B","09:56:22"],[19204775,6.91,400,"B","09:56:22"],[19189884,7.19,600,"S","09:56:20"],[19160879,7.19,500,"B","09:56:16"],[19160679,7.19,200,"S","09:56:16"],[19153369,7.19,200,"S","09:56:15"],[19143783,7.1,500,"B","09:56:14"],[19132894,7.11,100,"S","09:56:13"],[19124699,7.19,1000,"S","09:56:12"],[19121222,7.11,100,"S","09:56:11"],[19115822,7.19,10000,"S","09:56:11"],[19112015,7.19,1600,"B","09:56:10"],[19089428,7.19,10700,"B","09:56:08"],[19073712,7.19,100,"B","09:56:06"],[19062445,7.19,2700,"B","09:56:05"],[19058502,7.19,10500,"S","09:56:04"],[19053441,7.19,100,"B","09:56:04"],[19042808,7.19,2100,"S","09:56:03"],[19038126,7.19,1300,"S","09:56:02"],[19023964,7.19,20000,"S","09:56:01"],[19004649,7.19,1500,"B","09:55:59"],[18984839,7.19,1400,"B","09:55:56"],[18980840,7.19,3800,"S","09:55:56"],[18972266,7.19,200,"B","09:55:55"],[18947113,7.19,500,"S","09:55:53"],[18931670,7.18,2100,"B","09:55:51"],[18924493,7.19,1300,"B","09:55:51"],[18908982,7.17,800,"B","09:55:50"],[18896417,7.19,6300,"B","09:55:49"],[18867665,7.19,5000,"S","09:55:45"],[18861164,7.19,300,"B","09:55:45"],[18854013,7.19,900,"B","09:55:44"],[18850687,7.19,100,"S","09:55:43"],[18850531,7.19,500,"B","09:55:43"],[18845258,6.8,1000,"B","09:55:43"],[18833900,7.19,1000,"B","09:55:41"],[18826737,7.19,1700,"B","09:55:40"],[18816340,7.19,1000,"S","09:55:39"],[18812053,7.19,1500,"S","09:55:39"],[18811741,7.19,500,"B","09:55:39"],[18809413,7.19,15100,"S","09:55:38"],[18792068,7.19,500,"S","09:55:37"],[18765733,7.19,4700,"S","09:55:34"],[18755441,7.19,1400,"B","09:55:32"],[18728410,7.19,1000,"S","09:55:29"],[18723422,7.19,6100,"S","09:55:29"],[18713668,7.19,90600,"B","09:55:28"],[18713666,7.19,1800,"S","09:55:28"],[18713640,7.19,116900,"B","09:55:28"],[18713467,7.19,20000,"B","09:55:28"],[18711613,7.16,200,"B","09:55:27"],[18702800,7.19,2100,"B","09:55:26"],[18691547,7.19,10100,"B","09:55:25"],[18685750,7.19,1400,"B","09:55:24"],[18673109,7.19,100,"B","09:55:23"],[18665529,7.19,500,"S","09:55:22"],[18663038,7.19,1300,"B","09:55:21"],[18649765,7.19,100,"S","09:55:20"],[18649565,7.19,500,"B","09:55:20"],[18649210,7.05,1000,"B","09:55:20"],[18647137,7.19,1200,"B","09:55:20"],[18626586,7.19,400,"S","09:55:17"],[18625125,7.19,700,"B","09:55:17"],[18618170,7.19,500,"S","09:55:16"],[18606212,7.19,800,"B","09:55:15"],[18603742,7.19,1300,"B","09:55:15"],[18599148,7.1,1100,"B","09:55:14"],[18586500,7.19,1100,"S","09:55:13"],[18579988,7.19,300,"S","09:55:13"],[18571345,7.19,2200,"S","09:55:12"],[18571279,7.19,1900,"S","09:55:12"],[18571278,7.19,500,"S","09:55:12"],[18571176,7.19,200,"S","09:55:12"],[18571175,7.19,6700,"S","09:55:12"],[18571168,7.19,300,"S","09:55:12"],[18571147,7.19,300,"S","09:55:12"],[18571138,7.19,300,"S","09:55:12"],[18571137,7.19,2400,"S","09:55:12"],[18571132,7.19,100,"S","09:55:12"],[18571129,7.19,1000,"S","09:55:12"],[18571125,7.19,400,"S","09:55:12"],[18571122,7.19,200,"S","09:55:12"],[18571120,7.19,200,"S","09:55:12"],[18571109,7.19,1900,"S","09:55:12"],[18571100,7.19,2500,"S","09:55:12"],[18571099,7.19,2200,"S","09:55:12"],[18571098,7.19,1600,"S","09:55:12"],[18559843,7.19,3000,"B","09:55:11"],[18557966,7.19,200,"S","09:55:11"],[18557670,7.19,300,"S","09:55:10"],[18557598,7.19,3300,"S","09:55:10"],[18557555,7.19,200,"S","09:55:10"],[18557492,7.19,1000,"S","09:55:10"],[18557488,7.19,400,"S","09:55:10"],[18552201,7.19,300,"S","09:55:10"],[18552194,7.19,1800,"S","09:55:10"],[18550586,7.19,300,"B","09:55:10"],[18544571,7.19,200,"S","09:55:09"],[18526244,7.19,2400,"B","09:55:08"],[18513751,7.19,1000,"B","09:55:07"],[18489842,7.19,1000,"B","09:55:05"],[18470664,7,300,"B","09:55:03"],[18467066,7.1,500,"B","09:55:02"],[18466584,7.19,1500,"S","09:55:02"],[18449553,7.19,11600,"B","09:55:00"],[18442354,7.19,700,"B","09:55:00"],[18441031,7.19,300,"B","09:55:00"],[18432276,7.07,100,"B","09:54:58"],[18427239,7.19,3000,"S","09:54:58"],[18416515,7.19,600,"B","09:54:56"],[18411657,7.19,1400,"S","09:54:56"],[18410744,7.19,1600,"B","09:54:55"],[18410715,7.19,3000,"S","09:54:55"],[18373245,7.19,76400,"B","09:54:51"],[18373224,7.19,57100,"B","09:54:51"],[18373219,7.19,85300,"B","09:54:51"],[18373217,7.19,84900,"B","09:54:51"],[18373205,7.19,54300,"B","09:54:51"]]}
}相关文章：
level2逐笔委托查询接口
沪深逐笔委托队列查询 前置步骤 分配数据库服务器 查询模板 以下是沪深委托队列查询的请求模板： http://<数据库服务器>/sql?modeorder_book&code<股票代码>&offset<offset>&token<token>查询参数说明 参数名类型说明mo…...
在Linux系统安装配置 MySQL 和 hive，hive配置为远程模式
前提：已安装配置好了Hadoop环境，因为hive的底层是Hadoop 1 Mysql安装 搜索Centos7自带的mariadb rpm -qa|grep mariadb 卸载mariadb rpm -e mariadb-libs-5.5.64-1.el7.x86_64 --nodeps 再搜索一次看看是否还存在 rpm -qa|grep mariadb 安装mysql 创…...
如何写好一份科技报告
如何写好一份技术文档 一、科技报告写作的整体框架封面与摘要：引言：理论框架与文献综述：实验方法与材料：实验结果：结果分析与讨论：结论：参考文献：附录： 二、科技报告写作…...
ARM学习（38）多进程多线程之间的通信方式
ARM学习（38）ARM学习（38）多进程多线程之间的通信方式 一、问题背景 笔者在调试模拟器的时候，碰到进程间通信的问题，一个进程在等另外一个进程ready的时候，迟迟等不到，然后通过调试发现，另外一个进程变量已经变化了，但是当前进程变量没变化，需要了解进程间通信的方式…...
《图解机器学习》（杉山将著）第一部分绪论学习笔记
《图解机器学习》（杉山将著）第一部分绪论学习笔记 《图解机器学习》（杉山将著）第一部分绪论学习笔记一、什么是机器学习1.1 学习的种类1.2 机器学习任务的例子1.3 机器学习的方法 二、学习模型2.1 线性模型2.2 核模型2.3 层级模型…...
【WPF】RenderTargetBitmap的使用
在WPF（Windows Presentation Foundation）中，RenderTargetBitmap 是一个非常有用的类，它允许你将任何可视元素（如 UIElement 或 Visual 的实例）渲染到位图中。这在需要生成图像快照、导出可视化内容为图片文…...
编辑， 抽成组件
问题 错误思路： 1 dept不能修改， 用watch监听一下：赋值给新的变量进行修改， 问题： currentDept 发生改变， depth也发生了改变，因为是浅拷贝， 用了json.pase(json.stringify(value…...
使用C#绘制具有平滑阴影颜色的曼德布洛特集分形
示例使用复数类在 C# 中轻松绘制曼德布洛特集分形解释了如何通过迭代方程绘制曼德布洛特集：...
【批量生成WORD和PDF文件】根据表格内容和模板文件批量创建word文件，一次性生成多个word文档和批量创建PDF文件
如何按照Word模板和表格的数据快速制作5000个word文档 ？ 在与客户的合作的中需要创建大量的合同，这些合同的模板大概都是一致的，是不是每次我们都需要填充不一样的数据来完成？ 今天用表格数据完成合同模板的填充，批量…...
低延迟！实时处理！中软高科AI边缘服务器，解决边缘计算多样化需求！
根据相关统计，随着物联网的发展和5G技术的普及，到2025年，全球物联网设备连接数将达到1000亿，海量的计算数据使得传输到云端再处理的云计算方式显得更捉襟见肘。拥有低延迟、实时处理、可扩展性和更高安全性的边缘计算应运而生&…...
内旋风铣削知识再学习
最近被有不少小伙伴们问到蜗杆加工的一种方式——内旋风铣削加工。关于旋风铣之前出过一篇《什么是旋风铣？》，简要介绍了旋风铣（Whilring）的一些基本内容。本期再重新仔细聊一聊内旋风这种加工方式，可加工的零件种类&a…...
Redis 7.x如何安装与配置？保姆级教程
大家好，我是袁庭新。最新写了一套最新版的Redis 7.x企业级开发教程，今天先给大家介绍下Redis 7.x如何在Linux系统上安装和配置。 1 Redis下载与安装 使用非关系型数据库Redis必须先进行安装配置并开启Redis服务，然后使用对应客户端连接使用…...
SLAAC如何工作？
SLAAC如何工作？ IPv6无状态地址自动配置(SLAAC)-常见问题 - 苍然满关中 - 博客园 https://support.huawei.com/enterprise/zh/doc/EDOC1100323788?sectionj00shttps://www.zhihu.com/question/6691553243/answer/57023796400 主机在启动或接口UP后，发…...
电脑丢失dll文件一键修复的多种方法分析，电脑故障修复攻略
电脑在使用过程中，有时会遇到DLL文件丢失的情况，这可能导致软件无法正常运行或系统出现故障。当面对这种状况时，不必过于慌张，因为有多种有效的修复方法可供选择。下面我们一起来看看电脑丢失dll文件的多种解决方法。 一.了解什么…...
Docker容器命令
docker 命令说明docker pull拉取镜像docker push推送镜像到DockerRegistrydocker images查看本地镜像docker rmi删除本地镜像docker run创建并运行容器（不能重复创建）docker stop停止指定容器docker start启动指定容器docker restart重新启动容器docker…...
【Leetcode 每日一题】3291. 形成目标字符串需要的最少字符串数 I
问题背景 给你一个字符串数组 w o r d s words words 和一个字符串 t a r g e t target target。 如果字符串 x x x 是 w o r d s words words 中 任意 字符串的 前缀（字符串的前缀是从字符串的开头开始并延伸到其中任意点的子串），则认为…...
Windows聚焦壁纸代理不更新——解除UWP应用回环限制
开代理后经常出现Microsoft store打不开，聚焦壁纸不更新的情况，因为UWP应用默认禁止回环地址，导致开了代理以后不仅用不了代理上网，还把自己的本来的通信堵死了 打开CMD输入 FOR /F "tokens11 delims\" %p IN (REG QUER…...
电脑开机提示error loading operating system怎么修复？
前一天电脑还能正常运行，但今天启动时却显示“Error loading operating system”（加载操作系统错误）。我已经仔细检查了硬盘、接线、内存、CPU和电源，确认这些硬件都没有问题。硬盘在其他电脑上可以正常使用，说明不是硬…...
javaFX.（蜜雪冰城点餐小程序）MySQL数据库
学习Java只有3个月，不喜勿喷 该小程序是用的MySQL数据库，编辑软件用的equals,为什么不用idea有提示因为主打一个纯手打 要源码私信 目录 javafx.小程序（蜜雪冰城点餐系统）简介 主体思路 思路讲解 用户登录 用户注册 忘记…...
Unity Apple Vision Pro 开发教程：物体识别跟踪
Spatial XR 开发者社区官网：SpatialXR 社区 开发流程与原理：Apple Vision Pro 物体识别跟踪原理与开发流程【Unity Apple Vision Pro 开发系列教程】 PolySpatial 物体跟踪官方样例讲解：Unity Apple Vision Pro 开发教程：物体识别…...
React Native 开发环境搭建（全平台详解）
React Native 开发环境搭建（全平台详解） 在开始使用 React Native 开发移动应用之前，正确设置开发环境是至关重要的一步。本文将为你提供一份全面的指南，涵盖 macOS 和 Windows 平台的配置步骤，如何在 Android 和 iOS…...
【力扣数据库知识手册笔记】索引
索引 索引的优缺点 优点1. 通过创建唯一性索引，可以保证数据库表中每一行数据的唯一性。2. 可以加快数据的检索速度（创建索引的主要原因）。3. 可以加速表和表之间的连接，实现数据的参考完整性。4. 可以在查询过程中，…...
抖音增长新引擎：品融电商，一站式全案代运营领跑者
抖音增长新引擎：品融电商，一站式全案代运营领跑者 在抖音这个日活超7亿的流量汪洋中，品牌如何破浪前行？自建团队成本高、效果难控；碎片化运营又难成合力——这正是许多企业面临的增长困局。品融电商以「抖音全案代运营…...
【2025年】解决Burpsuite抓不到https包的问题
环境：windows11 burpsuite:2025.5 在抓取https网站时，burpsuite抓取不到https数据包，只显示： 解决该问题只需如下三个步骤： 1、浏览器中访问 http://burp 2、下载 CA certificate 证书 3、在设置--隐私与安全--…...
关于 WASM：1. WASM 基础原理
一、WASM 简介 1.1 WebAssembly 是什么？ WebAssembly（WASM） 是一种能在现代浏览器中高效运行的二进制指令格式，它不是传统的编程语言，而是一种 低级字节码格式，可由高级语言（如 C、C、Rust&am…...
JUC笔记(上)-复习 涉及死锁 volatile synchronized CAS 原子操作
一、上下文切换 即使单核CPU也可以进行多线程执行代码，CPU会给每个线程分配CPU时间片来实现这个机制。时间片非常短，所以CPU会不断地切换线程执行，从而让我们感觉多个线程是同时执行的。时间片一般是十几毫秒(ms)。通过时间片分配算法执行。…...
Android15默认授权浮窗权限
我们经常有那种需求，客户需要定制的apk集成在ROM中，并且默认授予其【显示在其他应用的上层】权限，也就是我们常说的浮窗权限，那么我们就可以通过以下方法在wms、ams等系统服务的systemReady()方法中调用即可实现预置应用默认授权浮…...
SpringCloudGateway 自定义局部过滤器
场景： 将所有请求转化为同一路径请求（方便穿网配置）在请求头内标识原来路径，然后在将请求分发给不同服务 AllToOneGatewayFilterFactory import lombok.Getter; import lombok.Setter; import lombok.extern.slf4j.Slf4j; impor…...
Xen Server服务器释放磁盘空间
disk.sh #!/bin/bashcd /run/sr-mount/e54f0646-ae11-0457-b64f-eba4673b824c # 全部虚拟机物理磁盘文件存储 a$(ls -l | awk {print $NF} | cut -d. -f1) # 使用中的虚拟机物理磁盘文件 b$(xe vm-disk-list --multiple | grep uuid | awk {print $NF})printf "%s\n"…...
Spring AI Chat Memory 实战指南：Local 与 JDBC 存储集成
一个面向 Java 开发者的 Sring-Ai 示例工程项目，该项目是一个 Spring AI 快速入门的样例工程项目，旨在通过一些小的案例展示 Spring AI 框架的核心功能和使用方法。 项目采用模块化设计，每个模块都专注于特定的功能领域，便于学习和…...