PREVIEW / stock_daily / 2017-09-14

all stock daily files

  file:    by_date/stock_daily/2017/2017-09-14.parquet
  size:    214 KB
  rows:    6,441
  symbols: 2,935

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
2017-09-14	AAPL	Stock	39.7475	39.85	39.5225	39.57	95042800.0
2017-09-14	MSFT	Stock	75.0	75.49	74.52	74.77	15733900.0
2017-09-14	NVDA	Stock	4.2198	4.314	4.195	4.235	513712000.0
2017-09-14	AMZN	Stock	49.84	49.928	49.387	49.6105	78266000.0
2017-09-14	GOOGL	Stock	47.3	47.4015	46.9178	47.0065	28547580.0
2017-09-14	META	Stock	172.26	172.28	170.5	170.96	15615700.0
2017-09-14	TSLA	Stock	24.2887	25.1973	24.1753	25.176	108037500.0
2017-09-14	TLT	Stock	126.37	126.83	126.33	126.81	6674530.0
2017-09-14	ES	Stock	62.34	63.1	62.15	63.05	1446000.0
2017-09-14	CL	Stock	71.57	72.19	71.4	72.14	2011400.0
2017-09-14	A	Stock	65.31	65.87	65.16	65.68	1481000.0
2017-09-14	AA	Stock	44.48	45.0	43.75	44.8	4450600.0
2017-09-14	AAAP-DELISTED	Stock	54.83	58.975	53.07	56.94	318450.0
2017-09-14	AABA-DELISTED	Stock	66.26	66.905	65.72	66.01	10291655.0
2017-09-14	AAC-DELISTED	Stock	12.19	12.29	11.331	11.39	190349.0
2017-09-14	AACG	Stock	4.65	4.69	4.63	4.69	2300.0
2017-09-14	AAIC-DELISTED	Stock	13.11	13.19	13.09	13.12	209358.0
2017-09-14	AAL	Stock	46.79	46.94	46.12	46.19	5360500.0
2017-09-14	AAM.A-DELISTED	Stock	26.24	26.2799	26.12	26.26	40102.0
2017-09-14	AAMC-DELISTED	Stock	31.1324	32.1618	29.2529	32.1618	30964.0
2017-09-14	AAME	Stock	3.3	3.35	3.21	3.3	3900.0
2017-09-14	AAMI	Stock	13.83	13.83	13.625	13.64	450600.0
2017-09-14	AAOI	Stock	59.31	59.5	56.8	57.27	2058000.0
2017-09-14	AAON	Stock	21.7333	21.7667	21.4667	21.7667	102150.0
2017-09-14	AAP	Stock	100.09	100.09	99.0	100.02	1322700.0
2017-09-14	AAT	Stock	40.32	40.78	40.24	40.67	183500.0
2017-09-14	AAU-DELISTED	Stock	1.2	1.24	1.19	1.24	107467.0
2017-09-14	AAUAF-DELISTED	Stock	1.2	1.24	1.19	1.22	122300.0
2017-09-14	AAV-DELISTED	Stock	6.5	6.645	6.475	6.475	27642.0
2017-09-14	AAWW-DELISTED	Stock	66.75	67.3	65.85	65.95	115798.0
2017-09-14	AAXJ	Stock	72.47	72.69	72.35	72.6	738110.0
2017-09-14	AAXN-DELISTED	Stock	22.52	22.76	22.4	22.54	473856.0
2017-09-14	AB	Stock	23.85	24.1	23.8	23.9	184700.0
2017-09-14	ABAC-DELISTED	Stock	2.12	2.25	2.12	2.1899	4772.0
2017-09-14	ABAX-DELISTED	Stock	44.4	45.155	44.02	44.33	53310.0
2017-09-14	ABB-DELISTED	Stock	24.3	24.455	24.27	24.44	1017640.0
2017-09-14	ABBNY-DELISTED	Stock	24.3	24.455	24.27	24.43	1053828.0
2017-09-14	ABBV	Stock	88.23	89.32	88.15	89.22	10272200.0
2017-09-14	ABC-DELISTED	Stock	82.28	82.32	80.44	80.68	2580770.0
2017-09-14	ABCB	Stock	43.5	43.75	43.05	43.2	68000.0
2017-09-14	ABCD-DELISTED	Stock	6.07	6.3	6.0006	6.16	102163.0
2017-09-14	ABCO-DELISTED	Stock	53.5	53.7	53.5	53.6	834312.0
2017-09-14	ABDC-DELISTED	Stock	10.8	10.93	10.75	10.85	26876.0
2017-09-14	ABE-DELISTED	Stock	14.31	14.4	14.15	14.15	1884.0
2017-09-14	ABEO	Stock	348.75	355.75	343.75	350.0	26268.0
2017-09-14	ABEV	Stock	6.66	6.79	6.64	6.74	15329700.0
2017-09-14	ABG	Stock	59.1	59.3	58.3	58.45	153600.0
2017-09-14	ABIL-DELISTED	Stock	0.7441	0.8139	0.741	0.7698	350325.0
2017-09-14	ABM	Stock	39.97	39.97	39.49	39.76	301700.0
2017-09-14	ABMD-DELISTED	Stock	158.75	159.8	157.64	158.9	208038.0

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

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