データ確認,株価系を一括更新
取得条件,日付列がある場合は日付降順、ない場合は主キー順、最大10件
DB,stock.db
TABLE,T_STOCK
ORDER_BY,DATETIME DESC
CODE,NAME,MARKET,CATEGORY,DATETIME,PRICE,DIFF_PRICE,DIFF_RATE,PREV_PRICE,BEGIN_PRICE,HIGH_PRICE,LOW_PRICE,VOLUME,TRADING_VALUE,TOTAL_PRICE,STOP_LOW,STOP_HIGH
0001,日経平均株価（日経225）,東証,株価指数,20260721,66232.19,2091.07,3.26,64141.12,64544.05,66232.19,64203.47,,,,,
0002,TOPIX（東証株価指数）,東証,株価指数,20260721,4014.95,95.74,2.44,3919.21,3944.79,4014.95,3930.17,,,,,
1301,極洋,東証PR,水産・農林,20260721,4525,20,0.44,4505,4515,4575,4505,36000,163208,54654,3805,5210
130A,Veritas_In_Silico,東証GR,医薬品,20260721,403,-15,-3.59,418,420,420,403,12200,5028,2614,338,498
1332,ニッスイ,東証PR,水産・農林,20260721,1266,-6.5,-0.51,1272.5,1279,1283,1255.5,1493100,1892919,386466,972.5,1572.5
1333,Umios,東証PR,水産・農林,20260721,1332.5,-0.5,-0.04,1333,1339,1355,1327.5,428700,573571,202189,1033,1633
135A,VRAIN_Solution,東証GR,情報通信,20260721,3825,75,2,3750,3750,3875,3705,74000,281329,39229,3050,4450
1375,ユキグニファクトリー,東証PR,水産・農林,20260721,1148,-5,-0.43,1153,1153,1169,1148,45800,52876,45817,853,1453
1376,カネコ種苗,東証ST,水産・農林,20260721,1529,10,0.66,1519,1523,1545,1523,17200,26343,18000,1119,1919
1377,サカタのタネ,東証PR,水産・農林,20260721,4400,35,0.8,4365,4410,4445,4365,129900,571573,199807,3665,5070

DB,all_stock.db
TABLE,T_STOCK
ORDER_BY,YMD DESC
YMD,CODE,PRICE,DIFF_PRICE,DIFF_RATE,PREV_PRICE,BEGIN_PRICE,HIGH_PRICE,LOW_PRICE,VOLUME,TRADING_VALUE,TOTAL_PRICE,STOP_LOW,STOP_HIGH
20260721,9997,1074,11,1.03,1063,1065,1084,1064,466900,500933,104441,763,1363
20260721,9996,2129,7,0.33,2122,2129,2129,2129,100,213,19486,1622,2622
20260721,9994,2073,3,0.14,2070,2060,2090,2060,6400,13276,22488,1570,2570
20260721,9993,1175,2,0.17,1173,1182,1182,1171,3400,4002,12879,873,1473
20260721,9991,1637,22,1.36,1615,1624,1639,1624,54800,89407,55324,1215,2015
20260721,9990,762,5,0.66,757,757,765,757,66900,50988,22753,607,907
20260721,9989,3818,-49,-1.27,3867,3818,3886,3811,506200,1939902,455606,3167,4567
20260721,9987,5175,8,0.15,5167,5195,5228,5150,166700,864052,373465,4167,6167
20260721,9986,2494,-1,-0.04,2495,2517,2517,2490,6700,16734,15627,1995,2995
20260721,9984,5751,327,6.03,5424,5524,5789,5364,51208900,288305386,32848839,4424,6424

DB,all_ma.db
TABLE,T_MA
ORDER_BY,YMD DESC
YMD,CODE,PRICE,VOLUME,MA5,MA10,MA25,MA50,MA75,MA125,MA200
20260721,9997,1074,466900,1055.6,1033.9,981.6,955.1,926.3,937,960.6
20260721,9996,2129,100,2158.8,2161.4,2048.6,2064,2127.7,2216.8,2173.1
20260721,9994,2073,6400,2076.8,2075.4,2047,2082.9,2139.6,2190,2232.3
20260721,9993,1175,3400,1174,1176.7,1177.6,1166.8,1166,1174.2,1169.2
20260721,9991,1637,54800,1603.6,1588.6,1558.2,1535.2,1587.4,1644,1558
20260721,9990,762,66900,759.2,763.7,750.3,737.1,745.2,776.4,774.9
20260721,9989,3818,506200,3829.6,3841.5,3805.2,3771.1,3800.3,3923.6,4052.5
20260721,9987,5175,166700,5120.4,5057.6,4999.3,5094.2,5348,5703.9,5808.9
20260721,9986,2494,6700,2508.2,2516.4,2482.5,2497.6,2548.7,2571,2536.2
20260721,9984,5751,51208900,6014,6009.5,6331,6562.8,5934.9,5170.6,5094.8

DB,rsi.db
TABLE,T_RSI
ORDER_BY,YMD DESC
YMD,CODE,W9,W14,W25,C9,C14,C25
20260721,9997,83.64,78.85,71.08,88.89,88.48,74.8
20260721,9996,54.5,55.66,52.57,56.06,70.67,63.22
20260721,9994,55.76,52.03,47.72,60.76,64.14,56.42
20260721,9993,47.96,50.92,52.36,29.17,35.71,53.57
20260721,9991,80.01,71.55,59.45,82.98,81.94,71.17
20260721,9990,57.2,57.72,54.75,40,58.67,59.68
20260721,9989,49.16,50.6,50.28,34.77,51.26,50.45
20260721,9987,64.09,58.13,50.37,62.91,64.96,54.64
20260721,9986,47.48,48.94,47.4,46.48,58.85,51.96
20260721,9984,41.53,43.35,46.9,49.57,46.44,39.13

DB,keisan.db
TABLE,T_TREND
ORDER_BY,YMD DESC
YMD,CODE,RET_20,RET_60,RET_120,RET_252,RS_252,RANK_NO,TAISHO_SU,PRICE,MA150,HIGH_252,LOW_252,HIGH_DISTANCE_252,LOW_RISE_252,PREV_HIGH_60,HIGH_BREAK_60,CURRENT_VOLUME,AVG_VOLUME_20,AVG_VOLUME_PREV_20,VOLUME_RATIO_20,RANGE_20,RANGE_PREV_20,RANGE_OLD_20,VCP_FLG,VOLUME_CONTRACTION_FLG,BASE_YMD,BASE_PRICE,DATA_COUNT,KEISAN_VER,DATETIME
20260721,0001,-8.4608637868612,12.592118744293,25.500031833472,66.367058452363,87.55008255366,458,3635,66232.19,58469.4668,70384.59,0,5.8995868271734,,70384.59,0,,0,0,,70384.59,0,0,0,0,20250707,39810.88,252,1,2026-07-21 16:35:28
20260721,0002,-1.956020073015,6.2994106464885,11.846393849068,41.973867996252,78.205833791965,801,3635,4014.95,3738.3305333333,4137.62,0,2.9647478502134,,4137.62,0,,0,0,,4137.62,0,0,0,0,20250707,2827.95,252,1,2026-07-21 16:35:28
20260721,1301,2.7241770715096,-4.8370136698212,-10.039761431412,0,33.337094111172,2439,3635,4525,4779.9333333333,5450,4165,16.97247706422,8.6434573829532,4915,0,36000,42710,43560,0.82644628099174,285,345,555,1,1,20250707,4525,252,1,2026-07-21 16:35:28
20260721,130A,-1.9464720194647,-16.390041493776,-16.56314699793,-33.607907742998,7.4565217391304,3398,3635,403,461.25333333333,940,390,57.127659574468,3.3333333333333,499,0,12200,8665,9200,1.3260869565217,40,45,99,1,1,20250707,607,252,1,2026-07-21 16:35:28
20260721,1332,-1.2480499219969,-0.86139389193423,4.0262941659819,43.684031324481,79.268299394607,762,3635,1266,1300.67,1570,859,19.363057324841,47.380675203725,1369,0,1493100,1388775,1370420,1.0895200011675,89,128,199,1,0,20250707,881.1,252,1,2026-07-21 16:35:28
20260721,1333,3.8176860148033,-2.488108305891,-4.4802867383513,30.215967946839,71.476884975234,1048,3635,1332.5,1363.0806666667,1589,1005,16.142227816237,32.587064676617,1428,0,428700,525270,526395,0.81440743168153,91,79,198,0,0,20250707,1023.3,252,1,2026-07-21 16:35:28
20260721,135A,-8.6021505376344,5.0824175824176,43.581081081081,49.882445141066,81.829113924051,668,3635,3825,3292.32,4790,1910,20.146137787056,100.26178010471,4790,0,74000,114495,121440,0.60935441370224,1035,1250,1670,1,1,20250707,2552,252,1,2026-07-21 16:35:28
20260721,1375,3.8914027149321,8.0979284369115,6.9897483690587,4.3636363636364,40.747110621904,2176,3635,1148,1076.3666666667,1189,1000,3.448275862069,14.8,1189,0,45800,46435,47010,0.97426079557541,89,81,54,0,1,20250707,1100,252,1,2026-07-21 16:35:28
20260721,1376,5.5939226519337,5.5210489993099,-0.19582245430809,11.769005847953,52.270776004403,1753,3635,1529,1483.3933333333,1859,1364,17.751479289941,12.096774193548,1576,0,17200,17265,17660,0.97395243488109,139,95,72,0,1,20250707,1368,252,1,2026-07-21 16:35:28
20260721,1377,5.0119331742243,5.515587529976,9.0458488228005,25.177809388336,67.009080902587,1212,3635,4400,4216.7,4715,3310,6.6808059384942,32.930513595166,4715,0,129900,149910,147800,0.87889039242219,575,235,230,0,1,20250707,3515,252,1,2026-07-21 16:35:28