PREVIEW / stock_daily / 2017-10-30

all stock daily files

  file:    by_date/stock_daily/2017/2017-10-30.parquet
  size:    214 KB
  rows:    6,442
  symbols: 2,895

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-10-30	AAPL	Stock	40.9725	42.0175	40.93	41.68	178803200.0
2017-10-30	MSFT	Stock	83.7	84.33	83.11	83.89	31756700.0
2017-10-30	NVDA	Stock	5.0465	5.1523	5.0305	5.096	504056000.0
2017-10-30	AMZN	Stock	54.7505	56.1395	54.678	55.5425	132262000.0
2017-10-30	GOOGL	Stock	51.458	51.9915	51.1165	51.6565	46803440.0
2017-10-30	META	Stock	179.26	180.69	177.61	179.87	24353200.0
2017-10-30	TSLA	Stock	21.2787	21.5853	21.15	21.3387	63816000.0
2017-10-30	TLT	Stock	123.86	124.46	123.56	124.42	9051612.0
2017-10-30	ES	Stock	62.62	62.66	62.11	62.49	1925100.0
2017-10-30	CL	Stock	70.14	70.48	69.05	69.2	4444500.0
2017-10-30	A	Stock	67.8	67.93	67.1	67.49	846600.0
2017-10-30	AA	Stock	47.75	48.38	47.37	47.42	2072400.0
2017-10-30	AAAP-DELISTED	Stock	80.35	80.7	80.0	80.5	8479683.0
2017-10-30	AABA-DELISTED	Stock	68.09	68.96	67.94	68.86	7225210.0
2017-10-30	AAC-DELISTED	Stock	8.55	8.55	8.11	8.21	60001.0
2017-10-30	AACG	Stock	4.7	4.7	4.64	4.64	1700.0
2017-10-30	AAIC-DELISTED	Stock	11.61	11.7401	11.54	11.57	390817.0
2017-10-30	AAL	Stock	47.65	47.67	46.83	47.25	5402500.0
2017-10-30	AAM.A-DELISTED	Stock	26.15	26.1738	26.1286	26.13	11711.0
2017-10-30	AAME	Stock	3.5	3.55	3.5	3.55	4100.0
2017-10-30	AAMI	Stock	15.59	15.59	15.26	15.42	402500.0
2017-10-30	AAOI	Stock	39.3	42.25	38.89	42.12	1850700.0
2017-10-30	AAON	Stock	23.0333	23.1333	22.6333	22.8667	265200.0
2017-10-30	AAP	Stock	81.93	82.13	81.13	82.0	2309800.0
2017-10-30	AAT	Stock	39.4	39.46	38.96	39.04	202700.0
2017-10-30	AAU-DELISTED	Stock	1.01	1.02	1.0	1.01	318550.0
2017-10-30	AAUAF-DELISTED	Stock	1.01	1.02	1.0	1.01	336267.0
2017-10-30	AAV-DELISTED	Stock	5.2	5.4	5.2	5.35	57039.0
2017-10-30	AAWW-DELISTED	Stock	61.95	61.95	60.75	61.55	196439.0
2017-10-30	AAXJ	Stock	74.63	74.875	74.4475	74.59	548749.0
2017-10-30	AAXN-DELISTED	Stock	22.76	22.91	22.66	22.89	549351.0
2017-10-30	AB	Stock	26.3	26.65	26.05	26.1	492900.0
2017-10-30	ABAC-DELISTED	Stock	3.3	3.39	3.2601	3.3299	5073.0
2017-10-30	ABAX-DELISTED	Stock	49.12	49.12	47.3026	47.85	58589.0
2017-10-30	ABB-DELISTED	Stock	25.32	25.41	25.25	25.39	1294862.0
2017-10-30	ABBNY-DELISTED	Stock	25.32	25.41	25.25	25.38	1349011.0
2017-10-30	ABBV	Stock	91.7	92.06	88.91	90.96	6526200.0
2017-10-30	ABC-DELISTED	Stock	76.01	77.78	76.01	76.93	1850396.0
2017-10-30	ABCB	Stock	48.75	48.75	47.5	47.9	158100.0
2017-10-30	ABCD-DELISTED	Stock	5.93	5.95	5.8	5.92	56746.0
2017-10-30	ABCO-DELISTED	Stock	53.8	53.9	53.75	53.85	225853.0
2017-10-30	ABDC-DELISTED	Stock	9.8	9.9075	9.4009	9.51	115381.0
2017-10-30	ABE-DELISTED	Stock	14.47	14.47	14.41	14.42	7300.0
2017-10-30	ABEO	Stock	435.0	439.0	426.25	436.25	26036.0
2017-10-30	ABEV	Stock	6.35	6.38	6.31	6.35	26963700.0
2017-10-30	ABG	Stock	60.8	61.0	59.15	60.85	234000.0
2017-10-30	ABIL-DELISTED	Stock	0.6336	0.68	0.6336	0.67	116402.0
2017-10-30	ABLX-DELISTED	Stock	20.27	20.52	20.14	20.355	205435.0
2017-10-30	ABM	Stock	42.12	42.27	41.72	41.99	200300.0
2017-10-30	ABMD-DELISTED	Stock	179.56	180.12	177.4	179.48	321054.0

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

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