import pandas as pd
import dolphindb as ddb

# Create a session and log in.
s = ddb.session("127.0.0.1", 8848, 'testUser2', '123456')

# Access all table data.
sqlStr = """query(startDate=2015.01.01, endDate=2024.12.31, cols="*", security=NULL)"""
df = s.run(sqlStr)

# Access all data from the last year.
sqlStr = """queryRecentYear(startDate=2024.07.01)"""
df = s.run(sqlStr)

# Access all accessible columns for the specified securities in 2023.
sqlStr = """queryFirst10Col(startDate=2023.01.01, endDate=2023.12.31, security=`000008`000009`000010)"""
df = s.run(sqlStr)

# Access data of the specified columns in 2021.
sqlStr = """queryCond(startDate=2021.01.01, endDate=2021.12.31, cols=`SecurityID`date`time`col47`col48`col49)"""
df = s.run(sqlStr)