PREVIEW / stock_daily / 2012-07-17

all stock daily files

  file:    by_date/stock_daily/2012/2012-07-17.parquet
  size:    198 KB
  rows:    6,147
  symbols: 3,505

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-17	AAPL	Stock	21.8139	21.8393	21.5411	21.6764	293624800.0
2012-07-17	MSFT	Stock	29.64	29.86	29.2	29.66	33771300.0
2012-07-17	NVDA	Stock	0.316	0.3178	0.304	0.3093	447476000.0
2012-07-17	AMZN	Stock	10.8725	10.897	10.698	10.8465	39740000.0
2012-07-17	META	Stock	28.48	28.59	27.15	28.09	30438600.0
2012-07-17	TSLA	Stock	2.3333	2.3473	2.1587	2.2233	38539500.0
2012-07-17	TLT	Stock	129.26	129.82	128.64	128.75	5591917.0
2012-07-17	ES	Stock	39.8	40.08	39.48	40.03	1300300.0
2012-07-17	CL	Stock	52.385	52.725	52.31	52.58	2958400.0
2012-07-17	A	Stock	26.3805	26.7597	26.1087	26.7096	2887569.0
2012-07-17	AABA-DELISTED	Stock	15.81	15.89	15.42	15.6	30228771.0
2012-07-17	AACC-DELISTED	Stock	6.83	7.02	6.77	6.92	24819.0
2012-07-17	AACG	Stock	4.39	4.49	4.18	4.2	2700.0
2012-07-17	AAIC-DELISTED	Stock	22.5	22.94	22.2	22.85	86590.0
2012-07-17	AAME	Stock	2.8	2.8	2.8	2.8	2800.0
2012-07-17	AAMRQ-DELISTED	Stock	0.515	0.5399	0.505	0.52	765166.0
2012-07-17	AAON	Stock	6.0148	6.0741	5.8993	6.0148	67163.0
2012-07-17	AAP	Stock	72.47	72.98	71.73	72.1	1493900.0
2012-07-17	AAT	Stock	25.3	25.39	25.05	25.29	105500.0
2012-07-17	AAU-DELISTED	Stock	1.97	1.97	1.87	1.9	53315.0
2012-07-17	AAUAF-DELISTED	Stock	1.97	1.97	1.87	1.92	53515.0
2012-07-17	AAV-DELISTED	Stock	3.21	3.24	3.15	3.16	93306.0
2012-07-17	AAWW-DELISTED	Stock	45.39	45.39	44.19	45.14	117330.0
2012-07-17	AAXJ	Stock	52.1	52.49	51.543	52.39	281829.0
2012-07-17	AAXN-DELISTED	Stock	5.21	5.2323	5.0601	5.22	138193.0
2012-07-17	AB	Stock	12.37	12.63	12.15	12.56	376600.0
2012-07-17	ABAC-DELISTED	Stock	1.15	1.18	1.13	1.13	14460.0
2012-07-17	ABAX-DELISTED	Stock	39.4	39.93	38.9	39.7	70143.0
2012-07-17	ABB-DELISTED	Stock	16.38	16.41	16.21	16.4	4377923.0
2012-07-17	ABBNY-DELISTED	Stock	16.38	16.41	16.21	16.41	4548018.0
2012-07-17	ABC-DELISTED	Stock	39.51	39.92	39.19	39.78	1888225.0
2012-07-17	ABCB	Stock	12.47	12.66	12.35	12.45	30400.0
2012-07-17	ABCD-DELISTED	Stock	1.03	1.1	1.03	1.09	24638.0
2012-07-17	ABCO-DELISTED	Stock	50.8	50.95	50.17	50.2	121568.0
2012-07-17	ABCW-DELISTED	Stock	0.54	0.54	0.4	0.46	10073.0
2012-07-17	ABE-DELISTED	Stock	19.03	19.03	18.91	19.03	38666.0
2012-07-17	ABEO	Stock	650.0	700.0	650.0	700.0	29.0
2012-07-17	ABFS-DELISTED	Stock	11.73	11.8	11.34	11.45	275539.0
2012-07-17	ABG	Stock	26.45	26.69	26.09	26.58	219400.0
2012-07-17	ABM	Stock	18.42	19.41	18.11	18.67	1443300.0
2012-07-17	ABMD-DELISTED	Stock	24.37	24.5	23.79	24.15	303202.0
2012-07-17	ABR	Stock	5.34	5.36	5.3	5.3	16900.0
2012-07-17	ABT	Stock	31.4173	31.9595	31.4029	31.8875	12253022.0
2012-07-17	ABTL-DELISTED	Stock	3.76	3.77	3.49	3.65	51840.0
2012-07-17	ABUS	Stock	3.08	3.12	2.39	2.4	244600.0
2012-07-17	ABV-DELISTED	Stock	36.85	36.86	36.33	36.65	1498845.0
2012-07-17	ABVA-DELISTED	Stock	4.59	4.61	4.46	4.46	700.0
2012-07-17	ABX-DELISTED	Stock	34.81	34.94	33.97	34.64	6761181.0
2012-07-17	ACAD	Stock	1.57	1.63	1.55	1.61	326700.0
2012-07-17	ACAS-DELISTED	Stock	9.97	9.9799	9.75	9.87	1288985.0

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

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