PREVIEW / stock_daily / 2018-06-07

all stock daily files

  file:    by_date/stock_daily/2018/2018-06-07.parquet
  size:    218 KB
  rows:    6,509
  symbols: 2,796

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-06-07	AAPL	Stock	48.535	48.55	48.085	48.365	85388800.0
2018-06-07	MSFT	Stock	102.65	102.69	100.38	100.88	28232200.0
2018-06-07	NVDA	Stock	6.625	6.637	6.4812	6.5725	369448000.0
2018-06-07	AMZN	Stock	84.928	84.995	83.8055	84.465	75314000.0
2018-06-07	GOOGL	Stock	57.229	57.2932	56.306	56.721	36107760.0
2018-06-07	META	Stock	190.75	190.97	186.77	188.18	21503200.0
2018-06-07	TSLA	Stock	21.0767	22.0	20.9053	21.0727	215179500.0
2018-06-07	TLT	Stock	118.69	120.49	118.68	119.89	13238306.0
2018-06-07	ES	Stock	53.69	54.17	53.15	53.6	2194800.0
2018-06-07	CL	Stock	62.32	63.57	62.1	62.76	5698500.0
2018-06-07	A	Stock	65.41	66.09	64.8	65.23	2977200.0
2018-06-07	AA	Stock	50.04	50.12	48.542	49.19	4036800.0
2018-06-07	AABA-DELISTED	Stock	81.04	81.99	78.66	79.75	11092953.0
2018-06-07	AAC-DELISTED	Stock	10.46	10.52	10.16	10.3	107729.0
2018-06-07	AACG	Stock	5.28	5.28	5.15	5.28	12300.0
2018-06-07	AAIC-DELISTED	Stock	11.51	11.66	11.48	11.5	696491.0
2018-06-07	AAL	Stock	44.28	44.48	43.45	43.84	3729000.0
2018-06-07	AAM.A-DELISTED	Stock	25.34	25.49	25.2378	25.49	41136.0
2018-06-07	AAM.B-DELISTED	Stock	24.64	24.79	24.61	24.79	74581.0
2018-06-07	AAME	Stock	2.72	2.85	2.7	2.75	5500.0
2018-06-07	AAMI	Stock	15.73	15.805	15.57	15.71	307800.0
2018-06-07	AAOI	Stock	45.37	45.8	44.0	44.98	1137900.0
2018-06-07	AAON	Stock	21.6333	22.1	21.6	22.0	297300.0
2018-06-07	AAP	Stock	131.0	131.98	129.66	130.05	1506100.0
2018-06-07	AAT	Stock	37.47	37.65	37.07	37.18	248600.0
2018-06-07	AAU-DELISTED	Stock	0.74	0.749	0.7255	0.7287	95395.0
2018-06-07	AAUAF-DELISTED	Stock	0.74	0.749	0.7255	0.7287	99547.0
2018-06-07	AAV-DELISTED	Stock	3.05	3.175	3.05	3.15	224363.0
2018-06-07	AAWW-DELISTED	Stock	72.6	72.6	70.5	70.95	144319.0
2018-06-07	AAXJ	Stock	78.68	78.68	77.5395	77.92	1914290.0
2018-06-07	AAXN-DELISTED	Stock	65.45	65.5	62.25	63.51	1733199.0
2018-06-07	AB	Stock	29.2	29.35	28.7	28.9	460400.0
2018-06-07	ABAC-DELISTED	Stock	2.41	2.4213	2.2238	2.37	26485.0
2018-06-07	ABAX-DELISTED	Stock	83.27	83.37	82.9	83.02	108524.0
2018-06-07	ABB-DELISTED	Stock	23.24	23.24	23.01	23.11	1349218.0
2018-06-07	ABBNY-DELISTED	Stock	23.24	23.24	23.01	23.1	1583734.0
2018-06-07	ABBV	Stock	100.25	100.33	98.87	99.32	5092500.0
2018-06-07	ABC-DELISTED	Stock	87.34	87.71	86.43	86.61	1137162.0
2018-06-07	ABCB	Stock	57.45	57.55	56.7	57.45	185800.0
2018-06-07	ABCD-DELISTED	Stock	10.27	10.3	10.05	10.15	85440.0
2018-06-07	ABDC-DELISTED	Stock	6.76	6.8	6.66	6.67	44159.0
2018-06-07	ABEO	Stock	410.0	416.25	397.5	407.5	32484.0
2018-06-07	ABEOW-DELISTED	Stock	11.26	11.26	11.26	11.26	100.0
2018-06-07	ABEV	Stock	4.98	5.05	4.8	4.85	98048800.0
2018-06-07	ABG	Stock	73.75	74.85	73.3	73.6	147900.0
2018-06-07	ABIL-DELISTED	Stock	2.43	2.43	2.3201	2.39	4435.0
2018-06-07	ABLX-DELISTED	Stock	53.32	53.32	52.6	52.67	946.0
2018-06-07	ABM	Stock	30.05	32.9	29.76	32.18	2746900.0
2018-06-07	ABMD-DELISTED	Stock	411.51	413.89	393.7725	405.62	466870.0
2018-06-07	ABR	Stock	9.5	9.56	9.48	9.5	1142000.0

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

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