PREVIEW / stock_daily / 2012-09-07

all stock daily files

  file:    by_date/stock_daily/2012/2012-09-07.parquet
  size:    199 KB
  rows:    6,139
  symbols: 3,479

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-09-07	AAPL	Stock	24.2161	24.3743	24.1346	24.3014	329666400.0
2012-09-07	MSFT	Stock	31.04	31.07	30.73	30.95	42649100.0
2012-09-07	NVDA	Stock	0.3345	0.3373	0.3238	0.335	781064000.0
2012-09-07	AMZN	Stock	12.6925	12.971	12.676	12.957	100590000.0
2012-09-07	META	Stock	19.1	19.42	18.78	18.98	36371700.0
2012-09-07	TSLA	Stock	1.9033	1.9713	1.9	1.9567	14298000.0
2012-09-07	TLT	Stock	126.14	126.18	123.92	124.03	7335293.0
2012-09-07	ES	Stock	38.15	38.25	37.97	38.24	1019300.0
2012-09-07	CL	Stock	53.83	54.0	52.975	53.15	3502200.0
2012-09-07	A	Stock	26.8097	27.5966	26.6595	27.4821	5579837.0
2012-09-07	AABA-DELISTED	Stock	15.12	15.29	15.1	15.22	12714078.0
2012-09-07	AACC-DELISTED	Stock	6.82	6.82	6.69	6.7	11207.0
2012-09-07	AACG	Stock	4.38	4.42	4.38	4.4	700.0
2012-09-07	AAIC-DELISTED	Stock	22.86	23.0	22.821	23.0	64281.0
2012-09-07	AAME	Stock	2.69	2.7	2.67	2.67	2700.0
2012-09-07	AAMRQ-DELISTED	Stock	0.47	0.475	0.453	0.462	1496805.0
2012-09-07	AAON	Stock	5.6119	5.6504	5.5319	5.6178	119475.0
2012-09-07	AAP	Stock	71.27	71.45	69.97	70.39	1470700.0
2012-09-07	AAT	Stock	28.09	28.16	27.78	27.84	156600.0
2012-09-07	AAU-DELISTED	Stock	2.71	2.75	2.6101	2.67	307541.0
2012-09-07	AAUAF-DELISTED	Stock	2.71	2.75	2.6101	2.68	317691.0
2012-09-07	AAV-DELISTED	Stock	3.53	3.58	3.5	3.58	68316.0
2012-09-07	AAWW-DELISTED	Stock	53.98	55.06	53.42	54.56	343150.0
2012-09-07	AAXJ	Stock	53.96	54.32	53.9	54.31	317648.0
2012-09-07	AAXN-DELISTED	Stock	5.47	5.51	5.41	5.5	218637.0
2012-09-07	AB	Stock	14.36	14.49	14.21	14.34	163500.0
2012-09-07	ABAC-DELISTED	Stock	1.2	1.218	1.12	1.191	800.0
2012-09-07	ABAX-DELISTED	Stock	38.43	38.5	36.73	36.94	133835.0
2012-09-07	ABB-DELISTED	Stock	18.585	18.695	18.51	18.66	2905267.0
2012-09-07	ABBNY-DELISTED	Stock	18.58	18.695	18.51	18.65	3005137.0
2012-09-07	ABC-DELISTED	Stock	38.66	38.76	38.04	38.17	2681274.0
2012-09-07	ABCB	Stock	12.4	12.52	12.22	12.49	49300.0
2012-09-07	ABCD-DELISTED	Stock	0.99	1.05	0.9801	0.982	11200.0
2012-09-07	ABCO-DELISTED	Stock	47.09	47.29	45.76	45.88	140309.0
2012-09-07	ABCW-DELISTED	Stock	0.36	0.44	0.36	0.415	12870.0
2012-09-07	ABE-DELISTED	Stock	19.93	20.14	19.83	20.14	18435.0
2012-09-07	ABEO	Stock	712.5	712.5	662.5	712.5	3.0
2012-09-07	ABFS-DELISTED	Stock	8.74	8.74	8.17	8.25	662485.0
2012-09-07	ABG	Stock	29.53	29.98	29.38	29.87	275900.0
2012-09-07	ABM	Stock	19.44	19.44	19.08	19.21	366900.0
2012-09-07	ABMD-DELISTED	Stock	23.29	23.35	20.46	21.01	1683006.0
2012-09-07	ABR	Stock	5.7	5.7	5.54	5.62	20200.0
2012-09-07	ABT	Stock	32.0986	32.2618	31.9067	31.9979	9034598.0
2012-09-07	ABTL-DELISTED	Stock	3.6	3.65	3.6	3.65	5420.0
2012-09-07	ABUS	Stock	3.35	3.4	3.27	3.27	9000.0
2012-09-07	ABV-DELISTED	Stock	38.22	38.83	38.11	38.26	1399704.0
2012-09-07	ABVA-DELISTED	Stock	4.5	4.5	4.5	4.5	2300.0
2012-09-07	ABX-DELISTED	Stock	39.97	40.48	39.67	40.17	9832230.0
2012-09-07	ACAD	Stock	1.73	1.92	1.73	1.92	1505000.0
2012-09-07	ACAS-DELISTED	Stock	11.31	11.405	11.29	11.375	2536247.0

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

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