PREVIEW / stock_daily / 2012-06-08

all stock daily files

  file:    by_date/stock_daily/2012/2012-06-08.parquet
  size:    197 KB
  rows:    6,153
  symbols: 3,513

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-06-08	AAPL	Stock	20.4143	20.735	20.3214	20.7257	347516400.0
2012-06-08	MSFT	Stock	29.21	29.68	29.05	29.65	42551100.0
2012-06-08	NVDA	Stock	0.2982	0.304	0.2978	0.303	370308000.0
2012-06-08	AMZN	Stock	10.9305	10.971	10.833	10.924	57540000.0
2012-06-08	META	Stock	26.55	27.76	26.44	27.1	38034000.0
2012-06-08	TSLA	Stock	1.924	2.0127	1.8767	2.0053	13216500.0
2012-06-08	TLT	Stock	126.75	126.95	124.57	125.21	11239640.0
2012-06-08	ES	Stock	37.03	37.43	36.86	37.39	1570700.0
2012-06-08	CL	Stock	49.4	50.15	49.375	50.085	3109600.0
2012-06-08	A	Stock	28.3405	28.505	28.2046	28.3262	4244608.0
2012-06-08	AABA-DELISTED	Stock	15.52	15.68	15.4	15.64	16378091.0
2012-06-08	AACC-DELISTED	Stock	5.67	5.94	5.57	5.85	56344.0
2012-06-08	AACG	Stock	5.41	5.42	5.0	5.0	5000.0
2012-06-08	AAIC-DELISTED	Stock	22.0	22.37	21.87	22.26	29550.0
2012-06-08	AAME	Stock	2.75	2.75	2.63	2.74	3100.0
2012-06-08	AAMRQ-DELISTED	Stock	0.444	0.456	0.44	0.445	1497201.0
2012-06-08	AAON	Stock	5.7215	5.8993	5.6741	5.8607	124538.0
2012-06-08	AAP	Stock	73.47	74.63	72.96	74.33	923100.0
2012-06-08	AAT	Stock	23.49	23.71	23.42	23.58	117000.0
2012-06-08	AAU-DELISTED	Stock	2.1	2.2	2.03	2.15	134867.0
2012-06-08	AAUAF-DELISTED	Stock	2.1	2.229	2.06	2.15	133356.0
2012-06-08	AAV-DELISTED	Stock	2.82	2.86	2.73	2.78	254449.0
2012-06-08	AAWW-DELISTED	Stock	43.94	45.39	43.06	44.83	189808.0
2012-06-08	AAXJ	Stock	50.74	51.02	50.51	50.95	314056.0
2012-06-08	AAXN-DELISTED	Stock	5.2	5.3113	5.19	5.25	492730.0
2012-06-08	AB	Stock	12.07	12.18	11.8	12.0	2015800.0
2012-06-08	ABAC-DELISTED	Stock	1.35	1.4999	1.31	1.33	4400.0
2012-06-08	ABAX-DELISTED	Stock	31.89	33.1823	31.87	32.46	115815.0
2012-06-08	ABB-DELISTED	Stock	15.97	16.27	15.97	16.25	2127736.0
2012-06-08	ABBNY-DELISTED	Stock	15.97	16.27	15.97	16.24	2123616.0
2012-06-08	ABC-DELISTED	Stock	36.89	37.27	36.89	37.05	1283130.0
2012-06-08	ABCB	Stock	11.47	11.85	11.46	11.76	21400.0
2012-06-08	ABCD-DELISTED	Stock	1.24	1.4	1.24	1.35	46594.0
2012-06-08	ABCO-DELISTED	Stock	47.41	47.77	47.08	47.65	165626.0
2012-06-08	ABCW-DELISTED	Stock	0.5321	0.5321	0.4267	0.4267	13940.0
2012-06-08	ABE-DELISTED	Stock	17.89	17.89	17.83	17.87	1950.0
2012-06-08	ABEO	Stock	862.5	887.5	862.5	887.5	1.0
2012-06-08	ABFS-DELISTED	Stock	11.92	12.319	11.85	12.25	170375.0
2012-06-08	ABG	Stock	24.97	25.58	24.68	25.43	144600.0
2012-06-08	ABM	Stock	20.33	20.94	20.31	20.71	414300.0
2012-06-08	ABMD-DELISTED	Stock	21.2	22.16	21.05	21.83	463600.0
2012-06-08	ABR	Stock	5.33	5.38	5.33	5.37	230800.0
2012-06-08	ABT	Stock	29.3302	29.6996	29.2966	29.69	11941226.0
2012-06-08	ABTL-DELISTED	Stock	3.95	3.95	3.75	3.9	19981.0
2012-06-08	ABUS	Stock	1.97	1.99	1.97	1.99	300.0
2012-06-08	ABV-DELISTED	Stock	36.98	37.21	36.94	37.16	2629311.0
2012-06-08	ABVA-DELISTED	Stock	4.27	4.27	4.27	4.27	100.0
2012-06-08	ABVT-DELISTED	Stock	83.4	83.55	83.4	83.52	256845.0
2012-06-08	ABX-DELISTED	Stock	38.26	39.38	38.08	39.02	7055862.0
2012-06-08	ACAD	Stock	1.33	1.38	1.32	1.36	75600.0

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

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