PREVIEW / stock_daily / 2017-06-30

all stock daily files

  file:    by_date/stock_daily/2017/2017-06-30.parquet
  size:    214 KB
  rows:    6,447
  symbols: 2,983

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-06-30	AAPL	Stock	36.1125	36.24	35.945	36.005	92096400.0
2017-06-30	MSFT	Stock	68.78	69.38	68.74	68.93	24161100.0
2017-06-30	NVDA	Stock	3.6845	3.6982	3.5875	3.614	731060000.0
2017-06-30	AMZN	Stock	49.006	49.1735	48.3805	48.4	67806000.0
2017-06-30	GOOGL	Stock	47.1995	47.25	46.4805	46.484	45753240.0
2017-06-30	META	Stock	151.9	151.92	150.06	150.98	17666000.0
2017-06-30	TSLA	Stock	24.2473	24.4513	23.9747	24.1073	87727500.0
2017-06-30	TLT	Stock	125.19	125.39	124.85	125.12	10189811.0
2017-06-30	ES	Stock	60.7	61.16	60.59	60.71	1799300.0
2017-06-30	CL	Stock	74.31	74.47	74.12	74.13	3619100.0
2017-06-30	A	Stock	59.0	59.57	58.84	59.31	1593800.0
2017-06-30	AA	Stock	33.16	33.45	32.535	32.65	3032300.0
2017-06-30	AAAP-DELISTED	Stock	39.11	39.38	38.67	39.04	37361.0
2017-06-30	AABA-DELISTED	Stock	54.33	54.73	54.075	54.49	7883209.0
2017-06-30	AAC-DELISTED	Stock	7.08	7.1	6.83	6.94	20355.0
2017-06-30	AACG	Stock	4.73	4.73	4.22	4.54	15100.0
2017-06-30	AAIC-DELISTED	Stock	13.82	13.84	13.5932	13.67	492506.0
2017-06-30	AAL	Stock	49.92	50.51	49.6	50.32	6618700.0
2017-06-30	AAM.A-DELISTED	Stock	25.66	25.74	25.66	25.74	27176.0
2017-06-30	AAMC-DELISTED	Stock	25.7206	27.2794	25.5294	26.8821	58174.0
2017-06-30	AAME	Stock	3.5	3.75	3.5	3.75	3900.0
2017-06-30	AAMI	Stock	14.96	15.0	14.765	14.86	1217600.0
2017-06-30	AAOI	Stock	61.74	63.62	60.43	61.79	2414000.0
2017-06-30	AAON	Stock	24.3	24.6333	24.0667	24.5667	164250.0
2017-06-30	AAP	Stock	116.45	117.82	116.03	116.59	994900.0
2017-06-30	AAT	Stock	40.03	40.18	39.33	39.39	201100.0
2017-06-30	AAU-DELISTED	Stock	1.32	1.32	1.24	1.24	233472.0
2017-06-30	AAUAF-DELISTED	Stock	1.32	1.32	1.24	1.26	237929.0
2017-06-30	AAV-DELISTED	Stock	6.6	6.8	6.6	6.75	79400.0
2017-06-30	AAWW-DELISTED	Stock	51.05	52.55	50.7	52.125	314863.0
2017-06-30	AAXJ	Stock	67.5	67.669	67.37	67.45	361040.0
2017-06-30	AAXN-DELISTED	Stock	25.2	25.46	24.97	25.13	339414.0
2017-06-30	AB	Stock	23.25	23.9	23.25	23.65	231600.0
2017-06-30	ABAC-DELISTED	Stock	2.08	2.2795	2.08	2.1001	24793.0
2017-06-30	ABAX-DELISTED	Stock	52.93	54.0769	52.35	52.97	69554.0
2017-06-30	ABB-DELISTED	Stock	24.89	24.95	24.71	24.9	2836882.0
2017-06-30	ABBNY-DELISTED	Stock	24.89	24.95	24.71	24.9	2889181.0
2017-06-30	ABBV	Stock	72.57	72.82	72.21	72.51	4729100.0
2017-06-30	ABC-DELISTED	Stock	94.83	95.23	93.35	94.52	1009983.0
2017-06-30	ABCB	Stock	48.8	49.25	48.1	48.2	180800.0
2017-06-30	ABCD-DELISTED	Stock	5.02	5.07	4.98	5.07	6756.0
2017-06-30	ABCO-DELISTED	Stock	51.3	51.8	51.05	51.5	323021.0
2017-06-30	ABDC-DELISTED	Stock	13.5001	13.62	13.25	13.48	79426.0
2017-06-30	ABE-DELISTED	Stock	13.84	13.84	13.775	13.8072	745.0
2017-06-30	ABEO	Stock	156.25	161.25	153.0	160.0	8868.0
2017-06-30	ABEOW-DELISTED	Stock	3.4	3.402	3.4	3.402	1500.0
2017-06-30	ABEV	Stock	5.5	5.55	5.48	5.49	21029900.0
2017-06-30	ABG	Stock	56.1	56.85	55.88	56.55	181700.0
2017-06-30	ABIL-DELISTED	Stock	1.29	1.325	1.22	1.28	187531.0
2017-06-30	ABM	Stock	41.6	41.87	41.42	41.52	164400.0

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

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