PREVIEW / stock_daily / 2019-05-01

all stock daily files

  file:    by_date/stock_daily/2019/2019-05-01.parquet
  size:    220 KB
  rows:    6,539
  symbols: 2,584

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-05-01	AAPL	Stock	52.47	53.8275	52.3075	52.63	259309200.0
2019-05-01	MSFT	Stock	130.53	130.65	127.7	127.88	26821700.0
2019-05-01	NVDA	Stock	4.5778	4.6203	4.5115	4.5118	354280000.0
2019-05-01	AMZN	Stock	96.6545	97.182	95.5275	95.576	62340000.0
2019-05-01	GOOGL	Stock	59.875	59.9625	58.5838	58.666	74340360.0
2019-05-01	META	Stock	194.78	196.18	193.01	193.03	15996600.0
2019-05-01	TSLA	Stock	15.9233	16.0	15.4333	15.6007	160566000.0
2019-05-01	TLT	Stock	123.69	124.45	123.6	123.9	14372113.0
2019-05-01	ES	Stock	71.38	71.85	71.02	71.13	1644500.0
2019-05-01	CL	Stock	72.08	72.47	71.24	71.29	3919100.0
2019-05-01	A	Stock	78.49	78.92	77.28	77.47	1078600.0
2019-05-01	AA	Stock	26.7	27.1	25.98	26.0	3681900.0
2019-05-01	AABA-DELISTED	Stock	75.64	78.2969	75.54	76.82	5878048.0
2019-05-01	AAC-DELISTED	Stock	1.64	1.66	1.59	1.63	52231.0
2019-05-01	AACG	Stock	1.88	1.88	1.76	1.76	212300.0
2019-05-01	AAIC-DELISTED	Stock	7.91	8.0	7.87	7.92	484333.0
2019-05-01	AAIC.C-DELISTED	Stock	23.51	23.51	23.3992	23.42	7612.0
2019-05-01	AAL	Stock	34.3	34.59	33.88	33.91	4466600.0
2019-05-01	AAM.A-DELISTED	Stock	25.11	25.25	25.11	25.235	17115.0
2019-05-01	AAM.B-DELISTED	Stock	25.14	25.2328	25.04	25.17	65203.0
2019-05-01	AAMC-DELISTED	Stock	8.0059	8.0059	8.0059	8.0059	680.0
2019-05-01	AAME	Stock	2.46	2.46	2.46	2.46	100.0
2019-05-01	AAMI	Stock	14.67	14.76	14.49	14.54	439400.0
2019-05-01	AAOI	Stock	12.59	12.78	12.25	12.27	617600.0
2019-05-01	AAON	Stock	33.56	33.8533	33.12	33.2467	458250.0
2019-05-01	AAP	Stock	166.13	166.66	163.67	163.83	923200.0
2019-05-01	AAT	Stock	46.3	46.86	45.96	46.22	408100.0
2019-05-01	AAU-DELISTED	Stock	0.512	0.5188	0.501	0.5025	97957.0
2019-05-01	AAUAF-DELISTED	Stock	0.512	0.5188	0.501	0.5025	99798.0
2019-05-01	AAWW-DELISTED	Stock	47.5	49.66	46.31	47.59	663560.0
2019-05-01	AAXJ	Stock	72.44	72.99	71.88	72.0	808088.0
2019-05-01	AAXN-DELISTED	Stock	63.83	64.27	63.23	63.79	673147.0
2019-05-01	AB	Stock	29.5	29.81	29.4	29.54	208400.0
2019-05-01	ABB-DELISTED	Stock	20.67	20.73	20.46	20.48	902487.0
2019-05-01	ABBNY-DELISTED	Stock	20.67	20.73	20.46	20.49	951273.0
2019-05-01	ABBV	Stock	79.6	79.68	78.61	78.89	5231700.0
2019-05-01	ABC-DELISTED	Stock	75.13	75.25	73.04	73.39	1746060.0
2019-05-01	ABCB	Stock	36.45	37.23	35.91	36.12	534900.0
2019-05-01	ABDC-DELISTED	Stock	8.47	8.5	8.35	8.42	11782.0
2019-05-01	ABEO	Stock	193.75	194.0	185.25	193.0	20360.0
2019-05-01	ABEOW-DELISTED	Stock	3.15	3.15	3.1	3.1	500.0
2019-05-01	ABEV	Stock	4.7	4.76	4.63	4.65	13150600.0
2019-05-01	ABG	Stock	80.25	80.93	79.12	79.18	208300.0
2019-05-01	ABIL-DELISTED	Stock	1.36	1.41	1.33	1.35	46891.0
2019-05-01	ABM	Stock	38.08	38.08	36.48	36.63	725300.0
2019-05-01	ABMD-DELISTED	Stock	279.36	281.75	274.31	277.06	1006672.0
2019-05-01	ABR	Stock	13.67	13.71	13.59	13.61	1435300.0
2019-05-01	ABR.A-DELISTED	Stock	26.0977	26.47	25.9	26.4067	1010.0
2019-05-01	ABR.B-DELISTED	Stock	25.7	25.73	25.7	25.73	1490.0
2019-05-01	ABR.C-DELISTED	Stock	26.18	26.18	26.18	26.18	100.0

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

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