Baselight
Sign In

Stock Information

Tradable in Robinhood

@kaggle.vaghefi_robinhood

Robinhood
@kaggle.vaghefi_robinhood.robinhood

  • 1.95 MB
  • 4610 rows
  • 33 columns
simple_name

Simple Name

name

Name

symbol

Symbol

bloomberg_unique

Bloomberg Unique

margin_initial_ratio

Margin Initial Ratio

maintenance_ratio

Maintenance Ratio

country

Country

day_trade_ratio

Day Trade Ratio

list_date

List Date

type

Type

default_collar_fraction

Default Collar Fraction

open

Open

high

High

low

Low

volume

Volume

average_volume_2_weeks

Average Volume 2 Weeks

average_volume

Average Volume

high_52_weeks

High 52 Weeks

dividend_yield

Dividend Yield

float

Float

low_52_weeks

Low 52 Weeks

market_cap

Market Cap

pb_ratio

Pb Ratio

pe_ratio

Pe Ratio

shares_outstanding

Shares Outstanding

description

Description

ceo

Ceo

headquarters_city

Headquarters City

headquarters_state

Headquarters State

sector

Sector

industry

Industry

num_employees

Num Employees

year_founded

Year Founded

Aurora CannabisAurora Cannabis Inc. Common SharesACBEQ000000003634338511CA0.25Thu Jul 10 2014 00:00:00 GMT+0000 (Coordinated Universal Time)stock0.051.351.431.32957967126813041.826813041.810.3211347136891.3115762243210.5360011168980000Aurora Cannabis, Inc. engages in the production, distribution and sale of cannabis products. It also produces and sells indoor cultivation systems and hemp related food products. The company was founded by Terry Booth and Steve Dobler on December 21, 2006 and is headquartered in Edmonton, Canada.Michael SingerEdmontonAlbertaProcess IndustriesAgricultural Commodities/Milling27792006
FordFord Motor CompanyFEQ00100602000010000.50.25US0.25Tue Jan 02 1990 00:00:00 GMT+0000 (Coordinated Universal Time)stock0.057.097.096.923809410098639445.398639445.310.568.3333338879207656.67275967127380.883266615.3853965050000Ford Motor Co. engages in the manufacture, distribution, and sale of automobiles. It operates through the following three segments: Automotive, Mobility, and Ford Credit. The Automotive segment engages in developing, manufacturing, marketing and servicing of Ford cars, Lincoln vehicles. The Mobility…James P. HackettDearbornMichiganConsumer DurablesMotor Vehicles1900001903
GEGeneral Electric CompanyGEEQ00100632000010000.50.25US0.25Tue Jan 02 1990 00:00:00 GMT+0000 (Coordinated Universal Time)stock0.0511.0611.1210.7653341840690629654.790629654.713.260.3568287031452047.65950937024003.46019147.638738434000General Electric Co. is a technology and financial services company. It operates through the following segments: Power, Renewable Energy, Aviation, Healthcare, and Capital. The Power segment offers technologies, solutions, and services related to energy production, which includes gas and steam turbi…H. Lawrence Culp, Jr., MBABostonMassachusettsElectronic TechnologyAerospace And Defense2050001878
MicrosoftMicrosoft Corporation Common StockMSFTEQ00101743000010000.50.25US0.25Thu Sep 17 1987 00:00:00 GMT+0000 (Coordinated Universal Time)stock0.05168.48169.28165.622180135666904114.666904114.6190.71.180627489814344109.01123000000000011.943730.07877606050000Microsoft Corp. engages in the development and support of software, services, devices, and solutions. It operates through the following business segments: Productivity and Business Processes; Intelligent Cloud; and More Personal Computing. The Productivity and Business Processes segment comprises pr…Satya NadellaRedmondWashingtonTechnology ServicesPackaged Software1440001975
GoProGoPro, Inc. Class A Common StockGPROEQ00000000171078610.60.5US0.25Thu Jun 26 2014 00:00:00 GMT+0000 (Coordinated Universal Time)stock0.054.034.073.9119710325832852.45832852.47.6451197180003.255920043112.4739155996000GoPro, Inc. engages in manufacturing and selling camera and camera accessories. The company provides mountable and wearable cameras and accessories, which refers as capture devices. Its product brands include Hero7, Fusion, GoPro Plus, Quik, GoPro App and Karma Grip. It also offers an ecosystem of m…Nicholas WoodmanSan MateoCaliforniaConsumer DurablesElectronics/Appliances9262002
FitbitFitbit, Inc. Class A common stockFITEQ00000000205595690.50.25US0.25Thu Jun 18 2015 00:00:00 GMT+0000 (Coordinated Universal Time)stock0.056.446.456.3420545477932401.77932401.77.26232802490.92.8116951088413.52806265275245Fitbit, Inc. engages in the development of wearable device which tracks data of an individual's health. Its products include smartwatches, trackers, smart scales, and accessories. The company was founded by Eric N. Friedman and James Park in March 2007 and is headquartered in San Francisco, CA.James ParkSan FranciscoCaliforniaConsumer DurablesOther Consumer Specialties16842007
AppleApple Inc. Common StockAAPLEQ00101695000010000.50.25US0.25Tue Jan 02 1990 00:00:00 GMT+0000 (Coordinated Universal Time)stock0.05296.44298.48293.132743506163424086.563424086.5327.851.030764368676129169.5120000000000014.634823.59974375480000Apple, Inc. engages in the design, manufacture, and sale of smartphones, personal computers, tablets, wearables and accessories, and other variety of related services. It operates through the following geographical segments: Americas, Europe, Greater China, Japan, and Rest of Asia Pacific. The Ameri…Timothy Donald CookCupertinoCaliforniaElectronic TechnologyTelecommunications Equipment1370001976
Plug PowerPlug Power, Inc. Common StockPLUGEQ00883408000010000.60.5US0.25Fri Oct 29 1999 00:00:00 GMT+0000 (Coordinated Universal Time)stock0.054.614.664.45734226636620084366200846.05303859651.51.551332686890-74.7307307071000Plug Power, Inc. provides alternative energy technology, which focuses on the design, development, commercialization, and manufacture of hydrogen and fuel cell systems used primarily for the material handling and stationary power markets. Its fuel cell system solution is designed to replace lead-aci…Andrew J. MarshLathamNew YorkElectronic TechnologyElectronic Components6851997
DisneyThe Walt Disney CompanyDISEQ00100463000010000.50.25US0.25Tue Jan 02 1990 00:00:00 GMT+0000 (Coordinated Universal Time)stock0.05119119.2115.5679221920819523.920819523.9153.411.466911802345476107.322120000000002.380719.17411805440000The Walt Disney Co. is a diversified international family entertainment and media enterprise. It operates through the following segments: Media Networks, Parks, Experiences and Products, Studio Entertainment and Direct-to-Consumer and International (DTCI). The Media Networks segment includes cable a…Robert ChapekBurbankCaliforniaConsumer ServicesMedia Conglomerates2230001923
AMDAdvanced Micro Devices, Inc. Common StockAMDEQ00100010000010000.50.25US0.25Tue Jan 02 1990 00:00:00 GMT+0000 (Coordinated Universal Time)stock0.0548.2549.1147.2254132667100530254.9100530254.959.27110489241721.0355319620312519.6421155.8621169660000Advanced Micro Devices, Inc. engages in the provision of semiconductor businesses. It operates through the following segments: Computing & Graphics, and Enterprise, Embedded and Semi-Custom. The Computing and Graphics segment includes desktop and notebook processors and chipsets, discrete and integr…Lisa T. SuSanta ClaraCaliforniaElectronic TechnologySemiconductors114001969

CREATE TABLE robinhood (
  "simple_name" VARCHAR,
  "name" VARCHAR,
  "symbol" VARCHAR,
  "bloomberg_unique" VARCHAR,
  "margin_initial_ratio" DOUBLE,
  "maintenance_ratio" DOUBLE,
  "country" VARCHAR,
  "day_trade_ratio" DOUBLE,
  "list_date" TIMESTAMP,
  "type" VARCHAR,
  "default_collar_fraction" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "volume" BIGINT,
  "average_volume_2_weeks" DOUBLE,
  "average_volume" DOUBLE,
  "high_52_weeks" DOUBLE,
  "dividend_yield" DOUBLE,
  "float" DOUBLE,
  "low_52_weeks" DOUBLE,
  "market_cap" DOUBLE,
  "pb_ratio" DOUBLE,
  "pe_ratio" DOUBLE,
  "shares_outstanding" DOUBLE,
  "description" VARCHAR,
  "ceo" VARCHAR,
  "headquarters_city" VARCHAR,
  "headquarters_state" VARCHAR,
  "sector" VARCHAR,
  "industry" VARCHAR,
  "num_employees" DOUBLE,
  "year_founded" DOUBLE
);