PREVIEW / stock_daily / 2018-10-10

all stock daily files

  file:    by_date/stock_daily/2018/2018-10-10.parquet
  size:    222 KB
  rows:    6,573
  symbols: 2,755

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-10-10	AAPL	Stock	56.365	56.5875	54.0125	54.09	167962400.0
2018-10-10	MSFT	Stock	111.24	111.5	105.79	106.16	61376300.0
2018-10-10	NVDA	Stock	6.5315	6.5778	6.14	6.1423	684940000.0
2018-10-10	AMZN	Stock	92.8945	92.928	87.7205	87.7625	219778000.0
2018-10-10	GOOGL	Stock	56.82	56.851	54.5755	54.608	58980120.0
2018-10-10	META	Stock	156.82	157.69	151.31	151.38	30610000.0
2018-10-10	TSLA	Stock	17.6407	17.7007	16.518	17.1253	192229500.0
2018-10-10	TLT	Stock	113.14	113.575	112.785	113.49	15290066.0
2018-10-10	ES	Stock	63.3	64.02	63.0	63.04	1841900.0
2018-10-10	CL	Stock	64.54	65.38	63.8	63.83	4789000.0
2018-10-10	A	Stock	69.41	69.41	66.61	66.67	3055700.0
2018-10-10	AA	Stock	37.31	37.45	35.97	36.06	4374400.0
2018-10-10	AABA-DELISTED	Stock	60.12	60.49	58.2	58.4	14239975.0
2018-10-10	AAC-DELISTED	Stock	7.13	7.3	6.9701	7.0	81801.0
2018-10-10	AACG	Stock	1.03	1.15	1.01	1.01	78600.0
2018-10-10	AAIC-DELISTED	Stock	8.9	8.97	8.7	8.7	314187.0
2018-10-10	AAL	Stock	33.33	33.4	31.59	31.61	20539000.0
2018-10-10	AAM.A-DELISTED	Stock	24.3063	24.39	24.1282	24.24	22102.0
2018-10-10	AAM.B-DELISTED	Stock	24.2	24.2	23.9507	24.05	23615.0
2018-10-10	AAMC-DELISTED	Stock	15.0206	15.5882	14.7353	15.5882	9459.0
2018-10-10	AAME	Stock	2.68	2.68	2.57	2.6	2900.0
2018-10-10	AAMI	Stock	12.84	13.09	12.51	12.52	933300.0
2018-10-10	AAOI	Stock	22.38	22.528	21.255	21.32	1003400.0
2018-10-10	AAON	Stock	22.6667	22.9533	21.9333	22.0	298500.0
2018-10-10	AAP	Stock	169.0	169.65	162.87	163.17	997300.0
2018-10-10	AAT	Stock	37.29	37.67	36.87	36.95	281900.0
2018-10-10	AAU-DELISTED	Stock	0.56	0.5796	0.53	0.5351	560089.0
2018-10-10	AAUAF-DELISTED	Stock	0.56	0.5796	0.53	0.5351	565036.0
2018-10-10	AAWW-DELISTED	Stock	55.96	56.2	52.91	53.72	485354.0
2018-10-10	AAXJ	Stock	65.44	65.49	63.9	63.9	2743215.0
2018-10-10	AAXN-DELISTED	Stock	62.28	62.28	57.54	57.66	905671.0
2018-10-10	AB	Stock	30.2	30.34	29.2	29.27	302000.0
2018-10-10	ABAC-DELISTED	Stock	1.91	1.97	1.73	1.901	11204.0
2018-10-10	ABB-DELISTED	Stock	21.92	21.93	21.5301	21.55	2152571.0
2018-10-10	ABBNY-DELISTED	Stock	21.92	21.93	21.5301	21.54	2232293.0
2018-10-10	ABBV	Stock	93.85	95.39	92.99	93.08	5310800.0
2018-10-10	ABC-DELISTED	Stock	91.05	92.8307	90.81	90.83	1443623.0
2018-10-10	ABCB	Stock	45.54	45.9	44.71	44.83	238200.0
2018-10-10	ABCD-DELISTED	Stock	11.59	11.925	11.55	11.78	130529.0
2018-10-10	ABDC-DELISTED	Stock	6.0	6.05	6.0	6.0	77757.0
2018-10-10	ABEO	Stock	268.5	269.25	241.5	250.75	43232.0
2018-10-10	ABEOW-DELISTED	Stock	5.3	5.3	5.1	5.27	4500.0
2018-10-10	ABEV	Stock	4.65	4.65	4.55	4.55	27428400.0
2018-10-10	ABG	Stock	63.04	63.32	61.71	61.79	323500.0
2018-10-10	ABIL-DELISTED	Stock	3.31	3.38	3.03	3.1	42198.0
2018-10-10	ABM	Stock	32.59	33.01	32.35	32.37	1020000.0
2018-10-10	ABMD-DELISTED	Stock	394.64	396.99	375.61	376.89	602945.0
2018-10-10	ABR	Stock	11.75	11.83	11.64	11.65	838700.0
2018-10-10	ABR.A-DELISTED	Stock	25.66	25.66	25.5272	25.5272	1590.0
2018-10-10	ABR.C-DELISTED	Stock	26.1715	26.1715	26.1397	26.1397	658.0

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

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