portfolio_management / table_schema.py
huggingface112's picture
update db with daily stocks price
5fd74e2
raw
history blame
1.05 kB
'''
create df schema for db
'''
PORTFOLIO_TABLE = 'portfolio_profile'
PORTFOLIO_TABLE_SCHEMA = {
'ticker': str,
'shares': int,
'date': 'datetime64[ns]',
'sector': str,
'aggregate_sector': str,
'display_name': str,
'name': str,
'cash': float,
'weight': float,
'ave_price': float
}
STOCKS_DETAILS_TABLE = 'all_stock_info'
STOCKS_DETAILS_TABLE_SCHEMA = {
'display_name': str,
'name': str,
'start_date': 'datetime64[ns]',
'end_date': 'datetime64[ns]',
'type': str,
'ticker': str,
'sector': str,
'aggregate_sector': str
}
STOCKS_PRICE_TABLE = 'stocks_price'
STOCKS_PRICE_TABLE_SCHEMA = {
'time': 'datetime64[ns]',
'ticker': str,
'open': float,
'close': float,
'high': float,
'low': float,
'volume': int,
'money': float,
}
BENCHMARK_TABLE = 'benchmark_profile'
BENCHMARK_TABLE_SCHEMA = {
'date': 'datetime64[ns]',
'weight': float,
'display_name': str,
'ticker': str,
'sector': str,
'aggregate_sector': str,
'name': str
}