SQL Functions

Jump to bottom Edit New page

Ross Palmer edited this page Apr 28, 2015 · 3 revisions

`insert`

.insert(table_name, df)

Insert (or ignore) data from trade or price DataFrame into SQL database.

table_name : name of SQL table to insert data ('trades' or 'price')
df : DataFrame

`select`

.select(table_name, exchange='',  symbol='',
            start='', end='', freq='')

Select data from SQL database and return as DataFrame

table_name : name of SQL table to insert data ('trades' or 'price')
exchange : Bitcoin exchange (str)
symbol : currency symbol (str)
start : beginning timestamp (int or mm/dd/yy)
end : ending timestamp (int or mm/dd/yy)
freq : frequency of price data (str)