PREVIEW / stock_daily / 2012-07-26

all stock daily files

  file:    by_date/stock_daily/2012/2012-07-26.parquet
  size:    198 KB
  rows:    6,155
  symbols: 3,510

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-26	AAPL	Stock	20.7057	20.7286	20.37	20.5314	406632800.0
2012-07-26	MSFT	Stock	29.23	29.5	29.09	29.16	45301400.0
2012-07-26	NVDA	Stock	0.3333	0.337	0.3263	0.3288	338440000.0
2012-07-26	AMZN	Stock	11.0	11.0725	10.7475	11.0005	138748000.0
2012-07-26	META	Stock	27.75	28.23	26.73	26.85	64597400.0
2012-07-26	TSLA	Stock	1.9933	2.0	1.8427	1.8753	33934500.0
2012-07-26	TLT	Stock	131.53	131.78	130.9	130.95	6606220.0
2012-07-26	ES	Stock	39.88	40.4	39.85	40.05	908000.0
2012-07-26	CL	Stock	52.385	53.415	52.09	53.19	5617400.0
2012-07-26	A	Stock	26.4235	26.824	26.0372	26.1874	4271449.0
2012-07-26	AABA-DELISTED	Stock	15.67	15.88	15.62	15.79	11008632.0
2012-07-26	AACC-DELISTED	Stock	6.08	6.08	5.9905	6.05	18674.0
2012-07-26	AACG	Stock	3.71	4.0	3.7	3.7	9600.0
2012-07-26	AAIC-DELISTED	Stock	22.29	22.29	22.05	22.1	51254.0
2012-07-26	AAME	Stock	2.73	2.73	2.61	2.69	1200.0
2012-07-26	AAMRQ-DELISTED	Stock	0.515	0.515	0.501	0.514	1741493.0
2012-07-26	AAON	Stock	5.4726	5.4933	5.3689	5.4222	62775.0
2012-07-26	AAP	Stock	72.89	72.98	69.31	69.39	2864800.0
2012-07-26	AAT	Stock	25.14	25.77	25.14	25.45	220600.0
2012-07-26	AAU-DELISTED	Stock	1.92	2.0051	1.9	1.99	36297.0
2012-07-26	AAUAF-DELISTED	Stock	1.92	2.0	1.9	1.99	36542.0
2012-07-26	AAV-DELISTED	Stock	3.5	3.58	3.48	3.57	280999.0
2012-07-26	AAWW-DELISTED	Stock	44.0	44.9	43.05	43.61	126479.0
2012-07-26	AAXJ	Stock	51.52	51.7698	51.3	51.58	261483.0
2012-07-26	AAXN-DELISTED	Stock	5.21	5.4	5.16	5.3	1150183.0
2012-07-26	AB	Stock	12.05	12.75	11.84	12.01	282400.0
2012-07-26	ABAC-DELISTED	Stock	1.14	1.14	1.05	1.1	16881.0
2012-07-26	ABAX-DELISTED	Stock	37.0	37.24	36.12	36.87	125241.0
2012-07-26	ABB-DELISTED	Stock	16.9	17.11	16.84	16.99	5562292.0
2012-07-26	ABBNY-DELISTED	Stock	16.9	17.11	16.84	16.97	5718671.0
2012-07-26	ABC-DELISTED	Stock	38.18	38.652	36.91	37.95	6192685.0
2012-07-26	ABCB	Stock	11.83	12.08	11.66	11.7	21400.0
2012-07-26	ABCD-DELISTED	Stock	1.1	1.1	1.01	1.1	12693.0
2012-07-26	ABCO-DELISTED	Stock	45.05	45.51	44.89	45.1	217954.0
2012-07-26	ABCW-DELISTED	Stock	0.4	0.54	0.4	0.41	8650.0
2012-07-26	ABE-DELISTED	Stock	19.15	19.2	19.1	19.2	38959.0
2012-07-26	ABEO	Stock	637.5	800.0	637.5	775.0	18.0
2012-07-26	ABFS-DELISTED	Stock	11.35	11.46	11.13	11.21	242368.0
2012-07-26	ABG	Stock	26.14	26.2	25.36	25.51	348800.0
2012-07-26	ABM	Stock	18.89	18.94	18.59	18.67	423700.0
2012-07-26	ABMD-DELISTED	Stock	22.16	22.16	21.77	21.9	301199.0
2012-07-26	ABR	Stock	5.4	5.4	5.31	5.35	65600.0
2012-07-26	ABT	Stock	31.0814	31.187	30.9279	31.0191	11808879.0
2012-07-26	ABTL-DELISTED	Stock	3.69	3.7499	3.69	3.71	7600.0
2012-07-26	ABUS	Stock	2.95	3.34	2.79	2.93	58500.0
2012-07-26	ABV-DELISTED	Stock	37.07	38.28	37.0	38.18	3579196.0
2012-07-26	ABVA-DELISTED	Stock	4.34	4.376	4.34	4.35	1424.0
2012-07-26	ABX-DELISTED	Stock	31.54	33.06	31.0	32.73	26259230.0
2012-07-26	ACAD	Stock	1.58	1.58	1.54	1.55	114900.0
2012-07-26	ACAS-DELISTED	Stock	9.84	9.84	9.73	9.8	1945458.0

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

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