PREVIEW / stock_daily / 2009-07-14

all stock daily files

  file:    by_date/stock_daily/2009/2009-07-14.parquet
  size:    180 KB
  rows:    5,759
  symbols: 3,439

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-07-14	AAPL	Stock	5.0725	5.1136	5.0414	5.0811	347247600.0
2009-07-14	MSFT	Stock	23.2	23.22	22.86	23.11	45448700.0
2009-07-14	NVDA	Stock	0.2643	0.2688	0.2612	0.2678	452568000.0
2009-07-14	AMZN	Stock	4.074	4.121	4.021	4.0975	90872000.0
2009-07-14	TLT	Stock	94.76	95.13	93.7	94.1	3629073.0
2009-07-14	ES	Stock	21.58	21.61	21.32	21.54	1341900.0
2009-07-14	CL	Stock	36.505	36.68	36.335	36.67	3790600.0
2009-07-14	A	Stock	13.7697	14.02	13.7697	13.9413	2331864.0
2009-07-14	AABA-DELISTED	Stock	15.07	15.22	14.98	15.19	12648968.0
2009-07-14	AACC-DELISTED	Stock	7.78	7.85	7.64	7.68	28730.0
2009-07-14	AACG	Stock	7.76	8.27	7.75	7.8	10800.0
2009-07-14	AAI-DELISTED	Stock	6.25	6.46	6.14	6.43	2001409.0
2009-07-14	AAIC-DELISTED	Stock	7.0	9.0	6.8	8.8	15197226.0
2009-07-14	AAME	Stock	0.82	0.82	0.78	0.78	500.0
2009-07-14	AAON	Stock	3.8914	4.0296	3.8914	4.0138	247050.0
2009-07-14	AAP	Stock	44.83	45.0	44.0	44.39	1652200.0
2009-07-14	AATI-DELISTED	Stock	4.3	4.44	4.27	4.38	87251.0
2009-07-14	AAU-DELISTED	Stock	0.62	0.63	0.5878	0.61	42060.0
2009-07-14	AAUAF-DELISTED	Stock	0.62	0.63	0.5878	0.61	45060.0
2009-07-14	AAV-DELISTED	Stock	4.39	4.79	4.39	4.78	1261876.0
2009-07-14	AAWW-DELISTED	Stock	20.83	21.51	20.83	21.36	205062.0
2009-07-14	AAXJ	Stock	43.59	43.99	43.43	43.99	142626.0
2009-07-14	AAXN-DELISTED	Stock	4.45	4.75	4.45	4.73	462695.0
2009-07-14	AB	Stock	18.87	19.51	18.57	19.47	777100.0
2009-07-14	ABAX-DELISTED	Stock	18.91	19.33	18.91	19.09	85996.0
2009-07-14	ABB-DELISTED	Stock	15.46	15.61	15.25	15.47	2258953.0
2009-07-14	ABBC-DELISTED	Stock	8.01	8.28	8.01	8.15	34809.0
2009-07-14	ABBNY-DELISTED	Stock	15.46	15.61	15.25	15.49	2260953.0
2009-07-14	ABC-DELISTED	Stock	18.07	18.29	17.97	18.24	2595279.0
2009-07-14	ABCB	Stock	6.4292	6.4584	5.9817	6.0791	11001.0
2009-07-14	ABCO-DELISTED	Stock	11.727	11.757	11.468	11.688	106144.0
2009-07-14	ABCW-DELISTED	Stock	1.1	1.15	1.09	1.12	38020.0
2009-07-14	ABD-DELISTED	Stock	2.4	2.5303	2.4	2.46	214780.0
2009-07-14	ABE-DELISTED	Stock	14.84	15.01	14.57	14.57	8584.0
2009-07-14	ABEO	Stock	2500.0	2500.0	2187.5	2312.5	11.0
2009-07-14	ABFS-DELISTED	Stock	28.35	28.5	27.11	27.25	845795.0
2009-07-14	ABG	Stock	10.21	10.44	9.98	10.37	192000.0
2009-07-14	ABII-DELISTED	Stock	31.7	31.7	29.87	30.85	56971.0
2009-07-14	ABK-DELISTED	Stock	0.86	1.02	0.8315	0.94	9164628.0
2009-07-14	ABM	Stock	17.28	17.75	17.06	17.66	163100.0
2009-07-14	ABMD-DELISTED	Stock	7.89	8.01	7.83	7.85	227868.0
2009-07-14	ABR	Stock	1.5	1.66	1.5	1.56	209500.0
2009-07-14	ABT	Stock	22.2963	22.4642	22.0564	22.3059	16593372.0
2009-07-14	ABTL-DELISTED	Stock	2.15	2.3	2.15	2.3	21274.0
2009-07-14	ABV-DELISTED	Stock	64.67	64.67	63.7	64.43	343757.0
2009-07-14	ABVT-DELISTED	Stock	71.93	74.18	71.93	74.0	47182.0
2009-07-14	ABX-DELISTED	Stock	32.64	32.99	32.36	32.87	7153869.0
2009-07-14	ACAD	Stock	2.07	2.14	1.98	2.06	99200.0
2009-07-14	ACAP-DELISTED	Stock	38.72	39.1	38.33	38.52	20500.0
2009-07-14	ACAS-DELISTED	Stock	2.95	2.95	2.82	2.86	1323998.0

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

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