PREVIEW / stock_daily / 2015-09-22

all stock daily files

  file:    by_date/stock_daily/2015/2015-09-22.parquet
  size:    220 KB
  rows:    6,625
  symbols: 3,427

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-09-22	AAPL	Stock	28.345	28.545	28.13	28.35	201384800.0
2015-09-22	MSFT	Stock	43.38	44.05	43.31	43.9	28085900.0
2015-09-22	NVDA	Stock	0.5755	0.5795	0.5692	0.5722	228356000.0
2015-09-22	AMZN	Stock	26.9855	27.1775	26.633	26.92	76834000.0
2015-09-22	GOOGL	Stock	32.8735	32.941	32.2515	32.66	54361620.0
2015-09-22	META	Stock	93.77	94.68	91.92	92.96	36888900.0
2015-09-22	TSLA	Stock	17.2687	17.51	17.058	17.396	54966000.0
2015-09-22	TLT	Stock	121.44	122.39	121.14	121.78	9968204.0
2015-09-22	ES	Stock	47.33	47.68	47.09	47.47	1634100.0
2015-09-22	CL	Stock	62.5	62.73	61.74	62.16	3911000.0
2015-09-22	A	Stock	35.19	35.33	34.94	35.05	2283300.0
2015-09-22	AA.B-DELISTED	Stock	35.0	35.0	33.84	34.4	93067.0
2015-09-22	AABA-DELISTED	Stock	30.78	30.92	30.17	30.4	14013099.0
2015-09-22	AAC-DELISTED	Stock	23.18	23.4499	22.24	23.16	214395.0
2015-09-22	AACG	Stock	2.48	2.64	2.44	2.47	38100.0
2015-09-22	AAIC-DELISTED	Stock	15.96	16.08	15.796	15.85	396563.0
2015-09-22	AAL	Stock	42.77	43.08	40.92	41.19	12483700.0
2015-09-22	AAMC-DELISTED	Stock	7.2706	7.5676	7.0324	7.3706	34102.0
2015-09-22	AAME	Stock	3.71	3.76	3.68	3.76	10000.0
2015-09-22	AAMI	Stock	15.79	15.96	15.58	15.84	206300.0
2015-09-22	AAOI	Stock	19.39	19.48	18.71	18.9	217600.0
2015-09-22	AAON	Stock	13.2533	13.2733	13.0267	13.1667	158550.0
2015-09-22	AAP	Stock	173.68	175.0	172.54	174.44	662300.0
2015-09-22	AAT	Stock	39.94	40.21	39.47	39.64	284500.0
2015-09-22	AAU-DELISTED	Stock	0.52	0.55	0.52	0.54	25543.0
2015-09-22	AAUAF-DELISTED	Stock	0.52	0.55	0.52	0.54	26048.0
2015-09-22	AAV-DELISTED	Stock	5.4	5.57	5.39	5.54	60058.0
2015-09-22	AAVL-DELISTED	Stock	10.29	10.46	9.95	10.17	588447.0
2015-09-22	AAWW-DELISTED	Stock	37.64	37.958	36.96	37.33	379422.0
2015-09-22	AAXJ	Stock	53.24	53.3	52.92	53.24	956656.0
2015-09-22	AAXN-DELISTED	Stock	23.41	23.78	23.18	23.36	1302942.0
2015-09-22	AB	Stock	26.5	27.0	26.33	26.57	185700.0
2015-09-22	ABAC-DELISTED	Stock	0.66	0.6699	0.65	0.65	5727.0
2015-09-22	ABAX-DELISTED	Stock	47.16	47.36	46.61	46.94	119162.0
2015-09-22	ABB-DELISTED	Stock	17.75	17.78	17.56	17.69	2235504.0
2015-09-22	ABBNY-DELISTED	Stock	17.75	17.78	17.56	17.7	2851651.0
2015-09-22	ABBV	Stock	58.17	58.26	56.91	57.74	14192000.0
2015-09-22	ABC-DELISTED	Stock	104.34	104.5	102.66	103.25	2150328.0
2015-09-22	ABCB	Stock	27.85	28.17	27.63	27.76	98400.0
2015-09-22	ABCD-DELISTED	Stock	4.86	4.91	4.67	4.83	122392.0
2015-09-22	ABCO-DELISTED	Stock	47.87	48.5	47.31	47.74	155933.0
2015-09-22	ABCW-DELISTED	Stock	39.7	40.22	39.54	39.94	25726.0
2015-09-22	ABDC-DELISTED	Stock	12.81	12.99	12.67	12.9	12729.0
2015-09-22	ABE-DELISTED	Stock	11.03	11.12	11.03	11.12	639.0
2015-09-22	ABEO	Stock	124.0	128.5	119.5	121.0	7016.0
2015-09-22	ABEV	Stock	4.75	4.8	4.7	4.77	14048700.0
2015-09-22	ABG	Stock	83.67	83.9	82.32	83.65	272800.0
2015-09-22	ABGB-DELISTED	Stock	4.29	4.42	4.2	4.33	56516.0
2015-09-22	ABM	Stock	29.26	29.34	28.84	28.92	316300.0
2015-09-22	ABMD-DELISTED	Stock	101.22	103.48	100.02	102.75	362483.0

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

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