PREVIEW / stock_daily / 2016-11-30

all stock daily files

  file:    by_date/stock_daily/2016/2016-11-30.parquet
  size:    215 KB
  rows:    6,532
  symbols: 3,169

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-11-30	AAPL	Stock	27.9	28.05	27.5675	27.63	144649200.0
2016-11-30	MSFT	Stock	60.86	61.18	60.22	60.26	34655400.0
2016-11-30	NVDA	Stock	2.34	2.354	2.3025	2.305	440500000.0
2016-11-30	AMZN	Stock	38.1	38.4045	37.5125	37.5285	92518000.0
2016-11-30	GOOGL	Stock	39.455	39.5755	38.6573	38.794	45581080.0
2016-11-30	META	Stock	120.32	121.79	117.95	118.42	30188900.0
2016-11-30	TSLA	Stock	12.7333	12.7927	12.5	12.6267	53206500.0
2016-11-30	TLT	Stock	119.97	121.01	119.48	120.24	21163537.0
2016-11-30	ES	Stock	53.13	53.21	51.6	51.62	2733900.0
2016-11-30	CL	Stock	66.27	66.67	65.23	65.23	4515900.0
2016-11-30	A	Stock	44.79	44.9	43.94	43.98	2238600.0
2016-11-30	AA	Stock	30.06	30.44	28.85	28.97	5131700.0
2016-11-30	AAAP-DELISTED	Stock	29.25	29.87	28.95	29.2686	93183.0
2016-11-30	AABA-DELISTED	Stock	41.66	41.67	40.88	41.04	7080281.0
2016-11-30	AAC-DELISTED	Stock	8.58	8.8	8.29	8.4	219735.0
2016-11-30	AACG	Stock	4.0	4.06	3.8	3.94	2900.0
2016-11-30	AAIC-DELISTED	Stock	16.65	16.65	16.18	16.24	312868.0
2016-11-30	AAL	Stock	46.14	46.86	45.42	46.44	7904200.0
2016-11-30	AAMC-DELISTED	Stock	8.6324	8.7056	8.2647	8.4853	15830.0
2016-11-30	AAME	Stock	4.0	4.0	4.0	4.0	500.0
2016-11-30	AAMI	Stock	14.76	14.76	14.42	14.7	127100.0
2016-11-30	AAOI	Stock	25.18	25.624	24.64	24.77	285400.0
2016-11-30	AAON	Stock	22.2333	22.3333	21.7	21.9333	183450.0
2016-11-30	AAP	Stock	169.48	170.67	168.41	169.72	827500.0
2016-11-30	AAT	Stock	40.29	40.51	39.81	40.06	204900.0
2016-11-30	AAU-DELISTED	Stock	1.11	1.11	1.065	1.08	134271.0
2016-11-30	AAUAF-DELISTED	Stock	1.11	1.11	1.065	1.08	135209.0
2016-11-30	AAV-DELISTED	Stock	7.4	7.55	7.1	7.25	355516.0
2016-11-30	AAWW-DELISTED	Stock	50.35	50.35	49.2	49.45	160301.0
2016-11-30	AAXJ	Stock	57.2	57.26	57.02	57.08	823625.0
2016-11-30	AAXN-DELISTED	Stock	27.59	27.9604	27.13	27.23	443059.0
2016-11-30	AB	Stock	22.75	23.1	22.3	22.6	353700.0
2016-11-30	ABAC-DELISTED	Stock	3.27	3.27	3.11	3.11	5995.0
2016-11-30	ABAX-DELISTED	Stock	52.09	52.09	50.63	51.56	186674.0
2016-11-30	ABB-DELISTED	Stock	20.41	20.485	20.34	20.43	3065610.0
2016-11-30	ABBNY-DELISTED	Stock	20.41	20.485	20.34	20.43	3131525.0
2016-11-30	ABBV	Stock	61.63	61.84	60.63	60.8	9025200.0
2016-11-30	ABC-DELISTED	Stock	77.72	78.92	77.45	78.01	4781411.0
2016-11-30	ABCB	Stock	44.9	45.3	44.53	44.85	119400.0
2016-11-30	ABCD-DELISTED	Stock	5.0	5.13	4.97	4.98	30341.0
2016-11-30	ABCO-DELISTED	Stock	37.0	37.35	35.025	35.35	792695.0
2016-11-30	ABDC-DELISTED	Stock	12.13	12.57	11.6	11.69	58112.0
2016-11-30	ABE-DELISTED	Stock	11.33	11.3699	11.26	11.35	41081.0
2016-11-30	ABEO	Stock	165.0	169.5	148.75	156.25	16344.0
2016-11-30	ABEOW-DELISTED	Stock	3.25	3.25	2.9	3.08	19332.0
2016-11-30	ABEV	Stock	5.15	5.16	4.99	4.99	30008000.0
2016-11-30	ABG	Stock	58.6	59.15	58.2	58.75	235200.0
2016-11-30	ABIL-DELISTED	Stock	3.6	3.6	3.44	3.48	28200.0
2016-11-30	ABM	Stock	44.71	45.03	43.99	44.0	328500.0
2016-11-30	ABMD-DELISTED	Stock	112.67	112.95	110.01	112.24	383995.0

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

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