我用python api导入数据到DolphinDB分布式表,分布式表按月+按股票分区,建库和导入代码如下:
import os
import glob
import pandas as pd
import datetime as dt
import dolphindb as ddb
if __name__ == "__main__":
s = ddb.session()
s.connect(host="10.63.16.165", port=8921, userid="admin", password="123456")
if not s.existsDatabase("dfs://minute_price"):
s.run("valuep = database(, VALUE, date(1990.01M + (0..600)))")
s.run("""tickerp = database(, HASH, [SYMBOL, 20])""")
s.run("""price_data = database("dfs://minute_price", COMPO, [valuep, tickerp])""")
columns = """`code`wind_code`name`date`time`open`high`low`close`volume`turnover`match_items`int