PREVIEW / stock_daily / 2016-06-09

all stock daily files

  file:    by_date/stock_daily/2016/2016-06-09.parquet
  size:    218 KB
  rows:    6,555
  symbols: 3,273

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-06-09	AAPL	Stock	24.625	24.9975	24.615	24.9125	106405600.0
2016-06-09	MSFT	Stock	52.0	52.0	51.49	51.62	20305700.0
2016-06-09	NVDA	Stock	1.1505	1.1862	1.148	1.1845	472168000.0
2016-06-09	AMZN	Stock	36.155	36.4455	36.115	36.3825	43406000.0
2016-06-09	GOOGL	Stock	36.8535	37.1965	36.825	37.126	19179260.0
2016-06-09	META	Stock	118.13	118.68	117.71	118.56	13859200.0
2016-06-09	TSLA	Stock	15.6653	15.6887	15.1373	15.2907	67381500.0
2016-06-09	TLT	Stock	134.32	134.54	133.93	134.13	6820290.0
2016-06-09	ES	Stock	56.35	56.97	56.27	56.88	1240900.0
2016-06-09	CL	Stock	71.85	72.41	71.74	72.34	1943200.0
2016-06-09	A	Stock	45.98	46.18	45.88	46.09	1203900.0
2016-06-09	AA.B-DELISTED	Stock	34.63	34.83	33.8	34.81	44260.0
2016-06-09	AAAP-DELISTED	Stock	31.8	32.07	31.55	32.0	70449.0
2016-06-09	AABA-DELISTED	Stock	36.82	37.73	36.71	37.36	14019192.0
2016-06-09	AAC-DELISTED	Stock	21.42	21.465	20.77	21.1	126349.0
2016-06-09	AACG	Stock	5.26	5.32	5.07	5.11	7200.0
2016-06-09	AAIC-DELISTED	Stock	13.85	13.94	13.55	13.78	339420.0
2016-06-09	AAL	Stock	32.25	33.58	32.25	33.4	8188300.0
2016-06-09	AAMC-DELISTED	Stock	6.4647	6.5	6.0294	6.0765	47583.0
2016-06-09	AAME	Stock	3.53	3.53	3.53	3.53	800.0
2016-06-09	AAMI	Stock	14.9	15.01	14.72	14.78	82800.0
2016-06-09	AAOI	Stock	11.38	11.525	10.63	10.76	327900.0
2016-06-09	AAON	Stock	18.3733	18.5067	18.1933	18.4533	93900.0
2016-06-09	AAP	Stock	153.89	157.46	153.89	156.78	2680400.0
2016-06-09	AAT	Stock	41.34	41.5	41.07	41.32	156400.0
2016-06-09	AAU-DELISTED	Stock	1.28	1.34	1.24	1.26	548681.0
2016-06-09	AAUAF-DELISTED	Stock	1.28	1.34	1.24	1.26	550842.0
2016-06-09	AAV-DELISTED	Stock	5.94	6.09	5.93	5.94	130667.0
2016-06-09	AAWW-DELISTED	Stock	46.14	47.24	45.96	46.82	286870.0
2016-06-09	AAXJ	Stock	54.66	54.84	54.6	54.78	520073.0
2016-06-09	AAXN-DELISTED	Stock	23.47	23.765	23.23	23.3	772481.0
2016-06-09	AB	Stock	23.27	23.88	23.25	23.54	286600.0
2016-06-09	ABAC-DELISTED	Stock	0.77	0.82	0.71	0.7984	12470.0
2016-06-09	ABAX-DELISTED	Stock	46.64	47.12	45.69	46.96	77640.0
2016-06-09	ABB-DELISTED	Stock	21.03	21.16	21.03	21.13	1749475.0
2016-06-09	ABBNY-DELISTED	Stock	21.03	21.16	21.03	21.14	1805592.0
2016-06-09	ABBV	Stock	61.5	62.17	60.52	60.75	11503700.0
2016-06-09	ABC-DELISTED	Stock	76.22	76.42	75.9	76.18	2859547.0
2016-06-09	ABCB	Stock	31.85	31.87	31.27	31.68	148900.0
2016-06-09	ABCD-DELISTED	Stock	4.57	4.64	4.5398	4.57	10799.0
2016-06-09	ABCO-DELISTED	Stock	35.03	35.03	34.61	34.65	261711.0
2016-06-09	ABDC-DELISTED	Stock	12.2	12.25	12.19	12.23	6532.0
2016-06-09	ABE-DELISTED	Stock	12.3067	12.3135	12.26	12.26	2622.0
2016-06-09	ABEO	Stock	77.75	79.5	77.75	79.0	1840.0
2016-06-09	ABEV	Stock	5.65	5.67	5.58	5.64	9272800.0
2016-06-09	ABG	Stock	57.19	57.19	54.94	55.51	354500.0
2016-06-09	ABIL-DELISTED	Stock	3.62	3.679	3.51	3.55	14128.0
2016-06-09	ABM	Stock	35.73	37.59	35.16	37.27	1351900.0
2016-06-09	ABMD-DELISTED	Stock	104.23	104.9173	103.255	104.32	322640.0
2016-06-09	ABR	Stock	7.02	7.09	6.97	7.04	210800.0

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

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