https://questdb.io logo
Title
a

Animus

01/05/2023, 5:15 AM
@sam you have two options based on what we have been able to figure out. You can create the table first and specify the column types which in your case would be for epoch time LONG for column, here is our example when feeding ohlcv through rest api
sql_queries = [{
    'query': f"CREATE TABLE IF NOT EXISTS {table_name} ("
             f"symbol STRING, "
             f"open DOUBLE, "
             f"high DOUBLE, "
             f"low DOUBLE, "
             f"close DOUBLE, "
             f"volumeBase DOUBLE, "
             f"klineTimestamp LONG"
             f")",
    'fmt': 'json'} for table_name in missing_tables]