PREVIEW / stock_daily / 2016-03-29

all stock daily files

  file:    by_date/stock_daily/2016/2016-03-29.parquet
  size:    219 KB
  rows:    6,617
  symbols: 3,345

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-29	AAPL	Stock	26.2225	26.9475	26.22	26.92	124760400.0
2016-03-29	MSFT	Stock	53.66	54.86	53.45	54.71	23924300.0
2016-03-29	NVDA	Stock	0.867	0.8868	0.865	0.8848	261812000.0
2016-03-29	AMZN	Stock	29.0075	29.7925	28.825	29.693	87852000.0
2016-03-29	GOOGL	Stock	37.684	38.359	37.4145	38.2945	40061220.0
2016-03-29	META	Stock	113.83	116.32	113.64	116.14	29825300.0
2016-03-29	TSLA	Stock	15.326	15.492	15.022	15.342	60214500.0
2016-03-29	TLT	Stock	130.38	131.09	130.02	131.07	9396659.0
2016-03-29	ES	Stock	58.0	58.6	57.7	58.53	1309600.0
2016-03-29	CL	Stock	70.0	70.67	69.55	70.51	3217100.0
2016-03-29	A	Stock	39.35	40.22	39.11	40.16	1091200.0
2016-03-29	AA.B-DELISTED	Stock	32.35	32.82	31.75	32.82	26676.0
2016-03-29	AAAP-DELISTED	Stock	33.12	34.4	32.89	33.89	28079.0
2016-03-29	AABA-DELISTED	Stock	35.05	36.43	35.01	36.32	21453231.0
2016-03-29	AAC-DELISTED	Stock	18.29	18.635	17.95	18.4	181380.0
2016-03-29	AACG	Stock	5.38	5.38	5.05	5.05	4000.0
2016-03-29	AAIC-DELISTED	Stock	12.78	12.97	12.4327	12.95	346580.0
2016-03-29	AAL	Stock	40.9	41.43	40.77	41.35	6794000.0
2016-03-29	AAMC-DELISTED	Stock	3.5588	3.5941	3.3529	3.4618	185919.0
2016-03-29	AAME	Stock	4.03	4.25	3.81	4.14	4900.0
2016-03-29	AAMI	Stock	12.64	13.19	12.49	13.09	100300.0
2016-03-29	AAOI	Stock	15.1	15.2	14.64	15.05	546900.0
2016-03-29	AAON	Stock	17.8	18.68	17.8	18.68	285450.0
2016-03-29	AAP	Stock	161.59	163.08	160.43	163.03	662700.0
2016-03-29	AAT	Stock	38.37	39.42	38.28	39.4	136500.0
2016-03-29	AAU-DELISTED	Stock	0.6651	0.6909	0.6573	0.69	46964.0
2016-03-29	AAUAF-DELISTED	Stock	0.6651	0.6909	0.6573	0.69	47770.0
2016-03-29	AAV-DELISTED	Stock	5.14	5.28	5.1	5.23	63655.0
2016-03-29	AAVL-DELISTED	Stock	4.99	5.1	4.84	5.08	341308.0
2016-03-29	AAWW-DELISTED	Stock	40.08	42.0	39.9	41.84	208205.0
2016-03-29	AAXJ	Stock	53.29	54.12	53.19	54.12	341456.0
2016-03-29	AAXN-DELISTED	Stock	18.35	19.53	18.28	19.51	1289682.0
2016-03-29	AB	Stock	22.5	22.84	22.03	22.7	205700.0
2016-03-29	ABAC-DELISTED	Stock	0.7	0.7	0.69	0.69	4305.0
2016-03-29	ABAX-DELISTED	Stock	42.02	44.51	41.785	44.31	204835.0
2016-03-29	ABB-DELISTED	Stock	18.89	19.19	18.84	19.17	925329.0
2016-03-29	ABBNY-DELISTED	Stock	18.89	19.19	18.84	19.17	959866.0
2016-03-29	ABBV	Stock	56.1	57.1	55.22	57.05	4567900.0
2016-03-29	ABC-DELISTED	Stock	86.55	86.86	85.73	86.41	1219362.0
2016-03-29	ABCB	Stock	28.69	29.44	28.18	29.04	222300.0
2016-03-29	ABCD-DELISTED	Stock	4.38	4.59	4.36	4.36	40415.0
2016-03-29	ABCO-DELISTED	Stock	30.75	32.36	30.45	32.2	422519.0
2016-03-29	ABCW-DELISTED	Stock	44.49	45.14	44.265	45.14	42816.0
2016-03-29	ABDC-DELISTED	Stock	11.25	11.4545	11.2201	11.42	28624.0
2016-03-29	ABE-DELISTED	Stock	11.2515	11.41	11.2515	11.41	6704.0
2016-03-29	ABEO	Stock	65.25	71.75	64.5	71.5	1652.0
2016-03-29	ABEV	Stock	5.26	5.32	5.21	5.27	24180400.0
2016-03-29	ABG	Stock	59.18	61.92	58.81	61.78	309400.0
2016-03-29	ABGB-DELISTED	Stock	1.7	1.79	1.62	1.73	205930.0
2016-03-29	ABIL-DELISTED	Stock	6.25	6.28	6.05	6.07	1960.0

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

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