PREVIEW / stock_daily / 2012-10-22

all stock daily files

  file:    by_date/stock_daily/2012/2012-10-22.parquet
  size:    198 KB
  rows:    6,120
  symbols: 3,456

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-10-22	AAPL	Stock	21.8721	22.6921	21.8129	22.6439	546730800.0
2012-10-22	MSFT	Stock	28.73	28.83	27.83	28.0	83374000.0
2012-10-22	NVDA	Stock	0.304	0.3058	0.2968	0.2992	480840000.0
2012-10-22	AMZN	Stock	11.9405	11.9475	11.616	11.689	90000000.0
2012-10-22	META	Stock	19.2	19.43	19.05	19.32	32447300.0
2012-10-22	TSLA	Stock	1.866	1.8667	1.824	1.8567	7053000.0
2012-10-22	TLT	Stock	121.43	121.84	120.94	120.96	6910526.0
2012-10-22	ES	Stock	39.62	39.85	39.29	39.56	1270700.0
2012-10-22	CL	Stock	53.76	54.05	53.535	53.845	2180200.0
2012-10-22	A	Stock	25.5079	25.8226	25.4149	25.7511	3406786.0
2012-10-22	AABA-DELISTED	Stock	15.81	15.95	15.74	15.77	31976956.0
2012-10-22	AACC-DELISTED	Stock	7.15	7.53	7.0	7.08	10070.0
2012-10-22	AACG	Stock	5.17	5.17	5.05	5.05	300.0
2012-10-22	AAIC-DELISTED	Stock	22.03	22.03	21.71	21.98	82692.0
2012-10-22	AAME	Stock	2.77	2.77	2.75	2.75	2700.0
2012-10-22	AAMRQ-DELISTED	Stock	0.366	0.37	0.365	0.3669	708882.0
2012-10-22	AAON	Stock	5.8222	5.9348	5.8222	5.9141	111375.0
2012-10-22	AAP	Stock	65.76	66.42	64.36	66.15	2884100.0
2012-10-22	AAT	Stock	27.99	28.07	27.37	27.44	111600.0
2012-10-22	AAU-DELISTED	Stock	2.49	2.655	2.48	2.65	109013.0
2012-10-22	AAUAF-DELISTED	Stock	2.51	2.68	2.5	2.65	108442.0
2012-10-22	AAV-DELISTED	Stock	3.9	3.9	3.63	3.67	929038.0
2012-10-22	AAWW-DELISTED	Stock	50.98	51.73	50.82	51.28	182454.0
2012-10-22	AAXJ	Stock	56.87	57.09	56.57	56.9	274834.0
2012-10-22	AAXN-DELISTED	Stock	6.38	6.54	6.3	6.42	689665.0
2012-10-22	AB	Stock	16.38	16.5	15.96	16.04	203200.0
2012-10-22	ABAC-DELISTED	Stock	1.28	1.55	1.28	1.5499	10313.0
2012-10-22	ABAX-DELISTED	Stock	35.81	36.6	35.39	36.47	66678.0
2012-10-22	ABB-DELISTED	Stock	19.54	19.645	19.41	19.58	2410325.0
2012-10-22	ABBNY-DELISTED	Stock	19.54	19.645	19.41	19.57	2439240.0
2012-10-22	ABC-DELISTED	Stock	40.19	40.56	39.9	40.43	1482561.0
2012-10-22	ABCB	Stock	12.01	12.15	11.9	11.93	14400.0
2012-10-22	ABCD-DELISTED	Stock	0.96	0.97	0.93	0.97	3182.0
2012-10-22	ABCO-DELISTED	Stock	46.95	46.95	45.68	46.2	101357.0
2012-10-22	ABCW-DELISTED	Stock	0.37	0.3899	0.37	0.38	5725.0
2012-10-22	ABE-DELISTED	Stock	20.75	20.77	20.61	20.66	7928.0
2012-10-22	ABEO	Stock	325.0	350.0	300.0	337.5	51.0
2012-10-22	ABFS-DELISTED	Stock	7.61	7.81	7.59	7.76	211142.0
2012-10-22	ABG	Stock	30.47	30.47	29.61	30.04	194400.0
2012-10-22	ABM	Stock	18.48	18.6	18.34	18.43	125100.0
2012-10-22	ABMD-DELISTED	Stock	19.57	19.63	18.69	19.05	869404.0
2012-10-22	ABR	Stock	5.53	5.53	5.45	5.49	97000.0
2012-10-22	ABT	Stock	31.5037	31.6668	31.3165	31.5756	23650896.0
2012-10-22	ABTL-DELISTED	Stock	3.95	4.0178	3.95	3.99	16426.0
2012-10-22	ABUS	Stock	3.82	3.89	3.82	3.89	4600.0
2012-10-22	ABV-DELISTED	Stock	41.3	41.67	41.22	41.52	1569771.0
2012-10-22	ABVA-DELISTED	Stock	4.48	4.48	4.48	4.48	100.0
2012-10-22	ABX-DELISTED	Stock	38.58	39.43	38.53	39.32	6371880.0
2012-10-22	ACAD	Stock	2.42	2.42	2.18	2.27	1593900.0
2012-10-22	ACAS-DELISTED	Stock	11.85	11.9451	11.73	11.82	1691951.0

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

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