PREVIEW / stock_daily / 2017-09-05

all stock daily files

  file:    by_date/stock_daily/2017/2017-09-05.parquet
  size:    214 KB
  rows:    6,475
  symbols: 2,964

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-05	AAPL	Stock	40.9375	41.0625	40.14	40.52	117874000.0
2017-09-05	MSFT	Stock	73.34	73.89	72.98	73.61	21556000.0
2017-09-05	NVDA	Stock	4.2095	4.2145	4.089	4.1478	695364000.0
2017-09-05	AMZN	Stock	48.77	48.8385	48.0185	48.2635	57664000.0
2017-09-05	GOOGL	Stock	47.343	47.5693	46.78	47.074	29216600.0
2017-09-05	META	Stock	171.27	172.39	169.55	170.72	13210900.0
2017-09-05	TSLA	Stock	23.5867	23.6993	23.0593	23.306	57526500.0
2017-09-05	TLT	Stock	127.69	128.8	127.69	128.76	15220687.0
2017-09-05	ES	Stock	62.62	62.96	62.36	62.95	1315800.0
2017-09-05	CL	Stock	71.1	71.44	70.77	71.11	2795100.0
2017-09-05	A	Stock	64.02	64.48	63.81	64.29	910200.0
2017-09-05	AA	Stock	45.08	45.12	43.7	44.42	5223000.0
2017-09-05	AAAP-DELISTED	Stock	46.25	51.8708	46.25	50.23	276054.0
2017-09-05	AABA-DELISTED	Stock	63.53	64.3	63.28	63.86	2839717.0
2017-09-05	AAC-DELISTED	Stock	9.8	9.95	9.58	9.82	67483.0
2017-09-05	AACG	Stock	4.62	4.65	4.6	4.6	1900.0
2017-09-05	AAIC-DELISTED	Stock	13.06	13.06	12.795	12.82	312881.0
2017-09-05	AAL	Stock	44.79	45.28	43.84	43.92	8501600.0
2017-09-05	AAM.A-DELISTED	Stock	26.139	26.14	26.04	26.14	28777.0
2017-09-05	AAMC-DELISTED	Stock	28.3971	29.1176	27.6471	29.1176	12111.0
2017-09-05	AAME	Stock	3.35	3.45	3.3	3.4	4800.0
2017-09-05	AAMI	Stock	13.9	13.99	13.46	13.51	525000.0
2017-09-05	AAOI	Stock	58.39	59.0	55.13	56.09	2746600.0
2017-09-05	AAON	Stock	21.7667	22.0	21.5333	21.5667	153900.0
2017-09-05	AAP	Stock	97.71	98.92	96.28	96.73	1191700.0
2017-09-05	AAT	Stock	40.77	41.19	40.47	40.6	239600.0
2017-09-05	AAU-DELISTED	Stock	1.3	1.32	1.21	1.23	336743.0
2017-09-05	AAUAF-DELISTED	Stock	1.3	1.32	1.21	1.24	406060.0
2017-09-05	AAV-DELISTED	Stock	6.45	6.55	6.3	6.35	92663.0
2017-09-05	AAWW-DELISTED	Stock	67.7	68.25	66.0	66.35	272086.0
2017-09-05	AAXJ	Stock	71.71	71.88	71.15	71.41	1022182.0
2017-09-05	AAXN-DELISTED	Stock	21.66	21.98	21.53	21.97	342717.0
2017-09-05	AB	Stock	23.35	23.6	23.15	23.35	245500.0
2017-09-05	ABAC-DELISTED	Stock	2.07	2.12	2.07	2.12	4300.0
2017-09-05	ABAX-DELISTED	Stock	45.91	46.67	45.91	46.23	68808.0
2017-09-05	ABB-DELISTED	Stock	23.69	23.75	23.465	23.56	1816252.0
2017-09-05	ABBNY-DELISTED	Stock	23.71	23.75	23.465	23.57	1871282.0
2017-09-05	ABBV	Stock	75.39	75.58	74.73	75.25	6309100.0
2017-09-05	ABC-DELISTED	Stock	79.81	80.78	79.05	79.69	934893.0
2017-09-05	ABCB	Stock	44.45	44.45	43.33	43.35	277600.0
2017-09-05	ABCD-DELISTED	Stock	6.1	6.35	6.04	6.1201	158009.0
2017-09-05	ABCO-DELISTED	Stock	53.3	53.45	53.15	53.3	3497592.0
2017-09-05	ABDC-DELISTED	Stock	10.73	11.04	10.73	10.88	51453.0
2017-09-05	ABE-DELISTED	Stock	14.22	14.22	13.89	13.89	3340.0
2017-09-05	ABEO	Stock	346.25	381.25	332.5	355.0	88308.0
2017-09-05	ABEOW-DELISTED	Stock	9.0	10.0	8.55	9.05	6850.0
2017-09-05	ABEV	Stock	6.31	6.34	6.26	6.29	23716200.0
2017-09-05	ABG	Stock	54.3	54.8	53.9	54.7	113200.0
2017-09-05	ABIL-DELISTED	Stock	0.8	0.85	0.79	0.81	162950.0
2017-09-05	ABM	Stock	44.56	44.75	43.94	44.03	162500.0

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

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