PREVIEW / stock_daily / 2013-08-13

all stock daily files

  file:    by_date/stock_daily/2013/2013-08-13.parquet
  size:    213 KB
  rows:    6,388
  symbols: 3,527

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
2013-08-13	AAPL	Stock	16.8193	17.6664	16.7161	17.4846	881941200.0
2013-08-13	MSFT	Stock	32.51	32.55	32.21	32.23	39464100.0
2013-08-13	NVDA	Stock	0.3598	0.362	0.3575	0.3605	197468000.0
2013-08-13	AMZN	Stock	14.794	14.8185	14.5335	14.6985	46998000.0
2013-08-13	META	Stock	38.24	38.32	36.77	37.02	65379200.0
2013-08-13	TSLA	Stock	9.9667	9.9893	9.63	9.6953	131233500.0
2013-08-13	TLT	Stock	105.33	105.36	104.8	104.99	11485791.0
2013-08-13	ES	Stock	43.47	43.54	43.06	43.06	917300.0
2013-08-13	CL	Stock	61.0	61.2	60.79	61.08	2430100.0
2013-08-13	A	Stock	33.226	33.6052	33.0758	33.5622	2905324.0
2013-08-13	AABA-DELISTED	Stock	28.38	28.6	28.23	28.34	14261668.0
2013-08-13	AACG	Stock	5.28	5.39	5.0	5.06	10400.0
2013-08-13	AAIC-DELISTED	Stock	24.88	25.14	24.8	24.91	133656.0
2013-08-13	AAMC-DELISTED	Stock	100.0	102.9412	100.0	102.9412	15048.0
2013-08-13	AAME	Stock	3.89	3.9	3.78	3.9	3000.0
2013-08-13	AAMRQ-DELISTED	Stock	5.81	5.84	2.75	3.17	110815263.0
2013-08-13	AAON	Stock	11.2978	11.4622	11.1244	11.2756	173925.0
2013-08-13	AAP	Stock	82.73	84.93	82.41	84.49	1200800.0
2013-08-13	AAT	Stock	32.1	32.17	31.68	31.87	66000.0
2013-08-13	AAU-DELISTED	Stock	1.8	1.8233	1.73	1.76	84752.0
2013-08-13	AAUAF-DELISTED	Stock	1.8	1.84	1.75	1.76	84388.0
2013-08-13	AAV-DELISTED	Stock	3.64	3.67	3.63	3.66	281730.0
2013-08-13	AAWW-DELISTED	Stock	42.85	42.85	42.3	42.42	171757.0
2013-08-13	AAXJ	Stock	56.98	57.1014	56.68	56.93	287889.0
2013-08-13	AAXN-DELISTED	Stock	8.6	8.74	8.57	8.69	373755.0
2013-08-13	AB	Stock	21.36	21.44	20.5	20.64	348500.0
2013-08-13	ABAC-DELISTED	Stock	0.6	0.6696	0.59	0.6696	36247.0
2013-08-13	ABAX-DELISTED	Stock	40.91	40.957	40.03	40.6	56155.0
2013-08-13	ABB-DELISTED	Stock	22.47	22.58	22.39	22.54	656951.0
2013-08-13	ABBNY-DELISTED	Stock	22.47	22.58	22.39	22.52	690434.0
2013-08-13	ABBV	Stock	45.12	45.18	44.68	44.93	2791800.0
2013-08-13	ABC-DELISTED	Stock	58.7	58.97	57.98	58.13	2284071.0
2013-08-13	ABCB	Stock	19.16	19.2	18.89	19.11	51400.0
2013-08-13	ABCD-DELISTED	Stock	1.2	1.22	1.19	1.22	6672.0
2013-08-13	ABCO-DELISTED	Stock	58.65	59.56	58.36	59.43	164350.0
2013-08-13	ABCW-DELISTED	Stock	0.045	0.06	0.0221	0.025	3306258.0
2013-08-13	ABE-DELISTED	Stock	20.0	20.09	19.87	20.05	8461.0
2013-08-13	ABEO	Stock	525.0	525.0	450.0	512.5	3.0
2013-08-13	ABFS-DELISTED	Stock	23.62	23.81	23.18	23.38	394954.0
2013-08-13	ABG	Stock	51.62	51.69	50.94	51.21	375400.0
2013-08-13	ABM	Stock	26.0	26.0	25.87	26.0	191100.0
2013-08-13	ABMD-DELISTED	Stock	22.6	23.2	22.38	23.11	274008.0
2013-08-13	ABR	Stock	7.51	7.51	7.4	7.42	82700.0
2013-08-13	ABR.A-DELISTED	Stock	24.829	24.829	24.69	24.69	1000.0
2013-08-13	ABR.B-DELISTED	Stock	23.6	23.72	23.6	23.7	800.0
2013-08-13	ABT	Stock	35.93	36.03	35.74	35.94	4600200.0
2013-08-13	ABTL-DELISTED	Stock	6.36	6.53	6.32	6.45	63009.0
2013-08-13	ABUS	Stock	5.47	5.49	5.2	5.4	84300.0
2013-08-13	ABV-DELISTED	Stock	36.95	37.55	36.92	37.36	1756414.0
2013-08-13	ABX-DELISTED	Stock	18.1	18.27	17.6	17.79	14786639.0

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

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