PREVIEW / stock_daily / 2009-04-09

all stock daily files

  file:    by_date/stock_daily/2009/2009-04-09.parquet
  size:    179 KB
  rows:    5,802
  symbols: 3,469

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-09	AAPL	Stock	4.2293	4.2857	4.2129	4.2704	530756800.0
2009-04-09	MSFT	Stock	19.45	19.7	19.22	19.67	55759600.0
2009-04-09	NVDA	Stock	0.2925	0.302	0.2902	0.301	904412000.0
2009-04-09	AMZN	Stock	3.8755	4.0	3.863	3.9885	141646000.0
2009-04-09	TLT	Stock	102.47	103.18	101.98	102.35	1088784.0
2009-04-09	ES	Stock	21.78	22.57	21.25	21.5	1434900.0
2009-04-09	CL	Stock	30.42	30.64	29.43	29.9	8280600.0
2009-04-09	A	Stock	11.7525	12.2532	11.7525	12.1602	4545178.0
2009-04-09	AABA-DELISTED	Stock	13.14	13.5888	13.07	13.47	16430324.0
2009-04-09	AACC-DELISTED	Stock	6.66	7.51	6.66	7.26	71023.0
2009-04-09	AACG	Stock	4.5	4.5	4.21	4.29	12300.0
2009-04-09	AAI-DELISTED	Stock	5.16	5.48	5.13	5.43	1823330.0
2009-04-09	AAIC-DELISTED	Stock	6.8	7.2	6.4	7.2	873412.0
2009-04-09	AAME	Stock	0.6	0.6	0.6	0.6	1000.0
2009-04-09	AAON	Stock	3.4588	3.5378	3.358	3.516	367537.0
2009-04-09	AAP	Stock	41.32	42.5	41.32	42.29	2094600.0
2009-04-09	AATI-DELISTED	Stock	4.1	4.34	4.01	4.15	289495.0
2009-04-09	AAU-DELISTED	Stock	0.64	0.65	0.62	0.6399	72246.0
2009-04-09	AAUAF-DELISTED	Stock	0.64	0.65	0.62	0.6399	74647.0
2009-04-09	AAV-DELISTED	Stock	2.61	2.9	2.57	2.75	1353385.0
2009-04-09	AAWW-DELISTED	Stock	18.74	21.26	18.27	21.05	489630.0
2009-04-09	AAXJ	Stock	36.89	37.02	36.21	36.84	63129.0
2009-04-09	AAXN-DELISTED	Stock	4.92	5.3	4.85	5.23	813942.0
2009-04-09	AB	Stock	17.45	19.61	17.29	18.8	1426800.0
2009-04-09	ABAX-DELISTED	Stock	16.16	16.47	15.9	16.05	459980.0
2009-04-09	ABB-DELISTED	Stock	14.75	15.06	14.63	15.01	4495591.0
2009-04-09	ABBC-DELISTED	Stock	8.8	8.92	8.8	8.9	72681.0
2009-04-09	ABBNY-DELISTED	Stock	14.75	15.06	14.63	15.01	4499291.0
2009-04-09	ABC-DELISTED	Stock	16.53	16.7	16.4	16.5	3182214.0
2009-04-09	ABCB	Stock	6.186	6.8766	5.5927	6.8766	40405.0
2009-04-09	ABCO-DELISTED	Stock	8.646	9.404	8.479	9.184	156474.0
2009-04-09	ABCW-DELISTED	Stock	1.56	1.66	1.43	1.47	200410.0
2009-04-09	ABD-DELISTED	Stock	1.331	1.3513	1.2598	1.27	364430.0
2009-04-09	ABE-DELISTED	Stock	12.89	13.03	12.75	12.96	16779.0
2009-04-09	ABEO	Stock	2012.5	2112.5	2012.5	2012.5	7.0
2009-04-09	ABFS-DELISTED	Stock	19.76	21.81	19.75	21.65	1045214.0
2009-04-09	ABG	Stock	5.59	5.98	5.55	5.8	1094200.0
2009-04-09	ABII-DELISTED	Stock	45.4209	45.4209	43.855	45.13	9936.0
2009-04-09	ABK-DELISTED	Stock	1.0	1.03	0.92	0.9697	12161932.0
2009-04-09	ABM	Stock	17.01	17.56	16.81	17.42	436000.0
2009-04-09	ABMD-DELISTED	Stock	5.4	5.92	5.34	5.82	623181.0
2009-04-09	ABR	Stock	0.84	1.0	0.83	1.0	214800.0
2009-04-09	ABT	Stock	21.3319	21.3319	20.5642	21.1256	31234681.0
2009-04-09	ABTL-DELISTED	Stock	1.374	1.3745	1.262	1.35	1098.0
2009-04-09	ABV-DELISTED	Stock	51.19	52.72	50.73	51.96	1064989.0
2009-04-09	ABVA-DELISTED	Stock	1.9	1.9	1.9	1.9	500.0
2009-04-09	ABVT-DELISTED	Stock	49.0	49.0	48.5	48.5	500.0
2009-04-09	ABX-DELISTED	Stock	28.99	29.03	28.39	28.51	9172653.0
2009-04-09	ACAD	Stock	1.14	1.15	1.04	1.1	609800.0
2009-04-09	ACAP-DELISTED	Stock	42.54	42.54	41.422	41.87	46842.0

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

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