PREVIEW / stock_daily / 2012-11-16

all stock daily files

  file:    by_date/stock_daily/2012/2012-11-16.parquet
  size:    200 KB
  rows:    6,190
  symbols: 3,492

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-11-16	AAPL	Stock	18.7571	18.9286	18.0625	18.8457	1266893600.0
2012-11-16	MSFT	Stock	26.67	26.7	26.34	26.52	64083300.0
2012-11-16	NVDA	Stock	0.2898	0.2908	0.2788	0.2845	624552000.0
2012-11-16	AMZN	Stock	11.0655	11.3125	10.932	11.2615	87056000.0
2012-11-16	META	Stock	22.25	23.93	22.18	23.56	107182200.0
2012-11-16	TSLA	Stock	2.0767	2.1333	2.0393	2.1227	13630500.0
2012-11-16	TLT	Stock	126.36	127.19	126.28	126.3705	4592415.0
2012-11-16	ES	Stock	37.86	38.37	37.64	38.32	1808500.0
2012-11-16	CL	Stock	51.94	52.625	51.895	52.575	4087400.0
2012-11-16	A	Stock	25.6009	25.6438	25.3577	25.6152	9231134.0
2012-11-16	AABA-DELISTED	Stock	17.91	18.02	17.76	17.86	30395593.0
2012-11-16	AACC-DELISTED	Stock	4.32	4.33	3.97	4.24	39962.0
2012-11-16	AACG	Stock	4.62	4.62	4.41	4.41	2000.0
2012-11-16	AAIC-DELISTED	Stock	19.5	20.3998	19.44	20.32	239896.0
2012-11-16	AAME	Stock	2.91	2.94	2.88	2.94	4100.0
2012-11-16	AAMRQ-DELISTED	Stock	0.371	0.3823	0.3625	0.363	543639.0
2012-11-16	AAON	Stock	5.5733	5.7156	5.4904	5.6681	388125.0
2012-11-16	AAP	Stock	77.51	78.0	76.9	76.9	1467200.0
2012-11-16	AAT	Stock	25.98	26.44	25.72	26.39	164700.0
2012-11-16	AAU-DELISTED	Stock	2.49	2.5405	2.48	2.5199	158404.0
2012-11-16	AAUAF-DELISTED	Stock	2.49	2.5506	2.49	2.52	158230.0
2012-11-16	AAV-DELISTED	Stock	3.31	3.38	3.28	3.35	118283.0
2012-11-16	AAWW-DELISTED	Stock	40.28	41.64	40.25	41.64	335399.0
2012-11-16	AAXJ	Stock	55.55	55.67	55.11	55.59	286436.0
2012-11-16	AAXN-DELISTED	Stock	7.63	7.75	7.5	7.69	480916.0
2012-11-16	AB	Stock	15.9	15.99	15.68	15.97	208400.0
2012-11-16	ABAC-DELISTED	Stock	0.8	0.832	0.78	0.78	10860.0
2012-11-16	ABAX-DELISTED	Stock	34.87	35.59	34.59	34.92	89668.0
2012-11-16	ABB-DELISTED	Stock	17.66	17.735	17.49	17.7	2546457.0
2012-11-16	ABBNY-DELISTED	Stock	17.65	17.735	17.49	17.69	2698187.0
2012-11-16	ABC-DELISTED	Stock	40.23	40.46	39.94	40.26	1986759.0
2012-11-16	ABCB	Stock	10.47	10.58	10.21	10.5	75900.0
2012-11-16	ABCD-DELISTED	Stock	0.94	0.98	0.94	0.98	7772.0
2012-11-16	ABCO-DELISTED	Stock	44.67	45.29	43.16	43.66	200693.0
2012-11-16	ABCW-DELISTED	Stock	0.4	0.419	0.4	0.419	1300.0
2012-11-16	ABE-DELISTED	Stock	19.4	19.742	19.34	19.5	38150.0
2012-11-16	ABEO	Stock	312.5	312.5	287.5	312.5	60.0
2012-11-16	ABFS-DELISTED	Stock	6.55	6.6688	6.43	6.56	353416.0
2012-11-16	ABG	Stock	28.35	28.7	28.17	28.48	155800.0
2012-11-16	ABM	Stock	18.2	18.39	17.98	18.37	192300.0
2012-11-16	ABMD-DELISTED	Stock	13.84	14.35	13.84	14.31	848593.0
2012-11-16	ABR	Stock	4.84	5.13	4.72	5.04	240500.0
2012-11-16	ABT	Stock	30.2994	30.4289	30.117	30.1698	17783243.0
2012-11-16	ABTL-DELISTED	Stock	3.97	3.99	3.8895	3.95	13481.0
2012-11-16	ABUS	Stock	5.28	5.41	5.22	5.22	96100.0
2012-11-16	ABV-DELISTED	Stock	40.06	40.35	39.76	40.26	2061718.0
2012-11-16	ABVA-DELISTED	Stock	4.35	4.47	4.35	4.47	878.0
2012-11-16	ABX-DELISTED	Stock	33.18	34.02	32.87	33.71	9520784.0
2012-11-16	ACAD	Stock	1.97	1.98	1.87	1.91	1005900.0
2012-11-16	ACAS-DELISTED	Stock	11.83	11.83	11.2	11.5	4138406.0

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

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