PREVIEW / stock_daily / 2015-07-16

all stock daily files

  file:    by_date/stock_daily/2015/2015-07-16.parquet
  size:    224 KB
  rows:    6,680
  symbols: 3,497

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-16	AAPL	Stock	31.935	32.1425	31.8375	32.1275	144889600.0
2015-07-16	MSFT	Stock	46.01	46.69	45.97	46.66	26271700.0
2015-07-16	NVDA	Stock	0.4968	0.5048	0.495	0.5048	282848000.0
2015-07-16	AMZN	Stock	23.275	23.794	23.24	23.774	81912000.0
2015-07-16	GOOGL	Stock	29.475	30.225	29.396	30.089	112641080.0
2015-07-16	META	Stock	90.28	90.86	89.77	90.85	21804100.0
2015-07-16	TSLA	Stock	17.6147	17.8133	17.544	17.7787	24240000.0
2015-07-16	TLT	Stock	116.89	118.16	116.87	118.11	7306517.0
2015-07-16	ES	Stock	47.68	48.4	47.58	48.3	1080400.0
2015-07-16	CL	Stock	67.33	67.73	67.18	67.62	1912000.0
2015-07-16	A	Stock	40.36	40.44	40.12	40.34	1826300.0
2015-07-16	AA.B-DELISTED	Stock	38.6101	38.8399	38.0	38.56	26883.0
2015-07-16	AABA-DELISTED	Stock	38.7	38.96	38.6	38.905	7790964.0
2015-07-16	AAC-DELISTED	Stock	42.83	43.82	42.1101	43.35	206397.0
2015-07-16	AACG	Stock	4.35	4.49	4.1	4.41	32400.0
2015-07-16	AAIC-DELISTED	Stock	20.07	20.2099	19.97	20.1	249754.0
2015-07-16	AAL	Stock	41.81	42.22	41.3	41.39	12111300.0
2015-07-16	AAMC-DELISTED	Stock	43.5882	45.0147	43.2324	43.2647	17156.0
2015-07-16	AAME	Stock	3.7	3.7	3.7	3.7	2100.0
2015-07-16	AAMI	Stock	17.77	18.03	17.76	17.88	151000.0
2015-07-16	AAOI	Stock	19.3	19.54	18.835	19.28	499000.0
2015-07-16	AAON	Stock	15.12	15.26	14.9733	15.02	210900.0
2015-07-16	AAP	Stock	168.91	169.82	168.27	169.36	572400.0
2015-07-16	AAT	Stock	40.96	41.69	40.96	41.49	105000.0
2015-07-16	AAU-DELISTED	Stock	0.757	0.7683	0.75	0.75	44317.0
2015-07-16	AAUAF-DELISTED	Stock	0.757	0.7683	0.75	0.75	44758.0
2015-07-16	AAV-DELISTED	Stock	6.07	6.1235	5.9701	6.0	61175.0
2015-07-16	AAVL-DELISTED	Stock	16.56	16.84	16.47	16.49	257969.0
2015-07-16	AAWW-DELISTED	Stock	52.41	52.915	51.63	51.87	521162.0
2015-07-16	AAXJ	Stock	61.2	61.6	61.16	61.53	966831.0
2015-07-16	AAXN-DELISTED	Stock	32.93	34.8	32.93	34.36	2679044.0
2015-07-16	AB	Stock	27.49	28.45	27.49	28.31	387400.0
2015-07-16	ABAC-DELISTED	Stock	1.11	1.11	1.11	1.11	700.0
2015-07-16	ABAX-DELISTED	Stock	54.37	54.44	53.85	54.19	76773.0
2015-07-16	ABB-DELISTED	Stock	20.85	20.89	20.74	20.78	1445081.0
2015-07-16	ABBNY-DELISTED	Stock	20.85	20.89	20.74	20.77	1559426.0
2015-07-16	ABBV	Stock	70.14	70.3	69.83	69.99	6843800.0
2015-07-16	ABC-DELISTED	Stock	111.0	111.93	109.93	111.85	1502574.0
2015-07-16	ABCB	Stock	26.27	26.41	26.02	26.12	96900.0
2015-07-16	ABCD-DELISTED	Stock	4.91	5.11	4.87	4.88	107267.0
2015-07-16	ABCO-DELISTED	Stock	59.65	60.35	58.35	58.85	619680.0
2015-07-16	ABCW-DELISTED	Stock	41.4	41.72	40.675	41.21	19887.0
2015-07-16	ABDC-DELISTED	Stock	12.64	13.34	12.64	12.99	54011.0
2015-07-16	ABE-DELISTED	Stock	13.14	13.21	13.058	13.2	16506.0
2015-07-16	ABEO	Stock	152.5	154.5	140.0	141.5	12688.0
2015-07-16	ABEOW-DELISTED	Stock	2.16	2.2	1.6	1.95	11124.0
2015-07-16	ABEV	Stock	6.28	6.3	6.17	6.21	14511700.0
2015-07-16	ABG	Stock	94.17	94.49	93.52	94.03	306700.0
2015-07-16	ABGB-DELISTED	Stock	15.94	16.01	15.7	15.72	22780.0
2015-07-16	ABIL-DELISTED	Stock	9.95	9.99	9.95	9.99	3440.0

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

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