PREVIEW / stock_daily / 2016-01-26

all stock daily files

  file:    by_date/stock_daily/2016/2016-01-26.parquet
  size:    218 KB
  rows:    6,595
  symbols: 3,351

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-26	AAPL	Stock	24.9825	25.22	24.5175	24.9975	300308000.0
2016-01-26	MSFT	Stock	51.79	52.44	51.55	52.17	28900800.0
2016-01-26	NVDA	Stock	0.712	0.7205	0.7048	0.7175	227944000.0
2016-01-26	AMZN	Stock	30.1725	30.225	29.519	30.0625	75314000.0
2016-01-26	GOOGL	Stock	36.7605	36.973	36.3485	36.6895	30940980.0
2016-01-26	META	Stock	97.76	97.88	95.66	97.34	26877100.0
2016-01-26	TSLA	Stock	13.1133	13.188	12.592	12.904	74463000.0
2016-01-26	TLT	Stock	125.99	126.46	125.75	126.08	5692621.0
2016-01-26	ES	Stock	51.77	52.68	51.74	52.15	1538600.0
2016-01-26	CL	Stock	64.01	64.81	63.98	64.33	3658900.0
2016-01-26	A	Stock	37.89	37.96	37.36	37.51	1754900.0
2016-01-26	AA.B-DELISTED	Stock	25.15	25.7	24.6	25.54	36742.0
2016-01-26	AAAP-DELISTED	Stock	25.0	25.11	20.53	24.5	49266.0
2016-01-26	AABA-DELISTED	Stock	29.76	30.19	29.62	29.99	10627161.0
2016-01-26	AAC-DELISTED	Stock	18.44	19.5	18.01	19.46	137541.0
2016-01-26	AACG	Stock	5.47	5.49	5.3	5.3	4000.0
2016-01-26	AAIC-DELISTED	Stock	10.5	10.9	10.36	10.84	249372.0
2016-01-26	AAL	Stock	38.73	39.75	38.44	39.64	8099000.0
2016-01-26	AAMC-DELISTED	Stock	4.9059	5.3647	4.8882	4.9853	485639.0
2016-01-26	AAME	Stock	4.47	4.47	4.02	4.26	3500.0
2016-01-26	AAMI	Stock	10.82	11.09	10.72	10.98	421900.0
2016-01-26	AAOI	Stock	13.49	15.41	13.375	15.14	497400.0
2016-01-26	AAON	Stock	13.6333	13.9933	13.6333	13.9467	175650.0
2016-01-26	AAP	Stock	145.44	152.71	144.76	151.47	1156100.0
2016-01-26	AAT	Stock	37.1	37.8	37.03	37.67	266700.0
2016-01-26	AAU-DELISTED	Stock	0.5697	0.6119	0.544	0.6119	68873.0
2016-01-26	AAUAF-DELISTED	Stock	0.5697	0.6119	0.544	0.6119	69943.0
2016-01-26	AAV-DELISTED	Stock	5.07	5.36	5.04	5.36	141976.0
2016-01-26	AAVL-DELISTED	Stock	6.4	6.51	5.96	6.48	283538.0
2016-01-26	AAWW-DELISTED	Stock	34.64	36.19	34.14	35.83	171650.0
2016-01-26	AAXJ	Stock	48.06	48.58	48.06	48.47	852820.0
2016-01-26	AAXN-DELISTED	Stock	15.08	15.87	14.72	15.85	1376803.0
2016-01-26	AB	Stock	19.13	19.29	18.63	19.07	228700.0
2016-01-26	ABAC-DELISTED	Stock	0.6436	0.677	0.6436	0.67	2594.0
2016-01-26	ABAX-DELISTED	Stock	52.19	52.95	51.02	52.45	134225.0
2016-01-26	ABB-DELISTED	Stock	16.51	16.69	16.48	16.67	2341171.0
2016-01-26	ABBNY-DELISTED	Stock	16.51	16.69	16.48	16.67	2392134.0
2016-01-26	ABBV	Stock	59.01	59.27	57.21	58.26	7421100.0
2016-01-26	ABC-DELISTED	Stock	91.41	91.59	90.61	91.25	1200982.0
2016-01-26	ABCB	Stock	26.61	27.27	26.5	27.22	566500.0
2016-01-26	ABCD-DELISTED	Stock	4.51	4.66	4.4501	4.61	29971.0
2016-01-26	ABCO-DELISTED	Stock	44.63	44.63	42.94	43.24	201434.0
2016-01-26	ABCW-DELISTED	Stock	41.475	41.61	41.32	41.35	146782.0
2016-01-26	ABDC-DELISTED	Stock	10.3	11.21	10.3	10.79	17129.0
2016-01-26	ABE-DELISTED	Stock	10.03	10.11	10.0	10.0	1500.0
2016-01-26	ABEO	Stock	69.25	69.25	63.5	66.25	2860.0
2016-01-26	ABEOW-DELISTED	Stock	0.88	0.88	0.88	0.88	1300.0
2016-01-26	ABEV	Stock	4.07	4.16	4.04	4.16	17300900.0
2016-01-26	ABG	Stock	49.54	49.6	48.34	49.09	3361000.0
2016-01-26	ABGB-DELISTED	Stock	1.1	1.1	0.9027	0.95	77581.0

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

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