PREVIEW / stock_daily / 2017-05-01

all stock daily files

  file:    by_date/stock_daily/2017/2017-05-01.parquet
  size:    215 KB
  rows:    6,451
  symbols: 3,026

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
2017-05-01	AAPL	Stock	36.275	36.8	36.24	36.645	134411600.0
2017-05-01	MSFT	Stock	68.68	69.55	68.5	69.41	31954400.0
2017-05-01	NVDA	Stock	2.6185	2.6712	2.6112	2.666	307732000.0
2017-05-01	AMZN	Stock	46.39	47.72	46.39	47.4115	109330000.0
2017-05-01	GOOGL	Stock	46.2075	46.791	46.04	46.641	46555640.0
2017-05-01	META	Stock	151.74	152.57	151.42	152.46	25218300.0
2017-05-01	TSLA	Stock	20.992	21.8167	20.9873	21.522	132444000.0
2017-05-01	TLT	Stock	121.69	122.14	120.71	121.08	8795929.0
2017-05-01	ES	Stock	59.58	59.58	58.94	59.14	860600.0
2017-05-01	CL	Stock	72.29	72.56	71.77	71.8	3369900.0
2017-05-01	A	Stock	55.5	55.99	55.36	55.8	1897000.0
2017-05-01	AA	Stock	33.95	34.13	32.9	33.28	4985500.0
2017-05-01	AAAP-DELISTED	Stock	38.01	38.4	37.75	38.0	41698.0
2017-05-01	AABA-DELISTED	Stock	48.22	48.78	48.12	48.62	5961659.0
2017-05-01	AAC-DELISTED	Stock	7.13	7.27	7.01	7.12	44666.0
2017-05-01	AACG	Stock	3.66	3.71	3.66	3.7	7300.0
2017-05-01	AAIC-DELISTED	Stock	14.61	14.72	14.55	14.64	453551.0
2017-05-01	AAL	Stock	42.76	42.96	42.01	42.08	8591400.0
2017-05-01	AAM.A-DELISTED	Stock	25.39	25.44	25.32	25.43	40032.0
2017-05-01	AAMC-DELISTED	Stock	22.6176	22.6471	21.6324	22.0746	55689.0
2017-05-01	AAME	Stock	3.88	3.9	3.65	3.85	2800.0
2017-05-01	AAMI	Stock	15.63	15.64	15.43	15.43	164700.0
2017-05-01	AAOI	Stock	50.25	52.1	49.33	50.13	3243700.0
2017-05-01	AAON	Stock	24.4667	24.9667	24.3333	24.9667	202350.0
2017-05-01	AAP	Stock	143.15	143.15	140.36	140.53	922500.0
2017-05-01	AAT	Stock	43.02	43.27	42.57	43.21	251000.0
2017-05-01	AAU-DELISTED	Stock	1.48	1.49	1.42	1.425	230691.0
2017-05-01	AAUAF-DELISTED	Stock	1.48	1.49	1.42	1.44	232435.0
2017-05-01	AAV-DELISTED	Stock	6.25	6.3	6.2	6.2	53801.0
2017-05-01	AAWW-DELISTED	Stock	58.3	58.3	57.5	57.9	109059.0
2017-05-01	AAXJ	Stock	64.46	64.64	64.29	64.42	744469.0
2017-05-01	AAXN-DELISTED	Stock	24.72	24.82	24.54	24.75	435442.0
2017-05-01	AB	Stock	22.9	22.95	22.0	22.15	1349200.0
2017-05-01	ABAC-DELISTED	Stock	1.7	1.75	1.6504	1.71	24540.0
2017-05-01	ABAX-DELISTED	Stock	45.35	45.9699	44.12	45.82	136035.0
2017-05-01	ABB-DELISTED	Stock	24.61	24.69	24.52	24.575	1125451.0
2017-05-01	ABBNY-DELISTED	Stock	24.61	24.69	24.52	24.57	1174058.0
2017-05-01	ABBV	Stock	66.0	66.67	65.94	66.48	4575800.0
2017-05-01	ABC-DELISTED	Stock	82.32	83.01	81.86	82.5	1504939.0
2017-05-01	ABCB	Stock	47.55	47.95	46.85	47.35	161100.0
2017-05-01	ABCD-DELISTED	Stock	4.84	4.99	4.8	4.92	28967.0
2017-05-01	ABCO-DELISTED	Stock	51.25	51.4	50.7	50.85	301837.0
2017-05-01	ABDC-DELISTED	Stock	13.99	14.1	13.73	14.1	51359.0
2017-05-01	ABE-DELISTED	Stock	13.61	13.87	13.5875	13.87	3555.0
2017-05-01	ABEO	Stock	142.5	142.5	136.25	141.25	5152.0
2017-05-01	ABEV	Stock	5.76	5.82	5.71	5.77	22742200.0
2017-05-01	ABG	Stock	61.8	62.7	60.9	61.65	482800.0
2017-05-01	ABIL-DELISTED	Stock	0.8	0.83	0.7995	0.81	10372.0
2017-05-01	ABM	Stock	43.42	43.42	42.86	43.39	258800.0
2017-05-01	ABMD-DELISTED	Stock	130.5	133.7	130.09	133.585	250475.0

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

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