PREVIEW / stock_daily / 2015-09-10

all stock daily files

  file:    by_date/stock_daily/2015/2015-09-10.parquet
  size:    221 KB
  rows:    6,646
  symbols: 3,448

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
2015-09-10	AAPL	Stock	27.5675	28.32	27.475	28.1425	251571200.0
2015-09-10	MSFT	Stock	43.12	43.79	42.75	43.29	31366600.0
2015-09-10	NVDA	Stock	0.5525	0.5715	0.55	0.5645	357076000.0
2015-09-10	AMZN	Stock	25.7575	26.3065	25.739	26.112	51520000.0
2015-09-10	GOOGL	Stock	32.195	32.745	32.085	32.554	27849620.0
2015-09-10	META	Stock	90.07	92.06	89.63	91.98	26437400.0
2015-09-10	TSLA	Stock	16.482	16.7147	16.3553	16.5653	40635000.0
2015-09-10	TLT	Stock	121.02	121.19	120.45	120.63	6789671.0
2015-09-10	ES	Stock	45.3	45.91	45.3	45.5	1707500.0
2015-09-10	CL	Stock	62.28	62.48	61.31	61.93	5223900.0
2015-09-10	A	Stock	35.61	36.04	35.44	35.86	1628700.0
2015-09-10	AA.B-DELISTED	Stock	36.01	36.24	35.27	35.27	63698.0
2015-09-10	AABA-DELISTED	Stock	31.35	31.59	30.785	31.16	13683048.0
2015-09-10	AAC-DELISTED	Stock	22.25	23.8576	22.11	23.04	305530.0
2015-09-10	AACG	Stock	2.38	2.44	2.38	2.42	8600.0
2015-09-10	AAIC-DELISTED	Stock	15.87	15.95	15.7006	15.9	206315.0
2015-09-10	AAL	Stock	41.39	41.88	40.71	41.21	9181600.0
2015-09-10	AAMC-DELISTED	Stock	8.1265	8.1265	6.5059	7.3529	254252.0
2015-09-10	AAME	Stock	3.56	3.59	3.45	3.58	7100.0
2015-09-10	AAMI	Stock	16.41	16.46	16.17	16.3	88100.0
2015-09-10	AAOI	Stock	20.72	21.59	20.63	21.26	223300.0
2015-09-10	AAON	Stock	13.32	13.42	13.1333	13.2533	108300.0
2015-09-10	AAP	Stock	174.39	176.7	173.1	174.88	885300.0
2015-09-10	AAT	Stock	37.86	38.45	37.69	38.01	101800.0
2015-09-10	AAU-DELISTED	Stock	0.5541	0.57	0.5095	0.553	107033.0
2015-09-10	AAUAF-DELISTED	Stock	0.5541	0.57	0.5095	0.553	111333.0
2015-09-10	AAV-DELISTED	Stock	5.29	5.5	5.29	5.48	62586.0
2015-09-10	AAVL-DELISTED	Stock	10.74	11.065	10.54	11.01	328874.0
2015-09-10	AAWW-DELISTED	Stock	38.71	40.12	38.61	39.71	251966.0
2015-09-10	AAXJ	Stock	53.3	53.75	53.11	53.48	1595141.0
2015-09-10	AAXN-DELISTED	Stock	23.65	24.02	23.54	23.77	611502.0
2015-09-10	AB	Stock	26.38	26.86	26.26	26.32	244200.0
2015-09-10	ABAC-DELISTED	Stock	0.8001	0.81	0.7101	0.7268	8100.0
2015-09-10	ABAX-DELISTED	Stock	48.37	48.935	48.28	48.56	40620.0
2015-09-10	ABB-DELISTED	Stock	18.63	18.775	18.49	18.675	1699689.0
2015-09-10	ABBNY-DELISTED	Stock	18.63	18.775	18.49	18.67	1745322.0
2015-09-10	ABBV	Stock	59.36	60.13	58.89	59.58	9306600.0
2015-09-10	ABC-DELISTED	Stock	100.65	102.88	100.36	102.09	1467830.0
2015-09-10	ABCB	Stock	27.63	28.01	27.54	27.86	109500.0
2015-09-10	ABCD-DELISTED	Stock	4.98	5.04	4.85	4.87	77800.0
2015-09-10	ABCO-DELISTED	Stock	48.2	48.65	47.9	48.22	144771.0
2015-09-10	ABCW-DELISTED	Stock	41.51	41.84	41.24	41.3	28754.0
2015-09-10	ABDC-DELISTED	Stock	12.81	12.86	12.74	12.83	19553.0
2015-09-10	ABE-DELISTED	Stock	11.03	11.03	11.03	11.03	500.0
2015-09-10	ABEO	Stock	125.75	138.0	124.75	132.75	4552.0
2015-09-10	ABEOW-DELISTED	Stock	2.0	2.35	2.0	2.2	5400.0
2015-09-10	ABEV	Stock	4.87	5.05	4.86	4.97	14917200.0
2015-09-10	ABG	Stock	81.63	82.28	81.01	81.28	146100.0
2015-09-10	ABGB-DELISTED	Stock	5.88	5.99	5.87	5.93	24029.0
2015-09-10	ABM	Stock	29.73	29.84	29.5	29.55	886300.0

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

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