PREVIEW / stock_daily / 2011-07-01

all stock daily files

  file:    by_date/stock_daily/2011/2011-07-01.parquet
  size:    197 KB
  rows:    6,078
  symbols: 3,515

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-07-01	AAPL	Stock	11.9982	12.2679	11.9357	12.2593	435313200.0
2011-07-01	MSFT	Stock	25.93	26.17	25.84	26.02	52906200.0
2011-07-01	NVDA	Stock	0.3985	0.4053	0.3905	0.4038	540804000.0
2011-07-01	AMZN	Stock	10.2775	10.5135	10.1805	10.4745	80174000.0
2011-07-01	TSLA	Stock	1.938	1.9733	1.92	1.9347	12823500.0
2011-07-01	TLT	Stock	94.13	94.23	93.365	93.63	6637186.0
2011-07-01	ES	Stock	35.22	35.74	35.14	35.72	1196500.0
2011-07-01	CL	Stock	43.66	44.305	43.575	44.235	4042400.0
2011-07-01	A	Stock	36.6452	37.289	36.4306	37.196	3925025.0
2011-07-01	AABA-DELISTED	Stock	15.07	15.5	15.02	15.46	16177353.0
2011-07-01	AACC-DELISTED	Stock	4.34	4.34	3.95	4.01	22795.0
2011-07-01	AACG	Stock	10.0	10.4	10.0	10.38	20100.0
2011-07-01	AAIC-DELISTED	Stock	31.41	31.59	31.37	31.48	51194.0
2011-07-01	AAME	Stock	1.97	2.05	1.97	2.05	3700.0
2011-07-01	AAON	Stock	6.4919	6.643	6.4504	6.5689	173813.0
2011-07-01	AAP	Stock	58.44	59.65	58.29	59.1	811200.0
2011-07-01	AAT	Stock	22.43	22.7	22.26	22.58	148900.0
2011-07-01	AATI-DELISTED	Stock	6.06	6.07	6.05	6.06	819506.0
2011-07-01	AAU-DELISTED	Stock	3.3	3.33	3.21	3.24	118147.0
2011-07-01	AAUAF-DELISTED	Stock	3.3	3.33	3.21	3.24	118347.0
2011-07-01	AAV-DELISTED	Stock	7.87	7.95	7.83	7.93	166313.0
2011-07-01	AAWW-DELISTED	Stock	59.45	61.2	59.04	60.83	94630.0
2011-07-01	AAXJ	Stock	61.91	62.81	61.91	62.7	156599.0
2011-07-01	AAXN-DELISTED	Stock	4.55	4.58	4.52	4.57	205871.0
2011-07-01	AB	Stock	19.43	19.58	19.18	19.56	405200.0
2011-07-01	ABAC-DELISTED	Stock	2.3	2.47	2.28	2.47	26538.0
2011-07-01	ABAX-DELISTED	Stock	27.3	27.79	26.89	27.77	269711.0
2011-07-01	ABB-DELISTED	Stock	25.73	26.17	25.66	26.1	2827809.0
2011-07-01	ABBC-DELISTED	Stock	10.43	10.65	10.43	10.57	70261.0
2011-07-01	ABBNY-DELISTED	Stock	25.73	26.17	25.66	26.08	2828765.0
2011-07-01	ABC-DELISTED	Stock	41.37	42.13	41.18	42.11	2988776.0
2011-07-01	ABCB	Stock	8.87	8.97	8.76	8.89	35900.0
2011-07-01	ABCD-DELISTED	Stock	3.39	3.39	3.35	3.35	36696.0
2011-07-01	ABCO-DELISTED	Stock	28.6	28.96	28.28	28.56	110136.0
2011-07-01	ABCW-DELISTED	Stock	0.73	0.7325	0.6999	0.7	17760.0
2011-07-01	ABD-DELISTED	Stock	7.875	8.145	7.855	8.115	307580.0
2011-07-01	ABE-DELISTED	Stock	18.89	19.0	18.89	19.0	5239.0
2011-07-01	ABEO	Stock	2500.0	2500.0	2500.0	2500.0	1.0
2011-07-01	ABFS-DELISTED	Stock	23.9	24.53	23.87	24.49	434044.0
2011-07-01	ABG	Stock	18.52	18.91	18.41	18.72	327000.0
2011-07-01	ABH-DELISTED	Stock	20.31	20.88	20.31	20.5	315897.0
2011-07-01	ABM	Stock	23.38	23.68	23.36	23.59	271900.0
2011-07-01	ABMD-DELISTED	Stock	16.22	16.83	15.95	16.75	214809.0
2011-07-01	ABR	Stock	4.67	4.8	4.65	4.79	26800.0
2011-07-01	ABT	Stock	25.2135	25.4774	25.1367	25.4774	11558566.0
2011-07-01	ABTL-DELISTED	Stock	5.5982	5.8973	5.5982	5.7518	24318.0
2011-07-01	ABUS	Stock	2.45	2.45	2.3	2.4	3700.0
2011-07-01	ABV-DELISTED	Stock	33.73	34.3789	33.4	34.3	2089999.0
2011-07-01	ABVT-DELISTED	Stock	70.68	71.1	69.56	69.94	272448.0
2011-07-01	ABX-DELISTED	Stock	45.1	45.25	44.25	44.78	4925097.0

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

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