PREVIEW / stock_daily / 2017-04-10

all stock daily files

  file:    by_date/stock_daily/2017/2017-04-10.parquet
  size:    215 KB
  rows:    6,451
  symbols: 3,036

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-04-10	AAPL	Stock	35.9	35.97	35.725	35.7925	75733600.0
2017-04-10	MSFT	Stock	65.61	65.82	65.36	65.53	17952700.0
2017-04-10	NVDA	Stock	2.509	2.5158	2.44	2.4443	756332000.0
2017-04-10	AMZN	Stock	44.9815	45.4255	44.95	45.352	63686000.0
2017-04-10	GOOGL	Stock	42.077	42.3369	42.0395	42.085	20924300.0
2017-04-10	META	Stock	141.0	141.43	140.63	141.04	9039400.0
2017-04-10	TSLA	Stock	20.61	20.9153	20.5807	20.826	114967500.0
2017-04-10	TLT	Stock	121.14	121.62	121.0001	121.27	5314493.0
2017-04-10	ES	Stock	59.31	59.39	58.92	59.28	1036400.0
2017-04-10	CL	Stock	73.39	73.96	73.21	73.73	2230900.0
2017-04-10	A	Stock	52.9	53.26	52.68	52.72	1025200.0
2017-04-10	AA	Stock	33.66	33.78	33.2	33.66	2575500.0
2017-04-10	AAAP-DELISTED	Stock	39.5	39.5	38.501	38.81	41284.0
2017-04-10	AABA-DELISTED	Stock	46.49	47.415	46.4	47.22	7182603.0
2017-04-10	AAC-DELISTED	Stock	8.21	8.5119	8.21	8.27	73760.0
2017-04-10	AACG	Stock	4.15	4.15	3.86	3.9	21600.0
2017-04-10	AAIC-DELISTED	Stock	14.03	14.1	13.97	14.01	300061.0
2017-04-10	AAL	Stock	41.81	42.67	41.62	42.32	4650500.0
2017-04-10	AAM.A-DELISTED	Stock	25.29	25.34	25.18	25.23	219306.0
2017-04-10	AAMC-DELISTED	Stock	19.6176	20.5882	19.2647	20.2941	12764.0
2017-04-10	AAME	Stock	3.95	4.0	3.95	3.98	1400.0
2017-04-10	AAMI	Stock	15.11	15.22	14.82	14.9	530500.0
2017-04-10	AAOI	Stock	45.32	46.1	43.7	44.46	1386300.0
2017-04-10	AAON	Stock	22.8667	23.2	22.6667	22.9333	121200.0
2017-04-10	AAP	Stock	141.88	143.76	141.87	142.84	739400.0
2017-04-10	AAT	Stock	41.86	42.91	41.72	42.9	524100.0
2017-04-10	AAU-DELISTED	Stock	1.29	1.29	1.23	1.28	244451.0
2017-04-10	AAUAF-DELISTED	Stock	1.29	1.29	1.23	1.29	245579.0
2017-04-10	AAV-DELISTED	Stock	6.75	6.8	6.725	6.75	39138.0
2017-04-10	AAWW-DELISTED	Stock	54.1	56.1	53.8	55.8	167655.0
2017-04-10	AAXJ	Stock	62.9	62.93	62.7399	62.86	637818.0
2017-04-10	AAXN-DELISTED	Stock	23.3	24.58	23.27	23.27	1968442.0
2017-04-10	AB	Stock	22.7	23.05	22.62	22.7	722900.0
2017-04-10	ABAC-DELISTED	Stock	2.76	2.86	2.411	2.69	22224.0
2017-04-10	ABAX-DELISTED	Stock	47.57	48.105	47.04	47.39	51754.0
2017-04-10	ABB-DELISTED	Stock	23.19	23.22	23.06	23.09	1844319.0
2017-04-10	ABBNY-DELISTED	Stock	23.19	23.22	23.06	23.09	2197134.0
2017-04-10	ABBV	Stock	65.5	65.78	64.91	64.97	7136200.0
2017-04-10	ABC-DELISTED	Stock	87.75	89.25	87.59	88.44	827014.0
2017-04-10	ABCB	Stock	44.5	45.05	44.27	44.65	182600.0
2017-04-10	ABCD-DELISTED	Stock	4.85	4.86	4.8	4.82	4038.0
2017-04-10	ABCO-DELISTED	Stock	46.9	47.85	46.65	47.5	429902.0
2017-04-10	ABDC-DELISTED	Stock	14.33	14.33	13.98	14.2	26773.0
2017-04-10	ABE-DELISTED	Stock	13.5	13.5	13.321	13.4	5248.0
2017-04-10	ABEO	Stock	128.75	128.75	122.5	125.0	8612.0
2017-04-10	ABEV	Stock	5.71	5.74	5.65	5.71	11469800.0
2017-04-10	ABG	Stock	58.05	59.35	57.9	59.0	255200.0
2017-04-10	ABIL-DELISTED	Stock	1.6	1.6976	1.37	1.38	72404.0
2017-04-10	ABM	Stock	41.88	42.18	41.62	41.86	325000.0
2017-04-10	ABMD-DELISTED	Stock	125.4	126.39	124.7601	125.18	137570.0

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

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