PREVIEW / stock_daily / 2015-07-01

all stock daily files

  file:    by_date/stock_daily/2015/2015-07-01.parquet
  size:    224 KB
  rows:    6,650
  symbols: 3,483

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
2015-07-01	AAPL	Stock	31.725	31.735	31.4975	31.65	120955200.0
2015-07-01	MSFT	Stock	44.46	45.23	44.1	44.45	28343900.0
2015-07-01	NVDA	Stock	0.5152	0.5225	0.5055	0.51	302892000.0
2015-07-01	AMZN	Stock	21.9675	22.0	21.779	21.8695	39742000.0
2015-07-01	GOOGL	Stock	27.183	27.2905	26.988	27.165	30759460.0
2015-07-01	META	Stock	86.77	87.95	86.49	86.91	25260000.0
2015-07-01	TSLA	Stock	18.074	18.1747	17.8567	17.9433	31518000.0
2015-07-01	TLT	Stock	115.82	116.36	115.43	115.62	12451476.0
2015-07-01	ES	Stock	45.53	45.73	45.34	45.57	1798900.0
2015-07-01	CL	Stock	65.59	66.19	65.55	66.16	2986600.0
2015-07-01	A	Stock	38.89	39.3	38.75	39.26	4486400.0
2015-07-01	AA.B-DELISTED	Stock	40.38	40.3999	39.66	40.0	102598.0
2015-07-01	AABA-DELISTED	Stock	39.46	39.78	39.15	39.32	6008536.0
2015-07-01	AAC-DELISTED	Stock	43.86	44.5	41.77	43.0	115340.0
2015-07-01	AACG	Stock	5.82	5.85	5.63	5.73	18900.0
2015-07-01	AAIC-DELISTED	Stock	19.68	19.778	19.48	19.56	383290.0
2015-07-01	AAL	Stock	40.65	40.9	37.8	38.8	24907100.0
2015-07-01	AAMC-DELISTED	Stock	42.6794	43.0294	42.3088	42.3088	13722.0
2015-07-01	AAME	Stock	3.71	3.71	3.71	3.71	2200.0
2015-07-01	AAMI	Stock	17.96	18.13	17.58	17.79	290900.0
2015-07-01	AAOI	Stock	17.59	18.07	17.24	18.07	296700.0
2015-07-01	AAON	Stock	15.1667	15.5267	15.1	15.2333	199650.0
2015-07-01	AAP	Stock	160.59	162.85	160.31	162.65	675400.0
2015-07-01	AAT	Stock	39.31	39.79	38.99	39.13	608000.0
2015-07-01	AAU-DELISTED	Stock	0.83	0.8449	0.81	0.83	40550.0
2015-07-01	AAUAF-DELISTED	Stock	0.83	0.8449	0.81	0.8301	41870.0
2015-07-01	AAV-DELISTED	Stock	6.29	6.29	6.08	6.15	68178.0
2015-07-01	AAVL-DELISTED	Stock	16.36	16.61	16.0	16.07	516844.0
2015-07-01	AAWW-DELISTED	Stock	55.5	55.965	54.27	54.53	411374.0
2015-07-01	AAXJ	Stock	63.42	63.57	63.085	63.29	513586.0
2015-07-01	AAXN-DELISTED	Stock	33.5	33.53	32.67	33.18	1409343.0
2015-07-01	AB	Stock	29.9	30.08	29.46	29.55	140400.0
2015-07-01	ABAC-DELISTED	Stock	1.35	1.4099	1.33	1.39	34999.0
2015-07-01	ABAX-DELISTED	Stock	51.84	52.1099	50.95	52.03	172146.0
2015-07-01	ABB-DELISTED	Stock	21.09	21.19	20.78	20.87	1745090.0
2015-07-01	ABBNY-DELISTED	Stock	21.09	21.19	20.78	20.87	1930727.0
2015-07-01	ABBV	Stock	67.9	68.6	67.68	68.51	7694900.0
2015-07-01	ABC-DELISTED	Stock	107.17	108.07	106.87	107.72	1632825.0
2015-07-01	ABCB	Stock	25.54	25.59	25.21	25.24	141200.0
2015-07-01	ABCD-DELISTED	Stock	4.26	4.28	4.2	4.27	35688.0
2015-07-01	ABCO-DELISTED	Stock	55.03	55.33	53.8	54.39	369211.0
2015-07-01	ABCW-DELISTED	Stock	38.85	39.25	38.4	39.02	34931.0
2015-07-01	ABDC-DELISTED	Stock	12.73	12.9	12.35	12.4599	93233.0
2015-07-01	ABE-DELISTED	Stock	12.86	12.93	12.8457	12.8916	13478.0
2015-07-01	ABEO	Stock	126.5	132.0	124.5	124.75	19244.0
2015-07-01	ABEOW-DELISTED	Stock	1.9	1.99	1.65	1.65	4503.0
2015-07-01	ABEV	Stock	6.12	6.15	6.05	6.08	9925600.0
2015-07-01	ABG	Stock	91.44	93.08	91.3	92.27	291700.0
2015-07-01	ABGB-DELISTED	Stock	16.83	16.9699	16.55	16.72	9411.0
2015-07-01	ABIL-DELISTED	Stock	10.0	10.0	10.0	10.0	100.0

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

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