PREVIEW / stock_daily / 2016-08-16

all stock daily files

  file:    by_date/stock_daily/2016/2016-08-16.parquet
  size:    220 KB
  rows:    6,567
  symbols: 3,253

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-16	AAPL	Stock	27.4075	27.5575	27.3025	27.345	135177600.0
2016-08-16	MSFT	Stock	57.61	57.62	57.27	57.44	20523500.0
2016-08-16	NVDA	Stock	1.5723	1.5748	1.5602	1.565	287652000.0
2016-08-16	AMZN	Stock	38.431	38.4365	38.191	38.202	32092000.0
2016-08-16	GOOGL	Stock	40.175	40.213	39.85	40.0595	21157940.0
2016-08-16	META	Stock	123.5	123.92	122.78	123.3	14222400.0
2016-08-16	TSLA	Stock	15.0327	15.146	14.894	14.9073	34006500.0
2016-08-16	TLT	Stock	138.98	139.15	138.23	138.39	6182739.0
2016-08-16	ES	Stock	56.22	56.39	55.47	55.47	1421700.0
2016-08-16	CL	Stock	74.5	74.85	74.27	74.32	1807400.0
2016-08-16	A	Stock	48.27	48.54	48.12	48.28	3176000.0
2016-08-16	AA.B-DELISTED	Stock	36.15	36.15	35.34	35.34	68032.0
2016-08-16	AAAP-DELISTED	Stock	31.5699	32.2	31.49	32.04	16576.0
2016-08-16	AABA-DELISTED	Stock	42.3	42.79	41.95	42.5	13179641.0
2016-08-16	AAC-DELISTED	Stock	18.57	19.13	17.87	18.27	258373.0
2016-08-16	AACG	Stock	4.01	4.45	4.01	4.27	3700.0
2016-08-16	AAIC-DELISTED	Stock	14.66	14.7	14.46	14.53	295002.0
2016-08-16	AAL	Stock	35.67	36.79	35.63	36.75	9385000.0
2016-08-16	AAMC-DELISTED	Stock	3.9765	4.0853	3.9655	4.0324	19734.0
2016-08-16	AAMI	Stock	13.62	13.84	13.5	13.58	137500.0
2016-08-16	AAOI	Stock	14.02	14.18	13.92	14.0	265200.0
2016-08-16	AAON	Stock	18.1933	18.2933	18.0133	18.0267	124800.0
2016-08-16	AAP	Stock	162.0	165.4	160.34	160.4	3030800.0
2016-08-16	AAT	Stock	44.63	44.95	44.25	44.51	104500.0
2016-08-16	AAU-DELISTED	Stock	1.65	1.75	1.63	1.71	330711.0
2016-08-16	AAUAF-DELISTED	Stock	1.65	1.75	1.63	1.72	335271.0
2016-08-16	AAV-DELISTED	Stock	7.0	7.2718	6.99	7.22	211030.0
2016-08-16	AAWW-DELISTED	Stock	35.42	35.94	34.77	35.06	210723.0
2016-08-16	AAXJ	Stock	59.84	59.84	59.53	59.7	3277343.0
2016-08-16	AAXN-DELISTED	Stock	29.52	29.8	29.29	29.46	697951.0
2016-08-16	AB	Stock	22.24	22.29	21.72	21.86	229300.0
2016-08-16	ABAC-DELISTED	Stock	0.8499	0.92	0.751	0.786	178206.0
2016-08-16	ABAX-DELISTED	Stock	49.61	49.8	48.9	49.48	118109.0
2016-08-16	ABB-DELISTED	Stock	22.07	22.16	22.03	22.05	1054849.0
2016-08-16	ABBNY-DELISTED	Stock	22.07	22.16	22.03	22.05	1156744.0
2016-08-16	ABBV	Stock	67.13	67.61	66.5	66.74	7147600.0
2016-08-16	ABC-DELISTED	Stock	88.99	90.12	88.99	89.47	1333047.0
2016-08-16	ABCB	Stock	33.42	33.59	33.21	33.49	68300.0
2016-08-16	ABCD-DELISTED	Stock	4.707	4.72	4.68	4.71	17645.0
2016-08-16	ABCO-DELISTED	Stock	41.32	41.89	41.23	41.37	128296.0
2016-08-16	ABDC-DELISTED	Stock	12.39	12.48	12.36	12.36	18244.0
2016-08-16	ABE-DELISTED	Stock	12.8	12.8	12.77	12.7802	1362.0
2016-08-16	ABEO	Stock	98.5	102.25	95.0	98.25	2324.0
2016-08-16	ABEOW-DELISTED	Stock	1.71	1.71	1.65	1.7	2598.0
2016-08-16	ABEV	Stock	6.26	6.32	6.22	6.28	12181300.0
2016-08-16	ABG	Stock	56.69	56.79	55.85	55.94	118400.0
2016-08-16	ABIL-DELISTED	Stock	4.6	4.6	4.1811	4.25	89878.0
2016-08-16	ABM	Stock	38.17	38.33	37.9	37.99	172200.0
2016-08-16	ABMD-DELISTED	Stock	122.8	123.26	121.8301	122.51	199895.0
2016-08-16	ABR	Stock	7.31	7.32	7.26	7.29	54000.0

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

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