PREVIEW / stock_daily / 2017-06-23

all stock daily files

  file:    by_date/stock_daily/2017/2017-06-23.parquet
  size:    216 KB
  rows:    6,460
  symbols: 2,979

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-23	AAPL	Stock	36.2825	36.79	36.2775	36.57	141757600.0
2017-06-23	MSFT	Stock	70.09	71.25	69.92	71.21	27617300.0
2017-06-23	NVDA	Stock	3.967	3.983	3.8305	3.8458	1088588000.0
2017-06-23	AMZN	Stock	50.127	50.231	49.901	50.187	57582000.0
2017-06-23	GOOGL	Stock	48.775	49.331	48.723	49.3045	31279700.0
2017-06-23	META	Stock	152.72	155.2	152.65	155.07	18027000.0
2017-06-23	TSLA	Stock	25.4967	25.7993	25.29	25.5633	96687000.0
2017-06-23	TLT	Stock	127.47	127.9	127.4	127.78	4329910.0
2017-06-23	ES	Stock	62.12	62.57	62.11	62.25	1485200.0
2017-06-23	CL	Stock	75.63	76.48	75.45	75.92	3114300.0
2017-06-23	A	Stock	60.59	60.59	59.5	59.77	2879800.0
2017-06-23	AA	Stock	30.13	31.43	29.79	31.09	6410900.0
2017-06-23	AAAP-DELISTED	Stock	39.33	40.0	38.535	39.9	69147.0
2017-06-23	AABA-DELISTED	Stock	54.49	54.99	54.45	54.74	12254464.0
2017-06-23	AAC-DELISTED	Stock	7.21	7.21	6.86	7.02	351634.0
2017-06-23	AACG	Stock	4.84	4.84	4.74	4.83	7000.0
2017-06-23	AAIC-DELISTED	Stock	14.68	14.87	14.63	14.82	561756.0
2017-06-23	AAL	Stock	49.0	49.1	48.47	48.63	12682000.0
2017-06-23	AAM.A-DELISTED	Stock	25.99	25.99	25.9	25.91	31528.0
2017-06-23	AAMC-DELISTED	Stock	26.7647	28.1618	26.0	26.4412	112027.0
2017-06-23	AAME	Stock	3.65	3.75	3.6	3.65	1900.0
2017-06-23	AAMI	Stock	14.55	14.82	14.46	14.71	2575000.0
2017-06-23	AAOI	Stock	63.6	67.18	63.35	65.87	2987900.0
2017-06-23	AAON	Stock	24.0	24.1667	23.9	24.1333	246150.0
2017-06-23	AAP	Stock	120.75	121.43	118.75	119.74	2289600.0
2017-06-23	AAT	Stock	39.8	40.29	39.72	39.87	426200.0
2017-06-23	AAU-DELISTED	Stock	1.36	1.39	1.34	1.38	145397.0
2017-06-23	AAUAF-DELISTED	Stock	1.36	1.39	1.34	1.37	148161.0
2017-06-23	AAV-DELISTED	Stock	6.2	6.4	6.15	6.35	66633.0
2017-06-23	AAWW-DELISTED	Stock	50.9	51.85	50.65	51.0	429394.0
2017-06-23	AAXJ	Stock	67.7	67.93	67.63	67.82	240162.0
2017-06-23	AAXN-DELISTED	Stock	26.32	26.42	26.14	26.32	341452.0
2017-06-23	AB	Stock	23.45	23.75	23.35	23.5	234500.0
2017-06-23	ABAC-DELISTED	Stock	2.0121	2.0631	2.0121	2.0631	1700.0
2017-06-23	ABAX-DELISTED	Stock	51.77	52.66	51.67	52.48	84940.0
2017-06-23	ABB-DELISTED	Stock	25.21	25.44	25.2	25.395	1276864.0
2017-06-23	ABBNY-DELISTED	Stock	25.21	25.44	25.2	25.4	1315078.0
2017-06-23	ABBV	Stock	73.2	73.49	72.26	72.64	7064500.0
2017-06-23	ABC-DELISTED	Stock	96.5	96.809	95.3	95.83	1472154.0
2017-06-23	ABCB	Stock	46.15	46.45	45.65	46.4	277700.0
2017-06-23	ABCD-DELISTED	Stock	4.98	5.21	4.96	5.12	112303.0
2017-06-23	ABCO-DELISTED	Stock	50.95	51.45	50.85	51.2	244489.0
2017-06-23	ABDC-DELISTED	Stock	13.47	13.49	13.33	13.46	29134.0
2017-06-23	ABE-DELISTED	Stock	14.0	14.04	14.0	14.0364	2622.0
2017-06-23	ABEO	Stock	141.25	151.25	133.75	150.0	113856.0
2017-06-23	ABEV	Stock	5.42	5.47	5.4	5.44	20085700.0
2017-06-23	ABG	Stock	52.15	52.55	51.5	52.25	433100.0
2017-06-23	ABIL-DELISTED	Stock	1.16	1.35	1.11	1.2401	256443.0
2017-06-23	ABM	Stock	41.57	41.85	41.5	41.68	1012600.0
2017-06-23	ABMD-DELISTED	Stock	144.98	145.58	144.29	144.49	212867.0

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

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