Spaces:
Running
Running
File size: 590 Bytes
976166f |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 |
'''
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
}
|