ticker_data

7323 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
symbol text 2147483647 null
gain_loss.symbol Implied ConstraintR
new_trades.symbol Implied ConstraintR
stock_ohlc.symbol Implied ConstraintR
trade_analysis.symbol Implied ConstraintR
trades.symbol Implied ConstraintR
trending_tickers.symbol Implied ConstraintR
name text 2147483647 null
description text 2147483647 null
tags _text 2147483647 √ null
similar_tickers _text 2147483647 √ null
industry text 2147483647 √ null
sector text 2147483647 √ null
exchange text 2147483647 √ null
short_ratio float8 17,17 √ null
create_tstamp timestamp 29,6 √ CURRENT_TIMESTAMP
modify_tstamp timestamp 29,6 √ null

Indexes

Constraint Name Type Sort Column(s)
ticker_data_pkey Primary key Asc symbol
ticker_data_industry_idx Performance Asc industry
ticker_data_sector_idx Performance Asc sector
ticker_data_similar_tickers_idx Performance Asc similar_tickers
ticker_data_tags_idx Performance Asc tags

Relationships

Close relationships within degrees of separation