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 开发教程：物体识别…...
观成科技：隐蔽隧道工具Ligolo-ng加密流量分析
1.工具介绍 Ligolo-ng是一款由go编写的高效隧道工具，该工具基于TUN接口实现其功能，利用反向TCP/TLS连接建立一条隐蔽的通信信道，支持使用Let’s Encrypt自动生成证书。Ligolo-ng的通信隐蔽性体现在其支持多种连接方式，适应复杂网…...
深度学习在微纳光子学中的应用
深度学习在微纳光子学中的主要应用方向 深度学习与微纳光子学的结合主要集中在以下几个方向： 逆向设计 通过神经网络快速预测微纳结构的光学响应，替代传统耗时的数值模拟方法。例如设计超表面、光子晶体等结构。 特征提取与优化 从复杂的光学数据中自…...
19c补丁后oracle属主变化，导致不能识别磁盘组
补丁后服务器重启，数据库再次无法启动 ORA01017: invalid username/password; logon denied Oracle 19c 在打上 19.23 或以上补丁版本后，存在与用户组权限相关的问题。具体表现为，Oracle 实例的运行用户（oracle）和集…...
R语言AI模型部署方案：精准离线运行详解
R语言AI模型部署方案：精准离线运行详解 一、项目概述 本文将构建一个完整的R语言AI部署解决方案，实现鸢尾花分类模型的训练、保存、离线部署和预测功能。核心特点： 100%离线运行能力自包含环境依赖生产级错误处理跨平台兼容性模型版本管理# 文件结构说明 Iris_AI_Deployme…...
相机Camera日志实例分析之二：相机Camx【专业模式开启直方图拍照】单帧流程日志详解
【关注我，后续持续新增专题博文，谢谢！！！】 上一篇我们讲了： 这一篇我们开始讲： 目录 一、场景操作步骤 二、日志基础关键字分级如下 三、场景日志如下： 一、场景操作步骤 操作步…...
大语言模型如何处理长文本？常用文本分割技术详解
为什么需要文本分割？ 引言：为什么需要文本分割？一、基础文本分割方法1. 按段落分割（Paragraph Splitting）2. 按句子分割（Sentence Splitting）二、高级文本分割策略3. 重叠分割（Sliding Window）4. 递归分割（Recursive Splitting）三、生产级工具推荐5. 使用LangChain的…...
《基于Apache Flink的流处理》笔记
思维导图 1-3 章 4-7章 8-11 章 参考资料 源码： https://github.com/streaming-with-flink 博客 https://flink.apache.org/bloghttps://www.ververica.com/blog 聚会及会议 https://flink-forward.orghttps://www.meetup.com/topics/apache-flink https://n…...
3403. 从盒子中找出字典序最大的字符串 I
3403. 从盒子中找出字典序最大的字符串 I 题目链接：3403. 从盒子中找出字典序最大的字符串 I 代码如下： class Solution { public:string answerString(string word, int numFriends) {if (numFriends 1) {return word;}string res;for (int i 0;i &…...
（转）什么是DockerCompose?它有什么作用？
一、什么是DockerCompose? DockerCompose可以基于Compose文件帮我们快速的部署分布式应用，而无需手动一个个创建和运行容器。 Compose文件是一个文本文件，通过指令定义集群中的每个容器如何运行。 DockerCompose就是把DockerFile转换成指令去运行。 …...
【学习笔记】深入理解Java虚拟机学习笔记——第4章 虚拟机性能监控，故障处理工具
第2章 虚拟机性能监控，故障处理工具 4.1 概述 略 4.2 基础故障处理工具 4.2.1 jps:虚拟机进程状况工具 命令：jps [options] [hostid] 功能：本地虚拟机进程显示进程ID（与ps相同），可同时显示主类&#x…...