PREVIEW / stock_daily / 2019-04-18

all stock daily files

  file:    by_date/stock_daily/2019/2019-04-18.parquet
  size:    220 KB
  rows:    6,527
  symbols: 2,582

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
2019-04-18	AAPL	Stock	50.78	51.0375	50.63	50.965	96783200.0
2019-04-18	MSFT	Stock	122.19	123.52	121.3	123.37	27991000.0
2019-04-18	NVDA	Stock	4.689	4.7232	4.6295	4.6575	380988000.0
2019-04-18	AMZN	Stock	93.4395	93.541	92.974	93.0845	54998000.0
2019-04-18	GOOGL	Stock	62.25	62.297	61.9705	62.0735	24755760.0
2019-04-18	META	Stock	178.8	178.88	177.34	178.28	11655600.0
2019-04-18	TSLA	Stock	18.082	18.3227	17.9833	18.2173	88144500.0
2019-04-18	TLT	Stock	122.81	123.1	122.78	122.9	27589692.0
2019-04-18	ES	Stock	70.54	70.71	69.94	69.96	1518900.0
2019-04-18	CL	Stock	69.0	69.39	68.77	69.35	3369000.0
2019-04-18	A	Stock	75.73	76.54	75.31	76.17	2874100.0
2019-04-18	AA	Stock	27.36	27.41	25.71	26.66	9476200.0
2019-04-18	AABA-DELISTED	Stock	76.13	76.13	75.34	75.96	5845175.0
2019-04-18	AAC-DELISTED	Stock	1.74	1.74	1.55	1.555	373667.0
2019-04-18	AACG	Stock	2.74	2.8	2.6	2.67	463000.0
2019-04-18	AAIC-DELISTED	Stock	7.59	7.61	7.56	7.58	172629.0
2019-04-18	AAIC.C-DELISTED	Stock	23.21	23.3	23.1841	23.3	8610.0
2019-04-18	AAL	Stock	34.43	34.62	33.9	34.37	3318200.0
2019-04-18	AAM.A-DELISTED	Stock	24.9601	25.0594	24.96	25.0	13527.0
2019-04-18	AAM.B-DELISTED	Stock	25.0	25.03	24.995	25.0	53391.0
2019-04-18	AAMC-DELISTED	Stock	8.75	9.0206	8.5206	8.8956	75660.0
2019-04-18	AAME	Stock	2.45	2.45	2.45	2.45	1800.0
2019-04-18	AAMI	Stock	14.47	14.55	14.395	14.54	350600.0
2019-04-18	AAOI	Stock	12.52	12.83	12.52	12.59	349700.0
2019-04-18	AAON	Stock	31.62	31.9533	31.4333	31.7267	180300.0
2019-04-18	AAP	Stock	176.56	177.13	174.11	175.4	1025300.0
2019-04-18	AAT	Stock	44.05	44.89	44.05	44.76	199200.0
2019-04-18	AAU-DELISTED	Stock	0.5576	0.57	0.5502	0.5505	73041.0
2019-04-18	AAUAF-DELISTED	Stock	0.5576	0.57	0.55	0.55	74017.0
2019-04-18	AAWW-DELISTED	Stock	50.13	50.55	49.655	50.02	74779.0
2019-04-18	AAXJ	Stock	73.07	73.36	72.935	73.26	911148.0
2019-04-18	AAXN-DELISTED	Stock	61.82	61.82	59.17	59.82	291281.0
2019-04-18	AB	Stock	30.0	30.01	29.8	29.96	163600.0
2019-04-18	ABB-DELISTED	Stock	20.96	21.025	20.845	20.96	2744028.0
2019-04-18	ABBNY-DELISTED	Stock	20.96	21.025	20.845	20.96	3147667.0
2019-04-18	ABBV	Stock	78.06	78.21	76.81	77.57	7784900.0
2019-04-18	ABC-DELISTED	Stock	72.3	72.78	71.28	72.47	1179194.0
2019-04-18	ABCB	Stock	35.59	35.81	35.01	35.17	193500.0
2019-04-18	ABDC-DELISTED	Stock	7.87	8.0	7.79	7.92	59080.0
2019-04-18	ABEO	Stock	205.0	210.0	197.5	199.0	39124.0
2019-04-18	ABEOW-DELISTED	Stock	3.77	3.8	3.77	3.8	1300.0
2019-04-18	ABEV	Stock	4.3	4.36	4.27	4.36	24784000.0
2019-04-18	ABG	Stock	75.67	76.04	74.56	75.65	142000.0
2019-04-18	ABIL-DELISTED	Stock	1.67	1.67	1.55	1.59	65582.0
2019-04-18	ABM	Stock	36.87	37.44	36.76	37.37	281900.0
2019-04-18	ABMD-DELISTED	Stock	252.23	257.07	244.08	256.49	897403.0
2019-04-18	ABR	Stock	13.53	13.69	13.51	13.68	447600.0
2019-04-18	ABR.A-DELISTED	Stock	25.74	25.85	25.67	25.85	1100.0
2019-04-18	ABR.C-DELISTED	Stock	26.3282	26.3282	26.3282	26.3282	300.0
2019-04-18	ABT	Stock	73.64	74.9	72.75	73.92	9712200.0

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

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