PREVIEW / stock_daily / 2017-07-26

all stock daily files

  file:    by_date/stock_daily/2017/2017-07-26.parquet
  size:    214 KB
  rows:    6,425
  symbols: 2,962

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-07-26	AAPL	Stock	38.3375	38.4825	38.265	38.365	63124000.0
2017-07-26	MSFT	Stock	74.34	74.38	73.81	74.05	16252200.0
2017-07-26	NVDA	Stock	4.192	4.2483	4.1462	4.1815	640404000.0
2017-07-26	AMZN	Stock	52.16	52.66	52.16	52.64	58426000.0
2017-07-26	GOOGL	Stock	48.639	48.6975	48.0115	48.2655	44432500.0
2017-07-26	META	Stock	166.01	166.01	164.1	165.61	35236900.0
2017-07-26	TSLA	Stock	22.6907	23.0333	22.5413	22.9233	72312000.0
2017-07-26	TLT	Stock	123.27	124.09	123.08	123.77	8459547.0
2017-07-26	ES	Stock	60.4	60.96	60.3	60.94	944800.0
2017-07-26	CL	Stock	71.83	74.59	71.56	73.0	6080800.0
2017-07-26	A	Stock	60.58	60.81	59.39	59.72	2520700.0
2017-07-26	AA	Stock	37.42	37.61	36.56	36.63	3451000.0
2017-07-26	AAAP-DELISTED	Stock	41.9	42.47	40.081	42.47	39288.0
2017-07-26	AABA-DELISTED	Stock	57.95	59.03	57.93	58.91	4139287.0
2017-07-26	AAC-DELISTED	Stock	6.65	6.69	6.39	6.46	102572.0
2017-07-26	AACG	Stock	4.66	4.66	4.56	4.66	3400.0
2017-07-26	AAIC-DELISTED	Stock	12.81	12.91	12.72	12.8	614935.0
2017-07-26	AAL	Stock	50.63	51.17	50.01	51.01	4776100.0
2017-07-26	AAM.A-DELISTED	Stock	25.83	26.08	25.83	26.08	46036.0
2017-07-26	AAMC-DELISTED	Stock	26.7941	27.3529	26.7941	27.25	3325.0
2017-07-26	AAME	Stock	3.6	3.65	3.5	3.6	1500.0
2017-07-26	AAMI	Stock	15.2	15.225	15.07	15.12	842800.0
2017-07-26	AAOI	Stock	96.0	99.98	95.203	98.76	3394700.0
2017-07-26	AAON	Stock	23.5	23.5	22.8667	22.9333	234150.0
2017-07-26	AAP	Stock	105.73	107.48	105.18	106.7	1700200.0
2017-07-26	AAT	Stock	40.03	40.43	39.54	40.11	139700.0
2017-07-26	AAU-DELISTED	Stock	1.21	1.26	1.21	1.235	185743.0
2017-07-26	AAUAF-DELISTED	Stock	1.21	1.26	1.21	1.235	194008.0
2017-07-26	AAV-DELISTED	Stock	7.05	7.25	7.05	7.1	66231.0
2017-07-26	AAWW-DELISTED	Stock	58.95	58.95	57.725	58.45	196013.0
2017-07-26	AAXJ	Stock	70.85	71.25	70.75	71.23	646165.0
2017-07-26	AAXN-DELISTED	Stock	25.47	25.48	24.96	25.21	328545.0
2017-07-26	AB	Stock	25.0	25.3	24.85	24.9	309100.0
2017-07-26	ABAC-DELISTED	Stock	2.11	2.29	2.1	2.22	20231.0
2017-07-26	ABAX-DELISTED	Stock	51.8	51.8	51.0	51.31	70986.0
2017-07-26	ABB-DELISTED	Stock	23.41	23.43	23.26	23.395	2238854.0
2017-07-26	ABBNY-DELISTED	Stock	23.4	23.43	23.26	23.39	2450723.0
2017-07-26	ABBV	Stock	72.37	72.69	71.95	72.59	4877000.0
2017-07-26	ABC-DELISTED	Stock	94.27	94.725	93.41	94.2	1065546.0
2017-07-26	ABCB	Stock	47.25	47.25	45.95	45.95	135100.0
2017-07-26	ABCD-DELISTED	Stock	4.9	4.99	4.85	4.85	9617.0
2017-07-26	ABCO-DELISTED	Stock	57.2	57.2	55.85	56.05	314229.0
2017-07-26	ABDC-DELISTED	Stock	12.06	12.22	11.8	11.88	169366.0
2017-07-26	ABE-DELISTED	Stock	14.08	14.19	14.08	14.1704	4070.0
2017-07-26	ABEO	Stock	226.25	226.25	212.5	217.5	15588.0
2017-07-26	ABEOW-DELISTED	Stock	4.51	4.97	4.5	4.7303	2832.0
2017-07-26	ABEV	Stock	5.88	5.96	5.87	5.94	9716600.0
2017-07-26	ABG	Stock	53.25	53.95	52.65	53.8	398900.0
2017-07-26	ABIL-DELISTED	Stock	0.94	0.94	0.8211	0.9087	45086.0
2017-07-26	ABM	Stock	44.44	44.69	44.25	44.58	210400.0

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

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