PREVIEW / stock_daily / 2016-01-11

all stock daily files

  file:    by_date/stock_daily/2016/2016-01-11.parquet
  size:    220 KB
  rows:    6,613
  symbols: 3,378

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-01-11	AAPL	Stock	24.7425	24.765	24.335	24.6325	198957600.0
2016-01-11	MSFT	Stock	52.51	52.85	51.46	52.3	36943800.0
2016-01-11	NVDA	Stock	0.7415	0.7473	0.7288	0.742	409372000.0
2016-01-11	AMZN	Stock	30.624	30.9925	29.9285	30.887	97832000.0
2016-01-11	GOOGL	Stock	36.5975	36.754	35.978	36.6535	50896120.0
2016-01-11	META	Stock	97.91	98.6	95.39	97.51	29932400.0
2016-01-11	TSLA	Stock	14.2673	14.2967	13.5333	13.8567	61371000.0
2016-01-11	TLT	Stock	122.04	122.79	121.8601	122.01	10040254.0
2016-01-11	ES	Stock	50.91	51.32	50.58	51.03	1097500.0
2016-01-11	CL	Stock	62.85	63.2	62.08	62.81	3079100.0
2016-01-11	A	Stock	38.71	38.9	37.41	37.94	2818400.0
2016-01-11	AA.B-DELISTED	Stock	29.1	29.1	27.84	28.18	59367.0
2016-01-11	AAAP-DELISTED	Stock	28.2	29.0	26.26	26.52	124161.0
2016-01-11	AABA-DELISTED	Stock	30.65	30.7501	29.74	30.16	16468926.0
2016-01-11	AAC-DELISTED	Stock	18.25	18.36	17.21	17.43	87634.0
2016-01-11	AACG	Stock	4.87	5.89	3.97	5.05	76700.0
2016-01-11	AAIC-DELISTED	Stock	12.61	12.67	12.34	12.39	329186.0
2016-01-11	AAL	Stock	40.56	41.2	39.9	41.08	15877500.0
2016-01-11	AAMC-DELISTED	Stock	4.5588	5.0	4.3706	4.9471	247476.0
2016-01-11	AAME	Stock	4.5	4.5	4.26	4.26	1400.0
2016-01-11	AAMI	Stock	13.44	13.84	13.36	13.76	325300.0
2016-01-11	AAOI	Stock	14.93	15.12	14.36	14.71	239700.0
2016-01-11	AAON	Stock	13.7333	13.84	13.4533	13.7733	211050.0
2016-01-11	AAP	Stock	146.13	148.12	145.06	147.05	1114400.0
2016-01-11	AAT	Stock	37.7	38.05	37.55	37.81	142900.0
2016-01-11	AAU-DELISTED	Stock	0.6105	0.62	0.59	0.6	97306.0
2016-01-11	AAUAF-DELISTED	Stock	0.6105	0.62	0.59	0.6	98263.0
2016-01-11	AAV-DELISTED	Stock	4.81	4.81	4.501	4.62	76396.0
2016-01-11	AAVL-DELISTED	Stock	7.32	7.32	6.455	6.64	327987.0
2016-01-11	AAWW-DELISTED	Stock	35.53	35.53	33.265	33.73	250281.0
2016-01-11	AAXJ	Stock	49.33	49.49	48.74	49.14	1787522.0
2016-01-11	AAXN-DELISTED	Stock	16.5	16.72	15.57	15.85	1506871.0
2016-01-11	AB	Stock	21.69	21.82	20.55	20.61	410900.0
2016-01-11	ABAC-DELISTED	Stock	0.92	0.9899	0.92	0.92	14392.0
2016-01-11	ABAX-DELISTED	Stock	51.86	52.37	49.71	50.73	156928.0
2016-01-11	ABB-DELISTED	Stock	16.48	16.5	16.2	16.32	2788844.0
2016-01-11	ABBNY-DELISTED	Stock	16.48	16.5	16.2	16.31	2848573.0
2016-01-11	ABBV	Stock	55.86	55.98	52.83	53.88	10483300.0
2016-01-11	ABC-DELISTED	Stock	95.51	96.0	93.81	94.11	5515539.0
2016-01-11	ABCB	Stock	31.37	31.73	30.97	31.2	318100.0
2016-01-11	ABCD-DELISTED	Stock	4.68	4.7	4.53	4.61	60510.0
2016-01-11	ABCO-DELISTED	Stock	45.66	46.25	45.1	45.855	226855.0
2016-01-11	ABCW-DELISTED	Stock	43.44	43.66	42.35	42.6	72917.0
2016-01-11	ABDC-DELISTED	Stock	11.87	11.92	11.32	11.49	30769.0
2016-01-11	ABE-DELISTED	Stock	10.3	10.304	10.17	10.22	8154.0
2016-01-11	ABEO	Stock	75.25	83.25	66.75	70.0	5024.0
2016-01-11	ABEOW-DELISTED	Stock	1.05	1.1	1.05	1.1	4658.0
2016-01-11	ABEV	Stock	4.25	4.27	4.09	4.11	20853200.0
2016-01-11	ABG	Stock	53.62	55.9	53.5	55.71	523100.0
2016-01-11	ABGB-DELISTED	Stock	1.24	1.27	1.2	1.27	20082.0

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

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