PREVIEW / stock_daily / 2016-07-11

all stock daily files

  file:    by_date/stock_daily/2016/2016-07-11.parquet
  size:    219 KB
  rows:    6,565
  symbols: 3,258

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-11	AAPL	Stock	24.1875	24.4125	24.1825	24.245	95179600.0
2016-07-11	MSFT	Stock	52.5	52.83	52.47	52.59	22269200.0
2016-07-11	NVDA	Stock	1.2895	1.31	1.288	1.3005	448776000.0
2016-07-11	AMZN	Stock	37.5	37.795	37.35	37.689	63906000.0
2016-07-11	GOOGL	Stock	35.971	36.4464	35.9432	36.36	28822260.0
2016-07-11	META	Stock	117.71	118.7	117.5	117.87	17711600.0
2016-07-11	TSLA	Stock	14.664	15.1187	14.634	14.9853	81447000.0
2016-07-11	TLT	Stock	143.05	143.465	142.24	142.34	8099048.0
2016-07-11	ES	Stock	59.33	59.43	58.73	59.33	1744700.0
2016-07-11	CL	Stock	74.05	74.58	73.72	74.49	3040700.0
2016-07-11	A	Stock	45.61	45.77	45.35	45.4	1094700.0
2016-07-11	AA.B-DELISTED	Stock	34.94	35.3278	34.63	35.3278	31786.0
2016-07-11	AAAP-DELISTED	Stock	30.72	31.0	30.38	30.98	15102.0
2016-07-11	AABA-DELISTED	Stock	37.67	38.15	37.37	37.96	18734699.0
2016-07-11	AAC-DELISTED	Stock	22.78	22.795	21.47	22.48	85075.0
2016-07-11	AACG	Stock	4.26	4.26	4.15	4.2	6100.0
2016-07-11	AAIC-DELISTED	Stock	12.97	13.1759	12.97	13.12	268247.0
2016-07-11	AAL	Stock	30.23	31.44	30.22	31.16	12374400.0
2016-07-11	AAMC-DELISTED	Stock	4.0382	4.2059	4.0	4.1088	72699.0
2016-07-11	AAMI	Stock	13.26	13.56	13.2	13.55	135900.0
2016-07-11	AAOI	Stock	11.49	11.53	10.86	11.07	458800.0
2016-07-11	AAON	Stock	18.2867	18.7733	18.18	18.5867	191100.0
2016-07-11	AAP	Stock	164.85	166.32	163.58	163.69	679200.0
2016-07-11	AAT	Stock	43.33	43.67	42.82	43.61	313200.0
2016-07-11	AAU-DELISTED	Stock	1.45	1.54	1.42	1.5	866466.0
2016-07-11	AAUAF-DELISTED	Stock	1.45	1.54	1.42	1.5	872780.0
2016-07-11	AAV-DELISTED	Stock	5.83	5.86	5.7	5.72	81758.0
2016-07-11	AAWW-DELISTED	Stock	41.4	41.77	40.59	41.49	165160.0
2016-07-11	AAXJ	Stock	55.25	55.7	55.25	55.49	1550004.0
2016-07-11	AAXN-DELISTED	Stock	27.6	28.58	27.5	27.66	1919163.0
2016-07-11	AB	Stock	23.21	23.67	23.21	23.49	165900.0
2016-07-11	ABAC-DELISTED	Stock	0.81	0.85	0.791	0.8	19704.0
2016-07-11	ABAX-DELISTED	Stock	51.06	52.04	50.52	51.98	172372.0
2016-07-11	ABB-DELISTED	Stock	19.37	19.46	19.34	19.36	1664204.0
2016-07-11	ABBNY-DELISTED	Stock	19.37	19.46	19.34	19.36	1746078.0
2016-07-11	ABBV	Stock	64.25	64.99	64.07	64.35	9641500.0
2016-07-11	ABC-DELISTED	Stock	81.97	82.6	81.85	82.2	1277806.0
2016-07-11	ABCB	Stock	29.72	30.11	29.65	30.09	119800.0
2016-07-11	ABCD-DELISTED	Stock	4.71	4.93	4.71	4.8	13839.0
2016-07-11	ABCO-DELISTED	Stock	37.7	38.21	37.18	38.08	205403.0
2016-07-11	ABDC-DELISTED	Stock	12.32	12.455	12.3	12.36	74556.0
2016-07-11	ABE-DELISTED	Stock	12.45	12.45	12.25	12.34	14358.0
2016-07-11	ABEO	Stock	59.75	61.25	59.0	59.25	2096.0
2016-07-11	ABEV	Stock	5.88	5.89	5.8	5.83	11141100.0
2016-07-11	ABG	Stock	55.17	56.34	55.17	55.95	214900.0
2016-07-11	ABIL-DELISTED	Stock	4.32	4.44	4.27	4.41	57218.0
2016-07-11	ABM	Stock	36.86	37.14	36.76	37.07	157900.0
2016-07-11	ABMD-DELISTED	Stock	115.0	116.71	114.63	115.98	719076.0
2016-07-11	ABR	Stock	7.18	7.18	7.1	7.16	39700.0
2016-07-11	ABR.A-DELISTED	Stock	25.2	25.4	25.2	25.4	4148.0

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

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