PREVIEW / stock_daily / 2009-04-28

all stock daily files

  file:    by_date/stock_daily/2009/2009-04-28.parquet
  size:    177 KB
  rows:    5,716
  symbols: 3,413

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-04-28	AAPL	Stock	4.4054	4.5075	4.4021	4.425	455856800.0
2009-04-28	MSFT	Stock	20.25	20.27	19.79	19.93	76685200.0
2009-04-28	NVDA	Stock	0.272	0.282	0.2695	0.2763	634392000.0
2009-04-28	AMZN	Stock	4.134	4.2675	4.12	4.12	158480000.0
2009-04-28	TLT	Stock	101.5	101.58	99.09	99.35	2332548.0
2009-04-28	ES	Stock	20.62	20.94	20.51	20.55	1878500.0
2009-04-28	CL	Stock	29.62	29.845	29.315	29.49	4782200.0
2009-04-28	A	Stock	11.9599	12.3748	11.7668	12.1888	4938854.0
2009-04-28	AABA-DELISTED	Stock	13.74	14.05	13.6	13.64	18441732.0
2009-04-28	AACC-DELISTED	Stock	6.0	6.26	6.0	6.17	11308.0
2009-04-28	AACG	Stock	4.06	4.35	4.06	4.35	19200.0
2009-04-28	AAI-DELISTED	Stock	6.79	6.99	6.32	6.41	5958490.0
2009-04-28	AAIC-DELISTED	Stock	5.2	5.6	5.2	5.6	242884.0
2009-04-28	AAME	Stock	0.73	0.74	0.66	0.66	2200.0
2009-04-28	AAON	Stock	3.5872	3.8025	3.5694	3.7156	481444.0
2009-04-28	AAP	Stock	42.35	44.0	42.1	43.48	1849000.0
2009-04-28	AATI-DELISTED	Stock	4.76	4.93	4.63	4.65	484315.0
2009-04-28	AAU-DELISTED	Stock	0.67	0.69	0.64	0.67	83747.0
2009-04-28	AAUAF-DELISTED	Stock	0.67	0.69	0.64	0.67	84247.0
2009-04-28	AAV-DELISTED	Stock	2.74	2.7401	2.66	2.66	414937.0
2009-04-28	AAWW-DELISTED	Stock	23.48	25.06	23.38	24.34	349949.0
2009-04-28	AAXJ	Stock	35.79	36.33	35.51	36.07	156966.0
2009-04-28	AAXN-DELISTED	Stock	4.72	4.85	4.63	4.72	534446.0
2009-04-28	AB	Stock	15.62	15.7	15.13	15.31	700300.0
2009-04-28	ABAX-DELISTED	Stock	14.64	15.32	14.64	14.86	254377.0
2009-04-28	ABB-DELISTED	Stock	13.77	14.23	13.71	14.08	3530775.0
2009-04-28	ABBC-DELISTED	Stock	8.7	9.04	8.7	8.94	32612.0
2009-04-28	ABBNY-DELISTED	Stock	13.77	14.23	13.71	14.06	3650975.0
2009-04-28	ABC-DELISTED	Stock	17.6	17.662	17.28	17.43	3390680.0
2009-04-28	ABCB	Stock	5.583	6.1666	5.583	6.0596	10178.0
2009-04-28	ABCO-DELISTED	Stock	8.135	8.255	8.085	8.17	221634.0
2009-04-28	ABCW-DELISTED	Stock	1.59	1.83	1.5	1.52	97380.0
2009-04-28	ABD-DELISTED	Stock	1.78	2.0317	1.75	1.99	185700.0
2009-04-28	ABE-DELISTED	Stock	12.69	13.1199	12.69	13.07	9000.0
2009-04-28	ABEO	Stock	1575.0	1687.5	1437.5	1687.5	3.0
2009-04-28	ABFS-DELISTED	Stock	20.45	21.7	20.19	21.21	404181.0
2009-04-28	ABG	Stock	7.45	8.44	7.14	7.91	423700.0
2009-04-28	ABII-DELISTED	Stock	47.77	47.77	44.6156	45.07	16519.0
2009-04-28	ABK-DELISTED	Stock	0.95	0.96	0.89	0.91	4650707.0
2009-04-28	ABM	Stock	16.93	17.48	16.84	17.22	146100.0
2009-04-28	ABMD-DELISTED	Stock	5.8	6.08	5.75	5.98	309043.0
2009-04-28	ABR	Stock	1.63	1.9	1.55	1.9	351200.0
2009-04-28	ABT	Stock	20.6554	20.8281	20.5834	20.6362	14471863.0
2009-04-28	ABTL-DELISTED	Stock	2.6	2.6	2.43	2.55	139609.0
2009-04-28	ABV-DELISTED	Stock	52.47	54.71	52.0	54.42	654910.0
2009-04-28	ABVA-DELISTED	Stock	2.1	2.1	2.0294	2.1	3050.0
2009-04-28	ABX-DELISTED	Stock	29.13	29.54	28.58	28.93	7255592.0
2009-04-28	ACAD	Stock	0.91	0.99	0.89	0.94	110100.0
2009-04-28	ACAP-DELISTED	Stock	40.82	42.43	40.82	41.26	53932.0
2009-04-28	ACAS-DELISTED	Stock	2.62	2.7	2.54	2.65	1530959.0

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

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