PREVIEW / stock_daily / 2018-05-10

all stock daily files

  file:    by_date/stock_daily/2018/2018-05-10.parquet
  size:    217 KB
  rows:    6,500
  symbols: 2,817

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-10	AAPL	Stock	46.935	47.5925	46.9125	47.51	111957200.0
2018-05-10	MSFT	Stock	97.46	97.95	97.05	97.91	22388100.0
2018-05-10	NVDA	Stock	6.448	6.5125	6.43	6.5033	994080000.0
2018-05-10	AMZN	Stock	80.424	80.78	80.172	80.454	56350000.0
2018-05-10	GOOGL	Stock	54.75	55.4705	54.694	55.2735	36413520.0
2018-05-10	META	Stock	183.15	186.13	182.5	185.53	21071400.0
2018-05-10	TSLA	Stock	20.5	20.866	20.274	20.3347	84774000.0
2018-05-10	TLT	Stock	118.55	118.98	118.35	118.93	7101525.0
2018-05-10	ES	Stock	57.54	57.98	57.16	57.95	1289300.0
2018-05-10	CL	Stock	62.36	62.76	62.06	62.48	4036100.0
2018-05-10	A	Stock	68.12	68.88	68.12	68.86	1844900.0
2018-05-10	AA	Stock	53.4	54.01	53.09	53.79	3321900.0
2018-05-10	AABA-DELISTED	Stock	76.19	77.48	75.73	75.89	3344245.0
2018-05-10	AAC-DELISTED	Stock	11.34	11.62	10.56	11.55	148001.0
2018-05-10	AACG	Stock	5.3	5.32	5.05	5.2	11200.0
2018-05-10	AAIC-DELISTED	Stock	10.91	11.07	10.91	10.99	804713.0
2018-05-10	AAL	Stock	41.51	42.46	41.51	42.04	7931600.0
2018-05-10	AAM.A-DELISTED	Stock	24.99	25.0	24.8548	24.99	58424.0
2018-05-10	AAM.B-DELISTED	Stock	24.7495	24.77	24.67	24.7	70307.0
2018-05-10	AAMC-DELISTED	Stock	19.0735	19.0735	19.0735	19.0735	2421.0
2018-05-10	AAMI	Stock	15.49	15.78	15.49	15.6	245400.0
2018-05-10	AAOI	Stock	32.26	32.58	31.4	32.09	1185100.0
2018-05-10	AAON	Stock	20.1667	20.1667	19.7333	19.8	357600.0
2018-05-10	AAP	Stock	118.25	118.59	116.78	118.23	594200.0
2018-05-10	AAT	Stock	35.38	35.44	35.07	35.25	217000.0
2018-05-10	AAU-DELISTED	Stock	0.86	0.86	0.81	0.836	105398.0
2018-05-10	AAUAF-DELISTED	Stock	0.86	0.86	0.81	0.836	122916.0
2018-05-10	AAV-DELISTED	Stock	3.0	3.05	2.9	2.95	171096.0
2018-05-10	AAWW-DELISTED	Stock	68.8	69.33	68.35	68.45	148399.0
2018-05-10	AAXJ	Stock	76.58	77.65	76.58	77.39	1084134.0
2018-05-10	AAXN-DELISTED	Stock	54.44	56.73	53.55	55.46	1592514.0
2018-05-10	AB	Stock	26.65	26.75	26.4	26.7	619300.0
2018-05-10	ABAC-DELISTED	Stock	2.3738	2.3738	2.19	2.3387	10600.0
2018-05-10	ABAX-DELISTED	Stock	68.49	70.08	68.49	69.82	174715.0
2018-05-10	ABB-DELISTED	Stock	23.87	24.05	23.835	24.04	962134.0
2018-05-10	ABBNY-DELISTED	Stock	23.87	24.05	23.835	24.04	1067989.0
2018-05-10	ABBV	Stock	102.58	103.81	101.93	102.85	5369700.0
2018-05-10	ABC-DELISTED	Stock	85.41	87.83	85.41	85.53	1743419.0
2018-05-10	ABCB	Stock	55.45	55.45	54.85	55.2	122600.0
2018-05-10	ABCD-DELISTED	Stock	10.14	10.23	9.8	10.12	178351.0
2018-05-10	ABDC-DELISTED	Stock	6.47	6.52	6.35	6.45	52101.0
2018-05-10	ABEO	Stock	480.0	492.5	470.0	471.25	21648.0
2018-05-10	ABEV	Stock	6.13	6.15	6.05	6.1	31477200.0
2018-05-10	ABG	Stock	68.5	69.8	68.2	68.9	194900.0
2018-05-10	ABIL-DELISTED	Stock	2.71	2.84	2.7	2.7699	23020.0
2018-05-10	ABLX-DELISTED	Stock	53.31	53.53	53.1021	53.53	2697.0
2018-05-10	ABM	Stock	30.46	30.62	30.21	30.39	835800.0
2018-05-10	ABMD-DELISTED	Stock	358.72	371.45	358.72	368.88	368783.0
2018-05-10	ABR	Stock	9.5	9.5	9.41	9.43	883900.0
2018-05-10	ABR.A-DELISTED	Stock	25.77	25.88	25.6957	25.83	1100.0

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

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