PREVIEW / stock_daily / 2017-09-01

all stock daily files

  file:    by_date/stock_daily/2017/2017-09-01.parquet
  size:    213 KB
  rows:    6,443
  symbols: 2,932

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-01	AAPL	Stock	41.2	41.235	40.9075	41.0125	66364400.0
2017-09-01	MSFT	Stock	74.71	74.74	73.64	73.94	21736200.0
2017-09-01	NVDA	Stock	4.2488	4.2975	4.24	4.2615	445432000.0
2017-09-01	AMZN	Stock	49.21	49.225	48.844	48.9125	50718000.0
2017-09-01	GOOGL	Stock	47.8735	47.9165	47.514	47.5995	20857700.0
2017-09-01	META	Stock	172.4	172.92	171.31	172.02	11677600.0
2017-09-01	TSLA	Stock	23.7413	23.8393	23.5793	23.6933	45742500.0
2017-09-01	TLT	Stock	127.31	127.34	126.43	126.75	14128576.0
2017-09-01	ES	Stock	63.18	63.18	62.51	62.57	1102500.0
2017-09-01	CL	Stock	71.66	71.75	71.04	71.3	2132400.0
2017-09-01	A	Stock	64.9	65.18	64.21	64.38	1224600.0
2017-09-01	AA	Stock	44.21	45.22	44.13	45.04	3376300.0
2017-09-01	AAAP-DELISTED	Stock	48.5	48.5	46.6	47.0	33338.0
2017-09-01	AABA-DELISTED	Stock	64.17	64.38	63.86	64.05	1995105.0
2017-09-01	AAC-DELISTED	Stock	9.29	9.84	9.29	9.82	60633.0
2017-09-01	AACG	Stock	4.65	4.69	4.6	4.65	7600.0
2017-09-01	AAIC-DELISTED	Stock	12.96	13.06	12.96	13.03	357797.0
2017-09-01	AAL	Stock	44.85	45.47	44.65	45.31	4569400.0
2017-09-01	AAM.A-DELISTED	Stock	26.0965	26.18	26.08	26.08	10998.0
2017-09-01	AAMC-DELISTED	Stock	26.4706	27.6471	26.1618	27.3529	18673.0
2017-09-01	AAME	Stock	3.39	3.4	3.3	3.3	2600.0
2017-09-01	AAMI	Stock	14.15	14.15	13.78	13.98	501800.0
2017-09-01	AAOI	Stock	59.25	60.17	58.4	58.98	1870800.0
2017-09-01	AAON	Stock	21.8	21.9667	21.7	21.8333	134850.0
2017-09-01	AAP	Stock	98.31	99.43	97.65	98.06	1095600.0
2017-09-01	AAT	Stock	40.6	40.88	40.35	40.75	159100.0
2017-09-01	AAU-DELISTED	Stock	1.19	1.21	1.15	1.21	189183.0
2017-09-01	AAUAF-DELISTED	Stock	1.19	1.21	1.15	1.21	192836.0
2017-09-01	AAV-DELISTED	Stock	6.4	6.5	6.35	6.45	33696.0
2017-09-01	AAWW-DELISTED	Stock	66.8	68.2	66.5	67.925	245772.0
2017-09-01	AAXJ	Stock	72.3	72.455	72.14	72.43	960087.0
2017-09-01	AAXN-DELISTED	Stock	21.73	21.98	21.64	21.72	292690.0
2017-09-01	AB	Stock	23.35	23.75	23.3	23.6	174200.0
2017-09-01	ABAC-DELISTED	Stock	2.08	2.2	2.08	2.12	23300.0
2017-09-01	ABAX-DELISTED	Stock	46.25	46.27	45.68	46.21	56241.0
2017-09-01	ABB-DELISTED	Stock	23.43	23.45	23.265	23.265	1071717.0
2017-09-01	ABBNY-DELISTED	Stock	23.43	23.45	23.26	23.26	1111385.0
2017-09-01	ABBV	Stock	75.59	76.0	75.26	75.42	3831700.0
2017-09-01	ABC-DELISTED	Stock	80.46	80.61	79.22	80.285	1064071.0
2017-09-01	ABCB	Stock	44.1	44.9	44.05	44.75	153900.0
2017-09-01	ABCD-DELISTED	Stock	5.95	6.06	5.71	6.0	82485.0
2017-09-01	ABCO-DELISTED	Stock	53.35	53.4	53.15	53.25	2191203.0
2017-09-01	ABDC-DELISTED	Stock	10.51	10.85	10.51	10.68	44756.0
2017-09-01	ABE-DELISTED	Stock	14.1893	14.2236	14.1893	14.22	952.0
2017-09-01	ABEO	Stock	326.25	349.75	322.75	345.0	59508.0
2017-09-01	ABEOW-DELISTED	Stock	7.8001	9.79	7.8	9.54	4400.0
2017-09-01	ABEV	Stock	6.32	6.34	6.24	6.24	14749900.0
2017-09-01	ABG	Stock	53.95	54.85	53.55	54.4	100000.0
2017-09-01	ABIL-DELISTED	Stock	0.84	0.8479	0.79	0.795	153013.0
2017-09-01	ABM	Stock	44.54	44.83	44.41	44.63	132800.0

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

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