PREVIEW / stock_daily / 2009-06-09

all stock daily files

  file:    by_date/stock_daily/2009/2009-06-09.parquet
  size:    182 KB
  rows:    5,809
  symbols: 3,463

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-06-09	AAPL	Stock	5.1361	5.1629	5.0196	5.0971	676964400.0
2009-06-09	MSFT	Stock	22.06	22.32	21.88	22.08	50887700.0
2009-06-09	NVDA	Stock	0.273	0.287	0.271	0.284	725032000.0
2009-06-09	AMZN	Stock	4.3465	4.3835	4.3085	4.354	89502000.0
2009-06-09	TLT	Stock	90.19	90.31	89.25	89.6	6046596.0
2009-06-09	ES	Stock	21.14	21.27	20.8	20.88	1320500.0
2009-06-09	CL	Stock	35.445	35.45	34.985	35.085	6111000.0
2009-06-09	A	Stock	14.1345	14.1989	13.927	14.1059	4124100.0
2009-06-09	AABA-DELISTED	Stock	16.23	16.48	16.18	16.39	12935227.0
2009-06-09	AACC-DELISTED	Stock	9.07	9.14	8.88	8.9	19457.0
2009-06-09	AACG	Stock	6.6	6.96	6.58	6.95	28600.0
2009-06-09	AAI-DELISTED	Stock	5.89	6.07	5.75	6.03	2617958.0
2009-06-09	AAIC-DELISTED	Stock	9.2	9.2	8.8	8.8	1456656.0
2009-06-09	AAME	Stock	0.75	0.75	0.74	0.74	5800.0
2009-06-09	AAON	Stock	4.2469	4.2469	4.1027	4.1323	236419.0
2009-06-09	AAP	Stock	44.06	44.6	43.62	44.35	1278000.0
2009-06-09	AATI-DELISTED	Stock	4.52	4.7	4.52	4.56	128412.0
2009-06-09	AAU-DELISTED	Stock	0.747	0.78	0.747	0.75	64684.0
2009-06-09	AAUAF-DELISTED	Stock	0.745	0.78	0.745	0.75	65295.0
2009-06-09	AAV-DELISTED	Stock	4.92	5.15	4.79	5.07	1667039.0
2009-06-09	AAWW-DELISTED	Stock	24.49	25.31	24.4601	24.99	175788.0
2009-06-09	AAXJ	Stock	44.94	45.25	44.62	45.02	419855.0
2009-06-09	AAXN-DELISTED	Stock	4.53	4.56	4.46	4.49	238131.0
2009-06-09	AB	Stock	21.19	21.94	21.11	21.84	356400.0
2009-06-09	ABAX-DELISTED	Stock	17.69	17.8799	17.4701	17.53	121937.0
2009-06-09	ABB-DELISTED	Stock	16.19	16.51	16.16	16.42	2183990.0
2009-06-09	ABBC-DELISTED	Stock	9.105	9.14	8.95	8.95	25133.0
2009-06-09	ABBNY-DELISTED	Stock	16.19	16.51	16.16	16.4	2187190.0
2009-06-09	ABC-DELISTED	Stock	18.27	18.28	17.8	17.87	2584222.0
2009-06-09	ABCB	Stock	7.2948	7.2948	6.4389	6.4486	16861.0
2009-06-09	ABCO-DELISTED	Stock	12.625	12.795	12.56	12.565	147663.0
2009-06-09	ABCW-DELISTED	Stock	1.59	1.59	1.41	1.43	134170.0
2009-06-09	ABD-DELISTED	Stock	3.25	3.31	3.21	3.29	152250.0
2009-06-09	ABE-DELISTED	Stock	15.49	15.65	15.47	15.52	12641.0
2009-06-09	ABEO	Stock	2650.0	2812.5	2500.0	2687.5	17.0
2009-06-09	ABFS-DELISTED	Stock	28.78	30.83	28.42	30.64	1090616.0
2009-06-09	ABG	Stock	11.26	12.25	11.26	11.84	361900.0
2009-06-09	ABII-DELISTED	Stock	43.5	43.5	42.49	43.0	24855.0
2009-06-09	ABK-DELISTED	Stock	1.31	1.31	1.27	1.28	3204956.0
2009-06-09	ABM	Stock	19.16	19.32	18.71	18.8	192300.0
2009-06-09	ABMD-DELISTED	Stock	7.51	7.73	7.48	7.61	293611.0
2009-06-09	ABR	Stock	1.76	1.76	1.65	1.68	135200.0
2009-06-09	ABT	Stock	21.5526	21.567	21.2791	21.2791	9975198.0
2009-06-09	ABTL-DELISTED	Stock	2.1056	2.1444	2.0946	2.1444	27512.0
2009-06-09	ABV-DELISTED	Stock	66.33	66.62	65.53	65.62	442817.0
2009-06-09	ABVA-DELISTED	Stock	2.98	2.98	2.95	2.95	1201.0
2009-06-09	ABVT-DELISTED	Stock	80.0	82.41	80.0	82.41	100920.0
2009-06-09	ABX-DELISTED	Stock	37.15	37.23	36.02	36.15	8043076.0
2009-06-09	ACAD	Stock	2.36	2.5	2.27	2.28	194600.0
2009-06-09	ACAP-DELISTED	Stock	42.11	42.795	41.44	41.56	18397.0

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

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