PREVIEW / stock_daily / 2012-08-10

all stock daily files

  file:    by_date/stock_daily/2012/2012-08-10.parquet
  size:    199 KB
  rows:    6,168
  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-08-10	AAPL	Stock	22.0968	22.2057	22.0964	22.2036	194938800.0
2012-08-10	MSFT	Stock	30.5	30.62	30.25	30.42	27810300.0
2012-08-10	NVDA	Stock	0.3775	0.3805	0.3608	0.3655	1278744000.0
2012-08-10	AMZN	Stock	11.654	11.7425	11.5715	11.6375	37050000.0
2012-08-10	META	Stock	21.41	21.82	21.13	21.81	25794700.0
2012-08-10	TSLA	Stock	1.954	1.996	1.954	1.996	10611000.0
2012-08-10	TLT	Stock	126.2	126.32	125.6	125.7	4672304.0
2012-08-10	ES	Stock	39.17	39.67	39.07	39.59	1081900.0
2012-08-10	CL	Stock	52.38	52.73	52.36	52.685	2454400.0
2012-08-10	A	Stock	28.9199	29.0057	28.4907	28.9914	2739521.0
2012-08-10	AABA-DELISTED	Stock	15.24	15.35	15.01	15.16	60271228.0
2012-08-10	AACC-DELISTED	Stock	5.91	5.95	5.856	5.9	67714.0
2012-08-10	AACG	Stock	4.55	4.58	4.51	4.54	3800.0
2012-08-10	AAIC-DELISTED	Stock	23.01	23.01	22.9	22.99	60337.0
2012-08-10	AAME	Stock	2.55	2.7	2.53	2.7	700.0
2012-08-10	AAMRQ-DELISTED	Stock	0.486	0.505	0.48	0.4915	1581143.0
2012-08-10	AAON	Stock	5.7956	5.8222	5.7511	5.7659	81000.0
2012-08-10	AAP	Stock	67.41	68.62	66.92	68.6	1289400.0
2012-08-10	AAT	Stock	26.06	26.06	25.64	26.06	122700.0
2012-08-10	AAU-DELISTED	Stock	2.21	2.21	2.02	2.1	140886.0
2012-08-10	AAUAF-DELISTED	Stock	2.21	2.21	2.02	2.1	146786.0
2012-08-10	AAV-DELISTED	Stock	3.32	3.35	3.18	3.25	243846.0
2012-08-10	AAWW-DELISTED	Stock	51.83	52.5	50.62	51.84	281302.0
2012-08-10	AAXJ	Stock	54.19	54.64	54.12	54.64	286583.0
2012-08-10	AAXN-DELISTED	Stock	5.67	5.7	5.58	5.595	284634.0
2012-08-10	AB	Stock	12.85	13.41	12.65	13.0	487100.0
2012-08-10	ABAC-DELISTED	Stock	1.0	1.0	0.96	1.0	20807.0
2012-08-10	ABAX-DELISTED	Stock	37.49	37.49	36.24	37.27	94683.0
2012-08-10	ABB-DELISTED	Stock	17.77	17.94	17.692	17.93	2184082.0
2012-08-10	ABBNY-DELISTED	Stock	17.77	17.94	17.692	17.93	2253089.0
2012-08-10	ABC-DELISTED	Stock	38.7	38.74	38.25	38.67	1705680.0
2012-08-10	ABCB	Stock	11.46	11.51	10.85	11.27	476300.0
2012-08-10	ABCD-DELISTED	Stock	0.96	0.96	0.88	0.89	70185.0
2012-08-10	ABCO-DELISTED	Stock	42.42	42.645	42.137	42.43	254740.0
2012-08-10	ABCW-DELISTED	Stock	0.36	0.48	0.36	0.435	57465.0
2012-08-10	ABE-DELISTED	Stock	19.45	19.45	19.31	19.4168	24204.0
2012-08-10	ABEO	Stock	612.5	625.0	562.5	625.0	10.0
2012-08-10	ABFS-DELISTED	Stock	10.51	10.61	10.32	10.35	177314.0
2012-08-10	ABG	Stock	26.92	27.08	26.1	26.53	182100.0
2012-08-10	ABM	Stock	18.94	19.04	18.9	19.01	149000.0
2012-08-10	ABMD-DELISTED	Stock	21.93	22.0	21.3	21.45	426012.0
2012-08-10	ABR	Stock	5.58	5.6	5.5	5.55	38800.0
2012-08-10	ABT	Stock	31.5181	31.734	31.4749	31.7196	6333055.0
2012-08-10	ABTL-DELISTED	Stock	3.71	3.79	3.54	3.58	259486.0
2012-08-10	ABUS	Stock	3.7	3.88	3.7	3.79	75800.0
2012-08-10	ABV-DELISTED	Stock	38.3	38.37	37.97	38.22	2097466.0
2012-08-10	ABVA-DELISTED	Stock	4.4	4.42	4.4	4.42	5196.0
2012-08-10	ABX-DELISTED	Stock	34.19	34.6	33.845	34.59	7683550.0
2012-08-10	ACAD	Stock	1.51	1.6	1.51	1.59	257700.0
2012-08-10	ACAS-DELISTED	Stock	10.82	10.995	10.8	10.93	2799480.0

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

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