PREVIEW / stock_daily / 2016-03-28

all stock daily files

  file:    by_date/stock_daily/2016/2016-03-28.parquet
  size:    219 KB
  rows:    6,600
  symbols: 3,334

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-03-28	AAPL	Stock	26.5	26.5475	26.265	26.2975	77645600.0
2016-03-28	MSFT	Stock	54.21	54.29	53.33	53.54	17025100.0
2016-03-28	NVDA	Stock	0.8605	0.8745	0.8595	0.8708	265388000.0
2016-03-28	AMZN	Stock	29.22	29.2375	28.778	28.9935	62430000.0
2016-03-28	GOOGL	Stock	37.8085	37.915	37.602	37.664	21676460.0
2016-03-28	META	Stock	113.32	114.59	112.95	113.69	21351800.0
2016-03-28	TSLA	Stock	15.4407	15.654	15.0	15.3507	58885500.0
2016-03-28	TLT	Stock	129.38	130.16	129.2801	129.71	5058676.0
2016-03-28	ES	Stock	58.1	58.42	57.63	57.77	681800.0
2016-03-28	CL	Stock	69.98	70.39	69.74	69.91	1926200.0
2016-03-28	A	Stock	39.54	39.75	39.14	39.52	1272700.0
2016-03-28	AA.B-DELISTED	Stock	32.26	32.97	31.87	32.6	21925.0
2016-03-28	AAAP-DELISTED	Stock	36.64	36.64	32.55	32.99	24155.0
2016-03-28	AABA-DELISTED	Stock	35.39	35.4489	34.62	35.23	12123861.0
2016-03-28	AAC-DELISTED	Stock	18.66	19.015	18.22	18.4425	291179.0
2016-03-28	AACG	Stock	5.0	5.14	5.0	5.04	2000.0
2016-03-28	AAIC-DELISTED	Stock	13.5	13.73	13.28	13.46	495891.0
2016-03-28	AAL	Stock	41.0	41.34	40.33	40.91	6402800.0
2016-03-28	AAMC-DELISTED	Stock	3.7941	3.7985	3.4412	3.5382	86333.0
2016-03-28	AAME	Stock	4.01	4.1	3.76	3.92	9700.0
2016-03-28	AAMI	Stock	12.47	12.87	12.445	12.73	158900.0
2016-03-28	AAOI	Stock	15.9	15.98	15.11	15.2	243200.0
2016-03-28	AAON	Stock	17.9333	18.0333	17.7533	17.8467	182850.0
2016-03-28	AAP	Stock	161.43	162.88	159.39	161.76	638200.0
2016-03-28	AAT	Stock	38.34	38.6	38.2	38.46	75400.0
2016-03-28	AAU-DELISTED	Stock	0.68	0.68	0.66	0.6676	61784.0
2016-03-28	AAUAF-DELISTED	Stock	0.68	0.68	0.66	0.6676	62741.0
2016-03-28	AAV-DELISTED	Stock	5.13	5.2	5.02	5.19	45267.0
2016-03-28	AAVL-DELISTED	Stock	5.06	5.14	4.86	4.99	274898.0
2016-03-28	AAWW-DELISTED	Stock	40.79	40.79	39.35	40.36	111105.0
2016-03-28	AAXJ	Stock	53.3	53.47	53.28	53.45	278225.0
2016-03-28	AAXN-DELISTED	Stock	18.32	18.6006	18.2	18.31	426053.0
2016-03-28	AB	Stock	22.31	22.74	22.12	22.53	180500.0
2016-03-28	ABAC-DELISTED	Stock	0.71	0.71	0.7001	0.7001	3081.0
2016-03-28	ABAX-DELISTED	Stock	42.23	42.48	41.93	42.23	127284.0
2016-03-28	ABB-DELISTED	Stock	18.95	19.0401	18.93	18.98	580213.0
2016-03-28	ABBNY-DELISTED	Stock	18.95	19.0401	18.93	18.98	606440.0
2016-03-28	ABBV	Stock	56.35	56.7	55.8	56.11	3803100.0
2016-03-28	ABC-DELISTED	Stock	87.04	87.4	85.71	86.48	1300936.0
2016-03-28	ABCB	Stock	28.92	28.98	28.45	28.77	84200.0
2016-03-28	ABCD-DELISTED	Stock	4.32	4.45	4.32	4.405	15036.0
2016-03-28	ABCO-DELISTED	Stock	30.66	31.27	30.66	30.72	523280.0
2016-03-28	ABCW-DELISTED	Stock	44.22	44.5	44.02	44.37	46140.0
2016-03-28	ABDC-DELISTED	Stock	11.53	11.9001	11.47	11.61	73347.0
2016-03-28	ABE-DELISTED	Stock	11.21	11.3299	11.21	11.3299	7140.0
2016-03-28	ABEO	Stock	68.0	68.25	61.25	65.0	3296.0
2016-03-28	ABEOW-DELISTED	Stock	0.63	0.63	0.6	0.6	900.0
2016-03-28	ABEV	Stock	5.23	5.29	5.19	5.27	12356400.0
2016-03-28	ABG	Stock	59.78	60.34	59.19	59.34	269600.0
2016-03-28	ABGB-DELISTED	Stock	1.49	1.5199	1.439	1.5	75719.0

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

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