Baselight

SEC Data 10Q And 10K

SEC data downloaded from the SEC website in bulk

@kaggle.malik1641_sec_data_with_market_cap_added

Loading...
Loading...

About this Dataset

SEC Data 10Q And 10K

this data is 10Q and 10K reports downloaded as JSON files, i then did tern them to parquet files for efficiency with every data frame there is a market cap column that is a masseur of the market cap of that day
you can always get the data from the SEC website the latest update for the data should be here
https://www.sec.gov/Archives/edgar/daily-index/xbrl/companyfacts.zip
A.csv is just an example of what the rest of the data is going to look like.
enjoy it if you can

Tables

A

@kaggle.malik1641_sec_data_with_market_cap_added.a
  • 824.07 KB
  • 64 rows
  • 762 columns
Loading...

CREATE TABLE a (
  "unnamed_0" TIMESTAMP,
  "accountspayablecurrent_usd" BIGINT,
  "accountsreceivablenetcurrent_usd" BIGINT,
  "accrualforenvironmentallosscontingencies_usd" DOUBLE,
  "accrualforenvironmentallosscontingenciesdiscountrate_pure" DOUBLE,
  "accrualforenvironmentallosscontingenciesgross_usd" DOUBLE,
  "accruedemployeebenefitscurrentandnoncurrent_usd" DOUBLE,
  "accruedincometaxescurrent_usd" DOUBLE,
  "accruedincometaxesnoncurrent_usd" DOUBLE,
  "accumulateddepreciationdepletionandamortizationpropert_4c10e814" DOUBLE,
  "accumulatedothercomprehensiveincomelossavailableforsal_ec2fd3e7" DOUBLE,
  "accumulatedothercomprehensiveincomelosscumulativechang_cdfe125e" DOUBLE,
  "accumulatedothercomprehensiveincomelossdefinedbenefitp_5cc78673" DOUBLE,
  "accumulatedothercomprehensiveincomelossforeigncurrency_b959c6aa" DOUBLE,
  "accumulatedothercomprehensiveincomelossnetoftax_usd" BIGINT,
  "acquiredfinitelivedintangibleassetamount_usd" DOUBLE,
  "additionalpaidincapital_usd" BIGINT,
  "adjustmentforamortization_usd" DOUBLE,
  "adjustmentsnoncashitemstoreconcilenetincomelosstocashp_3400682a" DOUBLE,
  "adjustmentstoadditionalpaidincapitalother_usd" DOUBLE,
  "adjustmentstoadditionalpaidincapitalsharebasedcompensa_6628af28" DOUBLE,
  "adjustmentstoadditionalpaidincapitaltaxeffectfromshare_8123d051" DOUBLE,
  "adjustmenttoadditionalpaidincapitalincometaxeffectfrom_fd203483" DOUBLE,
  "advertisingexpense_usd" DOUBLE,
  "allocatedsharebasedcompensationexpense_usd" DOUBLE,
  "allowancefordoubtfulaccountsreceivablewriteoffs_usd" DOUBLE,
  "amortizationofintangibleassets_usd" DOUBLE,
  "antidilutivesecuritiesexcludedfromcomputationofearning_a26634b0" DOUBLE,
  "aocilosscashflowhedgecumulativegainlossaftertax_usd" DOUBLE,
  "assetimpairmentcharges_usd" DOUBLE,
  "assets_usd" BIGINT,
  "assetscurrent_usd" BIGINT,
  "assetsfairvaluedisclosure_usd" DOUBLE,
  "assetsfairvaluedisclosurenonrecurring_usd" DOUBLE,
  "assetsofdisposalgroupincludingdiscontinuedoperation_usd" DOUBLE,
  "assetsofdisposalgroupincludingdiscontinuedoperationcurrent_usd" DOUBLE,
  "availableforsalesecurities_usd" DOUBLE,
  "availableforsalesecuritiesamortizedcost_usd" DOUBLE,
  "availableforsalesecuritiesgrossunrealizedgains_usd" DOUBLE,
  "availableforsalesecuritiesgrossunrealizedloss_usd" DOUBLE,
  "availableforsalesecuritiesgrossunrealizedlosses1_usd" DOUBLE,
  "availableforsalesecuritiesnoncurrent_usd" DOUBLE,
  "availableforsalesecuritiesgrossunrealizedgain_usd" DOUBLE,
  "bankacceptancesexecuted_usd" DOUBLE,
  "buildingsandimprovementsgross_usd" DOUBLE,
  "businessacquisitioncostofacquiredentitypurchaseprice_usd" DOUBLE,
  "businessacquisitionproformaearningspersharebasic_usd_shares" DOUBLE,
  "businessacquisitionproformaearningspersharediluted_usd_shares" DOUBLE,
  "businessacquisitionproformanetincomeloss_usd" DOUBLE,
  "businessacquisitionproformarevenue_usd" DOUBLE,
  "businessacquisitionpurchasepriceallocationamortizablei_cb2e934d" DOUBLE,
  "businessacquisitionpurchasepriceallocationdeferredinco_da4926e0" DOUBLE,
  "businessacquisitionsproformanetincomeloss_usd" DOUBLE,
  "businessacquisitionsproformarevenue_usd" DOUBLE,
  "businesscombinationacquisitionrelatedcosts_usd" DOUBLE,
  "businesscombinationconsiderationtransferred1_usd" DOUBLE,
  "businesscombinationcontingentconsiderationarrangements_93518735" DOUBLE,
  "businesscombinationstepacquisitionequityinterestinacqu_8b050e4f" DOUBLE,
  "businesscombinationstepacquisitionequityinterestinacqu_f40ac499" DOUBLE,
  "businessexitcosts1_usd" DOUBLE,
  "capitalizedcomputersoftwaregross_usd" DOUBLE,
  "capitalleaseobligationscurrent_usd" DOUBLE,
  "capitalleaseobligationsnoncurrent_usd" DOUBLE,
  "capitalleasesnetinvestmentindirectfinancingleasesdefer_905db966" DOUBLE,
  "capitalleasesnetinvestmentindirectfinancingleasesiniti_897c0af6" DOUBLE,
  "cashandcashequivalentsatcarryingvalue_usd" BIGINT,
  "cashandcashequivalentsatcarryingvalueincludingdisconti_f6a80d0f" DOUBLE,
  "cashandcashequivalentsperiodincreasedecrease_usd" DOUBLE,
  "cashcashequivalentsrestrictedcashandrestrictedcashequi_de615e97" DOUBLE,
  "cashcashequivalentsrestrictedcashandrestrictedcashequi_3a682bce" DOUBLE,
  "cashflowhedgegainlosstobereclassifiedwithintwelvemonths_usd" DOUBLE,
  "commitmentsandcontingencies_usd" DOUBLE,
  "commonstockdividendspersharecashpaid_usd_shares" DOUBLE,
  "commonstockdividendspersharedeclared_usd_shares" DOUBLE,
  "commonstockparorstatedvaluepershare_usd_shares" DOUBLE,
  "commonstocksharesauthorized_shares" DOUBLE,
  "commonstocksharesissued_shares" DOUBLE,
  "commonstocksharesoutstanding_shares" DOUBLE,
  "commonstockvalue_usd" BIGINT,
  "comprehensiveincomenetoftax_usd" DOUBLE,
  "comprehensiveincomenetoftaxincludingportionattributabl_74562e8c" DOUBLE,
  "contractwithcustomerassetnet_usd" DOUBLE,
  "contractwithcustomerliability_usd" DOUBLE,
  "contractwithcustomerliabilityincreasedecreaseforcontra_7aa6be6c" DOUBLE,
  "contractwithcustomerliabilityrevenuerecognized_usd" DOUBLE,
  "costmethodinvestments_usd" DOUBLE,
  "costmethodinvestmentsaggregatecarryingamount_usd" DOUBLE,
  "costmethodinvestmentsoriginalcost_usd" DOUBLE,
  "costmethodinvestmentsrealizedgainloss_usd" DOUBLE,
  "costofgoodsandservicessold_usd" DOUBLE,
  "costofgoodssold_usd" DOUBLE,
  "costofrevenue_usd" DOUBLE,
  "costsandexpenses_usd" DOUBLE,
  "cumulativeeffectofinitialadoptionoffin48_usd" DOUBLE,
  "cumulativeeffectofinitialadoptionofsfas158_usd" DOUBLE,
  "cumulativeeffectofnewaccountingprincipleinperiodofadoption_usd" DOUBLE,
  "currentfederaltaxexpensebenefit_usd" DOUBLE,
  "currentforeigntaxexpensebenefit_usd" DOUBLE,
  "currentstateandlocaltaxexpensebenefit_usd" DOUBLE,
  "debtinstrumentcarryingamount_usd" DOUBLE
);

Share link

Anyone who has the link will be able to view this.