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 开发教程：物体识别…...
构建企业级抓取服务：基于快马平台的openclaw生产环境部署实战
今天想和大家分享一个实战经验：如何用InsCode(快马)平台快速搭建企业级的openclaw分布式抓取服务。这个方案特别适合需要处理大规模数据采集的业务场景，比如电商价格监控、舆情分析或者竞品追踪。 分布式架构设计 生产环境最怕单点故障，所以我…...
BAR和BA
BAR 是请求方发出的“问题”：“我刚才发的那批数据包，你收到了哪几个？”BA 是接收方回复的“答案”：“我收到了第1、3、4、5个包，第2个没收到。”BAR - Block Ack Request（块确认请求） 角色与发…...
告别命令行：5分钟掌握ffmpegGUI视频处理新方式
告别命令行：5分钟掌握ffmpegGUI视频处理新方式 【免费下载链接】ffmpegGUI ffmpeg GUI 项目地址: https://gitcode.com/gh_mirrors/ff/ffmpegGUI ffmpegGUI是一款创新的跨平台视频处理工具，它将强大的FFmpeg命令行功能转化为直观的图形界面操作&a…...
iPhone USB网络共享驱动终极解决方案：从诊断到优化的全方位指南
iPhone USB网络共享驱动终极解决方案：从诊断到优化的全方位指南 【免费下载链接】Apple-Mobile-Drivers-Installer Powershell script to easily install Apple USB and Mobile Device Ethernet (USB Tethering) drivers on Windows! 项目地址: https://gitcode.c…...
IDEA插件MyBatisX实战：3分钟搞定SpringBoot项目CRUD代码生成
MyBatisX插件全流程实战：SpringBoot项目CRUD代码生成效率革命 在快节奏的企业级开发中，重复编写基础CRUD代码就像在键盘上跳机械舞——动作标准却毫无新意。当项目包含20张以上数据表时，手动创建Entity、Mapper、Service等层级代码会消耗开发…...
快马AI助力：十分钟用Python搭建免费股票行情网站原型
最近想验证一个股票行情网站的原型，但作为独立开发者，从零搭建前后端实在太耗时。尝试用PythonFlask快速实现，结合InsCode(快马)平台的AI辅助功能，居然十分钟就完成了基础框架。记录下关键实现思路： 数据获取层设计 选…...
PyTorch 2.8镜像效果实测：Wan2.2-I2V图生视频在4090D上的流畅度表现
PyTorch 2.8镜像效果实测：Wan2.2-I2V图生视频在4090D上的流畅度表现 1. 测试环境与配置 1.1 硬件配置 本次测试使用的是基于RTX 4090D显卡的深度学习工作站，具体配置如下： 显卡：NVIDIA RTX 4090D 24GB显存CPU：10核…...
3步实现AI智能背景移除：开源工具让透明GIF制作变得如此简单
3步实现AI智能背景移除：开源工具让透明GIF制作变得如此简单 【免费下载链接】backgroundremover Background Remover lets you Remove Background from images and video using AI with a simple command line interface that is free and open source. 项目地址:…...
GG3M 项目贝叶斯更新与决策数学的具体落地应用
GG3M贝叶斯决策体系：基于贾子公理的跨领域反熵增智慧决策应用摘要： GG3M项目以贾子公理体系为底层支撑，独创“事实层-模型层-元模型层”层级化贝叶斯架构，实现了从参数优化到认知框架迭代的范式突破。该体系以系统长期反熵增演化为…...
从 Python 和 Node.js 的流行看 Java 的真实位置
很多 Java 程序员都会有一个感觉：Python 很火，Node.js 也很火，Java 是不是没落了？ 先说结论：Java 没有没落，只是位置变了。一、为什么 Python 和 Node.js 看起来更火 1. Python 火，是因为 AI 太…...