PREVIEW / stock_daily / 2019-04-08

all stock daily files

  file:    by_date/stock_daily/2019/2019-04-08.parquet
  size:    220 KB
  rows:    6,548
  symbols: 2,611

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-08	AAPL	Stock	49.105	50.0575	49.085	50.025	103526800.0
2019-04-08	MSFT	Stock	119.81	120.02	118.64	119.93	15116200.0
2019-04-08	NVDA	Stock	4.743	4.82	4.7188	4.7947	424192000.0
2019-04-08	AMZN	Stock	91.6615	92.51	91.2555	92.493	75056000.0
2019-04-08	GOOGL	Stock	60.5555	60.6975	60.2348	60.414	21751760.0
2019-04-08	META	Stock	175.21	175.5	174.23	174.93	7297400.0
2019-04-08	TSLA	Stock	18.5127	18.744	18.0293	18.2133	156156000.0
2019-04-08	TLT	Stock	123.83	123.95	123.52	123.59	4446429.0
2019-04-08	ES	Stock	71.14	71.14	70.48	70.62	1506200.0
2019-04-08	CL	Stock	68.05	68.18	67.76	68.02	1678100.0
2019-04-08	A	Stock	81.57	81.71	80.58	81.69	783300.0
2019-04-08	AA	Stock	29.55	29.73	29.32	29.66	2375100.0
2019-04-08	AABA-DELISTED	Stock	73.65	74.78	73.58	74.45	11240603.0
2019-04-08	AAC-DELISTED	Stock	2.04	2.07	1.98	2.07	90613.0
2019-04-08	AACG	Stock	1.01	1.02	0.98	1.02	39600.0
2019-04-08	AAIC-DELISTED	Stock	7.9	7.99	7.89	7.97	357849.0
2019-04-08	AAIC.C-DELISTED	Stock	23.82	23.82	23.5293	23.73	12396.0
2019-04-08	AAL	Stock	33.64	33.95	33.44	33.88	6219800.0
2019-04-08	AAM.A-DELISTED	Stock	24.78	24.85	24.72	24.7403	30780.0
2019-04-08	AAM.B-DELISTED	Stock	24.72	24.75	24.61	24.61	50359.0
2019-04-08	AAMC-DELISTED	Stock	8.85	8.85	8.8235	8.8235	4151.0
2019-04-08	AAME	Stock	2.64	2.64	2.52	2.52	3200.0
2019-04-08	AAMI	Stock	13.99	14.05	13.885	14.04	320000.0
2019-04-08	AAOI	Stock	12.7	12.9	12.263	12.5	639100.0
2019-04-08	AAON	Stock	30.4333	30.72	30.1533	30.4867	192150.0
2019-04-08	AAP	Stock	175.78	178.04	173.83	177.59	830300.0
2019-04-08	AAT	Stock	46.81	46.86	45.95	46.0	218800.0
2019-04-08	AAU-DELISTED	Stock	0.588	0.5956	0.56	0.5649	191858.0
2019-04-08	AAUAF-DELISTED	Stock	0.588	0.5956	0.56	0.5649	197203.0
2019-04-08	AAWW-DELISTED	Stock	50.39	50.73	50.13	50.51	145515.0
2019-04-08	AAXJ	Stock	72.66	73.02	72.56	72.97	1498491.0
2019-04-08	AAXN-DELISTED	Stock	59.56	60.66	58.32	60.32	634918.0
2019-04-08	AB	Stock	29.41	29.48	29.28	29.32	88500.0
2019-04-08	ABB-DELISTED	Stock	19.65	19.779	19.61	19.755	1715476.0
2019-04-08	ABBNY-DELISTED	Stock	19.65	19.779	19.61	19.75	1773966.0
2019-04-08	ABBV	Stock	83.7	84.0	82.78	83.98	3499200.0
2019-04-08	ABC-DELISTED	Stock	77.1	78.39	76.5	78.12	1515196.0
2019-04-08	ABCB	Stock	35.8	36.12	35.61	36.09	232700.0
2019-04-08	ABDC-DELISTED	Stock	8.0	8.16	7.94	8.0	19398.0
2019-04-08	ABEO	Stock	194.25	196.25	188.0	189.75	11192.0
2019-04-08	ABEV	Stock	4.48	4.51	4.42	4.49	15856000.0
2019-04-08	ABG	Stock	71.45	72.75	70.99	72.16	116400.0
2019-04-08	ABIL-DELISTED	Stock	1.74	1.75	1.69	1.7087	44155.0
2019-04-08	ABM	Stock	36.88	37.13	36.67	37.06	535800.0
2019-04-08	ABMD-DELISTED	Stock	285.4	286.5	278.2134	283.02	451985.0
2019-04-08	ABR	Stock	13.54	13.61	13.38	13.58	1178900.0
2019-04-08	ABR.A-DELISTED	Stock	25.799	25.799	25.7755	25.7755	500.0
2019-04-08	ABR.B-DELISTED	Stock	25.6432	25.65	25.6432	25.65	430.0
2019-04-08	ABR.C-DELISTED	Stock	26.38	26.38	26.1969	26.35	690.0
2019-04-08	ABT	Stock	78.91	78.91	77.95	78.52	5178900.0

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

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