PREVIEW / stock_daily / 2011-12-12

all stock daily files

  file:    by_date/stock_daily/2011/2011-12-12.parquet
  size:    196 KB
  rows:    6,135
  symbols: 3,547

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
2011-12-12	AAPL	Stock	13.9886	14.0679	13.9089	13.9943	301067200.0
2011-12-12	MSFT	Stock	25.41	25.57	25.29	25.51	38945900.0
2011-12-12	NVDA	Stock	0.3645	0.366	0.3565	0.3632	573208000.0
2011-12-12	AMZN	Stock	9.5015	9.5575	9.3815	9.476	86864000.0
2011-12-12	TSLA	Stock	2.0293	2.0413	2.0013	2.0273	11380500.0
2011-12-12	TLT	Stock	117.91	118.49	117.61	118.01	5734508.0
2011-12-12	ES	Stock	34.14	34.31	33.9	34.24	1519900.0
2011-12-12	CL	Stock	45.22	45.42	44.695	45.105	3299600.0
2011-12-12	A	Stock	24.8999	24.9785	23.8484	24.1273	5470234.0
2011-12-12	AABA-DELISTED	Stock	15.73	15.73	15.41	15.48	14291044.0
2011-12-12	AACC-DELISTED	Stock	3.41	3.66	3.41	3.51	7313.0
2011-12-12	AACG	Stock	8.99	9.0	8.7	9.0	4400.0
2011-12-12	AAIC-DELISTED	Stock	21.58	22.07	21.42	21.82	69375.0
2011-12-12	AAME	Stock	1.96	2.0	1.95	2.0	18700.0
2011-12-12	AAON	Stock	6.2519	6.3348	6.1807	6.2726	208238.0
2011-12-12	AAP	Stock	69.89	70.08	69.1	69.16	1174900.0
2011-12-12	AAT	Stock	20.36	20.43	20.21	20.29	230400.0
2011-12-12	AATI-DELISTED	Stock	5.74	5.75	5.74	5.75	515891.0
2011-12-12	AAU-DELISTED	Stock	2.43	2.45	2.32	2.32	162160.0
2011-12-12	AAUAF-DELISTED	Stock	2.43	2.45	2.32	2.32	162660.0
2011-12-12	AAV-DELISTED	Stock	4.06	4.09	3.89	4.0	330217.0
2011-12-12	AAWW-DELISTED	Stock	39.27	39.75	37.21	39.11	282977.0
2011-12-12	AAXJ	Stock	50.25	50.43	49.59	50.0	913914.0
2011-12-12	AAXN-DELISTED	Stock	6.24	6.28	6.1	6.16	408470.0
2011-12-12	AB	Stock	13.16	13.64	13.12	13.55	695100.0
2011-12-12	ABAC-DELISTED	Stock	1.48	1.52	1.48	1.52	2600.0
2011-12-12	ABAX-DELISTED	Stock	27.29	27.34	26.82	27.25	64644.0
2011-12-12	ABB-DELISTED	Stock	18.38	18.429	18.15	18.31	4258915.0
2011-12-12	ABBNY-DELISTED	Stock	18.38	18.429	18.15	18.33	4462507.0
2011-12-12	ABC-DELISTED	Stock	36.15	36.27	35.73	35.84	2245211.0
2011-12-12	ABCB	Stock	10.14	10.14	9.86	10.0	33100.0
2011-12-12	ABCD-DELISTED	Stock	2.95	3.04	2.75	2.79	92639.0
2011-12-12	ABCO-DELISTED	Stock	35.71	35.94	34.97	35.5	119656.0
2011-12-12	ABCW-DELISTED	Stock	0.3615	0.3916	0.3524	0.3524	32670.0
2011-12-12	ABD-DELISTED	Stock	9.87	9.96	9.65	9.79	253710.0
2011-12-12	ABE-DELISTED	Stock	17.51	17.51	17.16	17.3	3863.0
2011-12-12	ABEO	Stock	1775.0	1812.5	1687.5	1800.0	13.0
2011-12-12	ABFS-DELISTED	Stock	18.91	18.91	18.03	18.68	388761.0
2011-12-12	ABG	Stock	20.71	21.22	20.71	21.16	244000.0
2011-12-12	ABH-DELISTED	Stock	14.88	14.99	14.76	14.77	299351.0
2011-12-12	ABM	Stock	20.73	20.84	20.35	20.46	680000.0
2011-12-12	ABMD-DELISTED	Stock	20.86	20.9885	20.18	20.61	182032.0
2011-12-12	ABR	Stock	3.31	3.46	3.24	3.43	25000.0
2011-12-12	ABT	Stock	26.0196	26.1491	25.8132	26.0387	11226344.0
2011-12-12	ABTL-DELISTED	Stock	3.7547	3.7953	3.5725	3.7953	2783.0
2011-12-12	ABUS	Stock	1.66	1.66	1.61	1.61	1300.0
2011-12-12	ABV-DELISTED	Stock	35.42	35.48	35.0	35.17	1945028.0
2011-12-12	ABVA-DELISTED	Stock	3.65	3.65	3.65	3.65	200.0
2011-12-12	ABVT-DELISTED	Stock	64.78	65.68	64.66	65.63	146094.0
2011-12-12	ABX-DELISTED	Stock	48.51	48.53	47.27	47.88	7608629.0

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

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