PREVIEW / stock_daily / 2012-07-12

all stock daily files

  file:    by_date/stock_daily/2012/2012-07-12.parquet
  size:    197 KB
  rows:    6,099
  symbols: 3,464

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-07-12	AAPL	Stock	21.4371	21.5525	21.1671	21.3893	428041600.0
2012-07-12	MSFT	Stock	29.15	29.18	28.54	28.63	63523600.0
2012-07-12	NVDA	Stock	0.3118	0.3123	0.3073	0.31	472160000.0
2012-07-12	AMZN	Stock	10.8305	10.865	10.6305	10.768	52324000.0
2012-07-12	META	Stock	30.7	31.4	30.6	30.81	11300700.0
2012-07-12	TSLA	Stock	2.086	2.2007	2.0533	2.18	16885500.0
2012-07-12	TLT	Stock	129.05	129.56	128.9	129.51	6421874.0
2012-07-12	ES	Stock	38.69	39.18	38.6	39.08	1122400.0
2012-07-12	CL	Stock	51.84	52.035	51.485	51.805	3586000.0
2012-07-12	A	Stock	26.3877	26.402	25.9299	26.123	4050146.0
2012-07-12	AABA-DELISTED	Stock	15.62	15.81	15.54	15.71	17945717.0
2012-07-12	AACC-DELISTED	Stock	7.21	7.21	6.85	6.95	61894.0
2012-07-12	AACG	Stock	4.19	4.47	4.06	4.26	2500.0
2012-07-12	AAIC-DELISTED	Stock	22.02	22.19	21.91	22.07	31679.0
2012-07-12	AAME	Stock	2.77	2.78	2.66	2.77	2100.0
2012-07-12	AAMRQ-DELISTED	Stock	0.55	0.5593	0.518	0.518	1432268.0
2012-07-12	AAON	Stock	5.8667	5.9319	5.8133	5.8933	89438.0
2012-07-12	AAP	Stock	69.5	71.87	69.25	71.58	1437100.0
2012-07-12	AAT	Stock	24.82	25.14	24.82	24.88	85700.0
2012-07-12	AAU-DELISTED	Stock	1.85	1.95	1.81	1.92	163264.0
2012-07-12	AAUAF-DELISTED	Stock	1.85	1.95	1.81	1.9	164482.0
2012-07-12	AAV-DELISTED	Stock	3.19	3.24	3.18	3.22	257578.0
2012-07-12	AAWW-DELISTED	Stock	43.81	44.92	42.95	44.69	157529.0
2012-07-12	AAXJ	Stock	50.99	51.28	50.74	51.09	286885.0
2012-07-12	AAXN-DELISTED	Stock	4.99	5.09	4.85	5.065	233902.0
2012-07-12	AB	Stock	12.43	12.5	12.12	12.25	323700.0
2012-07-12	ABAX-DELISTED	Stock	38.63	39.08	38.4	38.95	86028.0
2012-07-12	ABB-DELISTED	Stock	15.79	15.899	15.67	15.82	1670230.0
2012-07-12	ABBNY-DELISTED	Stock	15.79	15.899	15.67	15.82	1721278.0
2012-07-12	ABC-DELISTED	Stock	39.26	39.38	38.78	39.18	1960762.0
2012-07-12	ABCB	Stock	12.42	12.6	12.3	12.39	88900.0
2012-07-12	ABCD-DELISTED	Stock	0.9499	1.1	0.9499	1.07	14656.0
2012-07-12	ABCO-DELISTED	Stock	50.49	51.01	50.17	50.67	116471.0
2012-07-12	ABCW-DELISTED	Stock	0.54	0.54	0.41	0.48	24400.0
2012-07-12	ABE-DELISTED	Stock	18.75	18.87	18.67	18.87	4113.0
2012-07-12	ABFS-DELISTED	Stock	11.12	11.16	10.7	11.11	488235.0
2012-07-12	ABG	Stock	24.86	25.47	24.48	25.14	230600.0
2012-07-12	ABM	Stock	18.12	18.23	17.91	17.95	472200.0
2012-07-12	ABMD-DELISTED	Stock	23.59	23.98	23.4	23.82	201818.0
2012-07-12	ABR	Stock	5.22	5.26	5.16	5.23	53800.0
2012-07-12	ABT	Stock	31.0958	31.3501	31.0479	31.2494	16757607.0
2012-07-12	ABTL-DELISTED	Stock	3.78	4.21	3.37	3.95	27544.0
2012-07-12	ABUS	Stock	2.1	2.15	2.1	2.15	5600.0
2012-07-12	ABV-DELISTED	Stock	36.67	37.02	36.63	36.9	1920876.0
2012-07-12	ABX-DELISTED	Stock	34.54	34.76	33.67	34.56	12994061.0
2012-07-12	ACAD	Stock	1.76	1.77	1.71	1.77	238100.0
2012-07-12	ACAS-DELISTED	Stock	9.805	9.88	9.695	9.82	1961425.0
2012-07-12	ACAT-DELISTED	Stock	35.7	36.03	34.65	35.83	70138.0
2012-07-12	ACC-DELISTED	Stock	43.91	46.33	43.9	45.53	3724013.0
2012-07-12	ACCL-DELISTED	Stock	8.24	8.29	8.15	8.26	192616.0

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

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