PREVIEW / stock_daily / 2017-09-26

all stock daily files

  file:    by_date/stock_daily/2017/2017-09-26.parquet
  size:    214 KB
  rows:    6,436
  symbols: 2,921

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-26	AAPL	Stock	37.945	38.48	37.9225	38.285	146640000.0
2017-09-26	MSFT	Stock	73.67	73.81	72.99	73.26	18019600.0
2017-09-26	NVDA	Stock	4.4112	4.467	4.2588	4.299	1125620000.0
2017-09-26	AMZN	Stock	47.2745	47.4315	46.5875	46.93	71296000.0
2017-09-26	GOOGL	Stock	46.8345	47.204	46.756	46.8715	33454980.0
2017-09-26	META	Stock	164.5	165.5	162.78	164.21	23363300.0
2017-09-26	TSLA	Stock	23.3953	23.416	22.7267	23.0167	107344500.0
2017-09-26	TLT	Stock	126.77	126.885	126.43	126.76	7251877.0
2017-09-26	ES	Stock	61.49	61.64	61.18	61.34	1218900.0
2017-09-26	CL	Stock	73.0	73.54	72.56	73.39	3307000.0
2017-09-26	A	Stock	64.65	64.9	63.91	64.11	1615200.0
2017-09-26	AA	Stock	45.11	45.52	44.72	44.74	4539000.0
2017-09-26	AAAP-DELISTED	Stock	55.89	59.88	55.2	58.29	688262.0
2017-09-26	AABA-DELISTED	Stock	65.08	65.82	64.24	64.42	5623685.0
2017-09-26	AAC-DELISTED	Stock	10.13	10.5	10.0	10.16	100266.0
2017-09-26	AACG	Stock	4.77	4.77	4.67	4.71	7000.0
2017-09-26	AAIC-DELISTED	Stock	13.25	13.29	13.2	13.25	663207.0
2017-09-26	AAL	Stock	47.84	48.26	47.23	47.58	4706000.0
2017-09-26	AAM.A-DELISTED	Stock	26.19	26.2136	26.0928	26.18	16788.0
2017-09-26	AAMC-DELISTED	Stock	24.9514	25.1618	24.8382	25.1618	3655.0
2017-09-26	AAME	Stock	3.3	3.3	3.25	3.25	1000.0
2017-09-26	AAMI	Stock	14.21	14.37	14.16	14.22	408400.0
2017-09-26	AAOI	Stock	62.05	63.94	61.61	62.85	1741200.0
2017-09-26	AAON	Stock	22.3	22.6667	22.2333	22.4667	128550.0
2017-09-26	AAP	Stock	97.99	98.43	96.9	97.59	1175500.0
2017-09-26	AAT	Stock	40.18	40.47	40.0	40.32	158800.0
2017-09-26	AAU-DELISTED	Stock	1.16	1.17	1.12	1.14	97642.0
2017-09-26	AAUAF-DELISTED	Stock	1.16	1.17	1.12	1.12	100095.0
2017-09-26	AAV-DELISTED	Stock	6.6	6.6	6.5463	6.55	19521.0
2017-09-26	AAWW-DELISTED	Stock	66.1	66.425	65.15	65.3	459943.0
2017-09-26	AAXJ	Stock	71.82	71.89	71.47	71.54	912299.0
2017-09-26	AAXN-DELISTED	Stock	22.59	22.95	22.54	22.66	339802.0
2017-09-26	AB	Stock	24.45	24.63	24.25	24.3	184900.0
2017-09-26	ABAC-DELISTED	Stock	2.2	2.24	2.19	2.19	1500.0
2017-09-26	ABAX-DELISTED	Stock	44.74	44.81	43.83	43.89	92111.0
2017-09-26	ABB-DELISTED	Stock	24.57	24.6	24.46	24.56	919409.0
2017-09-26	ABBNY-DELISTED	Stock	24.58	24.6	24.46	24.56	955732.0
2017-09-26	ABBV	Stock	86.35	86.91	85.16	85.35	5862400.0
2017-09-26	ABC-DELISTED	Stock	81.41	82.65	81.33	82.02	832685.0
2017-09-26	ABCB	Stock	45.2	45.55	44.8	45.45	166600.0
2017-09-26	ABCD-DELISTED	Stock	6.41	6.87	6.37	6.6	297925.0
2017-09-26	ABCO-DELISTED	Stock	53.4	53.7	53.35	53.5	1092003.0
2017-09-26	ABDC-DELISTED	Stock	10.97	11.14	10.95	11.04	85331.0
2017-09-26	ABE-DELISTED	Stock	14.02	14.14	14.02	14.1162	6273.0
2017-09-26	ABEO	Stock	368.75	377.5	347.5	353.75	30356.0
2017-09-26	ABEOW-DELISTED	Stock	9.92	9.98	9.26	9.98	600.0
2017-09-26	ABEV	Stock	6.75	6.76	6.61	6.64	33633000.0
2017-09-26	ABG	Stock	60.25	61.8	60.25	61.6	116200.0
2017-09-26	ABIL-DELISTED	Stock	0.7629	1.01	0.7445	0.9078	2717192.0
2017-09-26	ABM	Stock	39.99	40.57	39.77	40.31	254200.0

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

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