PREVIEW / stock_daily / 2011-06-29

all stock daily files

  file:    by_date/stock_daily/2011/2011-06-29.parquet
  size:    198 KB
  rows:    6,126
  symbols: 3,564

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
2011-06-29	AAPL	Stock	12.0014	12.0132	11.8529	11.93	352545200.0
2011-06-29	MSFT	Stock	25.71	25.71	25.36	25.62	66051000.0
2011-06-29	NVDA	Stock	0.39	0.3975	0.3765	0.3935	960544000.0
2011-06-29	AMZN	Stock	10.1335	10.3125	10.0515	10.209	92178000.0
2011-06-29	TSLA	Stock	1.9	1.9393	1.8713	1.886	21927000.0
2011-06-29	TLT	Stock	94.95	95.1986	94.02	94.25	11084827.0
2011-06-29	ES	Stock	35.41	35.44	35.15	35.19	1954800.0
2011-06-29	CL	Stock	43.03	43.455	42.995	43.37	4652800.0
2011-06-29	A	Stock	36.3305	36.5808	36.03	36.1874	4879439.0
2011-06-29	AABA-DELISTED	Stock	14.96	15.05	14.68	14.88	25246538.0
2011-06-29	AACC-DELISTED	Stock	3.88	4.024	3.74	3.88	27896.0
2011-06-29	AACG	Stock	9.39	9.75	9.29	9.75	12100.0
2011-06-29	AAIC-DELISTED	Stock	32.37	32.45	32.0001	32.05	140292.0
2011-06-29	AAME	Stock	2.1	2.1	2.08	2.09	1000.0
2011-06-29	AAON	Stock	6.5689	6.8978	6.4296	6.5156	148163.0
2011-06-29	AAP	Stock	58.23	58.25	57.45	57.67	961500.0
2011-06-29	AAT	Stock	22.3	22.59	22.15	22.53	58700.0
2011-06-29	AATI-DELISTED	Stock	6.05	6.05	6.04	6.04	86838.0
2011-06-29	AAU-DELISTED	Stock	3.28	3.4237	3.26	3.35	231004.0
2011-06-29	AAUAF-DELISTED	Stock	3.28	3.4237	3.26	3.35	231559.0
2011-06-29	AAV-DELISTED	Stock	7.9	8.1	7.83	7.96	255280.0
2011-06-29	AAWW-DELISTED	Stock	59.72	59.8338	58.64	59.09	72388.0
2011-06-29	AAXJ	Stock	60.81	61.2	60.61	61.05	330971.0
2011-06-29	AAXN-DELISTED	Stock	4.45	4.5	4.44	4.48	163050.0
2011-06-29	AB	Stock	19.16	19.6	19.09	19.55	305800.0
2011-06-29	ABAC-DELISTED	Stock	2.4	2.4	2.28	2.36	21250.0
2011-06-29	ABAX-DELISTED	Stock	28.3	28.48	27.61	27.68	66293.0
2011-06-29	ABB-DELISTED	Stock	25.47	25.75	25.29	25.6	2859615.0
2011-06-29	ABBC-DELISTED	Stock	10.14	10.4	10.14	10.35	167396.0
2011-06-29	ABBNY-DELISTED	Stock	25.47	25.75	25.29	25.62	2900109.0
2011-06-29	ABC-DELISTED	Stock	41.6	41.61	41.07	41.12	2817641.0
2011-06-29	ABCB	Stock	8.9	8.96	8.73	8.81	52000.0
2011-06-29	ABCD-DELISTED	Stock	3.35	3.4	3.32	3.4	136197.0
2011-06-29	ABCO-DELISTED	Stock	28.99	29.7	28.47	28.7	134512.0
2011-06-29	ABCW-DELISTED	Stock	0.74	0.75	0.71	0.74	8770.0
2011-06-29	ABD-DELISTED	Stock	7.64	7.75	7.57	7.71	148540.0
2011-06-29	ABE-DELISTED	Stock	18.59	18.7101	18.55	18.65	9180.0
2011-06-29	ABFS-DELISTED	Stock	23.45	23.6	23.35	23.45	237121.0
2011-06-29	ABG	Stock	18.65	18.91	18.18	18.4	293800.0
2011-06-29	ABH-DELISTED	Stock	20.32	20.38	19.41	20.06	3034543.0
2011-06-29	ABM	Stock	23.23	23.57	23.04	23.46	458700.0
2011-06-29	ABMD-DELISTED	Stock	15.6	16.5	15.6	16.04	502130.0
2011-06-29	ABR	Stock	4.71	4.79	4.68	4.68	44200.0
2011-06-29	ABT	Stock	25.0935	25.1031	24.94	25.0264	11291163.0
2011-06-29	ABTL-DELISTED	Stock	5.35	5.8505	5.3	5.65	61936.0
2011-06-29	ABUS	Stock	2.5	2.65	2.5	2.6	14100.0
2011-06-29	ABV-DELISTED	Stock	33.06	33.69	32.8	33.47	2653050.0
2011-06-29	ABVA-DELISTED	Stock	4.83	4.99	4.82	4.95	8993.0
2011-06-29	ABVT-DELISTED	Stock	69.78	70.0	68.69	69.1	196827.0
2011-06-29	ABX-DELISTED	Stock	44.51	45.71	44.25	45.07	7194154.0

> showing 50 of 6,126 rows — these rows as CSV

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