PREVIEW / stock_daily / 2017-04-11

all stock daily files

  file:    by_date/stock_daily/2017/2017-04-11.parquet
  size:    215 KB
  rows:    6,460
  symbols: 3,038

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-11	AAPL	Stock	35.735	35.8375	35.015	35.4075	121517600.0
2017-04-11	MSFT	Stock	65.6	65.61	64.85	65.48	18791500.0
2017-04-11	NVDA	Stock	2.4138	2.4725	2.4088	2.453	618148000.0
2017-04-11	AMZN	Stock	45.352	45.562	44.875	45.118	60254000.0
2017-04-11	GOOGL	Stock	42.085	42.2315	41.73	41.994	19486860.0
2017-04-11	META	Stock	140.8	141.03	138.81	139.92	16638100.0
2017-04-11	TSLA	Stock	20.892	20.898	20.3667	20.5807	85869000.0
2017-04-11	TLT	Stock	121.8	122.65	121.72	122.42	11297362.0
2017-04-11	ES	Stock	59.16	59.36	58.85	59.21	1214900.0
2017-04-11	CL	Stock	73.64	73.96	73.43	73.7	2517900.0
2017-04-11	A	Stock	52.7	52.9	52.37	52.83	1520700.0
2017-04-11	AA	Stock	33.57	34.46	33.15	34.39	3142600.0
2017-04-11	AAAP-DELISTED	Stock	38.84	38.97	37.69	38.08	36506.0
2017-04-11	AABA-DELISTED	Stock	47.03	47.21	46.42	46.8	5133213.0
2017-04-11	AAC-DELISTED	Stock	8.26	8.35	8.229	8.29	49136.0
2017-04-11	AACG	Stock	3.9	3.93	3.71	3.83	18900.0
2017-04-11	AAIC-DELISTED	Stock	13.99	14.29	13.9542	14.23	361975.0
2017-04-11	AAL	Stock	42.78	43.95	42.41	43.93	10269600.0
2017-04-11	AAM.A-DELISTED	Stock	25.22	25.27	25.1	25.27	207771.0
2017-04-11	AAMC-DELISTED	Stock	20.2941	20.7353	19.7537	20.4706	24269.0
2017-04-11	AAME	Stock	4.0	4.03	3.8	3.8	5000.0
2017-04-11	AAMI	Stock	14.79	15.11	14.69	15.03	486900.0
2017-04-11	AAOI	Stock	44.43	44.7	41.79	42.38	1960500.0
2017-04-11	AAON	Stock	22.8333	23.5333	22.7667	23.5	141900.0
2017-04-11	AAP	Stock	142.49	143.92	141.49	143.46	763700.0
2017-04-11	AAT	Stock	43.04	43.5	42.94	43.4	340200.0
2017-04-11	AAU-DELISTED	Stock	1.3	1.39	1.3	1.36	329499.0
2017-04-11	AAUAF-DELISTED	Stock	1.3	1.39	1.3	1.37	348044.0
2017-04-11	AAV-DELISTED	Stock	6.8	6.85	6.7	6.8	85989.0
2017-04-11	AAWW-DELISTED	Stock	55.65	55.9	54.9	55.65	112626.0
2017-04-11	AAXJ	Stock	62.78	62.81	62.29	62.59	2663110.0
2017-04-11	AAXN-DELISTED	Stock	23.27	23.42	22.95	23.185	884916.0
2017-04-11	AB	Stock	22.65	22.75	22.15	22.35	622200.0
2017-04-11	ABAC-DELISTED	Stock	2.9	2.9	2.68	2.68	7363.0
2017-04-11	ABAX-DELISTED	Stock	47.35	47.99	47.35	47.76	47954.0
2017-04-11	ABB-DELISTED	Stock	22.94	23.065	22.8342	23.04	1735880.0
2017-04-11	ABBNY-DELISTED	Stock	22.94	23.065	22.8342	23.06	2162992.0
2017-04-11	ABBV	Stock	64.43	64.43	63.32	64.18	5404500.0
2017-04-11	ABC-DELISTED	Stock	88.28	88.35	86.82	87.87	1248173.0
2017-04-11	ABCB	Stock	44.4	45.05	44.1	44.9	82900.0
2017-04-11	ABCD-DELISTED	Stock	4.83	4.9	4.8	4.89	13824.0
2017-04-11	ABCO-DELISTED	Stock	47.5	47.8	47.2	47.6	243324.0
2017-04-11	ABDC-DELISTED	Stock	14.16	14.24	13.91	14.02	45697.0
2017-04-11	ABE-DELISTED	Stock	13.44	13.49	13.37	13.44	6103.0
2017-04-11	ABEO	Stock	125.0	126.25	120.0	121.25	6204.0
2017-04-11	ABEV	Stock	5.6	5.62	5.5	5.57	21247700.0
2017-04-11	ABG	Stock	58.8	59.95	58.25	59.8	233500.0
2017-04-11	ABIL-DELISTED	Stock	1.3	1.38	1.05	1.38	237126.0
2017-04-11	ABM	Stock	41.79	42.36	41.67	42.32	188800.0
2017-04-11	ABMD-DELISTED	Stock	124.89	125.99	124.2977	125.84	137464.0

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

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