PREVIEW / stock_daily / 2017-06-16

all stock daily files

  file:    by_date/stock_daily/2017/2017-06-16.parquet
  size:    216 KB
  rows:    6,466
  symbols: 2,999

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
2017-06-16	AAPL	Stock	35.945	36.125	35.55	35.5675	201444400.0
2017-06-16	MSFT	Stock	69.73	70.03	69.22	70.0	48345100.0
2017-06-16	NVDA	Stock	3.819	3.8675	3.756	3.7905	924960000.0
2017-06-16	AMZN	Stock	49.8	49.9875	49.1	49.3855	229454000.0
2017-06-16	GOOGL	Stock	47.8955	47.9975	47.435	47.931	51184140.0
2017-06-16	META	Stock	149.59	150.83	148.6	150.64	22882400.0
2017-06-16	TSLA	Stock	25.1987	25.2007	24.6733	24.76	100965000.0
2017-06-16	TLT	Stock	126.08	126.44	126.01	126.35	6672543.0
2017-06-16	ES	Stock	62.71	63.28	62.63	63.24	2929900.0
2017-06-16	CL	Stock	76.0	76.6	75.8	76.31	3813700.0
2017-06-16	A	Stock	59.37	59.79	59.24	59.51	2157500.0
2017-06-16	AA	Stock	30.8	30.863	29.55	30.0	4767100.0
2017-06-16	AAAP-DELISTED	Stock	37.8	37.8	36.2	36.8	32899.0
2017-06-16	AABA-DELISTED	Stock	52.79	53.3	51.9	52.57	233529834.0
2017-06-16	AAC-DELISTED	Stock	6.55	6.6699	6.19	6.28	112395.0
2017-06-16	AACG	Stock	4.75	4.9	4.63	4.63	51200.0
2017-06-16	AAIC-DELISTED	Stock	14.67	14.81	14.59	14.79	465395.0
2017-06-16	AAL	Stock	48.9	49.45	48.62	48.79	6622100.0
2017-06-16	AAM.A-DELISTED	Stock	25.633	25.72	25.5917	25.72	52380.0
2017-06-16	AAMC-DELISTED	Stock	25.6765	26.7647	25.6765	26.3088	13365.0
2017-06-16	AAME	Stock	3.6	3.7	3.55	3.65	5400.0
2017-06-16	AAMI	Stock	14.76	15.09	14.7	14.93	1591500.0
2017-06-16	AAOI	Stock	62.23	63.15	60.1	62.88	2978300.0
2017-06-16	AAON	Stock	24.8667	25.1333	24.7333	24.8667	332700.0
2017-06-16	AAP	Stock	130.47	130.92	127.64	130.16	1725200.0
2017-06-16	AAT	Stock	40.69	40.69	39.86	40.06	380400.0
2017-06-16	AAU-DELISTED	Stock	1.4	1.4	1.31	1.3588	148315.0
2017-06-16	AAUAF-DELISTED	Stock	1.4	1.4	1.31	1.34	149612.0
2017-06-16	AAV-DELISTED	Stock	6.1	6.25	6.05	6.2	33609.0
2017-06-16	AAWW-DELISTED	Stock	52.75	52.95	52.15	52.4	248960.0
2017-06-16	AAXJ	Stock	67.22	67.22	66.89	67.18	650729.0
2017-06-16	AAXN-DELISTED	Stock	24.5	25.5	24.33	25.36	1120739.0
2017-06-16	AB	Stock	23.0	23.3	22.91	23.3	196100.0
2017-06-16	ABAC-DELISTED	Stock	2.109	2.12	1.99	2.04	9897.0
2017-06-16	ABAX-DELISTED	Stock	51.25	51.395	50.47	50.86	167544.0
2017-06-16	ABB-DELISTED	Stock	24.97	25.36	24.9499	25.35	2404881.0
2017-06-16	ABBNY-DELISTED	Stock	24.97	25.36	24.9499	25.36	2459477.0
2017-06-16	ABBV	Stock	70.8	71.12	70.49	71.05	9342300.0
2017-06-16	ABC-DELISTED	Stock	94.5	94.56	91.74	92.53	1666497.0
2017-06-16	ABCB	Stock	48.1	48.4	47.6	47.8	291800.0
2017-06-16	ABCD-DELISTED	Stock	4.87	4.93	4.83	4.91	31702.0
2017-06-16	ABCO-DELISTED	Stock	51.05	51.55	50.95	51.55	260749.0
2017-06-16	ABDC-DELISTED	Stock	13.4	13.4776	13.25	13.27	33900.0
2017-06-16	ABE-DELISTED	Stock	13.69	13.9	13.69	13.8765	4996.0
2017-06-16	ABEO	Stock	117.5	121.25	113.75	117.5	7644.0
2017-06-16	ABEV	Stock	5.47	5.47	5.33	5.34	77181000.0
2017-06-16	ABG	Stock	56.8	56.8	53.15	54.65	524300.0
2017-06-16	ABIL-DELISTED	Stock	1.26	1.274	1.13	1.23	301820.0
2017-06-16	ABM	Stock	41.29	41.84	41.12	41.77	735600.0
2017-06-16	ABMD-DELISTED	Stock	142.75	143.49	142.14	143.39	230339.0

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

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