PREVIEW / stock_daily / 2012-05-23

all stock daily files

  file:    by_date/stock_daily/2012/2012-05-23.parquet
  size:    196 KB
  rows:    6,186
  symbols: 3,539

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-05-23	AAPL	Stock	19.9107	20.4571	19.7582	20.3771	584897600.0
2012-05-23	MSFT	Stock	29.35	29.4	28.64	29.11	65171000.0
2012-05-23	NVDA	Stock	0.3002	0.3115	0.2958	0.311	496000000.0
2012-05-23	AMZN	Stock	10.7355	10.8775	10.559	10.864	84876000.0
2012-05-23	META	Stock	31.37	32.5	31.36	32.0	73600000.0
2012-05-23	TSLA	Stock	2.0373	2.07	1.9667	2.068	18306000.0
2012-05-23	TLT	Stock	123.55	124.52	123.36	123.41	11744890.0
2012-05-23	ES	Stock	36.05	36.27	35.88	36.27	2835400.0
2012-05-23	CL	Stock	49.41	49.54	48.855	49.195	4600000.0
2012-05-23	A	Stock	28.6338	29.3419	28.176	29.1631	4817788.0
2012-05-23	AABA-DELISTED	Stock	15.16	15.43	15.14	15.38	17186705.0
2012-05-23	AACC-DELISTED	Stock	5.72	5.899	5.5101	5.79	38944.0
2012-05-23	AACG	Stock	6.53	6.95	6.05	6.8	4600.0
2012-05-23	AAIC-DELISTED	Stock	22.4	22.53	22.05	22.41	47081.0
2012-05-23	AAME	Stock	2.77	2.78	2.56	2.6	28000.0
2012-05-23	AAMRQ-DELISTED	Stock	0.46	0.472	0.455	0.468	1072247.0
2012-05-23	AAON	Stock	5.5437	5.6563	5.4726	5.6504	205875.0
2012-05-23	AAP	Stock	68.46	71.83	68.46	71.65	2258400.0
2012-05-23	AAT	Stock	22.82	22.82	22.41	22.68	225000.0
2012-05-23	AAU-DELISTED	Stock	1.95	2.01	1.87	1.99	216944.0
2012-05-23	AAUAF-DELISTED	Stock	1.97	2.03	1.89	1.99	215388.0
2012-05-23	AAV-DELISTED	Stock	2.87	2.88	2.75	2.86	234304.0
2012-05-23	AAWW-DELISTED	Stock	45.12	47.08	45.12	46.69	361380.0
2012-05-23	AAXJ	Stock	50.53	50.66	49.76	50.6	1199448.0
2012-05-23	AAXN-DELISTED	Stock	5.26	5.41	5.26	5.4	518922.0
2012-05-23	AB	Stock	13.34	13.46	12.94	13.33	194000.0
2012-05-23	ABAC-DELISTED	Stock	1.3784	1.39	1.37	1.39	2903.0
2012-05-23	ABAX-DELISTED	Stock	32.38	32.72	32.0	32.7	76319.0
2012-05-23	ABB-DELISTED	Stock	16.3	16.38	16.03	16.38	2179481.0
2012-05-23	ABBNY-DELISTED	Stock	16.3	16.38	16.03	16.37	2181131.0
2012-05-23	ABC-DELISTED	Stock	36.14	36.5	35.98	36.31	1998246.0
2012-05-23	ABCB	Stock	11.15	11.31	11.01	11.28	36000.0
2012-05-23	ABCD-DELISTED	Stock	1.26	1.48	1.2	1.37	21939.0
2012-05-23	ABCO-DELISTED	Stock	47.7	47.9	47.3	47.7	228672.0
2012-05-23	ABCW-DELISTED	Stock	0.5924	0.6024	0.5221	0.5221	5840.0
2012-05-23	ABE-DELISTED	Stock	18.01	18.249	17.89	17.98	7971.0
2012-05-23	ABEO	Stock	700.0	812.5	625.0	762.5	66.0
2012-05-23	ABFS-DELISTED	Stock	12.56	12.72	12.33	12.68	178347.0
2012-05-23	ABG	Stock	26.25	26.93	26.04	26.86	311000.0
2012-05-23	ABH-DELISTED	Stock	10.565	11.867	10.545	11.827	581220.0
2012-05-23	ABM	Stock	21.46	21.84	21.1	21.8	201000.0
2012-05-23	ABMD-DELISTED	Stock	22.27	22.27	20.84	22.02	1028118.0
2012-05-23	ABR	Stock	6.16	6.16	5.83	5.92	32000.0
2012-05-23	ABT	Stock	29.5749	29.762	29.287	29.4453	11987912.0
2012-05-23	ABTL-DELISTED	Stock	3.7025	3.751	3.5639	3.7475	34588.0
2012-05-23	ABUS	Stock	1.99	1.99	1.95	1.96	10300.0
2012-05-23	ABV-DELISTED	Stock	37.48	37.5	36.37	36.95	3033234.0
2012-05-23	ABVA-DELISTED	Stock	4.29	4.3	4.214	4.25	19220.0
2012-05-23	ABVT-DELISTED	Stock	83.09	83.26	83.09	83.2	277607.0
2012-05-23	ABX-DELISTED	Stock	37.14	39.58	36.89	39.56	13515510.0

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

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