PREVIEW / stock_daily / 2010-01-27

all stock daily files

  file:    by_date/stock_daily/2010/2010-01-27.parquet
  size:    188 KB
  rows:    5,880
  symbols: 3,490

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2010-01-27	AAPL	Stock	7.3875	7.5207	7.1261	7.4243	1722568400.0
2010-01-27	MSFT	Stock	29.35	29.82	29.02	29.67	63949500.0
2010-01-27	NVDA	Stock	0.405	0.4178	0.4005	0.4162	812504000.0
2010-01-27	AMZN	Stock	6.0515	6.1665	5.94	6.1375	295306000.0
2010-01-27	TLT	Stock	91.75	92.09	91.37	91.56	3325650.0
2010-01-27	ES	Stock	25.46	25.6	25.1	25.56	1787800.0
2010-01-27	CL	Stock	40.195	40.41	39.83	40.195	6222200.0
2010-01-27	A	Stock	20.887	20.9514	20.5508	20.8655	4362179.0
2010-01-27	AABA-DELISTED	Stock	16.48	16.49	15.77	15.97	41272258.0
2010-01-27	AACC-DELISTED	Stock	5.61	6.08	5.61	6.03	12708.0
2010-01-27	AACG	Stock	3.95	3.95	3.88	3.89	6000.0
2010-01-27	AAI-DELISTED	Stock	5.45	5.49	5.05	5.32	9760220.0
2010-01-27	AAIC-DELISTED	Stock	14.4	14.95	14.4	14.95	16700.0
2010-01-27	AAON	Stock	3.9644	4.1679	3.9388	4.1521	947194.0
2010-01-27	AAP	Stock	40.59	40.74	39.95	40.59	1203200.0
2010-01-27	AATI-DELISTED	Stock	3.5	3.61	3.46	3.54	126265.0
2010-01-27	AAU-DELISTED	Stock	0.94	0.9533	0.9	0.9099	240160.0
2010-01-27	AAUAF-DELISTED	Stock	0.94	0.9533	0.9	0.9099	240560.0
2010-01-27	AAV-DELISTED	Stock	6.47	6.52	6.27	6.38	631043.0
2010-01-27	AAWW-DELISTED	Stock	36.2	37.47	35.01	37.33	573668.0
2010-01-27	AAXJ	Stock	52.51	52.84	51.87	52.84	532818.0
2010-01-27	AAXN-DELISTED	Stock	5.8	5.95	5.78	5.91	841437.0
2010-01-27	AB	Stock	27.24	27.37	26.25	27.21	685300.0
2010-01-27	ABAX-DELISTED	Stock	23.38	23.73	23.33	23.56	94588.0
2010-01-27	ABB-DELISTED	Stock	18.84	18.935	18.55	18.88	5272946.0
2010-01-27	ABBC-DELISTED	Stock	7.03	7.25	7.03	7.25	25392.0
2010-01-27	ABBNY-DELISTED	Stock	18.84	18.935	18.55	18.88	5276566.0
2010-01-27	ABC-DELISTED	Stock	27.57	27.64	27.001	27.22	4875750.0
2010-01-27	ABCB	Stock	9.0865	9.3334	9.0865	9.2939	22882.0
2010-01-27	ABCD-DELISTED	Stock	3.86	3.9001	3.86	3.8901	850.0
2010-01-27	ABCO-DELISTED	Stock	15.723	16.432	15.723	16.297	91042.0
2010-01-27	ABCW-DELISTED	Stock	1.18	1.27	1.11	1.24	212270.0
2010-01-27	ABD-DELISTED	Stock	7.96	8.06	7.66	7.99	346340.0
2010-01-27	ABE-DELISTED	Stock	16.0	16.01	15.8	15.98	17419.0
2010-01-27	ABEO	Stock	3375.0	3475.0	3375.0	3437.5	38.0
2010-01-27	ABFS-DELISTED	Stock	26.06	26.69	25.89	25.97	713745.0
2010-01-27	ABG	Stock	11.85	12.04	11.63	11.78	274100.0
2010-01-27	ABII-DELISTED	Stock	41.56	42.1	41.35	41.37	9945.0
2010-01-27	ABK-DELISTED	Stock	0.7122	0.7292	0.67	0.706	7939683.0
2010-01-27	ABM	Stock	19.23	19.71	19.23	19.66	127700.0
2010-01-27	ABMD-DELISTED	Stock	8.09	8.31	8.08	8.28	106924.0
2010-01-27	ABR	Stock	2.14	2.16	2.05	2.05	77100.0
2010-01-27	ABT	Stock	25.9572	25.9764	25.5014	25.8612	24107753.0
2010-01-27	ABTL-DELISTED	Stock	5.15	5.2	4.9525	5.2	14080.0
2010-01-27	ABV-DELISTED	Stock	96.08	96.84	94.45	95.91	554753.0
2010-01-27	ABVT-DELISTED	Stock	62.0	62.75	61.65	62.25	140642.0
2010-01-27	ABX-DELISTED	Stock	35.93	36.27	35.2	35.78	12435375.0
2010-01-27	ACAD	Stock	1.28	1.31	1.23	1.27	335800.0
2010-01-27	ACAP-DELISTED	Stock	28.14	28.74	28.02	28.55	27267.0
2010-01-27	ACAS-DELISTED	Stock	3.74	3.85	3.7	3.85	3915158.0

> showing 50 of 5,880 rows — these rows as CSV

> unlock the full archive -- $79 one-time