PREVIEW / stock_daily / 2009-03-31

all stock daily files

  file:    by_date/stock_daily/2009/2009-03-31.parquet
  size:    176 KB
  rows:    5,777
  symbols: 3,449

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-03-31	AAPL	Stock	3.7661	3.8375	3.75	3.7543	570080000.0
2009-03-31	MSFT	Stock	17.83	18.79	17.78	18.37	92423300.0
2009-03-31	NVDA	Stock	0.2485	0.2525	0.2448	0.2465	805272000.0
2009-03-31	AMZN	Stock	3.6305	3.725	3.606	3.672	178364000.0
2009-03-31	TLT	Stock	105.04	105.8	105.0	105.71	1094525.0
2009-03-31	ES	Stock	21.77	21.91	21.51	21.59	3691800.0
2009-03-31	CL	Stock	29.53	29.895	29.29	29.49	5539200.0
2009-03-31	A	Stock	11.1016	11.2303	10.9227	10.9943	6620788.0
2009-03-31	AABA-DELISTED	Stock	12.74	13.04	12.67	12.85	11987942.0
2009-03-31	AACC-DELISTED	Stock	5.6	6.01	5.3	5.3	56434.0
2009-03-31	AACG	Stock	4.5	4.5	4.3	4.3	23000.0
2009-03-31	AAI-DELISTED	Stock	4.64	4.73	4.46	4.56	2571204.0
2009-03-31	AAIC-DELISTED	Stock	4.0	4.4	3.8	4.0	385420.0
2009-03-31	AAME	Stock	0.77	0.77	0.72	0.72	2400.0
2009-03-31	AAON	Stock	3.4291	3.6622	3.3719	3.5793	501187.0
2009-03-31	AAP	Stock	42.11	42.11	40.59	41.08	1865300.0
2009-03-31	AATI-DELISTED	Stock	3.65	3.66	3.45	3.59	530492.0
2009-03-31	AAU-DELISTED	Stock	0.7701	0.78	0.75	0.75	34091.0
2009-03-31	AAUAF-DELISTED	Stock	0.7701	0.78	0.75	0.75	34191.0
2009-03-31	AAV-DELISTED	Stock	2.5	2.52	2.41	2.43	562296.0
2009-03-31	AAWW-DELISTED	Stock	16.56	18.435	16.49	17.35	331918.0
2009-03-31	AAXJ	Stock	32.81	33.57	32.81	33.1	114094.0
2009-03-31	AAXN-DELISTED	Stock	4.43	4.96	4.39	4.68	695883.0
2009-03-31	AB	Stock	14.29	15.1	14.14	14.72	405600.0
2009-03-31	ABAX-DELISTED	Stock	17.57	18.11	17.16	17.24	564315.0
2009-03-31	ABB-DELISTED	Stock	13.95	14.23	13.8	13.96	4567774.0
2009-03-31	ABBC-DELISTED	Stock	8.42	8.42	7.4007	8.2	294645.0
2009-03-31	ABBNY-DELISTED	Stock	13.95	14.23	13.8	13.94	4572744.0
2009-03-31	ABC-DELISTED	Stock	16.27	16.73	16.08	16.34	4683690.0
2009-03-31	ABCB	Stock	5.4273	5.4273	4.5228	4.5812	39172.0
2009-03-31	ABCO-DELISTED	Stock	8.463	8.553	8.102	8.287	107204.0
2009-03-31	ABCW-DELISTED	Stock	1.31	1.43	1.26	1.35	272730.0
2009-03-31	ABD-DELISTED	Stock	1.18	1.21	0.98	0.98	429660.0
2009-03-31	ABE-DELISTED	Stock	11.43	12.35	11.43	12.23	17603.0
2009-03-31	ABEO	Stock	1950.0	2062.5	1937.5	2062.5	4.0
2009-03-31	ABFS-DELISTED	Stock	19.38	19.49	18.56	19.01	623298.0
2009-03-31	ABG	Stock	4.59	4.67	4.08	4.31	202400.0
2009-03-31	ABII-DELISTED	Stock	46.4	49.88	44.08	47.28	26123.0
2009-03-31	ABK-DELISTED	Stock	0.76	0.79	0.7296	0.7703	4172859.0
2009-03-31	ABM	Stock	16.31	16.82	16.13	16.4	314000.0
2009-03-31	ABMD-DELISTED	Stock	5.26	5.4	4.85	4.89	598206.0
2009-03-31	ABR	Stock	0.77	0.82	0.7	0.72	269000.0
2009-03-31	ABT	Stock	23.1551	23.4142	22.8529	22.8865	21521259.0
2009-03-31	ABTL-DELISTED	Stock	1.1571	1.35	1.1571	1.35	32409.0
2009-03-31	ABV-DELISTED	Stock	47.64	48.91	47.29	47.57	785180.0
2009-03-31	ABVT-DELISTED	Stock	44.0	45.0	44.0	45.0	94820.0
2009-03-31	ABX-DELISTED	Stock	32.85	33.31	31.93	32.39	9694752.0
2009-03-31	ACAD	Stock	1.07	1.11	0.95	0.95	212900.0
2009-03-31	ACAP-DELISTED	Stock	41.76	42.61	40.44	41.04	84535.0
2009-03-31	ACAS-DELISTED	Stock	1.97	2.0	1.84	1.87	4215667.0

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

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