PREVIEW / stock_daily / 2012-08-22

all stock daily files

  file:    by_date/stock_daily/2012/2012-08-22.parquet
  size:    198 KB
  rows:    6,122
  symbols: 3,480

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
2012-08-22	AAPL	Stock	23.3721	23.8929	23.1468	23.8882	565322800.0
2012-08-22	MSFT	Stock	30.59	30.76	30.47	30.54	33437400.0
2012-08-22	NVDA	Stock	0.363	0.3675	0.3618	0.366	313556000.0
2012-08-22	AMZN	Stock	11.97	12.245	11.94	12.155	49474000.0
2012-08-22	META	Stock	19.36	19.53	18.96	19.44	49892200.0
2012-08-22	TSLA	Stock	1.934	2.0027	1.934	1.9967	11632500.0
2012-08-22	TLT	Stock	123.52	124.51	123.21	124.41	11384322.0
2012-08-22	ES	Stock	38.0	38.26	37.98	38.17	935100.0
2012-08-22	CL	Stock	52.66	52.865	52.5	52.685	1870600.0
2012-08-22	A	Stock	26.5021	26.8097	26.3162	26.7954	6128273.0
2012-08-22	AABA-DELISTED	Stock	14.96	14.99	14.86	14.91	9141508.0
2012-08-22	AACC-DELISTED	Stock	6.42	6.42	6.11	6.36	28750.0
2012-08-22	AACG	Stock	4.1	4.39	4.03	4.39	19100.0
2012-08-22	AAIC-DELISTED	Stock	22.92	22.98	22.81	22.87	22519.0
2012-08-22	AAME	Stock	2.63	2.7	2.57	2.65	36600.0
2012-08-22	AAMRQ-DELISTED	Stock	0.495	0.503	0.49	0.493	605690.0
2012-08-22	AAON	Stock	5.7748	5.7748	5.6148	5.6207	162675.0
2012-08-22	AAP	Stock	72.01	72.42	71.9	72.2	594200.0
2012-08-22	AAT	Stock	27.14	27.29	26.85	27.18	126200.0
2012-08-22	AAU-DELISTED	Stock	2.26	2.43	2.2	2.43	191365.0
2012-08-22	AAUAF-DELISTED	Stock	2.26	2.43	2.2	2.43	191665.0
2012-08-22	AAV-DELISTED	Stock	3.27	3.3	3.23	3.29	95972.0
2012-08-22	AAWW-DELISTED	Stock	52.08	53.34	51.7	52.775	165018.0
2012-08-22	AAXJ	Stock	53.99	54.28	53.82	54.2	242262.0
2012-08-22	AAXN-DELISTED	Stock	5.5	5.51	5.37	5.43	261041.0
2012-08-22	AB	Stock	12.9	12.96	12.76	12.81	301800.0
2012-08-22	ABAC-DELISTED	Stock	1.19	1.2	1.13	1.2	7300.0
2012-08-22	ABAX-DELISTED	Stock	38.56	38.96	38.292	38.47	37797.0
2012-08-22	ABB-DELISTED	Stock	17.47	17.765	17.4532	17.73	1912327.0
2012-08-22	ABBNY-DELISTED	Stock	17.47	17.765	17.4532	17.74	2237355.0
2012-08-22	ABC-DELISTED	Stock	37.58	38.07	37.42	37.92	2836641.0
2012-08-22	ABCB	Stock	12.05	12.17	11.97	11.99	19000.0
2012-08-22	ABCD-DELISTED	Stock	0.9499	0.95	0.911	0.911	69153.0
2012-08-22	ABCO-DELISTED	Stock	40.11	41.54	40.11	41.31	706874.0
2012-08-22	ABCW-DELISTED	Stock	0.48	0.48	0.35	0.42	9538.0
2012-08-22	ABE-DELISTED	Stock	19.4	19.5	19.4	19.5	1039.0
2012-08-22	ABEO	Stock	587.5	587.5	562.5	562.5	4.0
2012-08-22	ABFS-DELISTED	Stock	10.34	10.42	10.25	10.31	187841.0
2012-08-22	ABG	Stock	26.45	26.64	26.03	26.24	208900.0
2012-08-22	ABM	Stock	20.47	20.54	20.23	20.3	440300.0
2012-08-22	ABMD-DELISTED	Stock	21.25	21.36	21.05	21.36	202467.0
2012-08-22	ABR	Stock	5.59	5.59	5.5	5.55	27100.0
2012-08-22	ABT	Stock	31.2398	31.5373	31.2206	31.4461	6578158.0
2012-08-22	ABTL-DELISTED	Stock	3.92	3.95	3.85	3.94	3257.0
2012-08-22	ABUS	Stock	3.78	3.78	3.34	3.5	17900.0
2012-08-22	ABV-DELISTED	Stock	36.74	37.32	36.61	37.179	1747598.0
2012-08-22	ABX-DELISTED	Stock	36.99	37.68	36.35	37.65	8947519.0
2012-08-22	ACAD	Stock	1.76	1.85	1.75	1.77	758000.0
2012-08-22	ACAS-DELISTED	Stock	11.18	11.27	11.15	11.19	4979982.0
2012-08-22	ACAT-DELISTED	Stock	44.0	44.58	43.61	44.09	121233.0

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

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