PREVIEW / stock_daily / 2009-03-09

all stock daily files

  file:    by_date/stock_daily/2009/2009-03-09.parquet
  size:    172 KB
  rows:    5,756
  symbols: 3,441

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-09	AAPL	Stock	3.0064	3.1286	2.9489	2.9682	698297600.0
2009-03-09	MSFT	Stock	15.2	15.74	15.1	15.15	66479100.0
2009-03-09	NVDA	Stock	0.2082	0.224	0.207	0.2075	682768000.0
2009-03-09	AMZN	Stock	3.11	3.2015	3.0075	3.0245	271228000.0
2009-03-09	TLT	Stock	104.51	104.55	103.12	103.65	2070419.0
2009-03-09	ES	Stock	19.95	20.14	19.34	19.45	1570400.0
2009-03-09	CL	Stock	27.735	27.905	27.255	27.525	8615000.0
2009-03-09	A	Stock	8.9413	9.2847	8.834	8.8984	6017551.0
2009-03-09	AABA-DELISTED	Stock	12.84	13.45	12.55	12.66	22867276.0
2009-03-09	AACC-DELISTED	Stock	3.45	3.52	3.29	3.41	26325.0
2009-03-09	AACG	Stock	4.86	5.31	4.86	5.21	31100.0
2009-03-09	AAI-DELISTED	Stock	2.63	3.59	2.52	3.03	3380119.0
2009-03-09	AAIC-DELISTED	Stock	2.8	2.8	2.226	2.4	190210.0
2009-03-09	AAON	Stock	2.9906	3.0775	2.9017	3.0242	783169.0
2009-03-09	AAP	Stock	36.22	37.67	35.77	36.01	1860000.0
2009-03-09	AATI-DELISTED	Stock	2.87	3.0	2.66	2.69	257924.0
2009-03-09	AAU-DELISTED	Stock	0.75	0.77	0.7	0.7	57677.0
2009-03-09	AAUAF-DELISTED	Stock	0.75	0.77	0.7	0.7	57777.0
2009-03-09	AAV-DELISTED	Stock	2.15	2.155	1.96	1.96	1090653.0
2009-03-09	AAWW-DELISTED	Stock	10.6	11.41	9.84	10.05	337444.0
2009-03-09	AAXJ	Stock	27.57	28.17	27.5	27.594	29172.0
2009-03-09	AAXN-DELISTED	Stock	3.51	3.83	3.51	3.7	541702.0
2009-03-09	AB	Stock	10.5	10.92	10.12	10.27	767200.0
2009-03-09	ABAX-DELISTED	Stock	15.94	16.61	15.57	16.1	177219.0
2009-03-09	ABB-DELISTED	Stock	11.3	11.85	11.3	11.49	5764093.0
2009-03-09	ABBC-DELISTED	Stock	6.7766	6.7766	6.38	6.44	63532.0
2009-03-09	ABBNY-DELISTED	Stock	11.3	11.85	11.3	11.49	5764093.0
2009-03-09	ABC-DELISTED	Stock	15.2	15.33	14.98	15.1	3477442.0
2009-03-09	ABCB	Stock	3.803	4.3866	3.3556	3.696	25600.0
2009-03-09	ABCO-DELISTED	Stock	7.068	7.068	6.7274	6.7524	220226.0
2009-03-09	ABCW-DELISTED	Stock	0.5	0.5	0.42	0.42	198730.0
2009-03-09	ABD-DELISTED	Stock	1.09	1.3	1.09	1.23	276390.0
2009-03-09	ABE-DELISTED	Stock	10.54	10.9	10.0	10.28	165866.0
2009-03-09	ABEO	Stock	1437.5	1812.5	1437.5	1437.5	8.0
2009-03-09	ABFS-DELISTED	Stock	16.92	17.58	16.54	16.72	422756.0
2009-03-09	ABG	Stock	2.38	2.46	2.0	2.02	267200.0
2009-03-09	ABII-DELISTED	Stock	60.95	60.95	53.78	55.4	24093.0
2009-03-09	ABK-DELISTED	Stock	0.35	0.42	0.35	0.3999	6010345.0
2009-03-09	ABM	Stock	13.51	14.15	13.37	13.51	429800.0
2009-03-09	ABMD-DELISTED	Stock	4.96	5.2	4.9	5.12	448590.0
2009-03-09	ABR	Stock	0.58	0.64	0.58	0.62	124400.0
2009-03-09	ABT	Stock	22.2867	22.7041	22.1284	22.3827	20769070.0
2009-03-09	ABTL-DELISTED	Stock	1.4003	1.5003	1.2002	1.2497	15724.0
2009-03-09	ABV-DELISTED	Stock	40.35	41.48	39.5	39.97	622941.0
2009-03-09	ABX-DELISTED	Stock	28.38	28.53	27.41	27.92	11621409.0
2009-03-09	ACAD	Stock	0.77	0.83	0.77	0.81	47400.0
2009-03-09	ACAP-DELISTED	Stock	39.1	40.49	38.46	38.82	63108.0
2009-03-09	ACAS-DELISTED	Stock	0.61	0.6799	0.61	0.6252	4222530.0
2009-03-09	ACAT-DELISTED	Stock	2.46	3.0275	2.45	2.62	69456.0
2009-03-09	ACC-DELISTED	Stock	15.35	15.98	15.0801	15.93	1266843.0

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

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