PREVIEW / stock_daily / 2016-04-29

all stock daily files

  file:    by_date/stock_daily/2016/2016-04-29.parquet
  size:    219 KB
  rows:    6,533
  symbols: 3,282

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
2016-04-29	AAPL	Stock	23.4975	23.68	23.1275	23.435	274126000.0
2016-04-29	MSFT	Stock	49.35	50.25	49.35	49.87	48411700.0
2016-04-29	NVDA	Stock	0.9012	0.9033	0.8785	0.8883	321904000.0
2016-04-29	AMZN	Stock	33.3	33.499	32.7	32.9795	206214000.0
2016-04-29	GOOGL	Stock	35.206	35.6055	35.189	35.394	58277960.0
2016-04-29	META	Stock	116.82	117.84	115.84	117.58	37140600.0
2016-04-29	TSLA	Stock	16.5427	16.562	15.854	16.0507	81207000.0
2016-04-29	TLT	Stock	128.45	129.71	128.195	129.38	7416314.0
2016-04-29	ES	Stock	55.87	56.56	55.39	56.44	1394000.0
2016-04-29	CL	Stock	71.03	71.59	70.43	70.92	4889600.0
2016-04-29	A	Stock	40.92	41.04	40.26	40.92	2027900.0
2016-04-29	AA.B-DELISTED	Stock	38.0	38.773	37.8	38.0	55072.0
2016-04-29	AAAP-DELISTED	Stock	35.0	35.3895	34.51	34.72	5529.0
2016-04-29	AABA-DELISTED	Stock	36.51	36.98	36.15	36.6	11239359.0
2016-04-29	AAC-DELISTED	Stock	20.59	20.67	19.73	20.59	128362.0
2016-04-29	AACG	Stock	5.6	5.7	5.55	5.69	7200.0
2016-04-29	AAIC-DELISTED	Stock	12.88	13.0865	12.73	12.94	170464.0
2016-04-29	AAL	Stock	35.81	35.83	34.1	34.69	17807200.0
2016-04-29	AAMC-DELISTED	Stock	4.4525	4.9791	4.4147	4.9265	73137.0
2016-04-29	AAME	Stock	4.12	4.18	3.86	4.18	2600.0
2016-04-29	AAMI	Stock	13.61	13.645	13.4	13.42	137700.0
2016-04-29	AAOI	Stock	11.31	11.475	11.0	11.2	526800.0
2016-04-29	AAON	Stock	17.72	17.9533	17.4667	17.68	450750.0
2016-04-29	AAP	Stock	155.98	156.5	154.14	156.1	454800.0
2016-04-29	AAT	Stock	39.21	39.93	38.99	39.67	445200.0
2016-04-29	AAU-DELISTED	Stock	1.21	1.24	1.1	1.1401	552196.0
2016-04-29	AAUAF-DELISTED	Stock	1.21	1.24	1.1	1.1401	553787.0
2016-04-29	AAV-DELISTED	Stock	5.6	5.75	5.54	5.72	46737.0
2016-04-29	AAVL-DELISTED	Stock	5.68	5.86	5.58	5.64	200071.0
2016-04-29	AAWW-DELISTED	Stock	40.62	40.905	39.4301	39.94	148375.0
2016-04-29	AAXJ	Stock	54.25	54.26	53.6367	54.01	831356.0
2016-04-29	AAXN-DELISTED	Stock	18.13	18.515	18.11	18.27	513277.0
2016-04-29	AB	Stock	23.45	23.75	23.06	23.49	263700.0
2016-04-29	ABAC-DELISTED	Stock	0.611	0.6992	0.601	0.6558	2700.0
2016-04-29	ABAX-DELISTED	Stock	46.81	47.07	43.18	45.32	339553.0
2016-04-29	ABB-DELISTED	Stock	21.12	21.215	21.01	21.11	2870187.0
2016-04-29	ABBNY-DELISTED	Stock	21.12	21.215	21.01	21.11	2951920.0
2016-04-29	ABBV	Stock	61.03	61.45	60.48	61.0	13052700.0
2016-04-29	ABC-DELISTED	Stock	86.13	86.49	84.37	85.1	3422182.0
2016-04-29	ABCB	Stock	31.34	31.63	31.07	31.4	150900.0
2016-04-29	ABCD-DELISTED	Stock	4.58	4.65	4.52	4.53	24366.0
2016-04-29	ABCO-DELISTED	Stock	31.66	31.96	30.95	31.64	398555.0
2016-04-29	ABCW-DELISTED	Stock	46.12	47.94	46.12	47.85	232716.0
2016-04-29	ABDC-DELISTED	Stock	11.82	11.95	11.51	11.64	12545.0
2016-04-29	ABE-DELISTED	Stock	11.9911	12.06	11.9901	12.02	792.0
2016-04-29	ABEO	Stock	69.5	69.5	66.25	68.0	2248.0
2016-04-29	ABEV	Stock	5.58	5.6	5.47	5.59	18502100.0
2016-04-29	ABG	Stock	60.85	61.16	59.88	60.62	300600.0
2016-04-29	ABIL-DELISTED	Stock	7.5199	8.0	7.3001	7.32	26925.0
2016-04-29	ABM	Stock	32.11	32.29	31.92	32.17	250200.0

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

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