PREVIEW / stock_daily / 2012-08-23

all stock daily files

  file:    by_date/stock_daily/2012/2012-08-23.parquet
  size:    198 KB
  rows:    6,111
  symbols: 3,461

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-23	AAPL	Stock	23.7896	23.925	23.6125	23.6654	420128800.0
2012-08-23	MSFT	Stock	30.39	30.4	30.08	30.26	28355600.0
2012-08-23	NVDA	Stock	0.3652	0.3655	0.3562	0.3578	379040000.0
2012-08-23	AMZN	Stock	12.107	12.174	11.951	12.06	49078000.0
2012-08-23	META	Stock	19.5	19.73	19.36	19.44	32813700.0
2012-08-23	TSLA	Stock	2.0	2.0567	1.9767	2.0487	22065000.0
2012-08-23	TLT	Stock	124.74	125.14	124.65	124.93	7139013.0
2012-08-23	ES	Stock	38.2	38.2	37.65	37.74	881600.0
2012-08-23	CL	Stock	52.66	52.745	52.33	52.355	1942800.0
2012-08-23	A	Stock	26.6309	26.867	26.5165	26.8026	6280096.0
2012-08-23	AABA-DELISTED	Stock	14.9	14.97	14.82	14.86	12325060.0
2012-08-23	AACC-DELISTED	Stock	6.33	6.42	6.27	6.39	38443.0
2012-08-23	AACG	Stock	4.14	4.37	4.14	4.35	1000.0
2012-08-23	AAIC-DELISTED	Stock	22.9	22.92	22.82	22.84	23602.0
2012-08-23	AAME	Stock	2.67	2.7	2.67	2.68	1500.0
2012-08-23	AAMRQ-DELISTED	Stock	0.492	0.499	0.48	0.488	1622431.0
2012-08-23	AAON	Stock	5.597	5.597	5.3719	5.4222	213638.0
2012-08-23	AAP	Stock	72.06	72.37	71.9	71.96	657500.0
2012-08-23	AAT	Stock	27.23	27.33	26.94	27.15	102600.0
2012-08-23	AAU-DELISTED	Stock	2.42	2.47	2.37	2.39	509748.0
2012-08-23	AAUAF-DELISTED	Stock	2.42	2.47	2.37	2.39	525648.0
2012-08-23	AAV-DELISTED	Stock	3.62	3.79	3.5	3.7	701423.0
2012-08-23	AAWW-DELISTED	Stock	52.55	52.84	51.4	52.17	136409.0
2012-08-23	AAXJ	Stock	54.17	54.28	53.82	53.93	195126.0
2012-08-23	AAXN-DELISTED	Stock	5.43	5.44	5.25	5.39	365334.0
2012-08-23	AB	Stock	13.75	13.75	13.21	13.31	816400.0
2012-08-23	ABAC-DELISTED	Stock	1.15	1.2	1.13	1.2	6329.0
2012-08-23	ABAX-DELISTED	Stock	38.32	38.42	37.75	38.24	48027.0
2012-08-23	ABB-DELISTED	Stock	17.68	17.72	17.57	17.62	1644464.0
2012-08-23	ABBNY-DELISTED	Stock	17.68	17.72	17.57	17.63	1668630.0
2012-08-23	ABC-DELISTED	Stock	37.82	38.15	37.76	37.98	2081499.0
2012-08-23	ABCB	Stock	12.09	12.09	11.69	11.79	18200.0
2012-08-23	ABCD-DELISTED	Stock	0.95	1.02	0.91	0.95	72761.0
2012-08-23	ABCO-DELISTED	Stock	41.37	43.16	41.29	43.03	471460.0
2012-08-23	ABCW-DELISTED	Stock	0.44	0.44	0.35	0.395	10836.0
2012-08-23	ABE-DELISTED	Stock	19.45	19.53	19.45	19.458	1600.0
2012-08-23	ABEO	Stock	562.5	625.0	550.0	587.5	35.0
2012-08-23	ABFS-DELISTED	Stock	10.29	10.29	9.9	9.95	219342.0
2012-08-23	ABG	Stock	26.18	26.42	26.0	26.34	157500.0
2012-08-23	ABM	Stock	20.23	20.46	20.13	20.32	186400.0
2012-08-23	ABMD-DELISTED	Stock	21.27	21.85	21.12	21.83	393350.0
2012-08-23	ABR	Stock	5.54	5.58	5.48	5.48	81500.0
2012-08-23	ABT	Stock	31.4749	31.5612	31.259	31.3453	7297416.0
2012-08-23	ABTL-DELISTED	Stock	3.94	3.94	3.811	3.9	3500.0
2012-08-23	ABUS	Stock	3.64	3.67	3.37	3.39	7400.0
2012-08-23	ABV-DELISTED	Stock	37.08	37.35	36.92	37.33	1572256.0
2012-08-23	ABX-DELISTED	Stock	38.09	38.28	37.53	38.02	13273432.0
2012-08-23	ACAD	Stock	1.79	1.84	1.77	1.79	400900.0
2012-08-23	ACAS-DELISTED	Stock	11.2	11.245	11.1	11.2	4362049.0
2012-08-23	ACAT-DELISTED	Stock	44.08	44.08	42.65	43.16	80235.0

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

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