Name: SEC Data 10Q And 10K
Creator: Kaggle
License: https://www.apache.org/licenses/
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
843.84 kB
64 rows
762 columns
CREATE TABLE a (
  "unnamed_0" TIMESTAMP  -- Unnamed: 0,
  "accountspayablecurrent_usd" BIGINT  -- AccountsPayableCurrent - USD,
  "accountsreceivablenetcurrent_usd" BIGINT  -- AccountsReceivableNetCurrent - USD,
  "accrualforenvironmentallosscontingencies_usd" DOUBLE  -- AccrualForEnvironmentalLossContingencies - USD,
  "accrualforenvironmentallosscontingenciesdiscountrate_pure" DOUBLE  -- AccrualForEnvironmentalLossContingenciesDiscountRate - Pure,
  "accrualforenvironmentallosscontingenciesgross_usd" DOUBLE  -- AccrualForEnvironmentalLossContingenciesGross - USD,
  "accruedemployeebenefitscurrentandnoncurrent_usd" DOUBLE  -- AccruedEmployeeBenefitsCurrentAndNoncurrent - USD,
  "accruedincometaxescurrent_usd" DOUBLE  -- AccruedIncomeTaxesCurrent - USD,
  "accruedincometaxesnoncurrent_usd" DOUBLE  -- AccruedIncomeTaxesNoncurrent - USD,
  "accumulateddepreciationdepletionandamortizationpropert_4c10e814" DOUBLE  -- AccumulatedDepreciationDepletionAndAmortizationPropertyPlantAndEquipment - USD,
  "accumulatedothercomprehensiveincomelossavailableforsal_ec2fd3e7" DOUBLE  -- AccumulatedOtherComprehensiveIncomeLossAvailableForSaleSecuritiesAdjustmentNetOfTax - USD,
  "accumulatedothercomprehensiveincomelosscumulativechang_cdfe125e" DOUBLE  -- AccumulatedOtherComprehensiveIncomeLossCumulativeChangesInNetGainLossFromCashFlowHedgesEffectNetOfTax - USD,
  "accumulatedothercomprehensiveincomelossdefinedbenefitp_5cc78673" DOUBLE  -- AccumulatedOtherComprehensiveIncomeLossDefinedBenefitPensionAndOtherPostretirementPlansNetOfTax - USD,
  "accumulatedothercomprehensiveincomelossforeigncurrency_b959c6aa" DOUBLE  -- AccumulatedOtherComprehensiveIncomeLossForeignCurrencyTranslationAdjustmentNetOfTax - USD,
  "accumulatedothercomprehensiveincomelossnetoftax_usd" BIGINT  -- AccumulatedOtherComprehensiveIncomeLossNetOfTax - USD,
  "acquiredfinitelivedintangibleassetamount_usd" DOUBLE  -- AcquiredFiniteLivedIntangibleAssetAmount - USD,
  "additionalpaidincapital_usd" BIGINT  -- AdditionalPaidInCapital - USD,
  "adjustmentforamortization_usd" DOUBLE  -- AdjustmentForAmortization - USD,
  "adjustmentsnoncashitemstoreconcilenetincomelosstocashp_3400682a" DOUBLE  -- AdjustmentsNoncashItemsToReconcileNetIncomeLossToCashProvidedByUsedInOperatingActivitiesOther - USD,
  "adjustmentstoadditionalpaidincapitalother_usd" DOUBLE  -- AdjustmentsToAdditionalPaidInCapitalOther - USD,
  "adjustmentstoadditionalpaidincapitalsharebasedcompensa_6628af28" DOUBLE  -- AdjustmentsToAdditionalPaidInCapitalSharebasedCompensationRequisiteServicePeriodRecognitionValue - USD,
  "adjustmentstoadditionalpaidincapitaltaxeffectfromshare_8123d051" DOUBLE  -- AdjustmentsToAdditionalPaidInCapitalTaxEffectFromShareBasedCompensation - USD,
  "adjustmenttoadditionalpaidincapitalincometaxeffectfrom_fd203483" DOUBLE  -- AdjustmentToAdditionalPaidInCapitalIncomeTaxEffectFromShareBasedCompensationNet - USD,
  "advertisingexpense_usd" DOUBLE  -- AdvertisingExpense - USD,
  "allocatedsharebasedcompensationexpense_usd" DOUBLE  -- AllocatedShareBasedCompensationExpense - USD,
  "allowancefordoubtfulaccountsreceivablewriteoffs_usd" DOUBLE  -- AllowanceForDoubtfulAccountsReceivableWriteOffs - USD,
  "amortizationofintangibleassets_usd" DOUBLE  -- AmortizationOfIntangibleAssets - USD,
  "antidilutivesecuritiesexcludedfromcomputationofearning_a26634b0" DOUBLE  -- AntidilutiveSecuritiesExcludedFromComputationOfEarningsPerShareAmount - Shares,
  "aocilosscashflowhedgecumulativegainlossaftertax_usd" DOUBLE  -- AociLossCashFlowHedgeCumulativeGainLossAfterTax - USD,
  "assetimpairmentcharges_usd" DOUBLE  -- AssetImpairmentCharges - USD,
  "assets_usd" BIGINT  -- Assets - USD,
  "assetscurrent_usd" BIGINT  -- AssetsCurrent - USD,
  "assetsfairvaluedisclosure_usd" DOUBLE  -- AssetsFairValueDisclosure - USD,
  "assetsfairvaluedisclosurenonrecurring_usd" DOUBLE  -- AssetsFairValueDisclosureNonrecurring - USD,
  "assetsofdisposalgroupincludingdiscontinuedoperation_usd" DOUBLE  -- AssetsOfDisposalGroupIncludingDiscontinuedOperation - USD,
  "assetsofdisposalgroupincludingdiscontinuedoperationcurrent_usd" DOUBLE  -- AssetsOfDisposalGroupIncludingDiscontinuedOperationCurrent - USD,
  "availableforsalesecurities_usd" DOUBLE  -- AvailableForSaleSecurities - USD,
  "availableforsalesecuritiesamortizedcost_usd" DOUBLE  -- AvailableForSaleSecuritiesAmortizedCost - USD,
  "availableforsalesecuritiesgrossunrealizedgains_usd" DOUBLE  -- AvailableForSaleSecuritiesGrossUnrealizedGains - USD,
  "availableforsalesecuritiesgrossunrealizedloss_usd" DOUBLE  -- AvailableForSaleSecuritiesGrossUnrealizedLoss - USD,
  "availableforsalesecuritiesgrossunrealizedlosses1_usd" DOUBLE  -- AvailableForSaleSecuritiesGrossUnrealizedLosses1 - USD,
  "availableforsalesecuritiesnoncurrent_usd" DOUBLE  -- AvailableForSaleSecuritiesNoncurrent - USD,
  "availableforsalesecuritiesgrossunrealizedgain_usd" DOUBLE  -- AvailableforsaleSecuritiesGrossUnrealizedGain - USD,
  "bankacceptancesexecuted_usd" DOUBLE  -- BankAcceptancesExecuted - USD,
  "buildingsandimprovementsgross_usd" DOUBLE  -- BuildingsAndImprovementsGross - USD,
  "businessacquisitioncostofacquiredentitypurchaseprice_usd" DOUBLE  -- BusinessAcquisitionCostOfAcquiredEntityPurchasePrice - USD,
  "businessacquisitionproformaearningspersharebasic_usd_shares" DOUBLE  -- BusinessAcquisitionProFormaEarningsPerShareBasic - USD/shares,
  "businessacquisitionproformaearningspersharediluted_usd_shares" DOUBLE  -- BusinessAcquisitionProFormaEarningsPerShareDiluted - USD/shares,
  "businessacquisitionproformanetincomeloss_usd" DOUBLE  -- BusinessAcquisitionProFormaNetIncomeLoss - USD,
  "businessacquisitionproformarevenue_usd" DOUBLE  -- BusinessAcquisitionProFormaRevenue - USD,
  "businessacquisitionpurchasepriceallocationamortizablei_cb2e934d" DOUBLE  -- BusinessAcquisitionPurchasePriceAllocationAmortizableIntangibleAssets - USD,
  "businessacquisitionpurchasepriceallocationdeferredinco_da4926e0" DOUBLE  -- BusinessAcquisitionPurchasePriceAllocationDeferredIncomeTaxesAssetLiabilityNet - USD,
  "businessacquisitionsproformanetincomeloss_usd" DOUBLE  -- BusinessAcquisitionsProFormaNetIncomeLoss - USD,
  "businessacquisitionsproformarevenue_usd" DOUBLE  -- BusinessAcquisitionsProFormaRevenue - USD,
  "businesscombinationacquisitionrelatedcosts_usd" DOUBLE  -- BusinessCombinationAcquisitionRelatedCosts - USD,
  "businesscombinationconsiderationtransferred1_usd" DOUBLE  -- BusinessCombinationConsiderationTransferred1 - USD,
  "businesscombinationcontingentconsiderationarrangements_93518735" DOUBLE  -- BusinessCombinationContingentConsiderationArrangementsChangeInAmountOfContingentConsiderationLiability1 - USD,
  "businesscombinationstepacquisitionequityinterestinacqu_8b050e4f" DOUBLE  -- BusinessCombinationStepAcquisitionEquityInterestInAcquireeRemeasurementGain - USD,
  "businesscombinationstepacquisitionequityinterestinacqu_f40ac499" DOUBLE  -- BusinessCombinationStepAcquisitionEquityInterestInAcquireeRemeasurementGainOrLoss - USD,
  "businessexitcosts1_usd" DOUBLE  -- BusinessExitCosts1 - USD,
  "capitalizedcomputersoftwaregross_usd" DOUBLE  -- CapitalizedComputerSoftwareGross - USD,
  "capitalleaseobligationscurrent_usd" DOUBLE  -- CapitalLeaseObligationsCurrent - USD,
  "capitalleaseobligationsnoncurrent_usd" DOUBLE  -- CapitalLeaseObligationsNoncurrent - USD,
  "capitalleasesnetinvestmentindirectfinancingleasesdefer_905db966" DOUBLE  -- CapitalLeasesNetInvestmentInDirectFinancingLeasesDeferredIncome - USD,
  "capitalleasesnetinvestmentindirectfinancingleasesiniti_897c0af6" DOUBLE  -- CapitalLeasesNetInvestmentInDirectFinancingLeasesInitialDirectCosts - USD,
  "cashandcashequivalentsatcarryingvalue_usd" BIGINT  -- CashAndCashEquivalentsAtCarryingValue - USD,
  "cashandcashequivalentsatcarryingvalueincludingdisconti_f6a80d0f" DOUBLE  -- CashAndCashEquivalentsAtCarryingValueIncludingDiscontinuedOperations - USD,
  "cashandcashequivalentsperiodincreasedecrease_usd" DOUBLE  -- CashAndCashEquivalentsPeriodIncreaseDecrease - USD,
  "cashcashequivalentsrestrictedcashandrestrictedcashequi_de615e97" DOUBLE  -- CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalents - USD,
  "cashcashequivalentsrestrictedcashandrestrictedcashequi_3a682bce" DOUBLE  -- CashCashEquivalentsRestrictedCashAndRestrictedCashEquivalentsPeriodIncreaseDecreaseIncludingExchangeRateEffect - USD,
  "cashflowhedgegainlosstobereclassifiedwithintwelvemonths_usd" DOUBLE  -- CashFlowHedgeGainLossToBeReclassifiedWithinTwelveMonths - USD,
  "commitmentsandcontingencies_usd" DOUBLE  -- CommitmentsAndContingencies - USD,
  "commonstockdividendspersharecashpaid_usd_shares" DOUBLE  -- CommonStockDividendsPerShareCashPaid - USD/shares,
  "commonstockdividendspersharedeclared_usd_shares" DOUBLE  -- CommonStockDividendsPerShareDeclared - USD/shares,
  "commonstockparorstatedvaluepershare_usd_shares" DOUBLE  -- CommonStockParOrStatedValuePerShare - USD/shares,
  "commonstocksharesauthorized_shares" DOUBLE  -- CommonStockSharesAuthorized - Shares,
  "commonstocksharesissued_shares" DOUBLE  -- CommonStockSharesIssued - Shares,
  "commonstocksharesoutstanding_shares" DOUBLE  -- CommonStockSharesOutstanding - Shares,
  "commonstockvalue_usd" BIGINT  -- CommonStockValue - USD,
  "comprehensiveincomenetoftax_usd" DOUBLE  -- ComprehensiveIncomeNetOfTax - USD,
  "comprehensiveincomenetoftaxincludingportionattributabl_74562e8c" DOUBLE  -- ComprehensiveIncomeNetOfTaxIncludingPortionAttributableToNoncontrollingInterest - USD,
  "contractwithcustomerassetnet_usd" DOUBLE  -- ContractWithCustomerAssetNet - USD,
  "contractwithcustomerliability_usd" DOUBLE  -- ContractWithCustomerLiability - USD,
  "contractwithcustomerliabilityincreasedecreaseforcontra_7aa6be6c" DOUBLE  -- ContractWithCustomerLiabilityIncreaseDecreaseForContractAcquiredInBusinessCombination - USD,
  "contractwithcustomerliabilityrevenuerecognized_usd" DOUBLE  -- ContractWithCustomerLiabilityRevenueRecognized - USD,
  "costmethodinvestments_usd" DOUBLE  -- CostMethodInvestments - USD,
  "costmethodinvestmentsaggregatecarryingamount_usd" DOUBLE  -- CostMethodInvestmentsAggregateCarryingAmount - USD,
  "costmethodinvestmentsoriginalcost_usd" DOUBLE  -- CostMethodInvestmentsOriginalCost - USD,
  "costmethodinvestmentsrealizedgainloss_usd" DOUBLE  -- CostMethodInvestmentsRealizedGainLoss - USD,
  "costofgoodsandservicessold_usd" DOUBLE  -- CostOfGoodsAndServicesSold - USD,
  "costofgoodssold_usd" DOUBLE  -- CostOfGoodsSold - USD,
  "costofrevenue_usd" DOUBLE  -- CostOfRevenue - USD,
  "costsandexpenses_usd" DOUBLE  -- CostsAndExpenses - USD,
  "cumulativeeffectofinitialadoptionoffin48_usd" DOUBLE  -- CumulativeEffectOfInitialAdoptionOfFIN48 - USD,
  "cumulativeeffectofinitialadoptionofsfas158_usd" DOUBLE  -- CumulativeEffectOfInitialAdoptionOfSFAS158 - USD,
  "cumulativeeffectofnewaccountingprincipleinperiodofadoption_usd" DOUBLE  -- CumulativeEffectOfNewAccountingPrincipleInPeriodOfAdoption - USD,
  "currentfederaltaxexpensebenefit_usd" DOUBLE  -- CurrentFederalTaxExpenseBenefit - USD,
  "currentforeigntaxexpensebenefit_usd" DOUBLE  -- CurrentForeignTaxExpenseBenefit - USD,
  "currentstateandlocaltaxexpensebenefit_usd" DOUBLE  -- CurrentStateAndLocalTaxExpenseBenefit - USD,
  "debtinstrumentcarryingamount_usd" DOUBLE  -- DebtInstrumentCarryingAmount - USD
);