PREVIEW / stock_daily / 2018-05-16

all stock daily files

  file:    by_date/stock_daily/2018/2018-05-16.parquet
  size:    218 KB
  rows:    6,515
  symbols: 2,822

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
2018-05-16	AAPL	Stock	46.5175	47.115	46.5	47.045	76732400.0
2018-05-16	MSFT	Stock	97.36	97.4	96.62	97.15	17384700.0
2018-05-16	NVDA	Stock	6.1	6.213	6.0628	6.1502	553828000.0
2018-05-16	AMZN	Stock	78.875	79.7215	78.8335	79.364	51412000.0
2018-05-16	GOOGL	Stock	54.2545	54.7191	54.0815	54.2045	25628120.0
2018-05-16	META	Stock	183.7	184.32	182.66	183.2	16975500.0
2018-05-16	TSLA	Stock	18.922	19.254	18.7707	19.0987	85110000.0
2018-05-16	TLT	Stock	117.42	117.53	116.79	116.8	6518040.0
2018-05-16	ES	Stock	57.49	57.86	57.21	57.44	2636800.0
2018-05-16	CL	Stock	61.63	62.41	61.5	62.09	3813900.0
2018-05-16	A	Stock	62.51	62.99	61.65	61.94	5872500.0
2018-05-16	AA	Stock	50.54	50.675	49.54	50.19	5433300.0
2018-05-16	AABA-DELISTED	Stock	76.35	77.43	76.35	77.02	1973567.0
2018-05-16	AAC-DELISTED	Stock	11.4	11.69	11.4	11.58	91434.0
2018-05-16	AACG	Stock	5.28	5.3	5.11	5.3	4500.0
2018-05-16	AAIC-DELISTED	Stock	10.94	11.03	10.92	10.94	492545.0
2018-05-16	AAL	Stock	43.13	44.91	43.04	44.06	7493600.0
2018-05-16	AAM.A-DELISTED	Stock	24.99	25.15	24.91	25.15	41132.0
2018-05-16	AAM.B-DELISTED	Stock	24.69	24.8	24.59	24.8	53904.0
2018-05-16	AAMC-DELISTED	Stock	19.1471	19.1471	18.7059	18.75	2819.0
2018-05-16	AAME	Stock	2.85	2.85	2.65	2.75	12100.0
2018-05-16	AAMI	Stock	15.53	15.62	15.39	15.52	240500.0
2018-05-16	AAOI	Stock	32.23	33.555	32.174	33.32	586800.0
2018-05-16	AAON	Stock	19.7333	19.9333	19.62	19.8667	467550.0
2018-05-16	AAP	Stock	120.64	121.5	118.66	119.03	855200.0
2018-05-16	AAT	Stock	34.61	34.85	34.28	34.55	289600.0
2018-05-16	AAU-DELISTED	Stock	0.75	0.7692	0.745	0.7472	195743.0
2018-05-16	AAUAF-DELISTED	Stock	0.75	0.7692	0.745	0.7472	202214.0
2018-05-16	AAV-DELISTED	Stock	3.1	3.15	3.0	3.1	157005.0
2018-05-16	AAWW-DELISTED	Stock	68.6	70.0	68.4	69.45	264401.0
2018-05-16	AAXJ	Stock	76.79	77.42	76.79	77.37	534396.0
2018-05-16	AAXN-DELISTED	Stock	54.54	56.81	53.67	54.33	1756360.0
2018-05-16	AB	Stock	26.9	27.5	26.9	27.3	620500.0
2018-05-16	ABAC-DELISTED	Stock	2.26	2.26	2.24	2.24	300.0
2018-05-16	ABAX-DELISTED	Stock	82.25	83.78	82.19	83.34	3987700.0
2018-05-16	ABB-DELISTED	Stock	24.0	24.08	23.875	23.91	1550396.0
2018-05-16	ABBNY-DELISTED	Stock	24.0	24.08	23.875	23.91	1601203.0
2018-05-16	ABBV	Stock	104.46	105.65	104.2	105.04	8296700.0
2018-05-16	ABC-DELISTED	Stock	85.93	86.73	85.31	85.99	897906.0
2018-05-16	ABCB	Stock	55.5	55.8	55.2	55.55	293900.0
2018-05-16	ABCD-DELISTED	Stock	10.31	10.42	9.86	10.18	300342.0
2018-05-16	ABDC-DELISTED	Stock	6.78	6.95	6.5	6.84	36319.0
2018-05-16	ABEO	Stock	508.75	527.0	506.25	525.0	34788.0
2018-05-16	ABEOW-DELISTED	Stock	15.753	15.93	15.6497	15.93	1900.0
2018-05-16	ABEV	Stock	5.82	5.88	5.75	5.8	23807500.0
2018-05-16	ABG	Stock	70.2	71.4	70.05	70.45	402500.0
2018-05-16	ABIL-DELISTED	Stock	2.6186	2.68	2.35	2.48	41261.0
2018-05-16	ABLX-DELISTED	Stock	53.22	53.71	52.99	53.71	7582.0
2018-05-16	ABM	Stock	30.23	30.46	30.11	30.28	398500.0
2018-05-16	ABMD-DELISTED	Stock	380.21	387.2133	376.98	382.0	364913.0

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

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