PREVIEW / stock_daily / 2016-07-27

all stock daily files

  file:    by_date/stock_daily/2016/2016-07-27.parquet
  size:    220 KB
  rows:    6,564
  symbols: 3,254

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-07-27	AAPL	Stock	26.0675	26.0875	25.6875	25.7375	369379200.0
2016-07-27	MSFT	Stock	56.61	56.8	56.11	56.19	32327500.0
2016-07-27	NVDA	Stock	1.428	1.4305	1.393	1.4015	446676000.0
2016-07-27	AMZN	Stock	36.8985	37.047	36.693	36.8335	58262000.0
2016-07-27	GOOGL	Stock	37.9485	38.2225	37.7965	38.0985	32171780.0
2016-07-27	META	Stock	122.42	125.0	121.51	123.34	52654200.0
2016-07-27	TSLA	Stock	15.2893	15.5573	15.128	15.2327	43335000.0
2016-07-27	TLT	Stock	139.55	140.65	139.4	140.65	8508125.0
2016-07-27	ES	Stock	58.12	58.33	57.24	57.71	1259900.0
2016-07-27	CL	Stock	74.17	74.17	72.91	73.28	3291700.0
2016-07-27	A	Stock	47.0	47.46	46.73	47.26	1572600.0
2016-07-27	AA.B-DELISTED	Stock	36.51	37.1634	36.07	36.8	36647.0
2016-07-27	AAAP-DELISTED	Stock	30.85	31.05	30.75	30.98	66994.0
2016-07-27	AABA-DELISTED	Stock	38.66	38.77	38.43	38.67	11702876.0
2016-07-27	AAC-DELISTED	Stock	22.74	24.38	22.73	23.52	168746.0
2016-07-27	AACG	Stock	3.83	3.85	3.65	3.82	5500.0
2016-07-27	AAIC-DELISTED	Stock	13.39	13.7	13.39	13.6	335241.0
2016-07-27	AAL	Stock	36.5	36.6	35.9	36.2	6671200.0
2016-07-27	AAMC-DELISTED	Stock	3.9706	4.0676	3.8324	3.8324	58347.0
2016-07-27	AAMI	Stock	13.84	14.16	13.84	14.08	97100.0
2016-07-27	AAOI	Stock	13.31	13.52	12.51	12.74	201100.0
2016-07-27	AAON	Stock	17.82	17.8267	17.6467	17.7	352200.0
2016-07-27	AAP	Stock	167.02	167.66	164.47	164.73	836100.0
2016-07-27	AAT	Stock	45.69	46.38	44.45	44.69	221000.0
2016-07-27	AAU-DELISTED	Stock	1.35	1.49	1.34	1.47	590499.0
2016-07-27	AAUAF-DELISTED	Stock	1.35	1.49	1.34	1.47	594039.0
2016-07-27	AAV-DELISTED	Stock	6.38	6.48	6.17	6.3092	76742.0
2016-07-27	AAWW-DELISTED	Stock	41.98	42.53	41.63	42.35	128119.0
2016-07-27	AAXJ	Stock	57.52	57.68	57.12	57.51	1103989.0
2016-07-27	AAXN-DELISTED	Stock	28.82	28.99	28.57	28.78	753922.0
2016-07-27	AB	Stock	24.05	24.38	24.05	24.29	145300.0
2016-07-27	ABAC-DELISTED	Stock	0.74	0.7499	0.711	0.7258	5900.0
2016-07-27	ABAX-DELISTED	Stock	48.96	49.42	48.675	49.15	115375.0
2016-07-27	ABB-DELISTED	Stock	20.91	20.99	20.8	20.94	1538113.0
2016-07-27	ABBNY-DELISTED	Stock	20.91	20.99	20.8	20.94	1601765.0
2016-07-27	ABBV	Stock	64.42	65.11	64.32	64.9	6220400.0
2016-07-27	ABC-DELISTED	Stock	85.71	85.8	84.66	85.43	1622722.0
2016-07-27	ABCB	Stock	33.01	33.74	32.88	33.66	354400.0
2016-07-27	ABCD-DELISTED	Stock	4.8211	4.885	4.82	4.885	4680.0
2016-07-27	ABCO-DELISTED	Stock	37.75	37.75	36.93	37.09	177544.0
2016-07-27	ABDC-DELISTED	Stock	12.23	12.34	12.21	12.24	15507.0
2016-07-27	ABE-DELISTED	Stock	12.54	12.64	12.54	12.58	5788.0
2016-07-27	ABEO	Stock	63.75	66.0	60.5	62.75	1708.0
2016-07-27	ABEV	Stock	5.89	5.92	5.82	5.88	7358700.0
2016-07-27	ABG	Stock	61.13	61.83	60.0	60.06	277700.0
2016-07-27	ABIL-DELISTED	Stock	4.42	4.53	4.36	4.51	18064.0
2016-07-27	ABM	Stock	37.5	37.62	37.16	37.61	178900.0
2016-07-27	ABMD-DELISTED	Stock	114.93	116.45	114.12	116.0	823014.0
2016-07-27	ABR	Stock	7.06	7.17	7.04	7.16	78700.0
2016-07-27	ABR.A-DELISTED	Stock	25.8	25.8	25.49	25.49	3100.0

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

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