PREVIEW / stock_daily / 2009-10-26

all stock daily files

  file:    by_date/stock_daily/2009/2009-10-26.parquet
  size:    187 KB
  rows:    5,849
  symbols: 3,475

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
2009-10-26	AAPL	Stock	7.2739	7.3839	7.1464	7.2314	484338400.0
2009-10-26	MSFT	Stock	28.13	29.02	28.11	28.68	124149700.0
2009-10-26	NVDA	Stock	0.3313	0.3362	0.3228	0.3245	481652000.0
2009-10-26	AMZN	Stock	5.9605	6.284	5.9245	6.232	645424000.0
2009-10-26	TLT	Stock	94.44	94.51	93.55	93.72	4128830.0
2009-10-26	ES	Stock	23.12	23.39	22.64	22.82	1354300.0
2009-10-26	CL	Stock	38.96	39.29	38.59	38.71	5445000.0
2009-10-26	A	Stock	18.7339	19.0987	18.3691	18.3906	4062169.0
2009-10-26	AABA-DELISTED	Stock	16.99	17.2	16.67	16.87	20313566.0
2009-10-26	AACC-DELISTED	Stock	7.01	7.12	6.9	6.96	48447.0
2009-10-26	AACG	Stock	5.45	5.5	5.25	5.3	22600.0
2009-10-26	AAI-DELISTED	Stock	4.82	4.88	4.61	4.66	4106755.0
2009-10-26	AAIC-DELISTED	Stock	13.85	13.86	12.5	13.09	229226.0
2009-10-26	AAME	Stock	1.48	1.48	1.25	1.26	13500.0
2009-10-26	AAON	Stock	3.761	3.842	3.7353	3.7393	345262.0
2009-10-26	AAP	Stock	36.63	37.24	36.46	36.61	2349500.0
2009-10-26	AATI-DELISTED	Stock	3.44	3.5	3.315	3.45	328293.0
2009-10-26	AAU-DELISTED	Stock	0.72	0.74	0.68	0.6901	215496.0
2009-10-26	AAUAF-DELISTED	Stock	0.72	0.74	0.68	0.6901	215696.0
2009-10-26	AAV-DELISTED	Stock	7.19	7.32	6.7	6.83	1396776.0
2009-10-26	AAWW-DELISTED	Stock	32.53	33.15	27.72	28.4	2143861.0
2009-10-26	AAXJ	Stock	54.8	55.08	53.85	54.03	119697.0
2009-10-26	AAXN-DELISTED	Stock	4.44	4.55	4.34	4.4	1081790.0
2009-10-26	AB	Stock	27.44	27.88	27.0	27.24	441700.0
2009-10-26	ABAX-DELISTED	Stock	25.75	26.1	25.19	25.34	193957.0
2009-10-26	ABB-DELISTED	Stock	21.21	21.45	20.6	20.74	3445794.0
2009-10-26	ABBC-DELISTED	Stock	7.19	7.25	6.87	6.99	44462.0
2009-10-26	ABBNY-DELISTED	Stock	21.21	21.45	20.6	20.71	3521823.0
2009-10-26	ABC-DELISTED	Stock	23.24	23.55	22.86	22.93	2669184.0
2009-10-26	ABCB	Stock	6.4884	6.6256	5.9396	5.9689	43260.0
2009-10-26	ABCO-DELISTED	Stock	12.613	12.898	12.47	12.602	51629.0
2009-10-26	ABCW-DELISTED	Stock	0.8972	0.9165	0.7814	0.82	162910.0
2009-10-26	ABD-DELISTED	Stock	7.11	7.54	6.61	6.7	423100.0
2009-10-26	ABE-DELISTED	Stock	17.2	17.3847	17.08	17.15	26090.0
2009-10-26	ABEO	Stock	4450.0	4487.5	4125.0	4125.0	19.0
2009-10-26	ABFS-DELISTED	Stock	27.26	27.99	26.66	26.89	405495.0
2009-10-26	ABG	Stock	14.33	14.75	13.65	13.7	278900.0
2009-10-26	ABII-DELISTED	Stock	35.45	35.61	35.0	35.08	44209.0
2009-10-26	ABK-DELISTED	Stock	1.22	1.23	1.11	1.13	9223546.0
2009-10-26	ABM	Stock	19.45	19.75	18.93	19.33	187900.0
2009-10-26	ABMD-DELISTED	Stock	10.14	10.36	9.97	10.0	180573.0
2009-10-26	ABR	Stock	2.41	2.43	2.25	2.28	193900.0
2009-10-26	ABT	Stock	24.6521	24.8153	24.2395	24.417	12666111.0
2009-10-26	ABTL-DELISTED	Stock	3.7987	4.4065	3.7481	3.9	27517.0
2009-10-26	ABV-DELISTED	Stock	96.63	96.72	93.9	94.5	557683.0
2009-10-26	ABVA-DELISTED	Stock	2.67	2.67	2.53	2.535	4423.0
2009-10-26	ABVT-DELISTED	Stock	49.86	50.64	49.86	50.54	155623.0
2009-10-26	ABX-DELISTED	Stock	37.58	38.2	36.05	36.23	13827947.0
2009-10-26	ACAD	Stock	1.57	1.62	1.5	1.5	647200.0
2009-10-26	ACAP-DELISTED	Stock	30.11	30.29	29.81	29.96	43258.0

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

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