PREVIEW / stock_daily / 2018-07-03

all stock daily files

  file:    by_date/stock_daily/2018/2018-07-03.parquet
  size:    214 KB
  rows:    6,420
  symbols: 2,736

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-07-03	AAPL	Stock	46.9475	46.9875	45.885	45.98	55819200.0
2018-07-03	MSFT	Stock	100.48	100.63	98.94	99.05	14670300.0
2018-07-03	NVDA	Stock	6.091	6.097	5.9125	5.921	222732000.0
2018-07-03	AMZN	Stock	86.198	86.25	84.624	84.698	43546000.0
2018-07-03	GOOGL	Stock	57.471	57.4955	55.7215	55.814	16447880.0
2018-07-03	META	Stock	194.55	195.4	192.52	192.73	13489500.0
2018-07-03	TSLA	Stock	22.1167	22.166	20.646	20.724	184239000.0
2018-07-03	TLT	Stock	121.53	122.03	121.53	122.0	3808806.0
2018-07-03	ES	Stock	59.08	59.95	58.81	59.52	1338700.0
2018-07-03	CL	Stock	65.16	65.23	64.5	64.67	2298400.0
2018-07-03	A	Stock	61.93	62.09	61.06	61.25	864400.0
2018-07-03	AA	Stock	46.34	46.9	45.51	45.8	1251300.0
2018-07-03	AABA-DELISTED	Stock	74.0038	74.18	72.52	72.78	6359336.0
2018-07-03	AAC-DELISTED	Stock	9.74	9.88	9.54	9.74	52314.0
2018-07-03	AACG	Stock	4.44	4.44	4.16	4.28	2300.0
2018-07-03	AAIC-DELISTED	Stock	10.41	10.475	10.37	10.37	434838.0
2018-07-03	AAL	Stock	37.64	38.33	36.76	37.75	5645300.0
2018-07-03	AAM.A-DELISTED	Stock	25.62	25.75	25.6	25.73	10741.0
2018-07-03	AAM.B-DELISTED	Stock	25.0	25.09	24.96	25.0	44986.0
2018-07-03	AAME	Stock	2.65	2.65	2.55	2.55	1600.0
2018-07-03	AAMI	Stock	14.44	14.56	14.43	14.44	268500.0
2018-07-03	AAOI	Stock	46.95	46.95	45.381	45.97	804700.0
2018-07-03	AAON	Stock	22.7	23.0667	22.5867	23.0	259500.0
2018-07-03	AAP	Stock	136.15	136.64	134.4	135.01	339600.0
2018-07-03	AAT	Stock	38.16	38.77	38.11	38.5	226900.0
2018-07-03	AAU-DELISTED	Stock	0.7016	0.7228	0.6901	0.7202	64929.0
2018-07-03	AAUAF-DELISTED	Stock	0.7016	0.7228	0.6901	0.7202	65744.0
2018-07-03	AAV-DELISTED	Stock	3.1	3.15	3.1	3.15	31355.0
2018-07-03	AAWW-DELISTED	Stock	72.3	72.87	70.95	71.5	77888.0
2018-07-03	AAXJ	Stock	71.3	71.3	70.54	70.62	280242.0
2018-07-03	AAXN-DELISTED	Stock	64.46	65.306	63.85	64.07	279316.0
2018-07-03	AB	Stock	28.8	28.95	28.45	28.5	193400.0
2018-07-03	ABAC-DELISTED	Stock	2.78	2.82	2.4926	2.56	4806.0
2018-07-03	ABAX-DELISTED	Stock	83.1	83.18	82.92	83.01	41328.0
2018-07-03	ABB-DELISTED	Stock	21.63	21.71	21.52	21.65	1440632.0
2018-07-03	ABBNY-DELISTED	Stock	21.63	21.71	21.52	21.53	1475364.0
2018-07-03	ABBV	Stock	93.58	94.37	93.12	93.61	2452400.0
2018-07-03	ABC-DELISTED	Stock	85.99	87.14	85.03	86.68	529512.0
2018-07-03	ABCB	Stock	53.6	54.1	52.6	52.8	892200.0
2018-07-03	ABCD-DELISTED	Stock	11.35	11.97	11.325	11.85	115886.0
2018-07-03	ABDC-DELISTED	Stock	6.43	6.74	6.43	6.72	43124.0
2018-07-03	ABEO	Stock	405.0	410.0	397.5	402.5	11156.0
2018-07-03	ABEOW-DELISTED	Stock	11.18	11.18	11.16	11.16	200.0
2018-07-03	ABEV	Stock	4.69	4.75	4.66	4.69	27320700.0
2018-07-03	ABG	Stock	69.2	70.58	69.1	69.7	81800.0
2018-07-03	ABIL-DELISTED	Stock	6.65	7.1	6.41	6.5	126807.0
2018-07-03	ABM	Stock	29.35	29.87	29.28	29.56	287300.0
2018-07-03	ABMD-DELISTED	Stock	414.91	414.97	408.93	409.5	217024.0
2018-07-03	ABR	Stock	10.56	10.64	10.54	10.59	481900.0
2018-07-03	ABT	Stock	60.97	61.23	60.63	60.81	2245200.0

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

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