PREVIEW / stock_daily / 2016-08-19

all stock daily files

  file:    by_date/stock_daily/2016/2016-08-19.parquet
  size:    219 KB
  rows:    6,539
  symbols: 3,235

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-08-19	AAPL	Stock	27.1925	27.4225	27.09	27.34	101472400.0
2016-08-19	MSFT	Stock	57.43	57.73	57.2	57.62	17271000.0
2016-08-19	NVDA	Stock	1.5518	1.5682	1.545	1.5565	291560000.0
2016-08-19	AMZN	Stock	38.095	38.1245	37.8445	37.8655	46864000.0
2016-08-19	GOOGL	Stock	39.9895	40.0615	39.844	39.9825	22415260.0
2016-08-19	META	Stock	123.6	124.16	123.28	123.56	11688300.0
2016-08-19	TSLA	Stock	14.9027	15.0113	14.8353	15.0	24892500.0
2016-08-19	TLT	Stock	138.64	139.05	138.1	138.71	5516269.0
2016-08-19	ES	Stock	56.33	56.47	55.27	55.54	1538800.0
2016-08-19	CL	Stock	74.33	74.51	74.09	74.49	2088500.0
2016-08-19	A	Stock	46.58	47.79	46.57	47.62	3340400.0
2016-08-19	AA.B-DELISTED	Stock	35.4	35.5165	35.02	35.12	24734.0
2016-08-19	AAAP-DELISTED	Stock	32.25	32.84	32.08	32.57	19098.0
2016-08-19	AABA-DELISTED	Stock	42.8	43.12	42.645	43.015	8377614.0
2016-08-19	AAC-DELISTED	Stock	17.52	17.75	17.08	17.29	186279.0
2016-08-19	AACG	Stock	3.93	3.93	3.93	3.93	300.0
2016-08-19	AAIC-DELISTED	Stock	14.42	14.52	14.37	14.5	117772.0
2016-08-19	AAL	Stock	36.44	36.74	36.1	36.49	6675300.0
2016-08-19	AAMC-DELISTED	Stock	4.1324	4.1676	4.0676	4.1588	42884.0
2016-08-19	AAMI	Stock	13.61	13.61	13.48	13.56	115400.0
2016-08-19	AAOI	Stock	13.33	13.82	13.08	13.74	285600.0
2016-08-19	AAON	Stock	18.3667	18.5133	18.04	18.44	183900.0
2016-08-19	AAP	Stock	156.97	159.72	156.97	158.04	1140500.0
2016-08-19	AAT	Stock	44.38	44.64	44.13	44.39	162000.0
2016-08-19	AAU-DELISTED	Stock	1.64	1.7	1.63	1.64	195914.0
2016-08-19	AAUAF-DELISTED	Stock	1.64	1.7	1.63	1.65	197751.0
2016-08-19	AAV-DELISTED	Stock	7.39	7.39	7.21	7.25	45375.0
2016-08-19	AAWW-DELISTED	Stock	34.57	35.03	34.22	34.82	218419.0
2016-08-19	AAXJ	Stock	59.26	59.54	59.03	59.47	506679.0
2016-08-19	AAXN-DELISTED	Stock	29.38	29.4	29.03	29.1	628850.0
2016-08-19	AB	Stock	21.98	22.19	21.95	22.01	120200.0
2016-08-19	ABAC-DELISTED	Stock	0.7202	0.79	0.7202	0.79	6400.0
2016-08-19	ABAX-DELISTED	Stock	49.11	49.14	48.51	49.0	67781.0
2016-08-19	ABB-DELISTED	Stock	21.99	22.09	21.9	22.06	1196739.0
2016-08-19	ABBNY-DELISTED	Stock	21.99	22.09	21.9	22.06	1240588.0
2016-08-19	ABBV	Stock	66.57	67.18	66.51	67.1	6709400.0
2016-08-19	ABC-DELISTED	Stock	88.53	89.0	88.26	88.84	1851249.0
2016-08-19	ABCB	Stock	33.7	33.75	32.76	33.6	105000.0
2016-08-19	ABCD-DELISTED	Stock	4.8	4.84	4.731	4.77	18550.0
2016-08-19	ABCO-DELISTED	Stock	41.17	41.89	40.84	41.59	233770.0
2016-08-19	ABDC-DELISTED	Stock	12.42	12.49	12.35	12.41	28332.0
2016-08-19	ABE-DELISTED	Stock	12.71	12.77	12.64	12.6931	1728.0
2016-08-19	ABEO	Stock	110.0	110.0	102.5	103.5	4792.0
2016-08-19	ABEOW-DELISTED	Stock	1.88	1.88	1.85	1.88	1800.0
2016-08-19	ABEV	Stock	6.15	6.22	6.1	6.18	10597100.0
2016-08-19	ABG	Stock	54.02	54.4	53.22	53.94	195000.0
2016-08-19	ABIL-DELISTED	Stock	4.28	4.32	4.167	4.28	16724.0
2016-08-19	ABM	Stock	37.92	37.94	37.71	37.84	215000.0
2016-08-19	ABMD-DELISTED	Stock	121.0	122.06	120.35	121.44	321240.0
2016-08-19	ABR	Stock	7.31	7.31	7.26	7.3	55900.0

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

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